Slide Decks for Mail Merge, Empowerment Technologies

Slide Decks for Empowerment Technology, Grade 11

1. Review What risk does sharing your FIRST NAME and LAST NAME carry? In what way can these two can carry greater risk?

2. Situation: You are tasked to print out a certificate for a 300 attendee sat a conference. The certificate is needed in 30 minutes. You were only given an excel file of the attendees. How are you going to fulfill the task?

3. MAIL MERGE

4. uses common productivity tools effectively by maximizing advanced application techniques (CS_ICT11/12-ICTPT-Ic-d-4) Most Essential Learning Competency Q1 Week 2

5. Unlocking of Terms PRODUCTIVITY TOOL – Software or technology that a teacher uses to complete a job

6. Activity: Pick your phones. Type the following names in 2 minutes SEBASTIAN ORGE CHARLES TUICO FERNANDO AMORSOLO MAX SURBAN MICHAEL SERATO JESUS RABANES MICK SUPERALES TEODY CAGING KIMI GRANDE ESTEBAN SANTIANES

7. Questions: 1. Can you complete the name list in two minutes? If not how long? 2. Should you be given a soft copy of the names how long can you transfer each of the names to a certificate page?

8. Can our fastest time finish the task?

9. Unlocking of Terms PRODUCTIVITY TOOL – Software or technology that a teacher uses to complete a job Example: MS Word

10. Mail Merge is most often used to print or email form letters to multiple recipients.

11. Using Mail Merge, you can easily customize form letters for individual recipients

12. Mail merge is also used to create envelopes or labels in bulk.

13. click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge

14. click LETTERS

15. Click SELECT RECIPIENTS, then choose USE AN EXISTING LIST

16. Find the .XLSX file, choose and then click OPEN

17. click OK

18. click INSERT MERGE FIELD, then choose the appropriate field

19. Click PREVIEW RESULTS

20. Click FINISH & MERGE, and choose EDIT INVIDIDUAL DOCUMENTS to save into a new file

21. How does productivity tools like MS Word help office staff be productive?

22. Assessment Get 1/8 lengthwise. YES 1/8 LENGTHWISE

23. Which of the following files can be used as list for Mail Merge? Assessment .PPTX .DOCX .PDF .XLSX

24. 2) Which tools allows the use of Mail Merge Assessment MS Excel MS PowerPoint MS Access MS Word

25. 3) In order to see if the names that will appear in the certificates are correct, which of the following button should be pressed? Assessment

26. 4) To get started with Mail Merge, which of the following tabs should you click? Assessment INSERT HOME MAILINGS REVIEW

27. 5. Which button will let you use the excel file of the names to be used as list for the Mail Merge? Assessment Highlight Merge Fields Greeting Line Start Mail Merge Select Recipients

28. Assessment 1 2 3 4 5

29. How are formulas in excel written in Excel cells? Assignment

30. Thank You!