This engaging Zombie Survival Shop spreadsheet project is designed for KS3 and KS4 ICT / Computing students and introduces spreadsheets through a fun zombie apocalypse theme.

Students create and improve a basic survival shop spreadsheet using formulas, cell formatting, currency, conditional formatting, stock control, and simple spreadsheet modelling techniques.

The resource pack includes a detailed teacher PowerPoint, worked teacher example spreadsheet, student worksheet, and editable student template spreadsheet, making it ideal for both specialist and non-specialist teachers.

Inspired by my other popular classroom projects such as Lemonade Stand and Theme Park Tycoon spreadsheets, this resource helps students develop practical spreadsheet skills in an accessible and motivating way.

Suitable for Microsoft Excel or compatible spreadsheet software, the activities encourage problem solving, logical thinking, and creativity while supporting UK Computing and ICT curriculum objectives for data handling and modelling.

Key Topics & Skills Covered

• Spreadsheet formulas
• Basic financial modelling
• Stock control
• Profit calculations
• Cell references
• Currency formatting
• Conditional formatting
• Spreadsheet modelling
• Data handling
• Microsoft Excel skills
• Zombie apocalypse themed learning
• ICT project work
• KS3 Computing
• KS4 ICT
• Functional spreadsheet skills
• Problem solving with spreadsheets
• Beginner spreadsheet lessons
• Engaging spreadsheet project
• Excel activities for secondary school students