Banner Class Lists

This document will provide you with step-by-step instructions for downloading class lists from Banner Telstar-Web to a Microsoft Excel spreadsheet.

Converting Banner Data to Excel Format
Login to Telstar
View Telstar/Banner Home Page
Selecting a Class Roster
Creating Class Roster
Loading Class Roster in Excel
Saving as Excel

Since the data structures in Banner are not directly compatible with Excel, a process has been developed to convert them.  The class list created from Banner is initially loaded into Excel as a "CSV (Comma Deliminated)" file.  This is not the standard Excel format (filename.xls), but can be understood by the program.  Once you have configured your spreadsheet, it is very important to save it as a standard Excel file.

• Before using this process, you will need to access the Banner Telstar-Web with a login and password.  If you do not have access:

1. Your supervisor must submit a request to ITS at telstarreq(at)umd.umich.edu.  The email request must include: your name, social security number, uniqname, email address, campus address and telephone number.
2. ITS will then send your supervisor the necessary paperwork for signature.
3. Once the signed forms are returned to ITS, an ID and password will be assigned.

• The machine you are working from will need to have a web browser (such as Netscape or Internet Explorer), and it must have MS Excel loaded

• Open up your web browser .
• Go to http://www.its.umd.umich.edu/telstar.

(Note: Since this is a secured web site, there is an "s" after http).
• You will be prompted to enter your User Name and Password. (Type in your uniqname and your Dearborn password.)
• Click the Login button

• The Telstar/Banner Home Page will be displayed.
• Select Class Rosters in the right column.

• The Class Roster screen will appear, and prompt you to enter the Term code and Course CRN number.
• Information about Term codes is available from the Telstar/Banner Home Page (above), by selecting Academic Year Codes from the left column.
• Course CRN numbers are available in the on-line catalog at https://web-sis.umd.umich.edu/.}
• After typing in the Term and CRN, click the Submit button.
• A dialog box will appear with a message that the report you are retrieving contains confidential information that cannot be distributed.  Click OK.

• The class roster you have requested will be displayed with a list of students (not shown here).
• Click the Save to File button.

• When the following dialog box appears, click on Save File. . .
• Another dialog box will appear, asking where you want to save the Class Roster file.
• Type in a file name that makes sense and will be easy for you to identify (such as class name/section).
• Select a location (such as the Desktop) or folder where you want to save the file, and then click the Save button.
• The file will automatically be saved in a format supported by Excel (CSV Comma Deliminated).

NOTE:  You will need to save it later in the standard Excel format (.xls).

• Go to the file location and open it.  The Excel program will automatically begin, and the file will be loaded.
• You can now add or delete columns/rows and format the appearance.

• When you have finished setting up your spreadsheet, you must SAVE IT AS A STANDARD EXCEL FILE.
• On the menu bar at the top of the screen, select File and then Save As....
• A dialog box will appear, asking where you want to save the file.  Select the folder or location where you want it saved.
• Next to Save as type: select the Microsoft Excel Workbook format that corresponds to the version loaded on your computer.
• Click on the Save button.