Term: 3rd Term
Week: 5
Class: Senior Secondary School 1
Age: 15 years
Duration: 40 minutes of 2 periods each
Date:
Subject: Data Processing
Topic: Spreadsheet II
SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to
INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source
INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, Online Materials.
INSTRUCTIONAL PROCEDURES
PERIOD 12
PRESENTATION 
TEACHER’S ACTIVITY 
STUDENT’S ACTIVITY 
STEP 1 INTRODUCTION 
The teacher reviews the previous lesson on Spreadsheet 
Students pay attention 
STEP 2 EXPLANATION 
He describes how to perform calculations in excel

Students pay attention and participates 
STEP 3 DEMONSTRATION 
He explains some errors that could occur in Excel

Students pay attention and participate 
STEP 4 NOTE TAKING 
The teacher writes a summarized note on the board 
The students copy the note in their books 
NOTE
Working with Excel worksheet
Recall that a cell can take short text (label), number and formula. So when working with Excel, you are expected to type in any of the above in the cells. The Excel sheet below will be used for our practical example.
Calculating in Excel
To do any form of calculation, a user is required to put a formula together or by using the predefined functions available in Excel.
To use any of the available functions, the following information should be taken into consideration:
A formula using a function name is of the form
= funct_name (arg1, arg2 , …, argN) ,
where N >= 1 and funct_name is the name of the function e.g. SUM, AVERAGE, COUNT, MIN, MAX etc.
Addition in Excel
Consider the Excel sheet above, to calculate the CA score for the first student (ESTHER) on the table:
Type any of the following formulas in cell D2
To calculate the Total score for TOBILOBA, use the formula:
Note: Total = CA + Exam
Average in Excel
Assuming the Total score for all students have been calculated, how do you calculate the Average of all the Total scores?
Note that the Total score for each student is calculated in column F, cell F2 for the first student up to cell F9 for the last student. To get the average of the Total scores, use the formula below:
Minimum and Maximum in Excel
To calculate the lowest Exam score, use the following formula:
To calculate the highest Exam score, use the following formula:
Grading in Excel
Consider the table above, If we are to grade according to a particular condition say, if a student’s Total score is 50 and above then his/her grade is “PASS” and if below 50, the grade is “FAIL”. How do you use Excel to achieve this?
To calculate the grade, MS Excel provides the IF function which has the syntax:
=IF(logical_test, value_if_true, value_if_false) , where:
So how do you calculate the grade for the last student on the list? i.e. JOSHUA
It is assumed that the total score has been calculated for JOSHUA, so in cell G9, type the following formula:
=IF(F9>=50, “PASS”,”FAIL”)
F9 is the cell where the Total score for JOSHUA is located, the ‘>=’ is the conditional operator to test if the value in cell F9 is greater than or equal to 50. If the test is carried out and it amount to true, then “PASS” will be inserted into cell G9 else ‘FAIL’.
DO IT YOURSELF!
What if the conditions are:
Total score is 75 and above, then grade is “ABOVE AVERAGE”, 50 to 74, the grade is “AVERAGE” and below 50 , the grade is “BELOW AVERAGE”. Write the IF functions to achieve this. Try this on your own!
Formula errors in Excel
EVALUATION: 1. Describe how to carry out the following calculations in excel
a. addition
b. average
c. minimum
d. maximum
2. Describe how to carry out grading in excel
3. What are some of the formula errors in excel and when do they occur?
CLASSWORK: As in evaluation
CONCLUSION: The teacher commends the students positively