GRADE 1 TO 12 School: ILOCOS SUR NATIONAL HIGH SCHOOL Grade Level: Grade - 11

Daily Learning Senior High School

Teacher: SHELANIEJEAN L. LIM EMPOWERMENT TECHNOLOGIES (E-TECH)
Area: 300072
Lesson Log Teaching Dates
July 9-13, 2018 Week: 4
and Time:

Session 1 Session 2 Session 3 Session 4

I. OBJECTIVES The learners uses common productivity tools effectively by maximizing advanced application techniques and creates an original or derivative ICT content to effectively
communicate or present data or information.
A. Content Standards 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.
B. Performance Standards The learners should be able to independently apply advanced productivity tools to create or develop ICT content for use in specific professional tracks.
C. Learning Competencies  CS_ICT11/12-ICTPT-Ic-d-5  CS_ICT11/12-ICTPT-Ic-d-5  CS_ICT11/12-ICTPT-Ic-d-5
/ Objectives Objectives: Objectives: Objectives:
 The learners are expected:  The learners are expected:  The learners are expected:
1. Familiarize the most commonly 1. Use hyperlinks to improve their 4. Use hyperlinks to improve their slideshow(s).
used functions in Microsoft slideshow(s). 5. Embed files and data to their slideshow(s)
Excel. 2. Embed files and data to their slideshow(s) Maximize slideshow(s) as an effective visual aid tool.
2. Use several conditional functions 3. Maximize slideshow(s) as an effective
available in Microsoft Excel. visual aid tool.
II. CONTENT Conditional functions Hyperlinks Embedding Files and data
III. LEARNING RESOURCES
A. References
1. Teacher’s Guide p. 6 p. 6 p. 6
Pages
2. Learner’s Material
Pages
3. Textbook Pages  Empowerment Technologies (Argel A.  Empowerment Technologies (Argel A.  Empowerment Technologies (Argel A. Bandala, 2016) p. 27-
Bandala, 2016) p. 67- 79 Bandala, 2016) p. 27-35 35
 Empowerment Technologies (Erwin  Empowerment Technologies (Erwin Reyes  Empowerment Technologies (Erwin Reyes Callo) p. 20-24
Reyes Callo) p 25 - 27 Callo) p. 20-24

4. Additional Materials
from Learning
Resources
B. Other Learning  Empowerment Technologies Curriculum  Empowerment Technologies Curriculum Guide  Empowerment Technologies Curriculum Guide by DepEd
Resources Guide by DepEd by DepEd Powerpoint Presentation, LCD Projector, Laptop
 Powerpoint Presentation, LCD Projector,  Powerpoint Presentation, LCD Projector,
Laptop Laptop
IV. PROCEDURES
1. Presenting the new The teacher will ask students if they are The teacher will ask students to have a recap on Review the key points in the discussion about the mail merge
lesson/Discussion familiar with Microsoft Excel and its parts yesterday's topic. process from the previous lesson.
 2. Establishing a purpose Ask students at introduction: who has used The teacher will divide the class into groups and The teacher will divide the class into groups and present to class
for the lesson Excel before? What have you used it to do? present to class the “Bazaar Business Venture” the “Bazaar Business Venture”

3. Presenting Examples / The teacher: The teacher presents the tips on creating an effective The teacher presents the tips on creating an effective pesentation
Instances of the new Discuss the basics of Microsoft Excel features pesentation with examples. with examples.
lesson through slideshow presentation.
1. Discussing new concepts The teacher: Activity: Bazaar Results Presentation Activity: Bazaar Results Presentation
and practicing new skills # 1 Explain the commonly used Microsoft Excel The teacher will instruct the learners to use the The teacher will instruct the learners to use the guide for the
functions through slideshow demonstration guide for the presentation. presentation.
with examples.
2. Discussing new concepts Key Take-aways (Demo) Understanding Concepts: Understanding Concepts:
and practicing new skills # 2 Demonstrate the conditional functions in The teacher will discuss and demonstrate the ways The teacher will discuss and demonstrate the ways to insert
Microsoft Excel. to insert hyperlinks and embed objects in a hyperlinks and embed objects in a document.
document.
3. Developing Mastery List down other functions you were able to Activity: What have I learned so far? Activity: What have I learned so far?
(Leads to Formative realize that are not part of the lesson then How is Internet connectivity important when a user How is Internet connectivity important when a user clicks a
Assessment) briefly describe each of them. clicks a hyperlink from an external source in the hyperlink from an external source in the Web?
Web?
4. Finding Practical Determine other instances where you can use 1. What is the signicance of using hyperlinks that 3. What is the signicance of using hyperlinks that navigate around
applications of concepts the COUNTIF, SUMIF, and AVERAGEIF navigate around your presentation instead of just your presentation instead of just using keyboard shortcuts?
and skills functions using keyboard shortcuts? Cite three instances where objects can help you improve your
2. Cite three instances where objects can help you presentation.
improve your presentation.
1. Making generalizations 1. Why do you think it is important for us to In what kinds of projects is the hyperlink very In what kinds of projects is the hyperlink very helpful? Why do you
and abstractions about know the different parts of Microsoft helpful? Why do you think hyperlinks can help you think hyperlinks can help you in this regard?
the lesson Excel? in this regard?
Why it is significant to know the location of
the different parts of Microsoft Excel?
2. Evaluating Learning Quiz (10 points) Quiz (10 points)
3. Additional activities for
application or
remediation
V. REMARKS Continuation of lesson on July 6, 2018 Continuation of lesson on July 10, 2018
VI. REFLECTION
A. No. of learners who 11 – Opal __________ 11 – Opal __________ 11 – Opal __________
earned 80% on the
formative assessment
B. No. of learners who
require additional
activities for remediation
C. Did the remedial lessons
work? No. of learners who
 have caught up with the
lesson.
D. No. of learners who
continue to require
remediation
E. Which of my teaching Demonstration presentation in a step by step
strategies worked well? procedure because they can easily understood the
Why did these work? lesson if there are additional images during the
discussion.
F. What difficulties did i
encounter which my
principal or supervisor can
help me solve?
G. What innovation or
localized materials did i
use / discover which i wish
to share with other
teachers?

Prepared by: Checked and Noted by:

SHELANIEJEAN L. LIM, MIT CHRISTIAN GIRON, Ed. D

SHS – Subject Teacher, HUMSS Subject Group Head, HUMSS