Please enable JavaScript.
Coggle requires JavaScript to display documents.
Screenshot 2026-06-01 092123 - Coggle Diagram
Task 1 - Planning & Design
Data Storage
Pupil details
Staff details
Scenario
5-day Barcelona trip
30 pupils
3 staff members
Staff funded separately
Spreadsheet-based booking system
Payment Structure
Deposit (30%)
Instalment 1 (25%)
Instalment 2 (25%)
Instalment 3 (20%)
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
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
