Versions Compared

Key

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

...

Note

The Center for Excellence in Teaching and Learning has more detailed instructions available in a PDF format.

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.

...

Note

The new file (converted_scantron.csv) contains the column Username. This column contains student NetIDs, which you must keep in order to upload the grades.

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. Next, browse

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

      Tip

      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.


Info

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


Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel in ("scantron","grade","bubble_sheet","exam","scanning") and space = "IKB" and parent = "79823540"

...