Canvas - Export Gradebook for Web Grading

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).

Layout:
one column
two columns

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

Navigate to the Grades Tool within your Canvas course.

Step

Open the Actions menu and select Export.

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

In order to create seperate spreadsheets for each of your courses sections, click on the Data tab then click Filter.

Step

Locate the Section column and click the dropdown menu arrow in the column header cell.

Step

When the dialogue box appears for the Section column, choose a single section from the list. Click Select All to expand the full list, then select the check box left of the appropriate section.

Step

Once you have selected one section, click back to your spreadsheet, select all, then copy the selection. You will only be copying the rows from the section you selected.

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

The Test Student in your course is included in the gradebook file. It will appear as Student, Test at the bottom of the list of students. Once you find the Test Student, select it's row, right click, and Delete.

Step

Your gradebook export has many columns. The only two that you will need are the SIS User ID and Final Grade.

To delete the columns you don’t need, right click on the column and select Delete from the menu that appears. Repeat this step for each of the extra columns.

Step

After deleting extra columns, select the first two rows of the spreadsheet (above the actual student ID numbers and final grades). Right click on the selected rows and Delete.

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.