Skip to main content

Year 7

Lesson 6 Assessment

Curriculum > KS3 > Unit > Lesson

In this lesson, learners will discover how to use conditional formatting, whereby the appearance of a cell changes automatically depending on the data it contains, according to rules the learners themselves set. They then complete an end-of-unit summative assessment.

Learning objectives

  • Use conditional formatting in a spreadsheet
  • Apply all of the spreadsheet skills covered in this unit

Package contents

  • Lesson plans
  • Learning graphs
  • Unit overviews
  • Activities
Log in to download

Not registered yet?

Create an account and get access to over 500 hours of free teaching resources.

Help us make these resources better

Provide your feedback

Or email us at [email protected]