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 Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

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?