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
|
|
|
|
Task |
VLOOKUP Walkthrough 2
|
|
|
|
Task |
Class VLOOKUp task
|
|
|
|
classxx.xls
|
Jobs VLOOKUp task
|
|
|
|
jobs.xls
|
Magazines VLOOKUp task
|
|
|
|
magazines.xls
magazines answers.xls
|
Fuel VLOOKUp task
|
|
|
|
fuel.xls
fuel answers.xls
|
Cats VLOOKUp task
|
|
|
|
cats.xls
cats answers.xls
|
Zones VLOOKUp task
|
|
|
|
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
|
|
|
|
task
|
Copyright © www.teach-ict.com
