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
|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|
|Log in to rate this resource|