EDEXCEL IGCSE ICT Unit 6 – Excel Advanced: Data Validation & VLOOKUP (Lesson 2 of 2)

This fully resourced ICT IGCSE Edexcel Unit 6 lesson teaches advanced Excel skills, including creating drop-down lists with data validation and using VLOOKUP to display data based on the selected list value. It is the second part of a two-lesson Excel project and uses the theme of offshore wind farms and renewable energy, with a focus on Europe and the North Sea.

The lesson includes:

Literacy and numeracy settler activity

Bespoke online quiz to assess progress throughout the lesson

Stretch task with each activity

Recap task for homework

Example videos throughout, allowing students to re-watch demonstrations at their own pace for independent learning

Complete lesson plan

Additional files for students to quickly begin editing datasets

This resource provides step-by-step guidance for mastering advanced Excel functions while linking learning to real-world environmental and energy contexts.

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