As well as grading within Moodle, you can prepare all your grades and comments in a separate Excel file, which you can then upload to the Grader report area.
This page tells you how to upload such a file.
When to use
Enter marks and comments in an Excel spreadsheet offline, when you have a large quantity of assignments to mark, or if your in-Moodle marking is likely to be disrupted by a poor Internet connection.
Teachers report that uploading an Excel file is a much faster and easier way of managing student marks and comments than entering them within the Moodle Gradebook, especially with large class sizes.
Step by step instructions
- In the Moodle Gradebook for the course, create a grade item for the uploaded grades to sit in if one does not already exist.
- Export the Gradebook of the grade item you just created.
- Open the downloaded Excel file and add the grades in the appropriate column. You can also add some feedback into the Feedback column.
- Save the Excel file as type a CSV file.
- In Moodle, in the Gradebook setup page, in the Settings block select Grade administration > Import > CSV file.
- In the Import file page, either drag and drop a file into the File box or click Choose a file and upload a file using the File picker. Then:
- At Encoding, select the first option in the drop-down list.
- At Separator, select Comma, if necessary.
- At Verbose scales, if you marked using text (Pass, Fail, Credit etc.) instead of numeric grades, select Yes.
- At Force import, if you wish to force importing check the box. It is recommended that you do not check this box.
- Click Upload grades.
- In the Import preview page, under Identify user by:
- At Map from, select Username.
- Map to, by default, is set to Username.
- Under Grade item mappings, from the drop-down menu for the grade item you are importing, select the matching item.
- Click Upload grades.
- A "Grade import success" message will display. Click Continue to view the grades in the Gradebook.
For more detailed information about uploading grades to the Gradebook, see this resource:
- California State University Northridge, "Moodle Gradebook"
The screens in this document may look a little different from UNSW Moodle 2 screens, but the information is essentially the same.
If you experience technical or other issues, consult the Where to get help page.