Importing Optical Scanning Data into Brightspace

Owned by Laurie Fox
Last updated: Jul 25, 2023 by Eric McLean
2 min read

This self help document outlines the process for importing Optical Scanning Data (bubble sheets) results into your Brightspace Course.

Step 1: Collect Student Scores

The Opscan results are sent via email from CIT. Within the zipped file, you will find files called LMSImport.csv and LMSImportReject.csv. Save both files to your desktop.

Step 2: Importing the Scores into the Brightspace Gradebook

  1. Enter the course where you want to import the results and navigate to the Grades section.

  2. On the Enter Grades page, click Import.

  3. Click Browse.

  4. Locate the file you want to import and click Open.

  5. Select Create new grade item when an unrecognized item is referenced if you want to be able to create new grade items from the import file.

  6. Click Continue.

  7. If you are creating new grade items:

    1. Select the Create New Grade Item check box beside each of the items you want to create.

    2. Select a grade item Type.

    3. Click Continue.

    4. Fill in the grade items' properties.

    5. Click Continue.

  8. View error and warning messages associated with the import, and click Continue. Note: Fields with errors are not imported.

  9. Preview your import and click Import.

Step 3: Manually add Student Scores from LMSImportReject.csv file

You will need to manually enter the scores from the LMSImportReject.csv file into the gradebook after you import the other scores, as the file contains results that did not match a Geneseo ID number to a student. You will also need to manually enter a zero for any student who did not take the quiz/exam, designated by a missing score following the import and reject file updates.

Related Self Help Guides

  • Page:
    Delete a grade item or category — This guide has information about how to remove unwanted grade items or categories
  • Page:
    Integrating your Pearson MyLab or Mastering
  • Page:
    Importing Optical Scanning Data into Brightspace
  • Page:
    Hide the Final Calculated Grade in Brightspace — Hiding the Final Calculated Grade can be helpful if Instructors want to prevent students from seeing their (final) grade at any point during the term and if an Instructor wishes to prevent students from receiving email notifications when a grade has been entered/updated (since the Final Calculated Grade, by default, will also be updated each time a grade is entered which causes email notifications to be sent to students).
  • Page:
    Hide a Single Grade Item or Grade Category from Students — When grading student work, instructors might want to decide to keep grades and feedback hidden from learners until all work has been graded, for example. For grades and feedback to be fully hidden from students, both a) the grade item and/or its category and b) the graded activity itself need to be made invisible.
  • Page:
    Creating Extra Credit Grade Items — Extra credit points can be given in Brightspace in two ways:
  • Page:
    Dismiss Activities from QuickEval — When you dismiss an activity, it is hidden from the Quick Eval list, but won't affect the activity. A dismissed activity is still available for evaluation from its own tool (Assignments, Quizzes, Discussions).
  • Page:
    Entering all grades for a specific Grade Item — There are many ways to enter grades into Brightspace. Typically you might enter grades within the Assignment or Quizzes tool. However there are times when you may not be using those tools, but have another activity that requires a grade. One of the simplest and most straightforward is to use the Enter Grades function within the Gradebook. This method allows you to input all the grades for a specific activity in one place, without having to use the assignment or quiz tools.