Computer Studies - Junior Secondary 3 - Calculations in Excel

Calculations in Excel

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Comprehensive Lesson Plan and Notes
  3. Junior Secondary 3
  4. Calculations in Excel

Term: 2nd Term

Week: 8

Class: Junior Secondary School 3

Age: 14 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Computer studies

Topic:-       Calculations in Excel

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

  1. Define formula in excel
  2. Highlight the general guidelines to be considered when carrying out calculations in excel
  3. Carry out Addition and subtraction using excel

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, textbook, pictures

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION

TEACHER’S ACTIVITY

STUDENT’S ACTIVITY

STEP 1

INTRODUCTION

The teacher revises the previous lesson on spreadsheet

Students pay attention

STEP 2

EXPLANATION

She defines formula and highlight the general guidelines in carrying out calculations in excel

Students pay attention and participates

STEP 3

DEMONSTRATION

She demonstrates the addition and subtraction in excel giving the guidelines for both

 

Students pay attention and participate

STEP 4

NOTE TAKING

The teacher writes a summarized note on the board

The students copy the note in their books

 

NOTE

CALCULATIONS IN EXCEL

The basic and most powerful feature of Microsoft Excel is the ability to accept formula into the worksheet.

A Formula is an instruction that is entered to tell Excel how to Add, Subtract, Multiply, Divide, or otherwise perform calculation by using the content of other cells.

It is advisable to construct formula that makes reference to cells in the worksheet so that the result can be instantly generated even the values are changed.

 

GUIDELINES TO BE CONSIDERED WHEN CARRYING OUT CALCULATIONS IN EXCEL

  1. To enter a formula, first select the cell that will contain the formula.
  2. All formula must begin with equal (=) sign tells Excel to treat the cells contents as a formula.
  3. The formula should not be more than 1024 characters.
  4. The function name (e.g. SUM, AVERAGE) which is preceded by equal (=) sign must be selected and followed by the desired argument, i.e. =SUM (A5:F5). In this case, SUM is the function name and A5:F5 is the argument.

Addition: Using the SUM Function

The SUM function is used to add together a range of data or numbers. To sum up the values of a range of data:

  1. Open the worksheet containing data 
  2. Position the cell pointer on the desired cell i.e. the cell where the result should be displayed.
  3. Type equal sign, Select the function (i.e. SUM) and state the range of cells.
  4. MS Excel will highlight the range specified.
  5. Press the Enter key.

The result is displayed.

 

NOTE: The teacher should ensure that each student follow the steps above and should also endeavour to explain alternative methods using the ‘AUTOSUM’ symbol (S), and Addition sign (+).

 

Subtraction: Using the IMSUB Function

The IMSUB function is used to find the difference of two numbers. To find the difference of a range of data;

  1. Open the worksheet containing data 
  2. Position the cell pointer on the desired cell i.e. the cell where the result should be displayed.
  3. Type equal sign, Select the function (i.e. IMSUB) and state the range of cells, usually two cells.
  4. MS Excel will highlight the range specified.
  5. Press the Enter key.

The result is displayed.

NOTE: The teacher should explain alternative methods using the Subtraction sign (-)

EVALUATION:    1. Define formula

  1. Highlight three general guidelines to consider in carrying out calculations in excel

CLASS ACTIVITY

Using the guidelines taught, carry out addition and subtraction on a pre-existing excel worksheet

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively