Canvas CCM: Prepare Final Grades for Upload to Faculty Business

Environment

Canvas
M-Pathways Faculty Business
Canvas Course Manager (CCM)

Issue

How to format Canvas grades so that they may be uploaded (imported) to M-Pathways Faculty Business for official grading and inclusion in transcripts.

Note:  These steps describe the standard process used at UM. Your department or school may have a different grade policy.

Video Demo

Format Canvas Gradebook using Canvas Course Manager (CCM)

Resolution

Canvas allows you to download a final grade CSV file that you can modify and upload to Faculty Business.

1. Prepare your Gradebook for uploading final grades

• End of Term Gradebook Checklist for Canvas

2. Login to M-Pathways Faculty Business via Wolverine Access

• Instructions for logging into Faculty Business

3. Download the CSV grade file from Canvas

• How do I export grades in the Gradebook?

• Note: Mac users should save the Canvas download .csv as a Windows file version before modifying and uploading

4. Modify the CSV file for uploading

   1. Use the Canvas Course Manager tool within Canvas to format grades from the Gradebook for error-free uploading to Faculty Business

      1. Navigate to the course
      2. Click on the Canvas Course Manager tool in the left course navigation
         • If the tool is not available, see the Enable External Tool (LTIs) in Canvas article
      3. Click the Format Canvas Gradebook button on the Canvas Course Manager landing page
      4. See the Canvas Course Manager Docs for more details
   2. Manually modify the CSV file
      1. Open the file in Excel or another spreadsheet application
      2. Delete all columns except:
         • One of the following: "SIS User ID" (an 8-digit number) or "SIS Login ID" (uniqname)
         • "Final Grade" (the last column with entries)
      3. Delete the first several rows (the rows with header information)
      4. Save your spreadsheet

5. Upload the CSV file to Faculty Business

• Instructions for uploading a CSV file to Faculty Business

• Details about preparing a CSV file 

Additional Information

• Check out the new Academic Technology@Michigan website for course planning resources from across U-M
• Visit the Canvas @ Michigan site for faculty including the U-M Instructor Guide with links to additional support resources from across campus
• Check out the Canvas and MiVideo tutorials

For additional questions, please contact the ITS Service Center