SAS Faculty Resources: Banner Cheat Sheet

Class Rosters and Data

Class Rosters

You have three options to choose:

• ROSTER: to run and print a roster;
• ROSTDOWN: to run a roster and download into excel;
• ROSTEMAIL: provides a class list of email addresses, and no other data;

1. In Banner, type in ROSTER and enter
2. Control Page Down twice (do not enter in a printer)
3. The only information that you need to enter in the Parameter Values is:
   • Line 3: Term (required field)
   • Line 5: Course reference number (required field)
   • Line 9: “print addresses?” if you change the N to Y, it will give you the students’ addresses, telephone number and email address.
   • Line 10: “print waitlist?” if you change the N to Y, it will include an alphabetical list of your waitlisted students (if any exist on your roster).
4. Control Page Down once and press F10 to save/process.
5. The class roster should show up in your email, which you can then print if needed.

ALLCRSEDETL: A report which lists all courses in a given quarter with detail codes

SFAALST: To view a class roster

1. Enter Term
2. Enter Course Reference Number (CRN)
3. Control + Page Down

SSASECT: To view class information

1. Enter Term
2. Enter CRN
   • To search for a CRN, press F9 and then enter subject name and course number
   • Press F8 to search and press Shift + F3 to select
3. Press Control + Page down
4. The first screen shows credits, title, grading mode, schedule type, special restrictions
5. Choose Options Menu for instructor, enrollment, registration restrictions, time and room assignment, fees or special tuition, crosslisted sections, pre-requisites

SLARDEF: To view a classroom size

1. Enter classroom code (query if you don’t know it)
2. Enter classroom number
3. Enter quarter designation
4. Control + page down for information

SGASADD: To view a cohort

1. 1. Enter student identification number
2. 2. Enter specific quarter designation
3. 3. Control + Page Down once