Exp22_PowerPoint_Ch03_Cumulative_Bryce_Adventure_Camp
Exp22 PowerPoint Ch03 Cumulative Bryce Adventure Camp
PowerPoint Chapter 3 Cumulative – Bryce Adventure Camp
Project Description:
Bryce Adventure Camp is a successful outdoor retreat dedicated to the appreciation of the splendor and inspiration of nature for good health. The operation has been so successful in its two years of operation that the owners opened retreats in two additional locations. They now want to open another retreat so even more people can enjoy the exhilaration of nature in magnificent settings. They are meeting with officers of a venture capital corporation, that offers funding for unique opportunities. The representatives have asked for an overview of Bryce Adventure Camp’s philosophy, services and activities, sales for this year and last year, a year-to-year comparison, and charts showing the increase. The owners of Bryce Adventure Camp asked you for help in preparing the presentation for the meeting.
Start PowerPoint. Download and open the file named Exp22_PPT_Ch03_Cumulative_BryceAdventureCamp.pptx. Grader has automatically added your last name to the beginning of the filename.
Insert a Title and Content layout slide after Slide 1. Type Agenda in the Title Placeholder. Insert a Vertical Box List SmartArt graphic in the content placeholder.
Type the following in the Text pane:
Highlights and Activities
Lodging
Income
Revenue
Balance Sheet
Assets
Stock Performance
Change the SmartArt graphic to Lined List.
On Slide 4, convert the bulleted list to a Horizontal Bullet List SmartArt graphic. Apply the Intense Effect style to the SmartArt graphic and change the color to Colored Fill – Accent 6. Change the width to 10.5″.
Create a new slide following Slide 4 using the Title and Content layout. Type Adventure Prices: $10 per voucher in the title placeholder.
On Slide 5, create a table with four columns and seven rows in the content placeholder. Type the following into the table:
Row 1, Col 1: Adventure; Col 2: Duration; Col 3: Vouchers Required Private; Col 4: Vouchers Required Group (min 3 people)
Row 2, Col 1: Guided hike; Col 2: 1 hour; Col 3: 3; Col 4: 1
Row 3, Col 1: Rappelling; Col 2: 2 hours; Col 3: 8; Col 4: 4
Row 4, Col 1: ATV tours; Col 2: 2 hours; Col 3: 10; Col 4: 4
Row 5, Col 1: Fitness classes; Col 2: 1 hour; Col 3: 3; Col 4: 1
Row 6, Col 1: Horseback riding; Col 2: 2 hours; Col 3: 6; Col 4: 2
Row 7, Col 1: Zip line; Col 2: 1 ride; Col 3: 1
Note: the last entry in the last column is intentionally left blank.
On Slide 5, add a new row at the bottom of the table. Merge the cells in the new row. Type Camp Package: 10 Adventure Vouchers/$90 (All vouchers are non-refundable) in the new row. Set the table height to 4.7″ and the width to 11.7″. Apply the Medium Style 3 – Accent 6 table style to the table.
Make the following changes to the text in the table on Slide 5:
• Select the table and Center Vertically the text.
• Select the column headings and change the font size to 20 pt.
• Select the text in rows 2-7 of the third and fourth columns, and align Center.
• Select the text in the last row, and apply Italic.
Create a new slide following Slide 5 using the Title Only layout. Add the title Increase by Camp. Start Excel. Download, open, and save the file named Campprofits.xlsx. Copy the chart from the Increase by Camp worksheet. Embed the chart using Paste Options – Use Destination Theme & Embed Workbook on Slide 6.
Change the chart colors to Colorful Palette 1. Apply the Layout 10 Quick Layout to the chart.
Size the chart to a height of 4.8″ and width of 7.8″. Position the chart horizontally at 2.3″ and vertically at 1.9″. Apply a Black, Text 1 outline to the chart with a weight of 3 pt.
Create a new Slide 7 using the Title and Content layout. Type Top Five Reasons For Visiting Camp as the title.
Create a Clustered Bar chart with the following data:
In cell A1, type Reason, then populate A2:B6 with the following values:
Location/Sight-seeing 52%
Adventure Opportunities 22%
Relaxation 13%
Children’s Activities 8%
Spa and Fitness Facilities 5%
Change the source data to use the range A1:B6.
Make the following changes to the clustered bar chart:
• Apply Chart Style 12
• Change the colors to Monochromatic Palette 2
• Remove the title, legend, and x-axis
• Increase the font size of the Y-axis to 16 pt and apply Bold
• Add Outside End Data Labels
• Change the font size of data labels to 16 pt and apply Bold
Note, Mac users apply Chart Style 13.
Save and close Exp22_PPT_Ch03_Cumulative_BryceAdventureCamp.pptx. Submit the file as directed.