Class: Junior Secondary School 3 (JSS3, JSS 3)
Term: 1st Term
Week: 9
Age: 14 years
Duration: 45 minutes
Subject: Basic Science And Technology
Curriculum Theme: Computer Studies
Previous Lesson:
Topic: Spreadsheet
Subject Matter: Examples of spreadsheet packages: Excel, Lotus 123, STATVIEW etc. Uses of spreadsheet packages: Preparation of daily sales, Budget, Examination results.

Specific Objectives

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

Cognitive Domain:
(a) Identify common examples of spreadsheet packages.
(b) Explain the uses of spreadsheet packages in everyday life.
Affective Domain:
(a) Appreciate the importance of spreadsheets in simplifying calculations and data management.
Psychomotor Domain:
(a) Demonstrate how to open and use a simple spreadsheet package.
Social Domain:
(a) Work cooperatively in groups to discuss practical uses of spreadsheets in school and business.

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 – Spreadsheet
Relevant Textbooks

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer system with spreadsheet software installed (Microsoft Excel)
Projector or monitor screen for demonstration
Chart showing spreadsheet window and components
Printed sample spreadsheet for exercises
Whiteboard and marker

Rationale for the Lesson

This lesson enables students to recognize different spreadsheet packages and understand their uses in daily record-keeping, budgeting, and computation.

Prerequisite/Previous Knowledge

Students have already learned the meaning and basic features of spreadsheet applications in previous lessons and can identify spreadsheet rows, columns, and cells.

Lesson Content/Board Summary

Spreadsheet

Examples of Spreadsheet Packages

Spreadsheet packages are software programs designed to organize, calculate, and analyze numerical data using rows and columns. Over time, several spreadsheet programs have been developed for personal and business use.

Examples include:

Microsoft Excel – The most popular and widely used spreadsheet application developed by Microsoft.
Lotus 1-2-3 – One of the earliest spreadsheet software used for data analysis and accounting before Excel became dominant.
Quattro Pro – A spreadsheet program developed by Corel Corporation used for similar purposes as Excel.
Apple Numbers – Spreadsheet software designed by Apple for macOS and iOS devices.
Google Sheets – A cloud-based spreadsheet application that allows users to create and share spreadsheets online.
STATVIEW – A statistical spreadsheet software used for research and data analysis.

Uses of Spreadsheet Packages

Spreadsheet packages are powerful tools that make calculations, data organization, and record-keeping easier and faster. They are used in schools, offices, and businesses for different purposes.

The following are the uses of spreadsheet packages:

Preparation of Daily Sales Record: Used by business owners to record daily transactions and calculate profit or loss.
Budget Preparation: Helps individuals and organizations to plan and monitor their expenses and income.
Examination Results: Used in schools to record and compute students’ scores automatically.
Payroll Preparation: Assists in calculating salaries, taxes, and deductions for workers.
Statistical Analysis: Used by researchers and data analysts to summarize and interpret large data sets.
Inventory Management: Helps companies to track stock levels, purchases, and sales.
Accounting Reports: Used to prepare financial reports and summaries.
Project Planning: Used to plan and monitor progress of projects effectively.

Teaching Methods/Instructional Techniques:

Lecture, Discussion, Explanation, Demonstration, Question and Answer, Group Work, Practical Display

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: Teacher asks pupils to recall the meaning and features of a spreadsheet package and shows a computer with Microsoft Excel open.
Pupils’ Activity: Pupils respond and identify familiar spreadsheet tools.
Learning Point: Pupils connect the new lesson with their prior knowledge of spreadsheets.

Step 2: Examples of Spreadsheet Packages

Time: 10 minutes
Teaching Skill: Explanation
Teacher’s Activity: Teacher lists and explains examples of spreadsheet packages using visual charts and displays icons of Excel, Google Sheets, and others.
Pupils’ Activity: Pupils observe, listen, and mention any spreadsheet programs they have seen or used.
Learning Point: Pupils recognize and can name various spreadsheet software packages.

Step 3: Uses of Spreadsheet Packages

Time: 10 minutes
Teaching Skill: Discussion
Teacher’s Activity: Teacher discusses how spreadsheet packages are applied in real-life situations such as budgeting and examination records.
Pupils’ Activity: Pupils share examples of how spreadsheets can be used at home or in school.
Learning Point: Pupils understand practical applications of spreadsheets in daily activities.

Step 4: Practical Demonstration

Time: 10 minutes
Teaching Skill: Demonstration
Teacher’s Activity: Teacher demonstrates how to enter data and perform simple calculations in Excel.
Pupils’ Activity: Pupils follow along, practice entering data, and observe how formulas work.
Learning Point: Pupils gain hands-on experience with basic spreadsheet operations.

Step 5: Note-Taking

Time: 5 minutes
Teaching Skill: Explanation
Teacher’s Activity: Teacher dictates or displays the summarized notes for pupils to copy into their books.
Pupils’ Activity: Pupils write down notes neatly.
Learning Point: Pupils have a written summary of the lesson content.

Step 6: Evaluation/Review

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

Mention three examples of spreadsheet packages.
State four uses of spreadsheet packages.
Which spreadsheet program is most commonly used today?
Pupils’ Activity: Pupils answer the questions orally.
Learning Point: Pupils recall and demonstrate understanding of the lesson objectives.

Step 7: Conclusion

Time: 2 minutes
Teaching Skill: Reinforcement
Teacher’s Activity: Teacher summarizes key points and encourages pupils to practice using spreadsheet software.
Pupils’ Activity: Pupils listen and ask clarifying questions.
Learning Point: Pupils understand the importance of learning spreadsheets for future use.

Lesson Keywords

Spreadsheet – a computer program that organizes data in rows and columns.
Package – a software program designed for a specific purpose.
Budget – a financial plan showing income and expenditure.
Formula – a command used to calculate values automatically.
Data – information entered into the computer for processing.

Differentiation

Teacher provides guided assistance and extra explanation for slower learners while encouraging advanced learners to demonstrate spreadsheet use on the computer.

Note for teachers using this lesson plan

Ensure that pupils get hands-on experience using the computer system. Demonstrate real-life spreadsheet applications to sustain interest and reinforce understanding.