Before getting started
- The Registrar’s Web Grading system requires the use of letter grades. The default Grading Scheme in Canvas includes letter grades. Before exporting your final grades, review the default Grading Scheme. If you would prefer to use a different grading scheme, the How do I add a grading scheme page will show you how.
- Double check that ungraded items are treated as you prefer. The Ungraded Items tutorial will show you how.
- Review your gradebook to ensure all grades have been properly entered and that final grades are calculating the way you want them to. You can pick a student and use pen, paper, and a calculator to work out their final grade by hand based on their scores. Alternatively, you can enter scores using the Test Student in your course (see the How do I view the course as a test student tutorial). If the grade you calculate differs from the grade in Canvas, double check the settings of your grade items and categories to ensure Canvas is calculating the grade the way you intend.
Step
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.
Step
Step
Step
Step
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.
Step
Step
Step
Step
Click File > Save As.
- If using a PC, save your grade book in the comma delimited CSV format.
- If using a Mac, save your grade book in the Comma Separated Values (.csv) or MS-DOS Comma Separated (.csv) format.
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.
Step
Repeat steps 10 - 13 for all of the section workbooks you created before completing the uploading process.
Step
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 registrar@colorado.edu or 303-492-6970.