KS3 Excel Lesson 6 – Spreadsheet Mastery Project | Apply IF, COUNTIF & Conditional Formatting | Comp

The final lesson in the KS3 “Learning Excel” series, where students put all their spreadsheet skills into practice through a project-based challenge.
Using Excel, learners combine everything they’ve learned — from basic formulas to IF statements, COUNTIF, and conditional formatting — to create their own fully functional data model.

Students will:

Apply skills in formulas, functions, and data modelling

Design a practical spreadsheet project using IF, COUNTIF, and formatting rules

Demonstrate understanding through evaluation and reflection tasks

Build confidence by completing independent real-world spreadsheet challenges

Included in this download:

Fully editable PowerPoint lesson (with Engage–Explore–Explain–Elaborate–Evaluate structure)

Project brief and modelling activities

Plenary reflection prompts and success criteria

Ideal for KS3 Computer Science, ICT, or Digital Literacy units focusing on spreadsheets, logic, and real-world application.
Can be used as an end-of-unit project, assessment lesson, or creative task to showcase student progress.

Part 6 of the 6-Lesson “Learning Excel” Series – the perfect conclusion to the complete KS3 introduction to Excel, covering formulas, functions, models, and conditional formatting.