MacArthur National High School
MacArthur, Leyte
Daily Lesson Plan in Grade 11
Empowerment Technology
August 01, 2019
Thursday
11-Demeter 7:30-8:30; 11-Apollo 11:00-12:00; 11-Athena 4:00-5:00
I. Objectives:
CONTENT STANDARD: The learners 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
PERFORMANCE STANDARD: The learners shall be able to:
at the end of the 2-week period independently apply advanced productivity tools to create or develop ICT
content for use in specific professional tracks
These may be in the form of, but not limited to:
1. Calculating spread sheet of athletic statistics (Sports)
2. Layout of catalogue of creative works (Arts)
3. Materials/ ingredients projections for batches of baked goods (Tech - Voc)
4. Letterhead/ business card design (Business/ Academic)
LEARNING COMPETENCY: Creates an original or derivative ICT content to effectively communicate or
present data or information related to specific professional tracks. CS_ICT11/12-ICTPT-Ic-d-5
LO1: Apply conditional functions available in Microsoft Excel.
LO2: Use Microsoft Excel as a viable tool in market research product development.
II. Content:
A. Topic: ADVANCED SPREADSHEET SKILLS
III. Learning Resources:
B. References: Teacher’s Guide in Empowerment Technologies for the Technical-Vocational-
Livelihood Track;
C. Materials: Computers, PowerPoint presentation; Empowerment Technology textbook, Projector
IV. Procedures:
A. Review:
1. Discuss the use of the conditional functions in Microsoft Excel.
B. Motivation/Activity:
Assigning of groups
Come up with a product for each group
Type your product information in a Microsoft Word
D. Discussion: ADVANCED SPREADSHEET SKILLS
Microsoft Excel provides an automated way of displaying any statistical data. It can be used to
automatically compute for several factors that are not easy to notice especially when faced by a
large data. Microsoft Excel includes several arithmetic and basic functions that help you
compute faster.
Basic Excel Formulas:
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
*type <=> before the formula, thus: =a1+a2 <then, hit the ENTER key>
BASIC FUNCTIONS:
Average – a function used to compute for the average of the number of a range.
• COUNTIF – a function used to count the cells with a specified content within a range.
• SUMIF – a function used to compute for the summation of a range if a certain condition is met
• AVERAGEIF – a function used to compute for the average of a range if a certain condition is
met
D. Analysis:
1. How this Excel tool help the user in computing and large amount of data?
2. When can we use excel tool?
E. Abstraction:
1. What are the uses of different functions in Microsoft Excel?
F. Valuing:
Make use properly and appropriately the advancement of technology in order to be able
to make accurate and helpful data.
G. Application:
Can you see yourself using excel tool in your future employment?
H. Evaluation:
Type an estimated cost of your materials/ingredients in the Microsoft Excel
Come up with an estimated price for your product
Compute using the functions the total cost of your ingredients/materials.
Find out if your estimated product is reasonable or not.
IV. Assignment:
Work on your Microsoft Excel Activity
SECTION
11 - Demeter
11-Apollo
11-Athena
V. Remarks
Prepared by
CLARISSA B. RAMOS Noted by:
TEACHER – I JEAN C. ALA
TLE Dept. Head
