ICT201 Learning Packet - 1st Quarter SY 2022-2023
ICT201 Learning Packet - 1st Quarter SY 2022-2023
ICT201 Learning Packet - 1st Quarter SY 2022-2023
MATH/ICT
9 weeks
References: Instructor:
Callo, E. (2017) SCIENCE IN TODAY’S Alexandro Gabriel S Cipriano
WORLD FOR SENIOR HIGH SCHOOL Dyan Fe D Mercado
EMPOWERMENT TECHNOLOGIES, Sibs Jonathan A Piguerra
Publishing House
XUSHS Faculty, Microsoft Teams
Juanillo, M. and Tan, E. (2017) E-Tech Xavier University Senior High School
TECHNOLOGY EMPOWERMENT IN A Masterson Avenue, Pueblo,
CONNECTED, DIGITAL WORLD, Cagayan de Oro City
TechFactors Inc.
E-mail address:
[email protected]
[email protected]
[email protected]
Consultation Schedule:
8:00AM - 5:00PM
Written Works:
Written works constitute long tests, post-tests, quizzes, seatworks, assignments, or any written
activity. These will be given depending on the need and will be usually scheduled. Questions for
quizzes are usually exercise questions or applications to practice the concepts learned but will
sometimes be “objective” type. They may be held before or after the lecture or activity, so
students are held responsible to study and be prepared. Assignments or homework are given with
the intention of encouraging self-study among students, not just to review their lecture notes but
also to pursue skills development not readily acquired during class hours or learning time
Performance Tasks:
Performance tasks (PT) are given or announced to students one month before the assigned
schedule for PT week. Ample time is given so that students can prepare well.
Quarterly Assessment:
There are two major exams for quarterly assessment: Midterm and Final. Delayed exam will be
given within one week after the scheduled examination. There will be no removal examinations.
Reading Assignments:
Students are expected to read all required material(s) given by the teachers. One must refer to the
topics in the course outline.
Non-regular Activity:
During the cautious return to on-campus learning and depending on the availability of facilities
some class periods may be spent in the Audio-Visual Room for other instructional modes like
video-showing, PowerPoint presentations or multi-media activities
Class Decorum:
For virtual classes, students are expected to observe netiquette. Taking down notes is an
integrated function of every student as well as studying and participating in class. For students
who cannot join the virtual classes, they will have to do the tasks on their own, following the
prescribed Learning Time.
GENERAL OBJECTIVES:
This course expect students to acquire a good foundation on the basic principles of Information
and Communication Technology and develop their skills in planning, designing and
implementing ICT project for social change, The students enrolled in this E-Tech course are able
use ICT as a tool for curating, contextualizing, collaborating, and creating content and
experience learning in their specific professional track through appreciating the significance and
application of the subject matter in the modern world.
Duration: 10 Weeks (1st Quarter)
1 Subject Orientation /
Written Works
August 8 – August 12 Introduction to ICT 201
3 Advanced Productivity
Tools - MS Word, MS Written works
August 22 – August 26
Excel,
4 Advanced Productivity -
Mini Task 1
August 29 – September 2 MS Powerpoint
5
MIDTERM EXAM
September 5 – September 8
6
Principles of Graphics and Written Works
September 12 – September Information Design Mini Task 2
16
7
Online Platforms & Online Written Works
September 19 – September Publishing Mini Task 3
23
8
Online Presence & Web
September 26 – September Written Works
Statistics
30
9
PT WEEK
October 3 – October 7
10
FINAL EXAM
October 10 – October 14
Essential Topics
Learning Objectives
References:
Juanillo, M. and Tan, E. (2017) E-Tech TECHNOLOGY EMPOWERMENT IN A
CONNECTED, DIGITAL WORLD, TechFactors Inc.
Callo, E. (2017) SCIENCE IN TODAY’S WORLD FOR SENIOR HIGH SCHOOL
EMPOWERMENT TECHNOLOGIES, Sibs Publishing House
PERFORMANCE TASK
6
By the end of the quarter, you are expected to show the following as Performance Task:
As the digital marketing team of a local NGO, you are to create an online information awareness
on a social issue you have identified to be of relevance with the current social climate.
Your team will be responsible for creating social media accounts, multimedia, and other ICT
content to be used in this campaign. You are to use online platforms in marketing the materials
you have created along with other related content about the advocacy you have created. Your
team will present your project during the annual Social Development Week of Xavier University
to help raise awareness among students and young professionals on the chosen social issue.
Your team will be rated according to the use of online platforms, creation of related ICT
materials, reliability of data presented in your booth, as well as the efficient use of graphics and
information design.
To help you acquire the necessary skills in creating your Performance Task, the following the
expected output in this module. Manage your time well and observe the Learning Time below.
PRE-TEST
Let us find out how much you already know about this subject. Encircle the letter that you think
best answers the question. Try to answer as much as you can without skipping the items.
1. It is defined as the ability to use digital technology to access, manage and create
information.
A. Empowerment Technology
B. Multimedia
C. Information and Communications Technology
7
D. Technology Literacy
2. What skill refers to the use of digital technology, communication tools, and/or networks to
define an information need, evaluate information or knowledge, and be able to communicate
this information to others?
A. Empowerment
B. Information Literacy
C. Information and Communication Technology
D. Technology Literacy
3. It is a category of multimedia where the user experiences an immersive environment like the
real-world using technology.
A. Edutainment
B. Entertainment
C. Virtual reality
D. Public access of information
4. What do you call a trend in multimedia that uses technology to help the public in accessing
information like maps and transport schedules?
A. Connectivity and multimedia
B. Interactive public spaces
C. Real-time production
D. Wearable technology
5. A common habit of student researchers is looking only on the first page results of a search
engine. What research skills should students develop to avoid this?
A. Being Patient
B. Using Networks
C. Asking Good Question
D. Going Beyond the Surface
6. Which online research criteria is satisfied when a student verifies the information they found
online if it came from a trusted online source?
A. Authority
B. Currency
C. Scope
D. Security
8. The following are reasons why contextualized research is important when researching online
EXCEPT ONE.
A. To verify information
B. To interpret existing facts
C. To discover new information
D. To revise accepted knowledge considering newly discovered facts
9. Which of the following is NOT considered when creating an effective slide presentation?
A. Keeping it simple
8
B. Using High-quality graphics
C. Choosing hard to read fonts
D. Using custom templates
10. Is it okay to use bullet points and fill most of the slides with text in a presentation?
A. No, you should use numbers and texts instead of bullet points
B. No, it strains the eyes of the viewers and bores the audiences
C. Yes, PowerPoint is built to be like that
D. Yes, it will make your life easy especially in creating a presentation
9
MODULE 1
E-TECH: Empowering People and Affecting Social Change
I. CONTEXT
The 21st cent
development of different technologies that have helped people accomplish tasks
in a more effective and efficient way. A common example is the use of smartphones for
communication via text messaging, voice chat, or video call. You can even use smartphones to
access applications you need for school, work, or even your daily tasks like buying groceries.
Instruction: If internet access is available, open your internet browser and watch this short video
about the history of communication technologies. https://youtu.be/LXMgShxJOBc
source: https://www.eedesignit.com/wp-content/uploads/2018/01/technology-milestones-timeline.jpg
10
NAME:
SECTION:
Process Questions:
1. Describe the pace of the evolution of communications technology as described in the
image above.
2. What do you think is the most important change that the internet has contributed to our
society in the past year?
Student’s responses:
11
Learning Objectives:
In these lessons, you will learn to:
• Discover how technology can empower individuals.
• Identify recent social issues related to empowerment technologies.
• Use advanced productivity tools in developing a project.
• Apply the concepts and skills in contextualized research in making a PowerPoint
Presentation in accordance with its purpose.
Evidence of Learning
You are expected to show the following as evidence of learning at the end of the module:
• Identify areas where ICT is being used for people empowerment.
• Research and collect information/data about a social issue and provide reliable sources.
• Present the collected data using productivity tools (MS Office Applications).
By the end of the module, you are expected to show the following scaffold to the Performance
Task:
MINI TASK 1
MS Word: Use the mail merge function to create invitation letters to key guests to appear in
your project.
MS Excel: Generate a financial budget plan for your proposed project using MS Excel that
utilizes the following: Functions, Formulas, Filtering, and Charts.
MS Powerpoint: Create a pre-recorded Powerpoint Presentation that would introduce your
advocacy to the public and catch their attention to support your project.
12
II. EXPERIENCE
LESSON 1: Introduction to Empowerment
Technology
Let us begin with familiarizing ourselves with ICT
“ICT is a broad subject and the concepts are evolving. It covers any product that will store,
retrieve, manipulate, transmit, or receive information electronically in a digital form (e.g.,
personal computers, digital television, email, or robots). Theoretical differences between
interpersonal-communication technologies and mass-communication technologies have been
identified by the philosopher Piyush Mathur. Skills Framework for the Information Age is one of
many models for describing and managing competencies for ICT professionals for the 21st
century.”
Source: https://www.tutor2u.net/business/reference/what-is-ict
Empowerment Technology
The process of giving yourself, or other refers to computer technology that we use
13
people, the capacity to achieve a specific almost every day, which enables us to do
end-goal tasks that, in the past, requires professional
help
Empowerment Technology is a strategy that aims to give individuals the tools and resources
necessary to take initiative, gather, and analyze information
or situations.
understands, evaluates, uses, and determines the ability to use digital technology to
the needed information effectively and access, manage and create information.
efficiently.
Likewise, empowerment technology refers to computer technology that we use almost every day,
which enables us to do tasks that, in the past, required professional help. Consider the following
examples. How does technology empower each individual? Other than the target outcome, what
other results are achieved through the use of technology?
● a fifteen-year-old owner of a bakeshop wanted to sell her cookies online. Knowing that
web development is a complex subject, she checked online for a free website creation
tool. She found WiX and she was able to put up her own website in just an hour.
● The student council wanted to create a video for their upcoming fundraising project.
When they asked for help from videographers, they were surprised at the cost given to
them. So, the council decided to find a video creation tool online. They tried Powtoon
and they were able to produce a video in a day.
● A businessman is running late for a meeting. To find the fastest route from his office to
his home he uses Waze and he is able to tell his estimated time of arrival to the people
waiting for him at the office.
Nowadays, there are applications that can be accessed and used for free.In the examples given
each individual is able to solve his or her problem with little to no cost, lesser time, and lesser
effort.
14
Activity 1: Definition of terms
Instruction: Use the internet or other reference material and provide the definition of the items
below and give an example how it is currently being used.
4. Data Services -
Emerging Technologies
1. AI (Artificial Intelligence) –
3. VR (Virtual Reality) –
4. AR (Augmented Reality -
15
In summary, many technologies are used in people empowerment. These technologies
work together to help us have a better and more efficient society. With ingenuity and creativity,
we can find new ways in using these existing technologies or even create new technologies that
will allow us to contribute to our society’s progress.
Study the list below. What other examples can you add for each aspect?
16
Technology Trends
According to an article from Forbes.com, these 25 technological trends will define the next
decade:
15. 5G
16. Genomics and gene editing
17
NAME:
SECTION:
ICT
NAME:
SECTION:
18
Activity 3: Reflect on your own skills. Review this from UNESCO. Mark the ones you think
you are capable of.
Activity 4: Identify social issues in your community. In this chart, list down some issues or
challenges that you can observe in your community or locality and take note of the individuals or
groups affected by each. Reflect and write on why you want to address each issue or challenge
you have noted.
Social Issue Who is affected by the issues? Why do I want to address this
issue?
19
Process Questions:
1. How important do you think these skills are in this time of pandemic?
2. Describe the role of ICT in our post-COVID pandemic society?
Student’s responses:
20
LESSON 2: Contextualized Online Research
In the previous lesson, you have learned of the importance of ICT and how it can empower us as
individuals. As a student, you are regularly searching for information online and offline, or in
other words, you regularly perform research. With the technology we have today, it is possible
for us to collate large amounts of information in a short span of time and at the same time
encounter information that otherwise can be considered falsified. In this lesson we will learn
about how to efficiently use the internet in researching online as well as some tips to help us
avoid unreliable data.
Research
Topic
1. 1.
2. 2.
3. 3.
4. 4.
5. 5.
21
Contextualized search can be defined as a skilled or optimized way of searching the Internet
based on the “context” provided, therefore narrowing down the results given back to you by the
search engine (Feldman, 2012). This increases the chances of you receiving the most appropriate
reply to your query.
In our world of expanding access to the internet, research has become a common term that is
used when looking for something online. Whether you search for a definition of a word you
don’t know, look for sales online, or for a recipe for food you line, it is now considered
“research”.
Committing errors when searching for information such as these does not matter much because it
generally does not affect other people. This kind of research is called personal research. The
research we do in schools, on the other hand, is called professional research.
Research Skills I Need to Develop. Searching for answers to questions you have for your
project requires more than just a simple Google search. You need to have proper skills that will
enable you to gather useful and credible information online. According to Scholastic, the
following are the online research skills students need. (Hudson, 2017)
22
1. Check Your Sources
The Skills: Developing and refining search queries to get better research results
The Challenge: Students will enter a search term, say, “Abraham Lincoln,” and comb
through pages of results that aren’t related to their research (think Lincoln beards, Lincoln
Logs), rather than narrowing their original query (“Lincoln assassination”).
The Solution: Give small groups three search terms each, ranging from the general to the
specific (e.g., “national parks,” “Yellowstone,” and “Yellowstone founding date”). Ask the
groups to record how many results are returned for each term. Discuss how specificity can
narrow their search to the results they need. Next, challenge groups to come up with three
alternate search terms for the most specific item on their lists. (For the Yellowstone example,
alternate terms might include “When was Yellowstone founded?” “history of Yellowstone”
and “Who founded Yellowstone?”) Compare the results and discuss how changing a few
words can generate different information.
23
Jonas Brothers or Justin Bieber?” Encourage teams to use a wide variety of sources in
answering their questions, including what others have said, box office receipts, and awards.
Determine a winner based on which team presents the most convincing case.
5. Respect Ownership
6. Use Your Networks
The Skill: Using social networks and information tools to gather and share information
The Challenge: Some kids do not understand the line between sharing information and
plagiarizing it. A survey by plagiarism-prevention firm Turnitin found that the most widely
used sources for cribbed material are sites like Facebook, Wikipedia, and Ask.com.
The Solution: Talk to kids about when you might use social sites for research. Provide a list
of topics and have partners decide whether it would be a good idea to use these tools.
Suggested topics: your family’s countries of origin, the life of Alexander the Great, and the
events of September 11, 2001. What could members of your network contribute to each of
these discussions? How wouldn’t they be helpful? How would you include information that
friends and family share in your work?
Also explain that Wikipedia must be evaluated like any other website. Students should focus
on the sources cited in a Wikipedia article and ensure these sources are legitimate. You might
have small groups analyze all of the sources for one Wikipedia article for currency, authority,
scope, and security. Emphasize that it is usually better to go back to the original source than
to quote directly from Wikipedia.
Source: https://www.scholastic.com/teachers/articles/teaching-content/6-online-research-skills-your-students-need/
Search Engines:
- Google (www.google.com)
- Bing (www.bing.com)
- Duckduckgo (www.duckduckgo.com)
Digital Libraries
- JSTOR (www.jstor.org)
- SciELO (http://scielo.org)
- Google Books (books.google.com)
24
The XU SHS Library also has an extensive collection of books, publications, articles, tools and
other resources that can help you with your research. They can provide you with a copy digitally
or borrow the materials in person. (http://shs.library.xu.edu.ph)
25
NAME:
SECTION:
Activity 2: Online data gathering. Using online search tools, collect the required information
about your social issue as indicated in the table below. Your search results must fall in the
following criteria:
- the article/paper is not older than 10 years
- your article/paper must have the author’s name and the date it was published
Publish
Title of Article Author Date Link to article
1.
2.
3.
4.
5.
C. Search for statistical data related to your advocacy. It can be in the form of graphs,
charts, or visualization of collected data.
26
Process questions:
1. Do you think you possess all the online research skills stated above?
2. Which of the online skills mentioned do you think you need to develop the most?
3. How does social networking help you in acquiring new information in your daily life?
Student Responses:
27
Lesson 3: Advanced Productivity Tools -
Microsoft Powerpoint
In this lesson, you will learn additional tips on how to use advanced features of MS Office
applications that we can use in our future profession..
Let us make an assessment of Word tools and know which features you have used before, check
all that are familiar to you in the table below.
28
These features are:
● References: Citation and Bibliography
● Review: Tracking Changes
● Mail Merge
Word automatically generates a bibliography from the sources you used to write your paper.
Each time you add a new citation to your document, Word adds that source so that it appears in
the bibliography in the proper format, such as MLA, APA, and Chicago-style.
2. Click the style that you want to use for the citation and source.
3. Click at the end of the sentence or phrase that you want to cite.
4. Click Insert Citation and then select Add New Source.
5. In the Create Source box, type in the citation details, and then click OK.
When you've completed these steps, the citation is added to the list of available citations. The
next time you quote this reference, you don't have to type it all out again, just click Insert
Citation and select the citation you want to use.
29
Create a bibliography from your sources
If you want to create a bibliography from your sources, do the following:
1. Click where you want to insert a bibliography. Typically, they are at the end of a
document.
2. On the References tab, in the Citations & Bibliography group, click Bibliography.
Similar to the Table of Contents builder in Word, you can select a predesigned bibliography
format that includes a title, or you can just click Insert Bibliography to add the citation without
a title.
If you want to learn more about using citation placeholders and editing sources, take a look at
Create a bibliography. Or, if you want to export your bibliography sources to another computer,
check out this post on the Microsoft Word blog.
30
● On the Review tab, go to Tracking and select Track Changes.
○ When Track Changes is on, deletions are marked with a strikethrough, and
additions are marked with an underline. Different authors' changes are indicated
with different colors.
○ When Track Changes is off, Word stops marking changes, but the colored
underlines and strikethrough from your changes remain in the document until
they're accepted or rejected.
31
○ Select the type of change that you want to display.
Important: Even if you hide a type of markup by clearing it on the Show Markup
menu, the markup automatically appears each time the document is opened by
you or a reviewer.
○ Point to Specific People, and then clear all check boxes except the ones next to
the names of the reviewers whose changes and comments you want to show.
Note: To select or clear all check boxes for all reviewers in the list, select All
Reviewers.
The Reviewing Pane also allows you to read long comments that don't fit within a comment
bubble.
By default, the Reviewing Pane shows at the top how many total revisions are in the document.
To see the number and type of the changes, select the carat next to the number of revisions.
32
Review each tracked change in sequence
1. Click or tap at the beginning of the document.
2. On the Review tab, go to Changes.
3. Select Accept or Reject. As you accept or reject changes, Word will move to the next
change.
4. Repeat until there are no more tracked changes or comments in your document.
33
○ Point to Specific People, and then clear all check boxes except those next to the
names of the reviewers whose changes you want to see or choose All Reviewers
to select or clear the check boxes for all reviewers in the list.
4. On the Review tab, go to Changes.
5. Select Accept or Reject. As you accept or reject changes, Word will move to the next
change.
Delete comments
1. Select a comment.
34
2. On the Review tab, go to Comments, and select Delete.
Before you begin, open a blank document in Word and type the body of the email message you
want to send.
35
The mailing list is your data source.
● If you don’t have a mailing list, you can create one during mail merge.
● If you're using an Excel spreadsheet, format the ZIP Codes or postal codes column as text
to preserve any zeros. For more info see
● If you want to use your Outlook contacts, make sure Outlook is your default email
program and the same versions as Word.
You can add other fields from your data source to your email message.
To change the font, size, or spacing of the merged content, select the merge field name and make
the changes you want.
3. In the To box, choose the email address column or field from your mailing list.
Note: Word sends an individual message to each email address. You can’t Cc or Bcc
other recipients. You can include links, but you can’t add attachments to the email.
4. In the Subject line box, type a subject line for the message.
5. In the Mail format box, choose HTML (the default setting) or Plain text to send the
document as the body of the email message.
6. Under Send records, use one of the following:
○ All records (default).
○ Current record only the record viewable on your screen is sent the message.
○ From and To send only a range of records.
7. Choose OK to run mail merge.
36
Step 6: Save the personalized message
Go to File > Save. When you save the main document, you also save its connection to the data
source. To reuse, open the document and answer Yes when prompted to keep the connection to
the data source.
Explore:
Below is a scenario for you to explore. In a cooking show, there are
two finalists vying for the title “Master Pastry Chef”. The organizers of the show invited five
Filipino cuisine exports to judge who deserved the title and they also invited you and your friend
to supervise and tally the scores. Help determine the winner by computing the total scores based
on weighted criteria. Do this manually and take note how long it took you to complete.
Contestant #1 Contestant #2
1 9 8 8 9 7 8
2 8 8 8 8 9 8
3 9 7 8 8 9 9
4 9 9 9 9 8 9
5 8 8 9 8 9 9
Total
Based on your computation, who is the winner? How many minutes did it take you to finish the
computation?
Computing data, especially large amounts of it, might take a lot of time and effort to do
manually. It is time consuming and requires a lot of effort. Electronic spreadsheets, such as MS
Excel, were created to allow us to complete tasks such as these in a faster and more efficient
manner.
Formulas and Functions
Some of the often-used features in Excel are in the Formulas tab. Excel uses standard
mathematical operators for formulas:
+ addition
- subtraction
37
* multiplication
/ division
^ exponents
You must also remember that the equals sign (=) must be entered first to start using a formula.
Complex formulas follow the PEMDAS rule.
You can create a simple formula to add, subtract, multiply or divide values in your worksheet.
Simple formulas always start with an equal sign (=), followed by constants that are numeric
values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/)
signs.
Functions
A function is a predefined formula in Excel that performs calculations for a specific value using
reference cells. Excel has different functions for various operations. Let use review the parts of a
function below.
There are numerous functions defined in Excel, but we will focus on the following common
functions.
1. Sum - this function adds all the values of cells in the argument
2. Average - this function will get the average of all the values of cells in the argument
3. Count - this counts the number of cells with numerical data in the argument
4. Max - this function gets highest cell value in the argument
5. Min - this function gets lowest cell value in the argument
38
3. Select a cell or type its address in the selected cell.
6. Press Enter. The result of the calculation appears in the cell with the formula.
View a formula
1. When a formula is entered into a cell, it also appears in the Formula bar.
2. To see a formula, select a cell, and it will appear in the formula bar.
Types of sorting
Sort sheet - sort all data in your worksheet by one column. Related information is kept together
when sorted. An example of this is a list of students to be arranged according to their class
number.
Sort Range - sorts the data in a range of cells, which can be helpful when working with a sheet
that contains several tables. Only the contents of the table will be sorted. Sorting a range will not
affect other content of the worksheet.
Sort text
1. Select a cell in the column you want to sort.
2. On the Data tab, in the Sort & Filter group, do one of the following:
○ To quick sort in ascending order, click (Sort A to Z).
○ To quick sort in descending order, click (Sort Z to A).
Sort numbers
1. Select a cell in the column you want to sort.
2. On the Data tab, in the Sort & Filter group, do one of the following:
○ To sort from low to high, click (Sort Smallest to Largest).
○ To sort from high to low, click (Sort Largest to Smallest).
39
Sort by more than one column or row
You may want to sort by more than one column or row when you have data that you want to
group by the same value in one column or row, and then sort another column or row within that
group of equal values. For example, if you have a Department column and an Employee column,
you can first sort by Department (to group all the employees in the same department together),
and then sort by name (to put the names in alphabetical order within each department). You can
sort by up to 64 columns.
Note: For best results, the range of cells that you sort should have column headings.
1. Select any cell in the data range.
2. On the Data tab, in the Sort & Filter group, click Sort.
3. In the Sort dialog box, under Column, in the Sort by box, select the first column that
you want to sort.
4. Under Sort On, select the type of sort. Do one of the following:
○ To sort by text, number, or date and time, select Values.
○ To sort by format, select Cell Color, Font Color, or Cell Icon.
40
5. Under Order, select how you want to sort. Do one of the following:
○ For text values, select A to Z or Z to A.
○ For number values, select Smallest to Largest or Largest to Smallest.
○ For date or time values, select Oldest to Newest or Newest to Oldest.
○ To sort based on a custom list, select Custom List.
6. To add another column to sort by, click Add Level, and then repeat steps three through
five.
7. To copy a column to sort by, select the entry and then click Copy Level.
8. To delete a column to sort by, select the entry and then click Delete Level.
Note: You must keep at least one entry in the list.
9. To change the order in which the columns are sorted, select an entry and then click the
Up or Down arrow next to the Options button to change the order.
Entries higher in the list are sorted before entries lower in the list.
How can you sort so that rows containing High appear first, followed by Medium, and then
Low? If you were to sort alphabetically, an “A to Z” sort would put High at the top, but Low
would come before Medium. And if you sorted “Z to A,”
Medium would appear first, with Low in the middle. Regardless of the order, you always want
“Medium” in the middle. By creating your own custom list, you can get around this problem.
41
1. Optionally, create a custom list:
1. In a range of cells, enter the values that you want to sort by, in the order that you
want them, from top to bottom as in this example.
2. Select the range that you just entered. Using the preceding example, select cells
A1:A3.
3. Go to File > Options > Advanced > General > Edit Custom Lists, then in the
Custom Lists dialog box, click Import, and then click OK twice.
Notes:
■ You can create a custom list based only on a value (text, number, and date
or time). You cannot create a custom list based on a format (cell color,
font color, or icon).
■ The maximum length for a custom list is 255 characters, and the first
character must not begin with a number.
2. Select a cell in the column you want to sort.
3. On the Data tab, in the Sort & Filter group, click Sort.
4. In the Sort dialog box, under Column, in the Sort by or Then by box, select the column
that you want to sort by a custom list.
5. Under Order, select Custom List.
6. In the Custom Lists dialog box, select the list that you want. Using the custom list that
you created in the preceding example, click High, Medium, Low.
7. Click OK.
42
Filtering
One of the features of Excel is to narrow down data in your worksheet, allowing you to view
only the information you need. This feature is called Filter.
43
1. Select the column header arrow for the column you want to filter.
2. Uncheck (Select All) and select the boxes you want to show.
3. Click OK.
The column header arrow changes to a Filter icon. Select this icon to change or
clear the filter.
Charts
Sometimes, it is difficult to interpret Excel workbooks which have a lot of data. A chart is a
graphical representation of your workbook data that’s easier to visualize for comparisons and
trends.
Create a chart (graph) that is recommended for your data, almost as fast as using the chart wizard
that is no longer available.
Create a chart
1. Select the data for which you want to create a chart.
2. Click INSERT > Recommended Charts.
3. On the Recommended Charts tab, scroll through the list of charts that Excel
recommends for your data, and click any chart to see how your data will look. If you
don’t see a chart you like, click All Charts to see all the available chart types.
4. When you find the chart you like, click it > OK.
5. Use the Chart Elements, Chart Styles, and Chart Filters buttons, next to the upper-
right corner of the chart to add chart elements like axis titles or data labels, customize the
look of your chart, or change the data that is shown in the chart.
6. To access additional design and formatting features, click anywhere in the chart to add
the CHART TOOLS to the ribbon, and then click the options you want on the DESIGN
and FORMAT tabs.
44
Creating a Gantt chart in MS Excel
A Gantt chart is a type of bar chart that illustrates a project schedule, named after its inventor,
Henry Gantt, who designed such a chart around the years 1910–1915. Modern Gantt charts also
show the dependency relationships between activities and the current schedule status. This is
commonly used in showing project timelines and milestones to keep everyone on track.
Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by customizing the
stacked bar chart type. Below you can find our Gantt chart data.
Result:
45
4. Enter a title by clicking on Chart Title. For example, Build a House.
5. Click the legend at the bottom and press Delete.
6. The tasks (Foundation, Walls, etc.) are in reverse order. Right click the tasks on the chart,
click Format Axis and check 'Categories in reverse order'.
Result:
46
7. Right click the blue bars, click Format Data Series, Fill & Line icon, Fill, No fill.
8. Dates and times are stored as numbers in Excel and count the number of days since January 0,
1900. 1-jun-2017 (start) is the same as 42887. 15-jul-2017 (end) is the same as 42931. Right
click the dates on the chart, click Format Axis and fix the minimum bound to 42887, maximum
bound to 42931 and Major unit to 7.
47
Result. A Gantt chart in Excel.
Note that the plumbing and electrical work can be executed simultaneously.
TRY IT OUT. Download the Excel worksheet template here and try out the various features of
MS Excel. (link to be inserted)
48
HOW CAN I RECORD MY PRESENTATION IN MS POWERPOINT?
In the previous section, we learned advanced MS Excel tools that enabled you to process the data
you gathered and present these using charts and graphs. In this lesson, we will use Powerpoint to
create an effective presentation and also record them for online viewing.
PowerPoint comes with a built-in, no-nonsense screen recorder. There are a lot of things that
PowerPoint’s screen recorder cannot do that more full-featured screen recording software can,
but that is the beauty of it—it is great for a quick, no-fuss recording.
First, open PowerPoint, head to the “Insert” tab, and then click “Screen Recording.”
49
PowerPoint will minimize, and the screen recording dock will appear at the top of your screen.
Here’s where the “simplicity” of PowerPoint’s screen recording feature comes in—you only
have five options. By default, PowerPoint will record audio and your cursor. Toggle these
options to disable them if you want. When you’re ready to move on, click “Select Area.”
Your pointer will turn into a crosshair. Click and drag to select the area of your screen you want
to record.
50
Next, click the “Record” button in the screen recorder dock.
A three-second countdown will begin. Once it reaches zero, your recording will begin. When you have
finished recording everything, move your cursor back to the top of the screen where the dock was, and the
dock will reappear. Click “Stop.” Your screen recording will now appear in your PowerPoint slide.
51
The “Trim Video” window will appear. Here, click and drag the green and red bars to adjust the start and
stop time, respectively. Once you have set this up, click “OK.”
o In Click Sequence: The video will play in the appropriate order you have set in terms of
actionable sequences (such as animations).
o Automatically: The video will automatically play when it appears.
o When Clicked On: The video will play when you click on it.
52
Applying Frame Styles
If you want to make your video more visually appealing, you can apply a frame to it. To
do so, right-click the video and select “Style” from the menu.
A sub-menu will appear, presenting a large library of frames for your video. Hovering
over each one will show a live preview of how the frame will look.
Select the one you like, and it will be applied to your video. Try it on your own!
53
Slideshow Recording in Microsoft Powerpoint
Before you get started, make sure the PowerPoint file is saved as recent PowerPoint (PPTX) file.
If the file is a PPT, you may lose recorded audio. To check and fix this (if necessary), choose
SAVE AS, then make sure the format is "PowerPoint Presentation (*.pptx)", not "PowerPoint
97-2003 Presentation." The PowerPoint icon should have a P on it.
To get started recording a presentation, load up your PowerPoint and click the Slide Show tab.
Recording
To get started recording, click the RECORD SLIDE SHOW button. You may be asked whether
you want to start from the current slide or from the beginning of the presentation, make the
appropriate selection depending on where you want to start recording from.
Click the big red button to start recording. You will get a three second countdown, then you can
start talking over your slides. Use the drawing tools at the bottom of the screen to annotate your
slides as you go. Click the onscreen arrow button or the right, down, or space keys on your
keyboard to advance to the next slide. Click the square button to stop recording.
Recording Notes
1. This recording process adds your audio (and video, if you're capturing webcam footage as
well) to the slides themselves. As a result, you can only advance your presentation while
recording. If you're going to want to refer back to a previous slide as part of your
presentation, include that slide twice -- once when it appears naturally, and again when you
want to re-refer to it.
54
2. Because you are recording audio to each slide, talking through transitions between slides
does not work well. Stop and take a breath when advancing to the next slide to avoid audio
issues.
3. If you have got the webcam turned on, your audio will be bound to the video. This means
you will not be able to remove the video from a slide without also removing the audio. If you
just want video on the first couple slides, start the recording with your webcam turned on,
then stop the recording when you want to switch to audio only, turn off the webcam, and start
recording again.
Once you are done recording, click the X button in the upper right corner of the screen or hit the
ESC key on your keyboard to close the recording stage.
At this point, you should save your PowerPoint presentation as you normally would.
If you captured video, you could move the video window around on a slide-by-slide basis
(making sure it does not obscure important content in your presentation). You can style or trim
your media by right-clicking on the media and choosing the appropriate option.
MUTE AUDIO / DISABLE VIDEO / HIDE VIDEO PREVIEW
In the bottom right of the recording stage
are controls for muting audio, turning off
video, and showing or hiding the cam
preview. While recording is in process
(paused counts as still in process) you
cannot switch any of these options except
the cam preview.
55
CLEAR RECORDING FROM A SLIDE / ALL SLIDES
Click the arrow next to the "CLEAR" label in the upper right, then select whether you want to
clear the recording from just the current slide or from all the slides in your presentation.
EXPORT TO VIDEO
Once your recording is done, click FILE, then EXPORT, then choose Create a Video to produce
a video file of your presentation. On the Create a Video page, the file type defaults to Full HD.
We recommend you change to HD (720p) or STANDARD (480p). The smaller the number, the
smaller the file and the less time it will take to render the video. Once you have got your settings
selected, click CREATE VIDEO to start the export process.
56
Be patient. It will take some time create the video. You can track the progress in the bottom right
of your PowerPoint window, just left of the notes button and view selectors. If you want to
cancel the recording process, click the little X button.
Once you have got the video file, you can submit it to Microsoft Teams.
Sources:
https://libraries.udmercy.edu/page.php?item_id=261
https://www.makeuseof.com/tag/record-screen-microsoft-powerpoint/
57
Some tips in Improving your Presentation
Before going any further, here are some tips that can help you improve your Powerpoint
presentation.
1. Keep it simple - complex slide designs tend to distract your audience from what you are
saying and keep them from understanding your message. The less clutter on the screen,
the better.
2. Follow the 5/5/5 rule - To keep your audience from feeling overwhelmed, you should
keep the text on each slide short and to the point. Some experts suggest using the 5/5/5
rule: no more than five words per line of text, five lines of text per slide, or five text-
heavy slides in a row.
3. Know your audience - Who will be watching your presentation? The same goofy effects
and funny clip art that would entertain a classroom full of middle-school students might
make you look unprofessional in front of business colleagues and clients. Humor can
lighten up a presentation, but if you use it inappropriately your audience might think you
don’t know what you’re doing. Know your audience, and tailor your presentation to their
tastes and expectations.
4. Don't read your presentation straight from the slides - If your audience can both read
and hear, it’s a waste of time for you to simply read your slides aloud. Your audience will
zone out and stop listening to what you’re saying, which means they won’t hear any extra
information you include. Instead of typing out your entire presentation, include only main
ideas, keywords, and talking points in your slide show text. Engage your audience by
sharing the details out loud.
5. Choose readable colors and fonts - Your text should be easy to read and pleasant to
look at. Large, simple fonts and theme colors are always your best bet. The best fonts and
58
colors can vary depending on your presentation setting. Presenting in a large room? Make
your text larger than usual so people in the back can read it. Presenting with the lights on?
Dark text on a light background is your best bet for visibility.
6. Don't overload your presentation with animations - As anyone who’s sat through a
presentation while every letter of every paragraph zoomed across the screen can tell you,
being inundated with complicated animations and exciting slide transitions can become
irritating. Before including effects like this in your presentation, ask yourself: Would this
moment in the presentation be equally strong without an added effect? Does it
unnecessarily delay information? If the answer to either question is yes—or even maybe
—leave out the effect.
7. Use animations sparingly to enhance your presentation - Don’t take the last tip to
mean you should avoid animations and other effects entirely. When used sparingly, subtle
effects and animations can add to your presentation. For example, having bullet points
appear as you address them rather than before can help keep your audience’s attention.
Reference: https://edu.gcfglobal.org/en/powerpoint-tips/simple-rules-for-better-powerpoint-presentations/1/
59
NAME:
SECTION:
Process questions:
1. What other ways can you use these productivity tools in your daily lives?
3. What are some alternatives to MS Word, MS Excel, and MS Powerpoint? Give three (3)
examples for each application and provide a link where you can download it.
Student Responses:
60
NAME:
SECTION:
III. REFLECTION
Answer the following questions briefly.
1. Why do you think it is important to know and be aware about emerging technologies?
3. What are the advantages and disadvantages of using the internet as a tool for
information gathering?
4. How can you apply Cura Personalis (care for the entire person) in doing contextualize
online search?
IV. ACTION
61
Mini Task 1: Using MS Office Productivity Tools
For this mini task, discuss with your group and assign each task to one member.
A. MS Word - Create a bibliography using the articles and research paper about your social
issue you have that you have collected in Lesson 2.
B. MS Word - Write an invitation letter to 20 individuals and use Mail Merge to create a pdf
copy of each letter.
C. MS Excel - Create a Gantt chart that shows the timeline and milestones of your project.
D. MS Excel - Create a proposed financial budget for your project. Use functions and
formulas in your spreadsheet.
E. MS Powerpoint - Create a recorded PowerPoint Presentation that would introduce your
advocacy to the public and could grab their attention to support
Your work will be evaluated based on the rubric below. After you are done with your mini task
1, answer the processing questions about your experience.
Required Skill All (4) advanced (3) Advanced Partially applies Very limited in
(Presentation techniques are technique is 2 of the techniques is
Skills) exceptionally exceptionally techniques present in the
applies in the applying in the needed. (6pts) output. (4pts)
presentation. presentation.
(10pts) (8pts)
NAME:
SECTION:
62
Processing Questions:
1. How did you find the mini-task?
2. How did the lessons help you see the real-world use of the topic?
63
You are about to
complete this module.
Kindly answer the post-assessment to
check how well you learned.
NAME:
SECTION:
64
V. EVALUATION
POST-TEST
It’s now time to evaluate your learning. Encircle the letter of the answer that you think best
answers the question. Your score will be disclosed by your teacher during Consultation Periods.
1. It is the ability to use digital technology to access, manage and create information.
A. Empowerment Technology
B. Multimedia
C. Information and Communications Technology
D. Technology Literacy
2. What skill refers to the use of digital technology, communication tools, and/or networks to
define an information need, evaluate information or knowledge, and be able to communicate
this information to others?
A. Empowerment
B. Information Literacy
C. Information and Communication Technology
D. Technology Literacy
3. It is a category of multimedia where the user experiences an immersive environment like the
real-world using technology.
A. Edutainment
B. Entertainment
C. Virtual reality
D. Public access of information
4. What do you call a trend in multimedia that uses technology to help the public in accessing
information like maps and transport schedules?
A. Connectivity and multimedia
B. Interactive public spaces
C. Real-time production
D. Wearable technology
5. A common habit of student researchers is looking only on the first page results of a search
engine. What research skill should students develop to avoid this?
A. Being Patient
B. Using Networks
C. Asking Good Question
D. Going Beyond the Surface
65
6. What online research criteria is satisfied when a student verifies if the information came
from a trusted online source?
A. Authority
B. Currency
C. Scope
D. Security
8. The following are reasons why contextualized research is important when researching online
EXCEPT ONE.
A. To verify information
B. To interpret existing facts
C. To discover new information
D. To revise accepted knowledge considering newly discovered facts
9. Which of the following is NOT considered when creating an effective slide presentation?
A. Keeping it simple
B. Using High-quality graphics
C. Choosing hard to read fonts
D. Using custom templates
10. Is it okay to use bullet points and fill most of the slides with text in a presentation?
A. No, you should use numbers and texts instead of bullet points
B. No, it strains the eyes of the viewers and bores the audiences
C. Yes, PowerPoint is built to be like that
D. Yes, it will make your life easy especially in creating a presentation
66
NAME:
SECTION:
SELF-ASSESSMENT:
Were you
able to
Activity No./ Actual Date of
Lesson complete Reason/s:
Task Completion
the task on
time?
Introduction to
Empowerment
Technology
Activity 2.1
Contextualized
Research
Activity 2.2
67
Reflection
Congratulations!
You have completed Module 1.
You can now proceed to the next module.
68
References
69
2022-2023
70
LESSONS OVERVIEW
In this module, you will take the following topics and you are expected to demonstrate the
following as evidence of learning:
Essential Topics
Learning Objectives
● Be familiar with the basic principles of graphics design and elements that comprise an
effective infographic.
● Discover various applications used in image manipulation and graphics design.
● Use graphic applications in creating visual content.
Evidence of Learning
● Manipulate images and graphic elements to create content.
● Create a visually appealing and content-rich visual material/infographic in relation to
promoting social change.
● Apply the principles of graphics design and elements of an infographic in making an
infographic related to a social issue.
Self-regulated Strategies
● Organizing, categorizing, summarizing, and transforming information
● Time management
● Note taking
● Trial and error / Experimentation
References
Juanillo, M. and Tan, E. (2017) E-Tech TECHNOLOGY EMPOWERMENT IN A
CONNECTED, DIGITAL WORLD, TechFactors Inc.
Callo, E. (2017) SCIENCE IN TODAY’S WORLD FOR SENIOR HIGH SCHOOL
EMPOWERMENT TECHNOLOGIES, Sibs Publishing House
NAME:
SECTION:
71
PRE-TEST
Let us find out how much you already know about this module. Encircle the letter that you think
best answers the question. Please answer all items. After taking this short test, you will see the
answer key. Take note of the items that you were not able to correctly answer and look for the
right answer as you go through this module.
1. What element of design refers to the surface that acts as a virtual container in a layout?
A. Line C. Shape
B. Point D. Space
3. What principle of design refers to the feeling of harmony that is created by all the parts and
elements of a design?
A. Balance C. Rhythm
B. Emphasis D. Unity
4. What principle of design determines which elements within the design are focused on the
most and which ones are given less attention?
A. Balance C. Rhythm
B. Emphasis D. Unity
5. On which of the four (4) elements of a good infographic do virality and enhanced Search
Engine Optimization (SEO) belong to?
A. Data C. Shareabiliy
B. Design D. Story
6. Which type of infographic can be a quick reference for different kinds of information and can
also be of a step-by-step process on how to do things?
A. Cheat Sheet C. Photo Infographic
B. Flowchart D. Visual Article
7. The following are the things to consider when making infographic EXCEPT:
A. Infographic must be creative and innovative.
B. The subject and the main idea must be clear.
C. Infographic must not be full of text to attract readers.
D. Data may not be that organized if it supports the main idea.
8. Your Biology teacher requires a performance task in the form of an infographic wherein
more content in the form of words will be presented. What type of infographic will you
create?
A. Cheat Sheet C. Flowchart
B. Data Visualization D. Visual Article
9. Jefferson has recently joined a weight-loss program to prepare for the annual summer beach
party of his company. He was advised by his training instructor to follow a diet plan to
achieve the desired weight. If Jefferson is to create a graphic plan for his diet, what type of
infographic is the most suitable for this?
A. Cheat Sheet C. Flowchart
B. Data Visualization D. Visual Article
72
10. Mr. Cruz and his friends decide to sell apples and other fruits in his neighborhood. He wants
to see the growth of their earnings since day 1 and show it to his friends without them seeing
the breakdown of their earnings. What type of infographic is the most suitable graphical
representation of their earnings?
A. Comparison C. Numerical
B. Data Visualization D. Visual Article
73
MODULE 2
Creating and Innovating Products and Processes through ICT
I. CONTEXT
In the previous module we learned about the role of ICT in our society, explored different
ways in locating information on the internet, and prepared a presentation for your project. Now,
we will learn about how we can produce images that are effective in conveying information
properly. But first, let us do this activity.
At a glance, what
do you think is
drawn in this
picture? Why do
you think so?
Is it visually
appealing to
your eyes? Why
do you say so?
What makes it
appealing, what
makes it not?
74
Processing Questions:
1. What do you think of this poster by Niklaus Troxler?
2. Can you immediately guess what is the meaning behind the poster?
3. What is the most striking thing about this image?
Student’s responses:
75
Learning Objective
In these lessons, you will learn to
● Be familiar with the basic principles of graphics design and elements that comprise an
effective infographic.
● Discover various applications used in image manipulation and graphics design.
● Use graphic applications in creating visual content.
Evidence of Learning
and you are expected to show the following as evidence of learning:
● Manipulate images and graphic elements to create content.
● Apply the principles of graphics in creating an image that best represents the information
about your chosen social issue.
By the end of the module, you are expected to show the following scaffold to the Performance
Task:
MINI TASK 2. Create a visually appealing and effective infographic about your
chosen social issue and provide relevant information about your advocacy.
MINI TASK 3. Collaboratively create a website that will act as your online
portfolio.
To help you acquire the necessary skills in creating your Performance Task, the following the
expected output in this module. Manage your time well and observe the Learning Time below.
October 8, 2022
Final Performance Task
76
II. EXPERIENCE
Shape - A shape is a two- or three-dimensional object that stands out from the space next to it
because of a defined or implied boundary. A shape can live in different areas in space, and have
other elements like line, color, texture, or movement. Everything is ultimately a shape, so you
must always think in terms of how the various elements of your design are creating shapes, and
how those shapes are interacting.
Color - Color is one of the most obvious elements of design, for both the user and the designer.
It can stand alone, as a background, or be applied to other elements, like lines, shapes, textures,
or typography. Color creates a mood within the piece and tells a story about the brand. Every
color says something different, and combinations can alter that impression further
Size – Size refers to how large or small something is in a document. Size is very important in
making the elements of a document coincide with one another and makes the layout more
attractive and organized. It displays what is most important, attracts attention, and helps to fit the
layout together.
Texture – Texture is the look or feel of a surface is known as texture. Visual texture creates an
illusion of texture on a printed material or webpage. Printed patterns are a type of visual texture.
Tactile texture can be felt physically. Nowadays, even paper can come in various textures. The
wide selection of textures used on paper and other materials can be translated accurately into
rich, layered graphics.
NAME:
SECTION:
77
Let’s explore some more
1. What do you think are other uses of color in a design?
2. What are other possible uses of texture?
3. How can space and negative space affect a design?
Student’s responses:
78
The Principles of Design
These 5 basic principles are the fundamental components of art composition. Knowing to
appreciate the Principles of design is essential for the creation of successful visual expression.
By utilizing the Elements and Principles, an artist or designer can accurately portray a visual
concept effectively.
Balance – Balance refers to the equal distribution of weigh, which in design, applies to visual
weight. Elements such as size, lightness, and thickness can be scaled accordingly in a design.
The two kinds of balance are symmetrical and asymmetrical balance. Symmetrical balance is the
even distribution of elements in a design. Asymmetrical balance is the uneven arrangement of
elements such that one side of a design has more weight. Color, value, size, and texture can be
used as balancing elements.
Contrast – Contrast is the placement of heavy and light elements within the page.
The larger, darker elements appear heavier in the designs than smaller and lighter elements.
Examples of contrast
Emphasis – Emphasis is the distribution of heavy and light elements in a design. It determines
which elements within the design are focused on the most and which ones are given less
attention.
79
Examples of emphasis
Rhythm – Rhythm is the repetition of heavy and light elements in a design. It creates a mood
and sense of movement. Variety in repeated elements makes the rhythm of a design more
exciting.
Example of rhythm
Unity – Unity refers to the feeling of harmony that is created by all the parts and elements of a
design. When a particular design is said to be unified, it means that a sense of completeness can
be felt from the work.
Additional references:
https://www.invisionapp.com/design-defined/elements-of-design/
https://creativemarket.com/blog/10-basic-elements-of-design
80
NAME:
SECTION:
Instruction: Use the internet to search for images (posters, photos, illustrations, or paintings)
that best represent each of the five (5) elements of design. Give two (2) examples for each
principle.
Balance
Contrast
Emphasis
Rhythm
81
Unity
82
USING INFOGRAPHICS TO PRESENT DATA
In the previous chapter, we have learned the elements of design and the principles of design and
how they are applied in today’s visual media. In this lesson, you will apply your previous
knowledge in making an infographic for your project.
At a quick
glance, what do
you see in this
poster?
Since the advent of minimalist design, we have seen many infographics similar to the one above
in every area of our society, from printed materials to websites, and even in campaign ads. No
matter what the medium is, they all represent information in a more eye-catching way than text-
only materials. In this lesson, we will discuss and learn what makes infographics work and what
to consider when making them.
83
NAME:
SECTION:
Activity 4.2: LET’S TRY THIS! Write down your thoughts on the differences between
Graphic Design and Information Design.
84
What is an Infographic?
The representation of data using colors, shapes, line, and other visual elements is called data
visualization. Through data visualization, information overload caused by a mass of disorganized
information can be avoided. Charts and graphs were the most common methods of data
visualization in the past, but nowadays, it serves as but a part of a more comprehensive way of
presenting not only data but other kinds of relevant information. This visualization is called an
information graphic, or simply, ang infographic.
Source: https://infogram.com/page/infographic
85
Types of Infographics
Visual Article – an infographic in which wordy content is made more visual. Best used for
information spread via social media. Has a strong title and lots of content.
Timeline – outlines events chronologically. Can either be simple or complex. Invites the viewer
to go on a historical journey through interesting and relevant content and design.
Flowchart – designed to make the viewer answer a series of questions to reach a particular
answer. Often funny and lighthearted, it also works well on social media.
Cheat Sheet – serves as a quick reference for different kinds of information. Can also be in the
form of a step-by-step process on how to do things.
Comparison – a visual comparison of two things. Best used with effective visual presentation
and large amount of data.
Photo Infographic – pictures are used to tell the story or message of the infographic. Usually
design in a simple manner using actual photos to answer questions or describe something.
Data Visualization – also used for large data, but the focus is on creative visualization. Highly
dependent on design to be effectively visualized.
86
Once you’re logged into the editor, choose the dimensions of your final image. You can select a
custom size, or choose from one of the pre-built templates. Search for “Infographics ” on the
homepage. The default size for an infographic is 800 x 2,000 px.
After you’ve chosen the right size canvas for your project, Canva rolls out a list of layout options
that will serve as the base of your infographics. There are literally hundreds of designs to choose
from, but the first 50 are typically the most customizable
Now that you’ve selected a stunning template, it’s time to choose an eye-catching background.
Canva provides unique infographic skins for free, and you can pick from a library of different
patterns, colors, and design elements.
87
To change the background, click on the background icon in the left sidebar. The background
options are sorted by color and include everything from solid colors and macro-photography, to
quirky sketches and minimalist patterns.
Changing color palettes is simple. Just click on the canvas, then click on the multi-colored box at
the top of the design space. Use the search box that pops up to find a variety of relevant color
schemes.
Add or change fonts in your graphic by selecting the text icon on the left side. Drag and drop the
type of text you want to the canvas, remove the demo content, and start typing. There are
thousands of fonts to choose from in Canva. Select a font that works with your branding and the
content of your infographics. Use the standard text editor features to fill out the details of your
infographics.
Because the typography can be so dramatically customized, using certain fonts can affect your
infographic’s template. Make sure you’re paying attention to the readability of the content.
The ease at which Canva lets you add graphic elements is a big reason why we decided to choose
Canva for our ‘how to create an infographic’ guide. Infographics are so effective because they
use powerful imagery to convey key data points. Be sure you’re picking relevant images to
represent your info.
88
To select an element, double click on the type you want. You will find several styling options
available for each type (“grids”, “icons”, etc.). Simply drag and drop the elements you like and
resize to fit your design by dragging the corners. If you’re looking for something specific, use the
search box provided to filter the results.
When you’ve settled on the perfect design for your infographic, click the download button to
bring up a list of file types.
Adjacent to that button is the sharing option. Canva allows you to share your Infographics
directly to social media platforms like Facebook and Twitter. You can even use the embed tool
to add your infographic to a guest post and boost user engagement. Sharing your content is an
important step in generating brand awareness.
Reference: https://themeisle.com/blog/how-to-create-an-infographic/
NAME:
SECTION:
Instructions: Use the internet to search for the definition of each type of Infographic and
provide an example Infographic for each type. Instead of putting the image in the example
column, paste the link address to the actual image instead. The first one is done as an example.
Timeline
89
Flowchart
Cheat Sheet
Comparison
90
Numerical
Photo Infographic
Data Visualization
91
NAME:
SECTION:
Process Questions:
1. How effective do you think are infographics in relaying information especially through social
media?
2. During the COVID-19 quarantine period, what is the most memorable infographic you have
encountered?
3. What do you think is the role of infographics in our post-COVID pandemic society?
Student’s responses:
92
NAME:
SECTION:
III. REFLECTION
3. What are the advantages and disadvantages of using the internet as a tool for information
gathering?
4. How can you apply Cura Personalis (care for the entire person) in doing contextualized
online search?
93
NAME:
SECTION:
The group members will agree among themselves what type of infographic each member will
create. Each group member must have a different type of infographic from the other group
members.
● Visual Article
● Timeline
● Flowchart
● Cheat Sheet
● Comparison
● Numerical
● Photo Infographic
● Data Visualization
Creativity Used more than Used at least two Used only one (1) The infographic No output
two (2) principles (2) principles of principle of lacks visual
of graphics and graphics design in graphics design in design and
design in creating creating their creating the appeal.
their infographic. infographic. infographic.
Overall design is Somewhat creative Overall design
aesthetically but lack lacks visual
appealing. attractiveness in its appeal.
design
Content The overall The output meets The output is The No output
presentation is the required incomplete. The information
complete. The output. The visual visual elements presented is not
visual elements elements give a do not match the related to the
work well to good information being subject.
highlight representation of presented.
important the information
information. presented.
Correctness The output is free The output The output has There were no No output
from errors. contains 1-3 more than 3 sources cited
94
Links to all errors. Only some errors. No sources for information
sources are sources are linked. provided. used.
indicated.
Processing Questions:
In our current situation, is designing an important skill to learn? Why do you think so?
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________
__________________________________________________________________________
__________________________________________________________________________
__________________________________________________________________________
5 years from now, how can you apply the lessons in your life?
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________
__________________________________________________________________________
__________________________________________________________________________
__________________________________________________________________________
95
LESSON 5: Online Platforms and Publishing
Content Online
In the previous lesson, we learned about various online tools that we can use to ensure every
member in a team is working efficiently in completing the tasks assigned to them. These tools
allowed us to communicate, coordinate, and collaborate with each other online, ensuring that our
project can be managed and competed before the deadline.
In this lesson, we will talk about what technologies and platforms can we use when we
want to put our project online for the world to see. We will also discuss what are some
differences in these platforms and which ones should we use.
Why do people invest so much time in planning and designing their house?
In this lesson, we will not be self-hosting our website but it is essential to have prior knowledge
of web hosting and the domain name system if you decide to self-host in the future.
96
Activity 5.1
Instruction: Using the internet, search for the definition of each of the different types of web
hosting and write them in the table below.
Colocation Hosting
Activity 5.2
Instruction: True or False. Write True if the statement is correct and False if not.
97
Domain Name System (DNS)
This is a service that interprets domain names
into IP addresses. For instance, when you type
a specific web address, or URL, the given DNS
will correspond to that specific name and the IP
address for that computer and will connect you
to that site.
NAME:
SECTION:
98
Process questions:
Student Responses:
99
Wix: A quick introduction
While most people like to use Wordpress for its flexibility, Wix is a good option for those who
prefer a simpler, more “hands-off” website building experience.
After answering a few short questions about your new website, the sign-up process is
complete. Next, you will be asked whether you want to create a website within the Wix Editor or
let the Wix ADI tool design a website for you.
100
Although Wix’s artificial intelligence designer (ADI) is a useful tool, its design and
customization options are limited compared to the Wix templates and editor. Therefore, if you
have a basic understanding of website design (and I mean basic), you can stick ahead to Step 3 to
choose your template.
However, if you are totally new to building a website, then Wix ADI may be a good option for
you.
After selecting Start Now, the tool will then ask you a few questions about your new project.
Make sure you carefully choose the design options that most appeal to you as the ADI tool will
design a website based on your answers.
Your new website will then open within the ADI Editor.
The ADI Editor is easy to navigate. But here are just a few pointers to get you started
101
● Elements – Click on an element to customize it. The settings for a selected element will
appear in the left-hand menu bar where you can then make any necessary alterations.
Options include changing the images, writing text, adding buttons, and more.
● Add a Page – Select Pages > Add Page from the top menu bar. Then select from a range
of new page types and pre-made page templates.
● Design – Click on Design in the top menu to change your website’s theme and layout, or
alter global colors, fonts, and more.
However, if you want more control over your website, you’ll be better off skipping the ADI and
selecting your own template (which is the recommended method).
To find designs that match your site, you can filter the templates by category, and you can
also View each template in demo mode. Once you have found a template that fits with your
project, select Edit.
102
Once you select a template, you’ll be able to customize it in the Wix Editor using simple drag-
and-drop editing.
To get started, click on an element on the page to alter its settings, resize or reposition it, change
colors, rewrite text, and much more. Any changes you make will appear in real-time, so you’ll
instantly know how your site will look to visitors.
For further customization, you’ll use the options in the menu on the left-hand side. Let’s go
through what you can do here
Under Menus and Pages, you will find your site’s pages. Here you can add new pages, as well
as rename, hide or delete pages, and change the order that they appear in the menu.
This is also where you can access your pages’ Setting options, which house a few key options:
● SEO – Add metadata to each page to help your content get found in the search engines.
● Social Share – Add the images and text that will be displayed when each page is shared
on social media.
103
● Permissions – Select who can view each page and create restricted content or members-
only pages.
Background
Wix allows you to change the background color or image or display a video background. Wix
has an extensive free media library to select from or you can upload your own media.
Elements
Under Add, you can add a wide assortment of elements to your website pages including:
● Galleries and images
● Interactive slideshows
● Videos and music
● Buttons
● Forms
Blog manager
104
If you want to add a blog to your website, select the Start Blogging icon. Then click on Add
Now to add the Wix Blogging Manager app to your website.
Under My Blog, click on Create New Post. Here you can add and publish new posts within the
Blog Manager.
105
You can also view and manage your posts by selecting My Blog > Manage Posts.
Top menu
There are a couple of other important Wix Editor features that you can find in the top menu bar.
These include…
● Page – Quickly toggle between the pages on your site and your blog.
● Desktop / Mobile – Switch between desktop and mobile mode to edit your site for both
device types.
● Settings – Access global settings for your website, add a favicon, view analytics, and
much more.
● Save / Preview / Publish – It is important to save your website as you go. You can also
then preview your site on the front end and publish it when you are ready.
106
The Wix App Marketplace offers a variety of free and premium apps that can add extra
functionality to your website. To access the marketplace, click on the Apps icon and then browse
the apps to find one that interests you.
Here are just a few of the most popular apps currently available.
● Online Store – Turn your website into an online store with this powerful eCommerce
app.
● Wix Events – Easily create and manage your events online.
● Instagram Feed – Showcase your Instagram images and videos.
To install a free app, open the app’s page and click Add to Site.
6. Publish your Wix website
To make your website publicly accessible, you need to publish it. To do so, click Publish from
the top menu. However, before Wix will publish your site, the last step in the process is to create
your own subdomain or connect your own domain name.
To use a custom domain, you will need to upgrade your Wix account to a premium plan. Once
you do that, you can publish your site and visitors will be able to access it at whatever domain
name you selected.
107
Mini Task 3: Publish a website on Wix (Team Portfolio Website)
The group will create a website to host the materials they have created for their advocacy. This
website will be their team portfolio site which will be part of the Finals PT requirement. You can
use any of your preferred website building platform; Wix, Wordpress, Strikingly, or Weebly, just
to name a few. Use templates and designs which fit the project and showcase what you have
created to promote this advocacy.
NOTE: For this mini-task, it is okay to not have all the outputs uploaded in the Portfolio page.
That can be reserved for the Finals PT.
Content of the website The website is complete (has The website is complete (has The website lacks two The website lacks three
a Home page, Portfolio, a Home page, Portfolio, sections and the content on sections and the content
About Us, and Contact Us About Us, and Contact Us some sections is good is somehow complicated
section) and the content on section) and the content on to understand.
every section is satisfactory. every section is satisfactory.
The website also has
additional 1 or more pages
aside from the required
pages.
Creativity and Design Excellent layout is shown, Good layout is shown, and Good layout is shown but Layout needs to be
and all the graphics and all the graphics and designs some graphics and designs improved and graphics
designs complement with complement with each other. do not complement with and designs do not
each other. Website used Used template or custom each other complement each other.
custom images such as logo template in creating the
and other graphics. website.
Promptness The activity is submitted The activity is submitted on The activity is submitted 2- The activity is submitted
before the deadline the due date 3 days late late for 3 or more days
Group Participation All group members 1 member of the group did 2-3 members of the group More than 3 members of
participated to complete the not participate in the activity did not participate in the the group did not
activity activity participate in the
activity.
108
LESSON 6: Online Presence and Web Statistics
Do you remember the first time you were introduced to the internet? When people started seeing
who you are online? For most of you, it likely involved either Youtube or Facebook or other
videos of you made public and shared online. These days almost everyone who has an internet
connection is trying to get attention or “views'' either for online reputation and even financial
opportunities.
NAME:
SECTION:
Activity 6.1
EXPLORE. List down some websites/platforms that online personalities you follow are using to
share content about themselves either for fun or as full-time content creators.
WEBSITE/PLATFORM CREATOR NAME WHAT KIND OF
CONTENT DO THEY
POST
109
Do you have an online or internet presence?
Presence is the unavoidable consequence of living in this increasingly connected world of
computing devices. Over the internet, you can either have online or internet/web presence.
110
NAME:
SECTION:
Activity 6.2
Instruction: Use the internet to search for the definition of some elements used in Online
Presence Management
.
Website
Management
Search Engine
Optimization
(SEO)
Social Media
Marketing
Internet
Advertising
Reputation
Management
Social Media
Management
111
Your Web of Influence
Having considerable web presence serves to boost a person’s influence over their audience who
follows their activities and posts online. Having an ounce of influence online means that people
believe in you, even if these people are only within your circle of friends or are members of your
family. A kernel of influence can become the seed that can grow into your own personal web of
influence online that would be like a tree with branches that reach out to all corners of the
internet.
Web Analytics
Web analytics is the measurement, collection, analysis, and reporting of web data for purposes of
understanding and optimizing web usage. However, Web analytics is not just a process for
measuring web traffic but can be used as a tool for business and market research, and to assess
and improve the effectiveness of a website. Web analytics provides information about the
number of visitors to a website and the number of page views. It helps gauge traffic and
popularity trends which is useful for market research.
112
Source: https://en.wikipedia.org/wiki/Web_analytics#/media/File:Basic_Steps_of_Web_Analytics_Process.png
113
Web Analytics Data That Matter
There are plenty of data that can be made available when it comes to Internet Analytics, but the
following might be the most important for you in relation to improving your web presence.
User – means the number of unique visitors to your site. Essentially, these are the actual people
landing on your website, which means that if someone were to visit your site 100 times on the
same device or browser, they would still only count as one user
Session - defined as the total number of visits to your site — including both new and repeat
visits. So that same person who visited your site 100 times on the same device is counted as one
user, but 100 sessions.
Page Visits – this is how many times a specific visitor loads a page on your site. If this is high,
then that visitor has a specific interest in what your site has to offer.
Page Views – the number of times a website has been loaded in a browser in a period.
Bounce Rate – the percentage of visitors to a particular website who navigate away from the site
after viewing only one page.
Time on Page (ToP) - Average time on page is simply the average amount of time all users
spend on a single page.
View/Visit Ratio (VVR) – the number of page views divided by the number of visits to a
website. This gives the average time of a visit in terms of content consumption.
Facebook Insights
Twitter Analytics
114
Instagram Insights
NAME:
SECTION:
115
III. REFLECTION
Answer the following questions briefly.
1. Why do you think it is important for an individual or organization to build their online
presence?
2. As a student, do you think online collaboration tools can help you be more efficient?
3. What are the advantages and disadvantages of using the online tools for managing and
completing a project?
4. How can you apply Cura Personalis (care for the entire person) as you grow your online
influence?
IV. ACTION
FINALS PT: Team Portfolio Site
116
As the digital marketing team of a local NGO, you are to create an online information awareness on a
social issue you have identified to be of relevance with the current social climate.
Your team will be responsible for creating social media accounts, multimedia, and other ICT content to
be used in this campaign. You are to use online platforms in marketing the materials you have created
along with other related content about the advocacy you have created. Your team will present your project
during the annual Social Development Week of Xavier University to help raise awareness among students
and young professionals on the chosen social issue.
Your team will be rated according the use of online platforms, creation of related ICT materials,
reliability of data presented in your booth, as well as the efficient use of graphics and information design.
GRADING RUBRIC
(6 points)
Infographics The group created more The group has created The group created less The group created one (1) of
than five (5) infographics five (5) infographics with than three (3) the different types of
with more than three (3) three (3) different types infographics with less infographics
different types than three (3) types
Posters The group created more The group created three The group created less The group created one (1)
than three (3) different (3) different posters than three (3) different poster about their topic
posters about their topic about their topic posters about their topic
Brochures The group created more The group created one (1) The group created one The group created one (1.)
than one (1) type of type of brochure. (1) type of brochure. type of brochure.
brochure. Information is Information is complete Information is somewhat Information is incomplete
complete and the layout and the layout shows incomplete, and the and the layout lacks
shows evidence of effective evidence of effective use layout has moderate use evidence of effective use of
use of design. of design. of design. design.
Social Media The group created more The group created two (2) The group created two The group created less than
Sites than two (2) social media social media accounts, (2) social media two (2) social media
sites, aside from Facebook Facebook & Twitter, and accounts, either accounts, either Facebook or
& Twitter, and has more has 5 posts per account Facebook or Twitter, and Twitter, and has less than 5
than 5 posts per account with at least 50 followers has less than 5 posts on posts on either account and
with more than 50 & likes per account. either account with less less than 20 followers & likes
followers & likes per than 50 but more than per account.
account. 20 followers & likes per
account.
Website The group created a The group created a The group created a The group created a website
website with at least four website with at least four website with at least with less than the four
(4) pages; Home, Portfolio, (4) pages; Home, four (4) pages; Home, recommended (4) pages;
About Us, and Contact Portfolio, About Us, and Portfolio, About Us, and Home, Portfolio, About Us,
page. All links are properly Contact page. Most of the Contact page. Some links and Contact page. Only few
working, and the website links are properly working are properly working links are properly working
shows evidence of effective and the website shows and the website shows and the website lack
webpage design. evidence of effective good webpage design. evidence of effective
webpage design. webpage design.
NAME:
SECTION:
Processing Questions:
1. How did you find the performance task?
117
2. How can you apply this experience in real life?
118
NAME:
SECTION:
POST-TEST
Let us find out how much you already know about this module. Encircle the letter that you think
best answers the question. Please answer all items. After taking this short test, you will see the
answer key. Take note of the items that you were not able to correctly answer and look for the
right answer as you go through this module.
2. Easiest, cheapest and most common type of web hosting where it shares multiple sites on the
same server.
A. Colocation Web Hosting
B. Dedicated Web Hosting
C. Shared Web Hosting
D. Virtual Private Server Web Hosting
4. Kriselda, a fresh graduate, wants to create her own portfolio website and online
resume. She is looking for the most affordable option as she only needs to use it for hosting
her personal data and works. What kind of hosting should she sign up for?
A. Colocation Hosting
B. Shared Hosting
C. Virtual Private Server Hosting
5. Mary is fond of writing. She is currently working on a personal journal that also acts as a
self-reflection exercise. Recently, she decided that she wants to publish it online, and at the
same time have creative control over the website’s design and appearance. Which of the
following services should Mary start looking into?
A. Facebook
B. Twitter
C. Wordpress
D. Pinterest
7. A student from Xavier University Senior High School wants to organize his own files online
and wants to arrange his appointments according to date. What tool is most appropriate for
him to use to able to solve his problem?
A. Communication
B. Coordination
119
C. Collaboration
8. Andrei misses his mom who is working abroad. Given that Andrei and his mom have an
internet access, what is the best communication tool will satisfy their need?
A. Chat and Instant Messaging
B. Voice Chat
C. Video Chat
9. It is the oldest form of online communication and used in creating and sending messages,
sending files and attachment to a recipient.
A. Electronic Mail
B. Instant Messaging
C. Voice Chat
D. Video Chat
10. Instant Messaging like Messenger and Viber is a type of coordination tool used to organize
and manage project.
A. True
B. False
C. Maybe
D. Sometimes
120
Congratulations!
You have completed Module 2
121
SELF-ASSESSMENT:
Were you
able to
Activity No./ Actual Date of
Lesson complete Reason/s:
Task Completion
the task on
time?
Activity 4.1
Activity 4.2
Basic Graphics
and Information
Design
Activity 4.3
Mini Task 2
Activity 5.1
Online Platforms
and Online
Publishing
Mini Task 3
Activity 6.1
Online Presence
and Web
Statistics
Activity 6.2
NAME:
SECTION:
122
POST-TEST
It is now time to evaluate your learning. Encircle the letter of the answer that you think best
answers the question. Your score will be disclosed by your teacher during
Consultation Periods
1. What element of design refers to the surface that acts as a virtual container in a layout?
A. Line C. Shape
B. Point D. Space
3. What principle of design refers to the feeling of harmony that is created by all the parts and
elements of a design?
A. Balance C. Rhythm
B. Emphasis D. Unity
4. What principle of design determines which elements within the design are focused on the
most and which ones are given less attention?
A. Balance C. Rhythm
B. Emphasis D. Unity
5. On which of the four (4) elements of a good infographic do virality and enhanced Search
Engine Optimization (SEO) belong to?
A. Data C. Shareabiliy
B. Design D. Story
6. Which type of infographic can be a quick reference for different kinds of information and can
also be of a step-by-step process on how to do things?
A. Cheat Sheet C. Photo Infographic
B. Flowchart D. Visual Article
7. The following are the things to consider when making infographic EXCEPT:
A. Infographic must be creative and innovative.
B. The subject and the main idea must be clear.
C. Infographic must not be full of text to attract readers.
D. Data may not be that organized if it supports the main idea.
8. Your Biology teacher requires a performance task in the form of an infographic wherein
more content in the form of words will be presented. What type of infographic will you
create?
A. Cheat Sheet C. Flowchart
B. Data Visualization D. Visual Article
9. Jefferson has recently joined a weight-loss program to prepare for the annual summer beach
party of his company. He was advised by his training instructor to follow a diet plan to
achieve the desired weight. If Jefferson is to create a graphic plan for his diet, what type of
infographic is the most suitable for this?
A. Cheat Sheet C. Flowchart
B. Data Visualization D. Visual Article
123
10. Mr. Cruz and his friends decide to sell apples and other fruits in his neighborhood. He wants
to see the growth of their earnings since day 1 and show it to his friends without them seeing
the breakdown of their earnings. What type of infographic is the most suitable graphical
representation of their earnings?
A. Comparison
B. Data Visualization
C. Numerical
D. Visual Article
124
1