Skip to content

1. Plan a Vacation

Playback speed:

In this activity, you will imagine that you are taking a vacation.

Taking a trip requires a lot of decisions.

A spreadsheet can help you collect, organize, and compare all of the information.

To plan your vacation, you will first decide on a place to go.

You will create a spreadsheet to estimate and track all of the expenses you will have on the trip.

Then, you will research transportation, lodging, food, and entertainment costs and add these to your spreadsheet.

To make your task more challenging, you will be assigned a maximum budget that you cannot that you cannot exceed.

Try to spend all the money.

You should not have more than 50 dollars remaining at the end of your trip.

It might be difficult to imagine spending hundreds or even thousands of dollars in one week.

But travel costs add up quickly!

Spreadsheets can help you keep track of the many expenses involved.

The skills you learn about budgeting, saving, and organizing data apply to all kinds of travel, like field trips, business trips, stay-cations, and international vacations.

Instead of showing you how to construct your spreadsheet step by step, the optional videos in this unit will give you suggestions.

But you will set up the sheet, insert formulas, and choose how to visualize your data yourself.

When you finish, your spreadsheet will look similar to, but not exactly like this.

To get started, create a new spreadsheet.

Name the spreadsheet Vacation Budget.

Click the link on this page to receive a budget amount.

Record your budget in the spreadsheet.

Then, brainstorm with a classmate to decide where you’d like to go.

You might want to see the Grand Canyon or Yellowstone National Park or hit the beaches in Florida or Hawaii.

Perhaps you would prefer a famous amusement park, or maybe you would want to see a play on Broadway.

Choose any location that interests you while keeping your budget in mind.

Once you have decided on a location, add it to the name of your spreadsheet.

Now, it’s your turn: Create a new spreadsheet.

Name the spreadsheet Vacation Budget.

Click the budget amount link on the webpage to generate your budget amount.

Talk with a classmate about vacation locations for your budget.

Add the location to your spreadsheet name.

Then, move on to the next video to get suggestions for setting up your spreadsheet.


  1. Go to
  2. Open a new, blank spreadsheet.
  3. Name the spreadsheet "Spring Break Budget."
  4. Click the "Budget Generator link on this page to find out your budget amount.
  5. Talk with your classmate.
  6. Add the location to your spreadsheet name.
  • "Krystal Hotels - Cancun" by Krystal International Vacation Club ( -- Licensed by CC BY 2.0 ( -- Image scaled up cropping edge
  • "Class Field Trip to the Clark Preserve and boardwalk at Rossville" by Gary Bridgman ( -- Licensed by CC BY 2.0 ( -- Image scaled up, cropping edges