KS3 Excel Lesson 4 – Only IF | IF & ELSE Functions in Spreadsheets | Computer Science & ICT

A creative and accessible KS3 Computer Science / ICT Excel lesson introducing students to IF and ELSE functions through practical modelling and fun logic-based challenges.
Building on the previous lessons in the Learning Excel series, learners explore how selection works inside spreadsheets and how to apply logic statements to create dynamic, decision-making models.

Students will:

Understand the keywords IF and ELSE

Learn to write IF statements using logical operators (=, <, >, <>)

Apply IF and ELSE logic to complete real-world spreadsheet challenges

Create a quiz-style model that reacts automatically to user input

Included in this download:

Fully editable student worksheet / booklet

Linked Excel activity files (IF1.xlsx, ELSE3.xlsx, QUIZ.xlsx)

Clear structure with starter, tasks, challenge & plenary

Reflection checks for assessment and progress tracking

Perfect for KS3 Computer Science, ICT, or Digital Literacy units focusing on formulas, logic, and data modelling.
Designed for independent or teacher-led delivery with engaging, progressive activities.

Part 4 of the 6-Lesson “Learning Excel” Series – follows Fun into Functions and prepares students for advanced spreadsheet modelling and self-marking projec