Lesson Notes By Weeks and Term - Senior Secondary 1

Spreadsheet III

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term
  3. Senior Secondary 1
  4. Spreadsheet III

Term: 3rd Term

Week: 6

Class: Senior Secondary School 1

Age: 15 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Spreadsheet III

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

  1. Load and exit the Microsoft excel program
  2. Create a new worksheet
  3. Identify the types of data

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

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION

TEACHER’S ACTIVITY

STUDENT’S ACTIVITY

STEP 1

INTRODUCTION

The teacher reviews the previous lesson on Spreadsheet

Students pay attention

STEP 2

EXPLANATION

He shows the learners how to load and exit the Microsoft excel program

 

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He shows the learners how to create a new worksheet. He also discusses the types of data in excel

 

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

LOADING AND EXITING SPREADSHEET

To load a spreadsheet package, take the following steps: 

Click on the START button

Point to ALL PROGRAM

Point to Microsoft Office

Click on Microsoft Excel

 

EXITING THE SPREADSHEET PACKAGE  

Click on the File menu and select Exit.

Click on the Close button on the Title bar

Press ALT + F4.

 

OPENING A WORKSHEET

To create a new worksheet, follow the steps below:

Open Microsoft Excel from the Start button

Click on Office button to display a sub menu

Select New

Click on Create

A new workbook will be displayed.

 

TYPES OF DATA (in Microsoft Excel)

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.

CLASS ACTIVITY:       1. Load and exit Microsoft Excel.

  1. Create a new worksheet in Microsoft Excel

EVALUATION:    1. List and explain the types of data that can be entered in Microsoft Excel

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively