Moodle 3.2: Import Results of Paper Exams into the Moodle Gradebook

Applies to: Moodle 3.2

You can import scores to your Moodle grade book from exams taken in class if you:

  • Use exam answer sheets provided by the Office of Measurement Services (OMS).
  • Request a Moodle Data File from OMS before your exam.
  • The grades received from OMS are in a CSV file with one column containing student Internet IDs and the remaining columns containing grades.

Ordering paper exam answer sheets

  1. Go to Order Testing Services.
  2. Download the Exam Report Order Form:
    • Click Exam Reporting Order Form (PDF).
  3. Print the form.
  4. Fill it out completely. On page 1:
    1. Go to Report Results, then Additional Files.
    2. Check Moodle Data File.
  5. Send the form to the address specified on the form.

Importing results of paper exams into the gradebook

  1. Open the CSV file with the exam scores on it
    • Change the Internet IDs to [email protected].
    • Change the title of the Internet ID column to Username.
    • Save changes to the file and save the file to your desktop.
  2. Go to your Moodle course gradebook.
  3. From the gradebook drop-down menu, select the Import >CSV file.
  4. Drag and drop the CSV file from your desktop to the file upload box.
  5. In the Import Preview window, set the fields as follows:
    • Identify user by:
      • Map from: Username
      • Map to: Username
    • Grade item mappings
      • Score: newgradeitem (this will create a new column)
      • OR select already existing grade item (column). Note this action overrides existing grades in that column, if there were any.
      • You may safely ignore the rest of the columns.
  6. Click the Upload grades button.

Technical Tip for Open Office Users

Open Office usually adds extra quotation marks (") to the CSV file, which causes issues during import. To fix the issue:

  1. In Open Office, go to File > Save as.
  2. In the pop-up window, check the Edit filter settings checkbox and click Save.
  3. Erase whatever you see in the Text delimiter field.
  4. Click OK.
  5. Save the file and import it into Moodle.