Lesson details

Key learning points

  1. In this lesson, we will use database search tools. We will search for results using 'AND' 'OR' criteria.

Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

Loading...

3 Questions

Q1.
Which column has this data been sorted by?
Correct answer: Area
Country Name
Currency
Population
Q2.
The data below has been produced by a search. What was searched for?
Area = 505,990
Currency = Peso
Correct answer: Language = Spanish
Q3.
By which fields has this data been searched and sorted?
Currency then Area
Correct answer: Currency then Population
Language then Area
Population then currency

3 Questions

Q1.
Which search term would return these results?
Age = 37
Correct answer: Boarded = Southampton
Class = 2nd
Gender = Male
Q2.
What would you search for to answer this question – ‘How many males under ten years old were on board the Titanic?
Correct answer: Gender AND Age
Gender AND Class
Gender OR Age
Name AND Age
Q3.
What would you search for to answer this question – ‘Altogether, how many people boarded at the highlighted places?’
Age = 10 and Boarded = Belfast
Correct answer: Boarded = Belfast or Boarded = Queenstown
Boarded = Queenstown and Boarded = Belfast
Boarded = Queenstown or Age = 10

Lesson appears in

UnitComputing / Flat-File Databases

Computing