Provide grades and feedback using the offline marking worksheet

Why use it?

The offline marking worksheet allows markers to enter marks and feedback when they are not connected to the internet. It also allows a record of all marks and feedback to be kept outside of Moodle.

Step 1: Add an Assignment

See our guide on Assignment set-up guide (individual and group) for the settings. When setting up the Assignment, under Feedback types, make sure Offline grading worksheet is enabled (ticked).

Step 2: Students submit

Tip: Click on the question mark icon next to any setting to display extra help or click on Moodle Docs for this page link at the bottom of each page in Moodle for accessing context-specific documentation.

Step 3: View the submissions table


Once the deadline for students to submit has passed, click on the assignment. This will bring up the Grading summary which will show the number of participants and submissions.  Click on View all submissions to view the submissions table.

 


The marking/submissions table lists all students and their submissions.  If ‘anonymous submissions’ is enabled submissions are identified by a participant number unique to this assignment. 

Note: Those with a Manager role can view student identities even when ‘anonymous submissions’ is enabled.

The table has a variety of filters and columns - see more details on the submissions table guide.


Step 4: Download grading worksheet

At the top of the submissions table is a drop down box allowing you to choose a Grading action. Select Download grading worksheet from this list and a CSV file of the submissions table will download.

If ‘anonymous submissions’ is not being used then the student name and email will also be included in the spreadsheet. If ‘anonymous submissions’ is enabled, then only those with the Manager role will be able to download this information and teachers and teacher editors will just see the participant number.

Step 5: Download all submissions

At the top of the submissions table, in the Grading action drop down box, select Download all submissions to download all the student submissions into a zip file. As per the submission table, each submission has a unique participant number to identify it.

If the Download submissions in folders box at the bottom of the submission table is ticked then each submission will have its own individual folder. If this is not ticked then the files will just be in one zipped folder.

Step 6: Enter marks into the grading worksheet

Using the participant number to ensure data is entered into the correct record, marks and feedback can then be entered into the grading worksheet under the Grade and Feedback comments column.

Make sure you save the amended worksheet as a CSV file.

Step 7: Upload grading worksheet

At the top of the submissions table, in the Grading action drop down box, select Upload grading worksheet and upload the amended CSV file. The added grades and comments will then be added to the submissions table.


Step 8: Release marks

Marking workflow state

Marking workflow is enabled by default. To release the marks using marking workflow see below

When you are ready to release marks to students, select the submissions for which you want to use marking workflow using the Select box to left of each submission – to select all submissions, click the Select all box under Select. Scroll to the bottom of the page and from the drop-down menu With selected… select Set marking workflow state and Go. You will be asked to confirm, click ok.

Select Released from the drop down options and then save changes. At this stage (and earlier stages) you can choose to Notify students by selecting Yes to generate an email.


Students will then be able to review their grades and feedback.

Note: If ‘anonymous submissions’ is in use with marking workflow, the grades are released regardless of whether student identities have been revealed. However, you and other markers are likely to want to reveal identities at some point. If you cannot find the option Reveal student identities in the Grading action drop-down menu at the top of the submissions table, you will need to ask someone with Teacher (Editor) or higher access to do it.