Vacation Planning
Congratulations!
You have just won the “In Your Dreams” vacation lottery where you will be able to customize your 5 days, 4 nights all expenses paid family trip. However, your trip is only valid for your household family members and any location within the continental United States.
To get started, download the contest entry Google Doc HERE.
(To add the doc to your drive, go to File -> Make a Copy. Important- when you are renaming your document title, please begin with your
LAST NAME, First initial Vacation Planning)
Some websites that may help you find prices for accommodations and transportation are:
5. http://www.usairways.com/default.aspx
7. http://www.cheaptickets.com
11. http://www.gaspricewatch.com/new/default_V3.asp
14. http://www.avis.com/car-rental/avisHome/home.ac
15. http://www.amtrak.com/home
Some websites that may help you find a place to stay:
1. http://www.tripadvisor.com/
3. http://www.ichotelsgroup.com
4. http://www.marriott.com/default.mi
6. http://www.bedandbreakfast.com/
7. http://www.orbitz.com/hotels/
Recreation fees may include anything from surf lessons to admissions to a theme park:
1. http://disneyworld.disney.go.com
6. http://www.sixflags.com/national/index.aspx
These websites may help you find online menus to budget your food expenses:
1. http://www.olivegarden.com/default_f.asp
5. http://www.mcdonalds.com/us/en/home.html
7. http://www.outbacksteakhouse.com/
9. http://www.tripadvisor.com/
Vacation Budget Spreadsheet
The next step is to take your research from your Google Doc Vacation Planning Worksheet, and creating a monetary budget. Remember, all the prices you will be using can be found in your worksheet (you already did the research, now were are calculating it).
Here are important characters you will need to know when typing your functions/formulas:
= tells the program you need to complete a function (math problem)
: through, which means a range of cells (ex: rows 1 through 5 in column A would be typed as A1:A5)
+ addition
* multiplication
You will also need to calculate sub totals and totals of different parts of your budget using formulas & functions. Remember start by clicking in the cell you want your answer to appear in, then start typing your formula. Below are some of the calculations you will need to find:
- Total per person; Adult- transportation + 3 meals + 3 entertainment
- Total per person; Child- transportation + 3 meals + 3 entertainment
- Subtotals for Adults- total per adult x number of adults
- Subtotals for Children- total per child x number of children
- Family Total for transportation, meals and entertainment- Adult Sub Total + Children Sub Total
- Total Stay- price per night + total nights
- Grand Total- family total + total stay
Don't forget that the cell name is what is important (not the numbers inside) when typing your functions/formulas.
Refer to the picture to the right for the correct location for your information.
Finished Example
My Map for My Vacation
Watch the video below to learn how to use Google My Maps
Please complete the following:
- Watch the above video to learn how to use the program.
- In your drive, create a New- My Map. Title the project Vacation Map to (Destination Here).
- Add a new layer for Lodging and add the address of your hotel (in your Google Doc planning worksheet)
- Add a second layer for Restaurants and add your 3 restaurants.
- Add a third layer for Entertainment and add your 3 things to do.
- Then go back and Customize: you can change the icons for your pins, add a brief description about the location and add photos of your location (maybe the outside of the building or a sign/logo).
Finished Example:
Have a great trip, and don't forget to send a postcard!
