Non-GCSE – Lesson 3 – RSC merchandise

Curriculum KS4 Unit Lesson

This lesson aims to begin the process of demonstrating to learners how databases are used to manage sales and stock levels; it links to Lesson 5. Learners will be given a partly completed spreadsheet showing items of merchandise to be sold at the RSC Live event. Learners will also research the types and prices of merchandise available at events and use this information to populate a financial model. They will complete the spreadsheet with target sales figures and implement formulae to calculate income from sales. Conditional formatting will be used to visualise whether sales targets are reached.

Learning objectives

  • Implement conditional formatting techniques
  • Format cells correctly, e.g. cells representing money should be currency, etc.

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework