|
|
Banner Course Information Reports |
|
Quicknote #36A |
October 2007 |
|
Introduction:This Quicknote is intended to supplement Quicknote 36 in assisting UM-Flint Banner Users with Course Information reports in the ssem2000 database. Course Information reports focus on enrollment data for specific course sections. Please refer to Quicknote 36 for instructions on opening the ssem2000 database and information about other types of reports contained in it. |
Table of Contents |
Course Information:
|
After opening the ssem2000 database, double-click on the Course Information form in the database window. **Note: All options on the Course Information form require the user to select a term from the drop-down list provided. You may be prompted to login using your Banner ID and password before the term list will display. Do not attempt to type a term code or to click on any report button prior to selecting a term from the list provided; otherwise, the form will not work properly and must be reset by clicking the Close Form button. |
|
|
The following reports are available in the Course Information form. |
|
Course Rosters
Several course roster reports containing different data are available to view or save. Viewing a report displays the output on your screen, and you may then choose to print it. Saving a report to a file sends the output directly to a file on your hard drive, and you must then locate and open the file in another program, such as Excel, for viewing or editing.
|
1. Click the Course Rosters button located in the Course Information form. 2. You will be notified that the report data is current as of the moment it is run. Click OK. 3. Use the drop-down menu at the top of the form to select a term. 4. Click on the button for the appropriate type of roster (see below for descriptions and further instructions regarding each roster option). |
|
Summary Rosters
Summary rosters provide an alphabetized list of registered students and take the least amount of time to run. The user must provide the subject code, course number and section number for the desired roster; only one course may be requested at a time. The output includes instructor, term, CRN, subject, course number, section number, course title, student name, student ID, credit hours, registration date and e-mail address. Users may view summary rosters or save them to a file on their local hard drive. To run the report:
1. Click on View Summary Roster to view the report on your screen with the option of printing, or click on Save Summary Roster to File to save the report to a file.
¨ If you choose to Save Summary Roster to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter a subject code (upper-case, e.g.: ENG) and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Detailed Rosters
Detailed rosters differ from summary rosters in that they include students with any registration status (such as dropped or waitlisted) along with their address and phone number. The user must provide the subject code, course number and section number for the desired roster; only one course may be requested at a time. Output is sorted by registration status and then by name and includes instructor, term, CRN, subject, course number, section number, course title, student name, student ID, registration status, credit hours, registration date, address, phone number and e-mail address. Users may view detailed rosters or save them to a file on their local hard drive. Viewed rosters feature a legend of registration status codes, while saved rosters do not. To run the report:
1. Click on View Detailed Roster to view the report on your screen, or click on Save Detailed Roster to File to save the report to a file.
¨ If you choose to Save Detailed Roster to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter a subject code (upper-case, e.g.: ENG) and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. The report will then begin to run. If you chose to view the report it, will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Department Rosters
Department rosters will produce individual rosters for all courses in the specified department. Like the summary roster, department rosters include registered students only and are sorted by course number, section number, and name. Output includes instructor, CRN, subject, course number, section number, course title, student name, student ID, credit hours, and registration date. Users may view department rosters or save them to a file on their local hard drive. To run the report:
1. Click on View Department Roster to view the report on your screen, or click on Save Dept. Roster to File to save the report to a file.
¨ If you choose to Save Dept. Roster to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter a department code (upper-case, e.g.: ENG) and click OK.
3. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Crosslist Group Number
All crosslisted roster reports require the user to enter a Crosslist Group Number. Follow the steps below to look up the crosslist group number.
1. Click on Find Crosslisted Group Number.
2. When prompted, enter the subject code (upper-case, e.g.: ENG) for one listing of the course and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. A separate window will display the course information. **Note: The crosslist group number and proceed with instructions for Summary Crosslisted Rosters or Detailed Crosslisted Rosters.
Summary Crosslisted Rosters
Summary crosslisted rosters provide an alphabetized list of students registered in any course sections crosslisted with the same group reference number. Output includes the CRNs and subject codes for all crosslisted sections, as well as instructor and course title. Additional output lists the student name, student ID, registered listing (subject, course and section number), credit hours, registration date and e-mail address. Users may either view the report on the screen or save it to a file on their local hard drive. To run the report:
1. Click on View Crosslisted Roster to view the report on your screen, or click on Save Crosslisted Roster to File to save the report to a file.
¨ If you choose to Save Crosslisted Roster to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter the Crosslist Group Number (e.g.: 60) and click OK.
3. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Detailed Crosslisted Rosters
Detailed crosslisted rosters differ from summary crosslisted rosters in that they include students with any registration status (such as dropped or waitlisted) along with their address and phone number. Output is sorted by registration status and then by name and includes the crosslist group number, course title, instructor, student ID, student name, registered listing (CRN, subject, course and section number), credit hours, registration date, registration status code, address, phone number and e-mail address. Detailed Crosslisted rosters may not be viewed on the screen; they must be saved to a file on the user's local hard drive. To run the report:
1. Click on Save Detailed Crosslisted Roster to File.
2. When prompted, select an output format. It is recommended that you select either Microsoft Excel or Rich Text Format (Microsoft Word). Click OK to continue.
3. When prompted, select a directory where the file will be located, and edit the file name if desired (by default, the file will be named New Crosslisted Roster Report). Click OK to continue.
4. When prompted, enter the Crosslist Group Number (e.g.: 60) and click OK.
5. The report will then begin to run and will be saved to the location you specified.
Waitlists
Several waitlist reports containing different data are available to view or save. Viewing a report displays the output on your screen, and you may then choose to print it. Saving a report to a file sends the output directly to a file on your hard drive, and you must then locate and open the file in another program, such as Excel, for viewing or editing.
|
1. Click the Waitlists button located in the Course Information form. 2. You will be notified that the report data is current as of the moment it is run. Click OK. 3. Use the drop-down menu at the top of the form to select a term. 4. Click on the button for the appropriate type of waitlist (see below for descriptions and further instructions regarding each waitlist option). |
|
Summary Waitlists
Summary waitlists are available for viewing/printing only and provide a list of waitlisted students, prioritized by date and time. The user must provide the subject code, course number and section number for the desired waitlist; only one course may be requested at a time. Output includes subject, course number, section number, CRN, waitlist position, student name, student ID, registration date and e-mail address. To run the report:
1. Click on View Summary Waitlist to view the report on your screen with the option of printing.
2. When prompted, enter a subject code (upper-case, e.g.: ENG) and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. The report will then begin to run and will be displayed on the screen when complete.
Detailed Waitlists
Detailed waitlists differ from summary waitlists in that they include students' earned credit hours along with their address and phone number. The user must provide the subject code, course number and section number for the desired waitlist; only one course may be requested at a time. Output includes subject, course number, section number, CRN, instructor, waitlist position, student ID, student name, address, phone number, registration date, earned hours and e-mail address. Users may view detailed waitlists or save them to a file on their local hard drive. To run the report:
1. Click on View Detailed Waitlist to view the report on your screen, or click on Save Detailed Waitlist to File to save the report to a file.
¨ If you choose to Save Detailed Waitlist to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter a subject code (upper-case, e.g.: ENG) and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Department Waitlists
Department waitlists will produce individual waitlists for all courses in the specified department. Output includes subject, course number, section number, CRN, instructor, waitlist position, student ID, student name, address, phone number, registration date, earned hours and e-mail address. Users may view department waitlists or save them to a file on their local hard drive. To run the report:
1. Click on View Department Waitlists to view the report on your screen, or click on Save Dept Waitlists to File to save the report to a file.
¨ If you choose to Save Dept Waitlists to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter a department code (upper-case, e.g.: ENG) and click OK.
3. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Term Waitlists
Term waitlists produce individual, prioritized waitlists for all courses in the selected term, sorted by subject, course and section number. Output includes subject, course number, section number, CRN, waitlist position, student ID, student name, address, phone number, registration date, and earned hours. Users may view term waitlists or save them to a file on their local hard drive. To run the report:
1. Click on View Term Waitlists to view the report on your screen, or click on Save Term Waitlists to File to save the report to a file.
¨ If you choose to Save Term Waitlists to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the Print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Crosslist Group Number
All crosslisted waitlist reports require the user to enter a Crosslist Group Number. Follow the steps below to look up the crosslist group number.
1. Click on Find Crosslisted Group Number.
2. When prompted, enter the subject code (upper-case, e.g.: ENG) for one listing of the course and click OK.
3. When prompted, enter the course number (e.g.: 112) and click OK.
4. When prompted, enter the 2-digit section number (e.g.: 01) and click OK.
5. A separate window will display the course information. Note: the crosslist group number and proceed with instructions for Summary Crosslisted Waitlists, Detailed Crosslisted Waitlists, or Term Crosslisted Waitlists.
Summary Crosslisted Waitlists
Summary Crosslisted waitlists are available for viewing/printing only and provide a combined list of students waitlisted in any sections crosslisted with the same group number, prioritized by date and time. Output includes the CRNs and subject codes for all crosslisted sections, followed by student name, student ID, waitlist position, registration date, registered listing (CRN, subject, course and section number), and e-mail address. To run the report:
1. Click on View Summary Crosslisted Waitlist.
2. When prompted, enter the Crosslist Group Number (e.g.: 60) and click OK.
3. The report will then begin to run and will be displayed on the screen when complete.
Detailed Crosslisted Waitlists
Detailed Crosslisted waitlists differ from summary crosslisted waitlists in that they include students' earned credit hours, address, and phone number. Output includes the CRNs and subject codes for all crosslisted sections, followed by waitlist position, student name, student ID, address, phone number, registration date, earned hours, registered listing (CRN, subject, course and section number) and e-mail address. Users may view detailed crosslisted waitlists or save them to a file on their local hard drive. To run the report:
1. Click on View a Detailed Crosslisted Waitlist to view the report on your screen, or click on Save Crosslisted Waitlist to File to save the report to a file.
¨ If you choose to Save Crosslisted Waitlist to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. When prompted, enter the Crosslist Group Number (e.g.: 60) and click OK.
3. The report will then begin to run. If you chose to view the report it, will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Term Crosslisted Waitlists
Term Crosslisted waitlists produce combined lists of students waitlisted in each group of crosslisted courses for the selected term. Output includes the CRNs and subject codes for all crosslisted sections, followed by waitlist position, student name, student ID, address, phone number, registration date, earned hours, and registered listing (CRN, subject, course and section number). Users may view term crosslisted waitlists or save them to a file on their local hard drive. To run the report:
1. Click on View All Crosslisted Waitlists for a Term to view the report on your screen, or click on Save All Crosslisted Waitlists for a Term to File to save the report to a file.
¨ If you choose to Save All Crosslisted Waitlists for a Term to File you will be prompted to select an output format. It is recommended that you select Microsoft Excel or Rich Text Format (Microsoft Word). You must also choose a location to save the file before you can continue.
2. The report will then begin to run. If you chose to view the report, it will be displayed on the screen and can be printed using the print icon on the toolbar. If you chose to create a file of the report, it will be saved to the location you specified.
Missing Grades
The Missing Grades report lists all students missing grades for courses in a given subject (department) and term, sorted by course, section, and name. The user must select a term and subject. Output includes CRN, subject, course number, section number, and student name. The report will be displayed on the screen and can be printed using the print icon on the toolbar. To run the report:
|
1. Click the Missing Grades button located in the Course
Information form 2. Use the drop-down menu at the top of the form to select a term. 3. Use the second drop-down menu to select a subject. 4. Click on View List. |
|
|
5. The report will then begin to run and will be displayed on the screen when complete. |
|
Grade Verification
The Grade Verification report allows users to view grade rosters for a single course or an entire department. Grade Verification reports are not available until grade processing has been completed by the Registrar's Office for the term. Grade Verification reports for crosslisted courses must be run separately for each subject. The user must select a term and subject for department rosters, and must also specify the course number and section number for a single course roster. Output includes subject, course number, section number, course title, CRN, instructor, student ID, student name, credit hours, grade, and date recorded. The report will be displayed on the screen and can be printed using the print icon on the toolbar. Space is provided on the printed report for the instructor to record individual student comments, if desired, and deliver it to the Registrar for filing. To run the report:
|
1. Click the Grade Verification button located in the Course
Information form 2. Use the drop-down menu at the top of the form to select a term. 3. Use the second drop-down menu to select a subject. |
|
|
4. To obtain rosters for all courses in the selected subject
(department), click on View Department Rosters and skip to
step 8. Otherwise, continue to step 5. 5. Enter the course number (e.g.: 112) in the Course Number field.
6. Enter the 2-digit section number (e.g.: 01) in the
Section Number field. 7. Click the View Single Course Roster button. |
|
|
8. The report will then begin to run and will be displayed on the screen when complete. |
|
Department Enrollment
The Department Enrollment Counts report will show enrollment counts for all courses for a given subject and term, sorted by course number and section number. The user must select a term and subject. Output includes CRN, subject, course number, section number, course status (cancelled, inactive, or active), enrollment counts (maximum allowed, current enrollment, seats available, and number waitlisted), crosslist group number, crosslisted enrollment counts (current enrollment and seats available for all sections combined), instructor, and meeting times, and room. The report will be displayed on the screen and can be printed using the print icon on the toolbar. To run the report:
|
1. Click the Department Enrollment button located in the Course Information form. 2. Use the drop-down menu at the top of the form to select a term. 3. Use the second drop-down menu to select a subject.
4. Click on View Counts. 5. The report will then begin to run and will be displayed on the screen when complete. |
|
Closed Classes
The Closed Classes report will show all courses in a given term for which enrollment is closed. These classes can still be waitlisted. The user must select a term. Output includes subject, course number, section number, CRN, enrollment counts (maximum allowed, current enrollment, seats available, and number waitlisted), crosslist indicator (yes or no), and course status (cancelled, inactive, or active). The report will be displayed on the screen and can be printed using the print icon on the toolbar. To run the report:
|
1. Click the Closed Classes button located in the Course Information form. 2. Use the drop-down menu at the top of the form to select a term.
3. Click on View Classes. 4. The report will then begin to run and will be displayed on the screen when complete. |
|
