KS3 Excel Lesson – Introduction to Functions & Data Analysis (Lesson 3 of 6)

An engaging and practical KS3 Computer Science / ICT lesson introducing students to spreadsheet functions and basic data analysis using SUM, MIN, MAX, and COUNTIF.

Building directly on the previous “Cheating at Maths” lesson, this session moves learners from simple formulas to more powerful built-in functions that allow spreadsheets to become efficient, dynamic and intelligent tools for analysing data.

What Students Will Learn

Students will:

• Use the SUM function to total ranges of data
• Apply MIN and MAX to identify smallest and largest values
• Use COUNTIF to analyse data using criteria
• Apply accurate cell referencing in function formulas
• Automate calculations to avoid repetitive manual work
• Interpret results using real-world datasets

Real-World Contexts

Students apply functions to practical examples such as:

• Analysing bus timetable or passenger data
• Identifying highest and lowest values in datasets
• Counting entries that meet specific conditions
• Exploring how businesses use spreadsheet analysis

This ensures learning feels purposeful and connected to real-world applications.

What’s Included

Editable Student Worksheet / Workbook

• Retrieval starter revisiting formulas
• Step-by-step guided practice tasks
• Structured SUM, MIN, MAX exercises
• COUNTIF introduction and applied challenges
• Reflection and understanding checks
• Stretch challenges for higher ability learners

Linked Excel Activity Files

• Av.xlsx
• Countif.xlsx
• Bus.xlsx

These files allow students to practise directly in working spreadsheets.

Clear Lesson Structure

• Starter retrieval task
• Guided modelling tasks
• Independent application
• Challenge extension
• Plenary reflection

Skills Developed

• Function syntax and correct structure
• Accurate range selection
• Criteria-based data analysis
• Logical thinking and modelling
• Confidence in building automated spreadsheet solutions

Ideal For

• KS3 Computer Science
• ICT
• Digital Literacy
• Data handling units
• Spreadsheet modelling lessons
• Cover or revision sessions

Why Teachers Choose This Lesson

• Clear progression from formulas to functions
• Real-world modelling contexts
• Scaffolded support with built-in challenge
• Encourages independence and problem-solving
• Fully editable and easy to deliver

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

Follows:

• Lesson 1 – Introduction to Spreadsheets
• Lesson 2 – Cheating at Maths

Prepares students for:

• IF and logical modelling
• Conditional formatting
• Advanced spreadsheet automation
• End-of-unit project-based challenges

A key lesson in transforming basic spreadsheet users into confident data analysts.