Your Canvas gradebook has a feature that allows you to both download your gradebook as a .csv file so you can work on it in a spreadsheet application like Excel, and then upload a .csv file with those scores back into your Canvas gradebook. You can access this feature from the gradebook options menu, which is the ‘gear’ symbol in the upper left corner of the Canvas gradebook. The options are listed as “Download Scores (.csv)” and “Upload Scores (from .csv).” You can read more detailed instructions for downloading your gradebook as a spreadsheet file at How do I download scores from the gradebook? Instructions for uploading a .csv file to your Canvas gradebook can be found at How to upload changes to the Gradebook?
Instructors can utilize this feature to take advantage of the capabilities of applications like Excel to more quickly and easily cut and paste grades, perform calculations using the features of a spreadsheet program, facilitate the process of importing grades or scores from other programs and sources, etc. It’s a good idea to start by downloading a .csv file of your Canvas gradebook and use that as your template to work in. Then when you upload that .csv file back into your Canvas gradebook it will contain the information it needs to synch the file and the gradebook together.
You can watch Downloading Grades and Uploading Scores in Canvas for a video demonstration of a simple download and upload of scores. The CTL Tip of the Week is brought to you by the William G. Jackson Center for Teaching and Learning (CTL). For more general information or help with Canvas at Michigan Tech, be sure to visit Canvas One Stop.