Create Charts Assignment
Microsoft Excel
Requirements: Using internet travel services, develop the cheapest, 7-night vacation in Honolulu, Hawaii for New Year's 2002 as possible. The hypothetical vacationer must be in Hawaii on January 1, 2002, and can not travel (arrive or depart) on that day.

---

Basic Assignment Option:

Step 1: Browse airline web sites, such as Delta.com (www.delta.com) or United.com (www.united.com), to find the cheapest roundtrip flights to Honolulu, HA for New Year's Day 2002.
Step 2: When you find the cheapest rate, print the pricing page as proof.
Step 3: Assume additional trip expenses: Hotel=$700, Rental Car=$400, Food=$300, Entertainment=$250.
Step 4: Use Microsoft Excel to create a spreadsheet to display all trip expenses.
Step 5: Create a chart to visually display trip expenses. Insert graph into spreadsheet.
Step 6: Submit Excel spreadsheet w/graph via email attachment to the instructor. Submit printed copy of airline pricing sheet in class on due date.

* Scoring Rubric *

Full Credit Excel spreadsheet w/graph All expenses on graph Pricing sheet submitted

Partial Credit Excel spreadsheet w/graph All expenses on graph No pricing sheet submitted

No Credit Excel spreadsheet-no graph Some expenses on graph No pricing sheet submitted

---

Intermediate Assignment Option:

Step 1: Browse airline web sites, such as Delta.com (www.delta.com) or United.com (www.united.com), to find the cheapest roundtrip flights to Honolulu, HA for New Year's 2002.
Step 2: When you find the cheapest rate, print the pricing page as proof.
Step 3: Browse rental car web sites, such as Avis.com (www.avis.com) or Budget.com (www.budget.com), to find the cheapest car rental rate during your trip.
Step 4: When you find the cheapest rates, print the pricing page as proof.
Step 5: Assume additional trip expenses: Hotel=$700, Food=$300, Entertainment=$250.
Step 6: Use Microsoft Excel to create a spreadsheet to display all trip expenses.
Step 7: Create a chart to visually display trip expenses. Insert graph into spreadsheet.
Step 8: Submit Excel spreadsheet w/graph via email attachment to the instructor. Submit printed copy of airline and rental car pricing sheets in class on due date.

* Scoring Rubric *

Full Credit Excel spreadsheet w/graph All expenses on graph Pricing sheets submitted

Partial Credit Excel spreadsheet w/graph All expenses on graph No pricing sheets submitted

No Credit Excel spreadsheet-no graph Some expenses on graph No pricing sheets submitted

---

Advanced Assignment Option:

Step 1: Browse airline web sites, such as Delta.com (www.delta.com) or United.com (www.united.com), to find the cheapest roundtrip flights to Honolulu, HA for New Year's 2002.
Step 2: When you find the cheapest rate, print the pricing page as proof.
Step 3: Browse rental car web sites, such as Avis.com (www.avis.com) or Budget.com (www.budget.com), to find the cheapest car rental rate during your trip.
Step 4: When you find the cheapest rates, print the pricing page as proof.
Step 5: Browse hotel web sites, such as Marriott.com (www.marriott.com) or Hilton.com (www.hilton.com), to find the cheapest hotel accommodations during your trip.
Step 6: When you find the cheapest rates, print the pricing page as proof.
Step 7: Assume additional trip expenses: Food=$300, Entertainment=$250.
Step 8: Use Microsoft Excel to create a spreadsheet to display all trip expenses.
Step 9: Create a chart to visually display trip expenses. Insert graph into spreadsheet.
Step 10: Submit Excel spreadsheet w/graph via email attachment to the instructor. Submit printed copy of airline, rental car, and hotel pricing sheets in class on due date.

* Scoring Rubric *

Full Credit Excel spreadsheet w/graph All expenses on graph Pricing sheets submitted

Partial Credit Excel spreadsheet w/graph All expenses on graph No pricing sheets submitted

No Credit Excel spreadsheet-no graph Some expenses on graph No pricing sheets submitted