CHAPTER 4
Why Your Markbook Is Slowing Everyone Down And What to Do About It.
When grade entry happens in one system and reports live in another, the gap between them costs your staff hours they don’t have and hides the data that would help your students most.
The markbook is where a teacher’s professional judgement about a student’s progress becomes data. It is the record of what was assessed, what was scored, and how that performance compared to the group. Used well, it is one of the most powerful tools a school has for identifying who needs support, celebrating who is excelling, and making sure that no student quietly falls behind without anyone noticing. In most schools, it is a spreadsheet. And it doesn’t talk to anything else.
The disconnected markbook problem
Ask a teacher in most schools how their markbook connects to the rest of the school’s systems and the honest answer is usually: it doesn’t. Grades are entered into a spreadsheet, a standalone app, or a tool the teacher chose themselves because it happened to suit how they work. At report time, those grades are manually transferred — typed, copied, or exported — into whatever system produces the report card. The data makes the journey twice, and somewhere in that journey, things go wrong.
The errors are rarely dramatic. A grade transposed from one column to another. A student’s average calculated from an incomplete set of results because one assessment was added after the export. A comment that references a test score that doesn’t match what appears on the report because the versions didn’t sync. Individually, each of these is a small mistake. Collectively, they are a steady erosion of the accuracy that parents and students should be able to rely on.
But the disconnected markbook problem is not just about accuracy. It is about visibility. When each teacher manages their own grade records in their own system, nobody above classroom level can see the full picture. A head of year cannot look across three subjects and identify which students are struggling in all of them simultaneously. A pastoral leader cannot see that a student’s grades have declined significantly over the past six weeks in a way that correlates with a change in attendance. The data exists — but it lives in silos that nobody other than the individual teacher can access.
“We had eight teachers keeping eight separate spreadsheets. At the end of term we had eight different formats, eight different ways of calculating averages, and eight different opinions about what ‘meeting expectations’ meant.”
— Head of Year, international secondary school
For international schools, this is compounded by the fact that teachers may be following different curricula, using different grading scales, and working in different languages. A system that relies on individual teachers to maintain their own grade records in their own format will produce data that cannot meaningfully be compared across the school — even when the underlying question is the same: how is this student doing?
SCREENSHOT Staff web app: Markbook view with coloured cells
Caption: The Schooly markbook with coloured cells enabled — students performing above and below the class average identified instantly, without a formula or a pivot table.
Â
What a markbook should actually do
A markbook is not a filing system. Its job is not to store grades — it is to make grades useful. There is a meaningful difference between a system that holds assessment data and a system that helps teachers and school leaders act on it. Most schools have the former. The latter requires four things that a spreadsheet cannot provide.
None of these capabilities require complex data science. They require a markbook that is built to do more than store numbers — one that calculates, compares, and highlights automatically, so that the professional work of a teacher or pastoral leader is spent on responding to what the data shows, not on producing the analysis manually.
Â
The standardisation problem most schools don’t realise they have
When a school runs multiple assessments across a term — a mid-term test marked out of 40, a coursework piece marked out of 75, an end-of-term exam marked out of 100 — comparing a student’s performance across these assessments is not straightforward. A student who scores 32/40 on the mid-term and 58/75 on the coursework has done well on both — but which performance is stronger? Without standardisation, the question is genuinely difficult to answer.
The solution is to convert all scores to a percentage before comparison. It sounds obvious — but in a school where each teacher manages their own spreadsheet, standardisation is a manual step that may or may not happen consistently. One teacher calculates percentages. Another compares raw scores. A third doesn’t compare across assessments at all. The result is a school where “how is this student doing?” gets a different answer depending on who you ask.
SCREENSHOT: Markbook with % Standardisation
The table above illustrates what this looks like in practice. With scores standardised to percentages, a teacher can immediately see that Lora Davis is consistently performing well below the class average across all three assessments — not just one — and that the gap has been consistent all year. Without standardisation, this pattern might not be visible until report season, when it is too late to act on it in any meaningful way during the current term.
Â
Baseline assessment: the most underused tool in most schools
Â
SCREENSHOT: Staff web app: Baseline comparison view
Caption: Baseline comparison in Schooly — every student’s progress measured against their own starting point, with trend indicators updated automatically as new results are added.
Â
Most schools measure student performance against where everyone else is right now. A student who scores 65% when the class average is 70% is below average. That is useful information — but it tells you nothing about whether this particular student has made progress since the beginning of the year, or whether their 65% represents an improvement from 45% or a decline from 82%.
Baseline assessment changes the reference point. Instead of comparing every student to the class average, you compare every student to their own starting point. A teacher who sets the first assessment of the year as the baseline can see, for every subsequent assessment, whether each student is above or below their starting level — and by how much.
This has two practical consequences. The first is that progress becomes visible for students who would otherwise be invisible — the student who has improved dramatically but is still below the class average, and whose progress would go uncelebrated without a baseline. The second is that regression becomes visible earlier — the student who starts strong and quietly declines is flagged before the decline becomes significant enough to show up in a formal review.
Setting a baseline in Schooly takes a single step: a teacher selects which assessment to use as the reference point, and the system automatically colour-codes all subsequent results relative to it. No formula. No separate calculation. The baseline is locked in the markbook and the comparison happens automatically as new results are added.
Â
The connection that eliminates double entry
Everything covered so far — averages, colour coding, standardisation, baselines — makes the markbook a more powerful analytical tool. But there is a second benefit to a properly integrated markbook that is more immediately visible to every teacher in the school: it eliminates the need to re-enter grade data at report time.
In Chapter 3 we covered the report card production process in detail. The key point here is the direct link between assessment and report: when grades live in Schooly’s markbook, they are available to the report card module without any export, copy, or manual transfer. A teacher opening a student’s report at the end of term sees the grades already populated — pulled automatically from the markbook entries for that period. What they write is the comment. Everything else is handled.
This integration also resolves a specific problem that affects schools at report time: the question of which grades are final. In a disconnected system, a teacher might update a markbook entry after the report has already been generated — correcting a data entry error, adding a late submission, or revising a mark following a review. In that system, the report now contains a grade that no longer matches the markbook. Someone needs to catch this discrepancy and correct it manually.
When the markbook and report card are the same system, this problem does not exist. The report always reflects the current markbook data. If a grade changes, the report changes. The source of truth is singular, and the consistency is automatic.
Â
What good assessment infrastructure looks like across a school
The value of a well-structured markbook system compounds as it scales. A single teacher with a well-organised spreadsheet can manage their own grades effectively enough. The problem emerges when you need to see across multiple teachers, multiple subjects, and multiple year groups simultaneously — which is exactly the view that school leaders and pastoral staff need to do their jobs.
Â
SCREENSHOT: Staff web app: Assessment overview across classes or subjects
Caption: Assessment data in Schooly is visible across the whole school — not just within each teacher’s markbook — giving heads of year and senior leaders the cross-subject picture they need.
The parent-facing dimension
There is a parent-facing dimension to assessment data that most schools underuse. Parents who can see their child’s grades between formal report cycles — in real time, on their phone, without calling the school — are parents who are more engaged in their child’s academic progress. They are also parents who are less likely to be surprised by a negative report at the end of term, because they have been following the trajectory throughout.
The concern schools sometimes raise about sharing live assessment data with parents is that it requires context — a single test score without explanation can cause unnecessary anxiety. This is a real concern. The answer is not to withhold the data but to present it appropriately: in context, with the class average visible where relevant, and with the teacher’s commentary available through the messaging channel if a parent wants to discuss it.
A parent who can see that their child scored 62% on a test where the class average was 60% has useful, reassuring information. A parent who receives only a formal report at the end of term and finds a 62% without context may have spent weeks wondering how their child was doing. The difference in experience — and in parent trust — is significant. And it costs the school nothing additional once the assessment data is already in the system.
Six questions to audit your current assessment infrastructure
These questions apply whether your school uses a dedicated MIS or a collection of spreadsheets. Any “no” points to a gap that is costing your staff time and your school visibility.
- When a teacher enters a grade into their markbook, does it automatically appear in the report card — or does someone type it again? Every manual transfer is a source of error. In a well-integrated system, the grade exists once and flows everywhere it is needed.
- Can a head of year or pastoral lead see a student's performance across all subjects right now — without emailing individual teachers for their spreadsheets? If not, your assessment data is siloed, and the cross-subject patterns that matter most for pastoral support are invisible until it's too late to act on them.
- Do all your teachers use the same grading format and scale, in the same system? If the answer is "sort of" or "we recommend it but don't enforce it," your grade data is not comparable across subjects — which means school-level analysis is either impossible or unreliable.
- Can any teacher in your school see, in under two minutes, which students in their class are consistently below the group average across multiple assessments? This should require one click, not a pivot table. If it takes more than two minutes, the data is not as actionable as it needs to be.
- Does your school measure student progress against a baseline — or only against the current class average? If the answer is "only against the current average," you are measuring attainment, not progress. These are different things, and confusing them disadvantages students who arrive with lower starting points.
- Can parents see their child's assessment results between formal report cycles — in their own language, without contacting the school? If not, you are withholding information that would increase parent engagement and reduce the surprise factor at report time. The data already exists. The question is whether parents can access it.
The bottom line
A markbook that only stores grades is a filing system. A markbook that calculates averages, highlights outliers, tracks progress against a baseline, standardises scores for fair comparison, and feeds its data directly into report cards — without requiring a teacher to do any of this manually — is a tool that makes teachers more effective, makes pastoral leaders better informed, and makes parents more engaged.
The shift from one to the other is not a technology upgrade. It is a change in how a school thinks about assessment data: not as something to be recorded and filed, but as something to be made visible, compared, and acted on. The technology makes this possible. But the decision to use it that way — to give teachers a system that does the analysis automatically, and to give leaders a view above classroom level — is a leadership decision.
Schools that make that decision consistently report the same outcome: teachers spend less time on grade administration and more time on the professional response to what the data shows. Pastoral interventions happen earlier because patterns surface sooner. And report season is shorter, because the grade data is already in the right place when the template opens.
