Y4 Unit 2 Part 2

Unit 2 : Be a
Data Controller

In this unit, you will learn about databases, forms and sorting data.
You will learn:

• about paper-based and digital databases

• about using form to collect data

• about data and information

• to sort data into order

Drag and Drop

A ​ ​

Placeholder

is a ​

Placeholder

of ​​

Placeholder

data.

Drag these tiles and drop them in the correct blank above

database

collection

related

Multiple Select

Two types of databases :

• Physical database

• Digital database

• Bluetooth database

Multiple Select

Choose words that describe data.

• raw

• meaningless

• no context

• processed

Multiple Select

Choose words that describe information.

• organized

• meaningless

• meaningful

• processed

Sorting Data
Ascending & Descending Order

​Ask 5 students of various height to stand in front of the class.

​Ask 5 students of various height to stand in front of the class.
What type of sorting we can ask them to do?

​Ask 5 students of various height to stand in front of the class.
What type of sorting we can ask them to do?
HEIGHT

Height

• tallest to shortest

• shortest to tallest

Height

• tallest to shortest (descending)

• shortest to tallest (ascending)

​What does this mean?

Ascending

• A to Z

• 1 to 100

• Shortest to tallest

• Youngest to olders

​What does this mean?

Descending

• Z to A

• 100 to 1

• Tallest to shortest

• Oldest to youngest

​Sorting Words

​cloud circle donkey dinosaur

Sort these in ascending order

​Sorting Words

​cloud circle donkey dinosaur

Sort these in ascending order

• Look at the first letter, if it the same then :

• Look at the second letter.

• So the answer is :
  

​Sorting Words

​cloud circle donkey dinosaur

Sort these in ascending order
Look at the first letter, if it the same then :
Look at the second letter.
So the answer is : circle, cloud, dinosaur, donkey

Open Ended

Sort these in descending order :

cloud, circle, donkey, dinosaur

​Not all data follows an ‘ascending’ or ‘descending’ order.
For instance, there is no ascending or descending order of colors.

• ​Data can be sorted using a spreadsheet.

• The Sort feature is used to put data in ascending and descending order.

​Tutorial for using Spreadsheet

​https://online.visual-paradigm.com/app/office/#proj=0&type=Spreadsheet&office-new

Online Spreadsheet

Microsoft Excel

​Task 1

• Do Practice on Page 30 -

• Type the raw data

• Copy and paste into 4 tables with heading.

• Label them with these sorting:

  • Sort your data into 4 categories as below:

    • ascending order by First Name

    • descending order by First Name

    • ascending order by Age

    • descending order by Age

• Give a title for your sheet - Sorting Name

​Task 2

• Type these items in the spreadsheet. Sort these in ascending order :

  • pencil

  • ruler

  • notebook

  • markers

  • paper

​https://play.blooket.com/play

​Task 3

• Type the names of 10 family members or random people in the spreadsheet (in Column A).

• Sort the names in two categories :

  • ascending order

  • descending order

• Type their ages in the column next to their names (in Column B).

• Sort the list of ages in :

  • ascending order

  • descending order

Choose your activity :

1. sis-lower.typingclub.com

2. toytheater.com