EDEXCEL IGCSE ICT Unit 6 – Excel Advanced: IF, COUNTIF & COUNTIFS – Warner Brothers Abu Dhabi Projec

This fully resourced ICT IGCSE Edexcel Unit 6 lesson focuses on advanced Excel skills, teaching the use of IF, COUNTIF, and COUNTIFS formulas to analyse visitor survey data from Warner Brothers World Abu Dhabi. It is part of a wider scheme of work on advanced Microsoft Office skills that meets the Unit 6 requirements for Word, PowerPoint, and Excel.

The lesson also includes a mini case study on Demis Hassabis (founder of DeepMind), the Theme Park video game, and Warner Brothers World Abu Dhabi, providing engaging real-world and cultural links.

The lesson includes:

Tutorial videos throughout, enabling students to work at their own pace and revisit demonstrations as needed

Literacy and numeracy starter activity

Reading comprehension task on Demis Hassabis, Theme Park, and DeepMind

Stretch activities for higher-level challenge

Ready-made lesson plan

Homework sheet

Literacy support mat

Marking crib sheet

This resource is designed for use in international schools but works equally well in the UK. The combination of high-interest, real-world examples, guided video instruction, and differentiated activities ensures accessibility for a wide range of learners.

All profits from this resource support charitable initiatives, including refugee assistance, youth sports, educational programmes, and environmental carbon capture, making our work carbon negative.