Note: You are currently viewing documentation for Moodle 3.2. Up-to-date documentation for the latest stable version of Moodle is probably available here: Grade export.

Grade export: Difference between revisions

From MoodleDocs
(grade publishing)
(steps to export grades, screenshot, default settings)
Line 1: Line 1:
{{Grades}}Grades may be exported in several formats. Select the Grade icon in the course administration block.  In 1.9 use the View pull down menu to select the export format. Download format choices are: Excel spreadsheet, OpenOffice spreadsheet, plain text file or XML file.
{{Grades}}[[Image:Grade export.png|thumb|left|Grade export]]To export grades from the gradebook:
# Choose an export format - Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file - from the gradebook dropdown menu.
# Set options as required.
# If the course uses groups, select whether to export grades for all participants or for a particular group.
# 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.
# Click the submit button.
# After previewing the data on the following page, click the download button.


The report layout and content for each downloading format is robust in 1.9, with many options.  Some of these can be set in "My report preferences", or in the screen which appears after the download format has been selected. 
==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 > [[General grade settings|Grade settings]]''.
 
==Spreadsheet formats==
In general, spreadsheet organize user information they way it is seen. The first few columns contain user information, The grade columns for each activity are placed in the order they appear in the course.  For example, a course section 2 assignment grade column will be placed before a section 3 quiz grade column.
 
==Text format==
 
==XML file formats==
 
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.


==Grade publishing==
==Grade publishing==
[[Image:Grade publishing settings.png|thumb|Grade publishing settings]]
[[Image:Grade publishing settings.png|thumb|left|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 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.



Revision as of 15:56, 19 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 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