Philippine Christian University
Sampaloc 1, Dasmariñas City, Cavite 4114
SENIOR HIGH SCHOOL
S.Y. 2025-2026
MODULE IN EMPOWERMENT TECHNOLOGIES
QUARTER 1 – WEEK 2 (JUNE 30-JULY 4, 2025)
LESSON 3: ADVANCED SPREADSHEET SKILLS
Overview
In today’s globalized world, the world’s most valuable resources are data and information. With the aid of
correct and well-organized data, people and organizations make meaningful decisions. Conversely, having wrong
data or wrong information will lead to wrong decisions
Nowadays, data must be properly organized for us to get information when needed. Also, information must
be easily accessible. One of the most basic tools in organizing and analyzing data is spreadsheet software. This
lesson will focus on Google Sheets application, as it is one of the most widely used spreadsheet application in the
Philippines.
Course Learning Outcome
First Quarter
Apply advanced productivity tools, principles, and techniques to create and develop original or derivative
ICT content for use in specific professional tracks.
Lesson Objectives
At the end of this lesson, you are expected to:
1. creates an original or derivative ICT content to effectively communicate or present data or information
related to specific professional tracks,
2. identify the environment and functions of Google Sheet ,
3. evaluate the importance, features and benefits of using Google Sheet,
4. construct the basic formulas of Google Spreadsheet using computer and mobile device; and
5. uses common productivity tools effectively by maximizing advanced application techniques
Essential Question
How can Google Sheets be effectively applied to make it more convenient to compute and tally the
large data we have?
Test Yourself
1. What G Suite is commonly used for presenting data and tables?
a. Google Docs b. Google Sheet c. Google
2. What makes it operate is the values in a range of cells or a cell.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
a. functions b. formula c. numbers
3. Formula should be started in what sign?
a. = b. + c. ,
4. By clicking this part of Google Sheet, you can edit the wrong formulas or text, it is located at the center
upper part of Excel.
a. Zoom Tool b. Formula Bar c. Active Cell
5. What do you call the horizontal cells in Google Sheets?
a.
Columns
b. Rows
c. Active
cells
Study these
terms
G Suite - G
Suite
includes
Gmail,
Calendar,
Drive, Docs,
Sheets,
Slides, and
Sites
Google
workspace – includes those same features of G Suite but with Meet, Chat, and Jamboard. Cloud Storage - a
managed service for storing unstructured data. Store any amount of data and retrieve it as often as you like.
(https://cloud.google.com/storage)
Spreadsheets – an electronic document in which data is arranged in the rows and columns of a grid and can
be manipulated and used in calculations.
Data – facts and statistics collected for reference or analysis.
Lesson Proper
What is Google Sheets?
Google Sheets is a web-based application that enables users to create, update, and modify spreadsheets
and share the data online in real time. Users can upload spreadsheets directly from their computers or mobile
devices. Multiple users can modify a Google Sheets document in real time, with changes tracked for each individual
user and it saves every change automatically.
Google Sheets are automatically saved to Google Drive. When you create a new Google Sheets spreadsheet,
it is saved to your Google Drive account. This means you can access the spreadsheet from anywhere, on any device,
as long as you are signed in to your Google account.
Google Sheets features
Google Sheets includes the following core features:
● Spreadsheet editing and formatting. This includes operations and functions for data entry; data summary;
text translation; data import; data validation.
● Data visualization. Users can generate spreadsheet data for graphs, charts and other types of diagrams and
embed them in websites.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
● Offline editing. Even when not connected to the internet, Sheets can edit offline, and changes will update
once an internet connection is restored.
● Compatibility. Sheets documents are compatible with a variety of formats, including Excel (XLS), Apache
OpenOffice, PDF, Text, HTML and comma-separated values (CSV).
● Google product integration. Google Sheets can be integrated with other Google services. It is also
compatible with Microsoft files and shares many of the same keyboard shortcuts.
●
Collaboration features. Emails can be sent when other collaborators make comments or changes to the
shared spreadsheet, and users can view the version history.
● Security. Users can manage permissions for editing, downloading, copying or printing for specific
collaborators through individual-, group- or domain-level access.
Environment of
Google Sheet
(computer
device)
Ribbon
Sheet
THE COMMON PARTS OF GOOGLE SHEET
● Ribbon - provides shortcuts to Google Sheets commands.
● Sheet - is a set of rows and columns.
● Spreadsheet Title – This is the name of your spreadsheet.
● Menu
o File – Options about your whole spreadsheet.
o Edit – Options to edit the data.
o View – Options mainly relating to how your sheet
o Insert – This allows you to add graphics, images, tables, sheet, row and columns
o Format – options relating to your data formats.
o Data- options to customize your data and also for other functions of Spreadsheet. o
Tools – This contains a few useful tools, such as the spellchecker, and the ‘research’ tool o
Help – it helps you to explore more about the advanced features of Spreadsheet.
● Toolbar - enables quick access to the most common settings, such as number
formats and cell borders.
● Commands - are the buttons that you use to do actions.
● Options – consist of icon where you can share to other people using their google account.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
● Cells – This is the cell that you are using. You can only use one cell at a time. The contents will show in the
Formula Bar.
● Columns – The letters help you know where you are in the spreadsheet horizontally
● Rows - The numbers help you know where you are in the spreadsheet vertically.
● Name Box - A box that displays the cell reference of the active cell
● Formula Bar - A bar that displays the value or formula entered in the active cell
●
Context Menu - use this to manually display the shortcut menu at a specific location and bind it with a
specific control.
How to access Google Sheet using computer device
1: Sign In to Google
Sign in to your Google account. Create one If you
don't have a Google account yet. You can access
Google Slides by clicking on (Google Apps
Menu) or can be directly going to Google Sheet
https://docs.google.com/spreadsheets/u/0/
2: Create a New Spreadsheet
Click on the Blank spreadsheet or choose
from available templates
3: Start
You can click any cell to input the data.
How to access Google Sheet using mobile device
1. Download and install Google Sheets on
your mobile device for easy access.
2. Click the + icon to create a new sheet.
3. To input the data, click the cell.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
4. To change the format of your data,
click icon. In the format section, you
can choose your font style, font size,
color of your text and cell, warp your
text and other functions related to your
data formatting.
5. Click the icon to insert an image
from your google drive or mobile device,
charts, and link.
6. On this icon you can see other
features of Google Sheet such as Title,
Data Validation, Share & Export, Add-
ons, you can also change the Theme
(light or dark).
To share and save your file, click “Share
& Export.
7. To download your file on your device,
go back to Homepage of Google Sheet
and look the file you want to download,
then click the icon of your file and click
Download.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
Formula- is an expression that operates on values in a range of cells or a cell.
Function - is a predefined formula that performs calculations using specific values in a particular order. **Formula
and Functions can be pre-set, making it possible for your spreadsheet to automatically calculate and update results
based on the data that you input.
What are the Elements of Formula and Function?
1.
The =
sign,
which indicates that what follows is a formula.
2. The operator or function.
3. Cell Reference or Range where the counting will take place, or the cells involved.
4. Criteria – the label or value that determines if it is to be counted.
- A (“”) quotation mark
Operators tell the formula of the operation to be performed. Google Sheet uses four types of operators and some
basic functions.
a. Arithmetic Operators
Operator Operation Performed Sample Formula Result
^ Exponentiation =A1^3 Value in Cell A1
raised to third power
+ Addition =A1+A2 Add the total
values in Cell A1
and A2
- Subtraction =A2-A1 Subtracts the
values in Cell A2-
A1
* Multiplication =A1*3 Multiplies the
values of cell A3
to 3
/ Division =A5/2 Divides the value
of Cell A5 to 2
Combination =(A1+A2+A3)/3 Computes for the
average of the
values in cell A1 to
A3
b. Text Operator
Text Operator Meaning Example Result
& (ampersand) Connects two values =” South ”&”Square” SouthSquare
to produce one
continuous text value
UPPER Convert text to all
capital letters
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
LOWER converts a text
string to all
lowercase letters
c. Comparative Operators
Comparison Operator Meaning Example
= Equal =A1=B1
> Greater than =A1>B1
< Less than =A1<B1
>= Greater than equal =A1=D1
<= Less than equal =D1<=B1
<> Not equal =D1<>A1
d.
Reference Operators
Reference Operators Meaning Example
: (colon) Range operator, which produces one =B1:B15
reference to all the cells between two
references, including the two
references.
, (comma) Union operator, which combines =SUM (A1:A7, C1:C7)
multiple reference into one
(space) Interact operator, which returns a =B7:D7 C6:C8
reference to the cells common to
the range in the formula
e. Common Functions
Function Meaning Syntax Sample
MAX Determines the highest cell =MAX (range) =MAX(A1:A10)
value included in the cell
range
MIN Determines the lowest cell =MIN (range) =MIN(A1:A10)
value included in the cell
range
SUM Sum numerical data in any number =SUM (sum_range) =SUM(A1:A10)
of columns or rows by selecting or
typing it.
AVERAGE Determines the average of the =AVERAGE =AVERAGE(A1:A10)
values included in the cell range. It (average_range)
calculates the sum of the cells and
then divides that value by the
number of cells in the argument
COUNT Counts the number of cells with =COUNT(range) =COUNT(A1:A10)
numerical data in the argument.
This function is useful for quickly
counting items in a cell range
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
SUMIF Used to compute the sum of a range UMIF(range, =SUMIF(A1:A10,
if a certain condition is met criterion, ">20", B1:B10)
[sum_range])
AVERAGEIF Used to compute the average AVERAGEIF(criteri AVERAGEIF(A1:A1
of a range if a certain condition a_ range, 0, ">20", B1:B10)
is met criterion,
[average_range])
COUNTIF Count cells based on one criterion COUNTIF(range, COUNTIF(A1:A10,
criterion) ">20")
IF Used to achieve a particular value if IF(logical_expressi IF(A2 = "PASSED",
the condition has been satisfied or on , value_if_true, "A2 PASSED", "A2
TRUE, or if the condition has not value_if_false) is not PASSED")
been satisfied or FALSE.
AND Returns true if all of the provided AND(logical_expre AND(A1=PASSED
arguments are logically true, and ssi on1, A2=PASSED)
false if any of the provided [logical_express
arguments are logically false. ion2, …])
CONCATENATE Combines two or more text strings. CONCATENATE(st CONCATENATE("hel
rin g1, [string2, lo" , "goodbye")
…])
VLOOKUP Searches down the first column of VLOOKUP(search_ VLOOKUP(10003,
a range for a key and returns the ke y, range, index, A2:B26, 2, FALSE)
value of a specified cell in the row [is_s orted])
found.
VLOOKUP PARAMETERS
search_key The value to search for.
range The range to consider for the search. The first column
in the range is searched for the key specified in
search_key.
index The column index of the value to be returned, where
the first column in range is numbered 1.
is_sorted - [optional] Indicates whether the column to be searched (the first
column of the specified range) is sorted, in which case
the closest match for search_key will be returned.
Conditional Formatting
This feature enables users to emphasize certain cells with the formatting they want.
Steps in adding Conditional Formatting
1. Select Cell Range.
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
2. In the Format Tab, click Conditional Formatting.
3. Hover on the right panel to modify the
Conditional format rules.
4. Click Done once you’re done.
Summary
Using Google Sheet, we can work anywhere in collaboration with other people in real time even if
we use different devices because we can access it on our computer device through browser and mobile
device through mobile applications.
Google Sheet has two main parts which are the Ribbon and Sheet.
Ribbon Sheet
●Spreadsheet title ●Cells
● Menu Bar ●Sheet Tab
●Commands ●Column
●Toolbar ●Rows
●Options ●Name box
●Context Menu
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
Google Sheets use four types of operators which are Arithmetic Operators, Text Operators,
Comparative Operators and Reference Operators. Also, we can use basic Functions such as MAX, MIN,
SUM, AVERAGE, COUNT, SUMIF, AVERAGEIF and COUNTIF, IF, AND, CONCATENATE AND VLOOKUP. To use
the Formulas, it should always start with = sign.
Assessment: Performance Task 3
GROUP ACTIVITY – ADVANCED SPREADSHEET SKILLS
Learning Resources
Rex Bookstore(2022). Empowerment Technologies: Innovative Training Works, Inc.
1977 C.M Recto Avenue, Manila, Philippines (pg.49-73)
Sibs Publishing House(2023). Science in Today’s World for Senior High School: Empowerment
Technologies. Phoenix Bldg. 927 Quezon Ave., Quezon City. (pg.18-21)
Online Reference:
Cloud Storage. (n.d.). Google Cloud. https://cloud.google.com/storage\
Chai, W. (2021, May 28). Google Sheets. WhatIs. https://www.techtarget.com/whatis/definition/Google
Spreadsheets
LiveFlow. (2024, January 25). How to Save Google Sheets in Google Drive. LiveFlow.
https://www.liveflow.io/product-guides/how-to-save-google-sheets-in-google
drive#:~:text=Yes%2C%20by%20default%2C%20Google%20Sheets,to%20your%20Google%20Drive
%20account. Steinfurth, A. (2023, October 21). The Parts of a Spreadsheet – Google Sheets [Video]. Sheets
Help. https://sheetshelp.com/spreadsheet-parts/
W3Schools.com. (n.d.). https://www.w3schools.com/googlesheets/google_sheets_overview.php
Supplemental Readings and Materials
For further examples and a deeper understanding of the lesson, please click the link below. It will
take you to a video that shows additional lesson examples.
Personal Finance with Leila - Debt Over It. (2021, March 26). How to build your own budget in Google
Sheets | GOOGLE SHEETS DEMO/TUTORIAL [Video]. YouTube.
https://www.youtube.com/watch?v=J8EzNIfki1U
W3Schools.com. (n.d.). https://www.w3schools.com/googlesheets/index.php
Prepared by: Checked by: Approved by:
CHABELITA KAREN E. CUEVAS PAMELA R. DOLORES 11 ANDREA NICOLE S. CURA
ANDREA NICOLE S. CURA JUSTINE JHOI N. FANER Subject Lead Teacher – Computer 12
SHARALYN B. DELA CERNA JOHANNA I. PUZON MARIA BEATRIZ B. SICO,MM
Subject Lead Teacher – Computer Principal
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
KEVIN I. GENEVEO
MARK GERALD S. LOPEZ
JENNIFER M. MIASCO
REGINE C. VELANDO
ANGELA FRANCES C. VELASCO
Subject Teachers
Disclaimer: This module is adapted and modified from the source materials listed in the references list. This is the exclusive property of
Philippine Christian University-Dasmariñas SHS and is provided only to enrolled students for their educational use. This module is provided for
free by the school through softcopy and printed media. Reproduction of this module without official permission is prohibited.
