This scheme of work and many of the materials was originally developed by Andrew Colley, AST and Tony Salter, Head of ICT
Andrew has kindly let us use his materials in order to create the lesson plans, starter and plenary activities.
| Lesson 1 | Link |
|---|---|
| Lesson Plan |    |
| Famous people quiz.xls |  |
| Famous people quiz answers | |
| Elephant Quiz stage 1.xls | |
| African elephant.jpg |  |
| Asian elephant.jpg |  |
| Video: 1. Getting set up.wmv | |
| Video: 2. IF functions.wmv | |
| Video: 3. Conditional formatting.wmv | |
| Video: 4. Countif function.wmv | |
| Lesson summary (subscription only) | |
| School tests hw.xls | |
| Lesson 2 | Link |
|---|---|
| Lesson Plan | |
| Spreadsheet quiz task 2 | |
| Elephant quiz stage 2.xls | |
| Video: 5. Formatting.wmv | |
| Video: 6. Print area.wmv | |
| Video: 7. Lock cells.wmv | |
| Stand up, sit down.ppt (subscription only) |  |
| Lesson 3 | Link |
|---|---|
| Lesson Plan | |
| Word association.doc (subscription only) | |
| Own quiz task sheet.doc | |
| Paper planning sheet.doc | |
| My quiz feedback sheet.doc | |
| Lesson 4 | Link |
|---|---|
| Lesson Plan | |
| 10 questions starter.doc + ppt(subscription only) | |
| How my quiz works.docx | |
| Assessment | Link |
|---|---|
| Mark sheet (subscription only) | |
Copyright © www.teach-ict.com