Center for Teaching, Learning and Technology
Illinois State University
Jump over the College navigation bar.

Opscan & ReggieNet

Opscan can provide a special "Scores for ReggieNet" Excel file that makes it possible for you to upload your grades into ReggieNet. ReggieNet identifies students using their University Login ID (ULID). In order for us to include ULIDs in the report we generate for you, students must use their numerical University ID (UID) on the Opscan sheet in the field that says "University ID". Social Security Numbers or specially-generated classroom identification numbers will not work.

When you submit the job to Opscan, make sure to indicate you want the “Scores for ReggieNet” report on the job request form along with any other reports you want. (If you want us to email the file, then you must set up a password with us to encrypt the Excel file and thus protect students’ UIDs and scores.) In an email message, you will receive an Excel file that lists the students’ names, UIDs, ULIDs, and scores. The column of ULIDs is titled “Student ID” because ReggieNet uses that term. A sample of such a file is shown here. If our scanner was unable to read a UID or unable to match it to a student, then no ULID is inserted.

Sample of Scores for ReggieNet Excel File

Starting in Fall 2017, a new gradebook tool is available within ReggieNet. The new Gradebook allows you to upload Opscan grades, but the process for doing so is different than in past semesters. A subset of these instructions is included in the "Scores for ReggieNet" file. (If you received a gradebook that includes a macro in it, that was a temporary format used at the beginning of the fall semester. Please contact Opscan, and we will be happy to regenerate your grades in the proper format.)

Note: During the first four weeks of the Fall 2017 semester, a different type of “Scores for ReggieNet” Excel file was generated. In order to upload that file, you will need to use a different set of instructions.

Make some necessary changes to the "Scores for ReggieNet file and save it in the CSV format:

  1. Open the Scores for ReggieNet file in Excel.
  2. If there are any ULIDs missing in the Opscan file, make sure to enter those in Column C (labeled Student ID), verifying that the right ULID is put in the correct row. Only lowercase letters should be used when entering the ULID.
  3. Delete columns A (Scanned Name) and B (University ID). Keep the remaining columns.
  4. Change the word "Test" to your preferred test name. Note that in the test name, you cannot use the following characters:
    [ ] # * $ \
  5. Change the word "Points" in brackets to the actual point value for the test. Keep the square brackets in place, with one space between the test name and the open bracket. (You can enter points as a decimal value, like 50.50.) In the end, the heading for column E would be something like:
    Test 1 [50]
  6. Save the file using File > Save As and save the file in CSV format. When you do, the set of instructions in the Excel file will disappear.  
  7. Upload the CSV file into ReggieNet. 

 Import the file into ReggieNet:

If you run into any errors while importing the CSV file into ReggieNet, please refer to our Troubleshooting page.

  1. Return to ReggieNet; click Gradebook in the left-hand navigation if you aren't already in Gradebook.
  2. Click the Import/Export tab.
  3. Under the Import section, click the button labeled Browse or Choose file. Navigate to and select the revised CSV file. Click Continue.
  4. On the Gradebook Item Import Selection page, scroll down and find the item for which you are importing scores. To the right, it should say "New" if the item is not in the Gradebook, or "Update" if this item already exists. Check the box next to the item's title.Gradebook Item Import Selection, new item
    Gradebook Item Import Selection
  5. Click Next.
  6. If this is a new item, you will be prompted to create the new item. The test name and point value will already be present in the proper fields, but you may change them at this point. Click Next.
  7. Verify the test name on the Confirmation page, and click Finish.
2017-09-14T15:07:29.275-05:00 2017