Databases

Unit 5B

This is an interesting and important unit which builds on the database work which has gone before in Years 2, 3 and 4.

Key objective	Can use ‘AND’, ‘OR’, ‘=<’ and ‘=>’ in database searches.	QCA Website
Activity 1 Answering questions	Download and open the file 'Survey' into Information Workshop 2000. Use the sort and search tools to answer the following questions: Who is the tallest person? Who is the tallest boy? Who is the shortest person with blonde hair? Who is the tallest person whose eyes are not blue? How may people's height is greater than 130 cm? How many people's weight is less than or equal to 30 Kg? Devise some questions of your own.	Survey
Activity 2 AND and OR searches	Download and open the file 'Vehicles'. Work through a scenario which illustrates AND and OR searches. Reload 'Survey' and explore the use of AND and OR searches.	Vehicles
Activity 3 AND and OR Internet searches	Explore the use of AND and OR searches from Google's Advanced search page.	www.google.co.uk

This unit, though important, should not take very long to deliver.

Key objective	Is able to interpret, check and question data; recognise that poor quality information leads to unreliable results.	QCA Website
Activity 1 Looking for errors	Download and open the file 'errors'. Use the graphing, searching and sorting tools to identify implausible data. Consider the types of errors which cannot be identified using the above techniques.	Errors

Deputy Training Unit Files T.Barrett

We will be working in Microsoft Word and Information Workshop.

End of Unit Sleuthing!

Extension Tasks: KidsMAPE Website - Whodunnit? A Sherlock Holmes style database game.