Uploading a CSV file from Scantron to HuskyCT

Owned by Steven Fletcher
Last updated: Nov 07, 2024 by A.J. Newman
3 min read

Do you want to help shape the future of bubble sheet scanning at UConn?

ITS is piloting bubble sheet scanning through Gradescope, which may replace Scantron for bubble sheet scanning functionality in the future. Gradescope provides a more convenient scanning solution that does not require expensive and custom scan sheets, and can be managed entirely through HuskyCT.

Instructors can use the Scantron Converter to generate a CSV file that allows them to upload grades to HuskyCT.

Once tests are scanned at the self-service Scantron locations, the system sends instructors an email containing a ZIP file (ScantronReports.zip) that instructors need to download. The ZIP file includes a CSV file named “ExamGrades.csv." Instructors can convert this file so that it includes student NetIDs, which are necessary for HuskyCT. This article covers how to use the converter app and upload the file to HuskyCT.

Step 1: Preparing your Scantron file

  1. Open the ScantronReports.zip file you received from the system-generated email.

  2. Extract the ExamGrades.csv file and save it.

  3. Go to scantronconverter.uconn.edu.

  4. Click on Choose File. Navigate to the ExamGrades.csv file.

  5. Click Submit. Save the file. The file generated by the converter is the one you will upload to HuskyCT.

The new file (converted_scantron.csv) contains the column “Username” as well as student names, a percent score, and a total score. The Username column contains student NetIDs, which you must keep in order to upload the grades. You should delete the other columns you do not need to upload, such as student names and the grade column you do not intend to use. Once your CSV has only the Username and one grade column, it is ready to upload into HuskyCT.

Step 2: Uploading the CSV File to the Grade Center

  1. At the upper right of the Grade Center, click on Work Offline and then Upload.

  2. Browse your computer for your converted file. Select Comma as the Delimiter type and click Submit.

A new column will be created during the upload to hold the uploaded grades (Option, 1 below) unless the test score column title in the CSV file exactly matches the Grade Center column title (Option 2, below). This requires the addition of a special ID code, which is covered under Option 2. 

Option 1: Adding a New Grade Center Column for the Test or Grade

Option 2: Populating Grades into an Existing Column

If you have already created a column in the Grade Center using the Create Column function and entered a column name that is different from the special ID, 

  1. Go to the Grade Center. 

  2. Click on the grey down arrow to the right of the column title. 

  3. Click on Quick Column Information. 

  4. From the menu that appears, copy down the Column ID. 

  5. Add the Column ID to the column title, using the format Title | Column ID number. 

Step 3: Changing the Column Primary Display from "Text" to "Score"

By default, uploading grade values from a CSV file into the Grade Center sets the Primary Display to “Text.” In order for those grades to count towards any calculations, that setting must be changed to “Score.” To change this setting,

  1. Click the gray down arrow next to the column title, and then select Edit Column Information. 

  2. Click on the down arrow for the Primary Display menu, then change the Display Type to Score.

  3. Enter in the number of points possible. 

  4. Click Submit. 

  5. Click OK on the warning message that appears. The test scores should now display with decimal places.

Related Articles