|
MANAGERIAL USE OF ICT
School Management using a Word Processing application
In a school, there are many instances when
the school management have to send a document with an identical
body to many correspondents, such as parents. The current
approach is to have a cycle-styled document with details filled
by hand. This can be not only laborious but could be a source
of embarrassment if names and other particulars contain inaccuracies
such as spelling mistakes.
It would be much nicer if each recipient could receive a copy
that has all the addresses and other particulars inserted by
the computer rather than by hand. This is the motivation for
the activity illustrated by the following exercise:
Exercise
A school wishes to recruit people into
a number of positions that have been advertised to fulfill
its plans to establish a School-based Multi-purpose telecenter.
A number of people have responded to the advertisements and
their interviews have been fixed as shown in the table below:
Use the mail merge feature to create the
letters to the applicants provided in the table below such
that each individual receives the letter with his/her necessary
details. You may use the following field names:
appDate – for application
date
jobTitle – for job
title
intDate – for interview
date
intTime – for interview
time
hotelName – for the hotel
venue for the interview
Name –
for the names of the applicant
Create the data source using the following table
|
NAME
|
APPLICATION DATE
|
JOB TITLE
|
INTERVIEW DATE
|
INTERVIEW TIME
|
HOTEL
|
|
JOHN MASSA
|
<12/9/01
|
PROGRAMMER |
1/12/01
|
1100
|
Equatoria
|
|
HENRY OTIENO
|
10/10/01
|
TECHNICAL WRITER
|
1/12/01
|
1500
|
Nile
|
|
ROSE NYACHWO
|
15/9/01
|
DATABASE MANAGER
|
1/12/01
|
1700
|
Nile
|
|
JAMES KINTU
|
12/9/01
|
LAN SPECIALIST
|
2/11/01
|
1100
|
Fairway
|
|
FULTON OPOKA
|
14/9/01
|
MARKETING
|
2/12/01
|
1300
|
Sheraton
|
|
HILARY CHOMBO
|
19/9/01
|
MARKETING
|
3/11/01
|
1430
|
Sheraton
|
|
JACKIE ONEN
|
12/10/01
|
MAINTENANCE
|
4/12/01
|
1600
|
Equatoria
|
|
JANE OTTO
|
9/9/01
|
PROGRAMMER
|
1/12/01
|
1000
|
Colline
|
Date: <insert day’s date> e.g.
Thursday, September 27, 2001
From:
The Board of Governors,
Budo Junior School,
Plot 4A Neptune Street,
Market Plaza,
KAMPALA.
Subject: Your Application dated <applicDate>
for the post of <jobTitle>
Dear <Name>
You are required to attend the final interview on <intDate>
for the post of <jobTitle> at . The interview
is to be held at Hotel <hotelName>.
Please bring your original passport, a copy of your biodata
and all testimonials along with one duplicate copy for our
use during the evaluation following the interview. Also bring
6 passport size photographs.
Thank you.
John Muzzanganda
Chairman Board of Governors
Next: Mail Merge
|
