This tutorial will show you how to change scores for an already existing assignment and then upload the changes into Canvas.
The first steps will show you how to download the current Canvas grade book as a .csv file. Doing so allows you to use the file as a template, which is much easier and less likely to contain errors than creating your own .csv file.
Open the grade book for the class in which you want to upload grades and then select Export.
A drop-down menu will appear. If you navigated away from a previous export before now, you will see the option to download that version of the grade book. Otherwise, you will just see the Current option. Select the appropriate option to download the grade book.
Open the spreadsheet.
Scroll through the assignments (titles are listed in row 1) until you find the assignment that needs to be changed. Double click the line between two columns to expand the column to show all of the content. Do NOT change the title of the assignment. If you wish to change the title, do it in Canvas after you have finished uploading the scores.
Delete column G (or the first assignment) and everything to the right of it except the column you are going to change. Delete the entire column by right-selecting the column and selecting Delete. The goal is to move the assignments you are changing right next to column F. Empty columns between column F and the assignments you are changing adds extra steps to the import process. Deleting this data now will not delete data in Canvas when you upload the file.
Delete the incorrect scores and then type or paste the correct scores into the cell that corresponds with the student.
Save the spreadsheet. You will see a window that asks if you want to keep using this format. Select Yes.
Go back to the grade book for the course in which you are uploading scores. Select Import.
Select Browse. (You don't need to worry about selecting What should the CSV file look like? because you used the spreadsheet you downloaded from Canvas as a template.) Open the .csv file and then select Upload Data.
You will see a list of your students with their original scores and the new scores. Verify that they are correct. If a score is incorrect, select the number in the column on the right and type in the correct score. Hit enter after each score you change to save the new score. Next select Save Changes.
The following window informs you that the upload may take a few minutes if you have a large file, but the upload will continue even if you navigate away from the page. Select OK.
You will be taken back to the grade book. Verify that the assignment and scores were uploaded correctly. You may now edit the name of the assignment if you wish.
Information compiled by SUU Online™ © 2016