Computer Applications I :: Projects :: YHS Travel
Problem
You are a travel agent for YHS Travel. You are going to be planning a vacation package that will take place anywhere between June 15th and August 15th of 2025. The package should depart from Chicago and can be to any travel destination you choose. The trip should NOT take the entire time frame above and should last no more than two weeks.
Use websites such as Expedia, Kayak, Travelocity, Orbitz, or an individual airline's website to find airfare information. In Excel you will use the information that you gathered about different flights in a spreadsheet. Create columns for the following information: Airline name (there may be more than one name in this cell), Class, Destination Information (departure and arrival times as well as flight numbers will be included here), Return Information (departure and arrival times as well as flight numbers will be included here), Round Trip Price. The columns will include the following information:
- Airline: The name of the airline. There may be more than one airline if your flight has stops.
- Class: Choose five economy/coach flights and five first class/business class flights.
- Destination Information: There should be three columns included in this section that list the departure time from Chicago, the arrival time at the destination, and the flight number.
- Return Information: This should be the same as the Destination Information section, but should detail the flight returning to Chicago at the end of the trip.
- Cost: Cost of the round trip flight.
This spreadsheet will be part of your final exam project so keep it in a safe place. Since it is part of the final there is no rubric.
