Moodle - Offline Grading Worksheet


UW-Madison has adopted Canvas as its single, centrally supported learning management system. As of 6/1/2018, support for Desire2Learn (D2L) and most Moodle courses has been discontinued. Access to those courses has permanently ended. However, certain Moodle courses that are part of the Adanced Quizzing Content Functional Gaps project are still available on Moodle. Those courses are located on the Moodle Extension site.

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 09:45 CSTUpdated:2018-03-05 16:56 CST
Sites:DoIT Help Desk, Moodle
Feedback:  2   4