Dream Travel Project
Mr. Snell has just won the lottery and because you are so special he has given you $5,000 for your dream vacation. The only stipulation is that you must go on a vacation that is outside of North America for exactly seven days and spend exactly $5,000. Since your teacher wants you to use the money well, he has asked you to submit a budget for your travel plans before you can receive the money. Make your budget with Excel. Also include one page in Word with a map, three pictures with captions describing each one, and a list of three website references that you have used. Use sites like Travelocity, Expedia, and Lonely Planet.
Excel Part
1. Title of Trip, use WORD ART ______
2. Your Name, put under the title_____
3. Your columns, starting in column B are:
Day 1, Day 2, Day 3, Day 4, Day 5, Day 6, Day 7
4. Below are the row headings: Enter all your headings and sub headings before you enter any number data.
Main Row Headings in Bold:
Sub row Headings UNDER main row headings:
_____Transportation
Air (example)
Bus (example)
Choose for sure: Air
And you must add one of these: rental car, bike, snow mobile, bus, train, taxi
_____Accommodations
Hotel (example)
Choose at least one: Hotel, motel, condo, inn, or campground fee ( You may not sleep in a car or at any friends’/relatives’ houses)
_____Entertainment
Choose at least ONE event per day: Something that you can do in the area you are visiting.
_____Meals
Choose ONLY one traditional meal with one real price; add it in per day. US chain food stores like McDonald's is not an option.
_____Spending Money
If you have completed your trip and have some money left over use this column for reaching your $5000 dollar total.
_____Total
Spreadsheet must include a daily total and a grand total that adds up to $5,000.00, with formulas.
Word Part
Word portion with pictures, captions and references must be complete; spelling and grammar must be correct; and all information must be REAL! BON VOYAGE!!!
4. Make sure to Copy/Paste your Website References! Into a References section in your Word document.
FOUR Web References Total: ____ ____ ____
5. At least one picture of a traditional meal you will eat there ____
With typed caption____
6. At least one readable map of the location you will visit ____
With typed caption____
7. At least one picture of the hotel/overnight place you will stay at ____
With typed caption____
8. At least two pictures of an event or activity you will do ____ ____
With typed caption____
When you are finished you will have two documents that you will load to edmodo. One document is the Dream spreadsheet the other is the Dream Reference.
Objective: SWBAT Create an original work as a means of expression
Language Objective: SWBAT Use content vocabulary correctly
Mr. Snell has just won the lottery and because you are so special he has given you $5,000 for your dream vacation. The only stipulation is that you must go on a vacation that is outside of North America for exactly seven days and spend exactly $5,000. Since your teacher wants you to use the money well, he has asked you to submit a budget for your travel plans before you can receive the money. Make your budget with Excel. Also include one page in Word with a map, three pictures with captions describing each one, and a list of three website references that you have used. Use sites like Travelocity, Expedia, and Lonely Planet.
Excel Part
1. Title of Trip, use WORD ART ______
2. Your Name, put under the title_____
3. Your columns, starting in column B are:
Day 1, Day 2, Day 3, Day 4, Day 5, Day 6, Day 7
4. Below are the row headings: Enter all your headings and sub headings before you enter any number data.
Main Row Headings in Bold:
Sub row Headings UNDER main row headings:
_____Transportation
Air (example)
Bus (example)
Choose for sure: Air
And you must add one of these: rental car, bike, snow mobile, bus, train, taxi
_____Accommodations
Hotel (example)
Choose at least one: Hotel, motel, condo, inn, or campground fee ( You may not sleep in a car or at any friends’/relatives’ houses)
_____Entertainment
Choose at least ONE event per day: Something that you can do in the area you are visiting.
_____Meals
Choose ONLY one traditional meal with one real price; add it in per day. US chain food stores like McDonald's is not an option.
_____Spending Money
If you have completed your trip and have some money left over use this column for reaching your $5000 dollar total.
_____Total
Spreadsheet must include a daily total and a grand total that adds up to $5,000.00, with formulas.
Word Part
Word portion with pictures, captions and references must be complete; spelling and grammar must be correct; and all information must be REAL! BON VOYAGE!!!
4. Make sure to Copy/Paste your Website References! Into a References section in your Word document.
FOUR Web References Total: ____ ____ ____
5. At least one picture of a traditional meal you will eat there ____
With typed caption____
6. At least one readable map of the location you will visit ____
With typed caption____
7. At least one picture of the hotel/overnight place you will stay at ____
With typed caption____
8. At least two pictures of an event or activity you will do ____ ____
With typed caption____
When you are finished you will have two documents that you will load to edmodo. One document is the Dream spreadsheet the other is the Dream Reference.
Objective: SWBAT Create an original work as a means of expression
Language Objective: SWBAT Use content vocabulary correctly