Lesson video

Hello, my name's Mrs. Jones and I'm really pleased you decided to join this lesson today.

In this lesson, we will look at how to organize data by sorting it.

When you have lots of data, it is helpful to organize it by sorting it.

So for example, you can see what happened at different times of the day.

So let's get started and learn about organizing data by sorting and looking for patterns.

Welcome to today's lesson.

Today's lesson is called, "Sorting Data to Solve Problems" from the unit, "Data Detectives".

And by the end of this lesson, you'll be able to sort and organize data to make it easier to understand.

There are three keywords to today's lesson.

Sort.

Sort is to organize data using a chosen rule.

Organize.

Organize is to arrange data so it is easier to understand.

Pattern.

Pattern is something that repeats or changes in a clear way.

There are two sections to today's lesson.

The first is sort data using a chosen rule.

And the second is organize data to reveal patterns.

So let's start with sort data using a chosen rule.

At Oak Academy Zoo, a rhino called Ruby is missing.

We will look at data to find clues about what might have happened.

We already have some data about Ruby.

To understand it better, the data needs to be organized.

Organizing data means arranging it so it is easier to understand.

And here we've got the zookeeper log for the Rhino enclosure.

And it says 10:30, rhino talk to visitors, nine o'clock, zoo cafe opens, 11 o'clock, enclosure checked.

Ruby not seen.

9:30, Ruby asleep.

10:30, flamingo talk.

8:30, Ruby eating.

10:00, zoo opened, Ruby walking around enclosure.

Jacob says, "It is hard to see what this shows," which is very true.

If you look at it, what are we looking at?

What can we see there?

Sorting means putting data into an order.

In this lesson, you will order data by time.

When data is not organized, it can be hard to see what it shows.

You can sort data using a time rule, for example, earliest to latest.

Sophia says, "We are sorting by time.

" And here you can see that the earliest is 8:30 and then it's 9:30, 10:00, 10:30, 11:00.

So we've started with the earliest and at the bottom, we now have the latest.

The same data can be sorted into different orders.

Changing the order can help us notice different information.

So the table on the left here has the zookeeper log and it starts at 11 o'clock, enclosure checked, Ruby not seen.

10:30, rhino talk to visitors.

10 o'clock, zoo opened, Ruby walking around enclosure.

9:30, Ruby asleep.

8:30, Ruby eating.

And that one you can see is we're starting at the later time and then it goes down to the earlier time.

And the one on the right, we've got the same zookeeper log, but this time, we're starting with the earliest time.

So we start at 8:30 and see Ruby eating.

9:30, Ruby asleep.

10 o'clock, zoo opened, Ruby walking around enclosure.

10:30, rhino talk to visitors.

11 o'clock, enclosure checked, Ruby not seen.

And this one starts earlier and finishes at the later time.

They're both sorted.

The table on the left is sorted to start with the later time and go down to the earlier time and the one on the right is sorted to start at the earlier time and go down to the later time.

Jacob says, "It is the same data, just in a different order," which is a really good point to make.

Organizing data means arranging it so it is easier to understand.

Jacob says, "Now it is easier to see what happened, because now we can see what Ruby did at different times, starting with the earliest, going through to the latest time.

" Sorting is one way to organize data.

In this example, the data has been sorted using time.

Jacob says, "The sorting rule is time.

" We started with the earliest through to the later time.

Data can be sorted by time.

Sorting by time helps us see what happened first and last.

Sophia says, "I can see what happened first and last.

" We can see there that 8:30, the first thing that happened was Ruby was eating.

And the last thing that happened at 11:00 was the enclosure checked and Ruby not seen.

Let's have a quick check.

True or false?

Sorting adds new data.

Is that true or false?

Pause the video and have a think if that's true or false and then we'll check your answer.

Let's check your answer.

The answer was false.

Why is that false?

Pause the video and have a think.

Why is that false?

And then we'll have a look at the answer.

Let's check your answer.

Sorting does not add new data.

It only changes how the same data is arranged.

Well done if you got those correct.

Sorting data does not change the data.

It changes the order so we can understand it more clearly.

Sophia says, "It is the same data just in a different order.

" Sorting helps prepare data so it can be organized and studied more closely.

Before sorting, it is important to decide what information is needed.

Let's have a quick check.

Which sentence best explains why data is sorted?

Is it A, to change the data, B, to make the data look nicer, C, to make the data easier to understand or D, to remove data?

Pause the video and have a think if the answer is A, B, C or D.

And then we'll go through the answer.

Let's check your answer.

The answer was C, to make the data easier to understand.

Well done if you got that correct.

Let's do the activity.

Look at the zookeeper log.

Order the events in the rhino enclosure by time.

You have the zookeeper log for the rhino enclosure and you have 10:30, rhino talk to visitors, 11 o'clock, enclosure checked, Ruby not seen, 9:30, Ruby asleep, 8:30, Ruby eating, 10 o'clock, zoo opened, Ruby walking around enclosure, 10 o'clock, zoo opened, Ruby walking around enclosure.

Pause the video and have a go at that activity.

Look at the data in the zookeeper log and order those events by time, and then we'll go through the answer.

Let's check your answer.

Here we've got the zookeeper log and it's been sorted, so starting with the earliest time going through to the later time.

And we've got 8:30, Ruby eating, 9:30, Ruby asleep, 10 o'clock, zoo opened, Ruby walking around enclosure, 10:30, rhino talk to visitors, 11 o'clock, enclosure checked, Ruby not seen.

Well done if you got that correct.

Let's move on to the second part of today's lesson.

Organize data to reveal patterns.

Organizing data means arranging it clearly.

This might be in a list, table or chart.

You can see here we have the zookeeper log on the left here, and we have it in a table.

And if we sort it, it is organized and this is changing the time, starting at half eight through to 11 o'clock.

When data is organized, it is easier to compare.

Comparing data helps us notice changes or repetition.

Sophia says, "Now I can see the last time Ruby was seen.

" So let's have a look.

And repetition means something that's repeated.

So we've got 8:30, Ruby eating, 9:30, Ruby asleep, 10 o'clock, zoo opened, Ruby walking around enclosure, 10:30, rhino talk to visitors, 11 o'clock, enclosure checked and Ruby not seen.

So now the data is sorted and organized, Sophia can now see when Ruby was last seen.

A pattern is something that repeats or changes in a clear way.

Patterns can appear when data is organized.

So Sophia says, "I can see that the times are ordered clearly.

" Because it goes from 8:30 to 9:30 to 10:00 to 10:30 to 11:00.

There is a pattern with the times.

They are in order.

Some patterns show things staying the same.

Other patterns show things changing over time.

So now we've got the zookeeper log for Monday and Tuesday.

And have a look here we've got, let's compare, at 8:30 on Monday, Ruby is eating.

On Tuesday at 8:30, Ruby is eating.

That is the same.

At 9:30, Ruby is asleep on Monday and at 9:30 on Tuesday, Ruby is asleep.

That is the same.

At 10 o'clock on Monday, the zoo opened and Ruby's walking around the enclosure and on Tuesday at 10 o'clock, the zoo opened and Ruby's walking around the enclosure.

That is the same.

10:30 on Monday, a rhino talk to visitors.

10:30 on Tuesday, a rhino talk to visitors.

We have the same.

11 o'clock on Monday, enclosure checked, all rhinos happy.

Tuesday, 11 o'clock, enclosure checked, Ruby not seen.

We have something that has changed.

This data also shows a pattern.

The cafe opens at the same time each day.

That is a pattern about the cafe.

So you can see the cafe opening times here.

Monday, opens at nine, closes at five.

Tuesday, opens at nine, closes at five.

Wednesday, opens at nine, closes at five.

We have a pattern of those times.

This data shows a different pattern.

Ruby follows the same morning routine before 11 o'clock and that's that data we just looked at for Monday and Tuesday.

We can see that the rhino did the same things between half eight and half 10 on both days, but it was different at 11 o'clock.

Both sets of data shows patterns.

Only one pattern helps answer questions about Ruby.

Sophia says, "We need the pattern that helps with Ruby.

" Jacob says, "The cafe pattern doesn't help us here.

" Let's have a quick check.

True or false?

A pattern is something that we guess when we look at data.

Is that true or false?

Pause the video and have a think and then we'll go through the answer.

Let's check your answer.

The answer was false.

Well done if you got that.

Why is it false?

Pause the video and have a think.

Can you explain why that is false?

And then we'll go through the answer.

Let's check your answer.

You notice patterns by looking carefully at organized data, not by guessing.

Well done if you got that.

Patterns are not guesses.

They are noticed by looking carefully at organized data.

Sophia says, "Patterns come from data, not from a guess.

" Different ways of organizing data can show different patterns.

Sophia says, "When we organized Ruby's data by time, we could see her routine.

" Jacob says, "When we compare the same data across more days, we can see when something has changed.

" A pattern can help you answer questions about what is happening.

The pattern in Ruby's data helps show when Ruby's routine changed.

That was that Monday and Tuesday and we saw that it changed at 11 o'clock, because on Monday, all rhinos were happy when the enclosure was checked.

But on Tuesday, when the enclosure was checked at 11:00, Ruby was not seen.

The pattern changed.

Organized data helps you explain what you notice.

Sorting and organizing data helps you understand information more clearly.

Let's have a quick check.

Which sentence best describes the pattern in Ruby's data?

Is it A, Ruby's routine was different every day, B, Ruby was never seen in the enclosure, C, Ruby followed the same routine before 10 o'clock?

Pause the video and have a think.

Is the answer A, B or C?

And then we'll go through the answer.

Let's check your answer.

The answer was C, Ruby followed the same routine before 10 o'clock.

Well done if you got that correct.

Let's do the activity.

Look at the zookeeper log.

Some information is not about Ruby or the rhino enclosure.

This information can be ignored for now.

The first part is remove any unnecessary data that is not about Ruby or the rhino enclosure.

So we have a zookeeper log and it says, "10:30, rhino talk to visitors.

9 o'clock, zoo cafe opened, 11 o'clock, enclosure checked, Ruby not seen, 9:30, Ruby asleep, 10:30, flamingo talk, 8:30, Ruby eating, 10 o'clock, zoo opened, Ruby walking around enclosure.

" So the first part is to remove any unnecessary data that's not about Ruby or the rhino enclosure.

Pause the video.

Have a go at that first part of the activity and then we'll go through the answer.

Let's have a look at the answer.

So the time that the zoo cafe opens and the time of the flamingo talk do not help us in finding out about Ruby.

So that's the information we can remove.

There's the zoo cafe opening at nine o'clock and there's the flamingo talk at 10:30.

Well done if you got that.

Let's look at the second part of the activity.

Look at the organized data about Ruby.

Write one sentence to describe the pattern and then write one sentence to explain what the pattern tells us.

Pause the video, have a look at that data for Monday and Tuesday, and write one sentence to describe the pattern and one sentence to explain what the pattern tells us.

And then we'll go through the answer.

Let's have a look at the answer.

So Sophia says, for writing one sentence to describe the pattern, that Ruby eats her breakfast at the same time every day.

That's one sentence that describes a pattern.

Well done to Sophia and well done if you've got one of those as well.

And then Jacob says, for explaining what the pattern tells us, he's put, "I can see that at 11 o'clock on the Tuesday, Ruby was not seen.

She must have gone missing before then.

" Well done if you got those correct.

In summary, you can sort data in different ways using chosen rules.

Organizing data makes it easier to read and understand.

Sorting the same data in different ways can help to show different information.

When data is organized clearly, patterns can appear.

These patterns help us notice what is staying the same and what is changing.

Well done for completing this lesson, "Sorting Data to Solve Problems".