KS3 Excel Lesson – Introduction to IF & ELSE Logic (Lesson 4 of 6)

A creative, engaging and accessible KS3 Computer Science / ICT lesson introducing students to IF and ELSE functions through practical modelling and logic-based challenges.

Building on earlier lessons in the Learning Excel series, students explore how selection works inside spreadsheets and how logical statements allow Excel to make decisions automatically. This lesson helps learners move from simple formulas to dynamic, responsive models.

What Students Will Learn

Students will:

• Understand the purpose of IF and ELSE in spreadsheets

• Write IF statements using logical operators:

  • = equal to
  • > greater than
  • < less than
  • <> not equal to

• Apply logical tests to create decision-making spreadsheet models

• Build a quiz-style spreadsheet that reacts automatically to user input

• Recognise how spreadsheet logic links to programming concepts

What’s Included

Editable Student Workbook / Worksheet

• Starter activity to revisit prior formula skills
• Step-by-step IF statement practice
• Structured tasks increasing in complexity
• Challenge activities for higher ability students
• Plenary reflection and self-assessment

Linked Excel Activity Files

• IF1.xlsx
• ELSE3.xlsx
• QUIZ.xlsx

These files allow students to practise writing formulas directly inside working models.

Clear Lesson Flow

• Starter retrieval task
• Introduction to logical operators
• Guided IF statement construction
• Independent modelling challenge
• Quiz model task
• Plenary and reflection

Skills Developed

• Writing structured IF statements
• Using logical comparisons
• Understanding Boolean-style outcomes (TRUE/FALSE logic)
• Designing reactive spreadsheet models
• Linking spreadsheet logic to programming concepts

Ideal For

• KS3 Computer Science
• ICT
• Digital Literacy
• Introducing logical thinking
• Cover lessons or consolidation tasks

Why Teachers Choose This Lesson

• Clear, scaffolded progression
• Engaging, practical modelling tasks
• Strong link between spreadsheets and programming logic
• Differentiated challenge built in
• Ready-to-teach with linked Excel files

Part 4 of the 6-Lesson “Learning Excel” Series

Follows Fun into Functions and prepares students for:

• Advanced spreadsheet modelling
• Conditional formatting logic
• Self-marking spreadsheets
• End-of-unit project work

A key stepping stone from formulas to true computational thinking inside Excel.