Unit 9 spreadsheet Task 2 Intended purpose and

Unit 9 spreadsheet Task 2

Intended purpose and user requirements • My spreadsheet will be used for the local cinema’s • I’m making it for the cinema to help record the members • The managers can access the spreadsheet to monitor how many memberships have been sold, how much the price for memberships are, they can use it too allocate seats to the member once the memberships have been sold. Check what type of memberships are available. Also the managers can update information on the spreadsheet ie: change prices, add more types of membership, update membership details, monitor sales and • What kind of data can be outputted for the user? (e. g. reports, graphs/ charts) • Worksheet 1 – Menu/Homepage • Worksheet 2 – Membership holder details • Worksheet 3 – Summary of information • Worksheet 4 – Annual membership type details

Worksheet structure diagram Menu sheet Worksheet 1 Membership holder details Worksheet 2 Summary of information Worksheet 3 Annual membership type details

Planning the worksheets Menus Sheet Annual membership types Membership – holder details Information Summary Annual membership types

Output Plan Table labelling the information on membership. Table including members and their numbers. Table including number of available seats Pie chart used as a visual aid to help understand the membership figures.

Test plan Test data Expected outcome Did it work Errors/ solutions Page buttons Take them to each equivalent page. Yes N/A Count if function Counts the amount of seats in a certain area Yes N/A Sum/multiplication function Does corresponding and works out money made Yes N/A Conditional formatting Changes the colour of the seats when they are booked out Yes N/A

Final Evaluation • My spreadsheet is easy to access and the format is quite user friendly. It is easy for the user of the spreadsheet to input data and the pages of the spreadsheet also shows the data in a nice aesthetic way. There also some functions used these help with ease of access.