Trends and Issues in ICT Overview
Trends and Issues in ICT Overview
: 1 Page 1 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Lesson: 1
Learning Module 1: Introduction to Information and Communication Technology
Content Standards:
The learners demonstrate an understanding of ICT in the context of global communication for specific
professional track.
Performance Standard:
The learners shall be able to:
at the end of the 2-week period independently compose an insightful reflection paper on the nature of ICT in
the context of their lives, society, and professional tracks (Arts, TechVoc, Sports, Academic)
Learning Competencies:
The learners compare and contrast the nuances of varied online platforms, sites, and content to achieve
specific class objectives best or address situational challenges
Overview
Good day, student! Let's start our day with some fun activities. You can exchange take turns on asking the
question with your classmates online to make it more interesting. Answer the following honestly.
1. How many times have you checked your phone this morning?
2. How many status updates have you posted on Facebook or Twitter today?
3. Did you use the Internet for an hour after you woke up this morning?
4. Do you follow a celebrity via his/her social media account?
Now, based on the questions asked by your classmates, do you think you are a Digital Native?
If you happen to be guilty as charged in most of these questions, chances are you. You are a digital
native. And chances are formed the moment you were born. You were surrounded by technology; you are
surrounded by ICT.
Discussion
As the popular saying goes, "Love makes the world go round." But before you start looking for
someone to fall in love with, you could argue on how the internet has made the world's ho round for decades.
Likewise, in motivation activity, the Internet has made your world go round. In this lesson, we will understand
how Information and Communication technologies have improved our lives in such a short period of time.
In data gathered by the Information Technology and Business Processing Association of the Philippines
(IBPAP) in 2016, the IT industry size is worth $22.9 billion.
Guide Questions:
1. What are the different ways for customers and/or suppliers to contact you?
____________________________________________________________
____________________________________________________________
____________________________________________________________
2. How often do you use a phone or cellular phone for business? Estimated
time only.
____________________________________________________________
____________________________________________________________
____________________________________________________________
3. Does your establishment have Internet connection? If yes, what is its
purpose? If no, would you consider having one the future? Why or why
not?
____________________________________________________________
____________________________________________________________
____________________________________________________________
4. Does your business have a website? If yes, how does it help the company?
If no would you consider having one the future? Why or why not?
____________________________________________________________
____________________________________________________________
____________________________________________________________
5. (If Applicable) would you consider giving free Wi-Fi access in the future?
If you already have it, does it help boost sales?
____________________________________________________________
____________________________________________________________
____________________________________________________________
Share the result with your classmates either in your messenger (group chat or private message) and
notice the trend on most of the reports presented.
To add to these statistics, Time Magazine's "The selfies Cities around the World" of 2013 places two
cities from the Philippines in the top 1 and top 10 spots. The study was conducted using the data from
Instagram, a popular photo-sharing application. With these numbers, there is no doubt that the Philippines is
one of the countries that benefit most of ICT.
Web 2.0 is a term coined by Darcy DiNucci, an information architecture consultant, in January 1999. In
her titled, "Fragment Future," she wrote, "The Web we know now, which loads into a browser window in
essentially static screenfuls, is only an embryo of the Web to come. The first glimmerings of web 2.0 are
beginning to appear, and we are just starting to see how the embryo might develop."
Web 2.0 is the evolution of Web 1.0 by adding dynamic web pages where the user can see a website
differently than others. Examples of Web 2.0 include social networking sites, blogs, wikis, video sharing sites,
hosted services, and web applications. Web 2.0 allows users to interact with the page instead of just reading a
©All Rights Reserved
Issue No.: 1 Page 5 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
page. The user may be able to comment or create a user account. Web 2.0 also
(EMPOWRMENT allows users to use web
TECHNOLOGY)
Revision No.: Effectivity Date:
browsers instead of just using their operating system. Browsers can now be used for
STUDENT LEARNING their user interface,
MODULE
application software (or web
1 applications), and
August 10, 2020 even for file storage.
Reviewed by:
The most website we
Approved by:
visit today is Web
2.0. _________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
3. User Participation – the owner of the website is not the only one who can put content. Others can
place the content of their own by means of comments, reviews, and evaluation. Some websites allow
readers to comment on an article, participate in a poll, or review a specific product. (e.g.,
[Link], online stores.)
4. Long Tail – services that are offered on-demand rather than on a one-time purchase. In some
instances, time-based pricing is better than file-sized pricing or vice-versa. This is synonyms to
subscribing to a data plan that charges you for the amount of time you spent on the Internet, or a data
plan that charges you for the amount of bandwidth you used.
5. Software as a Service – users will subscribe to software only when needed rather than purchasing
them. This is a cheaper option if you do not always need to use the software. Software as a service
allows you to "rent" software for a minimal fee.
6. Mass Participation– diverse information sharing through universal web access. Since most users can
use the Internet, Web 2.0's content is based on people from various cultures.
3. Vastness. The World Wide Web already contains billions of web pages.
4. Vagueness. Certain words are imprecise. The words "old" and "small" would depend on the user.
5. Logic. Since machines use logic, there are certain limitations for a computer to be able to predict
what the user is referring to at a given time.
Trends in ICT
As the world of ICT continues to grow, the industry has focused on several innovations.
These innovations cater to the needs of the people that benefit most out of ICT. Whether it is for business
or personal use, these trends are the current front runners in the innovation of ICT.
1. Convergence- Technological convergence is the synergy of technological advancements to work on a
similar goal or task. Convergence is using several technologies to accomplish a task conveniently.
2. Social Media- is a website, application, or online channel that enables web users to create, co-create,
discuss, modify, and exchange user-generated content.
Six types of Social Media
a. Social Networks. These are sites that allow you to connect with other people with the same
interests or background.
f. Blogs and Forums. These websites allow users to post their content. Other users can
comment on the said topic. There are several free blogging platforms like Blogger,
WordPress, and Tumblr. On the other hand, forums are typically part of a certain website
or web service.
g. Mobile Technologies
The popularity of smartphones and tablets has taken a major rise over the years. Several of
these devices are capable of using high-speed Internet. Today, the latest mobile devices use 4G
Networking (LTE), which is currently the fastest mobile network.
Mobile devices use different operating systems:
a. iOS –used in Apple devices such as the iPhone and iPad.
b. Android– an open-source operating system developed by Google. Being open-source means
several mobile phone companies use this OS for free.
c. Blackberry OS–used in Blackberry devices.
d. Windows Phone OS – a closed source and proprietary operating system developed by
Microsoft®.
e. Symbian – the original smartphone OS; used by Nokia devices.
©All Rights Reserved
Issue No.: 1 Page 8 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
f. WebOS – originally used for smartphones; now used for smart TVs.
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
g. Windows Mobile– developed by Microsoft for smartphones and pocket PCs.
1 August 10, 2020 Reviewed by: Approved by:
h. ASSISTIVE MEDIA _________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
Assistive Media is a nonprofit service designedQMR
to help President
people who have visual and reading
impairments. A database audio recording is used to read to the user.
Assistive technology is an umbrella term that includes assistive, adaptive, and rehabilitative
devices for people with disabilities and also includes the process used in selecting, locating, and using
them.
Assistive technology promotes greater independence by enabling people to perform tasks that
they were formerly unable to accomplish or had great difficulty accomplishing, by providing
enhancements to, or changing methods of interacting with, the technology needed to accomplish such
tasks.
Checkpoint
Look for 10 websites and classify them as static or dynamic. What makes each website static or dynamic? Use
the table below for your answers.
Skill Exploration 1.2. Identifying the Correct Web Platform for Social Change
1. Identify a problem in your community (e.g., littering, garbage disposal, blocked drainage, etc.)
2. Imagine that you are to create a website to persuade both community leaders and members to solve
this problem.
3. Fill out the forms below. You may refer to the sample provided after the form.
1. Why do you think microblogging platforms have become popular when regular blogging platforms
already exist?
2. What do you think of Web 3.0? Do you think it will be realized someday in the future?
Key to Correction
Community Problem: Severe flooding during rainy days due to blocked drainages
Vicinity: Lapiz St., Oleander Village, Brgy. Pulo, Quezon City_______________
Campaign Name: Anti-Flooding Movement______________________________
Type of Social Media Used: Blogging___________________________________
Website Used: Wordpress_____________________________________________
It will contain pictures of the flood areas during rainy days. It will also contain
pictures of the drainages that are blocked with garbage. I also plan to update it every
once in a while. Anyone who views the site will be able to comment on these updates
People in my community are avid readers of blogs. Most of them follow several
blogs that concern the community.
Wordpress, unlike other blogging platforms, has a more “serious feel” to it. It also
contains professional-looking templates that will fit the serious tone of my campaign.
Category 3 2 1
Assessment
Research on one momentous event in Philippine History wherein ICT played a huge role in making it a
success. Cut and stick on the space provided.
Content Standards:
The learners demonstrate an understanding of:
ICT in the context of global communication for specific professional track.
Performance Standard:
The learners shall be able to:
at the end of the 2-week period independently compose an insightful reflection paper on the nature of ICT in
the context of their lives, society, and professional tracks (Arts, TechVoc, Sports, Academic)
Learning Competencies:
Apply online safety, security, ethics, and etiquette standards and practice in the use of ICTs as it would relate
to their specific professional tracks.
Use the Internet as a tool for credible research and information gathering to best achieve specific class
objectives or address situational
Overview
Good day, student! Most of us use the Internet every day. Sometimes, we do not pay attention to how much
information we share online. Below is a questionnaire about how much information you have shared so far.
Put a checkmark under Shared or Not Shared.
How safe are you?
1. First name
2. Last name
3. Middle name
5. Cellphone number
8. Address
10. Birthday
How many checks did you have for Shared? You probably answered Shared in the first two items. If that is the
case, try using a search engine like Google TM, then type your first and last name. Did you get a link to your
profile page? Try switching to image search. Did your pictures appear? If you have a unique name, chances
are, it did. Do not feel bad if it did not appear, though; in fact, it is probably for your best interest not to have
pictures of yourself in a search engine.
So how did these things happen? How can search engines locate you? Is there any danger of being
found by search engines?
Discussion
How many hours do you spend on the Internet per day? Can you live without the Internet for a week?
How many aspects of your life depend on the Internet? How many times have you complained about your
Internet connection speed?
As teenagers, you are all exposed to many things powered by the Internet. Whether it is socializing,
playing games, reading the sports news, shopping, etc., the Internet has given you one of the most powerful
tools that your parents, during their teenage years, did not have. Because of this, do you think that it is also
important to wield this powerful tool properly? Without proper training, a swordsman can easily injure himself
when wielding a sword; the same could be said for you whenever you use the Internet.
Netiquette -is network etiquette, the do and don'ts of online communication.
1. First Name There is a risk in sharing your first name; Chances are, a hacker may already know
plenty of stuff about you even if you only give out your first name.
2. Last Name If sharing your first name is a small risk, having both your first and last is riskier.
Matching a name with a face is some modus to several cybercrimes' like identity theft
3. Middle Name Sharing your middle name is probably not the riskiest of this shared information, but
sharing your full name would be.
[Link] and previous Most People who steal identities study their subjects. They can use this information
School/s for verification purposes
5. Your Cellphone Your cell phone number should never be posted over the internet.
Number
6. The name of yourRisky, yet not as risky as posting their full names, especially your mother's maiden
mother and father name. In fact, you may have already encountered many websites that require your
mother's maiden name as an answer to a secret question whenever you lose your
password.
7. The name of yourDisclosing, this is a huge risk. Strangers may pretend or use their identity to dupe you.
siblings
9. Your home phoneThis shared information is riskier than sharing your personal phone number. Scams
number usually used this information to deceive you. One of which is when a stranger
pretends to know your parents or pretends to be you
10. Your CellphoneLetting people know your birthday is probably a must if you want to get as many gifts
Number as possible. But having it in your profile makes you vulnerable to identity theft.
Let us go back to the "How Safe Are You?" test. Let us visit each item and see how risky it is to share
personal information.
The Internet is defined as the information superhighway. This means that anyone has access to this
highway, can place information, and can grab the information. Any information, even things that you have set
Most people would dispute that there is no such thing as private over the internet, and they may be
right. Some hackers can find a backdoor even if your profile is already set on private. You have no control over
whoever is looking at your friend's screen whenever they open your profile or chat with you. You have no
control over people getting access to your friend's account and seeing your stuff.
2. SPAM
Refers to the transmission of unsolicited messages from
various origins using electric messaging systems
3. PHISHING
Its goal is to acquire sensitive personal
information like passwords and credit
card details. This is done by sending you
an email that will direct the user to visit a
website and be asked to update his/her
username, password, credit card, or
personal information.
Before you post something on the web, ask these questions to yourself: Would you
want your parents or grandparents to see it? Would you want your future boss to
see it? Once you post something on the web, you have no control who can see
your post.
Your friends depend on you to protect their reputation online. Talk to your
friends about this serious responsibility.
Set your post to “private”. In this way, search engine where not be able to scan
that post.
Avoid using names. Names are easy for search engines to scan.
If you feel that a post can affect you or other’s reputation, ask the one who
posted it to pull it down or report it as inappropriate.
Copyright Infringement
If you create something--- an idea, an invention, a form of literary work, or research, you have the right as to
how others should use it. This is called intellectual property. In other words, copyright law includes your rights
over your work, and anyone who uses it without your consent is punishable by law. Try grabbing any book the
browse its first few pages, and you will find a page with a disclaimer with the words: "No part of this book may
be copied, reproduces…" that is a copyright page.
As a responsible user of the Internet, you have to consider that not everything out there is free for you
to use, just like your own, contents that you see from websites have their respective copyrights. There are
several instances where employees or business owners face copyright infringement and are sentenced to a
huge fine due to reckless copying of materials.
2. Be responsible. Even if a material does not say that it is copyrighted, it is not a valid defense against
copyright. Be responsible enough to know if something has copyright.
3. Be Creative. Ask yourself whether what you are making is something that came from your work or
something made out of somebody else's creativity. It is important to add your creative genius in
everything that will be credited to you.
4. Know the law. There are some limitations to copyright laws. For instance, in the Philippines, copyrights
only last a lifetime (of the author) plus 50 years. There are also provisions for "fair use," which means
that intellectual property may be used without consent as long as it is used in commentaries, criticism,
search engines, parodies, news reports, research, library archiving, teaching, and education. If you
have doubts that what you are doing does not fall under the policy of fair use, seek permission first.
Another misconception is that fan-fiction is not copyright infringement. In reality, it is, and some copyright
holders ignore them, but they can opt to use their rights.
Reference
Checkpoint
2. How would you feel if someone posted something embarrassing about you? What would you do?
Assessment
Take a Challenge!
1. Together with your group from the cybercrime reporting, create campaign materials promoting "think
Before You Click." It could be in the form of small posters posted along the hallway or bulletin boards as
approved by the school. This campaign is an awareness program for the younger batches of your school.
Send your output on my account.
2. With the same group, survey 15 people who can use email. They must fit the following category:
a. Student;
b. Teacher;
c. Non-teaching staff;
d. Working young professionals (working, ages 20-29)
e. Working professionals (ages 30 and up)
As for them, the following questions and tally their answers.
Lesson: 3
Learning Module 3: Advanced Word Processing Skills
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
Performance Standard:
The learners shall be able to at the end of the 2-week period independently apply advanced productivity tools
to create or develop ICT content for use in specific professional tracks
These may be in the form of, but not limited to:
1. Calculating spreadsheet of athletic statistics (Sports)
2. The layout of the catalog of creative works (Arts)
3. Materials/ ingredients projections for batches of baked goods (Tech - Voc)
4. Letterhead/ business card design (Business/ Academic)
Learning Competencies:
The learners:
1. uses common productivity tools effectively by maximizing advanced application techniques.
2. Creates an original or derivative ICT content to effectively communicate or present data or information
related to specific professional tracks.
Specific Learning Outcomes:
Upon completion of this module, you must have:
1. used some advanced capabilities of Microsoft Word commonly used to increase productivity and
efficiency;
2. effectively used these features to help improve the productivity of an organization through
maximizing the potential of Microsoft Word;
Overview
2. Give an example of documents that you can personalize and send or distribute.
Scenario 2: you are making a report on the positive effects of using solar energy to the environment. To make
your report more appealing, you thought of putting a picture of solar panel into your report. You also
considered presenting graphical data on the trends of worldwide initiatives on the use of solar energy.
1. Describe briefly how you can insert pictures or images in a Word Document.
Discussion
In the professional world, sending out information to convey important information is vital. Because of
ICT, things are now sent much faster than the traditional newsletter or postal mail. You can now use the
Internet to send out the information you need to share. What if we could still do things much faster-an
automated way of creating ad sending uniform letters with different recipients/ would that not be more
convenient?
Let us assume this is the mailer that you would want to send:
<<Name>>
<<Company>>
<<Address Line 1>>
Dear <<Title>>,
Included in this promo kit are the mechanics of our promo and
the catalog from where you can see and choose from our
exciting new products.
1. Form Document
The sample letter above is called the form document – the first component of the mail merged
document. It is generally the document that contains the main body of the message we want to convey or
On a printed standard form, this will be the underlined spaces that you will see and use as a guide to
where you need to write the information that you need to fill out. In its simplest form, a form document is s
"form" that needs to be filled out with individual information. A common example of a form document is the
regular tax form or application form. There is also a form letter, which is exactly like the one in our example
above.
Label Generation
Included in the mail merge feature on Microsoft Word is the Label Generator. It just makes sense that after
you print out your form letters, you will need to send it to individual recipients in an envelope with the matching
address printed directly on the envelope or on a mailing label to stick on. By using virtually, the same process
as a standard mail merge, Microsoft World will print individual addresses to a standard form that is already
pre-formatted. Simply put, it creates a blank form document that simulated either a blank label or envelope of
pre-defined size and will use the data file that you have selected to print the information, typically individual
addresses. So even in generating labels, the two essential components of creating a merged document are
present: the form document and the data file. Only in this case, you do not need to type or create the form
document yourself because it is already created and pre-formatted in Microsoft Word. All you need to do is
select the correct or appropriate size for the label or envelope and select the data file that contains the
addresses (data) to be printed. You can also preview your merged labels before printing if you want to.
Now that we have learned the components needed to accomplish a successful mail merge let us put
theory into practice. Take a look at the steps in creating a simple mail merge document.
Exchanging names and addresses with your classmates could be a good idea to build your list
quickly.
1. Open Microsoft Word and start a new blank document. You can use the keyboard shortcut Ctrl+N
after Microsoft Word has been loaded or opened.
2. On the Mailings tab, from the Start Mail Merge group, choose Start Mail Merge > Letters.
6. On the Mailings tab, go to the Start Mail Merge group and choose Select Recipients > Type a New
List.
7. Click the Customize Columns button on the dialog box to customize the address list.
8. Select a field that you do not need then click the Delete button. A confirmation dialog box appears.
9. Click Yes in the confirmation dialog box. The dialog box closes, and the unnecessary field disappears.
10. Repeat steps 8 and 9 for each field you do not need. After removing the excess fields, the next step is
to add the fields you need.
11. To add a field that you need in your document, click the Add button.
12. Type the field name on the prompt inside a small Add Field dialog box and click the OK button.
13. Repeat steps 11 and 12 for each new field you need in your main document.
14. Click the OK button on the Customize Address List dialog box to confirm your changes.
15. The New Address List dialog box will appear again, ready for you to type in your data.
16. Type the individual data from your list corresponding to Name, Company, Address Line 1, Address
Line 2, Address Line 3, and Title.
17. Press the Tab key each time to enter the next field.
18. To add a new record, press the Tab key after inputting the last field.
When you press the Tab key on the last field in a record, a new record is automatically created and added
on the next line.
19. Repeat steps 16 through 18 until you enter all the records you want.
Once you are done typing your data, click the OK button on the Add New List dialog box to save your
data. A special Save Address List dialog box pops up, allowing you to save the recipient list.
20. Type a name for the address list. Name it "Client List."
21. Click the Save button. You should be back to your main document after.
22. Select or highlight a field placeholder (ALL CAPS) in the main document.
through email.
28. Or you may want to choose Preview Results to check your work before you send it
Arnold Reyes
ABC Inc.
23 Sierra St.
Alabang
Muntinlupa City
Dear Sir,
We would like to announce and invite you to avail of our 3rd quarter promo, for which you are
qualified! Being one of our loyal customers, we would like to thank you for trusting and carrying our
product line in your store.
Included in this promo kit are the mechanics of our promo and the catalog from where you can see
and choose from our exciting new products.
Please do not hesitate to contact us should you have further inquiries regarding the details of the
promo or about any of the new products in our catalog. We look forward to doing more business
with you
Integrating or inserting pictures in your document is fun, and it improves the impression of your
document. A common use of inserting a picture on a document is when you are creating your resume. Though
seemingly simple to do, your knowledge of the different kinds of materials that you can insert or integrate into
a Word document and its characteristics can help you create a more efficient, richer document not only in
content but also in physical form. A better understanding of the physical form of your document, as well as the
different materials you integrate into it, would allow you to be more efficient and versatile in using Microsoft
Word.
Let us consider the interesting aspects of inserting or integrating images and other external materials, which is
categorized as an advanced feature.
Kind of Materials
There are various kinds of materials. Microsoft Word is capable of Integrating to make your documents richer,
more impressive, and more informative.
b. .GIF. This stands for Graphics Interchange Format. This type of image file is capable of
displaying transparencies.
c. .PNG. This is pronounced as "ping." It stands for Portable Network Graphics. It was built
around the capabilities of GIFs.
2. Clip Art. This generally [Link] type. Clips arts are line art drawings or images used as a generic
representation for ideas and objects that can be integrated into a word document. Microsoft Word has
a library of clip arts that is built-in or can be downloaded and used freely. There are still other clip arts
that you can either purchase or free download and use that come from third-party providers.
3. Shapes. These are printable objects or materials that you can integrate into your document to
enhance its appearance or to allow you to have some tools used for composing and representing
ideas or messages. If you are designing the layout for posters or other graphic materials for
advertising, you might find this useful.
4. Smart Art. Generally, these are predefined sets of different shapes grouped to form ideas that are
organizational or structural. If you want to graphically represent an organization, process,
relationships, or flow for infographic documents, then you will find this easy and handy to use.
5. Chart. It allows you to represent data characteristics and trends in your Word Documents and is quite
useful in preparing reports that correlate and present data in a graphical manner. You can create
charts that can be integrated into your document either directly in Microsoft Word or imported from
external files like Microsoft Excel.
6. Screenshot. Sometimes, creating reports or manuals for training or procedures will require the
integration of a more realistic image of what you are discussing in your report or manual. Nothing can
get you a more realistic image than a screenshot. Microsoft Word even provides a snipping tool for
1. In-Line with Text. It is the default setting for images that are inserted or integrated into your document.
It creates your document. It treats your image as a text font with the bottom side aligned with the text
line. This setting is usually used when you need to place your image at the beginning of a paragraph
3. Tight. It is almost similar to the square setting; here, the text hugs or conforms to the general shape of
the image. It allows you to get a more creative effect on your document. This setting is mostly
achieved if you are using an image that supports transparency like GIF or PNG file.
4. Through. The setting allows the text on your document to flow even tighter, taking the contours and
shape of the image. Again, this can be best used with a GIF or PNG type of image.
5. Top and Bottom. This setting pushes the text away vertically to the top or bottom of the image so that
the image occupies a whole text line on its own as in the example.
7. In front of Text. This setting allows your image to be placed right on top of the text as if your image
was dropped right on it. That means whatever part of the text you place the image on, it will be
covered by the image. In the example below, notice the difference between using a PNG file (on the
left) with a transparency effect and a JPG file on the right.
Checkpoint
2. Describe how or in what ways you can manage the recipients' list.
2. Describe the steps on how you can transfer your pictures to your computer.
©All Rights Reserved
Issue No.: 1 Page 45 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Key to Correction
Category 3 2 1
All description is related to Some description is related Few descriptions are related to
Content
the topic to the topic the topic
Shows deep knowledge/ Shows shallow knowledge/ Does not show or reflect an
Profoundness insights/ understanding of insights/ understanding of idea/ knowledge/ insights/
the topic the topic understanding of the topic
Well-organized compilation Slightly organized Descriptions are confusing to
Organization
of descriptions compilation of descriptions the teacher
Assessment
Collaborate among your friends or classmates and make a newsletter about news and events in your school.
See rubrics below on how you will be graded. Send your output to my Email account.
The output is free The output contains The output has several The output contains
Correctness from errors minimal errors errors. many errors.
The group was able to The group was able to
The group was able
finish the task most complete the task but The group used the
to finish the task in
Efficiency effectively without
the projected
used methods that least efficient method
wasting time and consumed more time in the finishing task.
amount of time.
effort. or resources.
Lesson: 4
Learning Module 4: Advanced Spreadsheet Skills
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
Performance Standard:
The learners shall be able to at the end of the 2-week period independently apply advanced productivity tools
to create or develop ICT content for use in specific professional tracks
These may be in the form of, but not limited to:
1. Calculating spreadsheet of athletic statistics (Sports)
2. The layout of the catalog of creative works (Arts)
3. Materials/ ingredients projections for batches of baked goods (Tech - Voc)
4. Letterhead/ business card design (Business/ Academic)
Learning Competencies:
The learners:
©All Rights Reserved
Issue No.: 1 Page 47 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
1. uses common productivity tools effectively by maximizing advanced application
(EMPOWRMENT techniques;
TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
2. creates an original or derivative ICT content to effectively communicate or present data or
1
information related to August 10, 2020
specific Reviewed
professional [Link]: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
Specific Learning Outcomes: QMR President
6. critically assess the effectiveness of their previous financial decision and consider whether to repeat
these decisions in the future; and
7. recognized the basic financial foundation in setting up a potentially profitable business enterprise.
Overview
Good day, student! Let's start our day with a short activity.
Try to come up with a product or service that you can sell or offer to fellow students, teachers, or
school administrators around your school. It could be delicacies like polvoron or yema, small souvenirs
like keychains or bag tags, or services like foot spa or harana (serenade) for hire.
Add a personal twist to your product. If it is food or product, add something that you think could be
marketable. You may add malungay to polvoron. The keychain may contain a caricature of the buyer.
You can also create artworks and sell them as products or services.
On a sheet of paper, fill out the form with the information about your product. A sample is shown
below:
Product Information
Discussion
Whether your work is in the field of accounting or not, the truth is whether you do should be accounted
for. This is because the resources you use cost you experiences. Whether you become a scientist, an
engineer, a yoga instructor, a bartender, or an airline pilot, it is important to understand how a company
spends its resources to be able to deliver a product or services. These factors could easily be computed using
spreadsheet programs like Microsoft Excel or Google Sheets.
Product Information
Product Description:
Starbuko Milk Teaa is a special milk tea using organic ingredients especially
made for Filipinos.
Note: Values with PHP or Philippine peso sign use the Accounting Number Format. Its default uses
the dollar symbol ($). To change this, click the drop-down arrow at the currency button $, then select
More accounting Formats, then change the symbol to PHP.
2. Use the SUM formula to get the summation of the values from cells C4 to C7. The SUM formula is
=SUM(C4:C7). Type this on cell C8, as shown below:
3. Check if our estimated price will earn us profit. Type the additional information shown below then
apply the arithmetic formula for subtraction:
5. The result is Php7.80. This is profitable at this price. However, this does not guarantee our product's
success.
Now it is your group's turn to do this for your product. Remember to research the ingredient's
price if applicable, divide the quantity of a certain ingredient sp that its cost will only cover one serving.
For instance, 300 ml of condensed milk will cover about three servings of milk tea, so you have to
divide its price by three.
As seen in the exercise above, we must first ensure that the selling price is
greater than the total cost of ingredients. However, these ingredients only represent the
cost per unit, also known as the variable cost of the product. This does not yet include the
variable involved in actually producing the product, which include electricity, rent, labor,
etc. all these overhead experiencing, which are incurred whether or not you produce any
milk tea, are also known as fixed costs.
Suggestions or comments:
©All Rights Reserved
Issue No.: 1 Page 52 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
Add ore questions that fit your product. If your product is not a food product, replace
(EMPOWRMENT the "taste" rate with the
TECHNOLOGY)
Revision No.: Effectivity Date:
durability of function rate. Have this survey form approved by your teacher to produceMODULE
STUDENT LEARNING around 15 copies of
these. 1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Produce your sample product for the actual product testing. The sample product should be for 15 to
20 people. Start the product testing in your school by letting your fellow students, teachers, and personnel
taste/test your product. Afterward, gather the data and place them in Microsoft Excel. A sample of this
spreadsheet is on the next page using the milk tea product example.
Tip: To change the orientation of a text, press Ctrl + 1 to open the Format Cells dialog
box. Choose Alignment tab and under Orientation, specify the degrees you want.
©All Rights Reserved
Issue No.: 1 Page 53 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
This data is raw. Assuming that we have a huge sample, we have to apply several
_________________________ formulas to be able
_________________________
to analyze the result of this survey easily. GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
AVERAGE Function
Let us start with a simple average formula to determine the average rating of Quality, Taste,
Presentation, and Product.
The syntax would be =AVERAGE(cells involved).
Example:
Using Figure 4.1, determine the average for Quality:
=AVERAGE (F5: F19)
Determine the average of all your criteria and place them at the bottom of your survey results similar to the
screenshot below:
COUNTIF Function
Next, determine how many people said YES or NO if they were satisfied with the product or if they
would recommend it to their friend. For this, we will use the COUNTIF function.
Using the =COUNT function will allow us to count the number of cells that contain something.
However, in this case, we just need to count the ones that have YES or NO in them. For this, we have to use
the COUNTIF function.
COUNTIF Function Syntax:
=COUNTIF (range, criteria)
Rage – the cells where the counting will take place
Criteria – the label or value that determines if it is to be counted.
Example:
Using Figure 1.9, the formula for getting the number of YES for the criteria is =COUNTIF(J5:J19,"
YES")
Tip: if comma (,) does not work, try using semicolon (;) in separating the formula. Thus, it would be =
COUNTIF (J5:J19;” YES”). This is because of the language settings of using semicolon instead of
comma. To use commas in separating Excel formulas, change the List Separator in the©All Language
Rights Reserved
Settings.
Issue No.: 1 Page 54 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Determine the number of YES answer in both criteria and place them at the bottom of your survey
result similar to the screenshot below:
If we were to determine if we should sell our product or services to teachers or students, we could use the
AVERAGEIF function.
AVERAGEIF Function
Using the AVERAGEIF Function, we can average a range if the cell beside it equals to "teacher" or
"student."
AVRAGEIF uses the following syntax:
= AVERAGEIF (range, criteria, average range)
Range – the range of cells where you want to look for the criteria
Criteria – a value or label that determines if a cell is part of the range to be averaged
Average Range (optional) – the actual range of cells that will be averaged, of omitted, the range will be
used instead
Example:
Using figure 4.1
With this, we can say that the teachers rated the product higher.
In other instances, you may also want to use the SUMIF function, which works similarly to the
AVERAGEIF function, except that it gets the summation rather than the average.
Checkpoint
Using the formulas you have learned, accomplish the following by analyzing your data. Use the data
you have gathered.
1. Determine the number of people who are willing to pay a certain amount.
2. How many of the specific groups (e.g., teachers/students) are willing to pay more?
3. How many of the specific groups (e.g., teachers/students) like the presentation of the
product/services?
4. See rubrics below on how you will be graded
5. Send your output to my Email account.
3. List down other functions that you think where not included in this lesson and then briefly describe
each of them.
4. How does Microsoft Excel help entrepreneurs? State at least five instances.
5. Try to use the COUNTIFS function and determine the differences between the COUNTIF and
COUNTIFS.
Try to sell your product or service in a school or your neighborhood. Use Microsoft Excel to
determine your product or service is profitable by encoding the data of your
Assessment
profits and using the formulas you have learned. Log the customer's age range
as well.
Take note that there are other factors that you have not encountered in your simulation. It is important to take
into consideration the following costs:
1. Fixed Costs:
a) Rents – how much do you pay for renting the area where your products are sold?
b) Salaries – how much do you pay for people who are working to make this venture a success?
c) Utilities – how much do you pay for water and electricity (if applicable)?
d) Interest – since you are a student, your money may have come from your parents. Treat your parents
as if they are a bank wherein the money you loand=ed from them would have a particular interest.
2. Other costs:
a) Maintenance – how much money is spent on maintaining machines and instruments that are used to
make the product or deliver the service?
b) Training – how much money is spent on training your staff?
c) Research – how much money is spent on researching all about your product? This involves human
resources, utility bills, and even transportation costs for the researchers.
d) Advertising – how much money is spent on promoting your product? Whether it is online (electricity)
or prints (ink and paper), you still spent money.
After factoring in the costs above, try to determine the best price for your product that will make it profitable by
at least 15% per item or services sold. Your output will be graded using the rubric below. Send your output to
my Email account.
Category Exemplary Accomplished Developing Beginning Score
4 3 2 1
Skills All skills from the Most skills in the topic Some skills in the Few or no skills from
topic and applied. are applied. topic are applied. the topic are applied.
Content The output exceeds The output is The output is The output is
expectations. complete. somewhat complete. incomplete.
Correctness The output is free The output contains The output has The output contains
from errors. minimal errors. several errors. many errors.
Efficiency The student was The student was able The students were The student used the
able to finish the task to finish the task in the able to complete the least effective
most effectively projected amount of task but used a method in finishing
without wasting time time. method that the task
and effort. consumed more time
or resources.
Teamwork The member is an The member The member exerted The member did not
(Individual) effective team contributed to the little effort in contribute to the
player. group. accomplishing the group.
group's task.
Lesson: 5
Learning Module 5: Advanced Presentation Skills
Content Standards:
The learners demonstrate an understanding of how to manipulate text, graphics, and images to create ICT
content intended for an online environment
Performance Standard:
The learners shall be able to:
at the end of the 2 weeks, independently apply the techniques of image manipulation and graphic design to
create original or derivative ICT content from existing images, text, and graphic elements for use in specific
professional tracks.
These may be in the form of, but not limited to:
1. Team/ athlete/ league recruitment posters (Sports)
2. Logo or crest for a community, school organization or barkada (Arts)
3. Labeling and manual of operation for tools and equipment (Tech - Voc)
4. Presentation of cafeteria patronage data (Business/ Academic)
Learning Competencies:
The learners:
1. evaluate existing websites and online resources based on the principles of layout, graphic, and visual
message design;
2. use image manipulation techniques on existing images to change or enhance their current state to
communicate a message for a specific purpose;
3. create an original or derivative ICT content to effectively communicate a visual message in an online
environment related to specific professional tracks.
Overview
Good day, students! It is no time for your group to present the result of your small business venture in class.
What is a better way to present it but with the use of a presentation tool.
Below is a list of presentation tools. Research about them and write their advantages and disadvantages.
1. Microsoft PowerPoint
2. Prezi
3. Apple Keynote
4. Google Slides
5. Haiku Deck
6. PhotoSnack
You are free to decide which presentation tool/program you can use.
There are plenty of tools you can use to present data. Whether it is scientific data, statistical, or a book
report, a presentation tool has you covered.
Designing your presentation is the fun part of creating a report, for it gives you a chance to be creative. Placing
animations, transitions, and art could be on your mind right now. But whether or not these features would help
is generally up to you. Sometimes, these things could distract your audience rather than help them. Here are
some quick tips in creating an effective presentation.
1. Minimize. Keep slide count to a minimum to maintain a clear message and to keep the audience
attentive. Remember that the presentation is just a visual aid.
Most of the information should still come from the reporter.
2. Clarity. Avoid being fancy by using a font style that is easy to read. Make sure it is also big enough to
be read by the audience. Once you start making your presentation, consider how big the screen is
during your report.
3.
Tip: A font size of 72 is about an inch (depends on the screen size). A one-inch
letter is readable 10 feet away; a two-inch letter is readable 20 feet away.
Simplicity. Use bullets or short sentences. Summarize the information on the screen to make the audience
focus on what the reporter is saying than on reading the slide. Limit the content to six lines, seven
words per line. This is known as the 6 x 7 rule.
4. Visuals. Use graphics to help in your presentation; however, too many graphics may graphic may
distract the audience. Also, instead of using tables for data representation, use charts, and graphs.
5. Consistency. Make your design uniform. Avoid having different font styles and backgrounds per slide.
6. Contrast. Use a light font on a dark background or vice versa. This will make the text easier to read in
most instances. It is easier to read on-screen if the background is dark. This is due to the brightness of
the screen.
Now that you know the tips, it is now time to create a presentation about the results of your product selling.
1 2
3 4
5 6
9 10
11
As you can see from the sample presentation, the information presented is summarized as opposed to putting
too many words that may make the audience read the PowerPoint than listen to the speaker.
Links Options:
a. Existing File or Web Page – create a hyperlink to a website or a local file saved in your hard
drive. Just browse your file in the dialog box or type the web address.
b. Place in This Document- creates a hyperlink that allows you to jump to a specific slide in your
presentation.
c. Create a New Document- creates a hyperlink that, once clicked, creates a new document on
your specified location.
d. E-mail Address- creates a hyperlink that opens Microsoft Outlook that automatically adds your
specified recipient to a new email.
Tips: Notice how the word you selected is now underlined and is colored
blue that changes to purple whenever the link is previously visited.
Embedded objects are accessible using Microsoft PowerPoint. With this option, you can insert an
Excel file that would look like a table to a presentation.
Options:
Reference
1. Insert Action buttons on your presentation (action buttons are found in Insert>Shapes).
2. Create action buttons that will allow you to navigate to the next slide, previous slide, and first slide.
3. Insert hidden slides at the end of your presentation then insert an object containing your Excel files.
Create hyperlinks to these slides that contain the charts corresponding to the data.
2. Cite three instances where objects can help you improve your presentation.
Lesson: 6
Learning Module 6: Imaging and Designing for Online Environment
Learning Competencies:
The learners:
1. evaluate existing websites and online resources based on the principles of layout, graphic, and visual
message design;
2. use image manipulation techniques on existing images to change or enhance their current state to
communicate a message for a specific purpose;
3. create an original or derivative ICT content to effectively communicate a visual message in an online
environment related to specific professional tracks.
Overview
What is the most visited website in the world? Think about it for a second. No, it is not Facebook nor
Twitter. Here is a clue, the site'ss mission statement is “to organize the world’s information and make it
universally accessible and useful. “you have probably guessed it by now--it is Google. In December 2017,
[Link], a renowned website for ranking webpage popularity, rank google as the number one website in the
entire world. Why do you think Google ranks number one despite the many search engines and websites on
the Internet
Discussion
Creating a web page is like creating a work of art. There are certain things that you need to consider
to get your message across. In the previous lesson, you learned how to create an effective PowerPoint
presentation. Some of those tips can help you with graphics and layout design.
1. Balance- the visual weight of objects, texture, colors, and space is evenly distributed on the screen.
When visiting a website, check if one side holds the same amount of weight on the other. The colors
should also have a similar visual weight.
2. Emphasis- an area in the design that may appear different in size, texture, shape, or color to attract
the viewer’s attention.
3. Movement- visual element that guides the viewer’s eyes around the screen.
4. Pattern, Repetition, and Rhythm – the repeating visual element in an image or layout to create unity in
the layout or image. Rhythm is achieved when visual elements create a sense of organized
movement.
5. Proportion- visual element that creates a sense of unity where they relate well with one another.
Infographics
Information Graphics or Infographics are used to represent information, statistical data, or knowledge
in a graphical manner usually done in a creative way to attract the viewer’s attention. Infographics make the
complex more visually appealing to an average user.
1. Create a Piktochart account by going to [Link] and click sign up on the upper right
corner of the page.
3. Fill out the sign up page with the information needed; alternatively, you can connect with Google+ or
Facebook.
4. Once you have created an account and logged in, you first need to answer the following questions
below to best select what template suites you then click submit.
6. The piktochart editor will open (may take a while to load depending on your Internet connection). The
Dashboard contains your previously created visuals. On the left-hand corner contains your options of
what visual you want to create: Infographics, presentations, or printables, for now, excellent
infographics.
7. While editing a block, you can use the various tools on the left side of the page:
a. Graphics- Allows you to insert lines, shapes, icons, and even photos;
b. Uploads- allows you to browse and upload images from your local disk for your infographic;
c. Background – changes the background of a selected block;
d. Text- allows you to insert text to your infographics with the option to add text frames;
e. Color scheme- allows you to modify or create a new color scheme of your infographic; and
f. Tools- allows you to create charts (similar to the one in PowerPoint), maps (for demographic),
add videos.
Editing Tips:
8. To save your work, click on the Saved button on the top right of the page. To save it on your
computer, click Download.
©All Rights Reserved
Issue No.: 1 Page 76 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
In the Download options, select the medium quality and the(EMPOWRMENT
file format. TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Unlike images that are found on our computer, you have to consider that the website image should be
more compressed because data travels over the internet ad, nor everyone has an Internet connection.
Consequently, we have to use compressed images on our websites. Likewise, even though a wide variety of
websites already support high-definition (HD) photos, you do not have to use HD all the time. Most of the time,
you do not have to.
There are plenty of other image file formats used on the web, but most of the time, you will be using
these three because of their compatibility with all major web browsers.
Most of the time, we just capture an image and upload it on the Facebook account. From there,
Facebook does the rest by formatting our image to fit best the standards set by Facebook. But once you
create your website, you will have to edit your images. It seems a simple task, but you have to strike a balance
between the right image quality and the time for the page to load these images.
Personal websites do not necessarily have to downsize the file size of the images. But if you have a
broader target audience, you need to make necessary changes. Here are some tips to help you edit images
for your website:
1. Choose the right file format. Try to make a real-life photograph into GIF to see the difference between
PNG, GIF, and JPEG. Knowing the purpose is the key to finding out the best file format.
2. Choose the right image size. A camera with 12 megapixels constitutes a more prominent image size.
Monitor has a resolution limit, so even if you have a million megapixels, it will not display everything.
Thus, it is not always wise to make our image big, most notably on a website. Know how much space
you want the image to consume. Or have a “preview” image where the audience has the option to “
see full size.”
3. Caption. Remember to put a caption on images whenever possible. If it is not related to the webpage,
then remove it.
There are plenty of image manipulation tools, but if you are going to create a website, you have to use
the efficient one. Photocopies a useful tool because it is feasible for beginners and advanced user alike.
On the photoscape’s main screen, you will see its various features that you can use for creating web content
as follows:
1. Viewer- picture viewer that has the same features with most image viewers (e.g., changing image
orientation)
2. Editor- alters the appearance of a single image
3. Batch Editor- alters the appearance of multiple images
4. Page- arranges several photos to create a single one; similar to mosaic
5. Combine- links several images together to form a bigger image
6. Animated GIF- allows you to create an animated GIF from several pictures
For this lesson, we will only focus on the ones that we can use for our future website project: the Editor and
Batch Editor.
Editor Edit
For this exercise, take a photo form your camera. It can be a “selfie,” a “groufie,” or a random photo.
Make sure that you are the one who took it, and it is worth spending time with editing. Once you have it ready,
place it on your computer in a directory most convenient to you.
5. Notice the properties of the image like the file name, the image size (in pixels), and the file size found
on the bottom of the preview.
On the image above, notice that the photo is 4000 x 3000pixels and has a size of 3.3 MB. Most
monitors today do not support the resolution and would probably fill up the entire webpage. Due to this
high resolution, the file size is affected even though this is an HPG file.
6. Manipulate the image using the tools on the bottom.
a. Home tab- this is where you can add a frame, resize, sharpen, and add filters and effects to
your image.
If you have a similar problem as mentioned in the previous step, try to reduce the size of the
image. Most monitors with the aspect ratio of 16:9 support resolutions 1366 x 768. Try to
resize your image to lower than 800.
Batch Edit
Batch editing is one of the most useful tools when you create a gallery of photos for a website. You
can make their sizes uniform to what you have specified. For this exercise, you will need to take at least ten
pictures and save them in your desired folder. It is highly recommended that your photos share the same
orientation (portrait or landscape).
1. Select the folder where your photos are located, then on the Preview window, drag the photos you
want to be part of the batch edit to the work area (center)
2. Use the tools on the right edit your photo. This is similar to the options in edit except for the Crop
and Tools, which are replaced by the Filters tab. The filters tab is used to ass a specific filter that
will apply to all your photos.
3. Resize the pictures so that they do not exceed 800 pixels in width. Add filters if you want.
4. Click on Convert All button found on the upper right.
5. The save dialog box will appear that will allow you to change the location, the name of the image,
and the file. Since we are working on photographs, we are going to keep it as JPEG. For this
exercise, save the batch images in a new folder labeled as “batch” inside your resources folder.
Sharing your photos over the internet has never been so comfortable using social media. However, it
is highly recommended to put your social media photos private and separated from the ones that are posted
over the Internet. In that case, you need an image host. Image hosts are websites specializing in storing
photographs. These photographs can easily be embedded into a webpage or website.
There are plenty of image hosting sites out there; some of them have fee while others are free where
you can pay for more storage space or bandwidth. Storage space is pretty straightforward; it is like having a
16GB flash drive where it limits you to just 16GB. Bandwith limits hinder access to your image once a certain
bandwidth quota is reached (measured by megabytes or gigabytes). This quota is reached when a lot of
people have loaded the image using their computers on a certain amount of time (usually monthly).
There are plenty of free image hosting sites out there, and Photobucket is one of the oldest. Fell free
to check out other free image hosting sites over the internet.
1. First, sign up for a Photobucket account on [Link]. Just like piktochart, you may use your
Google+ or Facebook account to sign up automatically.
2. Once your account is set up and you are already logged in, click the Upload Images button.
3. A new page will load allowing you to drag and drop your photos or to choose them manually or the
entire folder to upload. Select a folder, add a password(optional), then feel free to upload any photos
you have right then.
4. Once selected, a progress bar will appear, indicating that the image is uploading. This may take a
6. Let us assume you will share a photo individually. Select the photo then click share
7. a pop up will appear, and you will see the following options:
Gives you a variety of link codes for HTML, Forums, Emails, Instant Messaging, and a direct link
Shares your photos directly to social media and blogging platforms: Facebook, Twitter, Google+,
Tumblr, and Pinterest, respectively
Shares your image via email
Share your image to social media sites with the option to add a custom message
8. You may choose to share your photo with your friends on Facebook. If you are done sharing, you may
now log off and close the browser.
Reference
Checkpoint
1. Give three websites that you visit. What makes their site design work?
2. Research on Photobucket and two more free image hosting sites and check out the limitations of the
free account. What is the best hosting site for you, and why?
Assessment
1. Create a short-three question survey for the community members who are campaigning. Ask them to
scale their thoughts (e.g., On a scale of 1-5, do you think this problem would ever be solved?). Make
sure you ask at least 15 members of the community to make a strong case for your campaign. Create
an infographic about it and post it on your campaign. Send the link to my account.
2. Go outside or even in your home with any device that has a camera and takes one picture for each of
the following principles:
Balance;
Emphasis;
Movement;
Pattern, Repetition, and Rhythm;
Proportion; and
Variety.
You may send these photos to my email explaining why the photo shows the principle. Make sure you
save the images for future activities.
3. Create an infographic using the data you gathered in Take the Challenge no. 2 from lesson 4.
Send your output to my E-mail account. See rubrics below on how you will be graded
Category Exemplary Accomplished Developing Beginning Score
4 3 2 1
Skills All skills from the Most skills in the Some skills in the Few or no skills
topic are applied. topic are applied. topic are applied. from the topic are
applied.
Content The output The output is The output is The output is
exceeds complete. somewhat incomplete.
expectations. complete.
Correctness The output is free The output contains The output has The output
from errors. minimal errors. several errors. contains many
errors.
Efficiency The student was The student was The students were The student used
Lesson: 7
Learning Module 7: Online Platform for ICT Content Development
Content Standards:
The learners demonstrate an understanding of the principles and techniques of design using online creation
tools, platforms, and applications to develop ICT content for specific professional tracks
Performance Standard:
The learners shall be able to:
at the end of the 2 weeks independently apply the principles and techniques of design using online creation
tools, platforms, and applications to create original or derivative ICT content for use in specific professional
tracks
These may be in the form of, but not limited to:
1. Survey instruments using Google forms (Business/Academic)
2. Athletic matchups and league standings using Mindmeister (Sports)
3. Catalogs/Swatches/ options for products and services using Prezi (Tech Voc)
4. Online photo album of artistic works or photographs using Picasa (Arts)
5. Online music production using Sibelius (Music)
Learning Competencies:
The learners:
1. evaluate existing online creation tools, platforms, and applications in developing ICT content for
specific professional tracks;
Overview
Good day! Today you will be having a group chat - a video call on messenger or zoom, or you can just
have a group message. Now divide yourselves into two groups, one group represents “team social media,”
while the others represent “team bloggers.” The groups will have ten minutes of closed group discussion about
the advantages of each platform. After ten minutes, the groups will choose five representatives (since not
everybody can be included on the video call) who will debate on which platform is superior and why.
After the debate, write your thoughts in the space provided by answering the question:
Discussion
We have discussed some of the platforms already available on the web. This time, we will take a more
in-depth approach to these platforms and when to use them accordingly. Is there a superior platform? Read
more to find out.
We will focus on a platform that will allow us to share our content with the rest of the world. We will also
create a few to experience what it is like to use all of it.
1. Social Media Platforms. Websites like Facebook allow you to create not only personal accounts but
also pages and groups where you can share content. The only downside of this is that you are
restricted to Facebook’s “one-size-fits-all” design which mater the agenda of your page, it will look the
same as other pages. This design feature is also present in other social media platforms like google+.
On the plus side, Facebook has billions of users. LinkedIn is another example of a social networking
site where its focus is on business and professional networking.
2. Blogging platforms. Websites like WordPress, Tumblr, and Blogger focus on content and design. It
typically looks like a newsletter where you are given options to change the design to your liking.
Though you can manipulate the design, the social media platform’s popularity is still unrivaled. The
amount of customizing in blogs is also unrivaled depending on the content management system
implemented by the provider.
3. Step 1: First, create your [Link] account. Fill in the details make sure the E-mail you use
is still active. Or create an account using Google (using your own Gmail) and Apple (using your
Mac ID) located at the bottom.
4. Now think of a name for your site address. Think about it clearly as it will be part of your URL. If
you are done, a list will appear showing you the available domains that you
can use. Since we are just practicing your blogging skills, and are not ready to spend real money,
choose the free option. Your blog URL should look like this: [Link]
Once your site has been created, you will see your dashboard containing two tabs. “My
site” and “Reader.” My site includes controls regarding your content that you post, whereas
“Reader” allows you to see articles from other blogs, including the ones you follow. For now,
make sure that you are on the “My Site” tab, simply by clicking the correct tab. You should
see your browser look like this.
But you’re not done yet, and you need to launch your site first. So follow these steps:
1. Since we just had created our account, just click the “Get started” it’s up to you on how you want
4. We’ve created the basics, and now it’s time for you to update the images and text. Make a great
first impression. Everything you do can be changed anytime.
3
As a new blog owner, you might want to change a thing or two about how your blog looks. There is a list of
things you need to do. On the upper right-hand corner of the page click “customize” under the “Design” or in
the right-hand corner there’s “Manage your site” under are the quick links if you want to edit your website.
Now that you are done with the design of your blog, it is now time for the important stuff: the blog posts!
Creating a blog post is pretty straightforward in WordPress.
4. If you want to keep track of how many words, headings, paragraphs, and blocks you write.
Blocks
a b c d
e f g h
Patterns
a b c
d e
WordPress offers more options for you to discover. Simply go to the “My Sites” tab and explore the
options to the left. Here is a brief explanation for each of them:
There are plenty of things you can do with a WordPress blog. Even if you do not have a pc available, you
can download WordPress on your smartphone or tablets! Make sure you try it out so you can easily post or
create a draft even when you are not at home or in school.
Cloud Computing
We already mentioned the term “cloud computing” in the previous discussions. From the past lessons,
including this one, you have already used the “cloud” in producing several outputs for this class. Give yourself
a minute to think about this output that used “cloud computing.”
When we created infographics, we used Piktochart, which has an infographic editor that uses cloud
computing. The same goes for making your blog and creating your first post: these are referred to as cloud
computing because we did not need to install any software on our computer. The software is the “cloud” or on
the internet. The following are some advantages and disadvantages of cloud computing.
Advantage Disadvantage
1. No need to install 1. Can be hampered down by slow Internet
2. Saves hard disk space speed; no connection; no cloud computing
3. Easy access to your software/files; can be 2. May still require compatible software like a
run anywhere as long as there is an Internet browser
connection 3. You do not own the software; you are simply
4. Saves you money from buying software renting it
licenses and additional hard disk space 4. The security risk of doing things over the
5. No need to update because it updates Internet as opposed to your personal
automatically computer alone
6. Minimum system requirements 5. More prone to hacking
7. Back up and data recovery are relatively 6. Limited control over the infrastructure itself
easier than on a physical device.
Using cloud computing is generally up to you. Large companies opt to use the “cloud” because they
do not need to pay licenses for each computer they have in their company; instead, they can use the software
on demand.
Reference
Checkpoint
1. Research 10 uncommonly used Filipino words, their definition, and example for each when used in a
sentence.
2. Create a blog post about these words, the blog you created.
3. Choose five words and take a video of someone (or yourself) while pronouncing these words. Use the
words in individual sentences. Upload these videos on YouTube.
4. Embed those videos as part of your post.
5. Send the link to my E-mail account. See rubrics below on how you will be graded.
2. What basic principles of design did you follow in your blog layout? Explain.
3. Besides WordPress and Piktochart, what are the other cloud computing software you have used so
far?
Assessment
Add your classmate’s blog to your reading list (when logged into your WordPress account, simply visit
their site, and click on “Follow”). Update your blog at least once a week. Talk about anything interests you and
your readers. Comment on your classmates’ posts and respond to any comments given. I will be checking
your website every end of the month, and you will be graded based on the following rubrics.
Content Standards:
The learners demonstrate an understanding of the principles and techniques of design using online creation
tools, platforms, and applications to develop ICT content for specific professional tracks
Performance Standard:
The learners shall be able to:
at the end of the 2 weeks independently apply the principles and techniques of design using online creation
tools, platforms, and applications to create original or derivative ICT content for use in specific professional
tracks
These may be in the form of, but not limited to:
1. Survey instruments using Google forms (Business/Academic)
2. Athletic matchups and league standings using Mindmeister (Sports)
3. Catalogs/Swatches/ options for products and services using Prezi (Tech Voc)
4. Online photo album of artistic works or photographs using Picasa (Arts)
5. Online music production using Sibelius (Music)
Learning Competencies:
The learners:
1. evaluate existing online creation tools, platforms, and applications in developing ICT content for
specific professional tracks;
2. apply web design principles and elements using online creation tools, platforms, and applications to
communicate a message for a specific purpose in specific professional tracks;
3. create an original or derivative ICT content using online creation tools, platforms, and applications to
communicate messages related to specific professional tracks effectively.
Overview
How hard is it to create a web page? You may already have your Facebook or Twitter account, and
you just recently made your own blog. What about a site that gives you full control over its design?
Interview three of your classmates and ask them to name a website they usually visit but are not
familiar to you. Ask them what makes the site great – graphics, layout, or content. You can do that through
chat or group message. Write their answer to the space provided.
How essential is basic? Imagine the way our ancestors do fishing rod or spear to catch fish. Today,
huge companies rule the fishing industry with their vast nets to catch fish by the truckload. Unfortunately, those
fishing vessels are not affordable, so we will still be using our fishing rod or spear.
However, that is not the case in web page creation. First, the Internet is free. Second, it is of free
courtesy of many website providers that provide basic functionalities for our website to function. Back in the
day, you have to learn HTML (Hypertext Markup Language) and CSS (Cascading Style Sheets) to be able to
create a decent website. Today, we will use a WYSIWYG editor
WYSIWYG
WYSIWYG is the acronym of What You See Is What You Get. This means that whatever you type,
insert, draw, place, rearrange, and everything you do on a page are what the audience will see. Like using the
Microsoft Word, WYSIWYG shows, and prints whatever you type on the screen.
As mentioned earlier, people use HTML codes to create pages and CSS codes to design them. When
it has taken up these coding skills before, it will help you in creating pages using WYSIWYG if you have not,
WYSIWYG designs for anyone who has not or does not have prior coding skills.
Tip: Any file inside the Sample Web page files folder is generated by MS Word . These are the
files that make HTML files display visual elements correctly.
You have just created a web page using Microsoft Word—a technique you can also use using
Microsoft Excel. These office applications can be used as a WYSIWYG platform. The next step is
uploading these files to a web server. However, we will skip that step because we are going to use a
much easier approach to creating websites. We are going to use an online application that is designed
to create websites.
Jimdo is a WYSIWYG web hosting service. It offers free, professional, and business web hosting
services. Jimdo also has an iOS and Android app which you can use to manage your website whenever you
do not have access to a PC.
For this exercise, you will create your website that focuses on your passion or hobby.
1. Create an account on Jimdo by going to [Link] and clicking “Start Now.” Optionally, you may
also download the official Jimdo App on your iOS or Android device.
2. Input your email address, create your password. You may also review the terms of use and privacy
policy. Afterward, click “Sign Up.”
4. Choose Make your own website with Jimdo creator. Then skip the question about what website you
would like to create.
6. Select a website address you want. Though there are options for a professional domain or a domain
you already own, ignore them and choose to use a free [Link] subdomain. This means that your
website will be something like [Link].
7. Select FREE when asked which Jimdo account is right for you.
8. Wait for the page to load (it may take a while). This will load the website editor wherein you can get a
chance to modify the website to your liking. This is called the WYSIWYG.
To use the editor, simply click on the element you want to change, whether it is the navigator on top,
the texts, or images. Almost everything can be changed.
By default, the home page is shown on your editor. To navigate to another page, simply click the page
title on your navigator. The site navigator contains a set of links going through the different pages of your
website. The navigator currently available depends on which template you used. A sample of the navigator is
shown below:
Inserting Page
1. Hover your mouse pointer over the site navigator. The Edit navigator button will appear:
2. Click on the Edit Navigator button. Click on Add a New Page.
3. Rearrange pages using the tools on the page title.
4. Click Save when done.
Editing Elements
Hovering over a text, image, or any element you see on the website will highlight the element.
Sizing tools- use to make images larger or smaller or restore to actual size page.
Align Tools – used for left, right, and center alignment page
Rotate Tools – used to rotate image clockwise or counterclockwise page
View Tools - used to enable enlarge an image, link photo, and remove the link (Tip: Enable
Enlarge Image will show a small image on the page and will only enlarge when a user clicks it.
Link photos allow
Other Tools – caption and alternative text; allow sharing to Pinterest (Tip: Alternative Text refers to
the text that will be shown in the image does not load.)
III. Paragraph
if it is a paragraph, you will be treated to even more options similar to using a word processor:
Adding Elements
1. To add elements on the screen, hover the mouse pointer over the top or bottom of an existing
element until the Add Element button appears:
2. Select the visual element you want to add:
a. Heading – to insert the heading type of text
b. Text – to insert a paragraph type of text
c. Photo – to insert a single photo
d. Text with Photo – to insert a photo surrounded with text
e. Photo Gallery – to insert multiple photos on one area
f. Horizontal Line – to insert a horizontal line that acts as a divider
g. Spacing – to add space with a specified size
h. Columns – to insert columns that divide an area vertically
i. Video – to insert a video from a video hosting site like YouTube
j. Form – creates a Send Email form for feedback
k. Store Item – adds buttons for the site visitor to share your website
l. Share Buttons – adds buttons for the site visitor to share your website
m. Additional Elements – includes other options like Google Maps, file download, widgets,
etc.
3. Edit the element to your liking then click Save.
©All Rights Reserved
Issue No.: 1 Page 122 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
Jimdo WYSIWYG menu _________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
The menu button located at the upper left of your WYSIWYG website QMR gets you more tools that you can use.
President
These are tools that are not usually seen by visitors but are essential for a website creator like you.
Overview
Domains
Business Listing
Settings
Checkpoint
2. What is the difference between the WordPress blog and your Jimdo website?
3. List down three more WYSIWYG web hosting services and their URL.
Assessment
Create a blog post on your WordPress blog, advertising your newly created website. Make sure you
insert details about your website that will entice your readers to visit it.
Send the link of your blog advertising to my E-mail account.
Lesson: 9
Learning Module 9: Collaborative ICT Development
Content Standards:
The learners demonstrate an understanding of the key learnings from the previous weeks, which they will
synthesize into integrated ICT content through collaboration with classmates and teachers as both peer and
partner.
Performance Standard:
The learners shall be able to:
at the end of the two weeks and quarter collaboratively develop an online portal or website to showcase and
share existing and previously developed content
These may be in the form of, but not limited to:
1. Online newsletter
2. Blog
3. Issue online “magazine.”
Learning Competencies:
The learners:
1. evaluate the quality, value, and appropriateness of peer’s existing or previously developed ICT
content related to the theme or intended audience/ viewer of an ICT project;
2. share and showcase existing or previously developed material in the form of a collaboratively
designed newsletter or blog site intended for a specific audience or viewer
Specific Learning Outcomes:
Upon completion of this module, you must have:
©All Rights Reserved
Issue No.: 1 Page 129 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
1. acquired skills in being a productive team member in managing and creating
(EMPOWRMENT a collaborative web
TECHNOLOGY)
Revision No.: Effectivity Date:
content; STUDENT LEARNING MODULE
1 August 10, 2020
2. used an online collaborative tool to monitor Reviewed by: effectively; and Approved by:
group tasks
_________________________ _________________________
3. created a project that requires team member cooperation.
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
Overview
Good day, student! So far, you have created blogs and websites that can be categorized as personal. But like
many websites and blogs you visit every day, you can see that multiple people produce some of them.
Think of the blog you have previously created. Ask yourself the following questions:
1. Who is the target audience of my blog?
2. Are my blog posts of good quality?
3. Is my blog updated regularly?
4. Who usually comments on my blog?
Discussion
Facebook would not that be interesting if it were not for all your friends. The more friends you have,
the more content you get. This also rings true for other websites and blogs. Now, it is time for us to create a
collaborative ICT content.
Web Portals
A web portal is a website that contains information from different sources and places them in one
location in a uniform way. An example of a web portal is Yahoo! ([Link]). [Link] offers a web
portal where news email, weather, etc. are found on one page. The information found in the image came from
different websites/sources.
Working together does not necessarily mean you have to be physically together. These tools can help your
group “go the distance” and work as if you already have your own office.
1. Create a Trello account by going to their home page ([Link] and click “Sign Up.” Fill out
the form and click Create a New Account.
2. Once you have signed up and logged in, click on Create a New team. If you have multiple boards
already, it will be found at the bottom of the page.
For steps 3-6, only one person should do this, preferably the group leader.
3. Click on the Invite button. Input a member’s Trello name or email address, or if the team member has
not signed up for Trello yet, you can invite them just simply adding their email. They will get an
invitation which will require them to sign up. Click Send when done. Do this again until you have sent
5. Create a new board for the task named Jimdo Site. Name it and use the default options, then click
Create.
6. You will be taken to the newly created board. Click on Add a List to add tasks to be done by your
group. For now, add one task named Create a Jimdo Account.
7. As a card under this with the label containing a description. It should look something like what is
shown on in item 11:
8. Click the down arrow on the lower right to view more options.
10. Any input you place in this card will be viewed by anyone. You can also use options on the right to add
members, edit labels, put a checklist, add a due data and attachment (like photos and office
documents). Going back to the board will show that the card is updated.
11. All members should have a list of tasks under their position. The leader should arrange these tasks
according to priority (due dates). Make sure all tasks are covered.
Reference
Checkpoint
1. Inside the classroom, find at least four classmates you have mutual interest.
2. Create a web portal using Jimdo or WordPress, including links to your different blogs and
posts.
3. Create a list of tasks and use Trello to organize your task as a group and to make sure that
no task is left undone.
4. Design the web portal to fit your group’s interest. Alternatively, you can also modify
individual blogs to make them more similar.
5. Design graphics for your portal and place them on all your blogs to create a collective
identity for your blogs.
6. Screenshot your work and Send your output to my E-mail account. See rubrics below on
how you will be graded
2. Do you use other collaborative/social tools besides Trello? If yes, what are these, and what do
you use them for?
Assessment
Create an advertising campaign for your web portal to get more visitors. You can achieve this through the use
of print ads (make from PhotoScape), a Facebook page, or blog posts on your blog, among others.
Send your advertisement campaign to my E-mail account. You will be graded using the rubric below:
Content Standards:
The learners demonstrate an understanding of the key learnings from the previous weeks, which they will
synthesize into an integrated ICT content through collaboration with classmate and teacher as both peer and
partner.
Performance Standard:
The learners shall be able to:
at the end of the 2-week period and quarter collaboratively develop an online portal or website to showcase
and share existing and previously developed content
These may be in the form of, but not limited to:
1. Online newsletter
2. Blog
3. Issue online “magazine”
Learning Competencies:
The learner’s:
1. evaluate the quality, value, and appropriateness of peer’s existing or previously developed ICT
content in relation to the theme or intended audience/ viewer of an ICT project;
2. share and showcase existing or previously developed material in the form of a collaboratively
designed newsletter or blog site intended for a specific audience or viewer
Specific Learning Outcomes:
Upon completion of this module, you must have:
1. improved the interactivity of your website;
2. embedded multimedia content from YouTube; and
3. created a viewer or customer friendly experience for those who visit your website through multimedia
content.
Good day, student! Was advertising campaign successful? To get regular traffic for your website is already a
pretty tough task to accomplish. This is especially true if your website is not as desirable as you think.
It is time to enlist the help of the entire class. Gather your group and visit the websites of other groups
in your class. On a sheet of paper, answer the survey form below. You need to review at least two groups as
assigned by your teacher.
III. Write the features that should be present and the feature that should be removed from the
website.
_____________________________________________________________________________
_____________________________________________________________________________
_____________________________________________________________________________
Submit your work to your teacher. Remember that any negative comment about your website is a
room for improvement ad should not be taken personally.
So far, we have managed to add interactively to your personal blog, website, and even your company
or group website. At this point, you can already consider that these websites are, indeed, Web 2.0. At some
extent, the advertisements generated by your web host (WordPress or Jimdo) are only glimpse of Web 3.0.
The as displayed on someone’s screen are sometimes affected by the things they have already visited.
There was a time that the Internet that was not fast as today’s Internet – only text, images, and bits of
sound are placed on most websites. Today, however, videos and music are now placed freely on most
websites. If you visit [Link]’s website today using the Internet of the year 2000, your World Wide Web
(WWW) would turn him into a different kind of WWW: World-Wide-Wait. CNN now hosts videos placed on their
home page, which was unthinkable in the past because of slow Internet speed. Videos way back then were
never on the home page and can be viewed “on-demand” or only when a user clicks on it. The same goes for
high quality images and background music.
Most websites you see today have embedded YouTube videos on them. To remedy the problem that
not everyone has fast Internet connection, these YouTube videos can be set to be played “on-demand” rather
than having them played automatically.
Multimedia Content
Here are multimedia contents that you can find on some websites:
1. Videos. Through video hosting sites, you can take a video and show it worldwide (e.g., YouTube)
2. Sound, Music, or Audio. If videos are too much for you, you can always record sound. You can
produce “sound bites” and share them globally (e.g., SoundCLoud)
3. Online games. Game developers now create what is called “browser-based games.” You do not need
to install these games to your computer as they run in most updated web browser (e.g.,
AdventureQuest, Farmville, Candy Crush).
4. Online tests. These are online survey forms and tests that automatically display the results when
finished (e.g., Online IQ and personality Tests).
5. Courseware. These are online courses that simulate the classroom through online connection (e.g., E-
learning Courses using a Learning Management System).
6. Podcasts. These are episodic series of audio or text files streamed online (e.g., Stuff You Should
Know, TED Talks, The Starters, ear Biscuits).
7. Vodcasts. These are episodic series of videos streamed online (e.g., YouTube series/shows like
Video Game High School, Good Mythical Morning).
Create a blog post about any significant OPM (Original Pilipino Music) that you like. Any music will do
just as long as it does not have any swears or inappropriate messages.
1. Search any OPM song of your choice on [Link]. You can use an official music video or
someone else’s upload.
3. Click on Embed.
4. Pop-up will appear. Copy the code found on the right hand side of the videos.
5. Create a new post on your WordPress then on the editor, click on the add block button (+) and
find Embed and click the YouTube icon.
Note: write an article about this song describing it and why you featured it on your blog.
6. Paste you code here. Once pasted, do not worry if this code changes to a shorter code.
7. Go back to the Visual tab and add text content on either the top of your video or the bottom.
8. Preview then publish the content.
Reference
Using plain text and images may meet your company’s website. It is time to bring that site to the next level by
adding a YouTube video for your homepage.
1. What video should you produce? You may consider the following options:
a. An introductory video about your group;
b. A video about your group’s interest – enticing others to know more about it.
2. Create a script including the flow of your video. The video should not exceed three minutes.
3. Post your video on YouTube then embed it to your group’s website.
4. Send links of your embeded video to my E-mail account. See rubrics below on how you will be graded.
2. Do you think the video you produced helped your site? Why or why not?
Assessment
2. The following is the list of the people who want your recommendation of which YouTube channel
viewers should follow. Simply go to [Link] and search their names and their interests.
Based on their interests, choose which channels will be listed in the search result. Take note that a
channel is the creator of the video and not just a single video. The first one is done for you as an
example:
Content Standards:
The learners demonstrate an understanding of ICT as a tool, medium, and force in bringing about action and
mobilize change in a population, society, or culture.
Performance Standard:
The learners at the end of the week independently articulate how ICT tools and platforms have changed the
way people communicate, and how social change has been brought about by the use of ICTs
Learning Competencies:
The learners share anecdotes of how he/she has used ICTs to be part of a social movement, change, or
cause to illustrate aspects of digital citizenship
For a moment, imagine the Internet has disappeared and will never be back. What do you think will happen?
List down your thoughts and share them with your classmates.
Information and Communication Technology is a part of a Digital Age, where Internet communication
is one of the most common ways to keep in touch with other people. But even before the digital age, there are
plenty of ways humans were able to communicate.
During the tribal age, or ancestors started communicating through body and verbal communication.
Eventually they learned to be literate and were able to store knowledge through wall paintings and stone
carvings.
By the eleventh century, our Chinese invented the movable type that was able to replicate documents.
By 1440, a German named Johannes Gutenberg invented the printing press in Europe that made it possible to
reproduce document using ink. This made books easy to reproduce and eventually made newspapers
available by 1605.
Finally, electronic-based communications started with the invention of the telegraph. This invention
was only the start as newer technologies like the telephone, radio, and television (TV) came to reality.
Today, we consider ourselves leaving in a digital age. Almost every device is now updating. Back
then, TV were just TVs, and cell phone were just for calling and sending SMS. At present, most devices are
now “smart” – smartphones, smart TVs, and smart refrigerators are only examples of devices that do more
than their regular function. Computers make it possible for these devices to be programmed with codes and
can do more than what we are used to.
Second Phase: Personal Computer – During the 1970s, the development of personal computers
started. This is made possible by chip technologies and magnetic discs which made bulky computers
fit a desktop. This technology made word processing, accounting, and graphics easily available to the
public.
a. Fourth Phase: Networking – Soon thereafter, small connection was made so that computers were able
to communicate with each other. This all started in small distances then eventually broke the distance
barriers which gave birth to the Internet. These days, we still see newer developments which make our
Internet connection faster, thus improving this technology.
b. Fifth Phase: Wireless technology – Wired connections were already a huge advancement for the
Internet, but to travel different places while still being able to browse websites, update your social
media status and search Google were all made possible with wireless technology.
Throughout recent history, the Philippines has been one of a few nations that demonstrates unity for a call
to action or social change. The following campaigns for social change would have not been successful if it
were not for ICT.
1. EDSA People Power Revolution. The people Power Revolution lasted from 1983 to 1986. During a
radio broadcast of Radyo Veritas, Cardinal Sin encouraged the Filipino to help end the regime of the
President Ferdinand Marcos. A major protest took place along EDSA from February 22 to 25, 1986
involving two million Filipinos from different sectors. These includes civilians, political parties, the
military, and religious group. The radio broadcast helped change the course of history. Without it,
Filipino would not have been moved into action.
2. Second People Power Revolution. This is also known as the 2001 EDSA Revolution, happened during
January 17 to 21, 2001. It was fueled after 10 senators-judges and 11 prosecutors of then President
Joseph Estrada walked out of the impeachment trial. As a result, the crowd in EDSA grew over the
course of few days through text brigades. Like the first People Power Revolution, EDSA II would not
have been successful without the text brigades.
4. Yolanda Person Finder. Recent storm in Philippine History gave birth to the Person Finder database
powered by Google. During typhoon Yolanda, the People Finder was a vital tool for people across the
globe to track the situation of their relatives. This provided to be successful and is now adapted by
more organizations to help people track relatives during calamities.
[Link]
[Link] is dubbed as the “world’s platform for change” where anyone from the online community
can create a petition and ask others to sign in. during the past times, petitions are only done through signing a
paper, usually done by a group asking for signatures via travel. [Link] gives access to more people by
allowing the online community to affix their digital signature on a petition.
[Link]’s mission is to help people from around the world to create change they want to see. For
years, [Link] hosted several petitions that help solve the following problems: economic problems,
criminal injustice, abuse of human rights, lack of education, environmental concerns, animal abuse, human
health concerns, and world hunger.
1. Visit [Link].
3. You can then start your own petition, but for now, click on browse then choose any petition you want.
4. Read the petition description to see if this petition matters to you. If it is, sign the petition by filling out
Alternatively, you can check out petitions of your friends on Facebook, then click on those petitions to read
about it and sign it.
Reference
Checkpoint
1. List down five things that could be improved in your school or community. Your group may also interview
some members of your community or use the data your individual members have gathered from Lesson
1’s Skill Exploration.
2. Choose one from the five things you have listed which you think should be of highest priority and demands
immediate action or change.
3. Make a write-up about this problem that is similar to [Link] petition.
1. Name 3 instances from the past where social media has kept the public informed about the latest
news in the county.
2. What is/are the petition(s) you signed using [Link]? Why is it important to you?
Assessment
Create a blog post about how social media has helped families, social workers, and the government in
gathering information during calamities. Differentiate it from the past where information is only provided by the
mainstream media (TV, radio, and print). Send link to my E-mail account.
Lesson: 12
Learning Module 12: ICT Project for Social Change
Content Standards:
The learners demonstrate an understanding of external publics/ partners for the development of an ICT project
that advocates or mobilizes for a specific Social Change or cause
Performance Standard:
The learners at the end of a 4-week period collaboratively participate actively in the creation and development
of an ICT Project for Social Change relating to an issue in specific professional tracks
Topics may cover, but are not limited to:
1. Promotion of wellness in the home (Sports)
2. Street food safety and cleanliness drive (Tech - Voc)
3. Cultural heritage promotion through new designs “Pinoy pride” (Arts)
4. Savings and financial literacy drives and advocacies (Business/ Academic
Learning Competencies:
The learner’s:
1. identify a local or regional cause or issue for Social Change related to specific professional tracks that
can be addressed or tackled using an ICT Project for Social Change;
2. analyze how target or intended users and audiences are expected to respond to the proposed ICT
Project for Social Change on the basis of content, value, and user experience;
3. integrate rich multimedia content in design and development to best enhance the user experience
and deliver content of an ICT Project for Social Change;
4. develop a working prototype of an ICT Project for Social Change.
Overview
So far you have several online platforms and applications to your advantage in promoting and selling products,
and even in starting a small campaign in your community. It is now time to take all of these knowledge to the
next level by identifying which platforms can help your group in your complain for social media.
Form your group from last Lesson’s Skill Exploration. Identify all the platforms and applications that you can
use for your campaign. List them down and explain their roles in your campaign.
Discussion
For the next few weeks, your group will be focusing on creating your social media campaign. For this
lesson, your group will go through the planning stage.
Before starting your project, your group should be able to do necessary paperwork.
This allows experts to see if a project is doable over the time frame that was given and if it is
significant enough to be made into reality.
A concept paper is a document used to convince a panel of potential funders to help a product,
program, or service becomes a reality. Your teacher will play the role of the sponsor and you have to convince
him or her that your project is worth your time and effort.
1. Introduction – includes your group’s mission and vision and a brief introduction of your
project;
2. Purpose – includes the reasons why this project is worth your group and your sponsor’s
time, effort, and money.
3. Description – includes all the necessary information about the project. In ICT, it involves
the size you are going to produce and the purpose of each and how the work in unison.
4. Support – contains the budget needed for the project. Some concept papers do not specify
any amount requested from the sponsor.
5. Contact Information – includes information on how the group can be contacted.
For years, many students depend on the school’s drinking fountain. Aside from saving
them money, the schools drinking fountain contains filters that make the water safe enough to
drink. But according to our research, the last time the water was tested was about three years
ago and by using the drinking fountains around schools, it is highly questionable that the
water is still safe for drinking. Our group theorized that the natural water-and-tear of the
drinking fountain has led to the water’s unpleasant taste. Our group, The Mosaic Alliance,
aims to create several online sources that will help promote the awareness of people involved
about this problem and create an online petition with the goal of improving out drinking
fountains here in school.
Our group aims to create a petition in [Link], a Facebook group, and a blog to
help achieve our goals. We will be creating infographics and other related information
connected to the dangers of drinking unsafe water especially at a young age. The scope of our
project is to be able to reach the school’s administration, parents, teachers, and students to
sign our petition.
We will be requiring a week to develop this project and we will start our promotion
right after we have uploaded the website. We will also be using our own resources so the
funding for this project will be close to none. Our expenses may only include the printing of
campaign materials and the Internet and computer shop rentals in case we need more time
outside school hours. We will also be using free services already offered by Facebook,
Blogger, and [Link].
Should you have any questions about our project feel free to contact us at
mosaicalliance@[Link].
2. Development – involves the actual creation of the website(s); the production of images, infographics,
etc.
3. Release and Promotion – involves the actual release of the website for public viewing and promoting
it. Promotion typically starts before the actual release.
4. Maintenance – involves responding to feedback of your site visitors and continuing to improve the
website.
Reference
Checkpoint
Your group’s goal over the course of two weeks is to create a legitimate [Link] campaign and accompany
it with a website that will promote the campaign and supple more information about the campaign. Create a
concept paper about this social campaign. Send it to my E-mail account for approval.
Once approved by your teacher, the following will be required for this project:
1. A website or blog that will promote and explain what the campaign is all about;
2. Pictures that will accompany the website or blog;
3. At least one infographic posted on the website (requires research either through the simple survey or
through the use of secondary data);
4. A Facebook fan page about the event that will help your audience meet and collaborate.
Optional:
1. A Photobucket account to host your images;
2. Another social media account like Twitter to reach a broader audience.
Using the Simplified ICT Project Process Overview, do the steps in planning your social
campaign.
Assessment
1. As a group, take photographic and videos for your campaign. Avoid using portrait videos;
use landscape ones instead. Prepare the videos for upload on YouTube. On the other
hand, upload your pictures to a Photobucket account or any image hosting site.
Using your prior knowledge and skills, your group will have to create, design, and
upload content or your website. All content should be original. It is advisable not to post
all the contents at once, plan the time between each post.
Your group should also prepare campaign materials to post around your school. You may
also start promoting via page shares and word of mouth.
Watch the video and comment about it through your blog. Make sure you embed
the video in you blog post. Write why you chose that campaign and how change can be
done if we all worked together.
Lesson: 13
Learning Module 13: ICT Project Publication and Statistics
Content Standards:
The learners demonstrate an understanding of how to manage an online ICT Project for Social Change
Performance Standard:
The learners at the end of the 2-week period independently and collaboratively co-manage an online ICT
Project for Social Change through available tools, resources, and platforms
Learning Competencies:
The learner’s:
1. demonstrate how online ICT Projects for Social Change are uploaded, managed, and promoted for
maximum audience impact;
2. generate a technical report interpreting data analytics, e.g. Google, Facebook, or similar traffic data on
the general aspects of search visibility, reach, and vitality.
Overview
Which among your site’s content will become the most popular?
After your campaign from the previous lesson’s Assessment, gather your group members and ask
yourselves the best campaign materials to use. Take a look at the other group’s campaign materials and see if
they are also effective. Are these campaign materials really that useful? If so, how does it affect your
websites?
Discussion
Have you ever wondered why websites publish new content at a certain time or date? In the business
world, companies would use site statistics to check how popular their website is and at which day time they get
the most traffic. This way their new content could reach more people.
1. WordPress
Once you log in to your WordPress account, you will be on the Readers tab by default. Simply click on
Stats and from there you will see the statistics for your blog.
2. Facebook
When you click on any Facebook page that you manage, you will see the Insights tab located at the
top of your page. Clicking on it will give you in depth statistics about your Facebook page.
©All Rights Reserved
Issue No.: 1 Page 173 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
The Insights Tab contains the following menus: (EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
b. Promotions – contains paid advertisements you have made for your Facebook page;
c. Followers – contains statistical data of your followers;
This give you an idea of when your page received the most likes. This may coincide with an
interesting post or an active week for your page.
Note: Followers contains the statistics of your current volume of followers, while likes contain the
number of people who have liked your page including followers who disliked your page.
e. Reach – contains information about the number of people which was reached by your individual
posts;
This page includes statistics that you may not be familiar with. Here are the definitions of the
statistics found on this page:
©All Rights Reserved
Issue No.: 1 Page 175 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
Reach: Organic – your posts seen through thee page’s wall,TECHNOLOGY)
(EMPOWRMENT shares by users, and the
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
news feed;
Reach: 1 Paid –August
your 10, 2020seen Reviewed
posts through paid
by: advertisements Approved
on Facebook;
by:
_________________________ _________________________
Post Clicks – the number of clicksGEMMA done E.
to PAGSUGIRON,
your post; MBA MA. TERESA S. SARABIA, Ph.D.
Likes, Comments, and Share – actual interaction QMR done by your audience either through
President
liking the post, commenting on it, or sharing it on the walls.
f. Page View – includes statistical data about your page visitors like total number of views and views
by age or gender, country, city, and more;
g. Page Preview – sows statistical data on how many times you Page preview has been seen;
h. Actions on Page – actions done on your page by visitors. This may involve clicking on certain
i. Posts – contains data showing when (day and time) your site visitors visit your site;
j. Events – includes statistical data that involves the events you have created on your page. If no
event is created, no data will be displayed here.
k. Videos – statistical data that involves the videos you have added to your page. If no video is
added, no data will be displayed here.
l. People – contains statistics about your audience’s demographics (age, location, gender,
language, and country). It also includes demographics about the people you have reached and
engaged with.
Demographics refers to the statistics characterizing human population usually divided by age,
gender, income, location, and language.
m. Message – involve statistical data of your conversations with your audience. If no conversations
were made, no data will be shown.
n. Orders – shows the number of orders that the page received during a period.
Reference
After a week of operating, updating, and managing your site and Facebook page, it is now time to analyze the
effectiveness of the things you have done to them. Answer the following questions as a group:
1. Which day and time is your page most popular?
2. What makes it popular at that given day and time?
3. What kind of posts was the most popular? Was it your videos, photographs, or your infographic?
4. Who are your audience composed of? What are their age range, location, gender, and language?
5. How many likes has your page got so far? How could you boost this even further?
Compile this on another word document and send it as an attachment to my E-mail account.
1. What are other ways of getting site statistics? Give at least one and explain.
Assessment
Continue operating your website by considering the answers you made in Exploration 13.1. Use these
statistics so you can focus on what kind of information your audience wants more. Focus on the content so
that it can entice more people to visit your site.
For your campaign, try to focus as well on people who have yet to see your website through the use of
the demographics.
Lesson: 14
©All Rights Reserved
Issue No.: 1 Page 179 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
Learning Module 14: ICT Project Maintenance
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
Content Standards, Performance Standard, Learning
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
Competencies and Specific Learning Outcomes QMR President
Content Standards:
The learners demonstrate an understanding of how to maintain and sustain the operation of an ICT Project for
Social Change.
Performance Standard:
The learners shall be able to:
at the end of the week independently evaluate the performance of an advocacy via an ICT Project for Social
Change through available monitoring tools and evaluating techniques such as user interviews, feedback
forms, and Analytics data.
Learning Competencies:
The learners generate a report on the performance of their ICT Project for Social Change on the basis of data
gathered from available monitoring tools and evaluating techniques
Find a partner. Assign a drawer while the other becomes the arbiter. Place a blindfold on the person
who will draw. Your teacher shall give the two of you the task to draw an object. The drawer shall start drawing
with his or her blindfold on; the arbiter’s job is to assist the drawer in drawing the object through verbal
command. However, the arbiter cannot touch the drawing and the drawer (or the object being used to draw)
while the drawer cannot speak. Your teacher will set a time limit for this. Afterward, compare your artwork with
your classmates.
Discussion
In the previews activity, did you find drawings that look really good? Or were they not that good?
When you create content and you find it highly successful without anyone giving you feedback is a game of
chance. In the corporate world, time and money are wasted when you leave things by chance. The same goes
with webpage creation – feedback is very important.
The internet will give you plenty of options in gathering your audience’s feedback. The only difference
that you and your group my notice is how these services are presented. Some of them, because they are free
to use, may have too many ads or some features are lacking. In any case, it is your group’s choice which of
these services is not cumbersome to reach your objective.
Google offers one of the easiest ways to gather user feedback. Google Forms allow your audience to answer
a set of questions you have set. These can be used for surveys, feedback, online registration, and customer
care support.
Forms.
3.
a. Question Title – includes the question that will be answered by your audience
b. Question Type – changes the type of question according to your preference. These options
include:
i. Short Answer – a question that can be answered in a short text;
ii. Paragraph – a question that can be answered in a long text;
iii. Multiple Choice – a question that can be answered by only one answer in a set of options;
iv. Checkbox – a question that can be answered with multiple answers in a set of options;
v. Dropdown – similar to multiple-choice question but the options are revealed in a drop-
down list;
vi. File upload – allows the person answering the form to upload a file;
vii. Linear Scale – a question that can be answered with a numerical range (e.g., 1-5, 1-10);
viii. Multiple Choice Grid – a question that contains sub-questions with similar options (see
below);
ix. Checkbox Grid – similar to the multiple-choice grid but the answer can be more than one;
x. Date – a question that can be answered with a specific date; and
xi. Time – a question that can be answered with a specific time.
5. Once you are done editing the question, you may click another item. Google Forms will automatically
save your form as long as you have internet connection.
6. To add a new question or item, click on the Add Question button on the sidebar.
7. Click the send button on the upper right corner. The send form dialog box will appear. Edit these as
you see fit.
a. Collect email addresses – requires the person who answered the form to input their own Email
address so you can easily contact them.
b. Send via:
1. Email – send the form via email. Simply input the email address, subject, message and
specify if you want to include the form in the email.
2. Link – contains the URL of the form that you can share on your website or via private
message;
Shorten URL option – generates a shorter link necessary for limited spaces like sharing on
Twitter;
3. Embed HTML – contains an embedded code that you can attach to your html file.
Found in the upper corner of the Google Forms interface are even more optons:
1. Customizer Theme – changes the header, font style, and theme and background color of the form;
2. Preview – shows you how the form will look like to someone who will answer it;
3. Settings – additional settings for you form which include the following tabs;
i. General – options involving the person who will answer the survey;
ii. Presentation – options involving how the form will look;
After a set amount of time, you may want to use this data in a spreadsheet and eventually create your
own charts.
6. You may now create chart for your numerical data in either Google Sheets or Microsoft Excel. Note
that you must be online to use Google Sheets.
Tip: Google Sheets are automatically saved when the Internet connection is
constant.
Reference
Checkpoint
1. Enumerate the user feedback that you believe can be useful in improving your campaign. Use this
information to improve the website.
2. Monitor the success of your [Link] petition by looking at the number of signature it has. See if
this increase coincides with your actions to promote and improve your website.
3. Continue to promote your website using online and print ads through Facebook campaigns blog posts,
and sharing.
4. Send me an E-mail if you have done so.
1. Were all the comments useful for your site’s visitors? Why or why not?
2. What are the best features of your site as commented by your visitors?
Assessment
Create a report through a Microsoft PowerPoint Presentation about your campaign’s success. Talk about the
different websites and online apps that you used and how each of them became an essential part of your
campaign. Add screenshots and break down every detail that has made this campaign possible. Send it to my
E-mail account.
Lesson: 15
Learning Module 15: The Disadvantages of ICT
Content Standards:
The learners demonstrate an understanding of how to reflect on the nature of ICT and the manner by which
the learning process has changed his/her world view.
Performance Standard:
The learners shall be able to:
at the end of the week independently reflect on the ICT learning process and how his/her world view has
evolved over the past semester
Outputs during this week may be in the form of, but not limited to:
1. Video blog
2. Presentation or image gallery
3. Website
4. Illustrated document
5. Podcast or webcast
Learning Competencies:
The learners create a reflexive piece or output using an ICT tool platform, or application of choice on the
learning experience undergone during the semester.
Overview
Good day, student! In various aspects, ICT and technology as a whole brought us comfort and convenience in
life. We, as a Filipinos, have been known to be avid users of technology. Some even made a name as an
Internet sensation. However, aside from those successes are the downfalls of users.
Discussion
Walking on a sidewalk does not pose danger as opposed to walking in the middle of the street.
Remove the sidewalk and you are left to dodge approaching vehicles. That is probably how much of us deal
with the Internet. In the Internet, there are no sidewalk; just a huge superhighway where information freely
flows through. If in the real world we have the police or the military to monitor us, the Internet is unmonitored,
making it one of the most abused technology we use.
Cybercrimes
Cybercrimes are illegal acts done through the use of the Internet. In 2012, Stephen Nale ([Link])
posted a list of ten most common Internet cybercrimes as follows:
1. Phishing/Spoofing – thee act of sending multiple emails to multiple users in hopes of having a number
of them clicking on the links or malwares attached to the email. Most email services today have spam
or bulk folders that automatically put these suspicious emails to that folder. However, it is not 100%
accurate that some emails are not filtered and some other emails that are legitimate end up on the
spam folder.
2. Blackmail/Extortion – the act of using the Internet to threaten or damage someone’s reputation to
export money or anything else of value. This can be avoided if you are aware of what you should post
on the Internet. The victims of this act tend to have posted something “inappropriate” over the Internet
even if they put it at a secured location.
3. Accessing Stored Communications/Hacking – the act of obtaining unauthorized access to data from a
computer network. This is typically done to commercial and government sites to threaten its owner. In
late 2014, a group of hackers hacked Sony’s website because of the impending release of the
controversial film “The Interview”.
4. Sports Betting – the act of wagering on any sports event on the Internet. In some countries, gambling
(including sports betting) is illegal even if you are doing it on the Internet.
©All Rights Reserved
Issue No.: 1 Page 194 of 189
ST. THERESE-MTC COLLEGES
Iloilo City, Philippines ICT 011
(EMPOWRMENT TECHNOLOGY)
Revision No.: Effectivity Date: STUDENT LEARNING MODULE
1 August 10, 2020 Reviewed by: Approved by:
_________________________ _________________________
GEMMA E. PAGSUGIRON, MBA MA. TERESA S. SARABIA, Ph.D.
QMR President
5. Non-Delivery of Merchandise – the act of devising a scheme wherein a culprit posts an item or
services for sale on the Internet and once the transaction has been done, does not really give the item
or service.
6. Electronic Harassment – the act of anonymously using the Internet to harass, abuse, threaten, or
annoy other people. This is also an act of cyberbullying, however, because the culprit is anonymous, it
is hard to detect who is bullying you.
7. Child Pornography – the act of using the Internet to show child pornography. This act is highly
punishable by law.
8. Prostitution – the act of using the Internet to engage in prostitution;
9. Drug Trafficking – the act of selling illegal substances by using the Internet;
10. Criminal Copyright Infringement – the act of piracy mainly for financial gain. In late 2014, the number
one pirate website, ThePirateBay, was raided for the second time due to years of pirating movies,
music, games, book, and other software. The kinds of websites earn money through advertising.
The Internet is the present and the future of your generation and you will define what impact it can do to shape
our society, whether it is negative or positive. The future is in your hands.
Combating Cybercrimes
There are several ways the authorities can help solve or prevent cybercrimes. Here are some of them:
1. Network Security. Before a hacker can get through the authorized files he or she is targeting, the
hacker has get through several security measures like firewalls, secure connections, passwords, anti-
malwares, and data encryptions. Encryption is the process of converting raw data into code. However,
these methods are not 100% secure and there will always be a way for a hacker to hack.
2. Investigation. URL tracing and logging are used by websites to track your unique IP addresses. This
can be used by investigators to trace hackers. In piracy, trackers are used to identify IP addresses
currently sharing a pirate file.
3. Penalties. More and more laws are being created and implemented today. Penalties include both fine
and imprisonment.
Reference
Checkpoint
As responsible users’ technology, we should be aware of the limitations of using the Internet.
1. Form a group of three members.
2. Write the Internet crimes that are rampant today.
3. Research on the punishments for the said crimes and discuss among yourselves if these punishments
are fair or not.
4. Try to revise these punishments as you see fit.
5. Send your output to my E-mail account.
1. What are other cybercrimes that were not discussed in this lesson do you think students of your
generation should be aware of? Why?
Assessment
Make a final video blog post about everything you have learned about ICT and its possible impact to our
society. Talk about its positive and negative impacts and the youth’s role in promoting its responsible use.
Interview your classmates and other school personnel about it. Send your video on my E-mail account.