EMPOWERMENT TECHNOLOGY Q1 Module-1-Week-3-Mail-Merge, High school final essays of Technology

Download EMPOWERMENT TECHNOLOGY Q1 Module-1-Week-3-Mail-Merge and more High school final essays Technology in PDF only on Docsity! Republic of the Philippines DEPARTMENT OF EDUCATION Region I Schools Division Office I Pangasinan Pangasinan National High School Lingayen, Pangasinan EMPOWERMENT TECHNOLOGY Applied Productivity Tools Quarter 1 - Week 3– Module 1 Prepared By: Eidene Joy M. Lopez Overview Dear Learners “Welcome to this module on MAIL MERGE”. A Mail Merge is a word processing feature that allows you to easily create multiple letters, labels, envelopes, name tags, or catalogue documents to group of people as stored in a list in a database or spreadsheet. Mail Merge What I Need to Know Learning Objectives After the lesson you should be able to:  Use advanced capabilities of Microsoft Word commonly used to increase productivity &efficiency  Create letters for distribution to various recipients  Create documents and combine or merge them with another documents What I Know (Pre-Test) Before you begin with the lesson, please answer the Pre-Test to check your previous knowledge. Directions: Encircle the letter of the best answer. 1. What feature of Microsoft word allows you to efficiently create documents that have the same general contents but may have different recipients or purpose? a. Print Merge b. Mail Merge c. Reference tab d. Home tab 2. Where can you find the start Mail Merge button? a. File tab b. Mailings tab c. Reference tab d. Home tab 3. What essential component of Mail Merge is required from users when generating labels? a. Data file b. Form document c. Place holder d. Merge field 4. What file contains the information you need to merge with your main document? a. Address file b. Contact list c. Data file d. Directory 5. What are the steps in creating simple mail merge? a. Create form document, preview, insert place holder, print b. Preview, insert place holders, create form document, print c. Create main document, create data source, insert place holder, preview d. Create data source, insert place holders, preview, print Answer will be given during the Group Chat! 7. From the Mail Merge task pane, select Type a new list, then click Create. 8. The dialog box of New address list appears, displaying 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. 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. What’s More (Enrichment Activity) Creating the Form Letter Creating the form letter 1. Click Next: Write your letter. Click the Address Block button to insert an address block into your letter. 2. Dialog box of Insert Address Block appears. Choose the desired format for the address block and click OK. The placeholder of Address Block will appear in the document. 5. Click the Next: Complete merge on the mail merge task pane and choose Edit Individual Documents. You may also click finish & merge button on the preview results section of the ribbon. Option A Option B Note: When you click the Edit Individual Documents, a Merge to New Document dialog box will appear and choose All if you have more than 1 recipient and click OK. After that, you will then see the full merged letter without writing to them one by one. When this is done, you can now print your work. What I Have Learned (Generalization) 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. 1. Create a folder called “MOGCHS University.” Save all files created in this activity into this folder. 2. Start with a blank file and save it with the name “MOGCHS University.” When you are working always Save your work as often as you can. 3. 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. 4. 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 Mr. Raul Ardent 145 Sunrise Road Cagayan de Oro City Philippines 9000 Ms. Wilma Doesn’t 13 Eastern Avenue Cagayan de Oro City Philippines 9000 Mr. Victor Wood PO Box 891 Cagayan de Oro City Philippines 9000 Mr. Cardo Dalisay 130 Maple Avenue Cagayan de Oro City Philippines 9000 Ms. Dawn Zulueta PO Box 113 Cagayan de Oro City Philippines 9000 5. Use the text below as the body of your letter. Follow the steps you have previously learned. 6. When you are done, save your work in the folder in step 1. You will submit this folder to your teacher through his/ her email. As soon as you submit, change the folder name into: family name_firstname_section_ MOGCHS University What I Can Do (Application) Creating a Mail Merge Assume that you are working for ABC company and your boss assigned you to send an e-mail to 10 recipients. Using mail merge, compose a letter addressed to 10 people stating that you are inviting them to an open gate party that will be held at your office’s convention center. Your document format must be: Document size: 8.5x11 inches Font: size 12, Century Gothic Margin: 1 in all sides Line spacing: 1.5 Your Data list must contain the following data: Last Name, First Name, Address Line 1 and 2, 10 recipients Submit the soft copy of your document through Google Classroom. 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  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, James Reid Director of Admissions