Week 2 · Unit 8.1: Communicating with others using digital tools · 3 lessons
2
Letters that know your name
Digital Literacy 8: Unit 8.1, objectives 8TC.03, 8TC.01
GoalExplain how a master document and a list work together in a mail merge, and name the benefits and risks.
New words
master document · the main letter that holds the fixed text and the blank fieldsmail merge · joining one master document with a list to make a personal copy for each persondata list · a table of names and other details, one row for each personmerge field · a blank in the master document that takes its words from the list
Explanation
Imagine writing 200 letters, each with a different name. A mail merge does the work in one go. You write one master document with the fixed text and put merge fields where the personal parts go, such as [first name] and [group]. You also make a data list, a table with one row for each person. The word processor joins them: for row one it fills the fields with the words from row one, for row two with row two, and so on. You get a personal letter for each person without typing 200 times. The benefits are speed and accuracy. The risks are mistakes in the list, which appear in the letters, and the privacy of the list. A list of names should be kept safe and shared only with people who need it.
Master document+→Data list=→Merge→One letter for each row
Worked examples
A
B
C
1
first name
group
day
2
Ana
Rockets
Tue
3
Kenji
Plants
Wed
4
Mia
Rockets
Tue
The invented Hilltop Science Club writes one master letter. The merge fields are shown in square brackets. The data list is below it.
Letter
Dear Kenji, your Plants group meets on Wed in the school lab. Please bring a notebook.
The second person on the list, Kenji, gets this letter. Notice that the master document did not change; only the fields were filled.
A
B
C
1
first name
group
day
2
Ana
Rockets
Tue
3
Leo
Rockets
Thu
A mistake in the list becomes a mistake in the letter. Here the list has the wrong day for one row. Always check one or two test letters against the list before printing them all.
Class activity
Hand-made merge (on paper, no computer). Write a short master letter for an invited school event. Put two merge fields in square brackets, such as [name] and [time]. Make a data list of four invented first names with times. Swap with a partner. Your partner writes the four letters by hand, filling in the fields. Check each letter against the list and find one deliberate mistake the original writer hid in the list. Then say what a person must check before sending a real merge. If you have a computer or tablet, try a mail merge with your invented list.
Practice
1
The master letter says: ‘Dear [name], your [group] group begins at [time] on [day].’ Look at the list and write the letter for the second person on the list.
A
B
C
D
1
name
group
time
day
2
Yuki
Painters
2 pm
Friday
3
Omar
Bakers
3 pm
Monday
Dear Omar, your Bakers group begins at 3 pm on Monday. Use only the second person’s name, group, time and day.
2
A school sends a merge letter to 120 families, but the list has a family’s name spelled wrongly. Who notices and what can the school do?
The family will notice the wrong name and may feel the school is careless. The school can check a few test letters against the list before printing, and ask someone else to read the list. Correcting the list fixes all future letters.
3
Give one reason the data list for a mail merge needs to be kept private.
It holds the names of real people. If strangers could see it, they could misuse it. It should only be shared with people who need it and stored safely.
4
Which is the master document and which is the data list?
A
Dear [first name], please bring [item] on [day].
B
Mina – pencil – Monday | Ravi – ruler – Tuesday
The letter with the blanks in square brackets is the master document. The table of names and details is the data list.