Rosters to Excel for Mac

 

To download a Roster

  1. Go to www.cerritos.edu
  2. Click on Faculty & Staff
  3. Click on Rosters+ Login
  4. Login using your Windows network login
  5. Click on Rosters+ Login
  6. Select your course and click “Get Roster”
  7. Click Download Roster
  8. Click Download as a Text File
  9. Choose File > Save As
  10. Name the file and save it to your desktop
  11. Launch Excel
  12. In Excel, choose File > Open and navigate to the text file on your desktop
  13. The Text Import Wizard will come up

screen shot of text import wizard, step 1
8. Select Fixed width and click Next

screen shot of text import wizard, step 2

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)