DEXCEL IGCSE ICT Unit 6 – Excel Advanced: Named Range, AVERAGE, MAX, MIN, Sorting & Filtering – Duba

This fully resourced ICT IGCSE Edexcel Unit 6 lesson focuses on advanced Excel skills, including the use of Named Range, AVERAGE, MAX, MIN, sorting, and filtering to analyse spending data from Dubai Mall. It forms part of a wider scheme of work on advanced Microsoft Office skills that covers the Unit 6 requirements for Word, PowerPoint, and Excel.

The lesson also includes a short case study on Dubai Mall and the Burj Khalifa, providing an engaging real-world context for the data analysis tasks.

The lesson includes:

Lesson plan

Tutorial videos throughout, allowing students to work at their own pace

Literacy and numeracy starter activity

Reading comprehension task on Dubai Mall

Stretch activities for higher-level challenge

Homework sheet

Literacy support mat

Marking crib sheet

This resource is designed for use in international schools but is equally effective for UK-based classes. The combination of clear video tutorials, differentiated tasks, and real-world case study content makes it ideal for independent learning, classroom teaching, or blended delivery.

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