Moodle 3.2: Grade Assignments with an Offline Grading Worksheet

Applies to: Moodle 3.2

Moodle offers multiple ways to grade assignments, as well as the option to grade outside of Moodle in a Grading Worksheet. The Grading Worksheet is a nice way to enter many assignment grades at once with a simple score and short comments as needed. It is very similar to the Quick Grading method but is done outside of Moodle in Excel.

Note: Using this upload method of an Excel file DOES NOT create overridden grades in the gradebook, since the grades and comments are brought into Moodle via the assignment grading page.

In this article:

Configuring the assignment to use an offline grading worksheet

  1. Go to the course homepage and click Turn editing on.
  2. Find the activity you want to modify.
  3. Click the Edit menu Edit activity menu. to the right of the activity.
  4. Choose Edit Settings.
  5. Scroll down and click Feedback Types to see the options.
  6. Check Offline Grading Worksheet.
    Assignment feedback type options with Offline grading worksheet checked.
  7. Scroll down and click Save and return to course.
  8. Click Turn editing off.

Downloading the offline grading worksheet

  1. Go to the course homepage.
  2. Find the Assignment you want to grade and click its link.
  3. Click View all submissions.
  4. Select Download grading worksheet from the Grading actions dropdown menu in the upper right. A Comma Separated Values (CSV) file will download to your computer.
    Grading action menu with Download grading worksheet highlighted.

Entering grades in the offline grading worksheet

  1. Open the CSV file in an appropriate program such as Excel.
    WARNING: Only modify the Grades and Feedback comments columns in this file.
  2. Find the Grades column and enter numeric grades.
    Sample CSV file with Grade, Maximum Grade, and Feedback comments columns.
    Note: Grade values should not be higher than the Maximum Grade displayed in the column to the right.
  3. Find the Feedback comments column and enter short text comments.
  4. Save your file as a CSV file. You may get a warning about saving the file in the "selected file format." Choose continue and accept the defaults. Leave the .csv at the end of the file name.

Uploading the new grades into Moodle

  1. Go to the course homepage.
  2. Find the Assignment you want to grade and click its link.
  3. Click View all submissions.
  4. Select Upload grading worksheet from the Grading actions dropdown menu in the upper right.
  5. Click Choose file.
  6. Find the CSV file on your computer.
  7. Click Upload this file.
  8. Scroll down and click Upload grading worksheet. A confirmation notice and a list of students with new grades and comments will display.
  9. Scroll down and click Confirm.
  10. Click Continue.