PowerPoint_3F_Report

p03F_final_result.jpgPowerPoint_3F_Report_Instructions.docx
PowerPoint_3F_Report
     
Open   the file named Student_PowerPoint_3F_Report.pptx downloaded with this project.
 
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
 
Apply Chart Style 7, and then   apply the Wipe entrance effect to the chart. 
 
Including the parentheses,   change the Chart Title to (IN THOUSANDS).
 
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
 
Change the height of the table   to 4.36″. Align the table text so   that it is centered horizontally and vertically within the cells. 
 
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.
 
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
 
Apply Chart Style 4 to the   chart, and then remove the Chart Title element. 
 
Apply the Wipe entrance effect   to the chart. Change the Effect Options so that the animation is applied By   Series. 
 
Change the chart animation   Timing so that the animation starts After Previous.
 
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
 
Save and close the file, and   then submit for grading.