Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 1
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Safety Measures in the Computer Room.
Topic: Inserting formulas and using functions (Writing simple formula, Writing complex formula)
Subject Matter: Writing simple formulas for addition, subtraction, multiplication, division; using AutoSum, AVERAGE, PRODUCT, QUOTIENT functions; totaling rows and columns.

Specific Objectives

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

Cognitive Domain:

Define a formula in a spreadsheet.
Identify the basic arithmetic operators used in formulas.
Explain the purpose of common functions like AutoSum and AVERAGE.

Affective Domain:

Appreciate the importance of formulas and functions for efficient data processing.
Show interest in using spreadsheet software for calculations.

Psychomotor Domain:

Write simple formulas for addition, subtraction, multiplication, and division.
Apply basic functions such as AutoSum, AVERAGE, PRODUCT, and QUOTIENT.
Accurately total rows and columns in a spreadsheet.

Collaborate with peers in practicing formula and function application in a spreadsheet environment.

Reference Materials

The following resources were used in planning this lesson:

Senior Secondary Education Curriculum
State Unified Scheme of Work
Data Processing for Senior Secondary Schools, Book 1
https://www.gcfglobal.org/en/excel/formulas-and-functions/1/
https://support.microsoft.com/en-us/office/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca17d

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer set with MS Excel software installed
Projector (optional)
Whiteboard and markers

Rationale for the Lesson

This lesson helps pupils understand how to perform calculations and automate tasks in spreadsheet software. Learning formulas and functions enables pupils to analyze data efficiently, which is important for various academic and real-world applications requiring numerical data handling.

Prerequisite/Previous Knowledge

Pupils are assumed to have basic knowledge of computer operations and familiarity with the spreadsheet environment, including how to enter data into cells.

Lesson Content/Board Summary

Inserting Formulas and Using Functions

What is a Formula?

A formula is an expression that calculates values in a cell. Formulas always begin with an equals sign (=).

The following are basic arithmetic operators:

Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)

Writing Simple Formulas

Simple formulas involve basic arithmetic operations on cell references or values.

Examples of simple formulas:

=A1+B1 (Adds the values in cell A1 and B1)
=C5-D5 (Subtracts the value in D5 from C5)
=E2*F2 (Multiplies the values in E2 and F2)
=G3/H3 (Divides the value in G3 by H3)

Common Functions

Functions are pre-defined formulas that perform specific calculations using specific values, called arguments, in a particular order or structure.

The following are common functions:

AutoSum: This function quickly adds a range of numbers. It automatically detects a range of cells containing numbers.
AVERAGE: This function calculates the arithmetic mean of a range of numbers.
PRODUCT: This function multiplies all the numbers given as arguments and returns the product.
QUOTIENT: This function returns the integer portion of a division.

Examples of functions:

=SUM(A1:A10) (Adds values from A1 to A10)
=AVERAGE(B1:B5) (Calculates the average of values from B1 to B5)
=PRODUCT(C1,C2,C3) (Multiplies values in C1, C2, and C3)
=QUOTIENT(D1,D2) (Divides D1 by D2 and returns the integer part)

Totaling Rows and Columns

To total rows or columns, the SUM function or simple addition formulas are typically used.

Steps to total a column:

Select the cell at the bottom of the column you want to total.
Type =SUM( followed by the range of cells in the column (e.g., A1:A10).
Close the parenthesis and press Enter (e.g., =SUM(A1:A10)).

Steps to total a row:

Select the cell to the right of the row you want to total.
Type =SUM( followed by the range of cells in the row (e.g., B1:D1).
Close the parenthesis and press Enter (e.g., =SUM(B1:D1)).

Teaching Methods/Instructional Techniques

Discussion, Lecture, Demonstration, Question and Answer, Visual Aids

Instructional Procedures

Step 1: Introduction

Time: 5 minutes
Teaching Skill: Set Induction
Teacher’s Activity: The teacher greets the pupils and reviews the previous lesson briefly. The teacher then asks pupils how they perform calculations in real life and introduces the topic of using formulas and functions in spreadsheet software for efficient calculations.
Pupils’ Activity: Pupils respond to questions and listen attentively to the introduction.
Learning Point: Pupils recall previous knowledge and are prepared for the new topic.

Step 2: Explanation of Formulas

Time: 7 minutes
Teaching Skill: Explanation/Definition
Teacher’s Activity: The teacher defines what a formula is in a spreadsheet and explains that all formulas begin with an equals sign (=). The teacher lists and explains the basic arithmetic operators (addition, subtraction, multiplication, division) using the whiteboard.
Pupils’ Activity: Pupils listen, take notes, and ask questions for clarification.
Learning Point: Pupils understand the definition of a formula and its basic components.

Step 3: Demonstration of Simple Formulas

Time: 8 minutes
Teaching Skill: Demonstration/Practical Application
Teacher’s Activity: Using a computer and projector, the teacher demonstrates how to write simple formulas for addition, subtraction, multiplication, and division using cell references. The teacher provides practical examples in MS Excel.
Pupils’ Activity: Pupils observe the demonstration, try to follow along if computers are available, and write down examples.
Learning Point: Pupils see practical application of simple formulas and learn to write them.

Step 4: Introduction to Functions

Time: 7 minutes
Teaching Skill: Explanation/Concept Introduction
Teacher’s Activity: The teacher introduces the concept of functions as pre-defined formulas. The teacher explains the purpose of common functions like AutoSum, AVERAGE, PRODUCT, and QUOTIENT, highlighting their advantages.
Pupils’ Activity: Pupils listen, ask questions, and note down the names and purposes of the functions.
Learning Point: Pupils understand what functions are and their general use.

Step 5: Demonstration of Functions

Time: 8 minutes
Teaching Skill: Demonstration/Practical Application
Teacher’s Activity: The teacher demonstrates how to use the AutoSum function to quickly sum a range of cells. The teacher also demonstrates how to use the AVERAGE, PRODUCT, and QUOTIENT functions with appropriate arguments in MS Excel.
Pupils’ Activity: Pupils observe the demonstrations and practice using the functions if computer systems are available.
Learning Point: Pupils learn to apply various functions in a spreadsheet.

Step 6: Totaling Rows and Columns

Time: 5 minutes
Teaching Skill: Practical Application
Teacher’s Activity: The teacher guides pupils on how to total specific rows and columns using the SUM function or simple formulas. The teacher emphasizes selecting the correct cell range.
Pupils’ Activity: Pupils follow the instructions and practice totaling rows and columns.
Learning Point: Pupils can correctly sum values across rows and columns.

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

Define a formula in a spreadsheet.
List two basic arithmetic operators used in formulas.
Explain the purpose of the AutoSum function.
Write a simple formula to multiply the value in cell A5 by the value in cell B5.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Pupils demonstrate understanding of the lesson.

Step 8: Conclusion

Time: 2 minutes
Teaching Skill: Summarization
Teacher’s Activity: The teacher summarizes the key points of the lesson, reinforcing the importance of formulas and functions in data processing. The teacher assigns homework: “Create a simple spreadsheet in MS Excel with at least 5 rows and 3 columns of numerical data. Use simple formulas to perform addition, subtraction, multiplication, and division on different cells. Also, use the AutoSum and AVERAGE functions to calculate totals and averages.”
Pupils’ Activity: Pupils listen to the summary and copy the homework assignment.
Learning Point: Pupils consolidate their learning and prepare for independent practice.

Lesson Keywords

Formula – An expression that calculates values in a cell, always starting with an equals sign (=).
Function – A pre-defined formula that performs specific calculations.
AutoSum – A function that quickly adds a range of numbers.
AVERAGE – A function that calculates the arithmetic mean of a range of numbers.
PRODUCT – A function that multiplies all numbers given as arguments.
QUOTIENT – A function that returns the integer portion of a division.
Cell Reference – The address of a cell in a spreadsheet (e.g., A1, B5).
Operator – A symbol that represents an operation, such as + for addition or * for multiplication.

Differentiation

For pupils who grasp concepts quickly, the teacher can challenge them to explore more complex functions like IF statements or VLOOKUP. For pupils needing additional support, the teacher can provide more one-on-one guidance during practical sessions and offer simplified exercises focusing on one formula or function at a time.

Note for teachers using this lesson plan

Ensure that each pupil has access to a computer with MS Excel during the practical sessions. If computer access is limited, consider using a projector for whole-class demonstrations and then allowing pupils to practice in small groups or providing printed worksheets for manual formula writing before practical application. Emphasize the importance of the equals sign (=) at the beginning of all formulas and functions.