Lesson Notes By Weeks and Term v5 - Grade 11

Lesson Video

This page supports the lesson note with a companion video and a short classroom-ready summary.

For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.

Performance objectives

• Use Mail Merge for personalized documents.
• Manage collaborative edits with Track Changes and Comments.
• Apply password protection to secure documents.
• Manage large reports with Master and Subdocuments.
• Automate tasks using Macros.

Lesson summary

This week, we delve into advanced word processing techniques, focusing on using these skills to develop solutions for real-world problems. Proficiency in word processing is no longer just about typing documents; it's about effectively communicating information, automating tasks, and creating professional-looking documents for various purposes. In the South African context, these skills are crucial for tasks ranging from creating professional CVs for job applications to producing informative pamphlets for community projects and generating business reports.

Lesson notes

2.1 Mail Merge Mail merge is a powerful tool that allows you to create personalized documents by merging a main document with a data source. This is especially useful when you need to send the same letter or email to many different people, but with personalized information such as names and addresses.

Why it matters: Imagine you are a small business owner in Khayelitsha and need to send out promotional flyers to your customers. Manually creating each flyer with individual addresses would be extremely time-consuming. Mail merge automates this process.

How it works: Create a Data Source: This can be a spreadsheet (like Microsoft Excel or Google Sheets) or a database. The data source contains the information you want to personalize, such as names, addresses, phone numbers, etc. Each column in the spreadsheet represents a field, and each row represents a record.

Example: Your Excel spreadsheet might have columns like "FirstName", "LastName", "Address", "City", "PostalCode".

Create a Main Document: This is your standard letter, email, or label design. You'll insert placeholders (called merge fields) where you want the personalized information to appear.

Example: In your letter, you might type: "Dear > >," where ` >` and ` >` are merge fields.

Merge the Data: The mail merge function in your word processor connects the main document to the data source and replaces the merge fields with the corresponding information from each record in the data source.

Example: When you run the mail merge, the first letter will be addressed to "Dear John Smith," the second to "Dear Mary Jones," and so on, using the data from your spreadsheet.

Worked example

Let's create a mail merge for sending out invitations to a workshop on starting a small business.

Data Source (Excel):

| FirstName | LastName | Address | City | PostalCode |

| --------- | -------- | --------------- | --------- | ---------- |

| Thando | Dlamini | 123 Main Street | Johannesburg | 2000 |

| Aisha | Patel | 456 Oak Avenue | Durban | 4000 |

| Sipho | Nkosi | 789 Pine Road | Cape Town | 8000 |

Main Document (Word):

```

Dear > >,

We are pleased to invite you to our upcoming workshop on starting a small business in South Africa.