Computer Studies - Junior Secondary 3 - Spreadsheet packages

Spreadsheet packages

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. Spreadsheet packages

Term: 2nd Term

Week: 4

Class: Junior Secondary School 3

Age: 14 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Computer studies

Topic:-       Spreadsheet packages

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

  1. Define spreadsheet packages
  2. Give examples of spreadsheet package
  3. State the uses of spreadsheet

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 database

Students pay attention

STEP 2

EXPLANATION

She defines spreadsheet packages and gives examples

Students pay attention and participates

STEP 3

DEMONSTRATION

She mentions and explains the uses of spreadsheet packages

 

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

SPREADSHEET PACKAGES

A Spreadsheet Package is a program that enables the computer user to carry out calculation-related tasks. Spreadsheets are majorly used for organizing and analyzing numeric data. They were designed to replace the pencil, calculator and the writing pad. It is widely used in diverse range of disciplines like Engineering, Mathematics, Science, Accounting, etc.

EXAMPLES OF SPREADSHEET PACKAGE

  1. Lotus 1-2-3
  2. Microsoft Excel
  3. STATVIEW
  4. Quattro pro
  5. GS-Calc
  6. Easy Calc
  7. Super-Calc
  8. Visi-cal
  9. Apple numbers
  10. Freeware spreadsheet program

 NOTE: For the purpose of this lesson, our focus shall be on Microsoft Excel because it is user-friendly, flexible and contains more advanced features.

 

USES OF SPREADSHEET PACKAGES

  1. For Statistical analysis
  2. For Mathematical purposes
  3. Regression analysis
  4. Budget management and control
  5. Preparation of daily sales report
  6. Stock/Inventory control analysis
  7. Preparation of examination results
  8. Accounting purpose
  9. Financial projection and analysis
  10. Preparation of Payroll, etc

EVALUATION:    1. Define Spreadsheet packages

  1. Give four examples of spreadsheet packages
  2. State five uses of spreadsheet packages

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively