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
(Reformat page, Create intro, add How to section)
Line 23: Line 23:


==Tips and tricks==
==Tips and tricks==
*Export grades in a spreadsheet format.  Then copy and paste that information into a 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.
*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.  
*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==

Revision as of 15:39, 12 December 2008

Grades can be exported as a Excel spreadsheets OpenDocument spreadsheet, plain text file or XML file formats.

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.

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.


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