One of the very useful new features in Moodle 2.4 Assignment is the Grading worksheet uploading. I had mentioned in the post about Blind Marking but this post will explain the process more fully.
So what is the Grading Worksheet option?
For this example, I am setting up an assignment on a course that has 10 students. This assignment is just going to be a placeholder assignment (Like the old style offline assignment) where the grades / comments from a practical can be added. So I have set it up with the following settings:
So once you create the assignment, you can then go then go into the view/grade all submissions page to access quick grading or the other options available from the drop down such as Download grading worksheet.
Selecting the Download grading worksheet will prompt for the spreadsheet (CSV) to be downloaded. Once opened in Excel it looked like the following:
This enables you to add a grade and a comment for each participant. Once you have added them in as below, you can then go through the upload process.
By selecting the Upload Grading worksheet option, you are brough to a standard upload page with one exception.
Once you upload the file and submit, you are prompted to confirm the changes as shown below.
After you confirm, the assignment and gradebook are updated. The grading page with the new data is shown below:
If you want to late change the grades using a worksheet you can download the existing values, change it and upload the new one. It works the same way. Below it shows the confirm page for when I went back in and set the grades all to 100.
This is going to be a heavily used feature for Moodle Assignment and will save a lot of time for graders. Of course it is not only good for “offline” assignments like a practical, as if you are updating it locally from manually graded papers, this will also be very useful.