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!)* 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, colours and layout** throughout. Every lesson includes teacher slides, worksheets, editable Excel files and step-by-step tasks that ensure success for all learners, including SEND and lower-ability students. This bundle takes students from absolute beginners to confident spreadsheet users through fun, practical and real-world modelling activities. *What’s included in the 6-lesson sequence:* *Lesson 1 – Battleships & Cell Referencing* *Introduce spreadsheets through a fun Battleships activity.* Students learn rows, columns, cells, formatting and basic referencing using a fully accessible grid-based model. *Lesson 2 – “Cheating at Maths!” Using = Calculations* Show pupils how simple **=** formulas can calculate answers automatically. They learn to use cell referencing to solve maths problems and see how modelling updates instantly. *Lesson 3 – Fun Into Functions!* Students discover Excel’s most popular beginner functions: **SUM, AVERAGE, MIN and MAX**. Step-by-step, dyslexia-friendly instructions build confidence with real-world examples. *Lesson 4 – IF & ELSE Logic: Build a Self-Marking Quiz* Introduce spreadsheet logic with IF statements. Students create a mini quiz where Excel marks their answers automatically — a brilliant link to computing and coding concepts. *Lesson 5 – Real-World Cost Modelling* Learners build a practical budgeting spreadsheet for shopping, everyday spending and simple cost analysis. A perfect real-world application of formulas and modelling. *Lesson 6 – Party Planner: Costs, Pricing & Profit!* Students design a party, add their own items, calculate costs, set ticket prices and work out profit or loss. This creative challenge consolidates the whole unit. *Why this bundle sells exceptionally well on TES:* * ✔ **Fully dyslexia-friendly design** – OpenDyslexic font (or similar), pastel backgrounds, spacious layouts, clean formatting and colour-coded examples in every lesson. * ✔ **Extremely high engagement** – Battleships, self-marking quizzes, party planning and budgeting keep behaviour low and motivation high. * ✔ **Perfect for mixed-ability KS3 groups** – Step-by-step tasks, scaffolded worksheets, clear modelling, and optional extension challenges. * ✔ **Ready-to-teach** – All six lessons include PowerPoints, worksheets and editable Excel templates. No preparation needed. * ✔ **Real-world relevance** – Students quickly see how spreadsheets matter in life, business, money, events and computing. *Skills students will master across the bundle:* * Cell referencing * Formatting & layout * Basic operations using = * Functions (SUM, AVERAGE, MIN, MAX) * IF/ELSE logic * Budgeting, costs & profit * Spreadsheet modelling & decision-making This 6-lesson Excel bundle gives you **everything you need for a full half-term of KS3 Computing** — fully accessible, fun to teach, and proven to keep students engaged from start to finish.