This guide will walk you through uploading feedback and grades via an Excel spreadsheet. This option is useful for large groups of students, where operational feedback left directly on the student assignment is not required.
This option can be used when the Anonymous submissions setting has been enabled for the assignment. The student names on the downloaded assignments and in the Grading worksheet are replaced by a Participant ID. You will have to take care to ensure you are adding the grade for the correct student to the Grading worksheet by double checking the participant IDs between the downloaded assignment name and the Identifier column in the Grading worksheet.
You must hide the individual assignment grade item while you are marking to ensure that marks and feedback are released at the same time to all students. To do this:
If you are working on an anonymous submission, the student names are removed and are replaced by a Participant ID. This participant ID will also be included in the file name of the downloaded assignment. You will have to take care to ensure you are adding the Grade for the correct student to to Grading worksheet by double checking the participant IDs.
This makes the grades and feedback visible and generates an email to students to alert them to their released grade and feedback.
When an assignment is set up with anonymous marking, you must unhide the grade item and reveal student identities in order to release grades and feedback.
When an assignment is set up with anonymous marking, you must unhide the grade item and reveal student identities in order to release grades and feedback.