Canvas - Import Scantron grades from the Testing Center to the Gradebook
This article provides directions for importing Scantron grades into a Canvas Gradebook. The process involves obtaining a file containing Scantron test scores from the UWM Testing Center and collating those scores into a Canvas Gradebook Excel file. This process takes place mostly in Microsoft Excel. After the information has been properly combined, the excel file of the Canvas Gradebook can be imported back into the Canvas course to reflect the new grade item.
Part 1: Exam settings and Gradebook export
- Log into Canvas and select the course that will receive the Scantron grades.
- Select the exam that will be receiving the grades in the module.
- Edit the exam.
- Under Submission Type, select “No Submission.”
- Click “Grades” in the Canvas navigation panel.
- In the Grades page, click the down arrow for “Actions.”
- Click “Export.”
- Download and open the Excel .csv file of the Gradebook that Canvas has created.
Part 2: Organizing the Canvas Gradebook and UWM Testing Center files in Excel
- Select the entire “Test Student” row and delete it from the Gradebook Excel sheet.
- Open the file of the Scantron grades from the UWM Testing Center.
- The file from the Testing Center is a tab-delimited text file with a .ASC file extension.
- Open Microsoft Excel.
- Select “File”
- Select “Open”
- Select "Browse"
- Note: Make sure the file browser is set to "All Files" when looking for the .ASC format.
- Navigate to the .ASC file and open it in Excel.
- Opening an .ASC file in Excel will prompt the Text Import Wizard pop-up.
- Make sure the file type selected is "Delimited."
- Click "Next" within the pop-up for the next 3 steps, there is no need to change any of the settings.
- In the Testing Center sheet, select all the cells and click “Sort & Filter.”
- Sort the cells from “A to Z.”
- Repeat steps 3 and 4 for the Gradebook sheet from Canvas.
Part 3: Transferring the UWM Testing Center Scantron scores into the Canvas Gradebook Excel sheet
- Once the names are aligned in both sheets, go back to the Scantron grades from the Testing Center.
- Click the first cell of the scores column and hold down “Shift” and then click on the last cell in the column with a score.
- Copy the information (Ctrl + C Windows) (Command + C Mac).
- Navigate back to the Gradebook sheet from Canvas.
- Select the first blank cell associated with the first student name in the Gradebook column receiving the scores.
- Note: Make sure the number of cells that have been copied matches the number of names in each sheet.
- Paste the scores from the Testing Center into the column (Ctrl + V Windows) (Command + V Mac).
- Note: Be sure that the scores align with each student properly.
- Save the Canvas Gradebook sheet with the new Scantron scores.
Part 4: Import the new Canvas Gradebook Excel sheet back into Canvas
- Navigate back to the Canvas course and go to “Grades.”
- Select the down arrow next to “Actions” again.
- Click “Import” and select the Gradebook file that was just saved from the file browser.
- Click the “Upload Data” button after the file has been selected.
- Click “Save Changes” and then click “OK.”
- The Scantron grades will now appear in the Gradebook column they were assigned to.