EMPOWERMENT

TECHNOLOGIES
Week 5-6

Development and Quality Assurance Team

Developer: Eleazar-Rey M. Agudo

Evaluator: Eleazar-Rey M. Agudo
Learning Area Supervisor: Menerba D. Dapar

Illustration Credits:
Title Page Art: Marieto Cleben V. Lozada
Title Page Graphics: Bryan L. Arreo
Visual Cues Art: Ivin Mae M. Ambos

Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
 Competency: uses common productivity tools effectively by maximizing
advanced application techniques. CS_ICT11/12-ICTPT-Ic-d-4
evaluate existing websites and online resources based on the principles of layout,
graphic, and visual message design. CS_ICT11/12-ICTPT-Ie-f-6

Objectives: At the end of the week, you shall have

A. Knowledge: familiarize the different productivity tools with advanced application
techniques
B. Skill: manipulate text, graphics, and images to create ICT content intended for an
online environment
C. Attitude: manifest appreciation of the significance of common productivity tools
and visual designs on specific professional tracks.

Lesson Overview

Advanced Word Processing Skills

In the professional world, sending out information to convey important information is vital.
Because of ICT, things are now sent much faster than the traditional newsletters or postal mail. You
can now send much faster than the traditional newsletters or postal mail. You can now use the
Internet to send out information you need to share. What if we could still do things much faster –
an automated way of creating and sending uniform letters with different recipients? Would that
not be more convenient?

I. Mail Merge and Label Generation

A. Mail Merge
One of the important reasons in using computers per se is its ability to do recurring tasks
automatically. But this ability has to be honed by learning the characteristics and features of the
software you use with your computer. After all, no
matter how good or advance your computer
and software may be, it can only be as good as
the person using it.
In this particular part of our lesson, we will
learn one of the most powerful and commonly
used features of Microsoft Word called Mail
Merge. As the name suggests, this feature allows
you to create documents and combine or merge
them with another document or data file. It is
commonly used when sending out advertising
materials to various recipients.
The simplest solution for the scenario above
is to create a document and just copy and paste
it several times then just replace the details
depending on whom you send it to. But what if
you have hundreds or thousands of recipients?
Would not that take too many hours? What if you
have a small database of information where you
can automatically generate those letters?

Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
Two Components of Mail Merge

1. Form Document

The first component of our mail merged document is the form

document. It is generally the document that contains the main body of
the message we want to convey or send. The main body of the
message is the part of the form document that remains the same no
matter whom you send it to from among your list.

2. List or Data File

The second component of our mail merged document is

the list or data file. This is where the individual information or
data that needs to be plugged in (merged) to the form
document is placed and maintained.

II. Integrating Images and External Materials

Integrating or inserting pictures in your document is fun and it improves the impression of
your document. A common use of inserting a picture on a document is when you are creating
your resume. Though seemingly simple to do, your knowledge on the different kinds of materials
that you can insert or integrate in a Word document and its characteristics can help you create
a more efficient, richer document not only in content but also in physical form.

A. Kinds of Materials
There are various kinds of materials Microsoft Word is capable of integrating to make the
documents richer, more impressive, and more informative.

1. Pictures - Generally, these are electronic or digital pictures or photographs you have saved in
any local storage device. There are three commonly used types of picture files. You can identify
them by the extension on their file names.

a. .JPG/JPEG - This is pronounced as “jay-peg“ and is the short form of .jpeg or Joint
Photographic Experts Group. Like all the rest of the image file extensions, it identifies the kind of
data compression process that it uses to make it more compatible and portable through the
Internet. This type of image file can support 16.7 million colors that is why it is suitable for use
when working with full color photographic images.
b. .GIF - This stands for Graphics Interchange Format. This type of image file is capable of
displaying transparencies. Therefore, it is good for blending with other materials or elements in
your document. It is also capable of displaying simple animation.
c. .PNG - This is pronounced as “ping“. It stands for Portable Network Graphics. It was
built around the capabilities of .GIF. Its development was basically for the purpose of
transporting images on the Internet at faster rates.

2. Clip Art - This is generally a .GIF type; line art drawings or

images used as generic representation for ideas and objects
that you might want to integrate in your document.
Microsoft Word has a library of clip arts that is built in or can
be downloaded and used freely.

3. Shapes - These are printable objects or materials that

you can integrate in your document to enhance its
Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
appearance or allow you to have some tools to use for composing and representing ideas or
messages.

4. Smart Art - Generally, these are predefined sets of different shapes grouped together to form
ideas that are organizational or structural in nature. If you want to graphically represent an
organization, process, relationships, or flow for infographic documents, then you will find this easy
and handy to use.

5. Chart - Another type of material that you can integrate in your Word document that allows
you to represent data characteristics and trends. Thi

6. Screenshot Sometimes, creating reports or manuals for training or procedures will require the
integration of a more realistic image of what you are discussing on your report or manual.

III. Image Placement

A. In Line with Text

This is the default setting for images that are inserted or
integrated in your document. It treats your image like a text font
with the bottom side totally aligned with the text line. This setting is
usually used when you need to place your image at the
beginning of a paragraph.

B. Square- This setting allows the image you inserted to be placed

anywhere with the paragraph with the text going around the
image in a square pattern like frame.

C. Tight - This is almost the same as the Square setting, but here the text “hug” or conforms to the
general shape of the image. This allows you to get a more creative effect on your document.
This setting can mostly be achieved if you are using an image that supports transparency like a
.GIF or .PNG file.

D. Through - This setting allows the text on your document to flow even tighter taking the
contours and shape of the image. Again, this can be best used with .GIF or .PNG type of image.

E. Top and Bottom - This setting pushes the texts away vertically to the top and/or the bottom of
the image so that the image occupies a whole text line on its own.

F. Behind Text - This allows your image to be dragged and placed anywhere on your document
but with all the texts floating in front of it. It effectively makes your image look like a background.

G. In Front of Text - As it suggests, this setting allows your image to be placed right on top of the
text as if your image was dropped right on it. That means whatever part of the text you placed
the image on, it will be covered by the image.

IV. 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.
Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
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 Portable Network Graphics image file.
.GIF – file extension for the Graphics Interchange Format image file.
Clipart – line art drawings or images used as a 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

ADVANCED SPREADSHEET SKILLS

What is a Spreadsheet Software?

•allows users to organize data in rows and columns and perform calculations on the
data
• These rows and columns collectively are called worksheet.
Examples of Spreadsheet Software:
• LibreOffice Calc • OpenOffice.org Calc • Google Sheets • Apple iWork Numbers
• Kingsoft Office Spreadsheets • StarOffice Calc • Microsoft Excel
MICROSOFT EXCEL
To open Microsoft Excel, Press “Windows Logo” + R then type “excel” then enter.
Key Terms in MS Excel:
a.1 Row – horizontal line of entries in a table a.7 Cell Reference – the cell address of the
a.2 Column – vertical line of entries in a cell usually combines letter and number (ex.
table A1, B4, C2)
a.3 Cell – the place where info. is held in a a.8 Merge – combining or joining two or
spreadsheet more cells
a.4 Active Cell – the selected cell a. 9 Formula – is an expression which
a.5 Column Heading – the box at the top of calculates the value of a cell.
each column containing a letter a.10 Functions – are predefined formulas
a.6 Row Heading – the row number and are already available in Excel
a.11 Formula Bar – the bar that displays the
contents of a cell

ADVANCED PRESENTATION SKILLS

Power point - is a highly innovative and versatile program that can ensure a successful
communication whether you’re presenting in front of potential investors, a lecture theatre or
Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
simply in front of your colleagues. The following are the five features you should be using. Learn
everything about these tips: they will improve your presentation skills and allow you to
communicate your message successfully. The five features of power point was

1)adding smart art -

2)Inserting Shapes -

3)Inserting and Image -

4)Slide Transitions -

5)Adding Animations -

Creating an Effective Presentation

1.Minimize: Keep slides counts to a minimum to maintain a clear message and to keep the
audience attentive. Remember that the presentation is just a visual aid. Most information should
still come from the reporter.
2.Clarity: Avoid being to fancy by using font style that is easy to read. Make sure that it is also big
enough to be read by the audience. Once you start making your presentation, consider how
big the screen is during your report.
3.Simplicity: Use bullets or short sentences. Summarize the information on the screen to have
your audience focus on what the speaker is saying than on reading the slide. Limit the content
to six lines and seven words per line. This is known as the 6 x 7 rule.
4. Visual: Use graphics to help in your presentation but not too many to distract the audience. In
addition, instead of using table of data, use charts and graphs.
5. Consistency: Make your design uniform. Avoid having different font styles and backgrounds.
6. Contrast: Use a light font on dark background or vice versa. This is done so that it is easier to
read. In most instances, it is easier to read on screen if the background is dark. This is due to the
brightness of the screen.

Formative Test - Multiple Choice

Direction: Choose the letter of the best answer. Write the chosen letter on a separate sheet of
paper.
1. What does .JPEG stands for?
A. Joint Photographic Experts Group C. Joint Photographic Essentials Group
B. Java Photographic Experts Group D. Joint Photographer Experts Group
2. It is a highly innovative and versatile program that can ensure a successful communication
whether you’re presenting in front of potential investors, a lecture theatre or simply in front of
your colleagues.
A. MS Word C. MS Excel
B. MS Power point D. MS Publisher

3. What does .GIF stands for?

A. Graphics International Format C. Graphics Interchange File
B. Graphics Interchange Format D. Group of Interchanged Formats
4. _____________ are printable objects or materials that you can integrate in your document to
enhance its appearance or allow you to have some tools to use for composing and representing
ideas or messages.
A. clip art C. chart
B. smart art D. shapes
Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
5. It is a type of material that you can integrate in your Word document that allows you to
represent data characteristics and trends. This is quite useful when you are preparing reports that
correlate and present data in a graphical manner. Which one is it?
A. clip art C. chart
B. smart art D. shapes

Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.
 Activity 2

Answer Key

Activity 1. Activity 2. Formative test

5.c

4.d

3.b

2.b

1.a

Disclaimer: This Learning Activity Sheet (LAS) is based from the Learner’s Materials, Textbooks and Teaching Guides released by DepEd Central
Office. Furthermore, utilization of duly acknowledged external resources is purely of non-profit, for educational use and constitutes fair use. All
Rights Reserved.