Submit Final Grades Using Excel File Export

---

Note: The Registrar's Grade Submission System requires a letter grade. If you do not perform this step, you will receive an error message when you try to upload your gradebook .csv file because there won't be any letter grades in this file! 

 

Step 1: Access Course Settings

The Registrar's online grade reporting system only accepts letter grades. To activate letter grades, go to your course Settings page [1] and [2] the course details tab (if it doesn't automatically open to this tab.)

  

 

Step 2: Enable Course Grading Scheme

Select the check box next to Grading Scheme "Enable course grading scheme" and then click the blue "Update Course Details" button at the bottom right of the page [3].

  

Note: Canvas will show you the default grading scheme. If you want to select another grading scheme, click the Select Another Scheme Links to an external site. link. You can use the pencil icon to make any necessary edits.

 

Don't forget to click 'Update Course Details' to save your changes [4].

  

 

If you check your gradebook, you will see the final letter grades next to the percentages in the Total column.

  

 

Step 3: Download Scores .CSV

In your Gradebook, select the Export button in the upper left corner of the interface. You may have a choice between current or previous exported gradebooks, select accordingly.

  

 

In your downloads folder, or whatever default location your downloads are directed to, you should see your downloaded .csv file.

 

Step 4: Access Registrar's Submission Website

Log in to the Registrar's Grade Submission Website Links to an external site..

 

Step 5: Select Course Unique

You should be automatically taken to the grade submission page when you log in. If not, (1) click on the link in the left navigation bar. Then (2) select the unique number for the course for which you wish to upload your grade .csv file.

Note: If you have cross-listed several of your course uniques/sections, just select the primary course's unique number and submit your .csv file to for that unique. This will also submit student grades for all secondary/cross-listed course sections.

 

Step 6: Select .CSV File

Click the "choose file" button (1) and select .csv file from downloads folder. Then (2) click the upload button to upload the .csv file to the Registrar's site.

 

You will see a browser message asking you if you're saved your file as a comma-delimited text-file, click the OK button as your .csv file is already comma-delimited. 

 

 

After clicking the upload button, you will be able to monitor the progress of the upload (1) and when you see the "upload successful" message, (2) click on the course unique to confirm that grades have been properly uploaded.

You may see a status that reads "upload in progress, click to update," which you can click to update uploading progress.

 

Step 8: Review Grade Submission Results

Confirm that grades have been properly uploaded by spot checking several students throughout the course roster. (Student names & EIDs have been blurred here for protection of student data.)

If there are any discrepancies, you can manually change or enter grades in this interface.

Note: If you are importing a .csv file that contains a course with multiple sections, your students' grade information will include the unique number of the section for which they originally registered.  

 

 

Step 8: Submit Grades

Note: We recommend to all faculty to communicate with your TAs when you are reporting final grades. Otherwise, they may make adjustments to the Canvas gradebook that will not be reflected in the final grade reported to the Registrar's office.