Moodle - Offline Grading Worksheet


UW-Madison is adopting Canvas as the single, centrally supported learning management system, and discontinuing support for Desire2Learn (D2L) and Moodle. Access to D2L and Moodle will permanently end June 1, 2018. For information about retaining materials from D2L or Moodle, please refer to this document.

This article is about using the Offline Grading Worksheet to grade assignments in Moodle 2.4.

Instructors are now able to download a grading sheet from a single assignment, grade their students, give feedback, and upload the grading sheet back to Moodle.
To do this, first go to the assignment you would like to grade this way.  Click Edit Settings in the "Administration" block.
Mark the check on the "Offline grading worksheet"  in the "Feedback types" section.

Now when you are ready to grade the assignment, select the assignment and click View/grade all submissions on the assignment page.
Select view/grade all submissions

On the grading page, select Download grading worksheet from the "Grading action" drop-down.

A Microsoft Excel CSV will then be downloaded to your computer.  Open this file and you will be able to edit the students' grades and give feedback if "Feedback comments" were set to "Yes" in the assignment settings.

offline grading 3

When done editing the grades, save the file to your computer.

Go back to the assignment grading page and select Upload grading worksheet from the "Grading action" drop-down.

Upload the file you saved on your computer
Confirm the grade changes

Select Continue
The grades will be changed in the Moodle grade book.

Keywords:3.0, marking, assignment, excel,   Doc ID:32494
Owner:Erica H.Group:Moodle
Created:2013-08-02 10:45 CDTUpdated:2018-03-05 17:56 CDT
Sites:DoIT Help Desk, Moodle
Feedback:  2   4