# Lesson Notes By Weeks and Term - Senior Secondary 1

Term: 3rd Term

Week: 6

Class: Senior Secondary School 1

Age: 15 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Data Processing

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

Click on the START button

Point to ALL PROGRAM

Point to Microsoft Office

Click on Microsoft Excel

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