España Graduation Trip
A Web Quest for 8th Grade (Computer and Spanish)
Designed by Karen Conlin
Introduction | Task | Process | Evaluation | Conclusion | Spreadsheet | Letterhead
Introduction
Your Great-Aunt Maricela Madrazo, who lives in Madrid, Spain with her sister Josephina, has invited you and a friend to visit them for a week in June as your graduation gift. She will be paying your expenses for air travel, lodging and trips to the museums but needs to know how much it will cost. You will be responsible for transportation around town (taxi, bus etc.), meals and any personal expenses. Remember she is older and you should not take advantage of her money. You may be receiving some money from other relatives that you can use for your expenses but do not even consider first class airfare or hotels.
It would be polite for you to take Great-Aunt Maricela and Josephina out to dinner to thank them for their hospitality.
Task
You need to research airfare roundtrip from the DC area to Madrid a moderately priced hotel near her apartment which is located near the Parque del Retiro, the cost of admission for two museums in Madrid as well as two meals a day. You should also write a letter in Spanish to Great-Aunt Maricela thanking her for her generosity, the cost of airfare and a hotel and when you will be arriving and departing. Great-Aunt Maricela is computer literate and can link to your spreadsheet in the letter you write.
Your expenses need to be shown in an Excel Spreadsheet and your letter written in a text document. Within the document you must link to the spreadsheet.
Process
- Collaborate with a classmate on how to break down the research (one can research air fares while the other researches hotels.)
- Research airfares from the DC area to and from Madrid, Spain
- Research hotels in Madrid and find the cost of a room
- Research the costs of admission to two museums and how far it is from your hotel to see if there is a bus, taxi or within walking distance. Get the costs of the transportation you can take.
- Find places to eat and the costs, both for your daily bread as well as taking your hostesses out for a meal.
- Enter the information on an Excel spreadsheet showing the total costs that will be paid by Great-Aunt Maricela and what you need to pay. There should also be a grand total for the whole trip.
- Write a letter in Spanish and proper letter format linking the spreadsheet. Some online translators are inaccurate so you must check with your Spanish teacher to make sure it is correct.
- The Letter and Spreadsheet formats are found in your assignments
- You MUST only use the links I have created as well as the letter and spreadsheet formats.
Evaluation
You will be evaluated with the following rubric.
Exemplary 1 | Accomplished 2 | Developing 3 | Beginning 4 | Score | |
Teamwork | Worked well as a team in dividing tasks and completing assignment. | Worked as a team but did not complete assignment. | Balance of teamwork was not even and tasks were partially completed. | Did not work collaboratively nor complete the tasks. | |
Information Organization | Information was accurate and spreadsheet was correctly completed. | Information was partially entered on spreadsheet accurately. | Information was not completed accurately | Spreadsheet was not completed. | |
Quality of Letter | Letter was properly formatted and written. | Letter was partially formatted correctly and written in Spanish | Letter was not properly formatted and Spanish was incorrect | Letter was not written. | |
Ability to Achieve Tasks | Worked well as a team and completed all tasks on time | Worked as a team only partial tasks were completed | Teamwork was not observed and tasks were incomplete. | Did not work well as a team and did not complete tasks. |
Conclusion
- You will have learned:
- How to utilize technology for research purposes,
- A working knowledge of spreadsheets to create, calculate, organize, and chart information
- A working knowledge of more complex word processing functions
- Integrate graphics, and spreadsheets into word-processes documents.
Spreadsheet
Use this spreadsheet layout:
Paid by Aunt | Trip to Madrid | |||||||
Expense | Qty. | Cost | Total | Notes | ||||
Total | ||||||||
Paid by Student | ||||||||
Total | ||||||||
Grand Total | ||||||||
Letterhead
Use this format in Microsoft Word for your letterhead
[Click here and type recipient’s address]
Dear Sir or Madam:
Type your letter here. For more details on modifying this letter template, double-click (. To return to this letter, use the Window menu.
Sincerely,
[Click here and type your name]
[Click here and type job title]
