Digital Education Wiki Spaces
Accessibility — Assessment — CampusPress Guides — Digital Education — Gradescope Guides — Learning Technology Good Practice — Lecture Recording — Moodle for Learning — Moodle Baseline — Moodle How-Tos — Multimedia — Student Online Learning — Zoom
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 submissions from the secondary navigation bar 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 button allowing you to choose an 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 button, 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 above the submissions 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
Open the grading worksheet .csv file in a spreadsheet editor e.g. Excel.
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.
Save the .csv file.
Note:
Make sure you enter data in the correct column of the spreadsheet.
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, 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 the marking workflow see below.
When you are ready to release marks to students, go to the submissions table. Select the submissions for which you want to change the state of the marking workflow using the Select box to left of each submission – to select all submissions, click the Select all box under Select.
At the bottom of the page, additional actions will appear on the sticky menu. Click the “More” button on the menu to reveal Change marking state and select this option. A pop-up window will appear, confirm the option to “change marking state”.
On the next screen, 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.
N.B. If ‘anonymous submissions’ is in use with marking workflow, you will need to reveal student identities before the grades are released. To do this, select Reveal student identities in the Grading action drop-down menu at the top of the submissions table. If you cannot find this option, you will need to ask someone with Teacher (Editor) or higher access to do it.
These pages are created by the LSE Digital Education Team and licensed under a Creative Commons Attribution-ShareAlike 4.0 International License CC BY-SA 4.0