Canvas (Instructors) - Uploading ScanTron results to the Canvas Gradebook

  1. Log into the Canvas course and navigate to the Grades section.
  2. Select Export > Export Entire Gradebook
  3. After the download finishes, open the gradebook export file in Excel
  4. Keep the columns with the identifier information (Student, ID, SIS User ID, SIS Login ID, Root Account and Section—columns A through F). Delete all other columns except for the column of the assignment you’d like to update.
  5. In another Excel Window, open the “Exam Results” spreadsheet from the Email generated by the Scantron process.
  6. Under the Class Roster tab, copy the Score information.
  7. Return to the exported file and Paste (right click and select “Paste Values” for the cleanest result) the data into the open area to the right of the student information beginning with the row containing the first student (probably cell H3 or H4)
  8. The Scantron results and Canvas both sort students by last name. Unfortunately, sometimes students who have dropped the course will still be listed in the Scantron results even though they are not in the Canvas course. Thus, when you paste the scores into the exported Canvas file the scores will be off by one line. If so, cut and paste the results so that each row lines up with the correct student.
  9. If you have multiple results (i.e. multiple versions of the exam), repeat steps 5-8 as needed. You may wish to use formulas such as =MAX(), =SUM(), or =AVERAGE() in Excel at this stage to get a final value.
  10. Copy and Paste the final VALUES of the cells into their appropriate rows for each student (you do not want a formula under the grade item) (right click and “Paste Values”). Ensure that student names and scores line up correctly all the way down.
  11. Delete all extra columns beyond the grade item.
  12. Save this page as a CSV document.
  13. Return to the Canvas Grades section and select Import.
  14. Browse for the CSV file you created and upload it.
  15. You may need to refresh the grades page several times for the grade changes to appear.

Print Article

Related Articles (2)

Canvas - Peer Review Guide for Students
Your instructor can assign student peer reviews for assignments and discussions in Canvas. This article is a collection of technical guides intended to help students complete peer reviews and view feedback from their peers.
Canvas (UWGB Account Holders Only) - Accepting Continuing Education Course Email Invitations
The purpose of this document is to show UWGB users how to accept externally-facing course invitations when they already have a UWGB account