1. Use a spreadsheet and database to organise data for specific purposes.
2. Plan and create spreadsheets and databases to provide a soluon for organisaonal use.
There are six spreadsheet tasks that you should complete. You should aim to complete all tasks - failure to
complete some tasks will impact on the rest of the assignment. For the purposes of this assignment,
assume that you work for the retail organisaon, Sun City, and have been asked to create a spreadsheet to
manage sales informaon per the following informaon:
Sun City's Manager, has implemented some changes within the organisaon and has introduced Excel to
record sales transacons for the company.
The sales consultants frequently ask quesons of their manager about their commission (a payment over
and above wages for meeng sales targets) and she is unable to give them the informaon quickly because
she calculates the commission on a piece of paper at the end of each month.