Grades

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.

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.

Step 3

Open 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.

Step 5

Type the title of the new assignment in cell G1.

Step 6

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

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.

Step 8

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

Step 9

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

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.

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.

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.

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.

Step 14

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

Step 1

Open the course from which you want to print grades and then select the Grades tool in the navigation pane on the left.

Step 2

Select Export in the top right corner. If you navigate away from the page during the export, the CSV file will appear as a previous download in the Gradebook export drop-down menu so it can be downloaded again.

Your grade book will download as an Excel spreadsheet, and so you will be able to print it like you would regularly print an Excel spreadsheet.

Before sending your grades, you will need to check three things: the grading scheme, muted assignments, and ungraded assignments (dashes) in the gradebook.

Sending your grades to Banner will not actually submit your grades. You must go to Banner and hit Submit.

Step 1

Log in to Canvas and open the course for which you want to publish grades. Next, select the Grades tool in the pane on the left.

Step 2

Scroll through the entire gradebook and look for any cells with dashes in them. Before you send the grades, all of the dashes must be replaced with a score: either a zero or some other value. If you skip this step, your students' grades will be different in Banner than they are in Canvas.

Look for muted assignments. Muted assignments have the potential to make Canvas grades inconsistent with Banner grades, so we recommend either unmuting the assignment before sending grades to Banner or deleting the assignment.

Step 3

Once all of the dashes have been replaced and the muted assignments are taken care of, select the menu button in the top left corner and then select the Settings tool at the bottom of the pane on the left.

Step 4

Scroll down to the Grading Scheme option. Make sure the box next to Enable course grading scheme is checked. Then select view grading scheme to make sure the grading scheme matches the actual grading scheme for your course.

Step 5

Review the values in the existing grading scheme. If they match your grading scheme, close the window and proceed to step 8. If the grading scheme does not match, select the pencil icon in the top right corner.

Step 6

Name the scheme and adjust the ranges to the correct values. Then select Save.

Step 7

Select Done to close the window.

Step 8

Scroll to the top of the page and select the Grade Publishing tab. Select the Publish grades to SIS button.

Step 9

Navigate to your portal and select the Faculty Menu link on the left side of the page.

Step 10

Select the Final Grades option.

Step 11

Use the dropdown menu to select the semester and then select Submit.

Step 12

Select the drop-down menu to select the course. Then select Submit.

Step 13

If any of your students have an F or Incomplete (I), type the last date of attendance into the field on the left. Review the rest of your students' grades and then select Submit.