| |
|
3 |
|
|
|
L
|
QCA Scheme of Work - Introducing databases |
|
|
| |
|
3 |
|
|
|
LP
|
Medium term planning - Introduction to Databases |
|
|
| |
|
3 |
|
|
|
A
|
Lesson 1 - Self assessment (databases) |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 1 - Class database |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 1 - Record cards |
|
|
| |
|
3 |
|
|
|
PS
|
Lesson 2 to 5 - How to do various database skills |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 2 - Questions to answer using the database |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 3 - Formatting cells |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 4 - Sorting databses |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 5 - Applying filters |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 5 - Applying filters (worksheet) |
|
|
| |
|
3 |
|
|
|
PS
|
Lesson 6 - Instructions for creating a graph in excel |
|
|
| |
|
3 |
|
|
|
PS
|
Lesson 6 - Instructions for creating a pie chart in excel |
|
|
| |
|
3 |
|
|
|
WS
|
Lesson 6 - Creating a bar graph and a pie chart |
|
|
| |
|
3 |
|
|
|
PS
|
Lesson 7 to 10 - Connectives to use in reports |
|
|
| |
|
3 |
|
|
|
SC
|
Lesson 7 to 10 - Success criteria for reports |
|
|
| |
|
3 |
|
|
|
O
|
Lesson 7 + 8 - Census database (fictitious other school) |
|
|
| |
|
3 |
|
|
|
O
|
Lesson 7 + 8 - Census database |
|
|
| |
|
3 |
|
|
|
M
|
Lesson 7 + 8 - Comparing Census Data from Our School and fictitious other school |
|
|
| |
|
3 |
|
|
|
O
|
Lesson 9 + 10 - Census database (fictitious our school 100 years ago) |
|
|
| |
|
3 |
|
|
|
M
|
Lesson 9 + 10 - Comparing Census Data from Our School today with 100 years ago |
|
|
| |
|
3 |
|
|
|
O
|
Lessons 1 to 10 - Tick list of who has done what |
|
|