The Safety Deposit Vault
This is an exercise with complex spreadsheets and mail-merged documents. It is based on an actual implementation in a vaut with over 1500 boxes of different sizes.
The simplified example uses nine boxes of three different sizes, each has the price for annual box rental.
Also recorded are the renters' names, addresses, when they last paid, etc.
The spreadsheet calculates the month when the next payment is due and when to send new invoices and warning letters. It also provides a monthly cash-flow report.
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.
|Subject(s)||STEM Clubs, Computing, Design & Development, Algorithmic Thinking, Data & Information, Design and technology, Design skills|
|Tags||spreasdsheets, mail-merge, Excel, word, complex, STEM|
|Age||11-14, 14-16, 16-19|
|Last updated||04 September 2019|