Canvas - Faculty Center Grade Prep Tool (UW-Madison)
This document provides instructions on how to transfer grades from Canvas to faculty center.
To transfer grades from Canvas to Faculty Center, go through the following processes below.
- Step 1: Enable Grading Scheme in Canvas
- Step 2: Verify Students’ Final Grades in Canvas
- Step 3: Faculty Center Export
- Step 4: Faculty Center Grade Prep Tool (in Canvas)
- Step 5: Faculty Center Import
For a video (screencast) overview of this whole process, please watch the following video.
As a reminder, please only use browsers supported by Canvas. See: Which browsers does Canvas support?.
The Faculty Center Grade Prep tool is designed to aid instructors with the submission of grades for high-enrollment courses with many diverse grades assigned to students. If you have a small course and/or you do not have many different grades assigned to students, we recommend that you manually enter grades into Faculty Center. For more information on manually entering your grades see: Grading Instructions.
Step 1: Enable Grading Scheme in Canvas
Use Valid Instructor Assigned Grades (A, AB, B, BC, C, D, F) as defined by the Office of the Registrar. For more information on Valid Instructor Assigned Grades, see https://registrar.wisc.edu/valid_instructor_assigned_grades.htm.
You can control how grades are displayed by setting up a Grading Scheme. For instructions on how to set up a grading scheme in your course, see How do I enable a grading scheme for a course?.
The default grading scheme is not currently set to the valid instructor assigned grades. When following the tutorial above, select the grading scheme using “A, AB, B, BC, C, D, F”. The screenshot below shows the “UW-Madison” grading scheme that contains the valid instructor assigned grades.
You may also create your own grading scheme as long as it uses valid instructor assigned grades. Instructions on creating grading schemes can be found here: How do I create a grading scheme for a course?.
Step 2: Verify Students’ Final Grades in Canvas
By default the Canvas Gradebook does not display students’ final grades.
The total column in Canvas Grades is the current or working total. It is not the final grade. To see the final grade, an instructor should do one of the following procedures:
- Enable “Treat Ungraded as 0” from the settings gear dropdown menu. NOTE: This only displays the ungraded items as 0. It does not actually change ungraded items to 0.
- Manually change all ungraded assignments to 0 (zero). You can change all ungraded assignments to 0 (zero) by using the “Set Default Grade” feature described in this document: How do I set a default grade for an assignment?. It is highly recommended that you save a backup of your Canvas gradebook before making bulk changes.
- Export a CSV spreadsheet of Canvas Grades by clicking Export > Current. The final grade is displayed in the last column of the spreadsheet.
- Graded, muted assignments are used in the calculation of students’ total grades in the instructor’s view of the gradebook. From the student’s point-of-view, their current total grade will not include the muted assignment. If you were to use the Faculty Center Grade Prep tool while assignments are muted, you run the risk of submitting a final grade that is not the same as the total grade students see in Canvas. (Note: If any of your assignments are muted, the Grade Prep Tool will treat them as 0s and adjust every students grade accordingly. Make sure to unmute any assignments before uploading the Faculty Center File into the Grade Prep Tool)
NOTE: Students Do Not See Their Final Grades by Default in Courses with Ungraded Items
Students will not see their final grade by default in courses with ungraded items. The default view is their current grade which disregards ungraded items. To see their final grade in a course with ungraded items, students should check “Calculate based only on graded assignments” as described under the “View Current and Total Grades” section of this document: How do I view my grades in a current course?.
If the instructor manually changes all ungraded items to zeros, the current grade will be identical to the final grade. For more information on calculating final grades see Canvas - Calculating Final Grades
Step 3: Faculty Center Export
For instructions on exporting grades from Faculty Center, please see the Office of the Registrar’s Quick Tips PDF. The tutorial starts on the second page under “Exporting and Importing a Grade Roster”. Follow instructions under the header “Exporting & Entering Grades in Excel”.
After exporting the faculty center grade roster file, return to Canvas.
Step 4: Faculty Center Grade Prep Tool (in Canvas)
- Return to your Canvas course.
- In Course Navigation, click the Grades link.
- Click the Faculty Center Grade Prep button.
- Click the Browse button.
- Use your computer’s file browser to select the file you just downloaded from Faculty Center.
- Click the Process File button.
- Depending on the size of your course, it may take some time to process the file. You should see while you wait.
- The tool should inform you of any issues you need to address in the Results, Warnings, and Errors sections.
- Scroll to the bottom of the page. Click the Download button to download the file you can upload into Faculty Center. Be sure to open and review the file before submitting to Faculty Center.
After you have the newly updated grade file from the Faculty Center Grade Prep tool, return to Faculty Center to import your file.
Step 5: Faculty Center Import
Once you have downloaded the grades file from Canvas, continue with the tutorial found in the Office of the Registrar’s Quick Tips PDF. Specifically, continue with Step 18 under “Importing Your Grades from the Grade Roster Export Excel File”.