Lesson 3

LEARNING OBJECTIVE

Success Criteria

To understand how to use formulas on Excel.

To be able to input information on to Excel.

 LEARNING OUTCOME

To successfully use formulas on Excel.

To be able to input information on to Excel.

SHOULD:

  • I can use formulas for the four number operations on Excel to calculate totals to sums.
  • I can enter information into an Excel spreadsheet.

COULD:

  • I can write different formulas for the same question.

In the last 2 lessons we have been principally concerned with creating graphs from numerical data. 

But this isn’t the only thing that a spreadsheet can do. 

Before we can learn any of the other uses that a spreadsheet can have we must ensure that we can all use find a cell correctly on a spreadsheet – now complete the warm-up activity.

Warm-up Task:  Cell Addresses?

Using this spreadsheet, what are the cell addresses for the following:

  1. All living things are made up of these
  2. This is the force that makes objects float in water
  3. This is a chemical in food that keeps us healthy
  4. This is what happens when a solid completely mixes in with a liquid and cannot be seen
  5. This is an organ which controls the body
  6. This is the organ which pumps blood around the body
  7. These act as an insulator to stop the heat from the oven reaching your hands
  8. Can anyone think up any good statements to define cells H8, D16 and A1.


Maths Operations
Begin by telling the children some of the other uses that spreadsheets can have. 

The children must be aware that spreadsheets can work with numbers through any of the four maths operations.
You can create addition formulas, subtraction formulas, division formulas and multiplication formulas.

Maths Symbols in Computers:

Multiply         *
Divide            /
Addition        +
Subtraction    -

First Method
  • Have a blank spreadsheet open and begin by typing in 3 different numbers into cells A2, A3 and A4. 
  • For example: A2 = 34 A3 = 35 and A4 = 67.

  • We want to add up all of these numbers in this column. 

  • Begin by going up to the formula bar and typing in an = sign. 
  • The equals sign tells the spreadsheet that it is a formula. 

  • You should end up have typed in =a2+a3+a4 and then press return.
A second method for addition: 
  • Click on the cell that you are wanting the total to be added into and then type in an = sign. 

  • You can click on the first cell which needs to be added, then press the + sign, then click on the next cell and so on.

  • Press enter to find the total.
A third method. 
  • Click on the cell where you want to calculate the total. Type in the = sign.

  • This time we are going to use the word SUM.

  • The word SUM tells us that it wants to add up the total of the numbers in the brackets.

    Then open the brackets and type in the formula =SUM(A2:A4) then press enter.

Other Mathematical Operations

Multiplication
Demonstrate in the same way how you can use multiplication and the sign we use for multiplication. 
  • We use the * sign which is normally found above the 8 on the keyboard.

  • The children can practise learning their multiplication tables! 

    • If you type in 1,2,3 down column A, 

      • you can show the children that you can then select all of these numbers and hold the mouse over the bottom right corner and a black cross will appear. 
      • Click and Drag down until as far as you want to go - say until 9. 

    • Put 7, 7, 7 in the next column. 
    • Highlight the first 3 sevens and drag down to same level as the 9. 

    • In the cell next to the 1 and 7 (Cell C1) type in the formula =A1*B1 and press enter.
       
    • You don’t need to type the formula for each question. 
    • Go to the answer and just drag down. 
    • This carries the formula down and changes slightly to the cells underneath.

Other Maths Operations:
    • Division
      • In Cell D1, put formula to Divide A1 by B1 (=A1/B1)
    • For completion:
      • in Cell E1, put formula to Add A1 to B1
      • In Cell F1, put formulate to subtract B1 from A1

    • Now repeat these formulas for each of the Rows of your multiplication table

71  Multiply
=A1*B1 		 Divide
=A1/B1		 Addition Subtraction
72    
73    
74    
 75    










I22, B12, F8, F16, D9, H2, H5, 

H8, D16, A1 - are states of matter





Comments