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.
Summary
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.
Hi Gavin,
Just a quick shout out to Damyon Wiese from NetSpot who led the development work for this and the other 2.4 assignment enhancements, and to the NetSpot Innovation Fund that provided financial support for the assignment module redevelopment, and to the consortium of universities (the University of Canberra, Flinders University, La Trobe University, the University of New England, the University of Southern Queensland and Massey University) who designed these enhancements – without the combined efforts of all the above these improvements would still be on the ‘wish list’ for the community. Well done to all involved
Mark.
Hi Mark,
Thanks for that background. It is a good example of community helping fund important feature updates in Moodle.
Gav.
If only our school district used something like this. Finally I can fill in grades rather than having to click each one separately.
Grading will go so much faster.