Hello, my name is Mrs. Antrobus.

Welcome to "Computing".

I'm so glad you could join the lesson today.

Today, we're going to look at analysing data using a computer.

Welcome to today's lesson from the Data Logging unit.

Today's lesson is called "Analysing Data Using a Computer." And by the end of this lesson, you'll be able to recognise how a computer can help us to analyse data.

During today's lesson, we'll be using these key words.

analyse.

analyse, to look at something in more detail to further understand it.

Dataset.

Dataset, a collection of related data that's been structured in some way.

Import.

Import, copying a file or data into a programme from a different programme.

Export.

Export, saving a project in a file format so that it can be used in another programme.

Today's lesson will be broken down into two parts.

You're going to view and read data in the first section.

And then in the second section, explain the different ways to view data.

Let's get started.

Scientists collect and use data when carrying out experiments.

A data set is a collection of related data that's been structured in some way.

For example, a scientist might have a data set about the impacts of medicine over a period of time on particular people.

When scientists collect data, it is usually stored so that it can be used later.

The data can also be shared so that other scientists can work with it.

A data logger was set up, shown in the photo.

"The cup contained very hot water." "The metal probe is a temperature sensor." "It has been plugged into the data logger so that it can collect the readings." You might think, "Well, why is a probe needed when the data logger already has a temperature sensor?" Well, the probe allows for a more accurate reading and of extreme temperatures.

"The cup contained very hot water." "What happens to hot things if they are left in a room?" "What might the data logger graph look like?" I just want you to pause the video and think about that for a moment.

Okay, so what did you think? Well, what happens to hot things if they are left in a room? They tend to go down in temperature.

So, what might the data logger graph look like? If you look at these four graphs, which one do you think would represent the hot water in the cup? This graph would represent the hot water in the room over a period of time as it would gradually become cooler, so this graph makes most sense.

What do these graphs show? Will these graphs show the readings from the data logger? Which graph shows the temperature? The middle image is a temperature graph.

Okay, let's check your understanding.

What is this graph most likely showing? Is it A, the temperature in a classroom? B, the sound from a rock concert? Or C, the light levels from teatime to bedtime? Look at the graph.

The data readings are very up and down.

Think about it.

Pause the video.

Okay, how did you get on? Well, if you said B, the sound from a rock concert, you'll be correct.

Because as I said earlier, we can see the readings are up and down, high and low, which represent music.

What is this graph most likely showing? A, the sound recording from an assembly? B, the light levels of a theatre show? Or C, the temperature of a kettle boiling and cooling? So, look at this graph.

It goes up and then it goes down.

Pause the video and think about it.

Okay, how did you get on? Well, if you said, C, the temperature of a kettle boiling and cooling, you'll be correct, because the graph represents the kettle gradually getting hotter and the data readings going up.

It reaches the boiling point, and then the water starts to cool down and we can see the readings go down.

Well done.

Let's have a closer look at the graphs from the data logger.

Clicking anywhere on the graph will show the readings for that time.

For example, here, is 23 degrees Celsius at 16 minutes.

Let's have a look at task A.

By clicking on the graph or using the 'All Data Table' button, answer these questions.

One, what was the highest temperature? Two, what was the lowest temperature? Three, what was the temperature at the start, and then after one, two, three, four, and five hours? Please remember that the data logger may not have recorded data exactly on the hour, so select the nearest time.

Pause the video and give this some thought.

Okay, how did you get on? Let's have a look at some example answers.

What was the highest temperature? Well, we can see here that the highest temperature was 23 degrees C.

What was the lowest temperature? Again, we can see that the lowest temperature was 16 degrees C.

It's the lowest point of the graph.

And when we put our mouse over it, it tells us it was 16 degrees C.

What was the temperature at the start and then after one, two, three, four, and five hours? Well, we can see here it was at 23 degrees C.

Then after one hour, it was 22 degrees C.

Two hours, was 21 degrees C.

Three hours, was 20 degrees C.

Four hours, it was 19 degrees C.

And at five hours, it was 18 degrees C.

How did you get on reviewing and reading the data in the graphs? Did you find it easy or maybe it was a little bit tricky? Don't worry if it was, you'll get better with practise.

Let's move on to the second part of today's lesson, explain the different ways to view data.

Data can be presented in tables, charts, graphs, or maps, depending on what is most useful for understanding it.

it is important to use the correct presentation format.

Data can be displayed in summary form or in more detailed views depending what the data is representing.

When you gather data using a data logger, it is possible to view the data collected in different ways.

You could look at the data in a graph like we can see here.

Graphs can support people in understanding complex data.

They give a visual picture of the data and show trends and patterns that might not be immediately apparent within tables of data.

Often if the data is quite complex, graphs are easy to understand and might be used in presentations by teachers, or maybe if a business owner was presenting some information about the amount of profit they've made over a period of time.

You can also view this data in a table within the data logger software.

We can see on this table we have five columns data points, which has the number of each data point from zero to four, the time that each data point was collected, and then the temperature, light, and sound levels, which are recorded in degree C, for temperature, lux, for light, and decibels, for sound level.

And within each column, there are numerical values that represent each one.

Viewing the data in a table format can be helpful.

The data is organised into a structure which can make it easier to understand.

This is the same data exported into a spreadsheet programme.

Again, we can see the columns represented by letters, B, C, D, E, and rows, represented by numbers, 1, 2, 3, 4, 5, 6.

But the same data is contained.

We have the date and we have the time.

We have the temperature in degree C, the light level in lux, and the sound level in decibels, and it contains the same readings.

Exporting the data to a spreadsheet also allows you to sort the data.

First of all, open the data file in a spreadsheet programme.

When you open the programme, you'll see a table that looks like this.

And if you watch this video on the right hand side, you will see, you click somewhere on the top row and then click the 'filter' button.

You click on the column heading, and as you'll see here, you can sort the data into ascending or descending order.

Let's just watch this for a moment.

You can see here that the temperature has been sorted into descending order.

The light level has been sorted into descending order and can also be changed to ascending order.

So, spreadsheets are very useful at allowing you to sort the data into different orders so that it's easy to view.

Sourcing the data in a spreadsheet can help you to analyse and understand the data.

Data can be sorted by different fields to make it easier to spot trends or locate specific information.

For example, if you had the names of somebody in a spreadsheet, it would make sense to have them sorted into ascending order from A to Z.

Then you would easily be able to find the correct person because they would be in alphabetical order.

Okay, let's check your understanding.

Name four different ways that data can be presented.

Is it A, tables? B, charts? C, graphs? Or, D, maps? Pause the video and give this some thought.

Okay.

How did you get on? Well, if you said A, B, C, and D, you would be correct because tables, charts, graphs, and maps are all different ways that data can be presented.

Well done if you remembered that.

Okay, let's check your understanding again.

Give two reasons why you might export the data from the data logging software.

Think about what we've just been looking at and the benefits of exporting the data from the data logging software.

I'll give you a minute to think about that and we'll come back.

Pause the video.

How did you get on? Well, if you wrote something like "you can sort the data", or "You can share the data with others who don't have the data logging software," you would be correct.

That's because once you've exported the data into a spreadsheet, you can sort the data ascending A to Z order, or descending Z to A order.

You can also share the data with other people.

You can easily attach the spreadsheet to an email and send it to somebody so they can access the data as well because they might not have the data logging software that you have in school.

Well done for having a go at this question.

Let's move on.

In this lesson, you have viewed data as a graph, as a table in the data logging software and as a spreadsheet.

Well done.

Isn't it interesting how data can be presented in lots of different ways? Why do you think it's beneficial to use a computer to view the data in different ways? Pause the video and think about that.

Okay, what did you come up with? Maybe you thought that it was beneficial because you can present the data in different ways for different purposes, or for different reasons.

Did you think about how much data a computer can analyse? Let's just think about that now.

Computers make it easier and faster to analyse large amounts of data.

Computers could log data throughout the night.

They can log data once every tenth of a second.

They can even log data in places where humans can't go.

For example, the temperature of volcano.

It would be impossible for humans to log data in this way, so you can see how computers do make it easier and faster to analyse large amounts of data.

Okay, let's have a look at task B.

First of all, you need to explain the different ways that you can view data collected by a data logger.

And then you're going to give an advantage for using each method.

I want you to pause the video and have a go at the task.

Okay.

How did you get on? Let's have a look at some example answers.

You should have identified that graphs is a way to view data collected on the data logger.

Jun says, "You can present data collected by data logger in a graph.

I like to use graphs because they help me to see the data clearly.

I can also use them in presentations as visual representation of my data for an audience." That's a good response from Jun.

How does yours compare? Have you put lots of detail in like Jun? Well done.

Let's have a look at the next one.

You can also view the data collected in a table.

Izzy says, "You can view the data collected from the data logger in a table.

I like to use tables because they are detailed and allow me to analyse the data closely.

If it's a really big data set, it can be tricky to analyse the data, so sorting it can be helpful to reveal trends and patterns." Did you identify that a table is a way to view the data from a data logger? And, do you agree with Izzy that actually being able to put it into a table makes it easier to analyse, especially if you've got a large data set? Because you can sort the data, which makes it easier to understand.

You are doing great so far.

Keep going.

Did you remember that a spreadsheet is another way that you can view data from the data logger? Well, Alex says, "You can export data from the data logging package into a spreadsheet format.

My Dad uses Excel and my Mum uses Google Sheets, but they don't have the data logger software that we have in school.

I could export the file so that they can import it into their chosen spreadsheet package and view the data too!" Okay, so Alex makes some good points there.

You may use Excel or you may use Google Sheets.

It doesn't really matter when you are exporting the data from the data logger because the data will be able to be read on either the software package.

And once you have that data in your spreadsheet package, you can edit it, you can analyse it, and you can share it with other people.

Well done on completing task B, you've been able to explain the different ways to view data.

So now we've come to the end of our lesson.

You've done a fantastic job, so well done.

Let's summarise what we've learned today.

Computers make it easier and faster to analyse large amounts of data.

Data can be displayed in summary form or in more detailed views.

Data can be sorted by different fields to make it easier to spot trends or locate specific information.

Data can be presented in tables, charts, graphs, or maps, depending on what is most useful for understanding it.

I hope you've enjoyed today's lesson and I look forward to seeing you next time.