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

Grade export: Difference between revisions

From MoodleDocs
(→‎Export setting page: rewrite instructions in order, see page comment)
 
(16 intermediate revisions by 7 users not shown)
Line 1: Line 1:
{{Grades}}
{{Grades}}Grades can be exported to Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file.
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==
''Grade export is NOT intended for students.''
[[Image:Grade export.png|thumb|center|Moodle Version 1.x Export settings page: Open Office spreadsheet format]]
 
# 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
==How to export grades==
# Each format will have a different set of options
[[Image:Grade export.png|thumb|left|Grade export]]To export grades from the gradebook:
## Options - Grade type, decimal point, lines displayed in preview and feedback export
# Choose an export format from the gradebook dropdown menu.
## Publishing - settings who can see the data without logging into the Moodlesite.
# Set options as required.
## 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.
## 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
# 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
# Click the submit button.
# Preview the data
# After previewing the data on the following page, click the download button.
# Click the download button.
 
# Save or open the file
==XML file export==
 
To export grades to XML file, you need to ensure that:
* Users have ID numbers (an optional field in the user profile)
* Activities have ID numbers (an optional field in the common module settings)
 
'''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==
==Default grade export settings==
Line 24: Line 35:


Grade publishing is disabled by default. It can be enabled by an administrator by checking the gradepublishing box in ''Administration > Grades > [[General grade settings|Grade settings]]''. Users with grade publishing capabilities (normally administrators only) are then provided with grade export publishing settings.
Grade publishing is disabled by default. It can be enabled by an administrator by checking the gradepublishing box in ''Administration > Grades > [[General grade settings|Grade settings]]''. Users with grade publishing capabilities (normally administrators only) are then provided with grade export publishing settings.
To determine the URL for exporting grades, follow an export format link e.g. XML file, select a user key or 'Create a new key' to generate a new one, select other options as required, then click the Submit button. A download URL e.g. <code><nowiki>http://qa.moodle.net/grade/export/xml/dump.php?id=2&groupid=&itemids=-1&export_letters=&export_feedback=0&updatedgradesonly=0&displaytype=1&decimalpoints=2&key=ed18257297c48d15096dd49c1d09ac06</nowiki></code> will then be provided.
==Tips and tricks==
*Export grades in a spreadsheet format.  Then copy and paste that information into another file that has  worksheet ("raw grades"). Create other worksheets which are custom reports which take their data from "raw grades". This works if graded activities are '''not''' moved around to different positions in the course. This allows you to create a standard printed report(s). For example a compact landscape report of all students and all grades for each activity, a report of just quizes, another of lessons, another of assignments. A pivot table of students by scores, generated from a report worksheet, which gets its data from the raw data.
*Mailmerge exported grades into custom documents.  For example, a document that is given to a department to file as a proof of training, with scores for every subject quiz.


==See also==
==See also==


*[http://www.youtube.com/watch?v=yZcbN_7p2zI Video showing how to exporting grades in Moodle 1.9]
*[http://www.youtube.com/watch?v=yZcbN_7p2zI Video showing how to export grades in Moodle 1.9]
 


[[ca:grade/export/xml/index]]
[[es:Exportar_calificaciones]]
[[fr:Exportation des notes]]
[[fr:Exportation des notes]]
[[ja:評定のエクスポート]]

Latest revision as of 07:25, 7 August 2014

Grades can be exported to Excel spreadsheet, OpenDocument spreadsheet, plain text file or XML file.

Grade export is NOT intended for students.

How to export grades

Grade export

To export grades from the gradebook:

  1. Choose an export format 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.

XML file export

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

  • Users have ID numbers (an optional field in the user profile)
  • Activities have ID numbers (an optional field in the common module settings)

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 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.

To determine the URL for exporting grades, follow an export format link e.g. XML file, select a user key or 'Create a new key' to generate a new one, select other options as required, then click the Submit button. A download URL e.g. http://qa.moodle.net/grade/export/xml/dump.php?id=2&groupid=&itemids=-1&export_letters=&export_feedback=0&updatedgradesonly=0&displaytype=1&decimalpoints=2&key=ed18257297c48d15096dd49c1d09ac06 will then be provided.

Tips and tricks

  • Export grades in a spreadsheet format. Then copy and paste that information into another file that has worksheet ("raw grades"). Create other worksheets which are custom reports which take their data from "raw grades". This works if graded activities are not moved around to different positions in the course. This allows you to create a standard printed report(s). For example a compact landscape report of all students and all grades for each activity, a report of just quizes, another of lessons, another of assignments. A pivot table of students by scores, generated from a report worksheet, which gets its data from the raw data.
  • Mailmerge exported grades into custom documents. For example, a document that is given to a department to file as a proof of training, with scores for every subject quiz.

See also