Homework answers / question archive / Shelly Cashman Word 2016 | Module 8: SAM Project 1a Learn to Play COLLABORATE ON A MEMO GETTING STARTED ? Open the file SC_WD16_8a_ FirstLastName _1

Shelly Cashman Word 2016 | Module 8: SAM Project 1a Learn to Play COLLABORATE ON A MEMO GETTING STARTED ? Open the file SC_WD16_8a_ FirstLastName _1

MS Word

Share With

---

Shelly Cashman Word 2016 | Module 8: SAM Project 1a

Learn to Play

COLLABORATE ON A MEMO

GETTING STARTED

?

Open the file

SC_WD16_8a_

FirstLastName

_1.docx

, available for download

from the SAM website.

?

Save the file as

SC_WD16_8a_

FirstLastName

_2.docx

by changing the “1” to

a “2”.

o

If you do not see the

.docx

file extension

in the Save As dialog box, do not

type it. The program will add the file extension for you automatically.

?

To complete this SAM Project, you will also need to download and save the

following data files from the SAM website onto your computer:

o

Support_SC_WD16_8a_Memo-EN.docx

o

Support_SC_WD16_8a_Users.xlsx

?

With the file

SC_WD16_8a_

FirstLastName

_2.docx

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.

PROJECT STEPS

1.

You are a project assistant at Learn to Play, a website that teaches people how

to play a musical instrument. You and a colleague are collaborating on a memo

to your manager that summarizes the data gathered about website users.

Start by combining the revisions from the file

Support_SC_WD16_8a_Memo-

EN.docx

, available for download from the SAM website, into your

SC_WD16_8a_

FirstLastName

_2.docx

document as follows:

a.

Label unmarked changes in the original document

(SC_WD16_8a_

FirstLastName

_2.docx) using

Mia Williams

as the name.

b.

Label unmarked changes in the revised document

(Support_SC_WD16_8a_Memo-EN.docx) using

Ed Nader

as the name.

c.

Show the changes in the original document.

d.

After combining the documents, turn off Track Changes.

2.

Accept the revision from Ed Nader to the company name (“Company Name”) to

include the correct company name in the memo.

3.

Reject the revisions from Mia Williams to the first sentence (“...to compile basic

information...”) to avoid repetition.

4.

Read the first comment from Ed Nader, make the change he suggests, and then

delete his comment.

5.

Read the first two comments from Mia Williams, make the changes she

suggests, and then delete both comments.

6.

Accept all of the remaining changes in the document because they are all

correct revisions.

7.

Read the next comment from Ed Nader and then insert the following reply:

I inserted a column chart below the table.

8.

Read the remaining comment from Mia Williams, make the change she suggests

to list the terms and definitions in the same order as in the table, and then

delete the comment.

9.

In the sentence beginning with “The following numbers...” in the second

paragraph, change “numbers” to

table and chart

so that the sentence begins

with “The following table and chart summarize the findings...”.

10.

At the end of the second paragraph, insert a comment with the following text:

I am planning to post this memo on our blog on Monday.

11.

To add visual appeal to the document, format the Learn to Play Website User

Analysis table as follows:

a.

Apply the

Grid Table 4 – Accent 6

style to the table.

b.

AutoFit the table to the window.

12.

In the blank paragraph below the table, insert a chart based on the information

in the table to comply with Ed Nader’s request as follows:

a.

Choose

Clustered Column

as the chart type.

b.

Copy the Learn to Play Website User Analysis table and then paste it in the

chart spreadsheet window.

c.

Remove the Percent Changed data series from the chart, and then close

the spreadsheet.

13.

Apply the following formatting to the clustered column chart so its design

coordinates with the rest of the document:

a.

Change the chart style to

Style 2

.

b.

Change the chart colors to

Monochromatic Palette 6

in the Change

Colors gallery.

c.

Change the chart title to the following:

USER ANALYSIS

d.

Change the height of the chart to

2.5”

so it fits on the first page.

14.

In the blank paragraph on page two, insert Excel data as follows to list

September user data by age:

a.

Open the file

Support_SC_WD16_8a_Users.xlsx

, available from the SAM

website, in Excel. (

Hint

: If necessary, Hide Source Documents before

completing this step.)

b.

Copy the data in cells A1:B7.

c.

Paste the data as a link, keeping the source formatting, and then close the

support file.

15.

Make the new table of Excel data more attractive and remove the connection to

the original Excel workbook as follows:

a.

Center the table on the page in the Word document.

b.

Break the link to the Excel worksheet.

16.

In the blank paragraph below the new table, insert and format a chart to display

the user data graphically as follows:

a.

Choose

Pie

as the chart type.

b.

Copy the table you just inserted, paste the data in the chart spreadsheet,

and then close the spreadsheet.

17.

Format the pie chart in the Word document to make it more meaningful and

attractive as follows:

a.

Change the chart type to a

Doughnut

chart.

b.

Change the chart title to the following:

September Users by Age

c.

Display the legend at the top of the chart.

d.

Add an outline to the chart using the

Red, Accent 6

(10

th

column, 1

st

row

in the Theme Colors palette) outline color.

e.

Add an

Offset: Center

shadow shape effect (2

nd

column, 2

nd

row in the

Outer Shadow palette) to the entire chart.

18.

The document

SC_WD16_8a_

FirstLastName

_2.docx

should look like the Final

Figure on the following pages. Save your changes, close the document, and exit

Word. Follow the directions on the SAM website to submit your completed

project.