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
- Slide decks
- Learner resources
- Homework
Don't have an account?
Enjoyed teaching these lessons? Found a mistake?
Fill in a short form to give feedback on these resources.