Macros are small programs that you can use to automate processes that require several steps. Your task this week is to create a simple, re-usable system that could be used in a shop, and to add a macro to make it easier to use. I have made videos to remind you how to create macros in Excel and LibreOffice.
An example system is show below. Your shop doesn’t have to be a petrol station – it could be anywhere that sells a limited range of items, in which case you’d enter the number of each item purchased, rather than the number of litres.
By now you should be able to add the formulae to get the totals to be calculated correctly, so the first step is to add formulae to column D to:
calculate the sub-total for each type of fuel
calculate the total cost
calculate the change from the amount tendered (that's the amount of money the customer actually hands over)
The main part of the task this week, however, is to use your Excel skills to use
macros to improve this point of sale system so that it could actually be used in a petrol station. You should improve the system to do as many of the following things as you
clear the sale sheet ready for the next customer
updating the stock levels after a sale to reduce them by the number of items sold
print a receipt
save and close the system
stop the amount tendered being less that the total bill
You can also add any extra features that you think are appropriate.
This is how your point of sale system will be marked: