Import Grades from Testing Center (TEMC)

Teachers who use TEMC's test scanning and scoring service can quickly import their exam scores into their Canvas course sites.

For more information on TEMC and their services, please visit their website.

In order for the CSV file to import into the Canvas gradebook, a few conditions will apply.

  1. The CSV file should not be modified in any major way or the teacher risks breaking the format for import.
  2. When requesting the data file, the For Canvas checkbox option for CSV file must be selected. If this is not selected the data file cannot be imported into Canvas.

Information about the CSV file from TEMC

The CSV file from TEMC will have the following column titles based on the options the teacher selected on their request form;

csv points example image
csv weighted column example

If the file does not match this format, it is likely you did not request the Canvas CSV file or that you are viewing a different file.

NOTE: Columns A - E should not be altered. Columns following E may vary in title based on how the TEMC request form was filled out form. You may edit the titles of these columns to match the name of your exam.

Student names and scores will appear in the subsequent cells.

StudentIDSIS User IDSIS Login IDSectionW-PointsW-Percent
Points Possible     
Student1 NameA#  8284
Student2 NameA#  8183
Student3 NameA#  7071
     

Import TEMC File into Canvas

  1. Log into Canvas and navigate to Course site Gradebook.
  2. Click Import located on the upper right corner of Canvas Gradebook
  3. The upload CSV page will appear. Browse for the TEMC grade and attach it. Click Upload Data.
  4. An alert screen will appear stating that Canvas could not figure out how to handle the data.
  5. If the CSV file had multiple grade columns, choose the grades you want to import into the Canvas Gradebook
    • For the grade column(s) you wish to import, select the Choose Assignment drop-list and select the option A new assignment.
    • For the grade column(s) you do not wish to import, select the Choose Assignment drop-list and select the option Bogus, ignore it.
  6. Enter the maximum points possible for quiz.
  7. Click Continue and a preview of the imported grades will appear.
    • If students entered their name or SIS ID incorrectly on the scantron form you should be able to reconcile the entries to match the appropriate student.
  8. Click Save Changes to save the grades to the gradebook or Cancel to exit back to the upload CSV page.
  9. The teacher will get an alert that their file is being uploaded and may take a while to upload and to refrain from making updates until the import process is completed. 
     
Canvas grade import alert
  1. Click OK to clear the alert.
  2. The Canvas gradebook will load and the imported grades will appear under the title of the column from which grades were imported. Some scores may appear to be missing initially. Please allow time for the gradebook to finish importing the grades.
    • If you need to change the title of the imported grade item, click Assignments, locate the assignment and click Edit. Change the title, enter due dates if you want and then click Save.