Shelly Cashman Word 365 | Module 8: SAM Project A Creekside Hospital Community Outreach
Collaborating on meeting minutes with charts
· Excel Projects Help
GETTING STARTED
1. Save the file SC_WD365_8A_FirstLastName_1.docx as SC_WD365_8A_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_8A_Events.xlsx
Support_WD365_8A_JM.docx
Support_WD365_8A_Survey.xlsx
3. With the file SC_WD365_8A_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 provide administrative support for the director of the Creekside Hospital Community Outreach Department that raises funds for the hospital and holds fitness classes and other events for outpatients. You have compiled the minutes of the latest department meeting and sent it to two colleagues, who have added their changes and sent the minutes back to you. Incorporate changes from your colleagues Josie Moore and Mumtaz Fawaz as follows:
a. Combine the revisions from the document Support_WD365_8A_JM.docx.
b. Show the changes in the original document.
2. Resolve the tracked changes in the document as follows:
a. Accept the first tracked change from Josie Moore, which inserts the word "Community" in the title to reflect the correct name of the department.
b. Accept the tracked change from Mumtaz Fawaz that adds the date of the meeting.
c. Reject the next tracked change, which deletes "Ali Garbon" and adds "Chuck Ogden" because it is incorrect.
d. Accept the remaining changes in the document because they improve or correct the writing.
3. Embed data from an Excel workbook as follows to include a table that Josie created:
a. Open the workbook Support_WD365_8A_Events.xlsx.
b. Copy the data in cells A1:F5.
c. Press ENTER to add blank Paragraph below the last paragraph (ending "…activities from March to May") in the "Fundraising Committee Report – Ali Garbon" section. Use Paste Special to embed the worksheet data as a Microsoft Excel Worksheet Object in the added blank paragraph.
d. Close Support_WD365_8A_Events.xlsx.
4. Modify the 3-D pie chart:
a. Change the Height to 3.3" so the pie chart fits on the same page as the table.
b. Use Funds Raised as the chart title.
5. Insert a chart as follows to comply with the request Mumtaz Fawaz inserted below the table in the "Fitness Committee Report" section:
a. Select the text "[Please insert a column chart to show this data]" below the table without selecting the paragraph mark, and then insert a Clustered Column chart.
b. Copy the Weekly Attendance table and then paste it in the chart spreadsheet window.
c. Close the chart spreadsheet window.
d. Delete the "Chart Title" placeholder object, since the placement of the chart makes the title unnecessary.
6. Format the chart as follows to improve its appearance:
a. Apply Style 6 to the chart to display wider data columns.
b. Change the colors to Monochromatic Palette 1 to coordinate with the rest of the document.
c. Add a Dark Teal, Text 2 (1st row, 4th column in the Theme Colors palette) border to clearly separate the chart from the table.
7. Link a chart from an Excel workbook as follows to compare outpatient responses to a survey about the quality of care they received at Creekside Hospital.
a. Open the workbook Support_WD365_8A_Survey.xlsx.
b. Copy the "Outpatient Satisfaction" doughnut chart, and then paste it as a link using the destination theme in the blank paragraph at the end of the document.
c. Close Support_WD365_8A_Survey.xlsx.
8. Change the chart type of the "Outpatient Satisfaction" chart to a 3-D pie chart using Chart Style 1 and Quick Layout 2 to match the "Fundraising Events" 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