Lesson video

Hello.

My name's Mr. Little.

Welcome to today's computing lesson.

I'm really excited to be learning with you today, and the lesson title is Collecting Data, and that's from the unit, Introduction to Spreadsheets.

I know if you work hard and try your best, you are gonna make today's lesson a success.

Are you ready to get started? Brilliant.

Let's go.

There's four key words for today's lesson, and I want you to listen out for them and look out for them in this lesson video.

The first key word is data.

And you might have heard that word before in maths, or science, or even computing, but data in today's lesson means facts and figures in their raw form.

The second key word is row, and that's a line of data in a table that runs horizontally.

The third key word is column, and that's a group of data in a table that runs vertically.

And the final keyword for today's lesson is spreadsheet, and that is an electronic document that stores data arranged in rows and columns.

Keep an eye out for these keywords in today's lesson.

Today's lesson is split into three parts.

First of all, we're gonna collect data.

I'll introduce you to Laura here, and she's been tasked with collecting some data.

She says here, "I went outside every hour to record the temperature on the school field at each hour of the school day." What Laura's done is she's collected some raw data on the temperature at certain times of the day.

The data she has collected is the temperature in degrees.

Let's have a look at what she collected.

So, it looked like she's written down the temperature at 9:00 was 12 degrees.

At 10:00, it was 13 degrees.

11:00, 17 degrees.

Ooh, it's getting warmer.

12:00, it was 21 degrees.

1:00, 22 degrees.

2:00, 22 degrees again.

And 3:00, it was 20 degrees.

So every hour, Laura has gone out onto the school field and written down the time and the degrees in temperature.

That's the data she's collected.

Let's look at our definition of data, because it's one of our key words.

Remember, data is facts and figures in their raw form.

Raw form means that the facts and figures haven't been changed or adapted or organised in any way.

The data Laura collected is in its raw form and it's not very useful yet.

Time to check your understanding of what data is.

So, choose the correct option here.

Data is a, needed for computers to work, b, facts and figures in their raw form, or c, just numbers.

It's b, data is facts and figures in their raw form.

Well done if you got that right.

There's lots of different types of data that can be collected, and I've given some examples here.

Data could be your attendance at school.

When you go to school in the morning and probably in the afternoon, your teacher takes the register and that marks your attendance, and that data is collected and stored somewhere.

You could collect data on your score in a video game perhaps, or if you're rolling a dice, you could collect what number you rolled.

Also, things you might buy at a shop or a supermarket are collected as pieces of data.

And you could also collect data on your eye colour or your friend's eye colour.

What other examples of data can you think of? You might have said things like your daily step count, your heart rate, the number of hours you sleep.

You can collect data on the speed of a car, or an aeroplane, or a boat or how much money you might have in your bank.

Let's check your understanding of different types of data here.

So the question is which of the following are examples of data you could collect? A, the number of vegetables you eat in a week, b, your score in a game, or c, your classmates' hair colour.

It's actually all three.

All three of these pieces of data are things you could collect.

You might try and eat lots of vegetables in a week and be really healthy.

You could collect data on your score in a game you play.

And also you could collect data on your classmates' hair colour.

Okay, let's put all of that knowledge about data into a task.

We've got Jun and Izzy here.

They're talking about what data is and some types of data that Jun could collect.

I've given you some sentence starters here, and I want you to discuss what Jun should say to Izzy.

So, I want you to step into Jun and describe what data is, what we use computers to do, and give some examples of data that Jun could collect.

Now, there's lots of things you could have said for this task, but here's some really good examples of what Jun could have said to Izzy.

He could have said, "Data is facts and figures in their raw form." That's our definition of data.

Jun could have said, "We use computers to collect, store, and organise data." And some examples of data that Jun could collect are the names of his classmates, his score in a game, or the number of vegetables he eats in a week.

In the second part of today's lesson, let's look at how to organise data.

Let's go back and think about Laura's example of when she collected data on the temperature during the school day.

Now, we use computers to collect data, to store data, to keep it, and to organise data.

And here Laura says, "I wrote down the temperatures I collected.

Now I'm gonna use a computer to store and organise this data." When data is recorded, it's really important for it to be organised, so it can be understood easily by everyone.

Let me give you an example here.

When I was growing up, my parents always said to me, "Make sure your bedroom is really tidy, so you and we can find what we are looking for." And I'm sure perhaps at school, it's really important to keep your classroom tidy or perhaps if you've got a cloak room area, teachers often say, "Keep that cloak room tidy, so everyone can find what they need." I'm sure you can think of an example of where keeping things organised makes things easier for everyone.

Laura has recorded her data in a table, so it can be easily understood by more people and by her.

So in her table here, she's got the headings time and temperature in degrees.

So at 9:00, the temperature was 12 degrees and at 10:00, the temperature was 13 degrees, and so on.

This table make makes Laura's data easily understood by everyone.

Now when data has been organised and it's been given a meaning, we call it information.

And Laura has said here that the information shows her that it was coldest at 9:00 in the morning 'cause it was 12 degrees and that's the lowest temperature.

Also, it tells us that it was warmest at 1:00 and 2:00, because the temperature here was 22 degrees.

Sounds like a warm day, doesn't it? Let's check your understanding of why it is important to organise data.

Is it a, so it can be easily understood by only one person? Is it b, so it can be easily understood by everyone? Or is it c, so it can be easily copied? Well done if you selected b.

It's important to organise data, so it can be easily understood by everyone.

Have a look at this image.

Do you recognise it? This is from a computer programme called a spreadsheet.

Now, a spreadsheet is an electronic document that stores data.

So, you can access spreadsheets on phones, on computers, on tablets, on laptops, and it's something that stores data for you.

Lots of people use spreadsheets to make it easier to organise data.

How do you think spreadsheets make things easier? It's because spreadsheets help to organise data into a table.

I'm sure you've used tables before.

In work, you might have done perhaps in science, or maths, or any subject perhaps, and it a table really helps to organise data.

Let's go back to Laura and her example of collecting the times and the temperatures.

Laura says here, "The data I collected is now organised in a spreadsheet.

It's easier for me and others to understand." Now, one of the really clever ways spreadsheets help to organise data is organise things into rows and columns.

So, let's have a look here at what rows are.

A row is a line of data in a table that runs horizontally from left to right Here, row 1 is highlighted.

Look at the number on the left hand side of the spreadsheet.

It says 1.

And then, horizontally means going from left to right or right to left.

But on a spreadsheet, we normally read left to right, like you do when you are reading a book.

Let's check that understanding.

Is this true or false? A row is a line of data that runs horizontally from left to right.

It's true.

Well done.

Let's look at the word column here.

It's one of our key words.

A column is a group of data in a table that runs vertically from top to bottom.

So, the opposite of horizontally, left to right or right to left, is top to bottom, vertically.

So, a column is a group of data that runs vertically from top to bottom.

Here, I've highlighted column A.

Okay, let's pause and let's check your understanding here to see if you know what a column is in a table.

So the question is which answer correctly describes what a column is in a table? Is it a, a group of data in a table that runs diagonally? Is it b, a group of data in a table that runs horizontally? Or is it c, a group of data in a table that runs vertically? It's c, a column is a group of data in a table that runs vertically.

B is a row, isn't it? A row runs horizontally.

Columns run vertically.

Let's look at the rows and the columns on Laura's spreadsheet when she recorded the temperature data.

Can you spot the columns and the rows on Laura's spreadsheet? What do they tell us? Here, column A shows the times and column B shows the temperatures.

And if I wanted to know a time and a temperature, so the temperature at a certain time, I could look at a row and read it left to right.

And here's the example.

Row 5 shows the temperature at 12:00 was 21 degrees.

Okay, let's put all that knowledge you've learned about organising data into a practise task now.

Listen carefully here.

Sofia has collected and recorded data on the temperatures for another day at school up until 1:00 PM.

I want you to record Sofia's data into a spreadsheet.

So, look at the raw data.

Sofia said that at 9:00, it was 10 degrees.

10:00, it was 14 degrees.

11:00, 18 degrees.

12:00, 21 degrees.

And 1:00, 22 degrees.

I want you to try and record this data onto a spreadsheet.

Now, remember to put some headings at the top for time and temperature in degrees.

And in your columns, you're gonna write the time and the temperature and the rows should read the time and what temperature it was.

Let's look at Sofia's completed spreadsheet here.

She's put time and the temperature in degrees as her headings.

She's used her rows and columns in her spreadsheet, so her data is now organised.

And we can read from her table to say that at 9:00, it was 10 degrees.

At 10:00 it was 14 degrees.

At 11:00, it was 18 degrees.

At 12:00, 21 degrees.

At 1:00, 22 degrees.

For the third part of today's lesson, you are gonna collect and organise data in a spreadsheet.

So remember, we know before you organise data in a spreadsheet, the data needs to be collected.

Think back to Laura's example of collecting the data for the temperatures in the school day.

Here's Sofia, and she's gonna collect data in a different way and it's gonna be different data.

So Sofia says, "I'm gonna collect, I'm gonna play a dice game with my classmates and collect the data to see who scores the most points.

Each player will roll a dice five times.

I'll collect the number rolled and the total score to see who scored the highest." Sofia asks Alex, Izzy, Aisha, Jacob, and Jun to each take a turn to roll a dice five times, while she collects the data.

Now here, Sofia might collect her data.

On paper, she might write it down using a pencil and paper, or she might collect her data directly into a spreadsheet.

So, Alex has five turns to roll his dice, and each time he rolls, Sofia writes down the score that's shown on the dice.

And Alex then gives the dice to Izzy, and Izzy has her five turns while Sofia records her scores.

And then Aisha, then Jacob and Jun.

Let's pause to check your understanding here to see if you understand the data that's being collected.

So, the question is it's a true or false one.

In Sofia's game, the number each player rolls on the dice is data.

Is that true or false? It is true.

Can you explain why that is? It's true because the data that's rolled on the dice is a figure, it's a number.

And each player rolls a number into Sofia's game and that number is a piece of data that's being collected.

Okay, let's take a look at Sofia's results.

She's organised her data into a spreadsheet, but she's forgotten to add something.

What does Sofia need to add to make her data easier to understand? Remember, she's collected the number of player rolls and the total score.

Izzy said, "I've added headings to my data." So, one of you have suggested that.

That this data now makes sense for everyone.

I can see for roll 1, Alex scored 2, Izzy scored 5, Jun scored 5, Jacob scored 4, and Aisha scored 6.

And I could go down each column to see the roll number and the score that each person got.

Or if I wanted to read just Izzy scores, for example, 5, 4, 5, 3, and 1, I could read across the rows.

And also at the end, there's a column for the total of a player score.

I'm sure you agree this data is now easy to understand as a spreadsheet.

Let's check your understanding of what Sofia did.

The question is by adding headings to her spreadsheet, what has Sofia done? Has she a, made her data more difficult to understand, b, made her data neither easier nor more difficult to understand, or c, made her data easier to understand.

It's c, she's made her data easier to understand, hasn't she? Okay, just before we go into a task, let's look at a conversation between Jacob and Izzy.

Izzy asked Jacob, "What do I need to remember when collecting and organising data in a spreadsheet?" Jacob's got a great response, "You need to collect your data first, use a table and add headings to your rows and columns." Remember, that makes the data easy for everyone to understand.

So, time for a practise task.

The first thing you need to do is think of a type of data you want to collect.

Now, you could collect data on lots of different things.

I suggest here you collect data on something that's easy to collect.

For example, it might be the different eye colours for people in your class or it might be your classmates' favourite fruits or vegetables.

You might collect their shoe sizes or you could, like Sofia did, collect the numbers for a dice game.

Once you've decided that, think about the headings for what needs to be collected, like if you are collecting someone's eye colour, you'll need to collect their name and the colour of their eyes.

If you are collecting their favourite fruit or vegetable, you might collect their name and the name of the fruit or vegetable.

Then, I want you to collect your data and record it in a spreadsheet.

Now, a top tip here, you might collect your data first on paper.

So in a book or on the worksheet, you can write down someone's name and their eye colour, someone's name and their favourite fruit or vegetable, someone's name and their shoe size, or someone's name and the score they roll on the dice.

And then, you might transfer it and organise it onto a spreadsheet.

Now, this example is probably gonna be different to yours 'cause we've collected names from the Oak classmates and Jacob's collected an example of favourite fruits.

So, let's take a closer look.

Let's look at the columns, name and favourite fruit.

They have headings and that makes it easy for me to understand what Jacob's collected data on.

In the first column, he's written the pupil's name.

So his classmates' names Alex, Izzy, Jun, Sofia, Aisha, Alex, and Lucas.

And next to it, he's written their favourite fruits.

So, Alex likes strawberries.

Izzy likes apples.

Jun likes strawberries too.

Sofia's favourite fruit is coconut.

Aisha's is lychees.

Alex really likes pears and Lucas likes dragon fruits.

Okay, we've come to the end of today's lesson.

Let's summarise what you might have learned.

Remember, we can collect data about different things.

And in today's lesson, our Oak pupils have collected data on examples such as the temperature during the school day, the numbers pupils roll on the dice game, or their classmates' favourite fruits.

And it's really important to organise that data, so it's easy to understand.

When you organise that data into a table, it really helps especially when you label the rows and the columns.

And finally, remember, a spreadsheet is a tool on a computer that can be used to organise and record data.

Thanks for learning with me today.