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).

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 to access context-specific documentation.

Step 2: Students submit

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.

Screenshot of the Teacher (editor) view of the assignment activity on Moodle. A red box is highlighting the 'view all submissions' button.

 


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.

Screenshot of the Teacher (editor) view of the submissions page of the assignment activity on Moodle. The grading actions menu is displayed with the 'Download grading worksheet' highlighted

 

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

  1. Open the grading worksheet .csv file in a spreadsheet editor e.g. Excel.

  2. 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.

  3. Save the .csv file.

Note:

  1. Make sure you enter data in the correct column of the spreadsheet.

  2. 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.