Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood swim centre spreadsheets - Coggle Diagram
Westwood swim centre spreadsheets
calculations
the total number of weeks attendant by each swimmer
income generated from who's made a block booking before/after 10% is applied.
income generated from who's made a class booking
total income generated from each swimmer that's attended classes but not made a block booking.
total income generated for each swimming class before/after 10% discount
total income per week before/after discount
fastest time for each swimmer
which swimmers have attended each week and will therefore get a voucher at a local sports shop
user requirements
store details about swimmers who have taken part in swimming lessons
allow staff and Taylor to record class attendance for weeks 1-5
allow staff and Taylor to record the fastest swimmers for week 6,7 and 8
record payments for either class or block bookings using data validation
compare the income generated from block bookings before and after 10% discount
see the effect on business income if £1.25 applied(its only applied for swimmers who pay per class not by block booking
house style
blue
white
clear font
size of font(not too small/too big)
follow logo
font that follows logos theme
black ops one(font)
lists
appropriate lists for fastest time for each swimming classs
any other suitable lists
graphs
graph for fastest time for each swimmer
any other suitable graphs
user interface
easy to use
target audience
Taylor
other staff members
buttons
home button
graph button
spreadsheet button
items button?
