Non-GCSE – Lesson 5 – RSC stock control

Curriculum KS4 Unit Lesson

The aim of this lesson is to link with the sales activity of Lesson 3 and go behind the scenes to examine the database of RSC merchandise. Learners will discuss the use of barcodes and QR codes (2D codes) and the different kinds of data they can hold. The spreadsheet will be used to track stock and flag up to users when items need to be reordered, demonstrating the process that happens when items are sold in a shop. Each sale at the till creates a transaction in the database and an automated reordering process takes care of replenishing the stock levels once a predetermined low-stock level is reached.

Learning objectives

  • Implement a LOOKUP function to retrieve data
  • Implement an IF function to give the user feedback

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework