New

Year 7

Data modelling

Lessons (6)

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

Formatting data in a spreadsheet

I can identify the components of a spreadsheet and apply formatting to improve the presentation of data.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Spreadsheet calculations

I can use formulas in a spreadsheet to complete calculations.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Collecting data for a purpose

I can explain the difference between data and information and know that data can come from a range of sources.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Analysing and visualising data

I can analyse data using functions and summarise findings using charts.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Sorting and searching data

I can use spreadsheet tools to sort and search data to find and analyse information.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Applying conditional formatting to data

I can use conditional formatting and a range of tools to present data effectively.

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