Overview
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.
Benefits
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.
Guide
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, selecting the grade item you just created.
- Open the downloaded Excel file and add the grades in the appropriate column. If you wish, you can create an additional column for comments—in row 1, add the column heading Comments.
- Save the file as type CSV (Comma delimited).
- In Moodle, in the Gradebook for the course, in the Settings block select 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 Windows 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.
Additional information
External resources
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.
Further assistance
If you experience technical or other issues, consult the Where to get help page.