Computer | Computer Science homework help

New Perspectives Word 2019 | Module 7: SAM Project 1a

Washburn Home Health Care

New Perspectives Word 2019 | Module 7: SAM Project 1a

Collaborating on a report


Open the file
, available for download from the SAM website.

To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:





With the file
still open, ensure that your first and last name is displayed in the footer.

If the footer does not display your name, delete the file and download a new copy from the SAM website.

In this Project, you will Combine two Word documents. Be sure to save your completed file as
after completing the Project Steps and before submitting your file for grading.


As a financial analyst for Washburn Home Health Care, you are helping Sarah Alvarado, the director of the Financial Development Division, to create a marketing analysis report summarizing expansion plans. Sarah has reviewed a draft of the report using tracked changes. You will add her comments and revisions to your copy of the report and then complete it.

Combine documents as follows to incorporate Sarah’s revisions and comments into your copy of the report:

Combine your document (the original document) with the file
Support_WD19_7a_Sarah.docx. [Mac Hint: If prompted, select the file to grant access.]

Select all the Comparison settings and show changes in the original document.

Turn on Track Changes and display
All Markup for review. Accept and reject tracked changes in the document as follows:

Accept each change in the first body paragraph because the changes improve the paragraph.

In the second body paragraph, reject the change to the text “Washburn Home Health Services” so that the bold formatting is removed.

Accept the remaining changes in the document, which are also improvements.

On page 2, with Tracked Changes on, apply the
Heading 1 style to the heading “Executive Summary” because this heading begins a new major topic.

Turn off Track Changes. Read the first comment in the document, and then respond to Sarah’s request as follows:

In the blank paragraph after the first paragraph on page 2 (“The secondary market…for service coordination.”), insert a pie chart.

Type the chart data as shown in Figure 1.

Change the chart colors to
Colorful Palette 4.

Figure 1: Pie Chart Data

Read the second comment in the document, and then respond to Sarah’s request as follows:

Open the workbook

In the
Market Projections worksheet, copy the column chart.

Return to the report document, and then move the insertion point to where Sarah instructs you to insert the column chart.

Link the chart to the document using the destination theme to keep the chart data the same in both locations while using the report document’s theme.


Modify the linked chart as follows to suit the design of the Word document and to update data:

In the report document, add
Projected Customers as the chart title.

Change the chart style to
Style 2 to display values on each segment of the columns.

Read the next comment in the document, and then continue editing as follows:

Open the workbook

In the
Services worksheet, copy cells A1:F5.

Return to the report document, and then move the insertion point to where Sarah instructs you to insert the data about competitors.

Paste Special to embed the worksheet selection in the Word document as a
Microsoft Excel Worksheet Object so that it retains the layout of the original worksheet. The source data is unlikely to change, so you do not need to link it to the source file.

Modify the embedded worksheet by formatting the text using the
Automatic font color.


Delete all the comments in the document because they are no longer needed.

On the last page in the document, insert a bookmark to the “Competitive Analysis” heading using
Competition as the bookmark name to make it easy to find the table of competitor’s data.

At the end of the first sentence in the document, format the word “competition” as a hyperlink to the “Competition” bookmark.

Insert another hyperlink as follows to make it easy for readers to access an external document:

In the last paragraph in the document, format the word “here” as a hyperlink that targets the document

Add a ScreenTip with the following text:

Table of top ten competitors

Your document should look like the Final Figure on the following pages. Rename your completed file to NP_WD19_7a_FirstLastName_2.docx. Save your changes, close the document, and then exit Word. Follow the directions on the SAM website to submit your completed project.

Final Figure

© Anton Foltin/; © dikobraziy/; ©










Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more