Class: Junior Secondary School 3 (JSS3, JSS 3)
Term: 2nd Term
Week: 3
Age: 14 years
Duration: 45 minutes
Subject: Basic Science And Technology
Curriculum Theme: Computer Studies
Previous Lesson: Graphics
Topic: The Worksheets (Part 1)
Subject Matter: Starting worksheet, Data entry, Editing, Saving, Retrieving worksheets, Formatting worksheets (text, cell and column, naming etc)

Specific Objectives

By the end of the lesson, pupils should be able to:

Cognitive Domain:
(a) Explain the meaning of a worksheet.
(b) Describe the processes involved in starting, saving and retrieving a worksheet.
Affective Domain:
(a) Show interest in working with worksheets.
(b) Appreciate the importance of proper formatting and saving of worksheets.
Psychomotor Domain:
(a) Start a worksheet and enter data correctly into cells.
(b) Edit, save and retrieve a worksheet file successfully.
Social Domain:
(a) Cooperate with classmates during worksheet activities.
(b) Share computer resources responsibly.

Reference Materials

The following resources was used in planning this lesson:

9 Years Basic Education Curriculum
Lagos State Unified Scheme of Work for Junior Secondary Schools
Wikipedia – Worksheet
Relevant Computer Studies Textbooks

Instructional Materials

The teacher will teach this lesson with the aid of:

Desktop or laptop computer
Spreadsheet application (e.g. Microsoft Excel)
Projector or monitor
Sample worksheet printouts
Whiteboard and marker

Rationale for the Lesson

Worksheets are essential tools for organizing and processing data. Learning these skills prepares students for academic tasks and future digital work environments.

Prerequisite/Previous Knowledge

Pupils have basic knowledge of computer parts and can open and close simple application software.

Lesson Content/Board Summary

The Worksheets

Meaning of Worksheet

A worksheet is a page in a spreadsheet program that is made up of rows and columns. It is used for entering, organizing, editing and analyzing data. Each small box where data is entered is called a cell.

The following are characteristics of a worksheet:

It is arranged in rows and columns.
It contains cells for data entry.
Many worksheets can exist in one workbook.

Starting a Worksheet

Starting a worksheet means opening a new or existing worksheet in a spreadsheet program in order to work on it.

The following are steps to start a new worksheet:

Switch on the computer.
Open the spreadsheet application.
Select a blank worksheet.

Data Entry in a Worksheet

Data entry refers to the process of typing information into the cells of a worksheet. Data can be text, numbers or symbols.

Examples include:

Names of students.
Scores or marks.
Dates and simple calculations.

Editing a Worksheet

Editing is the process of correcting, changing or updating data already entered in a worksheet.

The following are editing actions:

Correcting wrong entries.
Deleting unwanted data.
Modifying existing cell content.

Saving and Retrieving Worksheets

Saving a worksheet means storing it permanently on a computer or storage device, while retrieving means opening a previously saved worksheet.

The following are steps involved:

Choose a file name and storage location.
Save the worksheet.
Open the file later for continued use.

Formatting Worksheets

Formatting is the process of improving the appearance of data in a worksheet to make it clear and attractive.

These include:

Formatting text such as font size and style.
Adjusting column width and row height.
Applying borders and alignment to cells.
Naming worksheets appropriately.

Teaching Methods/Instructional Techniques:

Discussion, Explanation, Demonstration, Practical activity, Question and answer

Instructional Procedures

To deliver this lesson, the teacher will adopt the following steps:

Step 1: Introduction

Time: 5 minutes
Teaching Skill: Set Induction
Teacher’s Activity: The teacher asks pupils questions about tables and lists they have seen before and introduces the idea of electronic worksheets.
Pupils’ Activity: Pupils respond to questions and share experiences.
Learning Point: Worksheets are electronic tables used for organizing data.

Step 2: Meaning of Worksheet

Time: 8 minutes
Teaching Skill: Explanation
Teacher’s Activity: The teacher explains the meaning and features of a worksheet.
Pupils’ Activity: Pupils listen and ask questions.
Learning Point: A worksheet consists of rows, columns and cells.

Step 3: Starting and Data Entry in a Worksheet

Time: 10 minutes
Teaching Skill: Demonstration
Teacher’s Activity: The teacher demonstrates how to start a worksheet and enter data.
Pupils’ Activity: Pupils observe and practice.
Learning Point: Data can be entered into worksheet cells.

Step 4: Editing, Saving and Retrieving Worksheets

Time: 10 minutes
Teaching Skill: Practical demonstration
Teacher’s Activity: The teacher shows how to edit, save and retrieve a worksheet.
Pupils’ Activity: Pupils practice the steps.
Learning Point: Worksheets must be saved properly for future use.

Step 5: Note-Taking

Time: 5 minutes
Teaching Skill: Guided note writing
Teacher’s Activity: The teacher guides pupils to copy the board summary.
Pupils’ Activity: Pupils copy notes.
Learning Point: Key concepts are recorded for reference.

Step 6: Evaluation/Review

Time: 5 minutes
Teaching Skill: Questioning
Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

What is a worksheet?
Mention two steps in starting a worksheet.
State two examples of data entered in a worksheet.
Explain saving and retrieving a worksheet.
Pupils’ Activity: Pupils answer questions orally.
Learning Point: Understanding of worksheet concepts is assessed.

Step 7: Conclusion

Time: 2 minutes
Teaching Skill: Summary
Teacher’s Activity: The teacher summarizes the lesson and gives an assignment.
Pupils’ Activity: Pupils listen attentively.
Learning Point: Worksheets are useful tools for data management.

Lesson Keywords

Worksheet – a page used for entering data
Cell – a box formed by a row and column
Data entry – inputting information into cells
Editing – correcting or changing data
Formatting – improving the appearance of data

Differentiation

Fast learners assist peers during practical activities, while the teacher gives extra guidance to pupils who need support.

Note for teachers using this lesson plan

Ensure pupils have enough hands-on practice and emphasize proper saving and naming of worksheet files.