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.
- Click Upload Grades.
Interested in learning more about grading and feedback in your online course? Feel free to explore the following article on our Center for Teaching and Learning: