This site requires JavaScript to be enabled
Welcome Guest|
Recent searches

How to Prepare your Canvas Gradebook for Final Submission

Number of views : 37
Article Number : KB0016844
Published on : 2019-07-16
Last modified : 2019-07-16 13:02:30
Knowledge Base : Canvas Knowledge Base


How do I prepare my Canvas gradebook for final submission?



Preparing the Canvas Gradebook for Final Grade Submission boils down to 4 things:

  1. Replace dashes with a numeric score, even if that numeric score is a 0
    • If needed, you can "excuse" an assignment for a student by typing "EX"
  2. Unmute all muted assignments
  3. Remove any assignments that you're not using this semester
    • Unpublish assignments without student submissions, or
    • Exclude an assignment from the course's final grades
  4. Activate Final Letter Grade in Total Column



Step 1 - Converting All Ungraded Assignments to a 0 (or some other score): 

  • When submitting your grades from Canvas, all ungraded items (dashes) will automatically be counted as zeros, this could change the exported totals from what you see in your Canvas Gradebook.

    It's recommended that you enter zeros for students who do not turn in their work throughout the semester. That way, the running total for their final grade is accurate throughout the semester and students do not develop an unrealistic expectation about their final grade. 

    Treat Ungraded as 0Is a view feature onlyIt does not actually convert ungraded assignments (dashes) to zeros. 

    To actually change ungraded assignments (dashes) to 0s, you will need to do the following:

    • Click on the drop-down menu on an assignment and select Set Default Grade.
    • Enter 0 in the set default grade and click Set Default Grade.

  • Excuse an Assignment for a Student: As needed, you can use the Gradebook to excuse a student from a graded assignment, discussion, or quiz. You can also excuse a student from a group assignment. Excused assignments are not calculated as part of a student's total grade. To do this, open the gradebook and select the assignment you want to excuse. Within the cell for that student, type EX and press enter. The assignment is now excused.

Step 2 - Unmute All Muted Assignments

Please make sure you unmute ALL muted grades and change all ungraded assignments to a numeric score:

  • Click on the drop-down menu for the grade column you want to unmute and select Unmute assignment from that menu.

Step 3 - Removing Assignments You Are Not Using

You can either unpublish, delete or exclude any assignment you are not going to use and/or do not want to contribute toward final grade calculation.

  • To unpublish, open the Assignments page in your course and click on the green circle with a checkmark. The circle will turn gray with a slash.  Now it is unpublished and removed from gradebook calculations. Note: you will not be able to unpublish assignments with student submissions.
  • To delete the assignment, click on the gear icon next to the circle and select "Delete." Note: this will delete any student submissions and feedback you have added.
  • To exclude an assignment from the course's final grades, "Edit" the assignment details. Click the Do not count this assignment toward the final grade checkbox below "Display Grade as" to remove points from final gradebook calculations. Note: this feature allows you to provide feedback without the assignment counting toward Gradebook calculations. Like other checkboxes, it can be toggled on and off. 

Step 4 - Activate Final Letter Grade in Total Column:

The Registrar's online grade reporting system only accepts letter grades. We have loaded the University's standard grade scheme; however, if you would like to edit the grade scheme for your course, please check out this tutorial.

  • To activate letter grades, go to the course Settings page within your course and select the course details tab (if it doesn't automatically open to this tab.)

  • Select the check box next to Grading Scheme "Enable course grading scheme" and then click the blue "Update Course Details" button at the bottom right of the page.

  • If you check your gradebook, you will see the final letter grades next to the percentages in the Total column.


For more information on the gradebook, and more robust photo tutorials, please visit HERE.

To view the tutorial on how to submit final grades using the Registrar's Toolclick here.

To view the tutorial on how to submit final grades by importing an Excel spreadsheet, click here.








Thank You! Your feedback has been submitted.