Uploading Grades to Moodle

2021-05-12

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 Import
Set the Map From and Map To fields 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 Grade and Feedback comments fields to the correct assignment in the Grade and Feedback comments drop-down menu.
Leave everything else as ignore unless you want to use them for a reason.
Upload.

This worked for me. The related Moodle documentation is here.

This page was last rendered on June 29, 2023.