Advanced Word Processing Tools – SS2 Digital Technologies Lesson Note (First Term)
Download this term · ₦1,000Lesson note at a glance
- Subject
- Digital Technologies
- Class
- SS2
- Term
- First Term
- Topic
- Advanced Word Processing Tools
- Order
- Topic 1 of 7 this term
- Reading time
- 5 min
Advanced word processing tools are features that save time and reduce mistakes when you produce many similar documents.
- Mail merge: creates many letters from one main document and a list of names.
- Macro: records a series of steps and replays them with one click.
- Template: a pre-formatted document used as a starting point.
Behavioural objectives
By the end of the lesson, students should be able to:
- explain what mail merge is and name its three components;
- list the steps for performing a mail merge;
- explain what a macro is and record one;
- describe what a template is and give examples;
- say when to use mail merge, a macro or a template.
Why do we need advanced word processing tools?
We need them because they do repeated work for us, faster and with fewer errors than typing by hand.
- The problem: a school secretary must send personalised invitation letters to 500 parents.
- Typing one by one: this takes many hours and leads to spelling and name errors.
- Advanced tools: they do the “heavy lifting” so the work is done once and copied correctly.
- Main benefits: they save time, reduce mistakes and keep documents consistent.
What is mail merge?
Mail merge is a tool that creates many personalised documents at once from one main document and a list of names and addresses.
- Letters: invitations to a PTA meeting or admission letters.
- Envelopes: each one printed with a different address.
- Labels: name tags or address labels.
- Certificates: the same design with a different name on each.
What are the three components of mail merge?
Mail merge has three components: the main document, the data source and the merged document.
- The main document: the letter that contains the information that stays the same, such as the body of the invitation.
- The data source: your “address book”, usually a table or list of names, phone numbers or addresses.
- The merged document: the final result, a large file of 500 individual letters, each addressed to a different person.
What are the steps for performing a mail merge?
- Go to the Mailings tab.
- Select Start Mail Merge and choose “Letters”.
- Select Recipients: link your data source (an Excel sheet or a typed list).
- Insert Merge Fields: place placeholders like «FirstName» where you want the names to appear.
- Preview Results: check that each letter shows the correct name.
- Finish & Merge: Word generates all the letters automatically.
What can be used as a data source?
- Excel worksheet: one column for each item, such as FirstName and Address.
- Word table: a typed list in table form.
- Contacts list: names and addresses saved in an email program.
What is a macro?
A macro is a recorded set of steps that you can play back with a single click or a keyboard shortcut.
- Example task: changing text to Arial, size 12, bold and blue.
- Simple picture: think of it as a remote control for repetitive tasks.
What are the key concepts of a macro?
- Recording: once recording starts, Word records the commands and keystrokes you use.
- Automation: once saved, you can run the macro on any new text and Word repeats the actions instantly.
- Keyboard use: Word does not record mouse movements used to select text, so select text with the keyboard while recording.
How do you create a macro?
- Go to the View tab (or the Developer tab).
- Click Macros > Record Macro.
- Give it a name without spaces (for example, “MyHeadingStyle”).
- Assign it a button or a shortcut key of your choice.
- Perform the actions you want to automate.
- Click Stop Recording.
What should you be careful about when using macros?
- Mistakes are recorded: if you backspace while recording, the macro backspaces every time you run it.
- Plan first: practise the steps once before you start recording.
- Safety: macros can carry harmful code, so only enable macros from sources you trust.
What is a template?
A template is a pre-formatted document that you use as a starting point.
- Blank page: has no design, so you set everything yourself.
- Template: already has colours, fonts, layout and placeholders.
- Simple picture: think of it as a ready-made blueprint.
Why use templates?
- Consistency: every official school letter looks exactly the same.
- Speed: you do not set margins or add the logo every time.
- Professionalism: your work looks as if a professional designed it.
What are common examples of templates?
- Resumes (CVs): ready sections for education and experience.
- Invoices: fixed columns for items, prices and totals.
- Brochures: set panels for text and pictures.
- Meeting minutes: headings for date, attendance and decisions.
How do you use a template?
- Click File and choose New.
- Pick a template from the list or search for one.
- Replace the placeholder text with your own information.
- Save the finished document with a new name.
How do mail merge, macros and templates compare?
Mail merge produces many personalised copies, a macro repeats steps, and a template supplies a ready design.
| Feature | Best used for | Think of it as | School example |
|---|---|---|---|
| Mail merge | Sending the same letter to 100 people. | A “printing press” for letters. | Invitations to parents. |
| Macros | Automating a sequence of 10 clicks into 1. | A “record and play” button. | Formatting every heading in one click. |
| Templates | Starting a document with a pre-set design. | A “fill-in-the-blanks” form. | Official school letter with logo. |
Evaluation
- Mention two types of data source you can use for mail merge.
- What is the main difference between a template and a normal Word document?
- If you wanted to automatically format all your headings to “Red, Bold, Underlined”, would you use a macro or mail merge? Why?
- What is a merge field, and give one example.
- Why should you practise the steps before you record a macro?
Assignment
Write a short guide for a school secretary on the three tools, covering these points:
- Name the three components of mail merge and say what each one does.
- List the steps for creating a macro.
- Give three reasons for using a template when writing official school letters.
This term's Digital Technologies topics
SS2 First Term · 7 topics
Get Digital Technologies as PDF and Word
Every week of SS2 Digital Technologies, First Term, formatted and ready to print. Ad-free, and the copy lock comes off.
Get this term Card, bank transfer, USSD or OPay

