INTRODUCTION TO SPREADSHEETS

INTRODUCTION TO SPREADSHEETS

S1/2 ICT

Microsoft Excel

Is a spreadsheet file used to carry out calculations. You can also create charts and graphs.

​There are 3 parts to a spreadsheet...

1. Cells

2. Rows

3. Columns​

S1 ICT

Cells are the individual boxes that make up a spreadsheet​...

Cells...​

​

Rows go across the way...

Rows...​

​

Columns go up and down...

Columns...​

​

Row and columns...​

​

Multiple Choice

Which colour is the column?

• Red

• Green

Cell References

When we use excel we use "cell references" this is another way of saying each cell has a name.

Cell References...​

​

​When we "name" a cell we use the letter from the column and the number from the row.

​

Here are 5 examples...​

Cell References

Now that you know what a cell reference is you have some questions to answer...​

Fill in the Blank

What is the name of the cell filled in blue?

Fill in the Blank

What is the name of the cell filled in pink?

Fill in the Blank

What is the name of the cell filled in green?

Fill in the Blank

Can you decode the message?

E10, A4, D4

Fill in the Blank

Can you decode the message?

B2, E6, F7, C1, C5

Task 1

We are going to start with a task to help you find your way around excel.

You ​will be using the fill tool to shade in a number of cells different colours...

​

Your task is to use excel to re-create the following country's flags...​

France

​Iceland

Scotland​

​Sweden

Germany​

Greece​

​

​Here are some examples...

Demonstration...

Your teacher will now lead you through a demonstration on their board...

​

Task 1 - Flags

We are going to start with a task to help you find your way around excel.

You ​will be using the fill tool to shade in a number of cells different colours...

​

Your task is to use excel to re-create the following country's flags...​

France

​Iceland

Scotland​

​Sweden

Germany​

Greece​

​

Task 2 - Pixel Art

For this task you are going to need to make a small change to your spreadsheet.​ Your teacher will talk you through this as a class.

​

Using your spreadsheet and the fill tool you have to create different pixel art, here are some examples...​

​

Open Ended

Did you enjoy using the Quizizz lesson today?

Open Ended

What 2 new things did you learn today in ICT?