SOFTWARE SKILLS
Excel 2003: VLOOKUP
The ticks indicate the suitability of resources for each Key Stage.
Resource |
KS3 |
KS4 |
KS5 |
Click Here |
VLOOKUP Walkthrough 1
|
|
|
|
![download file](/w40.jpg)
Task |
VLOOKUP Walkthrough 2
|
|
|
|
Task |
Class VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
classxx.xls
|
Jobs VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
jobs.xls
|
Magazines VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
magazines.xls
![click here](../../../images/buttons/clickhere.gif)
magazines answers.xls
|
Fuel VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
fuel.xls
![click here](../../../images/buttons/clickhere.gif)
fuel answers.xls
|
Cats VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
cats.xls
![click here](../../../images/buttons/clickhere.gif)
cats answers.xls
|
Zones VLOOKUp task
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
zones lookup.xls
|
Hogwarts 1 and 2
This spreadsheet exercise provides students with an opportunity to practise:
- setting up validation (task 1)
- lookup tables (task 2)
Extension tasks are provided
Contributed by Jon Bridgeman of Finham Park School
|
|
|
|
![click here](../../../images/buttons/clickhere.gif)
task
|
Copyright © www.teach-ict.com