This tutorial will show you how to create a new assignment in a spreadsheet, add scores, and then upload the assignment and scores into the Canvas grade book.
You will first need 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.
Delete all of the information to the right of the Section column (column F). Make sure you scroll all the way to the right to make sure you deleted all of it. Don't worry: these assignments you just deleted in the spreadsheet will still be in the grade book when you reupload this spreadsheet into Canvas. Deleting them now just simplifies the process of adding assignments and scores.
Type the title of the new assignment in cell G1.
Type the total number of points possible in in cell G3 (in the Points Possible row).
Type or paste the scores your students earned into column G starting at row 4. Make sure your students' names line up with their names. Double click the line between columns A and B to see your students' whole names.
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.
Use the drop-down menu to select A new assignment. This step tells Canvas what to do with the information you just uploaded. Make sure the Points Possible is correct and then select Continue.
You will see a list of your students and the scores they earned. Verify that they are correct. If a score is incorrect, select the number in the column on the right, type in the correct score, and then hit Enter. Hitting Enter after each score you edit is important because if you don't, the change will not be saved in the grade book. Then 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.
Information compiled by SUU Online™ © 2016