6

Technology
and Livelihood
Education
Quarter 3 – Module 6:
Using functions and formulas
in an electronic spreadsheet tool
to perform advanced calculations
on numerical data

INFORMATION AND
COMMUNICATIONS
TECHNOLOGY /
ENTREPRENEURSHIP
(Grade 6)
TLE ICT/ENTREP– Grade 6
Self-Learning Module (SLM)
Quarter 1–Module 4: Title: Using functions and formulas in an electronic spreadsheet
tool to perform advanced calculations on numerical data.
First Edition, 2020

Republic Act 8293, section 176 states that: No copyright shall subsist in any work of
the Government of the Philippines. However, prior approval of the government agency or office
wherein the work is created shall be necessary for exploitation of such work for profit. Such
agency or office may, among other things, impose as a condition the payment of royalties.

Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand names,
trademarks, etc.) included in this module are owned by their respective copyright holders.
Every effort has been exerted to locate and seek permission to use these materials from their
respective copyright owners. The publisher and authors do not represent nor claim ownership
over them.

Development Team of the Module

Writer: Jocelyn L. Cagang
Editors: Jessica T. Verallo and Emelinda F. Pono
Reviewers: Amalia C. Caballes, EPS
Illustrator: Name
Layout Artist: Emelinda Pono
Cover Art Designer: Arvel G. Campollo
Management Team: Allan G. Farnazo, CESO IV – Regional Director
Fiel Y. Almendra, CESO V – Assistant Regional Director
Romelito G. Flores, CESO V - Schools Division Superintendent
Mario M. Bermudez, CESO VI -Assist. Schools Division Superintendent
Gilbert B. Barrera – Chief, CLMD
Arturo D. Tingson Jr. – REPS, LRMS
Peter Van C. Ang-ug – REPS, ADM
Name of REPS – Subject Area Supervisor
Juliet F. Lastimosa - CID Chief
Sally A. Palomo - Division EPS In- Charge of LRMS
Gregorio O. Ruales - Division ADM Coordinator
Amalia C. Caballes – Education Program Supervisor 1

Printed in the Philippines by Department of Education –Region XII

Office Address: Regional Center, Brgy. Carpenter Hill, City of Koronadal

Telefax: (083) 2288825/(083) 2281893
E-mail Address: region12@deped.gov.ph
 6
Technology
and Livelihood
Education
Quarter 3 – Module 6:
Using functions and formulas
in an electronic spreadsheet tool
to perform advanced calculations
on numerical data

INFORMATION AND
COMMUNICATIONS
TECHNOLOGY /
ENTREPRENEURSHIP
(Grade 6)
Introductory Message
For the facilitator:

Welcome to the TLE ICT/ENTREP 6 Alternative Delivery Mode (ADM) Module

6: Using functions and formulas in an electronic spreadsheet tool to perform
advanced calculations on numerical data!

This module was collaboratively designed, developed and reviewed by

educators both from public and private institutions to assist you, the teacher or
facilitator in helping the learners meet the standards set by the K to 12 Curriculum
while overcoming their personal, social, and economic constraints in schooling.

This learning resource hopes to engage the learners into guided and
independent learning activities at their own pace and time. Furthermore, this also
aims to help learners acquire the needed 21st century skills while taking into
consideration their needs and circumstances.

In addition to the material in the main text, you will also see this box in the
body of the module:

Notes to the Teacher

This contains helpful tips or strategies that
will help you in guiding the learners.

As a facilitator you are expected to orient the learners on how to use this
module. You also need to keep track of the learners' progress while allowing them to
manage their own learning. Furthermore, you are expected to encourage and assist
the learners as they do the tasks included in the module.

2
For the learner:
Welcome to the TLE ICT/ENTREP Alternative Delivery Mode (ADM) Module 6:
Using functions and formulas in an electronic spreadsheet tool to perform advanced
calculations on numerical data!

The hand is one of the most symbolized part of the human body. It is often
used to depict skill, action and purpose. Through our hands we may learn, create
and accomplish. Hence, the hand in this learning resource signifies that you as a
learner is capable and empowered to successfully achieve the relevant competencies
and skills at your own pace and time. Your academic success lies in your own hands!

This module was designed to provide you with fun and meaningful
opportunities for guided and independent learning at your own pace and time. You
will be enabled to process the contents of the learning resource while being an active
learner.

This module has the following parts and corresponding icons:

What I Need to Know This will give you an idea of the skills or
competencies you are expected to learn in the
module.

What I Know This part includes an activity that aims to

check what you already know about the
lesson to take. If you get all the answers
correct (100%), you may decide to skip this
module.

What’s In This is a brief drill or review to help you link

the current lesson with the previous one.

What’s New In this portion, the new lesson will be

introduced to you in various ways such as a
story, a song, a poem, a problem opener, an
activity or a situation.

What is It This section provides a brief discussion of the

lesson. This aims to help you discover and
understand new concepts and skills.

What’s More This comprises activities for independent

practice to solidify your understanding and
skills of the topic. You may check the
answers to the exercises using the Answer
Key at the end of the module.

What I Have Learned This includes questions or blank

sentence/paragraph to be filled in to process
what you learned from the lesson.

3
 What I Can Do This section provides an activity which will
help you transfer your new knowledge or skill
into real life situations or concerns.

Assessment This is a task which aims to evaluate your

level of mastery in achieving the learning
competency.

Additional Activities In this portion, another activity will be given

to you to enrich your knowledge or skill of the
lesson learned. This also tends retention of
learned concepts.

Answer Key This contains answers to all activities in the

module.

At the end of this module you will also find:

References This is a list of all sources used in developing

this module.

The following are some reminders in using this module:

1. Use the module with care. Do not put unnecessary mark/s on any part of the
module. Use a separate sheet of paper in answering the exercises.
2. Don’t forget to answer What I Know before moving on to the other activities
included in the module.
3. Read the instruction carefully before doing each task.
4. Observe honesty and integrity in doing the tasks and checking your answers.
5. Finish the task at hand before proceeding to the next.
6. Return this module to your teacher/facilitator once you are through with it.
If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your teacher or facilitator. Always bear in mind that you are
not alone.

We hope that through this material, you will experience meaningful learning and
gain deep understanding of the relevant competencies. You can do it!

What I Need to Know

In this module, you will learn uses functions and formulas in an electronic
spreadsheet tool to perform advanced calculations on numerical data.

4
 Among the computers program which exist, Microsoft Excel is one of the most
important because of the key role it plays in many sectors. Many businesses,
personal and institutional enterprises have embraced the use of Excel because of its
utility and the ability to serve as a visual basic for different applications.

The lesson targets the learners to define what an electronic spreadsheet its
uses functions and formulas in an electronic spreadsheet tool to perform calculations
on numerical data, enumerate the uses of and processes involved in preparing a
spreadsheet (Excel) and express appreciation for the use of spreadsheet.

At the end of this module, you should be able to:

• Define electronic spreadsheet
• Uses function and formulas in an electronic spreadsheet tool
to perform advanced calculations on numerical data.
• Enumerate the uses of and processes involved and preparing a
spreadsheet ( Excel)
• Express appreciation for the use of spreadsheet

What I Know

Through Excel the learners allow to organize data, calculate equations,

present the data in a table or graph and make decisions fast. Do you know what
Excel is? What are some of the things that you can actually put in an Excel program?
Do you have any experience using Excel?

Activity 1

Let’s answer the following questions.

Direction: Choose the letter of the correct answer.

1. It is like a filing system and a calculator. It is made up of grids where you can
enter data and text.
A. MS Power point
B. MS Word
C. MS Publisher
D. Spreadsheet

2. It is a set of drop down menus with all the Excel features.

A. tool bar
B. menu bar
C. sheet tabs
D. formula bar
3. It displays the data that you have entered in the worksheet.
A. tool bar
B. name box
C. sheet tabs
D. formula bar

5
 4. It is located at the bottom of the window.
A. name box
B. status bar
C. sheet tabs
D. formula bar
5. It is composed of numbers that you can add, subtract, multiply, divide and
use in the formula.
A. Formula
B. Text entry
C. Numeric data
D. None of the above
6. You can use______ for the titles, heading, and other notes.
A. formula
B. text entry
C. numeric data
D. none of the above
7. You can use____ to calculate the value of the cell from the contents of the other
cells.
A. formula
B. text entry
C. data entry
D. numeric data
8. What does the symbol ^ stand for?
A. division
B. equal to
C. exponent
D. multiplication
9. What does the symbol * stand for?
A. division
B. equal to
C. exponent
D. multiplication
10. What does the symbol / stand for?
A. division
B. equal to
C. exponent
D. multiplication

Lesson Using functions and formulas in an

electronic spreadsheet tool to
6 perform advanced calculations
on numerical data.

6
 What’s In

Digital literacy equips our learners to enjoy a high quality of life, work creative
and understand the value of collaboration. The learners utilize computers and
related technology efficiently with a range of skills covering from elementary use to
programs and other applications that are associated with computers.

Can you identify some of the Microsoft Office Program ?

What’s New

Now, let’s have a short activity that motivates you with our lesson.
ACTIVITY 2

Direction: Find and circle all the Microsoft Office Program. They may read in any
direction.

T A N E X C E L T P
W C E H N B L O N U
O C Y P A D A I O B
R E I S R T O Y S L
D S K T O P S O P I
E S O O R L E U Z S
R S L E E P M H P H
H O W E N W E B C E
S O R K I M A M Z R
P H A R E P O I N T

7
 What is It

We have already learned about Microsoft Excel. Let’s take a pause briefly
and ponder.

PARTS OF EXCEL

Here are the steps in creating Chart in Excel.

Microsoft Excel no longer provides the chat wizard. Instead, you can create a
basic chart by clicking the chart type that you want on the Insert tab in the Charts
group.

1. Enter the data for the chart on a worksheet

8
2. Compute for the chart table values.

A. Enter an average formula in cell G4.

Example: =AVERAGE (C4:F4). You may also use the Excel
function formula. (Computing for the averages for each subject areas)

B. Press Enter to see the computed average value for cell G4.

9
C. Select G4; then, drag from G4 to G8,using the mouse t apply formula to the
other cells .This will automatically display the average value of the other
subject areas then press Enter

D. Compute the General Average. Click cell G9, then enter the formula =
AVERAGE enter (G4:G8). Click Enter to show the value.

10
3. Select the data for the chart.

A. Select the cells from A4 to A8 by dragging the mouse button (Subject Areas);
then hold the control key to select from the G4 to G8 (Grade Average of each
of the different subject areas).

B. Select a chart type that you want on the Insert tab in the charts group. For
this exercise, select exploded pie chart in 3D.

11
 4. Create a chart by double-clicking the selected chart or by pressing
Enter (Select a pie chart). Excel will automatically plot the value of your
work sheet to your selected chart

5. You can modify one or more of the following elements.

a. Chart Title
b. Axis Title
c. Legend
d. Data Levels
e. Data Table
f. Axis
G. Grid Lines

6. Save the Excel document.

12
Note: Use any of the following methods to save the active workbook.

1. Click the office button; then, choose save.

2. Click the save button on the Quick Access toolbar.
3. Press Ctrl +S.
4. Press Shift+F12

What’s More

Activity 4
Direction: Identify the symbol the following operation in inserting text and numeric
data. Choose your answer from the box. Write the symbol of the correct answer in
the blank before each number.

* < > & = / ^

_______ 1. Exponentiation (raised to the power)
_______ 2. Greater than
_______ 3. Concatenation (joins text)
_______ 4. Division
_______ 5. Multiplication

Activity 5
Unscramble the letters to spell out the content described
__________ 1. Use in text entries for titles, headings, and other notes.
(etnetrxy)
__________ 2. Composed of numbers that can add, subtract, multiply, divide, and
use in formulas
(namrcidueat)
___________ 3.Use to calculate the value of the cell from the contents of the other
cells.
(rumfola)
___________ 4. Consist of a circle divided into a number of segments which
represent the value of data.
(iepcathr)
___________ 5. Uses bars to present values
(rbagaprh)

13
 What I Have Learned

sBasically, it’s a spreadsheet program used to store, organize, and analyze

data. It features columns and rows to keep inserted information legible and simple
to understand. It performs calculations, make decisions and present your data in a
table or graph.

Activity 1.6

Directions: Put a check mark (/) if it is the functions and formulas in an electronic
spreadsheet tool in performing calculations on numerical data, cross
(X) if not

______1. A spreadsheet is like a filing system and a calculator.

______2. Text entry use for titles , headings, and other notes.
______3. Formula used to calculate the value of the cell from the contents of the
other cells.
______4. Numeric data composed of numbers that can add, subtract, multiply,
divide and use of formulas.
______5. A pie chart consists of a circle divide with a number of segments which
represent the value of the data.
______6. A bar graph uses bars to present values.
______7. Create a basic chart by clicking the chart type that you want on the insert
tab in the charts group.
______8. Enter the data for the chart on a cells.
______9. You can modify one element only.
______10.The formula starts with an equal sign

What I Can Do

Activity 7

Now that you’ve learned one of the Microsoft Office Program which is the
spreadsheet (Excel) lets summarize the uses and process involved in preparing a
spreadsheet (Excel).

Using this kind of program, what are the uses and process involved? In what
form of presentation do your data presented?

In this quarantine phenomenon our government shared a SAP “ayuda” of

5,000. Show your data making a budget for family needs.

14
 Assessment

Direction: A. Encircle the letter of the correct answer.

1. It displays the data that you have entered in the worksheet.
A. tool bar
B. name box
C. sheet tabs
D. formula bar

2. It is located at the bottom of the window.

A. name box
B. status bar
C. sheet tabs
D. formula bar

3. It is a set of drop down menus with all the Excel features.

A. tool bar
B. menu bar
C. sheet tabs
D. formula bar

4. It is like a filing system and a calculator. It is made up of grids where

you can enter data and text.
A. MS Word
B. Spreadsheet
C. MS Publisher
D. MS Power point

5. It is composed of numbers that you can add ,subtract, multiply, divide

and use in the formula.
A. Formula
B. Text entry
C. Numeric data
D. None of the above

6. You can use______ for the titles, heading, and other notes.
A. formula
B. text entry
C. numeric data
D. none of the above

7. You can use____ to calculate the value of the cell from the contents of the
other cells.
A. formula
B. text entry
C. data entry
D. numeric data

15
 8. What does the symbol ^ stand for?
A. division
B. equal to
C. exponent
D. multiplication

9. What does the symbol / stand for?

A. division
B. equal to
C. Exponent
D. multiplication

10. What does the symbol * stand for?

A. division
B. equal to
C. exponent
D. multiplication

A. Imagine you conduct a survey from your friends to find the kind of movie they
like best. Show the data using Pie chart.

Action 4
Comedy 5
Romance 1
K- Drama 8
SciFi 2
Total 20

Additional Activities

Compute the average of Cheeky’s grades using the Excel program.

Subject 1 2 3 4 Average
English 86 88 83 85
Math 89 89 90 84
Science 90 90 86 86
Filipino 89 88 88 85
EPP 90 89 85 87
MAPEH 92 88 87 88
Total Average

Your work will be evaluated by your teacher using the following criteria:
Accuracy 70%
Neatness 30 %
Total 100%

16
 17
ASSESMENT WHAT I HAVE
LEARNED
A.
1. D 1. /
2. B 2. /
3. B 3. /
4. B 4. /
5. C 5. /
6. B 6. /
7. A 7. /
8. C 8. X
9. A 9. X
10. D 10. /
WHAT’S MORE WHAT’S NEW WHAT I KNOW
A. 1. ^ 1. D
1. EXCEL
2. > 2. B
2. PUBLISHER
3. & 3. D
4. / 3. POWER POINT
4. SHARE POINT 4. B
5. * 5. C
5. WORD
6. B
B. 1. Text entry 7. A
2. numeric data 8. C
3. formula 9. D
4. pie chart 10. B
5. bar graph
Answer Key
 18
SUBJECT 1 2 3 4 AVERAGE
English 86 88 83 85 85.5
Math 89 89 90 84 88
Science 90 90 86 86 88
Filipino 89 88 88 85 87.5
EPP 90 89 85 87 87.75
MAPEH 92 88 87 88 88.75
Total Average 89.33 88.67 86.5 85.33 87.58
19
References
Google.com
Technology and Livelihood Education 6
Learning and Living in the 21st Century

20
 DISCLAIMER
This Self-learning Module (SLM) was developed by DepEd SOCCSKSARGEN with
the primary objective of preparing for and addressing the new normal. Contents of this module
were based on DepEd’s Most Essential Learning Competencies (MELC). This is a
supplementary material to be used by all learners of Region XII in all public schools beginning
SY 2020-2021. The process of LR development was observed in the production of this
module. This is version 1.0. We highly encourage feedback, comments, and
recommendations.

For inquiries or feedback, please write or call:

Department of Education – SOCCSKSARGEN

Learning Resource Management System (LRMS)

Regional Center, Brgy. Carpenter Hill, City of Koronadal

Telefax No.: (083) 2288825/ (083) 2281893

Email Address: region12@deped.gov.ph

21