Grade export
Grades can be exported in several formats. In the course administration block, select grades. In the course grade window, change the view pull down menu to the best export format. This will bring up an export setting page.
Export setting page
- Confirm the export format - Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file - using the view drop down menu, it can be changed on the settings page
- Each format will have a different set of options
- Options - Grade type, decimal point, lines displayed in preview and feedback export
- Publishing - settings who can see the data without logging into the Moodlesite.
- Grade items to be included - a long list of options. Note that ID numbers are required for all activities for XML file export. An ID number field can be found in the common module settings for each activity
- If the course uses groups, select whether to export grades for all participants or for a particular group via the drop down menu at the top of the page
- Click the submit button
- Preview the data
- Click the download button.
- Save or open the file
Default grade export settings
The grade export display type and grade export decimal points site-wide defaults may be set by an administrator in Administration > Grades > Grade settings.
Grade publishing
Grade publishing is a way of importing and exporting grades via a URL without being logged in to Moodle. Grade publishing is intended for administrators only, due to the security implications.
Grade publishing is disabled by default. It can be enabled by an administrator by checking the gradepublishing box in Administration > Grades > Grade settings. Users with grade publishing capabilities (normally administrators only) are then provided with grade export publishing settings.