LP 8 Q 1 and 2
LP 8 Q 1 and 2
Pre-test
CN
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.
Activity #: Explanation
Instruction: Divide the students into 5 groups and answer the question provide. Each group will
be choosing 1 representative to deliver their answers.
1. Explain how Mail Merge can be used to personalize letters for multiple recipients.
Post test
Explain the purpose of Mail Merge and describe the essential components needed to perform it.
How does Mail Merge utilize information from an Excel workbook to create personalized
documents?
Week 2
Pre-test
Correct Answer: B
2: How does Mail Merge ensure uniformity in documents?
Correct Answer: C
A. Time efficiency.
B. Uniformity.
C. Precision.
D. Versatility.
Correct Answer: C
Correct Answer: A
A. Personalization.
B. Scalability.
C. Complexity.
D. Versatility.
Correct Answer: C
CN
The importance of Mail Merge lies in its ability to efficiently and accurately produce
personalized documents for multiple recipients. Key benefits include:
1. Time-saving: Automates the process of creating individualized letters, labels, and other
documents, reducing the need for manual entry and repetitive tasks.
2. Consistency: Ensures that each document follows the same format and style, maintaining
a professional appearance across all communications.
3. Accuracy: Minimizes the risk of errors that can occur with manual data entry, as the
information is directly pulled from a recipient list.
4. Scalability: Can handle large volumes of personalized documents, making it ideal for
businesses and organizations that need to communicate with many individuals.
5. Customization: Allows for the inclusion of personalized details such as names,
addresses, and other specific information, enhancing the relevance and impact of the
communication.
6. Flexibility: Can be used for various types of documents, including letters, envelopes,
labels, and name tags, making it a versatile tool for different needs.
1. True or False: Mail Merge can be used to create personalized letters, labels, envelopes, and
more using data stored in a spreadsheet or database.
True (Correct)
2. True or False: Mail Merge requires a separate software application apart from Microsoft
Word and Excel.
3. True or False: Mail Merge ensures each document maintains the same format and style,
regardless of recipient details.
False (Incorrect; Mail Merge allows each document to be personalized while maintaining
a consistent format)
4. True or False: Mail Merge can handle only small volumes of personalized documents
efficiently.
False (Incorrect; Mail Merge is scalable and can handle large volumes efficiently)
5. True or False: Mail Merge eliminates the need for any manual data entry when creating
personalized documents.
False (Incorrect; while it reduces manual entry, some initial setup and verification may
still be required)
Post test
Gaining insights
1. Why do businesses find Mail Merge so useful? Give examples of the types of documents it
can create and explain how it helps make communication smoother and more efficient.
Week 3 -4
Demonstration
STEPS:
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.
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.
Note:
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.
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.
Note: Use Match Fields button to match your field names with the required fields to correct problems.
This may be essential if you created the address list in another program such as Excel if not, just click OK
directly without clicking match fields. If you click OK, this will appear in your document.
4. To view your merged data, click the Preview Results button on the Mail Merge task pane or on the
ribbon to replace the merge fields with data from your recipient list.
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.
Applying
Let us Practice!
Problem: Mr. James Reid, the director of admissions at Cuares 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 “Cuares University Mail Merge.” Save all files created in this activity into this
folder.
2. Start with a blank file and save it with the name “familyname_firstname_section_Cuares University
Mail Merge”. 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 Times New
Roman 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
familynamefirstnamesectionCuares University Mail Merge. Save the file into the folder in Step 1.
Title First Name Last Name Address City Country Zip Code
Mr. Anboy Repz 123 Sunrise Bacuag Philippines 8408
Road
Ms. Girla Stanch 123 Sunrise Bacuag Philippines 8408
Road
Ms. Carla Bless 123 Sunrise Bacuag Philippines 8408
Road
Mr. Ray James 123 Sunrise Bacuag Philippines 8408
Road
Ms. Andy Mores 123 Sunrise Bacuag Philippines 8408
Road
5.1. Use the text below as the body of your letter. Follow the steps you have previously learned.
«Address»
«City»
«ZIP_Code»
«Country»
«GreetingLine»
Objective: To learn and demonstrate the ability to create personalized documents using Mail
Merge in Microsoft Word and Excel.
Materials Needed:
Computers with Microsoft Word and Excel installed
Sample Word document (template for the letter)
Sample Excel workbook (recipient list with columns for names, addresses, etc.)
Instructions:
Activity Review:
Group Discussion: Each group will discuss their experience with the Mail Merge process. What
challenges did they face? How did they resolve them?
Presentation: Each group will present their final personalized letters to the class, explaining the
steps they took and any tips they found helpful.
Standardized Rubric
Q2
Week 1
Pre-test
1. True or False: Using minimal text and bullet points on slides helps keep your presentation clear
and focused.
True
2. True or False: It is unnecessary to practice your presentation multiple times as long as you know
the content.
False
3. True or False: Incorporating high-quality visuals that directly relate to your content can enhance
audience understanding.
True
4. True or False: It's important to consider the demographics and background of your audience
when tailoring your presentation.
True
5. True or False: Maintaining eye contact with your audience is not important for building rapport
and keeping their attention.
False
CN
Creating a compelling presentation involves several key principles to ensure your message is delivered
clearly and engagingly. Here are some essential guidelines:
Know their needs: Tailor your content to suit the interests, knowledge level, and expectations of your
audience.
Consider demographics: Adjust your tone and examples based on the age, profession, and cultural
background of your audience.
Strong introduction: Start with an attention-grabbing opening that outlines the purpose of your
presentation.
Logical flow: Arrange your content in a logical sequence with clear transitions between sections.
Clear conclusion: Summarize key points and provide a strong closing statement or call to action.
3. Simplicity
Minimal text: Use bullet points or short sentences, avoiding large blocks of text.
Focus on key ideas: Highlight the main points and avoid cluttering slides with too much information.
Consistent design: Maintain a consistent font, color scheme, and layout throughout the presentation.
4. Effective Visuals
Use visuals: Incorporate images, graphs, charts, and videos to support your points.
Relevance: Make sure visuals directly relate to your content and enhance understanding.
5. Audience Engagement
6. Practice
Rehearse: Practice your presentation multiple times to become familiar with the content and flow.
Manage time: Ensure your presentation fits within the allotted time, leaving room for Q&A.
Seek feedback: Practice in front of friends or colleagues and get constructive feedback.
Reliable equipment: Ensure your laptop, projector, and any other equipment are working properly.
Backup plan: Have a backup of your presentation on a USB drive or cloud storage.
Technical proficiency: Be familiar with the presentation software and tools you’re using.
Eye contact: Maintain eye contact with your audience to build rapport and keep their attention.
Clear speech: Speak clearly, at a moderate pace, and use pauses effectively.
Confident posture: Stand confidently, use natural gestures, and avoid fidgeting.
9. Handling Questions
Anticipate questions: Prepare for potential questions that may arise from your content.
Stay calm: Listen to questions carefully and respond calmly and clearly.
Honesty: If you don’t know an answer, be honest and offer to follow up later.
Reflect: After your presentation, reflect on what went well and what could be improved.
Seek feedback: Ask your audience for feedback and use it to improve future presentations.
Continuous learning: Stay updated with new presentation techniques and tools.
Activity#
True or False: Using excessive text on slides can help keep your presentation clear and
focused.
False (Using minimal text and bullet points helps keep your presentation clear and
focused.)
True or False: Practicing your presentation multiple times is unnecessary if you are familiar
with the content.
False (Practicing your presentation multiple times is important to become familiar with
the content and flow.)
True or False: High-quality visuals that are unrelated to your content can enhance audience
understanding.
False (Incorporating high-quality visuals that directly relate to your content enhances
audience understanding.)
True or False: Tailoring your presentation to the demographics and background of your
audience is essential for effective communication.
True (It is important to consider the demographics and background of your audience
when tailoring your presentation.)
True or False: Avoiding eye contact with your audience can help build rapport and keep
their attention.
False (Maintaining eye contact with your audience is important for building rapport and
keeping their attention.)
Post test
1. Why does it matter to consider who your audience is when creating a presentation, and how can this
make your message more effective?
Week 2
Pre- Test
Instructions: Answer whether the following statements about Master Slides in PowerPoint are
True or False.
1. True or False: Changes made to the Master Slide affect only the slide currently being
edited.
2. True or False: Using Master Slides allows you to update fonts, colors, and backgrounds
across the entire presentation at once.
3. True or False: Custom layouts created in Slide Master view can only be applied to new
slides, not existing ones.
4. True or False: Closing the Slide Master view applies changes made to the Master Slide
automatically to all slides in the presentation.
5. True or False: Multiple Master Slides are beneficial for maintaining consistent design
across sections with varied content in a presentation.
Answer
False: Changes made to the Master Slide affect all slides in the presentation, not just the slide
currently being edited.
True: Using Master Slides allows you to update fonts, colors, and backgrounds across the
entire presentation at once.
False: Custom layouts created in Slide Master view can be applied to both new and existing
slides, not just new ones.
True: Closing the Slide Master view applies changes made to the Master Slide automatically
to all slides in the presentation.
True: Multiple Master Slides are beneficial for maintaining consistent design across sections
with varied content in a presentation.
CN
A Master Slide in presentation software like Microsoft PowerPoint is a template that defines the
layout, design, and style for all slides in a presentation. It allows you to make global changes to
your presentation's appearance, ensuring consistency and saving time.
Key Features:
1. Consistent Design: Changes made to the Master Slide affect all slides, maintaining a
uniform look.
2. Global Edits: Update fonts, colors, backgrounds, and placeholders across the entire
presentation from one place.
3. Efficiency: Saves time by applying design elements to multiple slides at once, rather than
editing each individually.
4. Custom Layouts: Create custom slide layouts with specific placeholders for different
types of content.
Benefits:
Activity#
Group activity
1. Why do you think using Master Slides in PowerPoint is helpful when creating presentations, and how
does it make the process more organized and efficient?
Post test
Instructions: Answer whether the following statements about Master Slides in PowerPoint are
True or False based on your understanding and learning from the lesson.
1. True or False: Changes made to the Master Slide affect all slides in the presentation,
ensuring a uniform appearance.
2. True or False: Custom layouts created in Slide Master view can be applied to both new
and existing slides, helping to maintain consistency.
3. True or False: Using multiple Master Slides is particularly useful for presentations with
different sections that require distinct formatting or styles.
4. True or False: Accessing the Slide Master view in PowerPoint is done through the
"Design" tab.
5. True or False: Master Slides in PowerPoint primarily help in creating animations and
transitions for slides.
Answer
True: Changes made to the Master Slide affect all slides in the presentation, ensuring a
uniform appearance.
True: Custom layouts created in Slide Master view can be applied to both new and existing
slides, helping to maintain consistency.
True: Using multiple Master Slides is particularly useful for presentations with different
sections that require distinct formatting or styles.
False: Accessing the Slide Master view in PowerPoint is done through the "View" tab, not
the "Design" tab.
False: Master Slides in PowerPoint are primarily used to define the layout, design, and style
of slides, not for creating animations and transitions.
Week 3
PreTest
Instructions: Answer whether the following statements about animation in presentations are
True or False based on your understanding.
1. True or False: Animation in presentations refers to the static display of content without
any movement or transition effects.
2. True or False: Animations can be used to highlight key points or elements, guiding
audience attention during a presentation.
3. True or False: Customization options for animations include adjusting duration, delay,
and trigger options.
4. True or False: The Animation Pane in PowerPoint is used to manage the sequence and
timing of animations on slides.
5. True or False: Animations primarily enhance presentations by adding text-heavy content
to slides.
Answer
CN
Animation in presentations refers to the dynamic movement or transition effects applied to text,
images, and other elements on slides. It enhances visual appeal and engagement by adding
motion and interactivity to otherwise static content.
Key Features:
1. Enhanced Visual Appeal: Animations make presentations more visually appealing and
captivating, keeping the audience engaged.
2. Focus and Emphasis: Use animations to highlight key points, elements, or sections of
the presentation, guiding audience attention.
3. Transition Effects: Smooth transition effects between slides create a cohesive flow,
improving the overall narrative of the presentation.
4. Interactive Elements: Animations can include interactive elements such as clickable
buttons or triggered actions, enhancing audience interaction.
5. Customization: Customize animation effects, timing, and sequences to match the tone
and pace of your presentation.
1. Adding Animations:
o Select the text or object you want to animate.
o Navigate to the "Animations" tab in PowerPoint.
o Choose from entrance, exit, emphasis, or motion path animations.
2. Customizing Animations:
o Adjust animation settings such as duration, delay, and trigger options.
o Preview animations to see how they will appear during the presentation.
3. Managing Animation Pane:
o Use the Animation Pane to manage the sequence and timing of animations.
o Reorder animations, set timing between animations, and adjust start options.
4. Applying Slide Transitions:
o Enhance slide-to-slide movement with transition effects.
o Select from various transition styles such as fade, dissolve, or slide.
5. Testing and Refining:
o Practice the presentation to ensure animations and transitions work smoothly.
o Refine animations based on audience feedback and presentation flow.
Benefits:
Activity
Post test
Instructions: Answer whether the following statements about animation in presentations are
True or False based on your understanding and learning from the lesson.
Answer
Week 4 -5
Materials Needed:
Activity Outline: