Uploading Grades with a CSV File

Owned by Former user (Deleted)
Last updated: Mar 30, 2023 by Jordan Vinikoor
4 min read

Formatting your CSV File

File Upload Specifications

  • For PC users, the file must be in CSV (Comma delimited) format. For Mac users, the file must be in Excel's CSV (Windows) "Save as..." format.

  • It must consist of four columns in this order: Term, Class Number, ID (Student ID or NetID), and Grade.

  • Column header names can vary but must contain the required data.

  • Grades must be in letter grade format and capitalized. 

File Upload Specifications - Additional Tips

  • The Term and Class Number columns require data in the first row only.

  • Your Class Number can be found on your Faculty Center Class Roster or Grade Roster page in the Student Administration System. 

    Class Number

  • If you are submitting a batch upload with multiple sections, you should list the lecture class number. You do not need to know which graded class number is associated with each student.

  • The Term Codes are as shown in the image below:

  • The ID can be either a student's NetID OR the 7-digit Student Administration System ID.

  • Additional columns may be present, such as Name, as long as they appear to the right of the required four columns and do not contain any commas in the column headers or rows.

  • You can save the file with a name of your choosing; there is no naming convention.

Uploading Grades with a CSV File

  1. Log in to the Student Administration System.

  2. Click the NavBar icon in the top right-hand corner.

  3. Click the Navigator button from the menu. 

  4. Click the Self Service tab. 

  5. Click the Faculty Center tab. 

  6. Click the My Schedule tab. 

  7. The My Schedule page will then display. 

    1. Confirm the Term before proceeding. If the term needs to be changed, click the Change Term button to select the appropriate term. 

      • If you are entering grades for sections individually, Select the Grade Roster icon displayed in Step 8. 

      • If you are entering grades for multiple sections in a batch, Select UPLOAD GRADES button on the My Schedule Page and proceed to Step 12. 

  8. Select the Grade Roster icon to the left of the class for which you want to upload grades. 

  9. The Grade Roster will display within the browser.

  10. Navigate to the Grade Roster Action section.

  11. Click Upload Grades. 

  12. Click Browse to locate the file you just created, and select it.

  13. Click Open. 

  14. Click Upload. 

  15. The file will then be processed. If errors display, you should review the errors and:

    1. Correct and upload the CSV file (overlaying previous grades, or

    2. Click Return and correct the grades(s) in the Grade Roster itself. For more information on how to record final grades, see Recording Final Grades. 

  16. If no errors are present, the Grade Roster page displays. Verify that all of the uploaded grades are correct.

  17. Click Save at the bottom.

  18. After all the grades have been populated and saved, change the Approval Status at the top of the page to Approved on each roster.

  19. A confirmation screen will display. Click OK.

Uploading Grades with a CSV File - Additional Tips 

  • Grade rosters can be updated as many times as desired as long as the Approval Status is Not Reviewed. However, once the Approval Status has been changed to either Ready for Review or Approved the Upload button will no longer appear.

  • Midterm rosters do not need to be approved.

Related Articles