Excellent Adventures is an exciting new simulation that combines the thrills of an amusement park with the spreadsheet skills. Excellent Adventures is a new amusement park located in the small town of Hartsville, approximately 20 miles north of Philadelphia, Pennsylvania. The grand opening of the park was a huge success, and due to its expanding growth, Excellent Adventures has a need for a Microsoft Excel Specialist.
There are 20 self-paced activities, typical of a theme park, which give students a "behind the scenes" look at the power of Excel and how it is applied to a real-world business that they will instantly relate to. From basic to advanced spreadsheet skills, students track, analyze, and chart many aspects of a successful amusement park business.
Benefits & Features
- Includes 20 easy-to-follow, self-paced projects
- Designed and formatted for today’s interactive, visual learner
- Projects are suitable for all levels of spreadsheets and increase in difficulty as students progress through the simulation
- Students can complete all or partial projects that meet course objectives, and may complete objectives in a non-sequential format
- All Assignments Submitted Online (from Student Portal to Instructor Portal)
- No textbooks or paper required
Activity 1
Park Division Contacts 1
Activity 2
North-South Map Legend 1
Activity 3
Monthly Admission Ticket Sales 1
Included with Your Purchase
- 24/7 access from anywhere, any device
- Source and Solution Files
- Performance Assessments and Solutions
- Certificate of Completion
- A comprehensive Curriculum Guide for mapping skills
Specifications
Grade: 6-8, 9-12
Item #: TB-EA-iA
ISBN: 978-1-626890-90-9
Author: The Development Team at B.E. Publishing
Introduction
All About Excellent Adventures
Activities
Activity 1
Park Division Contacts 1
View Skills
Skills
-
Enter and edit cell data
-
Change font size
-
Apply bold, italic, and underline
-
Center align cells
-
Resize columns
-
Save a spreadsheet
-
Use Print Preview
-
Set the Print Area
-
Insert a Header
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 2
North-South Map Legend 1
View Skills
Skills
-
Merge and center cells
-
Change font color
-
Change fill color
-
Format strikethrough style
-
Format nonadjacent cells
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 3
Monthly Admission Ticket Sales 1
View Skills
Skills
-
Use formulas to add and multiply numbers
-
Use Auto Fill to copy and paste a formula to adjacent cells
-
Format cells as currency
-
Display formulas in a workbook
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 4
Parking Revenue Report
View Skills
Skills
-
Use the =SUM function
-
Add nonadjacent cells
-
Apply borders
-
Format cell borders
Activity 5
Park Division Contacts 2
View Skills
Skills
-
Retrieve a saved file
-
Save a file as a different name
-
Insert blank columns
-
Hyperlink text to an email address
-
Print gridlines
Activity 6
North-South Map Legend 2
View Skills
Skills
-
Center spreadsheet horizontally and vertically
Activity 7
Monthly Admission Ticket Sales 2
View Skills
Skills
-
Rename worksheets
-
Insert multiple worksheets
-
Copy/paste data from multiple worksheets
-
Apply cell references from one worksheet to another
-
Use additional formulas with cell references from other worksheets
Activity 8
Vendor Database
View Skills
Skills
-
Name cell ranges
-
Sort data (Ascending)
-
Format cells as zip code
-
Format cells as phone number
-
Insert Data Validation
Activity 9
Ride Maintenance Schedule
View Skills
Skills
-
Format dates
-
Insert comments
-
Print showing comments
-
Create a custom sort
Activity 10
Average Ride Wait Time
View Skills
Skills
-
Use the =AVERAGE function
-
Format text orientation
-
Format time
Activity 11
Website FAQs
View Skills
Skills
-
Use Wrap Text
-
Format row height
Activity 12
Birthday Attendance Report
View Skills
Skills
-
Use the =MIN function
-
Use the =MAX function
Activity 13
Calendar of Events
View Skills
Skills
-
Use WordArt
-
Format cell indentation
-
Format horizontal and vertical alignment within cells
Activity 14
Purchase Requisition Form
View Skills
Skills
-
Use the =TODAY function
-
Insert/format a text box
-
Use the Format Painter
-
Format cells as Accounting
Activity 15
Purchase Requisition
View Skills
Skills
-
Format cells as percentage
-
Use the =IF function
Activity 16
Twitter Trends
View Skills
Skills
-
Create and format line charts
Activity 17
Top 5 Rides
View Skills
Skills
-
Create and format column charts
Activity 18
Expense Pie Chart
View Skills
Skills
-
Create and format pie charts
Activity 19
Annual Admissions Ticket Sales Revenue
View Skills
Skills
-
Use absolute cell reference
Activity 20
Table of Contents
View Skills
Assessments
Activity 1
Games Division Contacts 1 Assessment
Activity 2
Map Legend East-West 1 Assessment
Activity 3
Monthly Game Ticket Sales 1 Assessment
Activity 4
Snacks Revenue Report Assessment
Activity 5
Games Division Contacts 2 Assessment
Activity 6
Map Legend East-West 2 Assessment
Activity 7
Monthly Game Ticket Sales 2 Assessment
Activity 8
Customer Database Assessment
Activity 9
Game Maintenance Schedule Assessment
Activity 10
Average Restaurant Speed of Service Assessment
Activity 11
Handbook FAQs Assessment
Activity 12
Scholar Attendance Report Assessment
Activity 13
August Calendar Assessment
Activity 14
Purchase Order Form Assessment
Activity 15
Purchase Order Assessment
Activity 16
Facebook Trends Assessment
Activity 17
Top 5 Games Assessment
Activity 18
Expense Pie Chart Assessment
Activity 19
Game Ticket Sales Annual Revenue Assessment
Activity 20
Activity File List Assessment