Computer Science FREE Spreadsheets Lesson KS3

A free KS3 spreadsheets lesson introducing students to formulas through practical activities and structured PRIMM-style teaching.

This resource contains the first lesson from the full KS3 Spreadsheets Scheme of Work and is designed to give teachers a clear sample of the structure, teaching style and level of challenge used throughout the complete unit.

The lesson introduces students to spreadsheet formulas, helping them understand how calculations can be created using cell references and mathematical operators.

Included in this free sample:
• A complete lesson slide deck
• Lesson activities
• Homework
• Sample spreadsheet files
• Practical spreadsheet tasks

The lesson is structured using the PRIMM approach — Predict, Run, Investigate, Modify and Make — encouraging students to explore how existing formulas work before modifying them and creating their own solutions.

This lesson is particularly suitable for KS3 Computing or Computer Science, including students who are new to spreadsheets or who need to develop a stronger understanding of formulas and cell references.

It can be used as:
• An introduction to spreadsheets
• A first lesson on spreadsheet formulas
• A practical KS3 Computing lesson
• A PRIMM-based introduction to spreadsheet skills
• A sample of the complete Spreadsheets Scheme of Work

This free resource is taken from the complete 5-lesson KS3 Spreadsheets Scheme of Work, which goes on to cover formulas, functions, selection, lookups and charts, as well as an end-of-unit assessment.
https://www.tes.com/teaching-resource/resource-13602652

The full scheme also includes slide decks, lesson activities, homework and sample spreadsheet files for every lesson.

A useful free introduction to spreadsheet formulas, cell references and PRIMM-style teaching at KS3, while also providing a clear sample of the complete unit.