Task 3
Use the database to answer the following questions:-
Which countries have an area less than 50,000?
Which countries speak English as their first language?
Which country uses the Yen as it's currency?
Which country uses the Euro as it's currency and has an area less than 50,000?
Challenge
Make a database for the European Union. Pupils can define their own records.
Follow up activities
Learning can be reinforced using the minibeast cards and database. This would link well to science work on animals and their habitats.
Starter Cards: j2e.com/data/minibeastscards
Database: j2e.com/data/examples/minibeasts
Introduction
Print out the starter cards (enough for one set per small group) and ask them the following questions. Which country has the largest population?
Which country covers the smallest area?
Which 3 countries have the smallest population?
Prior to the lesson, open the counties template (see Resources above) and save a copy in your own area. Then share the file with the class by clicking on the blue share button at the top. Click on the blue arrows at the end of the box. This will give a list of users to share with. Select your class.
Assessment
Children can save their work enabling the teacher to assess what they have produced after the lesson.
Learning Objectives
Design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information.
Database 1
KS2
Learning Outcomes
All children: will collect and present data and information.
Most children: will collect, present and analyse data and information.
Some children: will collect, present, analyse and evaluate data and information.
Cross curricular links
Key Stage 2 - Maths
Solve one-step and two-step questions [for example, ‘How much more is this item?’ and ‘How much less is that item?’ using information presented in scaled bar charts and pictograms and tables. Interpret and present data using bar charts, pictograms and tables.
Upper Key Stage 2
Complete, read and interpret information in tables. Begin to decide which representations of data are most appropriate and why.
Vocabulary
Resources
Starter Cards:
Template: j2e.com/data/examples/countries
Task 1
Load the database template.
Stop the class
Explain to the pupils that we can use a database to find information quickly. Ask the question "which country has the largest population?". Find the answer by first clicking on the table tab of the database. Then click the relevant field and use the up or down arrows.
Task 2
Use the database to answer the following questions:-
Which country has the smallest population?
Which country covers the largest area?
Which 3 countries are the largest in population?
Stop the class
Show the pupils how to use a query to answer more complex questions (see starter video). For example, which countries have the Euro as their currency.
Main Activities
Using the blank starter cards create fact files for the following countries (or choose your own)
- Portugal
- New Zealand
- Austria
- Australia
You can use https://en.wikipedia.org (but remember that the pupils will need to double check the information).
Recap what a database is, explaining the meaning of field, datatype and record. Use the starter video as appropriate.
Load the database template and show the information. Draw attention to the fields and datatypes. Transfer information from one of the new data cards, to the database. Pupils will be able to add data in a later lesson.