PowerPoint_3F_Report

Step

Instructions

Points Possible

1

Open the file named Student_PowerPoint_3F_Report.pptx downloaded with this project.

0

2

On Slide 3, in the content placeholder, insert a Line with Markers chart. In the worksheet, enter the following data: In row 1, beginning in cell B1, enter Taxes, City Fees, Capital Grants In row 2, beginning in cell A2, enter Quarter 1, 8074, 4154, 3525 In row 3, beginning in cell A3, enter Quarter 2, 6380, 3092, 3785 In row 4, beginning in cell A4, enter Quarter 3, 6695, 3260, 4150 In row 5, beginning in cell A5, enter Quarter 4, 7382, 6958, 2795

10

3

Apply Chart Style 7, and then apply the Wipe entrance effect to the chart.

10

4

Including the parentheses, change the Chart Title to (IN THOUSANDS).

10

5

On Slide 4, in the content placeholder, insert a Table with 2 columns and 5 rows. In the first row enter Item in the first cell and Description in the second cell. In the second row, in the first cell type Street Improvements and in the second cell, type Monroe Avenue asphalt, signage, and street lighting In the third row, in the first cell type City Buildings and in the second cell, type Infrastructure upgrades In the fourth row, in the first cell type Flood Control and in the second cell, type Main Street storm drain replacement In the fifth row, in the first cell type City Parks and in the second cell, type Monterey Park installation of two baseball diamonds

10

6

Change the height of the table to 4.36". Align the table text so that it is centered horizontally and vertically within the cells.

10

7

Apply table style Medium Style 3 - Accent 2, and then apply a Round Bevel effect to the first row. Note—Depending on your version of PowerPoint, this may be named Circle Bevel. Change the Font Size of the text in the first row to 24.

10

8

On Slide 5, in the content placeholder, insert a Clustered Column chart. In the worksheet, enter the following data: In row 1, beginning in cell B1: Year 1, Year 2, Year 3 In row 2, beginning in cell A2: Land, 71534, 72823, 83653 In row 3, beginning in cell A3: Structures, 95746, 95920, 97812 In row 4, beginning in cell A4: Equipment, 35042, 33465, 39767 In row 5, beginning in cell A5: Infrastructure, 111586, 121860, 125873

10

9

Apply Chart Style 4 to the chart, and then remove the Chart Title element.

10

10

Apply the Wipe entrance effect to the chart. Change the Effect Options so that the animation is applied By Series.

10

11

Change the chart animation Timing so that the animation starts After Previous.

8

12

Insert a Header & Footer on the Notes and Handouts. Include the Date and time updated automatically, the Page number, and a Footer with the text 3F_Report. Display the document properties. As the Tags, type city council report

2

13

Save and close the file, and then submit for grading.

0

Total Points

100