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
- Enter the course where you want to import the results and navigate to the Grades section.
- Click on the Actions menu found above the list of students, then Import.
- Choose a CSV file to upload. Click on the Choose File button and select your CanvasImport.csv file.
- Click on the Upload Data button.
- Canvas will ask you to identify information about the data you are uploading:
- 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.
- Set the maximum points possible for your assignment.
- Press the Continue button. Review the scores imported, and click the Save Changes button.
- 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
How to Export Final Grades for KnightWeb Importing — Faculty can import grades to KnightWeb via Excel spreadsheet. This document describes how to create an Excel spreadsheet from Canvas.
MyLab & Mastering Coordinator courses and Canvas gradebook sync — If you are using a Coordinator course within Pearson, you must enable the Canvas/MyLab & Mastering integration first. Otherwise, when using Pearson’s Coordinator course with corresponding sections, you will not be able to integrate MyLab & Mastering with Canvas. You can, however, follow the steps detailed below to export grades from MyLab & Mastering and import to the Canvas gradebook.
For tips, tricks, and updates on learning technologies at Geneseo, visit our Educational Technology Chat. To explore Canvas Guides (created by Instructure), visit https://community.canvaslms.com/community/answers/guides/canvas-guide