Uploading Grades to Moodle
Small note about how to upload grades to Moodle.
One of the teaching assistants contacted me earlier with a problem uploading grades to Moodle. I've not used Moodle much before this semester but it's pretty straightforward if a bit sprawling. The interface is a bit of a strain also, with many clicks to get where you want to.
There was a problem with uploading a spreadsheet of grades. After a bit of playing around with it, it seems like the data that we were using in the identifier field wasn't lining up with the user ids stored in the system. The mapping happens at the
Map From and
Map To field. So I tried another unique identifier -
email address - and this worked fine. The process that worked is:
- Export the grading sheet for the assignment as a .csv file.
- Use this as a template for the upload.
- After selecting the grading dashboard from the left hand side menu, select
- Set the
Map Tofields to something that is unique and you know will work. In this case this was the email address since the User ID seemed to be failing.
- Set the
Feedback commentsfields to the correct assignment in the Grade and Feedback comments drop-down menu.
- Leave everything else as
ignoreunless you want to use them for a reason.
This worked for me. The related Moodle documentation is here.