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 one of spreadsheets.

In this lesson, you are going to identify columns, rows, cells and cell references.

You're going to use formatting techniques in your spreadsheet today.

I hope you enjoy this unit.

So, athletics competition medal.

You will notice on the right hand side, I have got a table for you, which has got different countries in it.

You will notice that they have got gold, silver and bronze medals.

I'm going to be asking you a series of questions.

Please make sure you have a pen and paper ready, as you may need this in order to write your answers down.

Feel free at any point to pause the video if you feel that you need more time.

Question number one.

Examine the data and try to answer the following questions.

So here we go.

How many medals did great britain win? Do you know yet? Yes, it was 67.

Well done if you got that correct.

How did you do that? Did you use a paper and a pad and a pen? You will have noticed the way to do this is to add the numbers together.

So you have to add gold, silver and bronze together to give you 67.

And you probably have to read across the row as well from where Great Britain is, in order to find that answer.

So it was a little bit like a coordinate, because you had to check with the medals were, and you had to check where the country is, and add those numbers together.

Question number two.

Who won the most gold medals? Are we there yet? Yes, it was USA.

Well done.

USA won the most gold medals.

So well done.

Last question.

Apart from USA, who won the most medals? Let me give you a bit more time.

Feel free to pause the video at any point.

Well done.

If you said it was China, it was.

Now, to do that you probably had to add up all the medals in China, in USA, in Germany, in Great Britain, and all the other countries that are listed.

It probably takes a bit of time.

Is there anything else we can use? Let's have a think.

Okay, so you could have actually quite easily have done the same questions in a spreadsheet.

Let's have a look at what makes up a spreadsheet.

So again, you can see that there is a table.

Okay, on the right hand side, and you will notice that there are countries there.

You will notice on this occasion, there are letters at the top and numbers on the left.

So before we can get started with spreadsheets, we need to know what the different parts of a spreadsheet are, and how a spreadsheet is made up.

We have got something called cells, rows and columns.

Let's have a closer look.

So, this is a spreadsheet.

You can get many different brands of spreadsheets.

The one I'm using here is Google Sheet.

And this is the one I will expect you to use in this unit.

So let's have a closer look.

Okay.

So you will notice that I am clicking in various different locations.

These little boxes are actually called cells.

And cells are made up of columns, and rows.

At the moment, I am clicking in a cell called D3.

How do I know? Well, from a close examination, you will notice the D is the name of the column.

The three is the name of the row.

That is called a cell reference.

And I'll probably come back to that again later.

But a cell is any one of these boxes.

We then have columns, so I can highlight a column as I've done now.

This is column C.

We also have rows.

So, if I just click on a row there, you will notice that this is a row.

Do you know which number row it is? Let me give you some time to think.

That's correct.

It is row four.

Well done if you got that right.

Yes so, spreadsheets are made up of columns, and rows various different cells.

And throughout these lessons, I will be coming back to Google Sheets, and I'll be showing you some demonstrations in here.

And I'll be teaching you about the various different aspects of it.

So please be ready with Google Sheets.

So what is a cell reference? Let's have a look.

You will notice on the image, I have got a cell highlighted.

And I did kind of mention this in my demonstration earlier on.

You will notice I have selected a cell, which has the letter C, and the number four attached.

If you remember, the C is the column, or the letter is associated with the column.

The number here is number four.

And number four is associated with the row.

Therefore, the cell reference is C4.

I did also mention earlier on that cell referencing is a little bit like coordinates.

If you've read maps before, you have coordinates in a map, and this system works in a similar way.

So here I have C4.

Just remember the letter comes before the number and that is how we do a cell reference.

Maybe you can pause the video and have a look yourself at a spreadsheet.

So, the next part of our lesson is about formatting a spreadsheet.

Formatting means changing.

So we are going to be changing parts of our spreadsheet.

Later on, you're going to move on to a task.

And this will involve you formatting your spreadsheet.

So you will notice here, I've got a screenshot of a Format menu in Google Sheets.

This will be very handy when you come to format your spreadsheet.

So let's have a closer look at how to format in Google Sheets.

So here is Google Sheets again, or our spreadsheet.

So I'm going to show you now how to format this sheet and show you various different tools in here.

First of all, if you did want to make any changes or format your sheet, there is a toolbar at the top just here.

So you can make things bold.

You can make your text italic.

You can change the colour of your text by simply clicking on the A.

You can change the colour of a cell using the bucket and binding the colour that you would like to use.

You can also add borders.

Now, the good thing about borders is, it actually makes information or data look really nice and neat, if you can have a border around it.

If you're making images, you might decide to have a border around your image.

There are various different ways you can have borders.

You can have the full on border, which has got lines going through the middle as well as around.

You can have a border which has lines only in the inside but no outside line.

Lines that go horizontally only.

Lines that go vertically only.

And an outer border.

And there are various other menus below as well that you can play and find out yourself what they do.

The other places you can go to, if you did want to format your spreadsheet is on the toolbar called Format.

And in here, you can select the theme.

As well as all the other aspects that I've just shown you.

You can change the size of the font in your Format menu.

You can align things to be in the centre, middle, left or right.

Something that I also like to use is text wrapping.

It basically means that sometimes when you start writing in a cell or typing, and it goes over other cells.

And if you don't want that you want it to stay in the same place or the same cell, then you can do something called wrapping.

But we will come back to that a bit later.

You can rotate information.

And lots of other things including conditional formatting, which I'll teach you about later on.

So, let's get started and create something.

I'm going to start off by creating a flag.

I'm going to go for an England flag.

Do you know what the colours are for the England flag? It's red and white.

Well done, if you got that correct.

Okay, so let's start.

I'm going to start with column C.

Starting in row one, depending on how big you would like your flag.

I'm going to go all the way up to 12.

Now, something I'd like to teach you here.

What cell reference, would you say that is? I'm going to give you a bit of time to think.

Okay, so the cell reference here is C1 to C12.

It's because I've selected 12 cells here.

Notice I didn't say C1, C2, C3, C4, et cetera.

It takes too long to say that.

I actually said C1 to C12.

And the way we would write that is and I'm going to do it in here so you can have actually have a look C1.

The to symbol is actually two little dots.

I will come back to that a bit later.

But, the two little dots mean to.

So C1 to C12.

And this is how it would look.

So if you have a group of cells that you're putting together, we write it in this way.

And that is how we do our cell reference.

So let's go back to making our flag.

So I'm going from C1 to C12.

Notice I've highlighted it.

So I didn't let go of my mouse.

I'm now going to choose a colour.

I'm going to go for red.

And I would say, six is probably the middle part of this flag.

And I'm probably going to need two because the width on this is a bit bigger.

So, I probably need two cells here together.

So, if I can go two across, then two across there making sure it's even.

So I'm going two columns here two columns here.

Okay, to make sure it's even.

I have now selected A6 to E7.

What's going on here? I said it's A6 to E7, not A6 to E6.

Well, when you have a group of cells, which involve other columns and rows, the way we would write this is A6.

What is the to symbol? Well done.

It's the two little dots, like that.

And then I said, it was E7.

This is how I would write a group of cells together as a cell reference, if I had lots of columns and lots of rows.

I start with A6 is the very first cell that I've selected.

E7 is the very last cell that I have selected.

Let me get rid of this and do it again.

So, I'm going to select everything from A6 to E7.

So there's A6, and there is E7.

I'm going to use my buckets and I'm going to make it red.

Now that looks nice so far.

It does look almost like an England flag, but not there yet.

I need to colour these cells.

And make them white.

I can also make a border around this.

So, I only want an outside border.

So I can see that this is that part of my flag.

So there is my England flag.

Okay.

So, it's time for you to have a go now.

Pause the video and have a look at the worksheet, and have a go at making your own flags.

Okay, so I'm now going to use spreadsheet to show you how to make the German flag.

So this is something in your worksheet.

I'm going to select the cells A1 up until F5.

You'll notice I've probably looked on the right hand side.

It's because I've used pen and paper to plan this out first, so I know where everything's going to go.

The German flag starts with black.

So we make sure that that is coloured black.

I'm now going to select cells A6, and cell F10.

And I'm going to make it orange.

Oh, no, that's not correct.

It's fine.

We can always click on the undo button.

There we go.

What colour comes next? Yes, you're absolutely right.

It is red.

Okay.

Probably not as harsh as that.

So I'm going to select another red.

Let's have a look.

Is there a brighter red? I will stick with that red.

Okay, so black, red, then it's A11 up until A15.

And I'm going to go for yellow.

You can also click on the Customise tool and select colours that are not already here.

The yellow is, and there is my German flag.

Well done if you did that correct.

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.