Integrating Applications: Spreadsheets and Word Processing
Updated:  03/10/2007 10:41:53 AM

Learning objectives

This assignment teaches you about building models and documents that work together in an integrated business activity.

• The first model will be a spreadsheet.  It will enable you to use the same calculations, formulas and charts with different data.  The practice assignment deals with building a student grade book.  The actual assignment involves creating a sales summary that will be used with different sales data each month.
• The second model will be a mail merge.  You will create a form letter within word that will act as a template.  You will merge that form letter with actual information from the spreadsheet to create customized reports.

Resources

Review the "Building Models" section of the Spreadsheet Modeling lesson.  This information provides a central context for this lesson.

Your best source of material for completing this assignment will come from what you learned while completing assignments 6 and 7. The optional class textbook (Running Microsoft Office)  does not contain material specifically designed to support the spreadsheet portions of this assignment.

Read the Chapter "Using Word to Automate Mailing", in Running Microsoft Office. In addition, we have prepared a series of video clips about using Microsoft Word's Mail Merge feature (use the [Back] button on your browser to return to this page).

Several of the video clips about Microsoft Excel are directly applicable to this assignment (use the [Back] button on your browser to return to this page).