Class: Junior Secondary School 3 (JSS3, JSS 3)
Term: 1st Term
Week: 10
Age: 14 years
Duration: 45 minutes
Subject: Basic Science And Technology
Curriculum Theme: Computer Studies
Previous Lesson: Examples and Uses of Spreadsheet Packages
Topic: Spreadsheet Packages
Subject Matter: Spreadsheet features and terminologies: Row, Column, Cell, Worksheets, Charts, Data range etc. Loading and exiting spreadsheet packages.

Specific Objectives

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

Cognitive Domain:
(a) Identify and explain key spreadsheet terminologies such as row, column, cell, worksheet, and chart.
(b) Describe the process of loading and exiting a spreadsheet package.
Affective Domain:
(a) Demonstrate appreciation for the usefulness of spreadsheet applications in data management and calculations.
Psychomotor Domain:
(a) Operate a computer to load, create, and close a spreadsheet package correctly.
Social Domain:
(a) Work cooperatively in pairs or groups to practice basic spreadsheet operations.

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 systems with spreadsheet software installed (e.g., Microsoft Excel, Google Sheets, or LibreOffice Calc)
Projector or large screen for demonstration
Chart showing spreadsheet interface
Flash cards of spreadsheet terms and definitions
Whiteboard and markers

Rationale for the Lesson

This lesson introduces learners to key spreadsheet features and terms, helping them understand how to navigate, create, and exit spreadsheet packages used in data organization and computation.

Prerequisite/Previous Knowledge

Pupils are familiar with basic computer operations, such as opening and closing programs, typing, and saving files, from earlier lessons on computer applications.

Lesson Content/Board Summary

Spreadsheet Packages

A spreadsheet package is a software program used for organizing, analyzing, and storing data in tabular form. It helps users perform calculations, create charts, and manage information efficiently.

Spreadsheet Features and Terminologies

A spreadsheet is made up of several parts that work together to process data and display results.

The following are the major features and terminologies of a spreadsheet:

Row: A horizontal arrangement of cells identified by numbers (e.g., 1, 2, 3…).
Column: A vertical arrangement of cells identified by letters (e.g., A, B, C…).
Cell: The intersection of a row and a column (e.g., A1, B3). It is where data is entered.
Worksheet: A single page within a spreadsheet file where data is entered and calculated.
Workbook: A collection of one or more worksheets stored together in a single file.
Data Range: A group of selected cells containing related data for analysis.
Charts: Visual representation of data such as bar charts, pie charts, and line graphs.
Formula Bar: A space where formulas and functions are displayed and edited.
Cell Address: The unique name of a cell formed by its column letter and row number.
Menu/Toolbar: Contains icons and commands for performing operations in the spreadsheet.

Loading a Spreadsheet Package

Loading or opening a spreadsheet package means starting the program to begin work.

The following are steps to load a spreadsheet package:

Click on the Start Menu or press the Windows key.
Select All Programs or Applications.
Locate and click on the spreadsheet software (e.g., Microsoft Excel).
Wait for the program window to open, showing a blank worksheet ready for use.

Exiting a Spreadsheet Package

After working on a spreadsheet, it is important to save your work and exit properly to prevent data loss.

The following are steps to exit a spreadsheet package:

Click on the File Menu or the Office Button.
Select Exit or Close from the dropdown menu.
If prompted to save changes, click Yes to save before closing.
The spreadsheet package closes and returns to the desktop screen.

Teaching Methods/Instructional Techniques:

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

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 what applications they know for typing or organizing information, leading them to identify spreadsheet packages.
Pupils’ Activity: Pupils respond with examples such as Excel and Google Sheets.
Learning Point: Pupils recall earlier computer knowledge and become motivated for the new topic.

Step 2: Features and Terminologies of a Spreadsheet

Time: 10 minutes
Teaching Skill: Explanation
Teacher’s Activity: The teacher explains spreadsheet terms like row, column, and cell using charts and live demonstration on the computer.
Pupils’ Activity: Pupils listen, observe, and ask questions.
Learning Point: Pupils identify and understand major spreadsheet features and terms.

Step 3: Loading a Spreadsheet Package

Time: 10 minutes
Teaching Skill: Demonstration
Teacher’s Activity: The teacher demonstrates how to open Microsoft Excel and identify its components.
Pupils’ Activity: Pupils follow along on their computers.
Learning Point: Pupils learn how to load and start working on a spreadsheet.

Step 4: Exiting a Spreadsheet Package

Time: 10 minutes
Teaching Skill: Explanation and Practical
Teacher’s Activity: The teacher shows how to close and save work in a spreadsheet package properly.
Pupils’ Activity: Pupils practice closing their spreadsheet applications.
Learning Point: Pupils understand and apply the correct procedure to exit a spreadsheet safely.

Step 5: Note-Taking

Time: 5 minutes
Teaching Skill: Reinforcement
Teacher’s Activity: The teacher writes or dictates the board summary for pupils to copy.
Pupils’ Activity: Pupils copy the lesson notes neatly.
Learning Point: Pupils have a clear written summary of spreadsheet features and operations.

Step 6: Evaluation/Review

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

Define a spreadsheet package.
List three features or terminologies of a spreadsheet.
State two steps for loading a spreadsheet package.
Mention two ways to exit a spreadsheet package.
Pupils’ Activity: Pupils respond orally.
Learning Point: Pupils demonstrate understanding of spreadsheet basics.

Step 7: Conclusion

Time: 2 minutes
Teaching Skill: Summary and Feedback
Teacher’s Activity: The teacher summarizes the lesson and encourages pupils to practice using spreadsheet software regularly.
Pupils’ Activity: Pupils listen and reflect on what they learned.
Learning Point: Pupils appreciate the importance of spreadsheets in organizing and calculating data.

Lesson Keywords

Spreadsheet – a program for organizing and calculating data in rows and columns
Cell – the smallest box in a spreadsheet where data is entered
Worksheet – a single page within a spreadsheet file
Workbook – a collection of worksheets in one file
Chart – a visual display of data in a graphical form

Differentiation

Teacher provides step-by-step guidance for slower learners and allows faster learners to assist peers during practical demonstrations.

Note for teachers using this lesson plan

Ensure every pupil operates a computer where possible. Emphasize saving work before exiting. Use visual aids to simplify explanation of spreadsheet terms.