Note: You are currently viewing documentation for Moodle 3.8. Up-to-date documentation for the latest stable version of Moodle may be available here: Grade export.

Grade export: Difference between revisions

From MoodleDocs
(→‎Export setting page: publish must be enabled)
(reverting to previous simpler revision of page with same style as similar pages)
Line 1: Line 1:
{{Grades}}
{{Grades}}[[Image:Grade export.png|thumb|left|Grade export]]To export grades from the gradebook:
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.
# Choose an export format - Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file - from the gradebook dropdown menu.
 
# Set options as required.
==Export setting page==
# If the course uses groups, select whether to export grades for all participants or for a particular group.
[[Image:Grade export.png|thumb|center|Moodle Version 1.x Export settings page: Open Office spreadsheet format]]
# 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.
# 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
# Click the submit button.
#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
# After previewing the data on the following page, click the download button.
# Each format may have slightly different settings. There are 3 sections of settings.
## Options - Grade type, decimal point, lines displayed in preview and feedback export
## Publishing - feature must be enabled see [[Grade_export#Grade_publishing|settings]]
## 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
# Click the submit button
# Preview the data  
# Click the download button.
# Save or open the file


==Default grade export settings==
==Default grade export settings==

Revision as of 15:38, 24 February 2008

Grade export

To export grades from the gradebook:

  1. Choose an export format - Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file - from the gradebook dropdown menu.
  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 submit button.
  6. After previewing the data on the following page, click the download button.

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