SEPTEMBER LAUNCH 20% DISCOUNT!

1. What Is Data, and Why Does It Matter?
2. Sorting & Filtering
3. Simple Formulas (SUM, AVERAGE, MAX/MIN)
4. Conditional Formatting
5. IF Statements
6. Charts & Graphs
7. Data Dashboard Project

A complete 7-lesson KS3 scheme of work teaching real Excel spreadsheet skills — sorting, formulas, conditional formatting, IF statements and charts — through genuine football data pupils actually want to dig into.

Every lesson pairs an interactive PowerPoint with a real, working Excel template — not screenshots or mock-ups, but genuine formulas, a real colour-scale conditional format, and a real chart, all pre-built and verified to calculate correctly. Pupils learn to move between both applications confidently, taught explicitly with a step-by-step window-snapping and copy/paste sequence most resources simply assume.

What’s included in this bundle:

• A full scheme of work covering all 7 lessons, with tiered vocabulary, differentiation and careers links mapped out lesson by lesson
• Seven detailed lesson plans with timings, learning outcomes (MUST/SHOULD/COULD), and SEND-focused differentiation (Bronze/Silver/Gold)
• A fully interactive Student PowerPoint with large, clearly signposted answer boxes throughout
• A real Excel Student Template — 8 colour-coded tabs, genuine formulas, and a working example chart pupils learn from directly
• A matching Teacher PowerPoint (3 slides per lesson) for introducing and recapping each lesson
• A built-in careers strand covering 7 real data-related jobs, from data analyst to data visualisation specialist

Originally developed for a KS3 SEMH cohort with low reading ages and a preference for concrete, structured tasks, every new skill is modelled with a real worked example before pupils attempt it themselves — removing the guesswork that usually makes spreadsheet lessons feel intimidating. It works equally well as a mainstream Year 7-9 unit for any school wanting pupils to leave with genuinely transferable Excel skills, not just a worksheet about them.
KS3 · Computing / ICT · Excel · Spreadsheets · Data skills · SEND · SEMH · Scheme of work

If you like the resource please can you leave me a positive review. Check out my other ICT / Computing resources in my shop.