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
  • Slide decks
  • Learner resources
  • Homework