How to Prepare your Canvas Gradebook for Final Submission
How do I prepare my Canvas gradebook for final submission?
Preparing the Canvas Gradebook for Final Grade Submission boils down to 4 things:
- 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"
- Unmute all muted assignments
- 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
- 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 0: Is a view feature only. It 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 Tool, click here.
To view the tutorial on how to submit final grades by importing an Excel spreadsheet, click here.