Uploading a CSV file from Scantron to 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 that contains a .zip file (ScantronReports.zip) that instructors need to download. The .zip file includes a .csv file named “ExamGrades.csv." Instructors can covert 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 https://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.

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 on 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

   If your .csv file does not contain the special ID, the new column you create in the Grade Center will have the same name as your .csv file. For example, if you named your .csv file 'Test 1,' instead of using the special ID code as the title, then the new column created in the Grade Center will also be titled 'Test 1.' 

   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 have already entered in 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. 

      Another way to retrieve the exact column title of the Grade Center column is to Download the Grade Center as a .csv file and then copy/paste the column title from there into the .csv file being prepared for the upload of the test score. 

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, 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