Lesson video

Hi everybody.

My name is Halima.

I am your computing teacher, and I will be teaching you about spreadsheets.

I hope you enjoy learning about spreadsheets as much as I enjoy teaching this as this is my favourite module.

In order to begin, you first of all, need to get permission from your parent, carer or teacher, if you are 13 years of age or below.

So please make sure you do this as you will need to create a Gmail account.

We are going to be using Google Sheets.

And that is what's going to act as our spreadsheet.

So please make sure you have this prior to starting anything.

You will also require a pen, paper to make notes with and possibly a calculator, if you want to double check anything.

So let's get started.

Lesson 3, spreadsheets.

In this lesson, you will explain the difference between data and information.

You will explain the difference between a primary and a secondary source, and you are also going to be collecting some data.

So, just to recap from lesson two, what is a formula? A formula starts with an equal sign, and it's needed in order to do a calculation.

So you will notice I'm providing you with some examples.

You've got an example here of C20 star, meaning times E20.

And then you also have an example of a division, which is D12 or equals D12, divide by F17.

What is data? Data is facts and figures.

Examples of data are all around us.

If you read newspapers, watch the news, listen to the radio, have magazines, you will notice there are lots of facts and figures around there, including when you're on the internet and you find news on the internet.

Here are some examples of facts and figures.

Only 12 out of 20 pupils achieved a level 9 this year.

That is a fact because the data will show this for the teacher in her class.

There are 10 girls in class 7B.

Again, that would be a fact because the teacher is able to see this in her class.

We had 60% of rainfall today at three o'clock.

And this is a figure.

There is a percentage here, which tells you what the rainfall is.

Charts are a very good way of showing facts and figures.

So what is the difference between data and information? So when you organise data so that it could be something meaningful, it then becomes information.

So a lot of the facts and figures that I've given you has turned into information.

You probably saw the data for this in a chart somewhere and I have written it in a way that is understandable, making it into information.

Examples of this can include receipts.

So when you purchase items, you will have the price of an item, which is a fact.

But once it's placed into a receipt, it's information because how much a certain item was.

Report cards, merit lists, payslips.

These are all examples of information that uses data.

Let me share with you an example of how to collect data.

Here, you can see a spreadsheet using Google Sheets, where I have created a survey to collect data.

A survey is a good way of collecting data.

And later on, I will be talking about the two different ways that data can be collected or data can be represented.

One is primary and the second is secondary.

And I will talk about these a bit later on.

Here you will notice in my survey, I have a list of questions.

Then, I have person 1, person 2 and person 3 answer.

Now, you're probably wondering why am I using a spreadsheet to do this? I can very easily create a survey in a word document.

Well, the reason being is that I want to later on analyse this data.

And in order to do that, I need my figures and facts and information that I can create a chart from, or I can colour coordinate, or do something else with in order to help me analyse that data.

And this is why I am using a spreadsheet and not a word processor.

So let's have a closer look.

Question number one, your first name? And you can put your first name in here.

My first name is Halima.

My age can go into the age box for person 1.

My favourite colour can be written or typed into person 1 answer.

How many siblings do I have? This can also go into person 1 answer.

If I go and ask another person the same questions, I then need to fill in person 2.

And I would do the same with person 3.

Do make sure, obviously, you have permission in order to use the data before you collect it.

It is important to do this.

And this is how you would simply collect data and have it in a survey.

You can now pause the video in order to complete task 1 in your worksheet.

Now that you have completed your task, here's an example of my completed survey.

As you can see, I have three people here who I have collected data from, and I have filled in their answers in the cell boxes.

I hope you have something similar too, and well done if you do.

Primary source or sources, there are two different types.

And I'm not talking about those sources that you use in your food.

These two sources relate to collecting data and how they are done.

Here, you see an example of a quiz.

A quiz can be created to collect primary sources or primary data.

Anytime you collect data firsthand, so that could be through an interview, a survey or a questionnaire, this is known as a primary source because you have collected the data.

Secondary source.

Here, you will see a picture on my slide, which I have taken from the internet.

This is known as a secondary source.

And notice under it, it tells you where this picture is from.

This is very important for copyright issues, but that's a different module.

Secondary source can be images and logo, quotes from a book, description of an object from the internet, anything that somebody else has created and you take, whether that's quotes from a book, whether that's images from a magazine.

So, not necessarily from the internet.

Anything like this is a secondary source.

Why not share the good work that you've been doing with Oak National? You can find us on Facebook and Twitter and Instagram.

Just make sure you get permission before you post anything.

We really look forward to seeing your work.

Thank you.

Bye-bye.

And see you again soon.