Grade export

Grades

Grades can be exported to Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file, or published via a URL.

Grade export is NOT intended for students.


Contents


How to export grades

To export grades from the gradebook:

  1. Choose an export format from the gradebook dropdown menu or in the Administration block under Grade administration > Export.
  2. Set options as required.
  3. If the course uses groups, select whether to export grades for all participants or for a particular group.
  4. Select the grade items to be included. 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.
  5. Click the export button.


XML file export

To export grades to XML file, you need to ensure that:


Export new or updated grades only

To export only new or updated grades you need to enable XML File in Grades > General settings > Primary grade export methods (gradeexport).

After this setting has been enabled, the XML File option will then set and use a "last exported" field for every grade. The result will export the records with the <state> tag being identified as new or regraded.

This means the report will track the last exported date. If you export and then try again, it will not show any results because there are no new or updated grades since the last export.


Default grade export settings

The grade export display type and grade export decimal points site-wide defaults may be set by an administrator in Site administration > Grades > General settings.


User profile fields export

An administrator can specify user profile fields and custom profile fields to be included in the grade export in Site administration > Grades > General 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 > Site administration > Grades > General settings. Users with grade publishing capabilities (normally managers only) will then be able to access the grade publishing options.

To publish grades from the gradebook:

  1. Follow the first four steps above for 'How to export grades'.
  2. In the grade publishing options, choose 'Create a new user key' or select a key generated previously.
  3. Click the export button. A download URL will then be displayed.


Grade export capabilities


Tips and tricks


See also