Canvas: Import Scores from an USAS Data Sheet

You can import scores to your Canvas gradebook from paper exams taken in class if you:

  • Use exam answer sheets provided by the University Survey & Assessment Services (USAS)
  • Request a Canvas Data File from USAS¬†before your exam

Ordering paper exam answer sheets

  1. Go to Order Testing Services
  2. Download the Exam Report Order Form
    • Click Exam Report Order Form
  3. Print the form
  4. Fill it out completely. On page 1:
    1. Go to Report Results, then Additional File
    2. Check Canvas Data File
  5. Send the form to the address specified on the form

Preparing the USAS data file

Open the CSV file from USAS with the exam scores in it. It will be nearly ready for import into Canvas and only needs minor changes.

  1. Canvas requires the five columns in the order that USAS has provided. Do not alter their headings
  2. Remove all the section numbers from the Section column
  3. Rename the "score" column from USAS to your course exam name
  4. Select all the data, including headers and click the Sort option in Excel
    1. Tic "My list has headers
    2. Sort by Column > SIS Login ID > OK
  5. Save changes to the file and save the file to your desktop

An USAS exam data sheet properly prepared for the Canvas import of grades

An OMS exam data sheet prepared for the Canvas import of scores.

Importing the paper exams scores into the gradebook

  1. Go to your Canvas course gradebook
  2. From the Actions drop-down menu select Import
  3. From the Upload Gradebook page choose Choose File, locate the CSV file on your desktop, click Open, then choose Upload Data
  4. If Canvas has difficulty identifying a user, you may manually select a match from a provided list of names
  5. Then, on the Upload Gradebook page, review the changes from existing values to new ones
    • Only the student names and scores will be shown
    • The scores should be matched to your course exam name column
      • New scores and increases in scores are in black text
      • Decreases in existing scores are in red text
  6. Click the Save Changes button. You will be redirected back to the full gradebook while scores are processed

If the first/last names are reversed, or an occasional emplID or UMN email address is missing, the exam scores should still import. However, if the ID or Section columns are missing, the file import will fail.

Other resources: How do I upload changes to the Gradebook?

Last modified

Changed

TDX ID

TDX ID
3025