| Year
9 Project - Data Handling (Unit 9.2) |
||||
This
is lesson 3 |
||||
Previous
lesson |
Planning
And Creating A Data Structure |
Next
lesson |
||
We
Are Learning
To... |
What
I'm Looking
For... |
At
the end of the lesson can you... |
||
|
1. create a data structure to contain data by choosing appropriate field and data types. |
1. Powerpoint slide about data structure completed. |
1. plan a suitable structure to collect data. 2. annotate a print-out or presentation to demonstrate your understanding of data types datatable structure. |
||
| 2. A correct data table created using MS Access. | ||||
| 3. Three 'mock' records entered into your data table. | ||||
| Click here to remind you what this project is about | ||||
Starter |
Lesson
- What you need to do |
At
the end of lesson... |
||
| 1. Show Lesson 3 powerpoint show (slide 2). Work in pairs to construct a table on your paper / writing pad. 2. Construct or show a table on the IWB - Lesson 3 powerpoint show (slide 3) 3. Complete the planning sheet before moving on to creating the data table. |
1. Teacher will demonstrate on IWB how to create a table using database software. 2. Pupils to create your own data structure using MS access database software. 3. Pupils to enter 3 'mock' records into the table and print 1 record. |
1. Some pupils to show their data tables on IWB and explain the selection of fields and data types. 2. Make sure you have recorded your WILF in your homework booklet. 3. Complete yourLesson Diary in your homework booklet. |
||
Resources: |
Resources: |
Resources: |
||
| Homework booklet to write down today's WILFs | MS Access database | Homework booklet to show homework |
||
| Paper / Writing pads to construct a table to hold answers from questionnaires. | IWB to show data tables and data types | |||
| Lesson 3 powerpoint show | Homework booklet to complete your Lesson Diary | |||
| Funbrain wordsearch maker | ||||
| Important
Words: Database, table, record, field, fieldname |
||||
| Extension
Work: |
||||
| Some special links | ||||