How to export marks and statistics

How to export marks and statistics

The Export Marks and Statistics function allows users to extract comprehensive academic data to Excel. This tool is essential for external reporting, data verification before printing reports, and analysing academic performance across phases.

My School > People: Learners > Learner Marks: Export Marks and Statistics

Purpose of the function

Use this function to export marks and statistics for one or more phases to an Excel file. The export is suitable for external reporting, data verification before printing reports, and academic performance analysis.

How do I export marks and statistics?

Step 1: Filter and selection

  1. Select the relevant Academic Year from the drop-down lists.

  2. Select the correct Phase (e.g. Foundation Phase, Intermediate Phase, etc.) for which data is required.

Step 2: Learner type definition

Select the appropriate learner status to define the scope of the report:

  • Current Learners: Includes all active learners, including those leaving the school only at the end of the term.

  • All Learners: Includes every learner on the system, including waiting list learners who have already been assigned subjects.

Step 3: Generating the report

  1. Click the Export button.

  2. The system will generate an Excel file and automatically download it to your computer.

Frequently asked questions

Why are some learners' marks blank in the Excel file?

This usually occurs when marks have not yet been saved in the Marks per Learner or Marks per Group modules, or if the learner is not correctly linked to the specific subjects for that term.

What is the difference between 'Current' and 'All' learners in the export?

The 'Current learners' filter excludes learners who have already left the school. 'All learners' is a full database extract useful for historical records or checking whether waiting list learners have been incorrectly assigned marks.

Why does the export take a long time to generate?

The speed depends on the volume of data (e.g. if an entire phase's marks across multiple terms are extracted simultaneously). It is recommended to export per phase or per term for faster results.

Last updated: March 2026  |  Version 1.2

© Copyright d6 group (Pty) Ltd.
    • Related Articles

    • How to capture marks for learners — Educator quick guide

      A quick-reference guide for educators on how to capture, verify and export learner marks using the d6 platform. My School > People: Learners > Learner Marks > Marks per Group How do I get access? Your admin needs to give you marks capture rights at ...
    • How to export marks to Excel

      The Export Marks and Statistics function exports all learner marks for a selected year and phase to Excel for departmental submissions. My School > People: Learners > Learner Marks: Export Marks and Statistics How do I export marks to Excel? Navigate ...
    • How to capture marks for learners - Educator complete guide

      This guide walks educators through every step of capturing marks for learners on the d6 platform, from checking access rights through entering marks to generating reports. My School > People: Learners > Learner Marks > Marks per Group How do I get ...
    • How to capture marks for learners - Educator quick guide

      A quick-reference guide for educators on how to capture, verify and export learner marks using the d6 platform. My School > People: Learners > Learner Marks > Marks per Group How do I get access? Your admin needs to give you marks capture rights at ...
    • Marks Statistics

      The Marks Statistics report provides a high-level analytical overview of academic performance per subject and grade. It is used by school management and Heads of Department to monitor academic standards and identify risk areas. Reports > Learners > ...