New

Year 11

Spreadsheets

Lessons (9)

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

These resources were created for remote use during the pandemic and are not designed for classroom teaching.

View new resources

Spreadsheet modelling

I can identify the key components of a spreadsheet and use a spreadsheet model for a given scenario.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Formulas in a spreadsheet model

I can use formulas to perform calculations in a spreadsheet model and replicate formulas across a range of cells.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Formatting in a spreadsheet model

I can format a spreadsheet model to improve readability and usability.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Data validation in a spreadsheet model

I can apply data validation techniques to improve data accuracy.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Lookup and reference functions

I can use lookup and IF functions to retrieve data efficiently.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Visualising data using charts in a spreadsheet

I can create and customise charts to present data effectively.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Improving a spreadsheet model

I can use a range of tools to improve a spreadsheet model.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Spreadsheet project I

I can create a spreadsheet model for an event to investigate income and costs.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Spreadsheet project II

I can use a spreadsheet to model different scenarios for an event and use the model to make recommendations.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Can't find what you need?

Create a tailor-made lesson plan and resources on any topic with Aila, our free AI-powered lesson assistant. Entirely adaptable to your class and context.

Create a lesson with AI