DREAM VACATION
TECHNOLOGY PROJECT BASED UNIT
DREAM VACATION
TASK:
In this real –life
simulation, each of you will be given $2,500 to spend on an
8 day/7nights dream vacation.
You and your friend have the freedom to choose your vacation destination;
however, your means of transportation must be by airplane and you may not
choose an all inclusive package. For your final project you will design and
present a promotional brochure.
NAME:
____________________________ CORE: _____
DREAM VACATION
ACTIVITY CHECKLIST
Check off each activity as you complete it.
MINI – LESSON: OR ACTIVITY WORKSHEET
Find the percent of a number. 7.1 C
Use proportions to solve percent problems. 7.2 A
Use decimals to solve percent problems. 7.3 C
Use equations to solve percent problems. 7.4 C
BENCHMARK:
Find a percent of change in a quantity.
Find markups, discounts, sales tax and tips.
Calculate interest earned and account balances.
HOMEWORK WORKSHEET:
7.1 Practice
7.2 Practice
7.3 Practice
7.4 Practice
7.5 Practice
7.6 Practice
7.7 Practice
QUIZZES/TESTS:
Chapter 7 Quiz 1
Chapter 7 Quiz 2
Chapter 7 Test
PROJECT:
Itinerary Worksheet: (handout #1)
Mircosoft Word document detail itinerary
Expense Worksheet: (handout #2)
Microsoft Excel spreadsheet and pie chart
Microsoft Word created brochure
Sign up for time to present your Dream Vacation
NAME:
____________________________ CORE: _____
DREAM VACATION
ITINERARY WORKSHEET
(handout #1)
PLANNING YOUR VACATION:
As you plan your vacation,
with a friend you must keep a detailed itinerary. Use this worksheet to help
you organize your information.
1.
Vacation
destination: _______________________________
2.
Travel
Dates:
_____________________________________
(remember you have 8 days/7 nights)
3.
Airline
carrier:
____________________________________
4.
Flight Details: __________________
5.
Lodging: _________________________________________
List amenities:
Websites:
|
Travel planner |
|
|
Travel planner |
|
|
Get directions here. |
|
|
Travel planner |
NAME:
____________________________ CORE: _____
DREAM VACATION
PROCEDURE:
Use your itinerary worksheet (handout #1) to create a Microsoft
Word document that details all the information below.
·
Destination:
(Where are you traveling to?)
·
Travel Dates:
(When will you be leaving and returning?)
·
Airline Carrier:
(Which airline carrier will you be flying?)
·
Flight Details:
(How long will you be flying to reach your destination?)
·
Lodging: (Where
will you be staying?)
·
Amenities: (What
does your lodging offer?)
DREAM VACATION
EXPENSES
1. Use the Expense Worksheet (handout #2) to itemize your
expenses.
2. Get your Expense Worksheet (handout #2) approved by your
teacher. Then
create a
Microsoft Excel Spreadsheet using the Expense Worksheet (handout
#2)
to determine your vacation budget, include all
expenses. See “how to” sheet.
3. Create a pie graph in Microsoft Excel using the numbers in the
percent
column of
Dream Vacation Expenses.
DREAM VACATION
MICROSOFT EXCEL
HOW TO SHEET
Using Microsoft Excel you will enter your expenses from handout #2 onto an expense spreadsheet.
Open a Microsoft Excel worksheet and create a vacation budget to list all your expenses.
- Be sure to include the following expense categories:
- Transportation
- Lodging
- Food
- Entertainment
- Other
- Use Microsoft Excel’s AutoSum function to add up the cost of these expenses.
EXAMPLE: Using the dollar amounts of each vacation expense, you will find the fraction, decimal and percent of the total. Follow the example below.
|
DREAM VACATION EXPENSES |
|
|
||
|
|
|
Fraction |
|
|
|
Total Expenses |
Dollar Amt |
Dollar Amt |
Decimal |
Percent |
|
|
|
|
|
|
|
Transportation |
$554.40 |
79/713 |
0.11 |
11.1% |
|
Lodging |
$1,880.32 |
236/625 |
0.38 |
37.8% |
|
Food |
$1,440.00 |
36/125 |
0.29 |
28.8% |
|
Entertainment |
$525.00 |
21/200 |
0.11 |
10.5% |
|
Other |
$590.00 |
59/500 |
0.12 |
11.8% |
|
TOTAL |
$4,989.72 |
4,989.72/5000 |
0.99 |
99.0% |
*Remember, your total dollars cannot exceed $5,000.
(you and your friends combined $2,500)
NAME: ____________________________ CORE: _____
DREAM VACATION
EXPENSE WORKSHEET
(handout #2)
Calculate
your expenses using this worksheet.
Include the following detailed travel
expenses:
o
Transportation:
(How much will it cost to get there and back?)
o
Lodging: (How
much will your stay cost?)
o
Food: (For the
entire stay, how much will you spend on food?)
o
Entertainment:
(How much will you spend on activities?)
o
Other: (Anything
else you think you might need money for.)
Fraction
Total Expenses Dollar Amts Dollar Amts Decimal Percent
Transportation $
Lodging $
Food $
Entertainment $
Other $
*Total
Dollars $
*Remember, your total dollars cannot exceed
$5,000.
APPROVED
BY TEACHER: _________
DREAM VACATION
BROCHURE:
Create
a brochure using Microsoft Word . See “how to”
sheet. Be sure to include the following
details in your brochure:
·
At least two
pictures or graphics
·
A map of your
destination
·
Microsoft Excel
spreadsheet and pie chart
·
Microsoft word
detailed itinerary
PRESENTATION:
Together
with your partner practice your presentation. Sign up for a time to present
your Dream Vacation. Good Luck
DREAM VACATION
ACTIVITY LIST
DAY
1:
Objective: SW use a fraction to find
the percent of a number.
Warm –u