EMPOWERMENT TECHNOLOGIES

FIRST SEMESTER
Final Examination Reviewer

Advanced Word Processing Skills

Key Terms
• Mail Merge – a feature that allows you to create documents and combine or merge them with
another document or data file.
• Form Document – the document that contains the main body of the message we want to
convey or send
• Data File – includes the individual information or data or the recipient’s information
• Merge Field/Place Holder – marks the position on your form document where individual data
or information will be inserted
• .JPG – file extension for the Joint Photographic Experts Group picture file
• .PNG – file extension for the Portable Network Graphics image file
• .GIF – file extension for the Graphics Interchange Format image file
• Clipart – line art drawings or images used as generic representation for ideas and objects
• Smart Art – predefined sets of different shapes grouped together to form ideas that are
organizational or structural in nature
• Text Wrap – adjusts how the image behaves around other objects or text

Lesson Summary
Word processors, though a common tool in the workplace, can be quite tricky at times
especially if you are typing a letter or making simple invitations. By doing so, the amount of features
that we utilize, particularly in Microsoft Word 2010, is only superficial. In fact, even the most common
tasks you usually do can be automated further making your work more efficient and effective.
In this lesson, we have discussed mail merge and the two essential components, the form
document and the data file, that you need to have in order to productively use this feature.
Form document is a standard document that contains generic information that is mostly
constant within the document. Data file, on the other hand, contains the list of changeable
information that needs to be inserted in the form document to complete it.
These files are the main components that are combined together (merged) to produce
multiple personalized copies of the same form document without typing up your time and effort.
We also discussed that the same exact process and components are utilized when you create
(address) labels for the distribution of your form document or letter. The only difference is that the
form document used during label generation is already predefined, formatted, and built in Microsoft
Word. All you need to do is to supply the data file that it will need to use during the actual label
printing or merging process.
Moreover, we also discussed another advanced feature of Microsoft Word which is the
integration of images and other external materials. We discussed each kind of material by describing
and differentiating each of them so we can identify the different effects on your document. We also
tackled how images and other materials are placed within the document and how to manipulate
them by using the layouting option specifically, text wrapping. Text wrapping allows you to place
your images where you want it to be in your document. Knowing the different characteristics of each
text wrapping option can save you a lot of time from figuring out how and where to put the image.
1|P age
Advanced Spreadsheet Skills
Key Terms
• Accounting Number Format – a number format that is used for accounting
• Orientation – the angle at which a text is displayed
• Count – a function used to count the cells with content in a range
• Sum – a function used to compute for the summation of the number of a range
• Average – a function used to compute for the average of the number of a range
• COUNTIF – a function used to count the cells with a specified content within a range
• SUMIF – a function used to compute for the summation of a range if a certain condition is
met
• AVERAGEIF – a function used to compute for the average of a range if a certain condition is
met
• 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 – the actual range of cells that will be averaged, if omitted, the range will be
used instead
Lesson Summary
Microsoft Excel provides an automated way of displaying any statistical data. It can be used
to automatically compute for several factors that are not easy to notice especially when faced by a
large data. Microsoft excel includes several arithmetic and basic functions that help you compute
faster.
With Microsoft Excel, organizing and analyzing data are much simpler through the use of
conditional functions such as COUNTIF, AVERAGEIF, and SUMIF. These functions work almost
the same as Count, Average, and Sum with the exception that you can provide criteria where if it is
not met, the data is to be ignored by the formula, and therefore not the computer.
COUNTIF syntax includes range and criteria. Range is the cells involved, and criteria is the
value or label that need to be fulfilled if the part of the range is to be counted. AVERAGEIF and
SUMIF, on the other hand, have three parts of its syntax: range, criteria, and average range. The
range and criteria work the same as COUNTIF’s syntax with the exception that it would be averaged
or summed. The average range is an optional part of the syntax. It is where the actual range of cells
that will be averaged or summed is located. If it is not specified, the range will be used instead.

Advanced Presentation Skills

Key Terms
• Minimize – keeping slide counts to a minimum
• Clarity – making sure the font is readable
• Simplicity – using bullets or short sentences; applying 6 x 7 rule
• Visuals – using graphics that attract, not distract the audience
• Consistency – making your designs uniform
• Contrast – using light font on dark background or vice versa
• Hyperlink – a text or object that contains a link to another file, web page, a place in a
document, a link to a new document, or an email address
• Embedding – the act of placing objects within the presentation
2|P age
Lesson Summary
To create an effective presentation, minimize the contents to maintain a clear message, avoid being
fancy by using that are easy to read, keep things simple through the use of bullets or short
sentences, use visuals like charts and graphs but avoid using ones that distract the audience, be
consistent by having uniform font styles, and be mindful of the contrast.

Use hyperlinks to create links to an existing file or web page, a place in the document, to create a
new document or to send email to a specified recipient.
Embedding objects allows you to insert files inside your presentation (e.g., an Excel file). You can
do this by simply going to the Insert tab>Text>object. You have two options when inserting an object:
(1) create new, which creates a new file you specified; and (2) create from file, which allows you to
create a new one based on an existing file already saved in your hard drive.

Imaging and Design for Online Environment

Key Terms
• Balance – deals with the visual weigh of objects, texture, colors, and space
• Emphasis – the area designed to attract the viewer’s attention
• Movement – guides the viewer’s eye around the screen
• Proportion – visual elements that create a sense of unity where they relate well with one
another
• Variety – uses several design elements to draw a viewer’s attention
• Infographics – or information graphics; used to represent information, statistical data, or
knowledge in a graphical manner
• Piktochart – an example of a free online app that allows you to create your own infographic
• PhotoScape – a free image manipulation tool that contains many features to help you in
creating images for websites
• Batch Editing – one of the most useful tools when trying to easily manipulate all images at
the same time
• Photobucket – an image hosting site
• Bandwidth – amount of data used to download your image by multiple users
Lesson Summary
The basic principles of graphics and layout include balance, emphasis, movement, pattern,
repetition, and rhythm, proportion, and variety/ Balance deals with the visual weight of object,
texture, colors, and space. Emphasis is the area designed to attract the viewer’s attention.
Movement guides the viewer’s eye around the screen. Pattern, repetition, and rhythm are visual
elements that are repeated to create unity in the layout or image. Proportion includes visual elements
that create a sense of unity where they relate well with one another. Lastly, variety uses several
design elements to draw a viewer’s attention.
Infographics or information graphics is used to represent information, statistical data, or
knowledge in a graphical manner. Piktochart is an example of a free online app that allows you to
create your own infographic.

3|P age
 Similar to MS Word, you can use several image file formats over the Internet; the most
commonly used are JPEG, GIF, and PNG. Each of which can be used in different instances
depending on what you need. In using images, remember to choose the right format, the right image
size, and to caption it.
PhotoScape is a free image manipulation tool that contains many features to help you in
creating images for websites. One of its features is the batch editor that edits multiple pictures at
once.
Photobucket is a free image hosting site that allows you to share photos over the Internet.
Simply create a Photobucket account and you can start uploading pictures and share theme to a
wide variety of platforms.

Online Platforms for ICT Content Development

Key Terms

• Content Management System (CMS) – a computer application that allows you to publish,
edit, manipulate, organize, and delete web content.
• Blogging – focuses on content and design. It typically looks like a newsletter where you are
given options to change the design to your liking.
• Social Media Platforms – allow you to create not only personal accounts but also pages and
groups where you can share content.
• WordPress – a free blogging platform
• Theme – the overall design of a website
Lesson Summary

Online platforms that you can use for ICT content development are social media platforms like
Facebook and Multiply, and blogging platforms like WordPress, Tumblr, and Blogger. Social media
are hampered by low customization but are strengthened by their popularity. On the other hand,
blogging platforms are not as popular but are highly customizable.
Blogs, news, and shopping websites use CMS which stands for Content Management System. CMS
is a computer application that allows you to publish, edit, manipulate, organize, and delete web
content.
One of the most popular blogging platforms is WordPress. WordPress allows you to create your
blogs for free and use its wide selection of free themes. The WordPress post editor is an example
of a cloud computing software.
Cloud computing applications are those that do not need nay installation and are readily available
over the Internet. You just need an Internet connection to access it. Cloud computing has its pros
and cons, but it is up to us on what we want and how we want to use it.

4|P age