This tutorial will assist you with exporting a CSV file of your students’ final grades and prepare it for upload to the Registrar’s Web Grading System. If you would like a more automated process, you can use the Web Grading Sync tool (see the Canvas - Web Grading Sync tutorial for instructions).
Open the CSV file in Microsoft Excel.
*Please Note: You can only upload one section at a time to the Registrar’s Web Grading System. If your course has more than one section, all sections will be included on the same spreadsheet. In order to separate your sections into different workbooks, go to the next step. If your course only has one section, skip to step 10.
Select File > New to create a new workbook, then click the first cell in the new workbook and paste the content you copied.
Now you have a workbook for only one of your sections. Save the new workbook with the course and section number and repeat this process for as many sections as you have in your course before moving on.
Click File > Save As.
Give your file a short name (e.g. JOUR1001-100.csv), as Web Grading can occasionally produce an error message if a filename is too long. Be sure to save the file somewhere you can easily find it (such as your desktop). If you would like to save a copy of your students’ final grades for your records, encrypt your grade book.
Repeat steps 10 - 13 for all of the section workbooks you created before completing the uploading process.
Follow the instructions on the Faculty Grading website to upload your CSV(s) to the Registrar’s Web Grading system.
If you had previously hidden your student’s final grades in Canvas, be sure to unhide them so that students can see them. The Unhide Final Grades tutorial describes how.
For assistance with uploading and posting your students' final grades to the Registrar’s Web Grading System, visit the Faculty Grading website or contact the Registrar's Office at firstname.lastname@example.org or 303-492-6970.