Click on a link below to take you to the corresponding walkthrough.

All links open in new tabs.


  1. How do I use the Gradebook?
  2. How do I view assignments or students individually in the Gradebook?
  3. How do I use the icons and colors in the Gradebook?
  4. How do I view assignment details in the Gradebook?
  5. How do I hide student names in the Gradebook?
  6. How do I enter and edit grades in the Gradebook?
  7. How do I excuse an assignment for a student in the Gradebook?
  8. How do I leave comments for students in the Gradebook?
  9. How do I send a message to my students from the Gradebook?
  10. How do I curve grades in the Gradebook?
  11. How do I mute or unmute an assignment in the Gradebook?
  12. How do I view a student's Grades page in a course?
  13. How do I view a student's submission details page in a course?
  14. How do I download grades from the Gradebook?
  15. How do I upload changes to the Gradebook?

Grading Schemes:

  1. How do I use grading schemes in a course?
  2. How do I view grading schemes in a course?

For additional tutorials on Grades, select this link

Click one of the following links for more information.  

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.

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.

Screenshot of the Grades tool.

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.

Screenshot of the Export button.

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.

Screenshot of the Grades tool.

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.

Screenshot of cell with dashes and a muted 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.

Screenshot of the course title.

Screenshot of the Settings tool.

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.

Screenshot of the view grading scheme button.

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.

Screenshot of the pencil icon.

Step 6

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

Screenshot of creating a grading scheme.

Step 7

Select Done to close the window.

Screenshot of the Done button.

Step 8

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

Screenshot of 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.

Screenshot of the Faculty Menu link.

Step 10

Select the Final Grades option.

Screenshot of the Final Grades option.

Step 11

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

Screenshot of selecting the semester.

Step 12

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

Screenshot of selecting the course.

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.

Screenshot of the grades in Banner and the Submit button.


SUU Online Teaching & Learning
(435) 865-8555


Related Articles: