Shelly Cashman Word 365/2021 | Module 8: End of Module Project 1 Boulder Game Studio
COLLABORATING ON A MEMO WITH CHARTS
· Excel Projects Help

GETTING STARTED
1. Save the file SC_WD365_2021_EOM8-1_Mac_FirstLastName_1.docx as SC_WD365_2021_EOM8-1_Mac_FirstLastName_2.docx
a. Edit the file name by changing “1” to “2”.
b. If you do not see the .docx file extension, do not type it. The file extension will be added for you automatically.
2. To complete this Project, you will also need the following files:
Support_WD365_2021_EOM8-1_Mac_Platforms.xlsx
Support_WD365_2021_EOM8-1_Mac_Sanderson.docx
3. With the file SC_WD365_2021_EOM8-1_Mac_FirstLastName_2.docx open, ensure that your first and last name is displayed in the footer.
a. If the footer does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. You are a marketing assistant for Boulder Game Studio (BGS), a video game developer in Boulder, Colorado. Bryan Sanderson, the vice president of marketing, asked you to draft a memo to all employees announcing the upcoming release of the company's games. Another BGS vice president, Rosa Valdez, has already reviewed and revised the memo. Now you need to incorporate revisions from Bryan before sending the memo to him for a final review. Combine Bryan Sanderson's revisions from the document Support_WD365_2021_EOM8-1_Mac_Sanderson.docx with the Project file. Use the Project file as the original document and Support_WD365_2021_EOM8-1_Mac_Sanderson.docx as the revised document. (Hint: In the Combine Documents dialog box, be sure to combine documents in the original document, rather than in the revised document or a new document.)
2. Display All Markup, if necessary, and then accept the first tracked change from Bryan Sanderson, which adds text to the Subject line. Reject the next tracked change, which inserts "improvements and", because it is repetitious. Accept the next tracked change, which is from Rosa Valdez and inserts the word "revisions" to clarify the sentence. Accept the remaining changes in the document because they improve the content.
3. With Track Changes turned on, insert the text Game Studio in the To line so that the memo is addressed to "All Boulder Game Studio employees". Display Simple Markup and turn off Track Changes when you are finished.
4. Insert a Clustered Column chart in the blank paragraph below the "December Game Updates" table to respond to Bryan Sanderson's request. Delete the existing data in the chart spreadsheet window, and then copy the "December Game Updates" table and paste it in the spreadsheet. Remove the Total column in the chart spreadsheet window, and then close the window. (Hint: If the chart does not display correctly, try resizing it slightly.)
5. Delete the "Chart Title" placeholder object since the placement of the chart makes the title unnecessary. Add Number of Updates as the Primary Vertical axis title to make the chart easier to interpret.
6. Open the workbook Support_WD365_2021_EOM8-1_Mac_Platforms.xlsx. Copy the data in cells A1:E6. In the blank paragraph in the "Market Update: Platforms" section on page 2, paste the Excel data as a link using source formatting. Break the link between the "Share of Revenue (%) by Platform" table and the source data in the Excel workbook because the data will not change. (Hint: Break the link by hovering over the table and holding the control key while clicking. In the context window, click "Links", then click "Break Link".) Close the Excel workbook.
7. Respond to Bryan Sanderson's second comment by changing the pie chart to a 3-D Pie chart to add visual interest. Apply Style 1 to the pie chart to match the style of the Clustered Column chart. Change the colors to Colorful Palette 1.
8. Add Developers per Platform as the chart title above the chart to identify the contents. Add a Dark Gray, Text 2 border to emphasize the boundaries of the chart.
Your document should look like the Final Figure on the following pages. Save your changes, close the document, and then exit Word. Follow the directions on the website to submit your completed project.
Final Figure
