Learn@Illinois Moodle - Importing Grades Using a Spreadsheet

Learn how you can import scores from a spreadsheet into your Learn@Illinois Moodle gradebook in order to save time hand-entering grades.

For a permanent link to this information, please use: http://go.illinois.edu/MoodleImportGrades

This feature is handy when you must manually enter grades for assignments outside of Moodle and prefer to keep these grades in an Excel file to upload at the end of the semester. It is advisable to keep grades in an Excel file that is generated by Moodle. This page explains how to:

  1. Add a manual grade item to the gradebook
  2. Download a blank file from Moodle to keep your grades in
  3. Prepare the file for upload
  4. Import the file at the end of the semester to upload the grades to the Moodle gradebook

STEP 1: Add a Grade Item or Grade Items for the Assignment(s) you Wish to Grade in Excel

If the grade item does not already exist in Moodle, we recommend adding a new manual grade item for any assignment you plan to grade in Excel.

Note: If you import without adding a grade item first, it will automatically make the Max grade (total points) 100 points and you will not be able to add feedback.

STEP 2: Export an Excel file

  1. Click Grades.
    Click Grades
  2. Click Grader report and select Export.
    Click Grader report and select Export
  3. Click OpenDocument spreadsheet and select Excel spreadsheet.
    Click OpenDocument spreadsheet and select Excel spreadsheet
  4. Under "Grade items to be included," check the checkbox to the right of the manual grade item you have created that you would like to grade in Excel.
    Select assignment

  5. Click Download. The file will download automatically.
  6. Your file will look something like this.
    Example of a downloaded Excel sheet

STEP 3: Prepare the File for Upload

  1. Delete all columns except "Email address" and the assignment for which you are uploading grades.
    Note: You may optionally insert another column called "Feedback" and add feedback to the student about the grade.
    Note: If you are not downloading an Excel file, make it match this format. You may alternatively use the NetID instead of the student email address in the first column.
    Example of formatting for Excel file to upload
  2. Enter grades (and feedback, if using).
  3. Save this file in CSV format.
    Note: You may get warnings from Excel when you save as a CSV. If these appear, just click continue.
    Save as CSV

STEP 4: Import the File

  1. From the course homepage, click Grades if not already on a grades-related page.
    Click Grades
  2. Click Export (or whichever grades page you were on last) and select Import.
    Click Export and select Import
  3. Drag and drop your CSV file into the box or click Choose a file... and add the CSV file to the file uploader.
     Drag and drop file or add using the Choose a file button
  4. When you are done, click Upload grades.
    Upload grades button
  5. In the "Identify user by" section, you will map the column from your CSV file to the variable in Moodle:
    • For "Map from", select the email column header name that you used in your CSV file (e.g., Email address).
    • For "Map to", select Email address.
      Identify user by email address
      Note: If you are using NetIDs to identify students, select the NetID column header name that you used in your CSV file for "Map from" and Username for "Map to".
      Note: Do not select "User ID" or "ID number."
  6. In the "Grade item mappings" section make the following changes:
    • By the "Email address" (or "NetID" field), select Ignore.
    • By the name of your assignment from the column header in your file on the left, select the name of the grade item in Moodle that you want to import to.
    • If you have a feedback column in your file, select the name of the feedback item in Moodle that you want to import to.
      Grade item mappings
      Note: The text on the left contains the names of the columns in your spreadsheet. In the drop-down menus, you are selecting the corresponding item in the gradebook.
  7. Click Upload grades.
    Note: This action can take several minutes. If you receive an error message, make sure that your CSV file contains no errors and try again.
    Upload grades

Keywordsimport, importing, grade, excel, csv, grading, boost   Doc ID72411
OwnerATLAS-TLTGroupUniversity of Illinois LAS
Created2017-04-07 13:43:57Updated2023-03-16 16:48:19
SitesUniversity of Illinois Liberal Arts and Sciences
Feedback  0   0