Before engaging the Faculty Center Grade Prep Tool, please review the following.

Set a grading scheme for your Canvas course

For the Faculty Center Grade Prep tool to work, your Canvas course must have an active grading scheme. That grading scheme needs to adhere to the Valid Grades policy put forth by the Office of the Registrar. For instructions on setting up a grading scheme in your course, see Canvas - Grading Schemes.

Give ungraded assignments a zero

For Canvas to accurately calculate a final grade, there should be no blank or null fields in the gradebook. 

In most cases, a blank cell in the gradebook indicates the student did not complete that assignment, thus earning a zero. If that is the case, you should enter a zero into that cell (or whatever numeric value is appropriate). This process should be performed one assignment at a time, sorting each assignment from lowest to highest values. That will cause all "null" cells to be grouped together, making them easier to locate.

Alternatively, if a student has been excused from an assignment, you should enter Ex into the cell. Doing so removes that assignment, and the associated points, from the calculation of the student's final score.

Ensure all assignment grades are posted (not hidden)

Canvas allows instructors to hide existing grades for an assignment. This is usually employed as a temporary tactic, to enable notifying all students of their grades for a given assignment at the same time. However, instructors may inadvertently leave some assignment grades hidden, or unposted. Before running the Faculty Center Grade Prep tool, it is imperative to ensure all grades have been posted.

The best way to determine whether any grades are currently hidden is by looking for the hidden grade icon. (See image.) If this icon is present in the header of any assignment, it means at least one student's grade for that assignment has been changed in the instructor's gradebook but has not been posted and shared back with the student.

To post grades for a single assignment, go to the gradebook. Find the assignment in question. Select the ellipsis button (three dots) in the header. In the resulting pop-up menu, select Post grades. (See image.) There will be additional options in this process. For a detailed breakdown of all options, refer to this Canvas Guide, How do I post grades for an assignment in the Gradebook?

If Post grades is not available, then there are no grades for this assignment that need posting.

Export the gradebook (optional)

You may wish to export a copy of the Canvas course gradebook before running the Faculty Center Grade Prep tool. This provides you with a current-state backup of the gradebook, it allows you to review the grades before starting the process outlined below, and it gives you a reference document by which you can confirm success at the conclusion of this process.

To export the Canvas gradebook:

1. Open your Canvas course.
2. Select the Grades tool.
3. Select the Export button (upper-right corner).
4. Select Export Entire Gradebook. (See image.)

Miscellany

• Use browsers supported by Canvas. See: Which browsers does Canvas support?.
• Note that the Faculty Center Grade Prep tool is designed to transfer final grades only. It is not intended to transfer midpoint grades or other partial grades to the Faculty Center.

In this first step, you will need to log into the Faculty Center and export (or download) the grade roster.

1. Log in to MyUW, then select the Faculty Center tile.
2. The main page will display your schedule for the current term. To view the schedule for a different term, click the Change Term button.
3. Select the class for which you need to enter grades.
4. Click one of the following:
   • Grade Roster
   • Packaged Grade Roster
   • XL-MW Grade Roster
5. On the grade roster page, click the Export button.
6. Click Save on the File Download dialog box.
7. In the Save As dialog box:
   • You may change the file name.
   • Change the file type to .csv (not .xls).
   • Select the location in which you want to save the file.
   • Click Save.
   • Important: The Excel spreadsheet must be saved in the .csv file format.
   • Mac users: Select csv (Windows) when saving and name the file with 30 characters or fewer.

We will use this exported .csv file in Step 2 (below).

Notes: 

• Do not modify any internal component of this .csv file. Both of the last two steps in this process depend upon the organization of columns, column headers and student identifiers. 
• Any work done to the body of this .csv file will be overwritten by the following steps.
• These steps are extracted from a KB document maintained by the Office of the Registrar. If you experience any complications with these steps, please consult the original KB document, Export and Import Grades. If problems persist with this export effort, contact the Office of the Registrar at egrade@em.wisc.edu, or 608-262-4859.

To complete this 3-step process, we now need to upload this new-and-improved grade roster (which now contains the students' grades) into the Faculty Center.

1. Log in to MyUW, then select the Faculty Center tile.
2. The main page will display your schedule for the current term. To view the schedule for a different term, click the Change Term button.
3. Select the class for which you need to enter grades.
4. Click one of the following:
   • Grade Roster
   • Packaged Grade Roster
   • XL-MW Grade Roster
5. On the grade roster page, click the Import button.
6. From the Choose File dialog box, select and open the file (.csv) that includes your students’ grade information.
7. Click Upload.
8. From the Grade Roster page, click Save.
9. Review any error messages that appear.
   • If you have entered an invalid grade, you will see an error message and invalid entries highlighted in red.
   • If the names in the grade roster do not match your extracted roster, you will see an error message. Contact the Office of the Registrar for assistance.
10. When you have entered all grades for this section, submit them to the Office of the Registrar for posting:
    • On the Grade Roster, select Submit to Registrar.
    • On the XL-MW / Packaged Grade Roster, click Submit.
11. Click [Save].