Skip to content

Advanced Word Processing Tools – SS2 Digital Technologies Lesson Note (First Term)

Download this term · ₦1,000

Lesson 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
4 min

Advanced word processing tools 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. A macro records a series of steps and replays them with one click. A template is a pre-formatted document used as a starting point.

Advertisement

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?

In our previous classes, we learned how to type, edit and format documents. Now imagine you are the school secretary and you need to send personalised invitation letters to 500 parents. If you type them one by one, you will be exhausted.

Advanced word processing tools do the “heavy lifting” for us. They save time and reduce mistakes.

What is mail merge?

Mail merge is a tool that allows you to create multiple documents (like letters, envelopes or labels) at once, using a single template and a list of names and addresses.

What are the three components of mail merge?

  1. The main document: This is the letter or document that contains the information that stays the same (for example, the body of the invitation).
  2. The data source: This is your “address book”. It is usually a table or a list containing the names, phone numbers or addresses of the people you are writing to.
  3. The merged document: This is the final result, a large file containing 500 individual letters, each addressed to a different person.

What are the steps for performing a mail merge?

  1. Go to the Mailings tab.
  2. Select Start Mail Merge and choose “Letters”.
  3. Select Recipients: Link your data source (an Excel sheet or a typed list).
  4. Insert Merge Fields: Place “placeholders” like «FirstName» where you want the names to appear.
  5. Finish & Merge: Word generates all the letters automatically.
Advertisement

What are macros?

Have you ever done the exact same steps over and over again? An example is changing the font to Arial, size 12, bold and blue. A macro is a way to record those steps so you can play them back with a single click or a keyboard shortcut. Think of it as a remote control for repetitive tasks.

Key concepts

  • Recording: When you start recording a macro, Word watches every click and keystroke you make.
  • Automation: Once saved, you can run that macro on any new text, and Word will repeat those actions instantly.

How do you create a macro?

  1. Go to the View tab (or the Developer tab).
  2. Click Macros > Record Macro.
  3. Give it a name (for example, “MyHeadingStyle”) and assign it a button or a shortcut key (like Ctrl + Shift + M).
  4. Perform the actions you want to automate.
  5. Click Stop Recording.

Teacher’s tip: Macros are useful, but be careful. They record everything, even your mistakes. If you backspace while recording, the macro will backspace every time you run it.

What are templates?

A template is a pre-formatted document that you use as a starting point. Instead of starting with a blank white page, you start with a layout that already has colours, fonts and placeholders. Think of it as a ready-made blueprint.

Why use templates?

  • Consistency: Every official school letter looks exactly the same.
  • Speed: You do not have to worry about margins or logos every time.
  • Professionalism: Your work looks as if a professional designed it.

Common examples of templates

  • Resumes (CVs)
  • Invoices
  • Brochures
  • Meeting minutes

How do mail merge, macros and templates compare?

Feature Best used for Think of it as
Mail merge Sending the same letter to 100 people. A “printing press” for letters.
Macros Automating a sequence of 10 clicks into 1. A “record and play” button.
Templates Starting a document with a pre-set design. A “fill-in-the-blanks” form.

Evaluation

  1. Mention two types of data source you can use for mail merge.
  2. What is the main difference between a template and a normal Word document?
  3. If you wanted to automatically format all your headings to “Red, Bold, Underlined”, would you use a macro or mail merge? Why?

Assignment

  1. Name the three components of mail merge and say what each one does.
  2. List the steps for creating a macro.
  3. Give three reasons for using a template when writing official school letters.

This term's Digital Technologies topics

SS2 First Term · 7 topics

  1. Advanced Word Processing Tools
  2. Advanced Spreadsheet I
  3. Advanced Spreadsheet II
  4. Advanced Presentation Tools
  5. Web Design I
  6. Web Design II
  7. Web Publishing and Hosting
Downloads

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

Advertisement

Lesson Notes for Other Classes

Print it or edit it in Word

Every note is free to read online. A PDF or Word copy of one subject costs ₦1,000 for one term, or ₦2,000 for all three terms.

Continue with GoogleContinue with Facebook

Sign in first, then choose your class and subject at checkout.