New Perspectives Word 365 | Module 7: End of Module Project 2 Montclair Public Library

GETTING STARTED

1. Save the file NP_WD365_EOM7-2_FirstLastName_1.docx as NP_WD365_EOM7-2_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_EOM7-2_Programs.xlsx

Support_WD365_EOM7-2_Projections.xlsx

3. With the file NP_WD365_EOM7-2_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 the assistant to the head librarian at the Montclair Public Library in Belleville, Ontario, you are preparing a report to present to the municipal council about the library's current and projected spending. On page 3, insert a horizontal line in the blank paragraph before the "Overview of Spending on Library Services" heading to separate the two main sections of the report. Change the height of the line to 3 pt and the color to Blue, Accent 3 to coordinate with the other colors in the report.

2. Open the Excel workbook Support_WD365_EOM7-2_Programs.xlsx, and then copy the data in the range A4:E10 so that you can include the spending data in the report. On page 3 of the Word document, select the "INSERT SPREADSHEET" placeholder text, and then paste the data as a link while keeping source formatting. If necessary, add a blank line following the pasted spreadsheet so a blank line appears both above and below the spreadsheet.

3. The spending amount for Storytime programs in 2027 is incorrect. In the Excel workbook Support_WD365_EOM7-2_Programs.xlsx, use $3,000 as the amount in cell E7. In the Word document, update the linked data, and then break the link to the Excel workbook since you no longer need a connection to it.

4. In the Excel workbook Support_WD365_EOM7-2_Programs.xlsx, copy the column chart so that you can include the chart in the report. In the Word document, select the "INSERT COLUMN CHART" placeholder text, and then use a Paste option to embed the chart while using the source formatting, which matches the formatting of the Word document. Close the Support_WD365_EOM7-2_Programs.xlsx workbook.

5. In the Word document, resize the column chart to a height of 2.6" so that it fits on page 3 after the text that introduces it. Add Program Expenses: 2024 to 2027 as the above chart title to identify the purpose of the chart. Add a legend at the bottom of the chart to indicate the meaning of each color in the columns.

6. On page 4, add data labels to the Outside End of the pie chart and display percentages instead of values to include the percentages on each slice. Display the legend at the bottom of the pie chart to match the placement of the legend in the column chart.

7. Open the Excel workbook Support_WD365_EOM7-2_Projections.xlsx, and then copy the bar chart so that you can include the chart in the report. In the Word document, select the "INSERT BAR CHART" placeholder text on page 4, and then use a Paste option to embed the chart while using the destination formatting to use the styles in the rest of the report. Close the Support_WD365_EOM7-2_Projections.xlsx workbook.

8. Change the style of the bar chart to Style 1 to match the style used with the column chart. Change the colors to Monochromatic Palette 3 to match the color used for the horizontal line you inserted on page 2. Remove the axis titles to reduce clutter in the chart.

9. The spending projection for Author Readings in 2028 needs to be updated. Edit the data in the bar chart to use $8,000 as the correct amount in cell C9.

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