Databases


Unit 3c: Introduction to databases
In this unit children learn to collect and store information involving more than two variables. They will use a database to answer simple questions by sorting and finding the top or bottom and searching in a single field.

Lesson Plan 1: Identifying properties of a database
Children will identify records and fields of a database.  Children will identify advantages and disadvantages of using databases.

Lesson Plan 2: Selecting appropriate information to place into a database
Children will be able to select the appropriate information to insert into a database.  Children will be able to read information from a database record to describe a minibeast.

Lesson Plan 3: Opening Junior Pinpoint and inserting information into a database.
Children will be able to open Junior pinpoint and open a pinpoint file.  Children will be able to insert records into a database.  Children will be able to insert information into fields of a database.

Lesson Plan 4: Browsing a database
Children will be able to look through a database to find information.  Children will be able to think, discuss and try different searching methods.

Lesson Plan 5: Making a bar chart
Children will be able to make a bar chart from the database information.  Children will be able to read and compare information on a bar chart.

Lesson Plan 6: Compiling a database
Children will be able to insert a complete record into a database using a variety of different formats of answer.

Lesson Plan 7: Searching a database
Children will be able to search a database to answer questions.

Lesson Plan 8: Searching a database using a database tool
Children will be able to search a database to answer questions.

PPF: minib.ppf
A database with records already created for a range of minibeasts.  Great for showing children how a database works, how to create and search records.  Links with a Science topic on Minibeasts.  Children could create additional records linked to the minibeasts studied in class.

PDF: Minibeast question sheet
Question and answer sheets extracting information from minib.ppf.  Understanding of the language of databases (fields, records etc) is consolidated.  A set of questions that will extend childrens knowledge and encourage active use of a database.

PDF: Who am I? (Teachers copy)
An elimination worksheet encouraging children to actively use and search the minibeast database to find out which minibeasts meet the criteria given. A useful assessment activity that tests childrens ability to search, manipulate and match data. The important pieces of information are highlighted in red to aid children in finding the answers.

PDF: Question sheet for MYCLASS file
A set of questions for children to answer using the myclass database. Focuses children on the information available within the database and the scope of information provided. Involves answering questions involving only.

PDF: Question sheet for MYCLASS file (Second sheet)
A more advanced set of questions for children to answer, involving 2 and 3 criteria. Will challenge the more able child and develop understanding of how database records work with the class. A variety of questions help children to think about and organise the data in different ways.

Edmark
Great newsletter! Get it!

Index

Wayne
Update
August  2005