Skip to end of metadata
Go to start of metadata

This self help document outlines the process for importing Optical Scanning Data (bubble sheets) results into your Canvas Course.

Step 1: Collect Student Scores

The Opscan results are sent via email from CIT. Within the zipped file, you will find files called CanvasImport.csv and CanvasImportReject.csv. Save both files to your desktop.

Step 2: Importing the Scores into the Canvas Gradebook

  1. Enter the course where you want to import the results and navigate to the Grades section.
  2. Click on the Actions menu found above the list of students, then Importscreen capture of import dropdown option
  3. Choose a CSV file to upload. Click on the Choose File button and select your CanvasImport.csv file.
  4. Click on the Upload Data button.
  5. Canvas will ask you to identify information about the data you are uploading:
    1. Choose an existing assignment if you have already created it in your course. If you have not created the assignment, Canvas will allow you to create a new assignment at this time.
    2. Set the maximum points possible for your assignment. 
    3. Press the Continue button. Review the scores imported, and click the Save Changes button.
  6. If you created a new assignment, it will now appear in your Grades. The title of the assignment will be in the format YYYYMMDDHHMM_Score - you can change the name of the assignment by clicking on the column heading.

Step 3: Manually add Student Scores from CanvasImportReject.csv file

You will need to manually enter the scores from the CanvasImportReject.csv file into the Canvas gradebook after you import the other scores, as the file contains results that did not match a Geneseo ID number to a student. You will also need to manually enter a zero for any student who did not take the quiz/exam, designated by a missing score following the import and reject file updates.

Related Self Help Guides

More Help

For questions about Canvas, contact CIT via our online service desk or email Weekdays between 8am-4pm, you can also contact us via our real-time chat portal.

For tips, tricks, and updates on learning technologies at Geneseo, visit our Educational Technology ChatTo explore Canvas Guides (created by Instructure), visit