- View more resources from this publisher
Generation Logistics
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
Data handling - stock control
This task is a real-world example of how spreadsheets can be utilised effectively to simplify data handling and calculation tasks.
Pupils are provided with information about the numbers of items in stock in a warehouse and the weekly sales of the items over a month. This task requires pupils to add the stock levels and sales data to the spreadsheet. Using the spreadsheet pupils have to calculate the stock left at the end of each week and the total monthly sales for each item by creating the appropriate formula and add conditional formatting to show when stock needs to be re-ordered. They are then required to create a line graph for each item to show the changes in stock over the month.
The activity includes:
- teacher notes
- adaptable presentation
- adaptable student activity sheet
- student blank spreadsheet with data labels added to provide support if needed
- suggested solutions
- exemplar solution spreadsheet
Further education resources that link the world of logistics to suitable lessons and subjects in school can be found on the Generation Logistics Education Hub.
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.
Downloads
Show downloads
Download all files as a .zip675.78 KB
Information on the permitted use of this resource is covered by the Category Seven Content section in STEM Learning’s Terms and conditions.
