Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Once tests are scanned at the self-service Scantron locations, the system sends instructors an email that contains 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  This article covers how to use the converter app and upload the file to HuskyCT.

...

Note

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

Note

...

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

Note

If your .csv 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.”

...

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.

Info

For assistance specifically with HuskyCT, please contact the Educational Technology Office at edtech@uconn.edu or (860-) 486-5052.

...