Moodle allows you to take data from your gradebook and export it to your own computer so you can modify values or input them into your own grading system (e.g. if you use advanced formulas to compute grades and prefer to work in a program like Excel). Moodle exports grades in the following file formats:
-
- Plain text file .CSV (default)
- Excel Spreadsheet .XLSX
- XML file
- OpenDocument spreadsheet
Along with the grade items you select for export, the export will include First name, Last name, ID number, and Email address.
Exporting data
- On your course page, in the Administration block, click Grades. The gradebook will open to the Grader report.
- In the navigation tabs (at top), click Export. The Export to Plain text file page will open.
- To change the file format from the default (Plain text file .CSV), below the Export tab, click the tab for a different file type.
- Under Grade items to be included, select the checkboxes for the columns to download.
Note: By default, every column in your gradebook will be included. At the top or bottom of the list, you can click Select all/none to make selecting columns more efficient.
- Under Export format options, select the checkboxes for the settings you wish to change.
- Include feedback in export: Include a column in the exported file for existing feedback or to add feedback for future upload.
- Require active enrollment: Only include students in the export whose enrollment is active and has not been suspended.
- Export new or updated grades only: Exports only grades that have been changed since the most recent import. Note: This option is only available for XML file export.
- Grade export display types: Select which grade format(s) you wish to include in the export. Each format will be in a new column.
- Grade export decimal points: Select the number of decimal points to be reported. Values range from 0 to 5.
- Separator: Select the delimiter for the text. Note: This option is only available for Plain text file export.
- Click Download to start downloading your file.
- Find the file in the downloads area. It will be called [name-of-your-course Grades].
Getting assistance with grades
If you need help with assistance with Moodle grading or the Moodle gradebook, contact the Office of Instructional Design (InstructionalDesign@northcentral.edu).