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

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 worksheet
  2. Explain the types of data that can be entered into an excel worksheet
  3. Create and edit worksheets

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 worksheet and explains the types of data can be entered into an excel worksheet

Students pay attention and participates

STEP 3

DEMONSTRATION

She demonstrates the creating and editing of a worksheet

 

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 worksheet can be defined as the working area of the program where entering of data and calculations are handled. It consists of rows, columns, cells and a cell pointer.

 

DATA ENTRY

There are three types of data that can be entered into an excel worksheet. These are Labels, Numbers and Formula.

  1. Labels are made up of texts that are entered into the active worksheet. Examples are letters of alphabets (A-Z)
  2. Numbers/values consists of numerals 0 – 9
  3. Formulas are mathematical expressions which return calculated value.

 

CREATING AND EDITING A WORKSHEET

CREATING A WORKSHEET

Method I:

To create a new worksheet, follow the steps below:

  1. Open Microsoft Excel from the Start button
  2. Click on Office button to display a sub menu
  3. Select New
  4. Click on Create
  5. A new workbook will be displayed.

 

Method II:

  1. Open Microsoft Excel
  2. Press Ctrl + N

 

EDITING THE WORKSHEET

Editing a worksheet means to either insert data, delete existing ones or to make corrections to the already existing data.

EVALUATION:    1. Define worksheet

  1. Mention and explain the three types of data that can be entered into an excel worksheet

CLASS ACTIVITY

Create and edit a worksheet

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively