Sometimes faculty like to enter grades into Moodle using Excel rather than directly through Moodle gradebook. This method requires one to export then import the gradebook.
Before following the instructions below, be sure to have the assignments or grade items already established in your gradebook.
- From your course, click the Grades tab.
- Select Export from the drop-down menu on the upper left of the page.
- Choose Excel spreadsheet to the right of “Export as” to ensure the gradebook is exported for Excel, or select another format if you wish. Select the grade items you want to export or export them all and select any other options that apply under the Export format options drop-down.
- Click the [Download] button.
- Open the downloaded Excel file and enter grades in the appropriate columns. Do not add additional columns and do not change the text of any existing columns.
- If a column doesn’t exist in the Excel file, add the assignment or grade item first in Moodle then export it again.
- Save the Excel file as a CSV (Comma Separated Values) file.
- From the course again, click the Grades tab.
- Select Import from the drop-down menu on the upper left of the page.
- Click the [CSV file] tab (if needed, because it should be selected by default).
- Drag and drop the CSV file you just saved to the File box.
- Click the [Upload grades] button.
- IMPORTANT: Within the Identify user by section, set the [Map from] field to Email address and the [Map to] field to Email address.
- Map the grade item or items to the appropriate item or items you graded in Excel. Anything you did not modify or that remains ungraded can be left at the default Ignore.
- Click the [Upload grades] button to finish.