Importing Grades Using a Spreadsheet
Sometimes grades are collected using another source such as i>clicker, scantron tests, and publisher websites. Or you may just prefer to organize your grades on a spreadsheet. Here is a brief overview of how to handle the import and export of spreadsheets in Canvas:
- Create a spreadsheet table in Excel (or another program) that meets the layout format Canvas expects (see below for details)
- Save the spreadsheet file as a .csv file
- Go to the gradebook in Canvas, select the “Options” menu, and choose “Upload Scores (.csv)”. Follow the steps from there.
There are currently 5 required columns that must be in your CSV file. They all must contain the following headers, which are case sensitive, but most columns can be left empty:
- Student: The student’s Last Name ,First Name. For example, Blue, Big
You need at least one letter from each student’s name in this column, but for best results have the student’s full Last Name, First Name
- ID: The student’s internal Canvas ID. You can leave this column blank.
- SIS User ID: The student’s sourcedid.id from Banner. You can leave this column blank.
- SIS Login ID: The student’s A number. You can match by this as long as you have at least part of each student’s name in the student column.
- Section: You can leave this blank.
Demo: Headers and Upload Process
For an overview of these headers, as well as a demonstation of a CSV upload, see http://screencast.com/t/Cc1yIv86
Demo: Sharing Spreadsheet Data Between Systems
- Preparing spreadsheet data from other systems for import into Canvas:
This typically involves combining a last name and first name column into a single “Student” column using Excel’s concatenate function, and then adding Canvas’s additional required columns and renaming the A number column to SIS Login ID.|
- Preparing a Canvas gradebook CSV file for import into other systems:
This process typically involves removing or renaming Canvas-specific columns and splitting the Student column into two columns, one for last name and one for first name, using Excel’s text-to-columns tool.
Perhaps the easiest way to get the format right is to start by first downloading your gradebook as a CSV file. Go to your gradebook and select Download Scores (.csv) from the options menu. Simply edit that file and reupload it.
You can learn more about grading in Canvas, including how to curve grades, use the speed grader, comment on grades, and much more at http://guides.instructure.com. Go to the Instructors and TA’s section and scroll down to Grades.