Shelly Cashman Word 2016 Module 8: SAM Project 1a

Shelly Cashman Word 2016 Module 8: SAM Project 1aShelly Cashman Word 2016 Module 8: SAM Project 1aLearn to PlayCOLLABORATE ON A MEMOGETTING STARTEDOpen the file SC WD16 8a FirstLastName 1.docx, available for download from theSAM website.Save the file as SC WD16 8a FirstLastName 2.docx by changing the “1” to a “2”.If you do not see the .docx file extension in the Save As dialog box, do not type it. Theprogram will add the file extension for you automatically.To complete this SAM Project, you will also need to download and save the followingdata files from the SAM website onto your computer:Support SC WD16 8a Memo-EN.docxSupport SC WD16 8a Users.xlsxWith the file SC WD16 8a FirstLastName 2.docx still open, ensure that your firstand last name is displayed in the footer.If the footer does not display your name, delete the file and download a new copy fromthe SAM website.PROJECT STEPSYou are a project assistant at Learn to Play, a website that teaches people howto play a musical instrument. You and a colleague are collaborating on a memoto your manager that summarizes the data gathered about website users.1.Start by combining the revisions from the fileSupport SC WD16 8a Memo-EN.docx, available for download from theSAM website, into your SC WD16 8a FirstLastName 2.docx document asfollows:a.On the Review ribbon, click the Compare button, and select Combine.b.Choose your SC WD16 8a YourName 2.docx as the Originaldocument, and label unmarked changes in the original document usingMia Williams as the name

Shelly Cashman Word 2016 Module 8: SAM Project 1ac.Choose Support SC WD16 8a Memo-EN.docx as the Reviseddocument, and label unmarked changes in the revised document using EdNader as the name.d.Click the More button, and choose to show the changes in the originaldocument, then click OK.e.After combining the documents, right-click the status bar at the bottom ofthe screen. If there is a not a checkmark next to Track Changes, click itto turn on the checkmark.

Shelly Cashman Word 2016 Module 8: SAM Project 1aLook at the status bar – if there is a message that says “Track Changes: On”, click on itso that it changes to “Track Changes:Off”.If multiple windows are open, close the windows on the right (click the x in theupper right to close), and close the window on the left. Only the originaldocument should be open.If necessary, click the arrow for the Markup on the Review ribbon, and selectAll Markup.2.To accept the revision from Ed Nader to the company name (“Company Name”)to include the correct company name in the memo, press Ctrl Home to movethe cursor to the top of the document, then click Next on the Review ribbon tomove the cursor to the first revision (Learn to Play), then click the Acceptbutton on the ribbon to accept the revision. If necessary, click the Acceptbutton again to delete “Company Name”.

Shelly Cashman Word 2016 Module 8: SAM Project 1a3.When the cursor moves to the next revision from Mia Williams to the firstsentence (“ to compile basic information ”), click the Reject button to rejectthe revision and leave the word “compile”. If necessary, click Reject again toremove the word “gather”.4.Read the first comment from Ed Nader (on the right), make the change hesuggests, and then with his comment still selected click the Delete button onthe Review ribbon to delete his comment.5.Read the first two comments from Mia Williams, make the changes shesuggests, and then delete both comments.6.To accept all of the remaining changes in the document because they are allcorrect revisions, click the arrow on the Accept button, and click Accept allchanges.

Shelly Cashman Word 2016 Module 8: SAM Project 1a7.Click on the next comment from Ed Nader, click Reply right below thecomment 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 shesuggests to list the terms and definitions in the same order as in the table, andthen delete the comment.9.In the sentence beginning with “The following numbers ” in the secondparagraph, change “numbers” to table and chart so that the sentence beginswith “The following table and chart summarize the findings ”.10.Click at the end of the second paragraph, then click the New Comment buttonon the Review ribbon. Insert a comment with the following text:I am planning to post this memo on our blog on Monday.

Shelly Cashman Word 2016 Module 8: SAM Project 1a11.12.To add visual appeal to the document, format the Learn to Play Website UserAnalysis table as follows:a.To Apply the Grid Table 4 – Accent 6 style to the table, click anywherein the table, then click the Table Tools Design ribbon. Select GridTable4 – Accent 6 in the Table Stylesb.To AutoFit the table to the window, select the Table Tools/Layoutribbon, then click the Autofit button, and select AutoFit Window.To insert a chart in the blank paragraph below the table, click the blank linebelow the table, and complete the following:a.On the Insert ribbon, click Chart, then choose Clustered Column.

Shelly Cashman Word 2016 Module 8: SAM Project 1a13.b.In the Word document, select the Learn to Play table (click thebutton in the upper left corner of the table) and right-click and copyc.In the chart spreadsheet window, click the Select all button (upper-leftcorner of the worksheet), then right-click and Paste (if you get amessage about your contents being a different size, click OK)d.To delete the last column from the chart, click the top of column D toselect the entire column, then right-click and select Delete. Then closethe spreadsheet.Apply the following formatting to the clustered column chart so its designcoordinates with the rest of the document:a.Select the chart, then on the Chart Tools Design ribbon change thechart style to Style 2.b.Click the Change Colors button, and change the chart colors toMonochromatic Palette 6 in the Change Colors gallery.c.Change the chart title to the following:USER ANALYSISd.To change the height of the chart, click the outside edge of the chart,then select the Chart Tools Format ribbon, and change the height to2.5” so it fits on the first page.

Shelly Cashman Word 2016 Module 8: SAM Project 1a14.In the blank paragraph on page two (below September Users by Age), insertExcel data as follows to list September user data by age:a.Open the file Support SC WD16 8a Users.xlsx, available from theSAM website, in Excel.b.Copy the data in cells A1:B7.c.Go back to the Word document, click the arrow on the bottom of thePaste button on the Home ribbon, and select the Link and Keep SourceFormatting button. Close the Excel file.

Shelly Cashman Word 2016 Module 8: SAM Project 1a15.16.17.Make the new table of Excel data more attractive and remove the connection tothe original Excel workbook by doing the following:a.Center the table on the page in the Word document (Hint: select theentire table, then click the Center button on the Home ribbon.)b.To break the link to the Excel worksheet, right-click the table, point toLinked Worksheet Object, click Links, then click Break Link. ClickYes when it asked if you are sure you want to break the selected link.In the blank paragraph below the new table, insert and format a chart todisplay the user data graphically as follows:a.Click Insert, then Chart, and 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 (Hint: see #12, steps b and c).Format the pie chart in the Word document to make it more meaningful andattractive as follows:a.To change the chart type to a Doughnut chart, select the chart, thenselect the Chart Tools Design ribbon. Click the Change Chart Typebutton, and select Doughnut.b.Change the chart title to the following:September Users by Agec.To display the legend at the top of the chart, right-click the legend (it’sbelow the Doughnut), and click Format Legend. In the task pane on theright side of the screen choose Top for the legend position.d.To add an outline to the chart, select the outside edge of the chart.Select the Chart Tools Format ribbon, and click the Shape Outlinearrow. Select the Red, Accent 6 (10th column, 1st row in the ThemeColors palette) outline color.

Shelly Cashman Word 2016 Module 8: SAM Project 1ae.Click the Shape Effects arrow, and add an Offset: Center shadow shapeeffect (2nd column, 2nd row in the Outer Shadow palette) to the entirechart.The document SC WD16 8a FirstLastName 2.docx should look like the Final Figureon the following pages. Save your changes, close the document, and exit Word. Followthe directions on the SAM website to submit your completed project.

Shelly Cashman Word 2016 Module 8: SAM Project 1aFinal Figure

Shelly Cashman Word 2016 Module 8: SAM Project 1a

Shelly Cashman Word 2016 Module 8: SAM Project 1a 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 t