This engaging, real-world project places students in the role of an Administrative Assistant responsible for creating and managing receipts for a music festival.

Using Microsoft Excel, students develop key spreadsheet skills while learning how businesses record and organise financial transactions.

✔ What Students Will Do

Students will:

Create professional receipts using Excel
Input and organise financial data
Use formulas to calculate:
Totals
VAT (if included)
Final costs
Format spreadsheets clearly and professionally
Apply their work to a music festival scenario
✔ Skills Developed

Students will build:

Spreadsheet skills (formulas, formatting, calculations)
Understanding of financial documents
Attention to detail and accuracy
Real-world admin and business skills
Digital organisation and presentation

✔ What’s Included

Student task sheet with clear instructions
Teaching PowerPoint with open ended questions and scenarios
Realistic business scenario
Opportunities for independent work

✔ Why Teachers Love This
✔ Real-world context students understand and enjoy
✔ Combines Excel skills with business knowledge
✔ Ready-to-use – minimal preparation required
✔ Ideal for both lessons and cover work
✔ Clear outcome (completed receipt document)
✔ Perfect For

KS3–KS4 Computing / ICT
Admin & IT
Business Studies
Spreadsheet units