KS3 Spreadsheets Lesson 4 – IF/ELSE Logic & Automatic Marking

KS3 Excel Mega-Bundle – 6 Fully-Dyslexia-Friendly Lessons (Battleships, Maths Modelling, Functions, Logic, Budgeting & Profit!)

KS3 Excel Mega-Bundle – 6 Fully Dyslexia-Friendly Lessons Battleships, Maths Modelling, Functions, Logic, Budgeting & Profit Updated for 2026 | Complete Half-Term Unit | Fully Editable Transform the way your KS3 students learn spreadsheets with this complete 6-lesson Excel unit. Fully resourced, highly engaging and designed with dyslexia-friendly fonts, pastel colours and clean layouts throughout, this bundle supports all learners, including SEND and lower-ability students. Each lesson includes teacher slides, structured worksheets and editable Excel files with step-by-step guidance. Students progress from complete beginners to confident spreadsheet users through practical, real-world modelling activities. --- Lesson Breakdown Lesson 1 – Battleships & Cell Referencing Students are introduced to spreadsheets through a fun Battleships activity. They learn about rows, columns, cell names, formatting and basic referencing using an accessible grid-based model. Lesson 2 – “Cheating at Maths!” Using = Calculations Students discover how the equals sign allows Excel to calculate answers automatically. They practise writing simple formulas using cell references and see how models update instantly when numbers change. Lesson 3 – Fun Into Functions Learners are introduced to key beginner functions: SUM, AVERAGE, MIN and MAX. Clear modelling and scaffolded tasks help students understand how functions save time and improve accuracy. Lesson 4 – IF Logic: Build a Self-Marking Quiz Students explore logical functions using IF statements. They create a simple self-marking quiz where Excel checks answers automatically, linking spreadsheet logic to computing concepts. Lesson 5 – Real-World Cost Modelling Students build a budgeting spreadsheet focused on everyday spending and cost comparison. They practise formula writing, totals and simple modelling to make financial decisions. Lesson 6 – Party Planner: Costs, Pricing & Profit Students design and plan an event. They calculate total costs, set ticket prices and determine profit or loss. This creative challenge consolidates all previous spreadsheet skills. --- Why Teachers Choose This Bundle * Fully dyslexia-friendly formatting throughout * High engagement activities that reduce behaviour issues * Strong scaffolding for mixed-ability classes * Real-world relevance that makes spreadsheets meaningful * Completely ready to teach with no extra preparation * Clear progression from basic referencing to logical modelling --- Skills Developed Across the Unit * Cell referencing and formatting * Writing formulas using = * Using functions (SUM, AVERAGE, MIN, MAX) * Applying IF logic * Budgeting and profit calculations * Spreadsheet modelling and decision-making * Problem solving using digital tools --- This KS3 Excel Mega-Bundle provides everything needed for a full half-term of structured, accessible and engaging spreadsheet teaching. Students build confidence step by step while developing practical digital skills they will use throughout school and beyond.