Moodle - Offline Assignment Grading (staff/faculty)
Topics Covered In This Article
Introduction
These instructions will go over offline grading and feedback. These instructions are for Windows, but macOS is similar.
Feedback is provided by downloading all student submissions and adding feedback to them, usually by using track changes if it is a Word document. Once feedback has been added to the files, the feedback files are uploaded to the course and made available to the students.
Grades are provided by downloading a grading worksheet (a spreadsheet) that the grades may be entered into. Once grades have been entered into the grading worksheet it is uploaded to the course to automatically apply the grades in the worksheet to the students for the current assessment.
Group Assignments
Although the group makes a single submission for the whole group, you will receive a copy of this submission for each team member. If you want to provide the same feedback to all group members, you can add the feedback to one file and then make extra copies for the other group members, naming the files for the other group members exactly as they were in the zip. Alternatively, if you want to provide separate feedback for each group member, simply provide feedback to each document as you would with a non-group assignment.
Note that online grading allows you to submit a single feedback file for all group members.
Do not rename folders in the zip
The folder names within the zip are used to identify the students and therefore should not be renamed. The zip file name and the file names can be renamed. If desired, additional feedback files can be added to each student's feedback folder and these feedback files will also become available to the students.
![]()
Enable offline grading worksheet
If you'd like to use the offline grading worksheet, you may need to enable it in the assignment. To enable it, navigate to the assignment, select Settings, scroll down to and expand Feedback types. Ensure Offline grading worksheet is enabled.
![]()
Download student submissions and grading worksheet
The following instructions assume you are using the default zip utility that is built into Windows. If you've installed a program such as WinZip or 7-Zip to be the default handler of zip files the following steps will be similar but not the same.
Navigate to the assignment you are grading and select Submissions.

At the top right, enable Download submissions in folders, select Actions and then select Download all submissions.

From the same menu, select Download grading worksheet. (If you don't see this option, jump to Enable Offline Grading Worksheet and return to this step once you've enabled it)

Record feedback and grades (can be done offline)
Locate the two files. They should be in your Downloads folder.
/moodle-offline-grading-downloads-4.png)
Right click the zip file and click Extract All.
/moodle-offline-grading-extract-all-5.png)
Choose a new location or leave the destination as is. The contents will automatically be extracted into a new folder with the same name as the zip file. Click on the Extract button
/moodle-offline-grading-extract-all-save-6.png)
Navigate to the location where you extracted the files and open the files to edit them and add feedback. There will be a folder for each student, and within that folder will be the student's file submission/s. When saving files after editing, remember not to change the names of any of the folders as they are used to identify which students receive the feedback files.
Open the grading worksheet and add student grades to the grade column. NOTE! If you are using Excel 2010, when saving the grading worksheet it must be saved using the following steps: Select 'File', select 'Save-As', set 'Save as type' to 'CSV (comma delimited)', and then select the 'Save' button. Excel 2010 will otherwise save it as in the wrong format and Moodle will display an error about it not being a CVS file.

Zip the feedback files
Once you have edited the files and provided your feedback, select all of the feedback folders (select one and then click control-A to select all files/folders in that folder), right click one of them, click Send to, and then click Compressed (zipped) folder.

The previous step can be confusing! As shown below, it will create a zip file at the bottom of the list with the same name as one of the files you just zipped, except that it will have a .zip extension and the icon will look different
. You can rename this file if you'd like or upload it to Moodle the way it is (the folders inside zip must have their original names).

Upload feedback zip and grading worksheet
Return to the assignment's Actions menu and select Upload multiple feedback files in a zip.

Drag and drop the zip file into the window to upload the file.

Select Import feedback file(s).

Select Confirm.

Ensure the results are what you were expecting and then select Continue.

Once completed, your feedback files will appear under the Feedback files column (scroll to the right to see it).

Also in the Actions menu, select Upload grading worksheet and submit the grading worksheet in similar steps.

Once completed, you'll see the updated grades in the submissions table.

How to Contact the Computer Services Department
Submit a ticket
To submit a ticket, you will be required to log in using your FULL Royal Roads email address (detailed instructions here)
New! If you do not have a full RRU email address (students not currently in a credit program and/or visitors), you can create a portal account using your personal email address.
Email us at IT Customer Service
Contact Form
Phone: 250-391-2659 Toll Free: 1-866-808-5429
Come visit us in the Sequoia Building
Hours of Operation