FFT5/FFT10 Tracker for SLT (Excel • up to 35 students per class)

Give your data meetings real bite. This Excel workbook tracks a class of up to 35 students against FFT10 and FFT5 targets, spotlights a Focus 5, and auto-builds clean visuals that SLT can lift straight into reports.

What it does

Student Overview: Enter names and demographics (PP, SEND, EAL), baseline, FFT10/FFT5 and current grade. Built-in progress formulas and traffic-light formatting (green ≥ FFT5, amber between, red < FFT10).

Focus 5 Dashboard: Automatically pulls only your Focus 5 and charts Current vs FFT10/FFT5 so interventions are crystal clear.

Class Progress Charts: Whole-class clustered columns for Current vs Targets, with an overlay that highlights the Focus 5.

SLT Summary: Live KPIs driven by the chart helper ranges—update the figures in the Class Progress Charts sheet and the SLT page instantly recalculates:

% meeting FFT10 / FFT5 (whole class)

Focus 5 % meeting FFT10 / FFT5

Group breakdowns for PP / SEND / Gender

Why teachers & leaders like it

Zero faff: paste your data and the visuals update.

Focuses attention on the right pupils (your Focus 5) without losing the whole-class picture.

Perfect for line management, deep dives, Pupil Premium reviews, and progress conversations.

What’s included

One editable .xlsx workbook with 4 linked sheets: Student Overview, Focus 5 Dashboard, Class Progress Charts, SLT Summary.

Sample data so you can see how it’s meant to look (just overwrite).

Compatibility

Built for Microsoft Excel 365 / Excel 2021 (Windows/Mac) using dynamic arrays (e.g., FILTER).

Not designed for older Excel versions or Google Sheets.

Customise in minutes

Change the grade scale (9–1, bands, points), add classes, or extend the group filters (e.g., ethnicity, EAL breakdown by stage).

Duplicate the file per class or aggregate via a simple index page if you want a year-group roll-up.

Keywords
FFT, FFT5, FFT10, Focus 5, SLT, data tracker, progress, attainment, PP, SEND, EAL, GCSE, KS3, KS4, dashboard, Excel.

Please note
This tracker does not include FFT data. You’ll need to enter your school’s FFT5/FFT10 targets. If you don’t have them, please request them from your school’s Data Manager/Assessment Lead before use.