Integrating office applications/Linking and embedding/Assessment

Integrating office applications

An introduction to integrating information from spreadsheets and databases into word-processing documents.
An OP Online course from the National Certificate in Computing (Level 2) programme.

About this course  |  Getting started  |  Course schedule  |  Assessment overview  |  Help

Portfolio Activity

The scenario Cottage Industries Ltd has sales data they wish to send out to retail outlets in a letter created in Microsoft Word. The letter has been created as a Word document and the sales data has been entered and graphed in an Excel spreadsheet. Instructions Download and save the Cottage Industries Letter (Word document file). This is the document you will use as the basis for your project. Download and save the Retail Sales Figures (Excel spreadsheet file). This provides the data table and chart that will need to be integrated into the letter. Embed the table of Retail Sales Figures into the appropriate place in the letter and format it as necessary - leave out the column of 2011 figures Embed the Sales Comparison chart into the appropriate place in the letter and format it as necessary Replace the name of the Production Manager (Moana Ching) with your own name Save your work - you will need to work with this file later in the assessment for Unit 2

|