Back to the tracking, and to where the turnaround came from. It was clear that the system I needed to give myself the full picture of my students’ progress wasn’t in place. I thought I had what I needed: a spreadsheet containing some key data. In fact, what I needed was a tracker.
A tracker is completely different to a spreadsheet. It’s comprehensive system that does the heavy lifting for you, allowing access to key data and information per pupil for each class and for the whole cohort. It allows important information to be accessed by all key stakeholders, at all times. Whereas, in my spreadsheet, I had a system that was creating barriers to vital information:
- Having to create my own tracking system = barrier
- Having to manually calculate the grades = barrier
- Having to find a look up to be able to use the latest grade boundaries = barrier
- Having to watch endless YouTube videos out how to get the spreadsheet to do what I needed it to do = barrier
- Having only a basic level of Excel expertise to do the calculations = barrier
- Not having enough time and brain space to focus on doing the job properly = barrier
And so on… When we have these barriers to finding out the full picture, we put off taking the time to work out how to find the information because it feels like too much hard work. The fatigue and tiredness that often go hand-in-hand with being a teacher promote procrastination around tasks that our brain knows require a lot of thought and effort. Much like your brain can convince you it’s OK to grab a quick few seconds’ sleep behind the wheel, your brain will subconsciously convince you: “It’s fine, I’m definitely going to do this next week… without question.” And we all know where that leads.
I was the person described above. I was extremely anxious about my students’ outcomes. I was stressed about the unknown. I worked extremely hard, it felt like I had worked my fingers to the bone, but I wasn’t working smartly and I was working in an environment where I wasn’t well informed.
It was only when I invested time in creating a tracking system that removed the barriers to the information I needed on a daily basis that I was able to plan strategically.
For those of you reading this thinking: “I only need to look at the tracking two or three times a year, what’s the big deal?” I’ve listed below the times in the year and number of events and / or activities that we need key data from our examined groups:
- Individual teacher meetings
- Team meetings
- Lesson observations
- Seating plan evidence
- Current progress (individuals)
- Current progress (whole class)
- Seating plans
- Line management meetings
- Pupil progress meetings
- 4-6 data points, per year
- Forecast grade
- Actual grade
- Parents’ evenings
- Forecast grade
- Actual grade
- Ad hoc parents’ meetings
- Strategic planning
- Reporting on mock test results and their impact on final grades
- Group setting
- Governors’ meetings
- This is GCSE only: double it if you also teach A-Level, treble it with BTEC, etc.
I hadn’t previously noted or respected the amount of things that I needed to use a tracking system for. When I realised this, forget the time I got back (which was a lot) – the stress it relieved was immeasurable.
To add to this, once I opened the data box, I couldn’t stop looking inside it… and neither could my staff. We couldn’t stop asking ourselves:
- Are we teaching what we need to teach?
- Has the topic gone well?
- What do we need to focus on now?
- Are the students on target?
- What’s the strategy moving forward?
Having a tracker revolutionised our approach to delivery, and because access to the information was so easy it allowed me to gain buy-in from all key stakeholders. We were able to be incredibly proactive, because we had a clear idea of the situation in early Year 11 and Year 10. We were able to put a clear action plan in place as to what we were going to deliver with the number of lessons we had left to achieve the greatest amount of impact.
Above all, “the Big Tamale” was that I knew – pretty much to a single % – what the results would be in August, because we’d been living and breathing this from the start of Year 10. Not only were we on target, but there were no surprises, and no cold sweats a week before Results Day. The reason: the tracking system was easy to access, and told me everything I needed to know without any barrier to this information.
The overriding message I’m trying to convey is – whether you do it through Excel, GoogleSheets or use the Pupil Progress tracking system – make sure that you invest time or money into a tracker. Don’t just use a spreadsheet. Implementing a comprehensive tracking system takes away all barriers to the key information you need in order to inform planning, delivery, strategy and buy-in from key stakeholders. Speaking from real, lived experience – this will dramatically reduce the stress you’re feeling and bring the enjoyment back into your teaching.