Family Activities
NAME: ____________________________________________ Modified Travel Project 2011
INTRODUCTION Your family has asked you to plan a vacation for the first week of April (leave on Sunday, return the next Sunday). You will be traveling to a state of your choice. You will need to plan eight (8) activities/places you and your family members want to visit. You have to keep in mind the individual interests of your “pretend” family. Family Member #1: Mother
Historical landmark/location
Family Member #2: Father
National/state park
Family Member #3: Your older sister
College/University
Family Member #4: Your little brother
Sporting event/sport
Family Member #5: You
???? Your choice
In addition, you will need to choose three additional activities which you believe the whole family will enjoy together.
PROCESS You will need to plan this family vacation using the TASK sheet with this packet. Also included are RESOURCES on the Internet which may help you to plan your trip. Read the information closely for specific information. You will be creating spreadsheets, making graphs, calculating distances, etc. READ the directions closely.
This project is worth: 50 points Deadline for written project: Friday February 11, 2011 Project Checklist includes: _____ Task #1: State Summary Sheet (typed) _____ Task #2: Family Activities Sheet (typed) _____ Task #3: Itinerary (typed) – see an example – you have to complete this for EACH DAY; you can budget free time! _____ Task #4: Budget (Excel) _____ Task #5: Graph (Excel)
Modified Travel Project 2011
TASK #1 – STATE SUMMARY > Choose a state and use the website below to help you find the information about the state you chose. > http://www.50states.com > This page will be typed
Your Name: State Name: 1.
Population
2.
State Capital
3.
Largest City
4.
Other major cities
5.
Climate (average temperatures)
6.
State flower
7.
State bird
8.
State song
9.
Major tourist attractions
10.
Unemployment rate
Other information you found out about the state (minimum of five things): 11. 12. 13. 14. 15.
Modified Travel Project 2011
TASK #2 – Family Activities Use this worksheet to make a list of the 3 activities you find for each family member. One helpful site is: http://www.us-national-parks.net/ You will need to research other sites on your own. When you are researching, make note of the costs of the activities because you will need them later. This page will be typed. 1.
Mom (historical location or museum) a. b. c.
2.
Dad (National Park or outdoor location) a. b. c.
3.
Big Sister (colleges/universities) a. b. c.
4.
Little Brother (sporting event or other athletic activity) a. b. c.
5.
You (?????) a. b. c.
NEXT: Pick the 8 activities (from the 15 you’ve found). Remember to have at least one for each family member. You are narrowing your above list from 15 (3 each) to a total of eight (8). 1. 2. 3. 4. 5. 6. 7. 8.
Modified Travel Project 2011
TASK # 3 – Itinerary For this task you will be completing an itinerary for your family vacation. You must format the itinerary so it is easy to read and follows the sample. Your itinerary should include for each of the 7 days:
Scheduled time for 3 meals Family activity of the day Travel time Rest/relaxation time.
Sample Itinerary for Project
Itinerary For (Family Name)’s Family Vacation to (Name of Destination) Sunday, March 28th 9 a.m.
Leave Columbus Airport, Delta Airlines, Flight 222
10:00 a.m.
Arrive San Francisco, CA Pick up rental car Drive to Westin Hotel Do . . . .
12:00 noon
Eat lunch at …….
2:00 p.m.
Go . . . .
5:00 p.m.
Stay overnight in San Francisco at the Westin Swim, eat at hotel and watch movie
Monday, March 29th 9 a.m.
Leave San Francisco, to go to . . . . . . .?????
Continue in this manner until you have returned home!!! YOU NEED 7 DETAILED DAYS OF ACTIVITIES FOR YOUR INTINERARY!
Modified Travel Project 2011
TASK #4 – Excel Budget
For this task you will use Excel to create a budget Use the sample as a guideline on how to set up your budget Your budget should include: o All possible costs including: Lodging Transportation for all family members to your vacation destination and while you are at your destination All scheduled activities Incidental costs Souvenirs Food o Your budget should meet the following appearance guidelines Title, column labels, costs in $, use formulas to calculate total costs Appropriate font and easy to read Use formatting techniques to make the spreadsheet attractive Calculate total for each category and for entire vacation o Save & print o Print once all on one page o Print again showing formulas ALL ON ONE PAGE
MY FAMILY VACATION Food Budget
Transportation Flight 6 day car rental
Total
$1,000 $500
$1,500
Breakfast
$300.00
Souvenirs Mom
$20.00
Incidentals Emergency Fund
Activities
$100.00
College Visit
$ $50.00
-
Lunch
$400.00
Dad
$20.00
Gas
$50.00
Historical Site
Dinner
$600.00
Siblings
$30.00
Fun Activities
$50.00
Park
$30.00
Snacks
$200.00
Me
$50.00
Water Park
$300.00
Total
$1,500.00
Total
$120.00
Total
$380.00
Grand Total for Vacation $3,700.00
Modified Travel Project 2011
Total
$200.00
TASK #5 – Graph/Chart
Graph the budget Using the spreadsheet’s graphing options, select a graph which will best show the various amounts of money spent on the following categories: o Transportation o Food o Lodging o Activity costs You will need to determine the setup!
Modified Travel Project 2011
TASK SUMMARY 1.
Research the state of your destination. Complete Task #1: State Summary (included in this packet) -- TYPE
2.
Determine activities to meet your family’s interests. Plan on a ONE WEEK (7 Day, 6 Night) TRIP. Complete Task #2: Family Activities (included in this packet) -- TYPE
3.
Plan your route, sequence family activities, type itinerary. Complete Task #3: Outline your route/travel using itinerary (example in this packet).
4.
Determine a budget for your trip. Include transportation to and from, food each day, lodging for the week, activity costs for each activity and each person. You must include a total dollar for each item AND total dollar amount for the entire trip. Complete Task #4: Organize your trip budget using a spreadsheet.
5.
Using the spreadsheet’s graphing options, select a graph which will best show the various amounts of money spent on the following categories: transportation, food, lodging, and activity costs. You will need to determine setup! Complete Task #5: Graph your trip’s budget.
Modified Travel Project 2011
EVALUATION You will need to complete all the tasks to have a completed project. The grading rubric will be as follows: ITEM
EXCELLENT (A) (10)
Completion of Assigned Tasks (Sheet #1 and Sheet #2)
Outstanding Effort Well done Neatly completed all assigned tasks Went above and beyond in finding additional points of interest
Satisfactory Completed all tasks
Minimal Effort Completed fewer tasks than required
Little/No Effort Completed one or no tasks
Activity Selections
Well planned Exceeded all family members’ interests Complete itinerary for each day included.
Some type of family plan of activities which do not meet all family member interests Itinerary included with most days and activities
No plan of activities for family members
Itinerary
Planned minimum number of activities that meet all family members’ interests Itinerary included, but one day or activity is missing
All costs included Easy to read and understand Font appropriate Used formulas
All costs included Hard to read or understand Font appropriate
Missing one cost Hard to read or understand Font not appropriate
Missing more than one cost Hard to read Font not appropriate
Yes Easy to read/understand Font appropriate
Yes Hard to read/understand Font appropriate
Yes Hard to read/understand Font not appropriate
None
Spreadsheet of Budget Information
Imported Graph of Budget Information
GOOD (B) (9-8)
FAIR (C) (7)
POOR (D-F) (6-0)
Did not do itinerary or only did one day
STUDENT NAME: _______________________________________ FINAL GRADE: _________
Modified Travel Project 2011
INTRODUCTION Your family has asked you to plan a vacation for the first week of April (leave on Sunday, return the next Sunday). You will be traveling to a state of your choice. You will need to plan eight (8) activities/places you and your family members want to visit. You have to keep in mind the individual interests of your “pretend” family. Family Member #1: Mother
Historical landmark/location
Family Member #2: Father
National/state park
Family Member #3: Your older sister
College/University
Family Member #4: Your little brother
Sporting event/sport
Family Member #5: You
???? Your choice
In addition, you will need to choose three additional activities which you believe the whole family will enjoy together.
PROCESS You will need to plan this family vacation using the TASK sheet with this packet. Also included are RESOURCES on the Internet which may help you to plan your trip. Read the information closely for specific information. You will be creating spreadsheets, making graphs, calculating distances, etc. READ the directions closely.
This project is worth: 50 points Deadline for written project: Friday February 11, 2011 Project Checklist includes: _____ Task #1: State Summary Sheet (typed) _____ Task #2: Family Activities Sheet (typed) _____ Task #3: Itinerary (typed) – see an example – you have to complete this for EACH DAY; you can budget free time! _____ Task #4: Budget (Excel) _____ Task #5: Graph (Excel)
Modified Travel Project 2011
TASK #1 – STATE SUMMARY > Choose a state and use the website below to help you find the information about the state you chose. > http://www.50states.com > This page will be typed
Your Name: State Name: 1.
Population
2.
State Capital
3.
Largest City
4.
Other major cities
5.
Climate (average temperatures)
6.
State flower
7.
State bird
8.
State song
9.
Major tourist attractions
10.
Unemployment rate
Other information you found out about the state (minimum of five things): 11. 12. 13. 14. 15.
Modified Travel Project 2011
TASK #2 – Family Activities Use this worksheet to make a list of the 3 activities you find for each family member. One helpful site is: http://www.us-national-parks.net/ You will need to research other sites on your own. When you are researching, make note of the costs of the activities because you will need them later. This page will be typed. 1.
Mom (historical location or museum) a. b. c.
2.
Dad (National Park or outdoor location) a. b. c.
3.
Big Sister (colleges/universities) a. b. c.
4.
Little Brother (sporting event or other athletic activity) a. b. c.
5.
You (?????) a. b. c.
NEXT: Pick the 8 activities (from the 15 you’ve found). Remember to have at least one for each family member. You are narrowing your above list from 15 (3 each) to a total of eight (8). 1. 2. 3. 4. 5. 6. 7. 8.
Modified Travel Project 2011
TASK # 3 – Itinerary For this task you will be completing an itinerary for your family vacation. You must format the itinerary so it is easy to read and follows the sample. Your itinerary should include for each of the 7 days:
Scheduled time for 3 meals Family activity of the day Travel time Rest/relaxation time.
Sample Itinerary for Project
Itinerary For (Family Name)’s Family Vacation to (Name of Destination) Sunday, March 28th 9 a.m.
Leave Columbus Airport, Delta Airlines, Flight 222
10:00 a.m.
Arrive San Francisco, CA Pick up rental car Drive to Westin Hotel Do . . . .
12:00 noon
Eat lunch at …….
2:00 p.m.
Go . . . .
5:00 p.m.
Stay overnight in San Francisco at the Westin Swim, eat at hotel and watch movie
Monday, March 29th 9 a.m.
Leave San Francisco, to go to . . . . . . .?????
Continue in this manner until you have returned home!!! YOU NEED 7 DETAILED DAYS OF ACTIVITIES FOR YOUR INTINERARY!
Modified Travel Project 2011
TASK #4 – Excel Budget
For this task you will use Excel to create a budget Use the sample as a guideline on how to set up your budget Your budget should include: o All possible costs including: Lodging Transportation for all family members to your vacation destination and while you are at your destination All scheduled activities Incidental costs Souvenirs Food o Your budget should meet the following appearance guidelines Title, column labels, costs in $, use formulas to calculate total costs Appropriate font and easy to read Use formatting techniques to make the spreadsheet attractive Calculate total for each category and for entire vacation o Save & print o Print once all on one page o Print again showing formulas ALL ON ONE PAGE
MY FAMILY VACATION Food Budget
Transportation Flight 6 day car rental
Total
$1,000 $500
$1,500
Breakfast
$300.00
Souvenirs Mom
$20.00
Incidentals Emergency Fund
Activities
$100.00
College Visit
$ $50.00
-
Lunch
$400.00
Dad
$20.00
Gas
$50.00
Historical Site
Dinner
$600.00
Siblings
$30.00
Fun Activities
$50.00
Park
$30.00
Snacks
$200.00
Me
$50.00
Water Park
$300.00
Total
$1,500.00
Total
$120.00
Total
$380.00
Grand Total for Vacation $3,700.00
Modified Travel Project 2011
Total
$200.00
TASK #5 – Graph/Chart
Graph the budget Using the spreadsheet’s graphing options, select a graph which will best show the various amounts of money spent on the following categories: o Transportation o Food o Lodging o Activity costs You will need to determine the setup!
Modified Travel Project 2011
TASK SUMMARY 1.
Research the state of your destination. Complete Task #1: State Summary (included in this packet) -- TYPE
2.
Determine activities to meet your family’s interests. Plan on a ONE WEEK (7 Day, 6 Night) TRIP. Complete Task #2: Family Activities (included in this packet) -- TYPE
3.
Plan your route, sequence family activities, type itinerary. Complete Task #3: Outline your route/travel using itinerary (example in this packet).
4.
Determine a budget for your trip. Include transportation to and from, food each day, lodging for the week, activity costs for each activity and each person. You must include a total dollar for each item AND total dollar amount for the entire trip. Complete Task #4: Organize your trip budget using a spreadsheet.
5.
Using the spreadsheet’s graphing options, select a graph which will best show the various amounts of money spent on the following categories: transportation, food, lodging, and activity costs. You will need to determine setup! Complete Task #5: Graph your trip’s budget.
Modified Travel Project 2011
EVALUATION You will need to complete all the tasks to have a completed project. The grading rubric will be as follows: ITEM
EXCELLENT (A) (10)
Completion of Assigned Tasks (Sheet #1 and Sheet #2)
Outstanding Effort Well done Neatly completed all assigned tasks Went above and beyond in finding additional points of interest
Satisfactory Completed all tasks
Minimal Effort Completed fewer tasks than required
Little/No Effort Completed one or no tasks
Activity Selections
Well planned Exceeded all family members’ interests Complete itinerary for each day included.
Some type of family plan of activities which do not meet all family member interests Itinerary included with most days and activities
No plan of activities for family members
Itinerary
Planned minimum number of activities that meet all family members’ interests Itinerary included, but one day or activity is missing
All costs included Easy to read and understand Font appropriate Used formulas
All costs included Hard to read or understand Font appropriate
Missing one cost Hard to read or understand Font not appropriate
Missing more than one cost Hard to read Font not appropriate
Yes Easy to read/understand Font appropriate
Yes Hard to read/understand Font appropriate
Yes Hard to read/understand Font not appropriate
None
Spreadsheet of Budget Information
Imported Graph of Budget Information
GOOD (B) (9-8)
FAIR (C) (7)
POOR (D-F) (6-0)
Did not do itinerary or only did one day
STUDENT NAME: _______________________________________ FINAL GRADE: _________
Modified Travel Project 2011
