Import CSV Document into the Gradebook - Canvas
( Canvas's directions on importing grades )
CSV Required Format
On Feb 15 Canvas is updating its grade book CSV importing procedures. So these directions should be used only after the 15th of Feb.
There are two formatting options that work. The one that has consistently worked for me is Option 1.The CSV document you need to upload into Canvas must have one of the formats below.
Option 1 (Use Student Names)
The following listed column headers are required.
Student (Required: Use First then Last Name with no separators)
ID (Values can be blank)
SIS User ID (Values can be blank)
SIS Login ID (Values can be blank)
Root Account (Values can be blank)
Section (Values can be blank)
Assignment Name (Values are Required)
Required Row - Points Possible
Example Below ( Download this CSV by Name Example )
Student | ID | SIS User ID | SIS Login ID | Root Account | Section | YOUR ASSIGNMENT TITLE HERE |
Points Possible |
|
|
|
|
| 10 |
Joe Smith |
|
|
|
|
| 2 |
Sam Jones |
|
|
|
|
| 3 |
Note on student names. If you get a CSV file from the testing center the students first and last name must be in the same cell. First name must appear first.
Option 2 (Use SIS Login ID)
The following listed column headers are required.
Student (Values can be blank)
ID (Values can be blank)
SIS User ID (Values can be blank)
SIS Login ID (Required must have OSH in front of the ID)
Root Account (Values can be blank)
Section (Values can be blank)
Assignment Name (Values are Required)
Required Row - Points Possible
Example Below ( Download this CSV file by SIS Login ID Example )
Student | ID | SIS User ID | SIS Login ID | Root Account | Section | YOUR ASSIGNMENT TITLE HERE |
Points Possible |
|
|
|
|
| 10 |
|
|
| OSH0XXXX01 |
|
| 2 |
|
|
| OSH0XXXX02 |
|
| 3 |
(ALTERNATIVE to the template links above)
You could download the grade book from your course first. This will give you the student names and Ids in one file;
Open your class in Canvas
Choose "Grades"
Select "Actions > Export"
Save to your desktop
Edit the CSV from the blank template
Add the name of your assignment in the header of the last column (should be unique to all your other assignments in Canvas )
If you have an existing spreadsheet (perhaps from the testing center) copy the required fields into the into the required columns (being careful to leave the "points possible" row blank)
Add in the total possible points for the assignment in the points row under the assignment header
Copy and paste the points the student received into rows below the possible points cell
Being careful to make sure your student IDs or Names line up with their scores copy and paste the SIS User ID column.
PLEASE double check to make sure the correct IDs line up with the correct scores
If necessary you may need to prepend " OSH0 " in front of each student ID if it's not already there (10 digits in total).
Upload the CSV
Go to "Grades"
Choose "Actions > Import"
Find the CSV on your computer
Choose the "Upload Data" button
You will be asked to choose the assignment. If its a new assignment that does not already appear in your grade book choose "New Assignment" if its an existing assignment in Canvas choose that assignment from the dropdown.
Choose "Continue"
Canvas will give you a preview including student names and the grade it will be assigning to them (please double check). If everything looks correct select the "Save Changes button. Please double check that the point and names all line up correctly!
You may need to give Canvas a few minutes to ingest the upload into the gradebook . After waiting click the refresh or reload button on your browser.