Grades: Importing Grades From A Spreadsheet
Instructors have the option to importing grades into the gradebook by pasting from a spreadsheet. This is helpful if you have grades you have compiled outside of Moodle.
To Import from a Spreadsheet:
- Create a simple spreadsheet with a column for student identifier (such as user name or e-mail address) and columns for activities. The activity names do not need to match exactly what is in your gradebook.
- Access the Grader Report by locating the Navigation Drawer on the left side and selecting Grades.
- Note: If you do not see the Navigation Drawer, click the button with three horizontal bars in the top left to toggle it on.
- Note: If you do not see the Navigation Drawer, click the button with three horizontal bars in the top left to toggle it on.
- Select the Import tab from the top row of tabs on the Grader Report.
- Select the Paste From Spreadsheet tab from the second row of tabs.
- Copy and paste the contents of your spreadsheet into the Data box.
- Click Upload Grades.
- Ensure the data under the Import Preview table looks correct on the preview page.
- Select the correct user and grade item mappings by using the drop-down boxes under the Identify User By and Grade Item Mappings
- As an example, say a spreadsheet had columns titled “username” and “Assignment 1”. In Moodle, “username” will be mapped to Username, and “Assignment 1” will need to be mapped to the exact title as it appears in the course. In this case, Lesson 1 Reading Assignment.
- Note: The user field (“username,” for example) will also appear under Grade Item Mappings. Leave this field as Ignore, because the user is not a grade field.
- As an example, say a spreadsheet had columns titled “username” and “Assignment 1”. In Moodle, “username” will be mapped to Username, and “Assignment 1” will need to be mapped to the exact title as it appears in the course. In this case, Lesson 1 Reading Assignment.
- Click Upload Grades.
