Skip to content
Oak National Academy
Oak National Academy
View my library
0
Teachers
Pupils
New
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