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

Moodle Version 1.x Export settings page: Open Office spreadsheet format

1. 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
2. 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
3. Each format may have slightly different settings. There are 3 sections of settings.
   1. Options - Grade type, decimal point, lines displayed in preview and feedback export
   2. Publishing - settings who can see the data without logging into the Moodlesite.
   3. 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
4. Click the submit button
5. Preview the data
6. Click the download button.
7. 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 settings

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.

See also

• Video showing how to exporting grades in Moodle 1.9