Template combinations
A markbook template is a set of columns in three zones: the Target area (once a year, at the left), the Reporting period zone (repeated in every checkpoint) and the Final period zone (only in the last checkpoint). This page gives tried combinations for common school types. Copy the one closest to your school, then adjust.
Where: open a template under Configuration → Assessment → Markbook Templates, tab Template settings, section Build the markbook grid. Use Add column in each zone, then Save value types. You need the Markbook templates permission. New column kinds are created under Columns Configurations (link at the top of the Templates page), which needs the Value types permission.
The column names below are the ones MarkBook installs (Target Grade, Current Grade …). Columns marked new you create yourself with New value type. See Column Library (Value Types).
1. British secondary (Key Stage 4)
Scale: GCSE 9–1. Periods: three terms split into half terms. See British (UK).
| Zone | Column | Data type | Notes |
|---|---|---|---|
| Target area | Target Grade (TG) | Grade label | Set once a year, often imported |
| Target area | Personalised Target (PTG) | Grade label | Optional stretch target |
| Reporting period | Current Grade (CG) | Grade label | Working-at grade, every data drop |
| Reporting period | Predicted Grade (Pred) new | Grade label | Years 10–11 |
| Reporting period | Effort Grade (Eff) | Judgement scale | Effort 1–4 |
| Reporting period | Report Grade (RG) | Grade label | Locks when the report is published |
| Reporting period | VA Grade (VA) | Calculated | RG - TG, signed, value-added colours |
| Reporting period | Teacher Comment (TC) | Text | |
| Final period | End of Year Grade (EoY) | Grade label |
Tip: if reports go home only at T1B, T2B and T3B, keep RG and TC there and disable them in the "A" half terms (click their cells in the Live preview).
2. British secondary (Key Stage 3, no GCSE grades yet)
Scale: your own KS3 scale, for example Emerging – Mastery or Below – Above expected.
| Zone | Column | Data type |
|---|---|---|
| Target area | Target Grade | Grade label (KS3 scale) |
| Reporting period | Current Grade | Grade label |
| Reporting period | Progress Grade (Prog) | Judgement scale: Below / Expected / Above |
| Reporting period | Effort Grade | Judgement scale |
| Reporting period | Teacher Comment | Text |
| Final period | End of Year Grade | Grade label |
3. British primary
Scale: Below – Above expected. Periods: three terms.
| Zone | Column | Data type |
|---|---|---|
| Reporting period | Current Grade | Grade label |
| Reporting period | Effort Grade | Judgement scale |
| Reporting period | Teacher Comment | Text |
| Final period | End of Year Grade | Grade label |
Year 6: add KS2 TA (new, grade label WTS / EXS / GDS) and KS2 test (new, grade label NS / EXS / HS) in the Final period zone.
4. Early Years (EYFS)
Scale: Emerging – Mastery during the year, ELG (Emerging / Expected) at the end. Subjects are the seven areas.
| Zone | Column | Data type |
|---|---|---|
| Reporting period | Current Grade | Grade label (Emerging – Mastery) |
| Reporting period | ATL | Judgement scale (Attitude to learning — EYFS) |
| Reporting period | Teacher Comment | Text |
| Final period | ELG judgement new | Grade label (ELG) |
Judge each Early Learning Goal as a learning outcome rather than a column. See Learning Outcomes Overview.
5. US high school, weighted categories
Scale: Letter grades +/− with GPA points. Periods: semesters with quarters. See American (US).
| Zone | Column | Data type | Formula / note |
|---|---|---|---|
| Reporting period | Homework (HW) new | Number | % |
| Reporting period | Quizzes (QZ) new | Number | % |
| Reporting period | Tests (TST) new | Number | % |
| Reporting period | Projects (PRJ) new | Number | % |
| Reporting period | Participation (PART) new | Number | % |
| Reporting period | Q1G … Q4G new | Calculated | 0.1*HW + 0.2*QZ + 0.4*TST + 0.2*PRJ + 0.1*PART, each in its own quarter |
| Reporting period | EX1, EX2 new | Number | Semester exams, in Q2 and Q4 |
| Reporting period | S1, S2 new | Calculated | 0.4*Q1G + 0.4*Q2G + 0.2*EX1 in Q2; same for S2 in Q4 |
| Reporting period | Report Letter (LTR) new | Grade label | The official letter |
| Final period | Final Grade (FIN) new | Calculated | avg(S1, S2) |
6. IB Diploma
Scale: IB 1–7 (installed by the wizard with Curriculum International Baccalaureate).
| Zone | Column | Data type |
|---|---|---|
| Target area | Target Grade | Grade label (IB 1–7) |
| Reporting period | Current Grade | Grade label |
| Reporting period | Predicted Grade new | Grade label |
| Reporting period | ATL | Judgement scale |
| Reporting period | Teacher Comment | Text |
| Final period | End of Year Grade | Grade label |
7. Romanian gimnaziu (classes V–VIII)
Scale: Note 1–10. Periods: one period for the whole school year, because only an annual average is closed (since 2024). See Romanian.
| Zone | Column | Data type | Formula / note |
|---|---|---|---|
| Reporting period | N1 … N10 new | Grade label | One per mark: at least lessons a week plus three |
| Reporting period | MA new | Calculated | round(avg(N1, …, N10)), 0 decimals |
Conduct on its own subject: P1 … P5 (grade label, one per learning interval), ABS (number, unjustified absences) and MP = round(avg(P1, P2, P3, P4, P5) - floor(ABS / 20)).
8. Polish szkoła podstawowa (class IV upwards)
Scales: Oceny bieżące 1–6 (with + and −) and Oceny klasyfikacyjne 1–6. Periods: two half-years. See Polish.
| Zone | Column | Data type | Formula / note |
|---|---|---|---|
| Reporting period | S1, S2, K1, K2, O1, Z1, A1 new | Grade label | Tests, quizzes, oral, homework, activity |
| Reporting period | SR1, SR2 new | Calculated | (3*S1 + 3*S2 + 2*K1 + 2*K2 + 2*O1 + Z1 + A1) / 14, one per half-year |
| Reporting period | Ocena śródroczna (OS) new | Grade label | Half-year I only |
| Final period | SRR new | Calculated | avg(SR1, SR2) |
| Final period | Ocena roczna (OR) new | Grade label |
9. Bulgarian (classes IV–XII)
Scale: Оценки 2–6. Periods: two terms. See Bulgarian.
| Zone | Column | Data type | Formula / note |
|---|---|---|---|
| Reporting period | T1 … T4 new | Grade label | Текущи оценки |
| Reporting period | SU new | Calculated | avg(T1, T2, T3, T4), 2 decimals, band colours |
| Reporting period | SO1, SO2 new | Grade label | Срочна оценка, one per term |
| Final period | GS new | Calculated | avg(SO1, SO2) |
| Final period | GO new | Grade label | Годишна оценка |
Rules that apply to every combination
- One template per grading pattern. Year groups that grade the same way share a template. A different scale or different columns means a separate template, or a per-subject scale on the Template content tab.
- A formula only sees columns on the same template. Add every column a formula names. A column that is not on the template is not read.
- Keep a column in one period with the Live preview. Click its cell under a period to disable it there. This is how "one column per term" works in the Romanian, Polish, Bulgarian and US examples.
- Choose who sees what. On each value type, Show in printed report and Show in student/parent grid decide whether families see it. Raw homework columns are usually teacher-only.
- Lock what goes on a report. Report Grade and End of Year Grade are installed with Read-only once the report is published on.