Desktop Publishing
Student Instructions
Online Class - Fall 2003
Ms. Cheryl Darce, Instructor
http://www.stmary.k12.la.us/phs/desktop/desktop_publishing_online_class.htm
Lesson Fifteen Title: My Dream Vacation (Word, Excel, Publisher, Internet)
In this project you will plan a vacation from New Orleans to a US major city or cities of your choice for a six-night/seven day stay. Before you begin your search, decide where you would like to vacation or a favorite place you have vacationed before. The total value of this project is 300 points. You are to do the following:
1. Using Microsoft Word – create an itinerary for the 6-night/7-day trip for you and a friend. The itinerary should be broken down by each day, be neatly done, you may change your font style and size and include any graphics or borders if you wish. The itinerary should include all of the pertinent information and be eye appealing.
2. Using Microsoft Excel – create a worksheet showing the high/low temperatures and precipitation chance for the days of your vacation. The worksheet should be formatted with different styles of fonts and font sizes, include at least one border, change the size of the columns and rows as necessary. Color is encouraged.
3. Using Microsoft Excel – create a worksheet showing the
a. Airline name, arrive and departure dates and times, flight #’s, and the individual price for you and a friend. Total the price for the 2 airline tickets.
b. Hotel you are staying at, the cost per night and the total cost for the 6-night stay.
c. Car Rental per day or a weekly charge.
d. Estimate the food cost per day.
e. Estimate the other spending cost involved.
f. End by giving a grand total of the expenses for the trip.
g. Follow the instructions from #2 as to formatting!
4. Using Microsoft Publisher – create a brochure telling the reader all about vacationing at this particular location. Some suggested sections may be:
a. General Information, Where to Eat, What to See and Do, Guided Tours, History, Lodging and Other Services, Where to Shop, Just for Kids, etc.
b. The brochure should be attractive and appealing to the eye. You may insert graphics, including fonts, bullets, etc. You may copy and paste information from the Internet!
5. Print a map of your location. You may copy and paste into Word and then print.
6. You must create a cover sheet to place in front of your itinerary it must be attractive and eye appealing. You may you word art, graphics, pictures, and the page must contain your name and the destination name of your vacation.
7. ****You must include a typed page listing all of the web sites that you obtained information or pictures from.****
Possible Internet Sites to Use:
1. Airline Web Site Listing - http://travel.airwise.com/info/airlines/
2. Airline, Hotel, and Car Rental information at - http://www.expedia.com
3. Weather information – http://www.weather.com
4. Search Engines can be found on the PHS homepage http://www.stmary.k12.la.us/phs – under the Library page and then click on Internet Search Engines. Use these to find information about your destination site.
5. City Search - http://www.citysearch.com/
6. Map Quest - http://www.mapquest.com/
***Make sure that everything has your name on it before you print out***
Back to Student Instruction Page
Back to Desktop Publishing Home Page
Home Library Internet Resources Calendar Departments
Clubs Sports Cracker Jacks Faculty
Alumni History Mission Statement
Desktop Publishing - OnLine Class Lesson Plans
Lesson Fifteen: My Dream Vacation
Curriculum Areas:
· Business
· English Language Arts
· Math
Grade Level: 9—12
Louisiana Framework:
· B-4-A Select and utilize equipment and technology appropriate for successfully completing various tasks.
· B-5-B Apply standard rules of grammar and usage.
· B-15-E Produce documents using a variety of application software including current word processing, database, spreadsheet, desktop publishing, and presentation graphic programs.
· B-15-G Examine and use communications software including the Internet technology for personal and business use.
· B-16-F Integrate presentations with clip art, graphics, pictures, sound, and video.
· B-17-C Identify, compare, and use various desktop publishing technology.
· B-19-F Conduct research on the Internet.
· B-20-C Create, compose, edit, store, retrieve, and print documents.
· ELA-1-H5 using the various purposes for reading (e.g., enjoying, learning, researching, problem solving) to complete complex projects. (1, 2, 4)
· ELA-5-H4 using available technology to produce, revise, and publish a variety of works; (1, 3, 4,)
· N-4-H determining whether an exact or approximate answer is necessary; (2, 3, 4)
· M-4-H demonstrating the concept of measurement as it applies to real-world experiences. (1, 2, 3, 4, 5)
Technology Strategies:
· 9-12-C Demonstrate knowledge and skills of Internet use and other resources consistent with acceptable use policies including the legal consequences of plagiarism and the need for authenticity in student work through an understanding of copyright issues. (5)
· 9-12-E Explain and use advanced terminology, tools, and concepts associated with software applications, telecommunications, and emerging technologies. (1,3)
· 9-12-G Refine knowledge and enhance skills in keyboarding, word processing, desktop publishing, spreadsheets, databases, multimedia, and telecommunications in preparing and presenting classroom projects. (3,6)
· 9-12-J Use appropriate technology to locate, retrieve, organize, analyze, evaluate, and communicate information for problem solving and decision making. (1,2,4)
Learner Objectives:
The student will:
· use the Internet to search for information on planning a vacation (airline tickets, rental car, hotel, food, etc.).
· use Microsoft Word to create a 7day/6night itinerary.
· use Microsoft Excel to create a worksheet showing the temperature and precipitation for a specified number of days.
· use Microsoft Excel to create a worksheet depicting the total cost for a 7day/6night vacation.
· use Microsoft Publisher to create a brochure about a particular vacation spot.
· retrieve and print a map from the Internet.
Materials:
· Dream Vacation Instruction Sheet
· Dream Vacation Internet Directed Web Site Sheet
· Dream Vacation Rubric
Technology Connection:
· Internet
· Microsoft Word
· Microsoft Excel
· Microsoft Publisher
Lesson Procedures:
A. Introduction/Motivation:
1. I am sure that each of you have dreamed of taking an all expense paid vacation. Where are some of the places that you want to go in the United States if you had an unlimited amount of money to spend? How would you travel there? What are some of the things that you would do? Where would you stay? Where are some of the places that you might eat? These are just some of the questions that we would ask ourselves if we were planning a vacation. In this next project, you will be doing exactly that. You will be planning a 7-day/6-night trip for anywhere in the United States. You will have an unlimited amount of money to spend.
B. Lesson Procedure (at the computer):
1. Using the Instruction Sheet, the Direct Web Site Sheet, and the Internet you are to plan a 7-day/6-night trip to anywhere in the United States. You will need to find the following items:
a. Airline flights leaving from New Orleans to your destination. This includes the Flight numbers for the trip there and the return trip and the price for a round-trip for you and a friend.
b. A rental car and the rental price for seven days.
c. A hotel to stay at and the price for the six nights.
d. Places to go and things to do for the seven days of your vacation, you may need to estimate the cost if you cannot find the exact cost of these things.
e. Restaurants to eat at and the cost for two people.
f. The weather for the next 7 days of your chosen location.
g. A map of where you are going.
2. Using this information you will create the following:
a. A 7 day/6 night Itinerary, including a cover sheet – all done in Microsoft Word.
b. A weather forecast done in Microsoft Excel
c. A cost sheet showing the breakdown of the cost for the trip for 2 people – use Microsoft Excel.
d. A brochure describing the vacation location – use Microsoft Publisher
e. A map of your destination
f. The final page should show all of the web sites that were used in this project.
C. Once the work has been turned in another possible assignment would be to then have the students plan the same trip but this time on a budget. Students could pull budgets out of a hat or they could be assigned. Students could then decide if they could still fly or if they would have to drive. Mileage could be determined. If the student did the Auto Shopping Project earlier, they could go back and see how many miles per gallon the vehicle used. Then with this information and the current price of gas and the miles to the destination a cost could be developed. A new hotel may have to be chosen, attractions and food cost may also have to be changed. The students could then simply go back in the Excel Spreadsheet and change to the new information.
D. Closure.
Assessment:
· Rubric
· Final Project
Directed Web Site Sheet
Dream Vacation Project
Directed Web Site Sheet
1. Airline Web Site Listing - http://travel.airwise.com/info/airlines/
2. Airline, Hotel, and Car Rental information at - http://www.expedia.com
3. Weather information – http://www.weather.com
4. Search Engines can be found on the PHS homepage http://www.stmary.k12.la.us/phs – under the Library page and then click on Internet Search Engines. Use these to find information about your destination site.
5. City Search - http://www.citysearch.com/
6. Map Quest - http://www.mapquest.com/
Back to Lesson Plan Page for Lesson 15
Rubric
Student 300 Points Possible
Dream Vacation Grade Sheet
1. Itinerary – 6 night/7 day (125 Points)
a. Broken down daily
b. Flight #, Departure Time, Arrival Time
c. Hotel Information
d. Font Style and Size
e. Neat and Eye Appealing
2. Temperature (25 Points)
a. High-Low Temp for 7 days
b. Font Styles and Size
c. Border
3. Price Sheet (50 Points)
a. Airline Price for 2 people
b. Hotel Price for 6 Nights
c. Car Rental for 6 Nights
d. Estimate of Attraction
e. Estimate of Food
f. Estimate of Souvenirs
g. Font Style and Size
4. Map (25 Points)
5. Brochure (50 Points)
a. Information
b. Pictures
c. Eye appealing and Neat
6. Web Sites Used (25 Points)
Back to Lesson Plan Page for Lesson 15
Back to Teacher Lesson Plan Page
Back to Desktop Publishing Home Page
Home Library Internet Resources Calendar Departments
Clubs Sports Cracker Jacks Faculty
Alumni History Mission Statement
Back to Teacher Lesson Plan Page
Back to Desktop Publishing Home Page
Home Library Internet Resources Calendar Departments
Clubs Sports Cracker Jacks Faculty
Alumni History Mission Statement