Importing Scantron test results into a D2L course gradebook

Scantron test results can be imported into a D2L gradebook. There are four steps to this process:

  1. Export and download the D2L gradebook taking only the required columns,
  2. Open the Scantron results file
  3. Add/replace the column headings in the Scantron file with those from the D2L gradebook file, and
  4. Import the Scantron file (still in a CSV format) into the D2L course.

Opening the Scantron files in Excel:

Save the Scantron attachment to an appropriate file location, if this was not already done. Open the Scantron file in Excel (CSV files usually open automatically in Excel).

Export from D2L

  • Go to Grades
  • Click Export Grades
  • Select Key Field: Username; and Grade Values: Points Grade
  • Under Choose Grades to Export select only the column you wish to add scores to (Note: this column should be prepared already with the appropriate maximum point value)
  • Click Export to CSV
  • Click the file link in the popup and Open (or Save and then open)

Edit in Excel

  • In the D2L Export Excel file select cell B1 and copy it
  • Open the modified Scantron Excel file, select cell B1 and paste the column headers from the D2L Export
  • Click Save As
  • Next to Save As Type choose CSV (comma delimited)
  • Save the file in a location from which it will soon be retrieved

Import in D2L

  • Click Import Grades
  • Click Browse
  • Select the CSV file containing the Scantron data that was just saved and click open
  • In D2L, click Continue (and Continue again)
  • Click Import

Errors: Any errors in this process appear in the first screen of Import process. These errors usually are the result of missing student UserNames. Those grades must be entered individually.