Class: Junior Secondary School 3 (JSS3, JSS 3)
Term: 2nd Term
Week: 4
Age: 14 years
Duration: 45 minutes
Subject: Basic Science And Technology
Curriculum Theme: Computer Studies
Previous Lesson: Worksheets, Data Entry and
Topic: The Worksheets (Part 2)
Subject Matter: Calculations, Addition, Average, Counting, Multiplication, Division etc.; Printing of worksheets.

Specific Objectives

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

Cognitive Domain:
(a) Define worksheet calculations and functions on a spreadsheet.
(b) Demonstrate how to perform addition, average, counting, multiplication and division using formulas on a worksheet.
Affective Domain:
(a) Show willingness to explore spreadsheet tools and functions.
(b) Appreciate the usefulness of worksheet calculations in solving real-life problems.
Psychomotor Domain:
(a) Use the keyboard and mouse to input data and formulae in a spreadsheet.
(b) Print a completed worksheet accurately.
Social Domain:
(a) Work collaboratively in pairs to enter data and perform calculations on a worksheet.
(b) Share findings and support peers during practical activities.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum
Lagos State Unified Scheme of work for Junior Secondary Schools (ClassRoomNotes)
Britannica – Worksheet Definition & Meaning | Britannica Dictionary
Relevant Textbooks

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer system with spreadsheet software (e.g., MS Excel)
Projector or interactive whiteboard
Printed sample worksheets
Worksheets handouts for learners
Printer for demonstration

Rationale for the Lesson

This lesson equips pupils with essential spreadsheet skills for performing numerical calculations, improving accuracy and efficiency in data handling tasks.

Prerequisite/Previous Knowledge

Pupils should be familiar with basic parts of a spreadsheet and how to open and save a worksheet from prior lessons.

Lesson Content/Board Summary

The Worksheets

Addition on Worksheets

Addition on a worksheet involves calculating the total of two or more numbers using a formula or function in a spreadsheet. This enables learners to get the sum of data entries without manual calculation.
They are:

Using the SUM function to add selected cells.
Entering an addition formula starting with the equal sign (=) followed by cell references. (Classhall)

Average on Worksheets

Average calculation finds the mean of a set of numbers on a worksheet. It simplifies understanding of central tendency in data.
The following are ways to calculate average in a worksheet:

Using the AVERAGE function with a range of cells.
Entering the formula =AVERAGE(cell range) in the formula bar. (oamschoolng.com)

Counting on Worksheets

Counting on a worksheet helps determine how many cells in a range contain values. This is important for summarising data entries.
The following are functions used for count:

Using the COUNT function with a specified range.
Using the COUNTA function to count all non-empty cells. (StopLearn)

Multiplication on Worksheets

Multiplication on a worksheet calculates the product of two or more numbers. This is useful for computing totals based on repeated quantities.
Examples includes:

Using the * symbol between cell references in a formula.
Applying the PRODUCT function for a range of values. (StopLearn)

Division on Worksheets

Division on a worksheet divides one number by another to get a quotient. It is used in distributing values across categories.
They are:

Entering a division formula using the / symbol between references.
Using functions like QUOTIENT for integer results if required. (StopLearn)

Printing of Worksheets

Printing a worksheet means producing a physical copy of the data and calculations. Proper printing ensures results can be reviewed offline.
The following are major steps in printing a worksheet:

Selecting the range to print.
Choosing Print from the office or file menu.
Setting print options (range, orientation, copies).
Clicking Print to generate the hard copy. (StopLearn)

Teaching Methods/Instructional Techniques:

Discussion, Lecture, Demonstration, Practical Exercise, Group Work

Instructional Procedures

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

Step 1: Introduction

Time: 5 mins
Teaching Skill: Set Induction
Teacher’s Activity: Greet class, review previous lesson on worksheets, relate with simple real-life calculations.
Pupils’ Activity: Respond to questions, recall prior knowledge.
Learning Point: Pupils are ready for new content.

Step 2: Concept of Addition

Time: 7 mins
Teaching Skill: Explanation
Teacher’s Activity: Explain how to use formulas for addition on spreadsheet.
Pupils’ Activity: Listen and observe demonstration.
Learning Point: Understanding of addition in worksheets.

Step 3: Average and Count Functions

Time: 7 mins
Teaching Skill: Demonstration
Teacher’s Activity: Show how to compute average and count using functions.
Pupils’ Activity: Observe and note steps on board.
Learning Point: Mastery of average and count functions.

Step 4: Multiplication and Division

Time: 7 mins
Teaching Skill: Practical Demonstration
Teacher’s Activity: Demonstrate multiplying and dividing using formulas.
Pupils’ Activity: Follow along on own computers.
Learning Point: Ability to perform multiplication and division.

Step 5: Printing Worksheets

Time: 7 mins
Teaching Skill: Demonstration
Teacher’s Activity: Guide learners through printing setup and execution.
Pupils’ Activity: Prepare worksheet for print preview.
Learning Point: Ready printing skills.

Step 6: Evaluation/Review

Time: 6 mins
Teaching Skill: Questioning
Teacher evaluates the learning by asking the following questions:

Define addition on a worksheet.
How do you calculate the average of values?
What formula symbol is used for division?
List steps to print a worksheet.
Perform a count of entries in a given range.
Pupils’ Activity: Answer questions and demonstrate tasks.
Learning Point: Assessment of comprehension.

Step 7: Conclusion

Time: 6 mins
Teaching Skill: Closure
Teacher’s Activity: Summarise key points, assign practical task.
Pupils’ Activity: Note assignments.
Learning Point: Recap of the lesson.

Lesson Keywords

Worksheet – digital grid for data entry
Formula – instruction for calculation
SUM – function to add numbers
AVERAGE – function to find mean
COUNT – function to count entries

Differentiation

Provide additional practice for slower learners; challenge advanced learners with extended dataset tasks.

Note for teachers using this lesson plan

Ensure computers are set up before class; encourage hands-on practice; circulate to support learners during practical exercises.