Canvas allows you to download a final grade file that you can modify and upload to Wolverine Access. This page describes the standard process used at U-M. Your department or school may have a different grade policy.
1. Apply a grading scheme in Canvas
By default, Canvas displays grades as % or points. To calculate final grades as letters (or another acceptable grade format) you must first apply either a currently-defined grading scheme or a grading scheme you created or modified.
You can apply a grading scheme at any point, including before the course is published or while you are calculating final grades. Please note that you cannot edit the default grading scheme.
When the course grading scheme has been set, you will see the letter grade in the "Total" column of the Gradebook along with the % or points.
Students also can see their final letter grade.
- Enable a currently-defined grading scheme
Units interested in defining a new grading scheme for UM-wide use should contact the ITS Service Center.
- Create or modify a grading scheme of your own
If you are creating your own grading scheme, ensure the final grades are valid grades at U-M. Once you create a grading scheme, you can select it for any course you teach.
2. Download the CSV grade file from Canvas
3. Modify the CSV file for uploading
A. Open the file in Excel or another spreadsheet application.
B. Check to make sure the "Current Grades" column and "Final Grades" column are the same. If these are different, it's an indication that there were blank squares when you downloaded the .csv.
C. Delete all columns except:
- one of the following: "SIS User ID" (an 8-digit number) or "SIS Login ID" (uniqname)
- The "Final Grade" column (the last column with entries)
D. Delete the first several rows (the rows with header information).
E. Save your spreadsheet.