EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

Information and Communication Technology 4. User Participation

(ICT) ❖ owner of the website is not only one
who is able to put content
❖ deals with the use of different communication ❖ Others are able to place a content of
technologies such as mobile phones, their own by means of comment,
telephone, Internet, etc. to locate, save, send reviews, and evaluation.
and edit information. ❖ Some websites allow readers to
comment on an article, participate in a
CURRENT STATE OF ICT IN THE PHILIPPINES poll, or review a specific product (e.g.,
❖ “ICT Hub of Asia”
[Link], online stores).
❖ 106.8 cellphones per 100 Filipinos in the year
❖ E.g. Wikipedia
2012
5. Software as a Service
❖ ICT Industry shares 19.3% of the total ❖ user will subscribe to a software
employment population in 2010. ❖ cheaper option if you do not always
❖ “The Selfiest Cities around the World” need to use software. Software as a
❖ 1st: Pasig & Makati service allows you to “rent” a software
❖ 9th: Cebu City for a minimal fee.
6. Mass Participation
WEB 1.0 (Static Web) ❖ diverse information sharing through
❖ cannot be manipulated universal access
❖ When the World Wide Web was invented
(1989, Tim Berners-Lee) most web pages were WEB 3.0 (Semantic Web)
static ᅳ stationary or flat page in a sense that ❖ (2014 Gavin Wood)
the page is "as is" ❖ machine-operated based on user
❖ (also known as flat page or stationary page) ❖ Acts as a personal assistant
❖ led by the World Wide Web Consortium
WEB 2.0 (Dynamic Web) (W3C).
❖ (1999 Darcy DiNucci) ❖ have machines (or servers) understand the
❖ can be manipulated user’s preferences to be able to deliver web
❖ Evolution of WEB 1.0 by adding dynamic web content specifically targeting the user.
pages ᅳ the user is able to see a website ❖ E.g. Chatbot, ChtGPT, Artificial Intelligence
differently than others
❖ It allows user to interact Cloud Computing
❖ E.g. Social Media, eCommerce, Entertainment (baliktad yan)
SAAS sa baba, IAAS sa taas
Features of Web 2.0
1. Folksonomy
❖ categorize and classify or arrange
information using freely chosen
keywords (e.g., tagging).
❖ uses pound sign (#) also referred to as
a hashtag.
❖ First to hashtag: Twitter, 2009
2. Rich User Experience
❖ content is dynamic and is responsive
to user's input
❖ E.g. Search bar
3. Long Tail
❖ services are offered on demand
❖ time-based pricing is better than file-
size based pricing TRENDS IN ICT
1. Convergence
❖ E.g. Subscription Plans
❖ Technological convergence is the
synergy of technological

FIRST SEM ASPASIA 1 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

advancements to work on a similar 5. Paperless Society

goal or task. ❖ defined as a society in which
2. Social Media communication and record keeping
❖ Social media is a website, application, (written documents, letters, etc.) with
or online channels that enable web the use of paper is replaced by
users to create, co-create, discuss, electronic communication and
modify, and exchange user-generated storage.
content.
❖ Types of Social Media
a. Social Network ONLINE SAFETY
❖ allows you to connect ❖ refers to the practices and precautions that
with other people with should be observed when using the internet
the same background, to ensure that the users as well as their
interests, etc. computers and personal information are safe
b. Bookmarking Sites from crimes associated with using the
❖ allows you to store and internet.
manage links to ❖ Type of Information:
various websites and a. First name
resources. ❖ Chances are, a hacker already
c. Social News knows plenty of stuff about
❖ allow users to post you even if you only give out
their own news items your first name.
or links b. Last name
d. Media Sharing ❖ Having both your first and last
❖ allows you to upload is more risky.
and share media ❖ You will be vulnerable to being
content like image, searched for using search
video, music engines,
e. Microblogging c. Middle name
❖ short updates from the ❖ Sharing just your middle name
user is probably not the most risky
f. Blogs and Forums of these shared information,
❖ Allows users to post d. Current and previous school
their content ❖ Most people who steal
3. Mobile Technologies identities study their subject.
❖ The popularity of smartphones and e. Cell Phone number
tablets has taken a major rise over the ❖ should never be posted over
years. the Internet.
❖ Devices capable of doing tasks that f. Mothers’ and fathers name
were originally found in personal ❖ Risky, yet not as risky as
computers posting their full names,
❖ Kinds of Operating Systems: especially your mother's
a. IOS - Proprietary maiden name.
b. Android g. Siblings
c. Blackberry OS - Proprietary ❖ This is a huge risk, especially if
d. Symbian (Nokia) you have younger siblings.
e. WebOS (Smart TV)
h. Home address
f. Windows Mobile (Microsoft)
❖ It would be much easier for
4. Assistive Media
criminals to find you.
❖ Non-profit service designed to help
i. Home phone number
people who have visual/reading and
❖ Scams usually use this
hearing impairments
information to deceive you,
❖ 1996 David Erdody

FIRST SEM ASPASIA 2 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

j. Birthday 8. Do NOT turn off the firewall

❖ Having it in your profile makes ❖ A firewall is a grate line of defense
you vulnerable to identity against cyberattacks.
theft. 9. Keep up to date
❖ The best security updates
automatically to protect your
computer.
❖ Use the manufacturer’s latest security
patches to make regular updates.
10. Use your noggin
❖ Use your COMMON SENSE while
surfing the web

NETIQUETTE ONLINE THREATS

❖ network and etiquette. 1. Malware
❖ set of rules for behaving properly online. ❖ Malicious Software
❖ umbrella term that describes any
RA 8293 malicious program or code that is
❖ Intellectual Property code of the Philippines harmful to systems.
❖ Unauthorized use of copyrighted material ❖ Types of Malware:
such as text, photos, video, music a. VIRUS
❖ program designed to
INTERNET SAFETY TIPS replicate itself and
1. Know the Scams transfer from one
❖ Learn about the different kinds of
computer to another
scam and what you do to avoid them.
either through the
2. Think before you click
internet and local
❖ Think twice, trice and a zillion times
network or data
before you click any links or buttons
storage.
❖ Is it: T-True, H-Helpful, I-Inspiring, N-
❖ Needs to be triggered
Necessary, K-Kind
for it to work
3. Safety Peruse
❖ These sites may have an address that’s ❖ Brain : first virus in
very similar to a legitimate site, floppy disk (1986)
❖ the page can have misspellings, bad made by Basit and
grammar or low resolution images. Amjad Farooq Alvi
4. Shop Safely b. WORMS
❖ Don’t shop on a site unless it has the ❖ A malicious program
“https” and a padlock icon to the left that transfers from one
or right of the URL. computer to another
5. Use Strong password by any type of means.
❖ Use an extremely uncrackable one like ❖ Does not need to be
“9&4yiw2PYqz#: triggered
6. Protect your info, keep your guard up ❖ Love Bug/I LOVE YOU
❖ Backup all of your data on your Worm: first worm
computer, smartphone and table, made by a Filipino
theft or a crash. (Onel de Guzman)
7. Watch your wi-fi connectivity
❖ Protect your network by changing c. TROJAN
your router’s settings and making sure ❖ disguised as a useful
that you have the connection program but once
password-protected. downloaded or
installed,

FIRST SEM ASPASIA 3 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

d. SPYWARE g. Motion Pictures and Other

❖ A program that runs in Audiovisual Works
the background h. Sound Recordings
without you knowing it i. Compilations
❖ has the ability to ❖ three basic requirements that a work must
monitor what you are meet to be protected by copyright. The work
currently doing and must be:
typing through a. Original
keylogging. b. A work of authorship
e. ADWARE c. Fixed
❖ program designed to
send you 1. Original
advertisements, ❖ work must merely be independently
mostly as pop-ups. created.
2. Spam 2. A Work of Authorship
❖ Unwanted email mostly from bots or ❖ a work must be a product of creative
advertisers. expression that falls under a category
❖ can be used to send malware. of copyrightable subject matter.
3. Phishing 3. Fixed
❖ The goal is to acquire sensitive ❖ sufficiently permanent or stable to
personal information like passwords permit it to be perceived, reproduced,
and credit card details. or otherwise communicated for a
❖ click the link of the website from the period of more than transitory
email. duration.
4. Pharming
❖ online fraud that involves the use of Who is a copyright owner?
malicious code to direct victims to ❖ Everyone is a copyright owner.
spoofed websites in an attempt to
steal their credentials and data How long does copyright protection last?
❖ click the link of the website from the ❖ In the Philippines, copyrighted works last
search engine (Direct access to during the lifetime of the author plus 50 years
website). after the author’s death.
5. Vishing
❖ online fraud that involves the use of What are the penalties provided by Philippine law
voice calls, for copyright infringement?
❖ Voice over Internet Protocol (VoIP) ❖ Imprisonment of between 1 to 3 years and a
systems. fine of between 50,000 to 150,000 pesos for
the first offense.
COPYRIGHT ❖ Imprisonment of 3 years and 1 day to six years
❖ a type of intellectual property that protects plus a fine of between 150,000 to 500,000
original works of authorship as soon as an pesos for the second offense.
author fixes the work in a tangible form of ❖ Imprisonment of 6 years and 1 day to 9 years
expression. plus a fine ranging from 500,000 to 1,500,000
❖ Examples pesos for the third and subsequent offenses.
a. Inventions
b. Literary Works FAIR USE
c. Musical Works ❖ legal concept that allows the reproduction of
d. Dramatic Works copyrighted material for certain purposes
e. Pantomimes and Choreographic without obtaining permission and without
Works paying a fee or royalty.
f. Pictorial, Graphic, and Sculptural
Works

FIRST SEM ASPASIA 4 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

SEARCHING THE WEB

❖ websites used for retrieval of data, files, or
documents from data bases. Some search
engines we use today are:
a. Google
b. Yahoo!
c. Bing
d. Ask
e. Ecosia
❖ HTTP(S): Hypertext transfer protocol (secure)
❖ Only web 2-3 use Https while web 1 uses http

ANATOMY OF A URL
5. Port
❖ a number used to specify a connection
endpoint and to direct data to a
specific service.
❖ Https: 443
❖ Http: 80

6. Subdirectory
❖ also known as a subfolder — helps
people to understand which particular
section of a webpage they’re on.

1. Scheme
❖ (also called protocol) tells web servers
which protocol to use when it accesses 7. Path
a page on your website. ❖ specifies the location of the file or
resource that the user wants to access.

8. Query
2. Subdomain ❖ that a specific query is being
❖ URL indicates which particular page of performed and is used to precede a
your website the web browser should query string.
serve up. ❖ A query string specifies the
3. Second-Level Domain parameters of the data being asked
❖ (SLD) is the name of your website. It
from a website’s database. We’ll dig
helps people know they’re visiting a
into parameters next.
certain brand’s site.

4. Top-Level Domain 9. Parameters

❖ The top-level domain (TLD) specifies ❖ the values being queried during a
what type of entity your organization search. (+ or ? sign)
registers as on the internet. ❖ The parameter can be a number,
encrypted value, search term or other
data that can be found on the website.

FIRST SEM ASPASIA 5 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

words) must be cited in order to give

the author/creator credit for the work
and to allow readers to retrieve the
10. Fragments information to review it.
❖ optional component of URLs that are
typically placed at the end with a hash
(#).

ONLINE RESEARCH
❖ research method that involves the collection
of information from the internet.

SEARCH ENGINE
❖ Websites used for retrieval of data

TIPS IN CONDUCTING AN ONLINE RESEARCH

1. Have a question in mind
❖ Focus on a question you want
answered. If it is a series of questions,
start with one
❖ Never search everything in one go.
2. Narrow it down
❖ Search engines like Google, Bing, or
Yahoo use several filters to determine
the most appropriate result for you.
❖ Boolean operators:
➢ AND - 2 concepts together
➢ OR - 1 concept or another
WORD PROCESSOR
➢ NOT - filters out concept you
❖ a computer program or device that provides
don’t need
for input, editing, formatting and output of
❖ Asterisk/Star Symbol
text often with some additional features.
➢ find different forms of the
❖ Early word processors were stand-alone
same word. (e.g. Teen* ,
devices often on its function
Canad*)
❖ current word processors are word processor
❖ Quotation Mark
programs running on general purpose
➢ Group words together in your
computers.
search
3. Advanced Search
MAIL MERGE
❖ This will allow you to filter out
❖ used to create multiple documents at once.
information you do not need.
❖ These documents have identical layout,
4. Look for a credible source
formatting, text, and graphics
❖ The source should be relevant to your
❖ Only specific sections of each document varies
research
and is personalized.
❖ The author and publication should be
a trusted authority on the subject you
COMPONENTS OF MAIL MERGE
are researching.
1. LIST OR DATA FILE (MS EXCEL)
5. Give credit
❖ where the individual information or
❖ All materials that you have quoted
data that needs to be plugged in
(left in the author's original language)
(merged) to our form document is
or paraphrased (put into your own
placed and maintained.

FIRST SEM ASPASIA 6 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

2. FORM DOCUMENT (MS WORD) the excel file to be

❖ The document that contains the main merged.
body of the message we want to ii. Click Next: Write
convey or send. your letter to move
to Step 4.
STEPS IN CREATING A MAIL MERGE - Note: You will need an address list
1. Creating a list or data file (MS Excel) so Word can automatically place
a. Open MS Excel. Encode the data
each address into the document.
needed as header (Row 1) of the file.
The list can be in an existing file,
such as an Excel workbook, or you
can type a new address list from
within the Mail Merge Wizard.
g. Step 4 of 6: Write your
letter
i. Click More items
from the Mail Merge
task pane to insert
2. Creating a form document (MS Word)
a. Open MS Word. Click the Mailings tab. data into your
b. Click the Start Mail Merge command. document.
c. Select Step by Step Mail Merge Wizard ii. The placeholder of
and a Mail Merge task pane will appear More Items will
at the right side of the document. appear in the
document. After
placing these, you
may then start writing the
content of the letter.
iii. Click Next: Preview
your letter to move to
i. Six (6) main steps in guiding
Step 5.
you to complete a merge will
h. Step 5 of 6: Preview
be displayed at the bottom.
your letters
d. Select Document type
i. To view your
i. Select Use the current
merged data,
document (default).
click the
ii. Click Next: Select recipients to
Preview
move to Step 3.
Results
e. Step 2 of 6: Starting
button on
Document
the Mail
i. Select Use the
Merge task
current document
pane or on
(default).
the ribbon to
ii. Click Next: Select
replace the merge fields with
recipients to move
data from your recipient list.
to Step 3.
ii. Click Next: Complete the
f. Step 3 of 6: Select
Merge to move to Step 6.
Recipients
i. Step 6 of 6:
i. From the Mail
Complete the Merge
Merge task pane,
i. The last step
select Use an existing
in merging
list (default), then
document is
click Browse (select
Data Source). Locate

FIRST SEM ASPASIA 7 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

to print or edit the individual ❖ Syntax:

file. ➢ =COUNT(range reference)
❖ Example:
➢ =COUNT(A1:A4)

COUNTIF FUNCTIONS
❖ count cells that meet a single criteria.
ADVANCE AND COMPLEX CALCULATIONS IN EXCEL ❖ can be used to count cells with dates,
❖ Combination of more than 2 simple formulas numbers, and text that match specific criteria.
❖ One of the key features of excel is the ability to ❖ Supports logical operators and wildcard for
calculate complex formulas partial matching.
❖ Addition (+), subtraction (-), multiplication (*), ➢ >, <, <=, >=
division (/) ➢ *a, *a, *a*
❖ Syntax:
FUNCTIONS ➢ =COUNTIF(range, criteria)
❖ Predefined formula that performs calculations
using specific values in a particular order
❖ parts:

COUNTIFS
❖ count cells that meet a multiple criteria
BASIC FUNCTIONS ❖ can be used to count cells with dates,
1. SUM numbers, and text that match specific criteria.
❖ Add all the cells together and give you ❖ Syntax:
the total sum. ➢ =COUNTIFS (range1, criteria1, [range2],
❖ Syntax: [criteria2], ...)
➢ =SUM(range reference)
❖ Example: SUMIF
➢ =SUM(A1:A4) ❖ returns the sum of cells that meet a single
2. AVERAGE criteria.
❖ average of the selection you provide. ❖ Criteria can be applied to dates, numbers, and
❖ Syntax: text using logical operators and wildcards for
➢ =AVERAGE(range reference) partial matching.
❖ Example: ❖ Syntax:
➢ =AVERAGE(A1:A4) ➢ =SUMIF(range, criteria, sum_range)
3. MAX
❖ Returns the largest value from the SUMIFS
selection you provide. ❖ returns the sum of cells that meet multiple
❖ Syntax: criteria.
➢ =MAX(range reference) ❖ can be applied to dates, numbers, and text
❖ Example: using logical operators and wildcards for
➢ =MAX(A1:A4) partial matching.
4. MIN ❖ Syntax:
❖ Returns the smallest value from the ➢ =SUMIFS(sum_range, range1, criteria1,
selection you provide. [range2],[criteria2]. . . )
❖ Syntax:
➢ =MIN(range reference) IF
❖ Example: ❖ PerformS a logical test and returns one value
➢ =MIN(A1:A4) for a TRUE result, and another for a FALSE
5. COUNT result.
❖ how many cells have values in them. ❖ Syntax:

FIRST SEM ASPASIA 8 of 9

 EMPOWERMENT TECHNOLOGIES FIRST QTR

STEM | MONTE | SY 2024-2025

➢ =IF (logical_test, [value_if_true],

[value_if_false])

6 PRINCIPLES IN CREATING AN EFFECTIVE

POWERPOINT PRESENTATION

1. MINIMIZE
❖ Keep slide counts to a minimum to
maintain a clear message and to keep
the audience attentive
2. CLARITY
❖ Avoid being fancy by using a font style
that is easy
to read

3. SIMPLICITY
❖ Use bullets or short sentences
❖ Summarize the info on the screen to
have your audience focus on what the
speaker is saying
4. VISUALS
❖ Use graphics to help in your
presentation
5. CONSISTENCY
❖ Make your design uniform
❖ Avoid different font styles and
backgrounds
6. CONTRAST
❖ Use a light font on dark background
and vice versa

FIRST SEM ASPASIA 9 of 9