(The process of systematically planning, developing, evaluating and managing the instructional process by
using principles of teaching and learning - D.O. 42, s. 2016)
Detailed Lesson Plan (DLP) Format
School Sixto A. Abao National High School Grade Level 12
Teacher Learning Area Empowerment
Lara Melissa M. Tabamo
Technologies
Time & Dates Quarter I
I. OBJECTIVES
A. Content Standards The learner demonstrate an understanding of: the use of advanced
tools and techniques found in common productivity and software
applications in developing ICT content for specific professional tracks.
B. Performance Standards The learners shall be able to independently apply advanced
productivity tools to create or develop ICT content that are useful for
academic and chosen career.
C. Learning Competencies The learners uses common productivity tools effectively by
/ Objectives. maximizing advanced application techniques.
Write the LC code for each (CS_ICT11/12-ICTPT-Ic-d-4)
Identify the different excel formula and functions used in
Advanced and complex formulas and computations that is
useful in your chosen career.
II. CONTENT “Advanced and complex formulas and computations”
III. LEARNING
RESOURCES
A. References
1. Teacher’s Guide pages E - Tech Teachers Guide for Acad. Track pg. 8 - 9
2. Learner’s Materials E -Tech Student Reader pg. 23-26
pages
3. Textbook pages
4. Additional Materials
from Learning Resource
(LR) portal
B. Other Learning E -Tech - jemma, inc.
Resources http://www.excel-easy.com
IV. PROCEDURES
Introductory Activity Ask the following questions:
(3 minutes). This part 1. Who owns a business here?
introduces the lesson 2. Did you encounter any difficulty in balancing your assets and
content. Although at times liabilities? In your inventory?
optional, it is usually 3. Did you know that ICT has something to offer to make your
included to serve as a computation life easy?
warm-up activity to give the
learners zest for the You can use MS Excel to compute cost incurred in the projects, or
incoming lesson and an create tables or findings in the researches, and the create reports for
idea about what it to follow. business or research that you are doing. Spread sheet is also a
One principle in learning is collaboration tool for financial analysis or modelling.
that learning occurs when
it is conducted in a (In this portion, the teacher will state the objectives of the lesson.)
pleasurable and
comfortable atmosphere. Identify the different excel formula and functions used in Advanced
and complex formulas and computations that is useful in your chosen
career.
Activity/Strategy Group activity:
(5 minutes). “Label Me”
I will give you 3 minutes to answer by group. I will give you a
manila paper to copy and name the different symbols in the
equation flashed on screen. Underneath are the choices. The first
group to finish and has correct answer will be the winner.
= PI ( ) * A8 ^ 7 - 6 + 1
Functions Constant
Reference Operators
Equal sign
Analysis (3 minutes). Ask the following questions:
1. Are you familiar with this signs?
2. Is this use in mathematical computation?
3. What do you understand when we say advanced and complex
formulas and computations?
4. When are going to use Microsoft excel?
5. Can you sight any basic steps in Microsoft excel computation?
Abstraction (10 minutes). Okay, let’s talk about the Parts of formula and function.
Functions
Constants
Equal Sign = PI ( ) * A8 ^ 7 - 6 + 1
Reference Operators
PARTS OF A FORMULA
Functions The PI() function returns the value pi: 3.1416….
References A8 returns the value in cell A8
Constants Number or text values entered directly into formula,
such as 7, 6, 1
The ^ (caret) operator raises a number to a power
The * (asterisk) operator multiplies number
Operators
The + (plus) operator adds numbers
The - (minus) operator subtracts number
EXCEL FUNCTION - built - in formulas you can use to make your
work sheet construction easier
=SUM Calculates the sum of the values of a range cells
=AVERAGE Calculates the arithmetic mean of range of cells or
values
=MAX Gives the maximum value in a range of cells or values
=MIN Gives the minimum value in a range of cells or values
=COUNT Counts the number of cells in a range cells or values
=IF Shows a series of calculations using the same formula
but different value for each calculation to determine
whether the formula is true or false
Application (30 minutes). Practice the following
Group 1. “Sum Function” Activity
Group 2. “Average Function” Activity
Group 3. “Max Function” Activity
Group 4. “Min Function” Activity
Group 5. “Count Function”
After the activity, each group will have representative to report
their group output.
Assessment (6 minutes).
For the Teacher to: 1. It is the PI () function returns the value pi: 3.1416….
a) Assess whether learning a. Functions
objectives have been met b. Operators
for a specified duration, c. References
b) Remediate and/or d. Constants
enrich with appropriate 2. When A8 returns the value in cell A8
strategies as needed, and; a. Functions
c) Evaluate whether b. Operators
learning intentions and c. References
success criteria have been d. Constants
met. 3. Number or text values entered directly into formula, such as 7, 6, 1
(Reminder: Formative a. Functions
Assessment may be given b. Operators
before, during, or after the c. References
lesson). d. Constants
4. built - in formulas you can use to make your work sheet
construction easier
a. Functions
b. Operators
c. Excel Function
d. Constants
5 - 10. Locate inside the box the correct answer of the following question.
a. =SUM b. =AVERAGE c. =MAX d. =MIN e. =COUNT f. =IF
5. Calculates the sum of the values of a range cells
6. Calculates the arithmetic mean of range of cells or values
7. Gives the maximum value in a range of cells or values
8. Gives the minimum value in a range of cells or values
9. Counts the number of cells in a range cells or values
10. Shows a series of calculations using the same formula but different
value for each calculation to determine whether the formula is true
or false
Assignment/Agreement (3 Practice at home this following activities:
minutes Group 1. “Sum Function” Activity
Group 2. “Average Function” Activity
Group 3. “Max Function” Activity
Group 4. “Min Function” Activity
Group 5. “Count Function”
Screen print your steps and upload your activity in our group page.
V. REMARKS
VI. REFLECTION
