Name: __________________________
Date Due: _______________________
Background
One of the most commonly used functions of word processors in modern businesses is a mail merge. This allows businesses to contact many people in a very efficient way. In the past secretaries would need to type many letters over and over with changes to names and addresses or send out a one generic letter with no personal details. With a mail merge clients or prospective clients can receive a letter, including personal details, with the secretary only writing one version of the letter.
Another tool that is commonly used by businesses is a spreadsheet. This tool allows the user to tabulate statistical information, calculate results and produce charts. Once these charts are produced they are often sent to clients or prospective clients in the form of a letter to show performance of the company.
The Task
You are to produce a mail merged business letter for an imaginary company that includes a chart inserted from a spreadsheet. The company you use and the information you provide is entirely up to you. Remember though that you will receive a higher mark for the complexity of your letter and chart. It is also hoped that your spreadsheet will include a calculation.
Note: It is essential that your letter is in the format of a business letter.
You will need to hand in:
Marking Key
Name: _______________Satisfactory |
Good |
Outstanding |
|
| Unmerged letter? | |||
| 2 merged letters? | |||
| Print out of data source with 5 clients? | |||
| Chart? Calculation? Appearance? Other? |
|||
| General Presentation | |||
| Extras? |
This exercise forms part of your "Portfolio" and will not be formally assessed until the end of the year. As a guide, if it were part of a formal "Task" based on the course Outcomes, it would have been assessed at a level of:
Not Demonstrated (ND) |
Satisfactory (S) |
High (H) |
Very High (VH) |
Teacher: ______________________
Comments:
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
_______________________________________________________________________
Staple this feedback sheet to the original and drafts and place them in your Portfolio for safe-keeping until the end of the year. Your teacher keeps no record of this exercise other than whether it was submitted. If you lose this work, you will get no credit for it later.