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
5 min

Advanced word processing tools are features that save time and reduce mistakes when you produce many similar documents.

Advertisement
  • 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:

  1. explain what mail merge is and name its three components;
  2. list the steps for performing a mail merge;
  3. explain what a macro is and record one;
  4. describe what a template is and give examples;
  5. 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.

  1. The main document: the letter that contains the information that stays the same, such as the body of the invitation.
  2. The data source: your “address book”, usually a table or list of names, phone numbers or addresses.
  3. The merged document: the final result, a large file of 500 individual letters, each addressed to a different person.
Advertisement
Main document Data source Mail merge Merged document
How the three components of mail merge work together. Based on standard ICT texts.

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. Preview Results: check that each letter shows the correct name.
  6. 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?

  1. Go to the View tab (or the Developer tab).
  2. Click Macros > Record Macro.
  3. Give it a name without spaces (for example, “MyHeadingStyle”).
  4. Assign it a button or a shortcut key of your choice.
  5. Perform the actions you want to automate.
  6. 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.
Advertisement

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?

  1. Click File and choose New.
  2. Pick a template from the list or search for one.
  3. Replace the placeholder text with your own information.
  4. 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

  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?
  4. What is a merge field, and give one example.
  5. 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:

  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.