Vance's PI Computing Classes

Integrating keyboarding and language skills with MS Office

Advanced Word and Excel Integrated Skills Exercise

Instructions for Students

This exercise is to be done in one class period. It will test your ability to type a short document, format it according to Advanced Word features recently taught, link it dynamically to an Excel spreadsheet, and present a mail-merged result.

Step One

Prepare a spreadsheet reporting your last 5 Keyboarding Tutor typing speed and accuracy combinations

Special instructions for the Keyboarding Progress spreadsheet

If you wish you can use this worksheet to keep your records.
Start your chart off with 4 columns as shown at right.
As you complete the Keyboarding lessons, fill in the data as shown in the insert. Don't include the text in the last three lines.

Step Two

Prepare a spreadsheet database of Foundation Computing instructors

Use these data, with 'Title' in cell A1 of your spreadsheet:

Title	First	Last	Position	Office
Mr.	Richard	Pheasant	Coordinator	215
Mr.	Vance	Stevens	Lecturer	217
Mr.	Kevin	Bonner	Lecturer	213
Mr.	Neil	Westly	Lecturer	211

Step Two

Please be patient,
the following is ...

Prepare a memo reporting your progress

Copy this text into your word processor (the faster you type, the faster you can do this)
Format the memo (as in this example)

In your memo, you need to have the following (see the hidden characters here)

A header with title of document at left margin and date at right margin
A footer with your ID number and name at bottom left
Drop cap as shown
Insert PI logo, alligned square
One 2 column section
All text in font ...
A dynamic link to the spreadsheet, which you can update later in future versions of this memo
A line graph copied from the spreadsheet and pasted in the word document to illustrate the results shown in the spreadsheet (does not have to be dynamic)
Copies mail merged to all 4 computing teachers

Submit what you can to Work Finished (for a grade) a mail merged document (4 letters) called (for example) 007yourname082sn_typing-word-excel

This update: May 4, 2004
Address questions or comments in email to vstevens at pi.ac.ae or http://www.vancestevens.com/contactv.htm