Overview

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.

Step 1

Open the grade book for the class in which you want to upload grades and then select Export.

Screenshot of the Download Scores button.

Step 2

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.

Screenshot of the Export options.

Step 3

Open the spreadsheet.

Screenshot of the spreadsheet.

Step 4

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.

Screenshot of deleting cells.

Step 5

Type the title of the new assignment in cell G1.

Screenshot of naming the assignment.

Step 6

Type the total number of points possible in in cell G3 (in the Points Possible row).

Screenshot of adding the points possible.

Step 7

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.

Screenshot of selecting the line between columns.

Step 8

Save the spreadsheet. You will see a window that asks if you want to keep using this format. Select Yes.

Screenshot of the Yes button.

Step 9

Go back to the grade book for the course in which you are uploading scores. Select Import.

Screenshot of the Upload Scores button.

Step 10

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.

Screenshot of the Browse button.

Step 11

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.

Screenshot of adding the assignment.

Step 12

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.

Screenshot of the Save Changes button.

Step 13

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.

Screenshot of the OK button.

Step 14

You will be taken back to the grade book. Verify that the assignment and scores were uploaded correctly.

Screenshot of the gradebook column.

Information compiled by SUU Online™ © 2016

Was this helpful? 0 out of 1 found this helpful

Related Articles:


Have more questions?