Shelly Cashman Word 365/2021 | Module 8: SAM Project 1b Friends of the Ashby Public Library

GETTING STARTED

1. Save the file SC_WD365_2021_8b_FirstLastName_1.docx as SC_WD365_2021_8b_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_8b_Circulation.xlsx

Support_WD365_2021_8b_MF.docx

Support_WD365_2021_8b_Technology.xlsx

3. With the file SC_WD365_2021_8b_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. As a volunteer for the Friends of the Ashby Public Library, you are collaborating on a memo to Madeleine Frazier, the director of the organization. The memo summarizes statistics about the library in the past year. The director and another volunteer have reviewed the memo and made revisions using Word's Track Changes feature. Incorporate changes from Madeleine Frazier and the other volunteer, Kento Maki, as follows:

a. Combine the revisions from the document Support_WD365_2021_8b_MF.docx.

b. Show the changes in the original document.

c. Turn off Track Changes when you are finished.

2. Resolve the tracked changes in the document as follows:

a. Accept the first tracked change from Madeleine Frazier, which inserts the organization name and removes the placeholder text.

b. Accept the next tracked change, which is from Kento Maki and deletes "library's" to remove repetitive text.

c. Reject the next tracked change, which inserts "Ashby Public", because the name of the library has already been introduced.

d. Accept the remaining changes in the document because they improve or correct the writing.

3. In the pie chart, use Patron Visits as the chart title.

4. Embed data from an Excel workbook to include a table Kento created as follows:

a. Open the workbook Support_WD365_2021_8b_Circulation.xlsx.

b. Copy the data in cells A1:F6.

c. On page 2, use Paste Special to embed the worksheet data as a Microsoft Excel Worksheet Object in the blank paragraph in the "Circulation by Branch" section.

d. Close Support_WD365_2021_8b_Circulation.xlsx.

5. Insert a chart to comply with the request Madeleine Frazier inserted below the "Library Cards" table as follows:

a. Select the text "[Insert a chart comparing the data in the table]" below the "Library Cards" table, and then insert a Clustered Column chart.

b. Copy the table in the "Library Cards" section and then paste it in the chart spreadsheet window. (Hint: If prompted, click OK to continue.)

c. Remove the Total data series from the chart, and then 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 to improve its appearance as follows:

a. Apply Style 14 to the chart to display wider data columns.

b. Change the colors to Monochromatic Palette 5 to coordinate with the rest of the document.

c. Add a Red, Accent 5 border to clearly separate the chart from the table.

7. Link a chart from an Excel workbook to compare patron attitudes toward library technology as follows:

a. Open the workbook Support_WD365_2021_8b_Technology.xlsx.

b. Copy the "Attitude Toward Library Technology" 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_2021_8b_Technology.xlsx.

8. Change the chart type of the "Attitude Toward Library Technology" chart to a Pie chart to match the "Patron Visits" 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