How to generate and use marks sheet reports

How to generate and use marks sheet reports

The Marks Sheets module provides a suite of reporting tools to audit, verify, and export learner performance data. These reports ensure that internal school marks align with DBE requirements and provide transparent mark calculations for stakeholders.

Reports > Learners > Marks and Achievements: Marks Sheets

What mark sheet report types are available?

  • Captured Marks Verification Sheet — shows marks per individual task and assessment, identifying missing marks. Can be sorted by subject or teacher. Left learners still linked to subjects will appear here; remove them from the relevant Subject Group and Subject Choice to exclude them from official DOE schedules.

  • Calculated Mark Sheet — displays marks alongside their proportional weightings. Options include Empty (blank grid), With Mark Out Of (raw scores only), With Weighted Marks (raw scores + weighted percentages), or With Raw Marks (all raw data + final totals). Optionally include Task Averages and Symbol Spread.

  • Detailed Mark Sheet — a per-learner, per-subject breakdown of every assessment contribution. Primary tool for resolving parental queries about mark calculations.

  • Subjects Mark Sheet — a consolidated view of final calculated subject marks per learner across an entire class or grade.

  • Working Marks Sheet (Excel Optimised) — exports term marks to Excel for copying into official DOE schedules. Filter by Subject Group, Register Class, or All Learners. Requires Excel Export rights on the user profile.

Frequently asked questions

Why do left learners appear on the Verification Sheet?

Left learners who were active during any part of the term remain linked to subjects by default to maintain compliance with attendance-linked mark requirements. To remove them from official DOE schedules, remove them from the specific Subject Group and Subject Choice for the active term.

Why is the Working Marks Sheet (Excel) not available to me?

The Excel export option is restricted to users with May use Excel export function rights. Contact your Superuser to have this right assigned to your profile.

Why do the calculated marks not match what I expect?

Discrepancies between raw marks and final percentages are usually caused by weighting configurations in the Curriculum Setup. All reports pull directly from the Setup Learning Programme weightings — review the Template Formula or Subject-Specific Formula setup at My School > Curriculum.

Last updated: April 2026  |  Version 10.0

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

    • Generate a composite recording sheet

      The Composite Recording Sheet provides a breakdown of assessment types per term, per subject (SBA, Exam, PAT, ANA). The Mark Types (Promotion, Merit, and Year Mark) can also be verified with this report if set up under year-end formulas. This report ...
    • Formula Calculation Sheet

      The Formula Calculation Sheet shows the complete calculation analysis of the promotion mark according to the Template Formula or Subject-Specific Formula setup in the system. Use this report to verify how marks are weighted and calculated before ...
    • Generate a Composite Recording Sheet

      The Composite Recording Sheet generates a composite mark recording sheet for DOE reporting. It displays academic performance per grade across multiple subjects, terms and assessment types. Reports > DOE > Curriculum: Composite Recording Sheet How do ...
    • 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 export a DOE Marks Schedule

      Marks schedules can be exported to Excel to comply with Department of Education requirements and accommodate district and provincial variances. This process allows administrators to customise and manage marks data according to specific compliance ...