What Progress Measures Do and Do Not Show

I remember sitting in a windowless departmental meeting three years ago, staring at a color-coded spreadsheet that supposedly explained everything about my Year 10 cohort. The SLT lead was explaining exactly how school performance data is used to “drive pedagogical excellence,” but all I could see were rows of numbers that had absolutely nothing to do with the boy in the back row who hadn’t opened his book once since October. We were being asked to pivot our entire teaching strategy based on a statistical abstraction that didn’t account for the fact that half the class was hungry, tired, or simply disengaged.

I’m not here to give you another lecture on data entry or how to please an inspector with a pretty graph. Instead, I want to talk about what actually matters when the spreadsheets meet the reality of a crowded classroom. I’m going to show you how to strip away the jargon and find the tiny, actionable bits of truth hidden in those metrics—the kind that actually help you teach a lesson on a Tuesday morning rather than just filling up a folder for a middle leader to skim.

Interpreting Academic Growth Trends When the Classroom Is Chaotic

The problem with interpreting academic growth trends is that the spreadsheets assume a linear progression. They show a neat little upward tick or a gentle dip, as if learning is a steady climb up a mountain. But in a classroom where you’ve got three different SEND requirements, a broken heating system, and a group of Year 10s who have decided that today is the day to collectively test the limits of your patience, growth isn’t a line. It’s a jagged, messy scribble. When you’re looking at student achievement analytics, you have to account for the noise of the actual room.

If the data says a cohort is stalling, the instinct from leadership is often to push for more “data-driven instruction methods.” But before you swap out your entire scheme of work because a mid-term assessment looked grim, ask yourself: was this a genuine cognitive gap, or was it just a bad Tuesday? You can’t manage a classroom through a dashboard. Real progress is often invisible to the school accountability frameworks until it’s far too late, so you have to learn to read between the lines of the numbers to see the human struggle underneath.

The Truth About School Accountability Frameworks and Your Sanity

We’ve all been there: sitting in a windowless meeting room, staring at a slide deck that claims our school accountability frameworks are designed to “empower teachers through transparency.” It sounds lovely on paper, doesn’t it? But in reality, these frameworks often feel less like a compass and more like a spotlight, specifically aimed at the parts of your job that are hardest to quantify. When the leadership team starts talking about student achievement analytics, they’re usually looking for a neat line on a graph. They aren’t looking at the kid in the back row who finally sat still for twenty minutes, or the quiet girl who actually contributed a sentence during a seminar.

The problem is that these metrics tend to flatten the lived reality of a classroom into a series of data points. We are told to embrace data-driven instruction methods, but there is a massive difference between using information to help a child and using it to justify a departmental restructure. If the framework only rewards the easy wins and penalizes the messy, complex work of supporting students who are struggling, then it isn’t a tool for improvement—it’s just a mechanism for stress.

Five Ways to Use Data Without Losing Your Mind (or Your Sunday)

• Stop looking for the ‘why’ in the spreadsheet. A spreadsheet will tell you that Year 10 has plummeted in their assessed writing, but it won’t tell you it’s because the radiator in Room 4 broke and they’ve been shivering for three weeks. Use the data to spot the fire, but use your eyes to find the source.
• Prioritise ‘actionable’ data over ‘interesting’ data. If a data set shows you a trend that requires a complete curriculum overhaul by Monday, ignore it for now. Focus on the small, granular bits—like which specific sub-topic in the Tudor period is tripping them up—that you can actually fix in a twenty-minute starter next lesson.
• Beware the ‘Average’ Trap. We love to talk about the ‘class average’ in department meetings, but the average is a lie. It hides the three kids who are flying and the four who are drowning. Look for the outliers; that’s where the real teaching happens, not in the middle of a bell curve.
• Use data to defend your time, not just to justify it. When leadership asks why certain outcomes are lagging, don’t just shrug. Use the data to show the correlation between class size, behaviour incidents, and progress. If the numbers show a struggle, use them as evidence to ask for the resources or the support you actually need.
• The ‘Friday Afternoon’ Test. Before you implement a new data-driven intervention, ask yourself: “Can I actually do this on a wet Wednesday afternoon when the printer is jammed and I’ve got thirty-two restless teenagers staring at me?” If the data suggests a strategy that requires an hour of prep per pupil, it’s not a strategy; it’s a fantasy.

The Reality Check: What Actually Matters When the Spreadsheets Start Screaming

Stop treating data as a verdict on your teaching and start using it as a diagnostic tool for the gaps you can’t see when you’re mid-sentence in a lesson.

If a metric doesn’t help you decide which group of students needs a different scaffold or a seating change tomorrow morning, it’s just noise designed to keep you in the office late.

Prioritise “good enough” data that informs your next move over “perfect” data that requires three hours of analysis you simply do not have.

## Data vs. The Human Element

“We’ve become experts at tracking the movement of decimal points on a spreadsheet, but we’re losing the ability to track the actual progress of the human beings in front of us. If a data set tells you a student is failing but doesn’t tell you they’ve been hungry since breakfast or that they’ve stopped trusting the person at the front of the room, then that data isn’t a tool—it’s just noise.”

Ellery Mwangi-Selkirk

The View from the Classroom Floor

At the end of the day, we have to stop pretending that a spreadsheet can tell the whole story. We’ve looked at how to navigate the chaos of growth trends and how to keep your head above water when the accountability frameworks start feeling more like an interrogation than a support system. Data is a tool, but it’s a blunt one; it can show you that a group is stalling, but it won’t tell you that they’re stalling because the heating broke in Room 4 or because they’re all exhausted from a week of mocks. If you use the metrics to inform your next move without filtering them through the reality of your actual pupils, you aren’t teaching—you’re just managing a dashboard.

So, as you head out to the car park or settle in for that mountain of marking, remember this: the numbers are just a shadow cast by the real work happening in your classroom. They are a way to spot patterns, not a way to define your worth or the worth of the kids sitting in front of you. Don’t let the obsession with “perfect data” rob you of the human connection that actually drives progress. You know the difference between a child who is struggling and a child who is simply having a bad Tuesday, and that is the insight no algorithm will ever replicate. Keep your eyes on the students, not just the stats.

About Ellery Mwangi-Selkirk

Most educational advice is written for a classroom that does not exist — twenty motivated pupils, unlimited preparation time, no behaviour to manage. I write for the room you are actually in. What retrieval practice looks like when marking is already three weeks behind, why the seating plan matters more than the starter activity, and which of the last decade's initiatives left anything behind. Nineteen years taught me that the good ideas survive contact with a wet Wednesday and the rest do not.