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: 9

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. Carry out Average, count, multiplication and division using excel
  2. Print worksheet

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 calculations in excel

Students pay attention

STEP 2

EXPLANATION

She demonstrates the average, count, multiplication and division in excel giving the guidelines

 

Students pay attention and participates

STEP 3

DEMONSTRATION

She demonstrates how to print worksheets

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

Average

It is also possible to use the spreadsheet package to find the average of certain values or group of numbers.

To find average:

  1. Position the cell pointer in the desired cell where result is to be displayed
  2. Type “=AVERAGE (DATA RANGE)”in the formula bar
  3. Press the ENTER KEY

The result is displayed in the cell

 

Count

The COUNT function is used to ascertain the number of cells within a specified range that contains values.

  1. To use the count function;
  2. Position the cell pointer in the desired cell
  3. Click on AutoSum (S) and select “Count”
  4. Press the ENTER KEY.

 

Multiplication

The multiplication function is solely for multiplication of numbers just like in arithmetic. To multiply a range of data;

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

The result is displayed.

Also, the symbol (*) can be used.

 

Division

To divide a range of values;

  1. Position the cell pointer on the desired cell i.e. the cell where the result should be displayed.
  2. Type equal sign, Select the function (i.e. QUOTIENT to display the integer portion of a division) and state the range of cells.
  3. MS Excel will highlight the range specified.
  4. Press the Enter key.

The result is displayed.

Also, the symbol (/) can be used to display the exact result.

 

NOTE: The teacher should please endeavour to expose the students to some other functions embedded in the worksheet program.

Printing of Worksheet

After the spreadsheet have been formatted and properly calculated the next thing is to get the worksheet printed. To print your worksheet, take the following steps:

  1. Highlight the range to be printed
  2. Click on the Office button and select Print
  3. Select the name of the printer from the Printer Name box
  4. Enter the number of copies to print
  5. Click on Preview button and select Page Set Up. Set all the necessary parameters like margins, page layout, paper size and grid lines (if necessary).
  6. Click on OK

 

CLASS ACTIVITY

Using the guidelines taught, carry out average, count, multiplication and division on a pre-existing excel worksheet

Print the worksheet worked on

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively