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

This engaging lesson introduces students to the role of an Administrative Assistant, focusing on the key tasks, duties, skills and personal qualities required in a modern workplace. Through structured activities, discussion tasks and presentation work, students develop a clear understanding of the difference between job responsibilities and individual skills, preparing them for real-world employment contexts. ✔ What’s Included Teaching PowerPoint with structured lesson delivery Activities exploring: Tasks and duties of an Admin Assistant Skills and qualities required for the role Interactive discussion and classification tasks Final presentation task to consolidate learning Real-world links to recruitment and job roles ✔ What Students Will Learn Students will: Understand the difference between tasks/duties and skills/qualities Identify key responsibilities of an Administrative Assistant Explore essential workplace skills such as: Communication Organisation Reliability IT competency Apply knowledge to real-world job scenarios ✔ Skills Developed Workplace awareness and employability skills Communication and discussion Organisation and critical thinking Presentation skills Understanding of recruitment processes ✔ Why Teachers Love This ✔ Clear, structured lesson with ready-to-use slides ✔ Strong real-world links to employment ✔ Encourages discussion and student engagement ✔ Ideal for Admin & IT and Business courses ✔ Minimal preparation required ✔ Perfect For KS3 Admin & IT Business Studies Employability / careers education Introductory units on workplace skills

✔ What Students Will Do Students will: Use Slide Master to create consistent designs Apply timed transitions and animations Structure presentations for a specific audience Create visually engaging and professional slides Combine text, images and design effectively ✔ Skills Developed Students will build: Advanced PowerPoint design and formatting skills Understanding of presentation timing and delivery Consistency in layout using master slides Attention to detail and visual communication Digital presentation and creativity skills ✔ What’s Included Student task sheet with clear instructions Structured activities focusing on advanced features Opportunities for independent and creative work Real-world context for presentation design ✔ Why Teachers Love This ✔ Builds on prior knowledge – ideal progression from basics ✔ Focus on high-impact, real-world skills ✔ Encourages creativity alongside technical accuracy ✔ Ready-to-use resource with minimal preparation ✔ Suitable for assessment or extended projects ✔ Perfect For KS3–KS4 Computing / ICT Presentation skills units Coursework or project-based learning

This practical, real-world project introduces students to key administrative and research skills by placing them in the role of an Administrative Assistant. Students use online tools to plan routes, research travel options, and present accurate information for business purposes. The resource combines maps, driving directions, rail and air travel research into a structured and engaging set of tasks. ✔ What’s Included Student workbook 1: Maps & Driving Directions tasks Student workbook 2: Rail and Air Travel research tasks Teaching PowerPoint with clear instructions and context Step-by-step activities based on a realistic business scenario ✔ What Students Will Do Students will: Use Google Maps to: Find routes and directions Calculate travel times (driving and walking) Extract specific instructions from journeys Research rail and flight options based on given criteria Capture and present evidence using screenshots Apply problem-solving skills to real-life admin scenarios Plan travel arrangements for business purposes ✔ Skills Developed Students will build: Online research and digital literacy skills Accuracy when handling real-world information Understanding of travel planning and logistics Screenshotting and evidence presentation Administrative and organisational skills ✔ Why Teachers Love This ✔ Clear, structured tasks with real-world relevance ✔ Develops essential Admin & IT skills ✔ Ready-to-use – no preparation required ✔ Engaging scenario-based learning ✔ Ideal for both classwork and cover lessons ✔ Perfect For KS3 Computing / ICT / Admin & IT Digital skills and research units Business and travel-related topics

✔ What’s Included Full student workbook / booklet with step-by-step activities Teaching PowerPoint to support each lesson Structured tasks covering key programming concepts Clear progression from basic skills to independent project work ✔ What Students Will Learn Students will develop understanding of: Algorithms and computational thinking Using sprites and backgrounds Creating and controlling animations Writing simple programs using: Sequence Selection Repetition (loops) Debugging and improving their work ✔ Why Teachers Love This ✔ Complete unit – no preparation required ✔ Perfect for students with no prior coding experience ✔ Clear, step-by-step structure builds confidence ✔ Engaging tasks that promote creativity ✔ Ideal for both specialist and non-specialist teachers ✔ Perfect For KS3 Computing / ICT Introduction to programming Cover lessons or full half-term units

What Students Will Do Students will: Create and calculate a payslip using Excel Use formulas to work out: Gross pay Tax deductions Pension contributions Bonuses Net pay Apply basic Excel functions and formulas Present their information clearly using Microsoft Word Skills Developed Students will develop: Spreadsheet skills (formulas, functions, calculations) Understanding of income and deductions Financial literacy (tax, pensions, bonuses) Data presentation and formatting Digital document creation using Word What’s Included Excel task/activity (payslip creation) Structured instructions for students Word task for presenting financial information Real-life scenario to support learning

This engaging, real-world project places students in the role of a band manager, responsible for organising a European tour. Students must plan and manage all aspects of the trip, including travel, accommodation, budgeting, and promotion. The project develops a wide range of administrative and IT skills through a creative and practical scenario that students find highly motivating. ✔ What Students Will Do Students will: Plan a European tour for a band Research and compare: Flights Hotels Travel routes Design marketing materials such as posters Organise and present key information clearly ✔ Skills Developed Students will build skills in: Online research and decision-making Digital design and marketing (posters) Organisation and administrative skills Problem-solving in real-world scenarios ✔ What’s Included Student project brief with clear instructions Structured tasks covering each stage of the project Opportunities for independent and creative work Realistic scenario to support engagement ✔ Why Teachers Love This ✔ Cross-curricular project combining ICT, Business and creativity ✔ Encourages independent thinking and research ✔ Real-life context that students relate to ✔ Flexible – can be used as a short project or extended unit ✔ Minimal preparation required ✔ Perfect For KS3–KS4 Computing / ICT / Business Studies Project-based learning End of unit projects or enrichment activities

LEARNING INTENTIONS/SUCCESS CRITERIA I can use functions of technology to prepare and communicate simple information I can use presentation software to produce simple presentations by:  inserting, editing and formatting text  aligning text  inserting graphics from an e-file or the internet  using bullets  creating chart(s) and/or table(s)  adding and deleting a slide  animating text/objects  importing data from other applications/internet  changing slide content layout  applying slide transitions  changing slide order  applying and changing background, design and colour schemes  printing presentation in slide and handout format • Demonstrates an understanding of how digital literacy will impact on their future learning and career pathways. • Consistently use a range of devices and digital software and applications and services to share, create, collaborate effectively and publish digital content online

THE WORKSHEET IS SET UP FOR TRNSMT BUT IT FITS ANY FESTIVAL You work as a Senior Administrator for ‘What’s On Now’, an Event Management company based in Glasgow. You are helping plan and coordinate TRNSMT 2025. You have been asked to prepare a presentation with some key information to be presented at the upcoming planning meeting. Your presentation should make use of the following features: • Master Slide – Add the TRNSMT logo to every slide in the top right corner • Watermark on every slide which reads ‘Draft’ • Action Buttons – Next/Backwards on each slide, Information button (where relevant) and a Home button on the final side. • Design template • Transitions & Animations • Images throughout Your Presentation should be printed in • 4 Slides Horizontal • One sided • Landscape Orientation • Colour • Date & Time • Your name in the header

In this task pupils are tasked to book accommodation and travel to the 2026 World Cup held in Mexico/Canada/USA. They will have to select appropriate flights and accommodation for each match their chosen country has to play.

*Please email gw21hampsondale@glow.sch.uk for access to the Database Engage students with databases using a FIFA Ultimate Team themed project. This resource uses a database of 15,000+ real football players and challenges pupils to build queries in Microsoft Access to create the best possible Ultimate Team. Perfect for teaching database fundamentals, querying, and data handling in a fun, real-world context that students immediately recognise. What’s Included FIFA Ultimate Team Microsoft Access database containing 15,000+ players Student workbook / class booklet introducing Microsoft Access Step-by-step activities covering: Adding records Editing records Deleting records Understanding database structure 50+ query challenges where students must search the database to build their Ultimate Team Teaching PowerPoint to guide lessons and support delivery What Students Will Learn Students will develop skills in: Understanding databases, tables and records Creating and modifying queries Filtering and sorting data Using criteria to answer questions Applying database skills to solve problems Why Teachers Like This Resource Highly engaging FIFA theme that motivates students Large realistic dataset (15,000+ players) for meaningful queries Structured activities that build skills progressively Ready-to-teach with PowerPoint and student booklet included Ideal for introductory database units or Microsoft Access lessons

What Students Will Do Students take on the role of a travel planner for a school trip and must: Research flights to Paris Compare hotel options and prices Investigate Disneyland Paris ticket costs Calculate estimated overall trip costs Organise information clearly Create a PowerPoint presentation to present the trip to parents at an information evening Skills Developed Students will develop skills in: Online research and evaluating sources Cost comparison and budgeting Organising and summarising information Designing effective PowerPoint presentations Communicating ideas clearly to an audience What’s Included Student task sheet explaining the project Clear instructions for the research task Guidance on what must be included in the presentation A realistic scenario to support independent work

Using BBC Bitesize pupils are tasked to research how they can be safe online. The worsksheet then asks pupils to complete an E-mail and match up task to summarise their learning

The Goldrush Spreadsheet allows pupils to practice basic functions such as = - * / at varying difficulty levels.