Spreadsheets II : Using Formula

Lesson Objective : Using a formula to add the value of 2 cells

All formula begins with a equals sign.

Operators in spreadsheets (+, -, *, /)

Learning Outcome : Download and open the spreadsheet file, The Gold Mine.

The Big Picture

What have we done? We learned about cells and cell references

What are we doing? We are going to use formula to add the value of 2 cells

What are we going? We will use spreadsheets to make lots of calculations

A spreadsheet program is made up of a large table, called a sheet.

Each cell has a cell reference. The cell reference is the column letter followed by the row number. The cell reference for the green cell below is B3.

Spreadsheet Operators : Multiplication and division is different from conventional Maths operators.

Addition (Plus): +

Subtraction (Minus):

Multiplication (Times): *

Division (Divide By): /

How to find MS Excel on your computer. Select the windows button on the bottom left of the screen and search for Excel. Select the correct version.

This week’s task

Note : You may need to select Enable Editing

Instructions

Work out the answers to various calculations and if they are right, the cells will automatically turn gold.

You can enter formulae into cells to help work out the answers.

All formulae must begin with an = (equals) sign

See example in D7;

=B7+C7 will add the numbers of the 2 cells together

If you finish, you can go to level 2

Success Criteria

Success : I can complete a level of the Gold Mine, adding and subtraction

Super Success : I can also do multiplication and division

Extra Success : I can complete the move ahead to next week’s task, Recap Challenge

Extra Task: Recap Challenge

Note : You may need to select Enable Editing

Instructions

Work out the answers to various calculations and if they are right, the cell will automatically turn green.

You can enter formulae into cells to help work out the answers.

All formulae must begin with an = (equals) sign

See example in E3;

=B3+D3 will add the numbers of the 2 cells together

If you finish early, go to level 2

Socrative Plenary

If you are attending the live sessions, you will be asked to tell me how you did.

https://b.socrative.com/login/student/

Room Name : XFUTURE

One thought on “Spreadsheets II : Using Formula

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: