Grade export

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

Grade export is NOT intended for students.

To export grades from the gradebook:

  1. Select 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 submit.
  6. After previewing the data on the following page, click download.

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)

Tips and tricks: For OpenDocument - 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 quizzes, 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.

Index of all help files