Rosters to Excel for Mac
To download a Roster
- Go to www.cerritos.edu
- Click on Faculty & Staff
- Click on Rosters+ Login
- Login using your Windows network login
- Click on Rosters+ Login
- Select your course and click “Get Roster”
- Click Download Roster
- Click Download as a Text File
- Choose File > Save As
- Name the file and save it to your desktop
- Launch Excel
- In Excel, choose File > Open and navigate to the text file on your desktop
- The Text Import Wizard will come up
8. Select Fixed width and click Next
9. Click in the number line to create or move break lines. Create two break lines, one before the students’ names and one before the email addresses
10. Click Next and Finish
11. The roster will open in Excel. The student number, student name, and email address will be in separate columns. Format the Excel document to your liking.
Grade Templates
Click Save when the File Download dialog appears
Copy student names and numbers from the attendance sheet, paste into one of the templates
below.
Rosters + Grade Template Download Instructions to Grade Template Download
Excel Templates from the Microsoft Office Web site for Windows
Grade book (based on points)
Grade book (based on percentages)
Grade book (based on averages)
Stay Connected