KS3 Computer Science / ICT – Excel Lesson 1: Introduction to Spreadsheets
Engaging Starter Lesson | Fully Structured | Updated for 2026

A fun, interactive and fully structured KS3 lesson introducing students to Microsoft Excel and the fundamentals of spreadsheets.

This first lesson builds confidence with cells, rows, columns and basic modelling concepts, while keeping learners actively involved through games and real-world examples.

What Students Will Learn

Students will:

• Understand what a spreadsheet is and why it is used
• Discover the origins and purpose of spreadsheets in business and everyday life
• Identify cells, rows, columns, and headers
• Practise accurate cell referencing
• Explore how spreadsheets model real-world systems (e.g. cinema bookings)
• Complete comprehension, recall and challenge tasks

Lesson Activities

Battleships Cell Referencing Game

• Students practise identifying cell references in a fun, competitive format
• Reinforces understanding of coordinates (e.g. B4, C7)
• Builds confidence quickly through active learning

Real-World Modelling Task

• Explore how spreadsheets are used to model systems such as cinema bookings
• Introduces the concept of spreadsheets as decision-making tools

Structured Practice & Reflection

• Retrieval starter
• Guided tasks
• Independent challenge
• Plenary reflection

What’s Included

• Fully editable Word worksheet / student booklet
• Links to interactive spreadsheet activities (e.g. Battleships.xlsx)
• Clear lesson structure: starter → tasks → challenge → plenary
• Key vocabulary support
• Reflection and progress-check questions

Why Teachers Choose This Lesson

• Highly engaging first experience with Excel
• Clear progression from basic structure to simple modelling
• Scaffolded for mixed-ability KS3 classes
• Easy to deliver for specialists and non-specialists
• Strong foundation for formulas, functions, and IF statements later in the unit
• Ready to teach with no additional planning required

Perfect For

• KS3 Computer Science
• KS3 ICT
• Digital Literacy
• Introduction to spreadsheets
• Cover lessons or skills-based computing sessions

Series Information

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

This lesson provides the essential foundation for:

• Formulas and cell referencing
• Functions (SUM, MIN, MAX, COUNTIF)
• IF statements and logic modelling
• Conditional formatting
• Project-based spreadsheet challenges

An ideal starting point for building confident, capable spreadsheet users at KS3.