Using search tools

Computing

Creating a paper-based database

Computer databases

Using a database

Comparing data visually

Databases in real life

This unit looks at how a flat-file database can be used to organise data. Pupils will use tools to order and answer questions about data. They will create graphs and charts from their data to solve problems. They will use a real-life database to answer a question, and present their work to others.

Flat-file databases

Which operator is used to narrow a search by requiring all conditions to be met?

Which operator is used in a search to find records that meet at least one of the given criteria?

Why is it useful to use both AND and OR in a search?

Find students in Year 5 or who play football.

Find students in Year 5 and who play football.

Which of the following searches correctly uses the AND operator to narrow results?

It narrows the search to find records that meet all given criteria.

It produces more results than a search with a single condition.

It has no effect on the number of results.

It deletes records that do not meet any given criteria.

What happens when you use the AND operator in a search?

What does the term 'criteria' mean in the context of data?

What process organises data values in a specific order, such as alphabetical or numerical?

Click on the field name again to sort in descending order.

Arrange the steps for sorting data in descending order in the correct sequence.

Why might grouping and sorting be combined?

to look for specific information in a database using a rule

to arrange data values in a specific order

information that is stored, processed or analysed

Match the keywords to their correct definitions.

to display only the records that match a condition

Introduction

What will you need for this lesson?

Are you ready to learn?

Equipment

Worksheet