Based on some of the information in UNIT 5B (QCA)
Using simple Databases
Objectives:
technique: to search a database using different fields.
key idea: that searches can be carried out using more than one criterion
technique: to search a database using 'AND'
technique: to search a database using 'OR'
key idea: that information found is often unhelpful
technique: to skim read and sift information to modify a search strategy
- to use complex searches to locate information
- to use IT to test an hypothesis
(2Simple 2Investigate)
Lesson 1
Intro- recap on Databases units in both year 3 and 4. specifically the questioning element within branching databases. Draw similarities to the questions they had to create previously giving a true or false answer.
Show example of example record and each field, highlighting the differences of entering text and entering an option from the drop down lists.
Demonstrate how to upload an image and where to find resources needed on the school network.
Using a previously created shared class database based on the personal details of the class. Fields should include written information unique to the individuals, as well as using lists for example eye colour and hair colour.
Recap on the meaning of fields and records within a database and how to add a new record.
Demonstrate how to upload an image or draw a picture of themselves.
While individuals are adding the information at different times the database will not be ready to use until all fields are complete.
Fields to include in the database:- Photo, first name, last name, D.O.B, age, eye colour, hair colour, height, favourite food, Favourite TV, Favourite Hobby, Best friend
EXT:-
Recap on grouping and sorting within a database, using the fruit database already stored with 2investigate.
Sort using different fields and with a partner make up questions and find the answers taking it in turns.
Lesson 2
Make sure that the photos taken of individuals are added to the database.
Add the heights of individuals who didn't have this information during the previous lesson.
Clarify misconceptions on some of the fields that were not entered correctly.
Using the shared database answer the questions using the sorting and grouping facility.
Lesson 3
Finish questions and answers from last lesson if not yet complete.
With a partner create a folder on the shared network inside Databases (Class name), labelled with your initials and your partners initials and your class name. This is where you will save your database when you create it.
Discuss what group of objects/animals etc- you might want to create a database on. Once you both agree, start to do a little research.
You will need to read some information first with a test subject to help you decide on the field you will need for your database. You should have at least 6 fields. You will also need some images so save them in your pictures ready to import later.
Once you have designed your database, you can then create records. You should have a minimum of 10 records sharing the imput as 5 each.
Lesson 3
Finish questions and answers from last lesson if not yet complete.
With a partner create a folder on the shared network inside Databases (Class name), labelled with your initials and your partners initials and your class name. This is where you will save your database when you create it.
Discuss what group of objects/animals etc- you might want to create a database on. Once you both agree, start to do a little research.
You will need to read some information first with a test subject to help you decide on the field you will need for your database. You should have at least 6 fields. You will also need some images so save them in your pictures ready to import later.
Once you have designed your database, you can then create records. You should have a minimum of 10 records sharing the imput as 5 each.
Pupil Self Assessment
I know what a database is used for
I have participated in a class shared database.
I can load and prepare a database?
Enter data into a database?
Check for mistakes in the data and change them?
Sort the data?
Search the database to answer questions?
Show data as a graph
Use a CD-Rom to find a topic, or search an alternative database; for example within a program or on the www?
Enter accurate data to achieve accurate results?
add and remove data from records?
Design a data collection form and accurately collect data
Make my own database?
Save my own databases?
Search and sort?
Enter and read data?
Print from my database?
I have added collected information to a database. I have used it to answer my questions and to locate a relationship between areas of data?
