Please enable JavaScript.
Coggle requires JavaScript to display documents.
westwood village hall hire - Coggle Diagram
westwood village hall hire
prices
£42.50 a hour
£245 full a whole day
half day is 50% of a full day
extras
tables
chairs
kitchen
tables and chairs
password to protect data
WVH#26
calculate
total bookings made in october
number of bookings made by each customer in october
total number of each type of booking (hourly rate/half day/full day)
total income generated from booking the hall in october excluding extras
total bookings made that include extra items
income generated from extra items in october
total income generated in the months october
total income generated from each customer in october
house style
green
light blue
beige
trees
client requirements
store details about who has booked the hall
follow WVH house style/branding by reflecting the logo
easy to use human computer interface
allow manager to record the hall bookings
allow manager to record any extra items included with each booking
record the booking type as hourly or full day using data validation
assets
WVH_October_Bookings.csv
WVH_Customers.csv
WVH_Extra_Item_Costs.csv
WVH_Logo.jpg
WVH_Test_Plan.rtf
Customer 203
date of invoice
customer ID
Booking number and date of booking
cost per booking
total cost
functionality
formulas
=Vlookup
=sum
=cell
=countif
=max
=min
sorting
filtering
data validation
format check
length check
range check
lookup table
presence check
security
data verification
double entry
proofreading data
HCI
purpose
navigation
layout
accessibility
large letters
easy to read font
colour
memorability
outputs
charts
lists
invoices
worksheets