Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood School Trips (WST) Booking System - Coggle Diagram
Westwood School Trips (WST) Booking System
Scenario
5-day Barcelona trip
30 pupils
3 staff members
Staff funded separately
Spreadsheet-based booking system
Costs
Flights (£7,230)
Accommodation (£9,225)
Visits (£2,485)
Airport Transfers (£560)
Coach (£2,100)
Total Cost
Calculate overall trip cost
Split equally between 30 pupils
Payment Structure
Deposit (30%)
Instalment 1 (25%)
Instalment 2 (25%)
Instalment 3 (20%)
Task 1 - Planning & Design
Data Storage
Pupil details
Staff details
Branding
WST logo
House style
HCI Design
Easy navigation
Worksheet links/buttons
User-friendly layout
Data Entry
Record pupil details
Record staff details
Validation
Yes/No payment entries
Minimise errors
Security
Password:
WST@27
Protect formulas
Protect worksheets
Outputs Planning
Charts
Cost breakdown per pupil
Number of payments made
Value of payments made
Payments vs outstanding
Reports
Outstanding payments list
Pupil details
Amount owed
What-if Analysis
36 pupils instead of 30
Accommodation reduced by 5%
Task 2 - Spreadsheet Creation
Import Assets
Pupil Data CSV
Staff Data CSV
Payments CSV
WST Logo
Calculations
Per Pupil Costs
Flights
Accommodation
Visits
Transfers
Coach
Payment Calculations
Deposit amount
Instalment 1 amount
Instalment 2 amount
Instalment 3 amount
Payment Monitoring
Number of deposits paid
Value of deposits paid
Number of instalments paid
Value of instalments paid
Total received
Outstanding payments
Data Integrity
Validation rules
Protected formulas
Locked cells
Future Predictions
36 pupil scenario
5% accommodation reduction
Task 3 - Testing & Evaluation
Testing
Use provided test plan
Complete all tests
Record results
Screenshot evidence
Evaluation
Solution Effectiveness
Meets requirements
Accurate calculations
Useful outputs
HCI Effectiveness
Easy to use
Easy navigation
Clear design
Required Outputs
Charts
Cost breakdown per pupil
Number of deposits/installments paid
Value of deposits/installments paid
Payments received vs outstanding
Lists
Pupils with outstanding payments
Outstanding payment type
Outstanding payment value
Assets Provided
WST_Pupil_Data.csv
WST_Staff_Data.csv
WST_Payments_Received.csv
WST_logo.jpg
WST_Test_Plan.rtf