Non-GCSE
Lesson 5 RSC stock control
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
- Learning graphs
- Unit overviews
- Activities
Not registered yet?
Create an account and get access to over 500 hours of free teaching resources.