Republic of the Philippines

Department of Education
Region I
Division of Pangasinan II
Binalonan, Pangasinan
Flores Integrated School
San Manuel, Pangasinan

SELF-LEARNING MODULE IN
EMPOWERMENT TECHNOLOGY
Grade 11/12
First Quarter, Week 4

MELC: Productivity Tools

LESSON 4: Productivity Tools

Objectives:

By the end of this lesson, you are expected to:

 Use common productivity tools effectively by maximizing advanced application

techniques.
 Create an original or derivative ICT content to effectively communicate or present data or
information related to specific professional tracks.

Prepared by:

JAYSON M. SORIANO
SHS Teacher II

AUBREY ROSE R. MAGNO

SHS Coordinator

ROBERTO P. SOL, PH.D.

Principal I

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 1

INTRODUCTION:

Productivity Tools also known as productivity software are software that people use to create and
produce professional quality documents, presentations, databases, charts, graphs, and more
(http://productive.tools/why-should-you-use- productivity-tools/).

The three basic functions of these three productivity tools are:

1. Microsoft Word – writing skills
2. Microsoft Excel – numeracy skills
3. Microsoft PowerPoint – presentation skills

PRE-TEST:

Direction: Read each item carefully and choose the letter of the correct answer. Write your answers on a
separate sheet of paper.

1. What program is used to create spread sheets which can later be used to analyse statistical tool?
A. MS Excel B. MS Word C. MS Publisher D. MS OneNote
2. What MS Excel function adds a range of cells?
A. ADD B. PLUS C. SUM D. TOTAL
3. Which of the following objects can be inserted in your document?
A. Pictures B. Sound C. Chart D. Shapes
4. Which of the following is NOT an animation type?
A. Entrance B. Exit C. Emphasis D. Encore
5. In MS Word, what menu is “Mail Merge” found?
A. Insert B. Format C. Design D. Mailings

DISCUSSION:
Lesson 4.1: Advance Techniques in Word Processor

Integrating Illustrations in Word Processor

An illustration in MS Word is visualization or drawing that is in the form of pictures, clip art, shapes,
SmartArt, charts, or screen clippings. You can insert illustrations easily by using the illustrations group of the
Insert Tab.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 2

 Steps on Inserting Illustrations in MS Word

Inserting Illustrations: Picture from a File

1. Click the area where you want to insert the picture in
your document.
2. Click Insert Tab then go to Illustrations group and
click Pictures. Insert picture dialog box will appear.
3. Choose the picture you want to insert and click insert.

Inserting Illustrations: Shape

1. Click Insert Tab then go to
Illustrations group and click Shapes.
2. Click the shape that you want and click the area in
your document where the shape will be placed.

Inserting Illustrations: SmartArt

1. Click Insert Tab then go to Illustrations group and
click SmartArt. A dialog box will appear. Select from the
list of SmartArt that you want and click OK.

Inserting Illustrations: Chart

1. Click in the document where you want the Chart to be
placed.
2. Click Insert Tab then go to Illustrations group and
click Chart. A dialog box will appear. Select the type
of chart that you want and click OK. MS Excel
window will appear with the chart.
3. Edit the data in MS Excel window. You can close
Excel after editing the chart.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 3

 Steps in Formatting Illustrations in MS Word

Resizing Illustrations
1. Click image and sizing handles will appear. Click
and drag any of the sizing handles.

Format Pictures and Clip art

1. Select the picture that you want to format. A Format tab of the Picture Tools will appear.

PICTURE TOOLS PURPOSE

Improves brightness, contrast and
sharpness

Changes color quality

Provides various artistic effects

 Adds visual style to the whole picture or clip art, click Picture
Styles
 Click Picture Border to add border.
 Click Picture Effects to add visual effects.

Format Shapes
1. Click the shape so the Format Tab of the Drawing Tool will appear.

PICTURE TOOLS PURPOSE

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 4
  To quickly change the appearance of the shape, click the drop- down
arrow of the Shape Styles then click one of the galleries of shape
styles.

You may also click any of these buttons if you

want to fill the shape with color, change the line
width or style, or add effects to the shape.

Format Chart
1. Select the chart that you want to format. Design, Layout, and Format tabs of the Chart Tools will appear.

2. To edit the data of the chart, click Edit Data of the Data group under the Design
tab. An MS Excel window will appear where you will edit the data. Close this
window as soon as you are done.
3. To add labels to your chart, go to the Layout tab and click the appropriate button
in the Labels group. Note: The steps may vary in Office 365 version.

ACTIVITY 4.1: Let’s Practice

Directions: Do the following activities as required.

1. Inserting and Editing Shapes: Digital Art

Open MS Word / WPS Word and create a simple drawing of scenery or a person using the available
shapes in MS Word / WPS Word. Be creative. Your work should be printed in a short bond paper.
Refer to the scoring rubric below for your grading.
2. Inserting and Editing Pictures: Travelogue
Open MS Word / WPS Word and create a travelogue of a favorite place you have visited currently or
in the past. Provide descriptions of the places you have been to and what is nice about the place.
Embed pictures using Wrap Text in Tight. Set the brightness at 0% and contrast at 20%. Place a
Picture Border of your choice. Do not put any artistic effects on the pictures. Other requirements:
choose a font style of your choice, size 12, and paragraph alignment should be justified, line spacing
is 1.15. Your work should be printed in a short bond paper. Refer to the scoring rubric below for your
grading.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 5

Mail Merge and Label Generation

A Mail Merge is a word processing feature that allows you to easily create multiple letters, labels,
envelopes, nametags, or catalogue documents to group of people as stored in a list in a database or
spreadsheet.
When making Mail Merge, you will need a document using MS Word and a recipient list which is
typically done using MS Excel workbook. But you can also use various sources including MS Outlook contact
list, MS Access database, or a Notepad text document.

Three Components of the Mail Merge:

1. Main document – the letter which contain the email information for each of the merged
document that can be letter, stationary or template. It also contains the field names which
contains the instructions for carrying out the merge.
2. Data source – it is also called data file which comprises the information to be merged into a
document such as the list of names and addresses to be used in a mail merge. This must be
connected to the data source before it can use the information in it.
3. Merge document – this is also a word processing document that is the generated output after
executing the merge process.

In Mail Merge you need to create the main document, create a data source and merge data with the document.

STEPS in creating a form letter:

1. Open MS Word. Click the Mailings tab.

2. Click the Start Mail Merge command.

3. Select Step by Step Mail Merge Wizard and a Mail Merge task
pane will appear at the right side of the document

4. Choose the type of document you want to create. If you want to

create a letter, select Letter. Six main steps in guiding you to
complete a merge will be displayed at the bottom.

5. Click Next: Starting document to move to Step 2.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 6

 6. Select Use the current document. Click
Next: Select recipients to move to
Step 3.

Note: You will need an address list so Word

can automatically place each address into the
document. The list can be in an existing file,
such as an Excel workbook, or you can type
a new address list from within the Mail
Merge Wizard.

7. From the Mail Merge task pane, select

Type a new list, then click Create.

8. The dialog box of New address list

appears, diplaying fields that Word
assumes you need. Select an entry that you don’t need
and click the Delete button. Use the TAB key to move
from cell to cell

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 7

Note:
 When you delete, a confirmation dialog box will appear.

 To customize the address list, click Customize Columns

button at the bottom of the window.

 The dialog box of Customized Address List will appear.

The resulting window lists the Field Names provided.
When you are done, click OK then customized fields
appear as column headings in the New Address List
dialog box.

 Fill in the recipient list by typing the record’s data.

Type the information that’s appropriate to each field,
then press TAB of the keyboard to enter the next
field. After filling in the last field, add another record
just press the TAB key after inputting the last field.
When you press the TAB key on the last field in a
record, a new record is automatically created and
added on the next line

9. Click OK after filling the recipient list. A special Save As dialog box pops up, allowing you to save the
recipient list. Type a name for the address list then click the Save button.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 8

POST – ASSESSMENT:

Direction: Read each item carefully and choose the letter of the correct answer. Write your answers on a
separate sheet of paper.

1. Which of the following is NOT an animation type?

A. Entrance B. Exit C. Emphasis D. Encore
2. Which of the following objects can be inserted in your document?
A. Pictures B. Sound C. Chart D. Shapes
3. In MS Word, what menu is “Mail Merge” found?
A. Insert B. Format C. Design D. Mailings
4. What program is used to create spread sheets which can later be used to analyse statistical tool?
A. MS Excel B. MS Word C. MS Publisher D. MS OneNote
5. What MS Excel function adds a range of cells?
A. ADD B. PLUS C. SUM D. TOTAL

ACTIVITY 4.2: Let’s Practice

Problem: Mr. James Reid, the director of admissions at MOGCHS University, has asked you to send an orientation
letter announcement to all incoming freshmen. You decide to use a form letter.

Directions:
1. Start with a blank file and save it with the name “MOGCHS University Letter.” When you are
working always Save your work as often as you can.
2. Before doing anything, select “1.15 Line and Paragraph Spacing.” Font style should be Arial size 12.
Margins should be at 1-inch all sides.
3. Create the data file or the recipients from the table below. Save the data file with the name MOGCHS
University Freshmen.
Save the file into the folder in Step 1.
Title First Name Last Name Address 1 City Country Zip
Code
145 Cagayan de Oro
Mr. Raul Ardent Sunrise City Philippines 9000
Road
13 Cagayan de Oro
Ms. Wilma Doesnt Eastern City Philippines 9000
Avenue
Mr. Victor Wood PO Box 891 Cagayan de Oro Philippines 9000
City
130 Cagayan de Oro
Mr. Cardo Dalisay Maple City Philippines 9000
Avenue
Ms. Dawn Zulueta PO Box 113 Cagayan de Oro Philippines 9000
City
4. Use the text below as the body of your letter. Follow the steps you have previously learned.
June 1, 2020

<<AddressBlock>>
<<GreetingLine>>
Congratulations on your acceptance to MOGCHS University.
We have scheduled an orientation in the Alumni Hall from 8:00am to 11:00am on Monday,
June 15, 2020, for all incoming freshmen. Advisers, instructors, and other staff members will
be available to familiarize you with the campus and answer your questions.
Topics covered during the orientation will be:
Adjusting to college life
Determining the right degree program

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 9

 Learning the campus layout

Registration for the first semester begins June 23, 2020 (Monday). Classes will begin
Monday, August 24, 2020.

We look forward to meeting you. For more information about the registration and orientation
please call us at (088) 355 – 5000.
Sincerely,

5. When you are done, save your work and print your output and submit it to your subject teacher.

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 10

Name: ____________________________________
Grade & Section: ____________________________________
Module #: ____________________________________

Answer only
Pre-test Post-Assessment
1. 1.

2. 2.
3. 3.
4. 4.
5. 5.

Activity 4.1

Activity 4.2

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 11

 Republic of the Philippines
DEPARTMENT OF EDUCATION
Region I
PANGASINAN DIVISION II
Binalonan
FLORES INTEGRATED SCHOOL
Flores, San Manuel, Pangasinan
Name:_______________________ Date:__________
Section:______________________ Score:_________
First Quarter
Week 4 Summative Test in
Empowerment Technology
Part II. Direction: Read the questions carefully and select the correct answer by writing the letters beside
the number.
_______1. An article that only presents one point of view or omits facts is biased.
A. True B. False C. Maybe D. Somewhat
_______2. Which of the following is NOT an example of a domain?
A. .gov B. .com C. .npr D. .edu
_______3. Your family is going out on a vacation. What should you do?
A. Post pictures when you return home.
B. Post the dates you will be gone online.
C. Tell no one. Vacations are for getting away.
D. Post updates of where you are currently checking in hotels or places.
_______4. http://www.avg.com/en/signal/what- is-spyware is an example of?
A. Access code B. Directory C. Server D. URL
_______5. What happens when a phrase or sentence is placed inside quotation marks when doing research?
A. Will search for words that are together and in order.
B. Will return items that have either of the terms
C. Will only return items that have both terms
D. Will return items that exclude a term
Prepared by: Checked by: Noted by:

JAYSON M. SORIANO AUBREY ROSE R. MAGNO ROBERTO P. SOL, Ph.D.

Subject Teacher SHS Coordinator Principal I

EMPOWERMENT TECHNOLOGY WEEK 4 FOR QUARTER 1 Page 12