DAILY LESSON LOG FOR School: Grade and Section: VI -

IN-PERSON CLASSES Teacher: Subject: TLE (ENTREP AND ICT)

Date and Time: MARCH 17 – 21, 2025 (WEEK 6) Quarter: FOURTH QUARTER

MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY

I. OBJECTIVES
A. Content Standards demonstrates knowledge and skills in performing advanced calculations on numerical data using an electronic spreadsheet tool
B. Performance Standards processes and summarizes numerical data using advanced functions and formulas in an electronic spreadsheet tool
C. Most Essential Learning uses functions and formulas in an electronic spreadsheet tool to perform advanced calculations on numerical data (TLEIE6-0f12)
Competencies (MELCS)
Write the code for each

D. LEARNING OBJECTIVES At the end of the lesson, the learners are expected to:
a. Use functions and formulas in an electronic spreadsheet tool to perform advanced calculations on numerical data.

PERFORMING PERFORMING PERFORMING PERFORMING

ADVANCE ADVANCE ADVANCE ADVANCE
II. CONTENT CALCULATIONS USING CALCULATIONS USING CALCULATIONS USING CALCULATIONS USING CATCH-UP FRIDAY
ELECTRONIC ELECTRONIC ELECTRONIC ELECTRONIC
SPREADSHEETS SPREADSHEETS SPREADSHEETS SPREADSHEETS
III. LEARNING
RESOURCES
A. References
1. Teacher’s Guide
pages
2.Learner’s Material
pages
3.Textbook pages
4.Additional Materials Hernandez, C., Hernandez, C., Hernandez, C., Hernandez, C.,
from Learning Resource Tormes,A., Cramonte,R., Tormes,A., Cramonte,R., Tormes,A., Cramonte,R., Tormes,A., Cramonte,R.,
(LR) portal/LASs/SLMs) & Sumalinog, F.M. (2020). & Sumalinog, F.M. (2020). & Sumalinog, F.M. (2020). & Sumalinog, F.M. (2020).
Technology and Technology and Technology and Technology and
Livelihood Education ICT Livelihood Education ICT Livelihood Education ICT Livelihood Education ICT
and Entrepreneurship and Entrepreneurship and Entrepreneurship and Entrepreneurship
Module 6: Performing Module 6: Performing Module 6: Performing Module 6: Performing
Advance Calculations Advance Calculations Advance Calculations Advance Calculations
 Using Electronic Using Electronic Using Electronic Using Electronic
Spreadsheets [Self- Spreadsheets [Self- Spreadsheets [Self- Spreadsheets [Self-
Learning Modules]. Learning Modules]. Learning Modules]. Learning Modules].
Moodle. Department of Moodle. Department of Moodle. Department of Moodle. Department of
Education. Retrieved (May Education. Retrieved (May Education. Retrieved (May Education. Retrieved (May
03, 2024) from https://r7- 03, 2024) from https://r7- 03, 2024) from https://r7- 03, 2024) from https://r7-
2.lms.deped.gov.ph/moodl 2.lms.deped.gov.ph/moodl 2.lms.deped.gov.ph/moodl 2.lms.deped.gov.ph/moodl
e/mod/folder/view.php? e/mod/folder/view.php? e/mod/folder/view.php? e/mod/folder/view.php?
id=13094 id=13094 id=13094 id=13094

Yumul, M. (2021). Yumul, M. (2021). Yumul, M. (2021). Yumul, M. (2021).

Creating an Online Survey Creating an Online Survey Creating an Online Survey Creating an Online Survey
Form [Learning Activity Form [Learning Activity Form [Learning Activity Form [Learning Activity
Sheet]. Department of Sheet]. Department of Sheet]. Department of Sheet]. Department of
Education Education Education Education
B. Other Learning PowerPoint Presentation, PowerPoint Presentation, PowerPoint Presentation, PowerPoint Presentation,
Resources laptop, SLMs/Learning laptop, SLMs/Learning laptop, SLMs/Learning laptop, SLMs/Learning
Activity Sheets, bolpen, Activity Sheets, bolpen, Activity Sheets, bolpen, Activity Sheets, bolpen,
lapis, kuwaderno lapis, kuwaderno lapis, kuwaderno lapis, kuwaderno
IV. PROCEDURES
A. Reviewing previous Direction: Why is Directions: Encircle Directions: Answer the Directions: Answer the
lesson or presenting the conducting an online TRUE if the statement is question. question.
new lesson survey important? correct, FALSE if not.
1. True or False: How does the process of
Electronic spreadsheet using electronic In what ways does the
software can be helpful in spreadsheet software to integration of formulae,
managing and updating manage inventory and functions, and conditional
records such as the make informed decisions formatting in spreadsheets
balance sheet and income about stock procurement enhance an
statement. reflect on the entrepreneur's ability to
2. True or False: Microsoft interconnectedness analyze business data and
Excel is probably the most between technological make strategic choices for
popular electronic tools and entrepreneurial inventory management?
spreadsheet program decision-making?
used today.
3. True or False: Open-
source software allows
anyone to access and
modify its source code,
while proprietary software
 is solely owned by its
developer or publisher.
4. True or False:
Spreadsheets can perform
basic mathematical
operations such as
addition, subtraction,
multiplication, and
division.
5. True or False: You can
format column titles with
text, enter textual
information in cells, delete,
add, or merge columns or
rows, add or delete
sheets, and select printing
options in spreadsheets.
B. Establishing a purpose Are you familiar with this? Within one minute, provide Compute the following Perform the basic
for the lesson a part of the spreadsheet using an electronic formulas/computations
inside the box. spreadsheet. Write the using Excel/spreadsheet.
answers in your notebook.
1. 12345678 + 9876543 =
_______________
2. 65476736 ÷ 123873 =
________________
3. 64638489 x 1528483 =
_______________

C. Presenting Spread sheets are Spread sheets are Spread sheets are Spread sheets are
examples/instances of the designed with functions designed with functions designed with functions designed with functions
new lesson and formulas that will and formulas that will and formulas that will and formulas that will
make calculating make calculating make calculating make calculating
numerical data easier and numerical data easier and numerical data easier and numerical data easier and
convenient for you. Using convenient for you. Using convenient for you. Using convenient for you. Using
formulas and functions will formulas and functions will formulas and functions will formulas and functions will
help you increase the help you increase the help you increase the help you increase the
accuracy of your accuracy of your accuracy of your accuracy of your
calculations while calculations while calculations while calculations while
decreasing the amount of decreasing the amount of decreasing the amount of decreasing the amount of
time you need to spend in time you need to spend in time you need to spend in time you need to spend in
 Excel. Excel. Excel. Excel.
D. Discussing new concepts Using Spreadsheets Using Spreadsheets Using Spreadsheets Using Spreadsheets
and practicing new skills Probably the most popular Probably the most popular Probably the most popular Probably the most popular
#1 electronic spreadsheet electronic spreadsheet electronic spreadsheet electronic spreadsheet
program that we use today program that we use today program that we use today program that we use today
is Microsoft Excel. It uses is Microsoft Excel. It uses is Microsoft Excel. It uses is Microsoft Excel. It uses
columns and rows, like a columns and rows, like a columns and rows, like a columns and rows, like a
table, where you enter table, where you enter table, where you enter table, where you enter
data in each cell. data in each cell. data in each cell. data in each cell.

Open-source refers to the Open-source refers to the Open-source refers to the Open-source refers to the
software whose source software whose source software whose source software whose source
code is available for code is available for code is available for code is available for
anybody to access and anybody to access and anybody to access and anybody to access and
modify, while proprietary modify, while proprietary modify, while proprietary modify, while proprietary
software refers to the software refers to the software refers to the software refers to the
software which is solely software which is solely software which is solely software which is solely
owned by the individual or owned by the individual or owned by the individual or owned by the individual or
publisher who developed it publisher who developed it publisher who developed it publisher who developed it
Spreadsheets can help Spreadsheets can help Spreadsheets can help Spreadsheets can help
you do basic mathematical you do basic mathematical you do basic mathematical you do basic mathematical
operation such as operation such as operation such as operation such as
addition, subtraction and addition, subtraction and addition, subtraction and addition, subtraction and
multiplication, and multiplication, and multiplication, and multiplication, and
divisions: divisions: divisions: divisions:
a. Format the column titles a. Format the column titles a. Format the column titles a. Format the column titles
with text with text with text with text
b. Enter textual b. Enter textual b. Enter textual b. Enter textual
information in each cell information in each cell information in each cell information in each cell
aside from number; aside from number; aside from number; aside from number;
c. Delete, add, or merge c. Delete, add, or merge c. Delete, add, or merge c. Delete, add, or merge
columns or rows; columns or rows; columns or rows; columns or rows;
d. Add or delete sheets; d. Add or delete sheets; d. Add or delete sheets; d. Add or delete sheets;
and and and and
e. Select printing options e. Select printing options e. Select printing options e. Select printing options
E. Discussing new concepts To perform computations, To perform computations, To perform computations, To perform computations,
and practicing new skills select the cell where you select the cell where you select the cell where you select the cell where you
#2 want the output to be want the output to be want the output to be want the output to be
displayed. You can then displayed. You can then displayed. You can then displayed. You can then
use the formula editor to use the formula editor to use the formula editor to use the formula editor to
program your program your program your program your
computations. computations. computations. computations.
F. Developing mastery Directions: Write whether Directions: To ensure the Directions: Imagine that Directions: Read and
(Leads to Formative it is TRUE or FALSE. success of your business, you are managing a analyze the following
Assessment ) ______1. To add a new it is important to keep simple sari-sari store. statements or questions
row in a spreadsheet, click track of your customers’ Design an inventory below. Choose the letter
a cell in the row directly order so you will not miss worksheet in Excel of the correct answer.
above where you want the an opportunity to earn. identifying sample items 1. It multiplies all the
new row. Create a Purchase Order that you sell. Follow the numbers given as
______ 2. A formula and Inventory using an instructions below: argument.
function are the same electronic spreadsheet hat 1. Type the name of your a. Quotient
thing. contains the data below. sari-sari store on the first b. Sum
______ 3. Spreadsheet Make sure to use Function row of the worksheet. c. Product
programs calculate Arguments to help you 2. Type "ITEM" on the first d. Power
expressions within generate information. column of row 3. 2. What functions should
parentheses last and 3. Type "QUANTITY" on be used when adding all
follow the MDAS rule. Table 1: Purchase Order the second column of row the numbers in a range of
_______4. It is possible to Inventory 3. cell?
insert an image from a file 1. A column for 4. Type "UNIT PRICE" on a. Sum
into an electronic Customers’ Names (at the third column of row 3. b. Product
spreadsheet. least 5 names) 5. Type 15 items that you c. Quotient
_______5. An electronic 2. A column for products sell in the first column d. MOD
spreadsheet can be used they ordered (3 products) starting on the 4th row. 3. What function should be
as the “data source” for a 3. A column for prices (to 6. Type the corresponding used when adding the
Word Mail Merge. save you time for quantity (between 25 - cells specified by the
encoding, aVLOOKUP 100) and realistic unit condition or criteria?
Function) price of each of the items. a. SUMPRODUCT
4. A column for order 7. Type "NO. OF ITEMS b. SUMIF
 quantity SOLD" on the fourth c. SUMIFS
5. A column for total column of row 3. d. SUMSQ
amount per order 8. Type "NO. OF ITEMS 4. It returns the integer
6. A column for [remarks] LEFT" on the fifth column portion of a division.
which will indicate if the of row 3. a. Quotient
order is [Retail] or [Bulk] 9. Type "SALES" on the b. Sum
use IF Function for this. sixth column of row 3. c. Product
Set the number of order 10. Type any number d. Power
for Retail or Bulk) under NO. OF ITEMS 5. This function returns the
SOLD for each of the remainder after a number
items. Be sure to enter a is divided by a divisor.
number that is less than a. SUMPRODUCT
the given number under b. MOD
QUANTITY. c. SUMIF
11. Format your inventory d. SUMSQ
worksheet according to
your own style.
12. Save your inventory
worksheet.
G. Finding practical How is the use of What are the different How does the integration In what profound ways
applications of concepts electronic spreadsheets ways in which electronic of electronic spreadsheets does the widespread
and skills in daily living for advanced calculations spreadsheets assist in into daily routines facilitate adoption of electronic
relevant to everyday everyday financial tracking expenses, spreadsheets for
tasks? planning and budgeting? managing investments, advanced calculations
and optimizing resource empower individuals to
allocation? make informed decisions,
manage personal finances
effectively, and enhance
productivity in their daily
lives?
H. Making generalizations What are the basic How can basic and How does using electronic How does proficiency in
and abstractions about functions of electronic advanced functions of spreadsheets for using electronic
the lesson spreadsheets? electronic spreadsheets performing advanced spreadsheets for
be used for calculations? calculations contribute to advanced calculations
faster and more effective expand our technological
data processing? capabilities and enhance
our ability to conduct
deeper and more complex
analysis of data and
information?
I. Evaluating learning Directions: True or False. Directions: Answer the Directions: Answer the Directions: Answer the
Write your answers in your Table 2 using the following in your notebook. question.
notebook. information in the activity. 1. How can an electronic
________1. MS Excel is Table 2: Summary of spreadsheet help an 1. How would you
one of the most commonly Order entrepreneur run a compare and differentiate
used computerized 1. A column for products business? the features of proprietary
worksheet. 2. A column for total software and those of
________2. number of order per open source software?
2. Can we rely on an
SUMPRODUCT is a product
electronic spreadsheet to
function that returns the 3. Two columns that will
deliver an accurate
remainder after a number generate the count [Bulk]
output?
is divided by a divisor. and[Retail] orders.
________3. Using the
formulas and functions will
help you increase the
accuracy of your
calculations while
decreasing the amount of
time you need to spend.
________4. MS Excel is
widely used in accounting
and financial applications,
statistics, engineering
calculations, as well as in
analyzing data.
________5. To create and
enter functions without the
equal (=) sign, excel will
still calculate a result.
J. Additional activities for
application or remediation
V. REMARKS
VI. REFLECTION
A. No. of learners who
earned 80% in the
evaluation
B. No. of learners who
require additional
activities for remediation
who scored below 80%
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
strategies worked well?
Why did these work?
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?