video

Lesson video

In progress...

Loading...

Hello, my name is Mrs. Holbrough and welcome to computing.

I'm so pleased you've decided to join me for the lesson today.

We are going to be using spreadsheets in today's lesson.

We are going to investigate the difference between data and information and compare different sources of data.

Then we will collect our own data for a purpose.

Welcome to today's lesson from the unit data modelling.

This lesson is called "Collecting Data for a Model." And by the end of today's lesson, you'll be able to explain the difference between data and information, and know that data can come from a range of sources.

You'll need to have access to some spreadsheet software for this lesson.

Shall we make a start? We will be exploring these key words during today's lesson.

Data.

Data.

Facts and figures in their raw form.

Information.

Information.

Data that has been given structure or meaning.

Primary.

Primary.

Collecting data yourself.

Secondary.

Secondary.

Someone else collects the data.

There are three parts to today's lesson.

We'll start by looking at the difference between data and information.

We'll then go on to compare primary and secondary sources of data, before finishing with collecting data for a purpose.

Let's start by looking at the difference between data and information.

What is the difference between data and information? Perhaps pause your video here whilst you have a think.

Sam's got a brilliant response.

Data is raw facts or figures without any meaning.

I cannot see what these numbers are about.

This data has now been converted to information.

This is information because it is organised and has meaning.

The headings explain what the information is about.

The table has been sorted with the highest medal winners at the top.

So we can clearly see that this table is all about Olympic medals.

We can see that the Olympic medals are divided into categories of gold, silver, and bronze, and a total has been calculated for each country.

Time to check your understanding.

Is this data or information? Pause the video here whilst you have a think.

That's right.

It's data.

At the moment, this data doesn't have any meaning.

It's just the number 1500.

I don't know what that 1500 refers to.

Is this data or information? Pause the video here whilst you have a think.

That's right.

This is information.

Because the table has headings and is organised into a particular way.

This data has moved into being information.

I can now quite clearly see that the 1500 is the number of magazines sold.

Okay, we are now moving on to the first task of today's lesson.

So for task A part one, I'd like you to explain the difference between data and information.

And then for part two, I'd like you to explain how a spreadsheet can be used to convert data into information.

Pause the video here whilst you complete the activity.

How did you get on? You're doing a great job so far.

So well done.

Let's have a look at some sample answers together.

So for part one, you were asked to explain the difference between data and information.

Data is raw facts or figures without any meaning.

Information is data that has been processed and organised to have meaning.

For part two, you are asked to explain how a spreadsheet can be used to convert data to information.

A spreadsheet can organise data into tables with column and row headings to explain what the data is about.

A spreadsheet can also be formatted to pick out key bits of information that may be useful for the reader.

Did you have a similar response? Remember, if you need to add any extra detail, you can always pause your video here.

You're doing a great job so far, so well done.

We are now going to move on to the second part of today's lesson, where we are going to compare primary and secondary sources of data.

How can data be collected? Perhaps pause your video here and have a think.

Sam's got a good idea.

You can use paper questionnaires.

Laura's also got a good idea.

You could use an online poll.

And Jun's saying you can count things and keep a record.

These are all excellent ways that we can collect data.

Did you have any others? Data can come from lots of different sources and these sources can be categorised as primary or secondary.

Primary data is data that you have collected yourself.

For example, going out to your class and asking them questions from a questionnaire.

Secondary data is data that someone else has collected.

So for example, you might have been asked to create a report for a history project.

You may go out to the internet and collect some data on different websites.

Time to check your understanding.

Primary data is data that someone else has collected.

Is this true or false? Pause your video here whilst you have a think.

That's right.

It's false.

Well done.

Primary data is data that you have collected yourself.

Sam's got a really good question here.

What is the benefit of primary data? So what's the benefit of going out and collecting data for yourself? Maybe pause the video here and have a think.

Jun's got a brilliant answer.

Primary data is data you collect yourself for a specific purpose, so it'll be totally suitable for what you need.

Time for a quick check.

Which of the following is not an example of primary data? Is it A, a poll you give your class to ask if they have a smartphone? Is it B, government statistics on how many children have smartphones? Or C, an interview you have with a friend about how they use their smartphone? Pause the video here whilst you haver a think.

Did you select B? Great work.

Government statistics on how many children have smartphones is actually an example of secondary data, because you haven't collected the data yourself.

Okay, now time for our next activity of today's lesson.

You're doing a great job so far, so keep going.

For task B part one, I'd like you to complete the table to state whether the source of data is primary or secondary.

So in the table we've got four sources of data, and in the empty column you need to write either primary or secondary as your answer.

Pause the video here whilst you complete the activity.

How did you get on? Great work so far.

Let's have a look at some sample answers together.

So you were asked to complete the table to state whether the source of data is primary or secondary.

The first source of data was a weather station publishes a report comparing rainfall this year and last year based on data they recorded.

This is primary data because the weather station is collecting the data and publishing the report for themselves.

The next one was a national newspaper publishes an article titled "Most popular GCSE subjects this year," based on data that was published by the government.

This is secondary data because the newspaper or journalist hasn't collected the data themselves.

They've used government statistics.

The third one was that your school website has a page showing the popularity of different subjects based on the class sizes in your school.

This is primary information because the school has collected the data themselves.

And then finally the last one in the table was the government issues a leaflet containing new health nutrition guidelines published by researchers in France.

This is secondary information because the data is coming from the researchers in France, not the government who is publishing the document.

Did you get all of those correct? Remember, you can make any corrections if you need to.

We are now moving on to the final part of today's lesson, and you've done a great job so far.

So well done.

We are now going to collect data for a purpose.

A school wants to find out what pupils do with their time outside of the school day.

What data would it be useful to collect? Pause the video here whilst you have a think.

Jun's got some brilliant ideas.

Jun is saying you may want to collect data about if pupils go to clubs, if pupils have any hobbies.

How long pupils spend watching TV or playing video games.

These are all great ideas.

Did you have any others? How could this data be collected? Maybe pause your video here and have a think.

Sam's got a great idea.

A questionnaire or survey could be sent for pupils to fill out.

Time to check your understanding.

Which of the following questions would be suitable for the school to include in the survey? And there may be more than one that are correct here.

So the options you have are A, what year group are you in? B, how much do you spend in the canteen each day? C, do you take part in any sports clubs outside of school? And D, how long do you watch TV for on average each day? Pause the video here whilst you have a think.

How did you get on? Great work.

A, C and D are all questions that would be suitable for the survey.

It may be useful to find out what year group a student is in so that you can do some comparisons between what students say in year seven do outside of school compared to what students in year 11 do.

It'd be interesting for you to know whether students take part in any sports clubs outside of school, and also how long they watch TV for on an average day.

When collecting data, it is important to make it as easy as possible to record responses.

This will encourage people to take part and will make sure that the data collected is recorded accurately.

So for example, you may do things like tally charts to record responses.

You may get people to tick boxes with a rating or a smiley face to see if they agree or disagree.

Or thumbs up thumbs down symbols.

Okay, it's now time for your final set of tasks for today's lesson.

I'd like you to create five to seven questions to find out about what pupils in your class do in their spare time.

Make the survey as easy to answer by providing answer options where suitable.

You can either create your questionnaires on paper and write them out, or you might want to create them digitally using an application.

It's totally up to you.

Pause the video here whilst you complete the activity.

How did you get on with your questions? Did you manage to provide some answer options? Great work so far.

Well done.

Here's a couple of sample questions that I've produced.

So the first one is, "Do you play sport for a club after school?" And I've provided the answer options of yes or no.

My second question is, "How many hours do you watch TV for on an average each day?" And I've provided a few categories here.

So I've got less than 30 minutes, 30 to 60 minutes or more than 60 minutes.

This should make these questions pretty quick and easy to respond to.

If you need to go back and make any improvements to your questions or add in some answer options, perhaps pause your video here.

Okay.

Now for the final part of task C.

I'd like you to use the questions you created in part one and I'd like you to collect the data from your class using your survey.

Make sure you keep the results somewhere safe so you can use them in a future lesson.

Pause the video here whilst you go and collect your responses.

How did you get on collecting your data? Was it easy to collect the responses from the rest of your class? You're doing a great job, so well done.

So here's the sample answer of what I've done.

I've gone out and asked the question about average time spent watching a TV a day, okay.

And I've put the data into a table so that that will be easy for me to look at later on.

So 12 people responded to say that they spent less than 30 minutes a day watching TV.

10 people said that they spent between 30 and 60 minutes and five people said that they spent more than 60 minutes.

If you haven't collected all your data, remember you can always pause the video here and go and finish that off.

We've come to the end of today's lesson and you've done a great job, so well done.

Let's summarise what we have learned.

Data is facts or figures without any meaning.

Information is data that has been given structure or meaning.

Primary data is data you collect yourself.

Secondary data is collected by someone else.

When collecting data for a purpose, it's important to consider the questions you'll use and how you'll save the responses carefully.

I hope you'll join me again soon.

Bye.