Refer to Offline
Grading
article to ensure Offline grading worksheet is
checked in assignment settings.
- To download the grading worksheet, return to the Moodle Assignment page and go to the Submissions tab.
- Expand the Actions tab and select Download grading worksheet. Ensure to save the file to a secure location (keep its .csv file format).Remember, offline grading cannot be used if you have enabled advanced grading methods such as Rubrics or Grading Forms.
After downloading the
submissions
and the grading worksheet:
- Open a downloaded submission to review
it.
- Open the csv file in a spreadsheet
editor,
e.g. MS Excel.
- For each submission, enter grades in
the Grade column and summary
comments
in the Feedback comments column.
Leave the other data untouched.
- Repeat as needed and save the csv file. Enter grades Enter feedback comments
Note: Take care to enter data in the correct column of the spreadsheet
- When you are ready to upload grades
and
summary feedback, click on the
assignment
name
on the Moodle course homepage and go
to the Submissions tab.
- From the Actions drop-down menu choose Upload grading worksheet.
- Select the grading worksheet file and add it in the Upload a file section. All other settings should remain at default.
- Click Upload grading worksheet; a Confirmation box displays the students’ grades and feedback that will be imported – check this carefully.
- If you are ready to proceed, click Confirm; a summary of updates displays.
- Click Continue.
Note: Ensure you adhere to MIC GDPR guidelines when downloading student assignment submissions.