Exp19_PowerPoint_Ch03_HOEAssessment_Energy_Saving_Tips

Project Description:

As an employee of Madison Electric, you give several presentations a year on home energy waste and how to save money. You want to update your presentation with new charts, a table and SmartArt graphics.

Start PowerPoint. Download and   open the file named Exp19_PPT_Ch03_HOEAssessment_Energy.pptx.   Grader has automatically added your last name to the beginning of the   filename. 

On Slide 2, insert a Target List   SmartArt graphic. Type the following in the Text pane as first level bullet   points. Remove any unneeded bullet points in the Text pane.
Saves   you money
Increases   the comfort level indoors
Reduces   our impact on climate change
Reduces   pollution

On Slide 4, click the first   picture on the left, press and hold CTRL, and then select each of the   remaining pictures moving from left to right. Click Picture Layout and insert   a Bending Picture Caption List SmartArt graphic.
 

  In the SmartArt Text pane type the text as follows (ensure that the text is   next to the appropriate image)
  • Seal   and insulate your home   (first image)
  • Buy   energy saving appliances (second image)
  • Install   a programmable thermostat (third image)
  • Replace   incandescent lights (fourth   image)
 

  Mac users, delete the four images on the slide, and then insert a Bending   Picture Caption List SmartArt graphic. Add a shape to the end to ensure there   are four shapes included in the SmartArt graphic. Add the following   downloaded images, in the order shown: SmartArtPicture1.png,   SmartArtPicture2.png, SmartArtPicture3.png, and SmartArtPicture4.png. Add the text as   instructed.

On Slide 2, apply the Inset 3D   Style to the SmartArt graphic and change the color to Colorful – Accent   Colors.

On Slide 4, apply the Inset 3D   Style to the SmartArt graphic and change the color to Colorful – Accent   Colors.

On Slide 6, insert a four   column, five row table in the content placeholder.
 

  Type the following information into the table:
  Row 1: Col 1: Setting; Col 2: Time; Col 3: Setpoint Temperature (Heat); Col 4: Setpoint   Temperature (Cool)
  Row 2: Col 1: Wake; Col 2: 6:00 a.m.; Col 3: <70° F; Col 4: >78° F
  Row 3: Col 1: Day; Col 2: 8:00 a.m.; Col 3: Setback at least 8° F; Col 4: Setup at   least 7° F
  Row 4: Col 1: Evening; Col 2: 6:00 p.m.; Col 3: <70° F; Col 4: >78° F
  Row 5: Col 1: Sleep; Col 2: 10:00 p.m.; Col 3: Setback at least 8° F; Col 4: Setup at   least 4° F
 

  Note, to add the degrees symbol (°), click the Symbol arrow in the Symbols   group on the Insert tab. In the Symbol dialog box, search for the symbol or   type 00B0   in the   Character code box. Mac users, add the degree symbol from the LETTERLIKE   SYMBOLS category.

Apply the Medium Style 2 –   Accent 2 table style.

Add a new column to the left of   column 1 in the table. Merge the cells in the new column. Type Recommended   Settings in the   new column and rotate all text 270°. Set the cell width of the merged cells   to 0.9″. Center the text in the cell. Change the cell shading to Dark   Red, Accent 1.

Set all of the text in the table   to Center Vertically. Change the width   of columns 2 and 3 to 2.2″ and the width of columns 4 and 5 to   3.3″. Set the table height to 3.4″.

On Slide 5, create a Clustered   Column chart with the following data:
  In cell A1, type Location and in cell B1 type % of Heat Loss.
  Then populate A2:B5 with the following values:
Roof/Attic 25%
Walls 35%
Windows/Doors 25%
Floor 15%
 

  Change the source data to use the range A1:B5.

Make the following changes to   the clustered column chart:
  • Apply Chart Style 10
  • Type Heat   Loss as the   chart title
  • Remove the legend and y-axis

Change the layout of Slide 3 to   Title Only.

Start Excel. Download and open   the file named HomeEnergyData.xlsx   and save it as HomeEnergyData_LastFirst.xlsx. Copy the chart from the Energy   Use worksheet and embed the chart using Paste Special on Slide 3. Mac users,   paste the chart as a Microsoft Excel Chart Object.

Change the chart height to 5.2″. Position the chart horizontally   at 3.35” and vertically at 2.2″.

Insert the HomeEnergy.png image on Slide 3. Position the image horizontally   at 5.9″ and vertically at 3.85“.

Save and close Exp19_PPT_Ch03_HOEAssessment_Energy.pptx.   Exit PowerPoint. Submit the file as directed.