Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood School Trips - Coggle Diagram
Westwood School Trips
Equal share of total cost from each pupil for the trip
Use of coach-£2100
Airport transfers-£560
Flight-£7230
Visits-£2485
Accommodations-£9225
The pupils whe then have to pay 3 instalmenst
Instalment 1:25%
Instalment 2:25%
Instalment 3:20%
Client Requirments
Store details about pupils and staff
Follows WST house style/branding by reflecting logo
Allow manager to record details of pupils and of staff
Have an easy-to-use HCI that supports navigation between worksheets
Record payments on behalf of each pupil as
Yes
or
No
using data validation
Calculations
Breakdown of costs for individual item per pupil
Cost of deposit to be paid by each pupil
Cost of each instalment being paid by each pupil
Number of deposits paid
Total value of deposits paid
Total number of each instalments paid
Total value of each instalment paid
Total value of payments received
Total value of outstanding payments
Output results based on the calculations
The total value of deposits and instalments paid
The value of deposits and instalments paid
A breakdown of the cost per pupil
A comparison between total payments and made any outstanding payments
A list of the details for all pupils with outstanding payments and what the outstanding payments are for, including their value
Have and appropriate validation to minimize errors in the data
Have an appropriate security measure to ensure no unauthorised people have access and users cannot accidently delete data or formulae
Have appropriate validation
The booking system can only be opened by authorised people using the password
***WST@27
*
Appropriate charts which include:
Assets
WST_Staff_Data.csv
- details about the staff going on the map
WST_Pupil_Data.csv
- details about the pupils interested in the trip
WST_Payments_Received.csv
- details about the pupil payments received
WST_logo.jpg
- the logo for WST
WST_Test_Plan.rtf
- the test plan for new booking system