The Excel and Internet Challenge: FLYING INTERNATIONAL
(PART 1)
For the following activity you will use the Internet, specifically expedia (www.expedia.com) and maybe other flight search engines such as AA, Q’antas and British Airlines (You may need to try new sites if you don’t find a site that will give you enough information- consult with me first).
“The rules”
You will depart from St. Louis on January 15th 2004 and stay out for a month (return date February 15th 2004). You will put the information you collect into an excel spreadsheet. The information you gathered will then be graphed using Excel and showed to the class in a compounded PowerPoint.
HINTS:
1-When checking for flights make sure you sort them by price.
2-Make the Excel table before looking for the information. J
Scenario:
I- You are thinking about flying (round-trip) to 6 different locations around the world:
· Australia (Sydney)- AUSTRALIA
· China (Beijing- PEK)- ASIA
· Italy (Rome)- EUROPE
· Canada (Ottawa)- NORTH AMERICA
· South Africa (Johannesburg)- AFRICA
· Kenya (Nairobi)- AFRICA
· Madagascar (Antananarivo)- AFRICA
· Peru (Lima)- SOUTH AMERICA
II- For each place you will be visiting you will need to get the following information. I recommend you to create a table in Excel first so that you can put the information as you find it on the web:
· Airlines you will be using.
· Departure City- Arrival City
· Cost of flight.
· Total number of stops. (And where you stop)
· Time it will take to get there (in hours).
· Total Distance you will fly (miles and meters).
· Time you will leave St. Louis and arrive to your destination (TIME not hours of traveling).
NOTES:
(- In some places there are more than one airport to choose. Make sure students chose the same one. E.g. Either the default top airport or one of your choice; Rome, Italy (ROM-All Airports; -Student will need to find using the internet what can be done to travel to Madagascar, look different sites, etc. For example or other sites for multiple traveling options <www.travelocity.com or www.priceline.com> use google)
Expedia values are estimates of Flights you can get cheaper flight to Kenya (e.g. $1500 for example) but Expedia is a good start.
III- Ask Mr. J for further Instruction for the Activity.
The Excel and Internet Challenge: FLYING INTERNATIONAL
(PART 2)
You probably couldn’t get information from www.expedia.com to travel to Madagascar (Antananarivo). To get this information you should try www.travelocity.com to find more about traveling to Madagascar. (Check the table given by this sites about schedules for flights.)
HINT: Not every day planes fly to Madagascar actually only three times a week.
NOTES: (One way to find the information in expedia.com is by changing the departure date to 11th JAN and return date FEB 16th 2004, since no planes fly on THU Jan 15th ) The student will need to change this value. Plus all flights to Madagascar go through PARIS chose first airport)
A) Complete the table with the missing information about Madagascar and add information about flying from St. Louis to Chicago, IL (ORD-O'Hare).
B) By now you should have:
· An excel table with all the information asked for in Part II (Air Plane, time, miles, etc).
C) Task 1: Copy the worksheet into a new worksheet. Give names to the two worksheets you have now. There default name right now are: sheet1, sheet2 and sheet 3 probably. Change the first two to: Sheet1 = Travel and Sheet2 = copy.
D) Task 2: Convert the values of time (23h 30mn) into hours with decimal points. That is 23h 30mn will be equal to 23.5. Do NOT put any character (h, mins, hours, etc). If you do this we will not be able to graph later on. (To do this calculations create a small calculation algorithm (equation) in your excel worksheet… ask for help if you are not sure)
E) Task 3: In a new column put the traveled distance in Kilometer (km) not miles by using a mathematical equation too. (Ask for help if you need to)
F) Final task: Create three bar charts as different worksheet
Note: Destination City should be in your X-axis
· Destination cities and Prices
· Destination cities and Time
· Destination cities and Distance in Miles
G) If FINISHED: Do the following graphs. Note: Destination City should be in your X-axis
· Destination cities and Prices (pie chart)
· Destination cities and Time in hours (pie chart)
· Destination cities and Distance in Miles (pie chart)
· Combination of Destination City, distance, time and price.
--------------------------------------------------------------------------------------------------------
Conversion
1 miles = 1.609344 kilometers
1 hour = 60 minutes