Empowerment Technologies 11

Name of Learner: ________________________________ Grade Level: _____

Section: _________________________________________ Date: ____________
LEARNING ACTIVITY SHEET

Productivity Tools-Mail Merge

Background Information for Learners

Now that you are a senior high school student, expect that things will be different. When
you were in your Junior High School, you were given activities with a little help of computer
applications, your pen and paper is enough for a requirement. Now, expect that almost all of
the requirements will need the help of computer application! Some of your time will revolve
around using office applications such as word, excel, powerpoint, etc. Those applications will
make your work a lot easier. One must be familiar on how it works so that it works!
Disclaimer: MS office application needed installed in a laptop or desktop computer or via MS
Office word android application

Learning Competency with Code

- uses common productivity tools effectively by maximizing advanced application
techniques (CS_ICT11/12-ICTPT-Ic-d-4)
Key Concepts:
Microsoft Word is a word processor developed by Microsoft. It can be used to create
and type letters, reports, newsletters, etc.
Activity 1: Pre-test
Direction: Choose the letter of the correct answer. Write you answer on the space provided.
1. Which key should be pressed to start a new paragraph in MSWord?
a. Down Cursor Key c. Shift + Enter
b. Enter Key d. Control + Enter
2. By default, on which page the header or the footer is printed?
a. On alternate page c. On every page
b. On first page d. None of the above
3. Which of these toolbars allows changing of Fonts and their sizes?
a. Print Preview c. Formatting
b. Standard d. None of these
4. MS-Word automatically moves the text to the next line when it reaches the
right edge of the screen and is called?
a. Word Wrap c. Carriage Return
b. Enter d. None of the above

NOTE: Practice Personal Hygiene Protocols at all times.

 5. Layout tab is for changing _________
a. Margin c. Orientation
b. Paper Size d. All of the above
6. What is the short cut for printing?
a. Ctrl + l c. Ctrl + p
b. Ctrl + v d. All of the above
7. Which option in File pull-down menu is used to close a file in MSWord?
a. New b. Close c. Exit d. Quit
8. In MS-Word, for what does ruler help?
a. To change page margins c. To set indents
b. To set tabs d. All of the above
9. Which bar is usually located below that Title Bar that provides categorized
options?
a. Status Bar b. Tool bar c. Scroll bar d. Menu bar
10. Which tab in MSWord can be used to change character size and typeface?
a. Home b. insert c. layout d. reference
11. In MS Word, Ctrl+S is for …..
a. Scenarios b. Size c. Save d. Spelling Check
12. Which enables us to send the same letter to different persons?.
a. Macros b. Template c. Mail merge d. None
13. How do you magnify your document?
a. View, Zoom b. Format, Font c. Tools, Options d. Tools, Customize
14. When you cannot move image to its desired position, you can use
a. Text wrapping b. Crop c. Drop d. Cut
15. The following are text alignment except___
a. Center b. Justified c. Left d. None
Microsoft Office word interface

Image Source: https://www.digiruns.com/introduction-and-user-interface-to-microsoft-word/

NOTE: Practice Personal Hygiene Protocols at all times.

Activity 2: Do what is asked
Direction:
1. Open Microsoft word
2. Change the Margin to T-.5in L-1in B-.5in R-.5in
3. Set the font to Arial Narrow Italic.
4. Type your name on the top left side of the document
5. Press enter, then type the subject “Empowerment Technologies”
6. Press enter, now set the alignment to center then type “Office Word Test”
7. Type the text below with the font: Times New Roman 11

Now that you are a senior high school student, expect that things will be different.
When you were in your Junior High School, you were given activities with a little
help of computer applications, your pen and paper is enough for a requirement.
Now, expect that almost all of the requirements will need the help of computer
application! Some of your time will revolve around using office applications such
as word, excel, powerpoint, etc. Those applications will make your work a lot
easier. One must be familiar on how it works so that it works!

8. Add indention to the first line

9. Justify the document
10. Hit enter twice then add pagination.
11. Send a screenshot of the document to your teacher.

Mail Merge
Mail Merge is a useful tool that allows you to produce multiple letters, labels,
envelopes, name tags, and more using information stored in a list, database, or spreadsheet.
When performing a Mail Merge, you will need a Word document (you can start with an existing
one or create a new one) and a recipient list, which is typically an Excel workbook.
How to perform Mail Merge?
1. Open and existing Word document, or create a new one.
2. From the Mailings tab, click the Start
Mail Merge command and select Step
by Step Mail Merge Wizard…from the
drop-down menu.

NOTE: Practice Personal Hygiene Protocols at all times.

3. Choose the type of document you
wish to create. In our example, we will
select Letters. Then click Next: Starting
document to move to Step 2.

4. Select Use the current document,

then click Next: Select recipients
to move to Step 3.

5. Now you'll 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. From the Mail Merge task pane,
select Use an existing list, then
click Browse... to select the file. If you
have not created a list yet, click type a new list then
enter the information required.

NOTE: Practice Personal Hygiene Protocols at all times.

6. In the Mail Merge
Recipients dialog
box, you
can check or unch
eck each box to
control which
recipients are
included in the
merge. By default,
all recipients
should be selected.
When you're done,
click OK.

7. From the Mail Merge task pane,

click Next: Write your letter to
move to Step 4.

8. Now you're ready to write your letter. When it's printed, each copy of the letter will basically
be the same; only the recipient data (such as the name and address) will be different. You'll
need to add placeholders for the recipient data so Mail Merge knows exactly where to add the
data.

8.To insert recipient data, Place the insertion

point in the document where you want the
information to appear.

NOTE: Practice Personal Hygiene Protocols at all times.

9. Choose one of the
four placeholder options: Address
block, Greeting line, Electronic
postage, or More items.

10. Depending on your selection, a dialog box

may appear with various options. Select the
desired options and click OK.

11. A placeholder will appear in your document (for

example, «AddressBlock»).

12. Repeat these steps each time you need to

NOTE: Practice Personal Hygiene Protocols at all times.

enter information from your data record.
In our example, we'll add a Greeting line.
13. Repeat these steps each time you need to enter information from your
data record. In our example, we'll add a Greeting line.

14. When you're done, click Next: Preview your

letters to move to Step 5.

15. Preview the letters to make sure the information from the recipient list appears correctly
in the letter. You can use the left and right scroll arrows to view each document.

NOTE: Practice Personal Hygiene Protocols at all times.

 Activity 3: Writing an Application letter
Direction:
1. Write a simple application letter by filling in the skeleton below.
2. Write down 10 possible recipients of your letter.
3. After writing the letter, encode it using Microsoft word.
4. Perform mail merge
5. Submit the copy of the file via messenger.

______________________
______________________ Your Address
______________________

______________________ Date

______________________ Name of the recipient

______________________ Position of the recipient
______________________ Address
______________________

_________, Salutation (Sir/Mam)

Body
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________
____________________________________________________________________________________________

Very truly yours,

_________________________ Name and Signature

Applicant

NOTE: Practice Personal Hygiene Protocols at all times.

Closure/Reflection
Mail merge is helpful in a way that……
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________

Answer key:

Activity 1:
1. B
2. C
3. C
4. A
5. D
6. C
7. B,C,D
8. D
9. D
10. A
11. C
12. C
13. A
14. A
15. D
Activity 2 and 3-Answers may vary

References for Learners

Botalon, M. (2017, March 15). Slideshare. Retrieved July 23, 2020, from Mail Merge:
https://www.slideshare.net/mike_1576/mail-merge-73155027
Digiruns. (n.d.). Retrieved july 16, 2020, from Introduction and User Interface to Microsoft
Word: https://www.digiruns.com/introduction-and-user-interface-to-microsoft-word/

PREPARED BY:

ROSTOM H. PON-ELBAN
Teacher II

NOTE: Practice Personal Hygiene Protocols at all times.

 10

NOTE: Practice Personal Hygiene Protocols at all times.