Beaver Mountain Bike Tours Congratulations and welcome to Beaver Mountain Bike Tours. You have been hired to work in the Information Processing Department because of your skills using many different kinds of software applications. You were highly recommended by your teacher. We hope you will find your work here challenging and exciting. Beaver Mountain Bike Tours has been in business for about three years. It has become the leading bike tour company in west central Utah. We rent out mountain bikes for the day. We provide 2-, 3-, and 4-day tours. These tours furnish everything needed for a wonderful vacation in the mountains. We have recently implemented some bike and fish tours. Our customers come from all over the Western United States. As a new employee in the Information Processing Department you will have your own desk with a multimedia PC connected to the local area network and the Internet. Use the formatting guides given to you. We expect many great and creative things from you. Thanks. Instructions: 1. Create a new folder named “Beaver Mountain Bike" to save all your work in. Your “supervisor” will help you do this. 2. Read all directions for the job BEFORE you begin to work. 3. PROOFREAD, PROOFREAD, PROOFREAD! 4. Name each file as instructed. 5. Each of the documents will be part of your final class portfolio which will count 25% of your exam grade. 1. Beaver Mountain Letterhead (BMLTRHD)—Word Processing Comments: Create a new letterhead for Beaver Mountain Bike Tours. On the letterhead include the company name, address, city, state, zip, phone number, and your name as the computer specialist. The letterhead information can all be at the top of the document or part on the top in a header and part on the bottom in a footer. Information: Beaver Mountain Bike Tours, 563 East Canyon Road, Beaver, UT 84713, 435-438-9103, Your Name, Computer Specialist Instructions: 1. Change your top margin to .5”. 2. Other margins may be default. 3. Use a decorative font for the company name in a large font (18-24 points). 4. Include a logo or graphic. 5. Proofread, save, and print. 2. Beaver Mountain Promotional Letter (BMPROLTR)—Word Processing Comments: We need a promotional letter written and sent to many of the local business asking them if they would like to be a sponsor for the upcoming "Pioneer Day Bike Tour". Write a block style letter on the company letterhead. The letter will be written to the Beaver County Travel Council and signed by the company president, Joseph Bradshaw. Information: Inside Address: Ms. Jennifer Smith Beaver County Travel Council PO Box 272 Beaver, UT 84713 First Paragraph: Tell Ms. Smith we have appreciated the travel council's support in the past and for letting us place pamphlets at their office. Second Paragraph: Ask the council to include our July 24th Pioneer Day Bike Tour on their calendar of events. Ask them if they would be willing to support the event with a $100 in prizes and we will put their logo on all of our printed flyers and T-shirts. Ask them to contact us by next Friday. (Find out what that date would be.) Last Paragraph: Thank them for their support. Tell them we are looking forward to hearing from them and working with them. Closing: Use "Sincerely yours" for the closing and typed signature of the president, Joseph Bradshaw. Add your initials as the typist. Instructions: 1. Load the company letterhead. 2. Use a block style letter format. 3. Date the letter today. 4. Write the letter to the travel council using the supplied information on the company letterhead. 5. Preview, proofread, save, and print. 3. Beaver Mountain Price Memo (BMPRMEMO)—Word Processing Comments: At Beaver Mountain Bike Tours we use memos to communicate within the company. The preferred style for memos is the formal memo format with special headings (TO, FROM, DATE, SUBJECT). Information: From: Company President, Joseph Bradshaw To: All Employees Date: Current 1st Paragraph: Write telling the employees that here is the new price list for the coming summer. 2nd Paragraph: Make a 4 column table using following price information. (The "|" tells where the columns are.) Tour | Days | Amenities | Cost Bike | 1 day | bike rental | $25 Easy Ride | 1 day | meals and guide | $50 Scenic | 3 days | meals, lodging and guide | $450 ATV Trail | 5 days | meals, lodging and guide |$650 Bike'n Fish | 2 days | meals, lodging and guide | $300 Custom Tours | __ days | meals, lodging, etc. | CALL Paragraph 3: Tell the employees you are looking forward to a "banner" summer. Then thank them for the good work they have been doing. Instructions: 1. Load the company letterhead 2. Key the headings ALL CAPS, bold, and DS. 3. Use a Formal Memo format. 4. Use the information above to write the memo in your own words as if it came from the president. You supply an appropriate subject line. 5. Use your initials as the typist at the bottom. 6. Proofread, save, and print. 4. Beaver Mountain Business Cards (BMBUSCD)—Desktop Publishing Comments: Since you have been hired here at Beaver Mountain Bike Tours we would like you to have your own business cards. On the business card include the company name, address, city, state, zip, phone number, your name as the computer specialist, and the new logo you have designed. Design one card and then print 10 cards on one page. Information: Beaver Mountain Bike Tours, 563 East Canyon Road, Beaver, UT 84713, 435-438-9103, Your Name, Computer Specialist Instructions: 1. Open up the desktop publishing program you are going to use. 2. Choose the option to print a set of 10 if possible (print tiled). 3. The size of the card will be the size of regular business card. (3 1/2" by 2") 4. Add Beaver Mountain Bike Tours at the top using the decorative company font, about size 18- 24 points. 5. Add the additional lines of the companies address, etc. in a more readable font, about size 10-12 points. 6. Add the logo you have used on the letterhead. 7. Make any additional adjustments as needed to improve the layout of the ticket so it is balanced and looks good. 8. Save in your Beaver Mountain folder. 9. Proofread, save, and print. 5. Beaver Mountain Flyer (BMFLYER)—Desktop Publishing Comments: Create a flyer that can be put in the local newspaper and mailed out with our promotional letters. The flyer will include these elements: (1) a border, (2) the title, (3) a graphic and logo, and (4) the details of our promotion. It will be printed on an 8.5 by 11 sheet of paper. Instructions: 1. Load your desktop publishing software. 2. Choose the poster or flyer option. Orient the page to portrait. 3. Place a border around the outside of the document. It can be a line border or a picture border. 4. Insert a title in the top ¼ of the document. The title can be in a very large (48-72 points) decorative font. Change the shape of the title using WordArt if you would like. The title is “July 24th Mountain Bike Ride”. 5. Add a graphic or picture in the middle part of the document. It could be a mountain biker, a mountain, or a scenic picture. 6. Add details in the bottom of the flyer. Use a large serif or sans serif font (20-36 points). Include: “July 24th 10K Bike Ride”, “Meet at the Swimming Pool at 8:00 AM”, “465 E 300 N in Beaver, Utah”, “Cost is $10 each”, “Free T-shirts to all finishers”, “Bring the Whole Family”. 7. Add another section of details in middle part beside the picture. Use a large serif or sans serif font (20-36 points). Include: “Beaver Mountain Bike Tours”, “563 East Canyon Road”, “Beaver, UT 84713”, “435-438-9103”. 8. Preview your flyer for balance and layout on the page. Make any adjustments needed to create a well designed flyer. 9. Proofread, save, and print. 6. Invitational Folding Card for Beaver Mountain Pioneer Day Tour (BMTOURCD)—Desktop Publishing Comments: We would like to make a folding card that can be used as a special invitation for our Pioneer Day Bike Ride. Information: Front: Border, "Pioneer Day 10K Bike Ride", and a related graphic. Back: Beaver Mountain Bike Tours, New Company Logo, and "Created by Your Name", and 20XX copyright. Inside Right: "You are invited to attend the July 24th 10K Bike Ride", "Meet at the Swimming Pool at 8:00 AM", "465 E 300 N in Beaver, Utah", "Cost is $10 each", "Free T-shirts to all finishers", "Bring the Whole Family" Inside Left: Include an appropriate graphic. Instructions: 1. Load your desktop publishing software. 2. Choose the folding card. In Publisher, Page 1 is the front; Page 4 is the back. Pages 2-3 are the inside. 3. Setup the card as instructed. 4. The title can be in a decorative font. Change the shape of the title using WordArt if you would like. 5. The graphic or picture in the middle part of the front could be a mountain biker, a mountain, or a scenic picture. 6. Preview your card. Make any adjustments needed to create a well designed card. 7. Proofread, save, and print. 7. Beaver Mountain Budget (BMBUDGET)--Spreadsheet Comments: At Beaver Mountain Bike Tours we have been working on a yearly budget. We need a spreadsheet created so we can see monthly and projected yearly amounts and totals. Information: Account Monthly Yearly Income Tours 5600 ? Rentals 1500 __?__ Total Income ? ? Expenses Rent 400 ? Wages 2100 ? Bike Repairs 200 ? Advertising 50 ? Utilities 145 ? Insurance 250 ? Total Expenses ? ? Net Income ? ? Instructions: 1. Load your spreadsheet and create a new document. 2. Set your font to Arial or Times New Roman at 12 or 14 points. 3. Enter the title "Beaver Mountain Bike Tours Budget" and bold it. 4. Add your name "Prepared by your name" and make it italics. 5. Enter the data above. Calculate the yearly amounts by multiplying the monthly amounts by 12. 6. Use the SUM function to total the Income and the Expense. 7. Net Income is calculated by the formula =Total Income - Total Expenses. Mentally check your calculations. 8. Format all numbers with commas and no decimal places. 9. Format the very top and bottom rows of numbers to currency and no decimal places. 10. Adjust column widths as needed so they are spaced evenly. 11. Align column headings as needed. 12. Adjust margins as needed. Center vertically and horizontally on the page. 13. Preview, proofread, save, and print. 8. Beaver Mountain Budget “What-If” (BMBUDGT2)--Spreadsheet Comments: At Beaver Mountain Bike Tours we have been working on a yearly budget. Using the budget created earlier, we need you to make some "What-If" projections. Instructions: 1. Load your BMBUDGET spreadsheet. 2. Change the title to "Beaver Mountain Bike Tours Budget—'What-If'" 3. Make the following changes: Rentals Income to 1700, Tours Income to 6300, Advertising to 90, Wages to 2900, and Insurance to 280. 4. Save as BMBUDGT2. 5. Make any adjustments as needed. 6. Preview, proofread, save, and print. 9. Beaver Mountain Trail Climb Chart (BMTRAIL)—Spreadsheet/Chart Comments: We have added a new mountain bike trail from Copes Basin Campground to Kent's Lake. We need an elevation chart showing the climb up the mountain. Included is a table of the kilometers and meters and a map of the area. Information: kilometers meters 0 2180 1 2260 2 2320 3 2340 4 2400 5 2440 6 2540 7 2580 8 2650 9 2710 Instructions: 1. Create a new file in your spreadsheet. 2. Use the information above to create a table. 3. Highlight the data and choose new chart on a separate sheet. 4. Make the chart a line graph with gridlines. 5. Add a border. 6. Add a title "Copes Basin to Kent's Lake" 7. Add titles for the horizontal (X-axis) and the vertical (Y-axis). 8. Add "Prepared by Your Name" as a subtitle. 9. Add data labels. 10. Remove the legend. 11. Make the background of the chart clear. 12. Start the vertical axis at 2000 meters. 13. Orient the paper to landscape 14. Preview, proofread, save, and print. 10. Beaver Mountain Customer Database (BMCUSTDB)--Database Comments: At Beaver Mountain Bike Tours we need a database setup so we can keep track of the customers we have signed up for bike tours. Set up a database and enter the follow cards in to the database. Later on we will have you generate some reports from your database. Information: Use the registration cards to setup your database and enter the information. The first card is for you to fill out about yourself. We want you to experience one of the trail rides. The company will pay your $350 fee. Instructions: 1. Load your database software. 2. Decide on the fields needed, their length, and the data type. 3. Create a new table using the fields you have decided on. 4. Enter the data. 5. Proofread and save. 6. Sort the database by Last Name and print it in table form. Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Your First & Last Name Name: Ben Lovell Address: Your Street Address Address: 349 Maple Street City: Your City, State Zip City: Roosevelt, UT 84066 Phone: XXX-XXX-XXXX Phone: 435-722-4986 Tour Date: 6/15/XX Fee Paid: $350 Tour Date: 7/8/XX Fee Paid: $300 Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Michael Begay Name: Yuko Honda Address: 35th Road, 9320 Address: 493 Van Nuys Avenue City: Kirtland, NM, 87417 City: San Francisco, CA 94123 Phone: 505-598-6394 Phone: 213-262-9061 Tour Date: 7/17/XX Fee Paid: $300 Tour Date: 8/10/XX Fee Paid: $650 Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Karl Measer Name: Marlin Anderson Address: 431 East 200 North Address: 5333 27 Street City: Provo, UT 84601 City: Taber, AB T0K 2G0 Phone: 801-373-9360 Phone: 403-223-6439 Tour Date: 6/18/XX Fee Paid: $600 Tour Date: 7/24/XX Fee Paid: $650 Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Selene Almonza Name: Joseph Nye Address: 372 Los Lovatos Road Address: 4860 N Jones Road City: Santa Fe, NM 87501 City: Sutherland, UT 84624 Phone: 505-438-9762 Phone: 435-864-7382 Tour Date: 6/3/XX Fee Paid: $50 Tour Date: 7/13/XX Fee Paid: $450 Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Mary Hales Name: Darryl Henrie Address: 4346 Avenue E. Address: 732 East 400 North City: Ely, NV 89301 City: Panguitch, UT 84759 Phone: 702-289-7342 Phone: 435-676-5732 Tour Date: 7/15/XX Fee Paid: $650 Tour Date: 6/21/XX Fee Paid: $50 11. Beaver Mountain Customer Address Report--Database Information: Use the forms to add the new customers. Use the report format: Instructions: 1. Load the Customer database. 2. Add the two new customers that we just received information on. 3. Create a report called: Customer Address Report with a subtitle Prepared by Your Name. 4. Include the following headings and fields in this order: Last Name, First Name, Address, City, State, and Zip. 5. Format the report with appropriate blank lines between the title section and the column headings. 6. Center and bold the title. 7. Center and italicize the sub title. 8. Adjust column widths as needed. 9. Sort the report (database) by Last Name. 10. Proofread, save, and print. Beaver Mountain Bike Tours Beaver Mountain Bike Tours Registration Registration Name: Silva Thomas Name: Jenny Smith Address: 493 N. Main Street Address: 3987 W 4000 N City: Farmington, UT 84025 City: Nephi, UT 84648 Phone: 801-451-2937 Phone: 435-798-4535 Tour Date: 6/15/XX Fee Paid: $450 Tour Date: 8/24/XX Fee Paid: $450 12. Beaver Mountain Customer Paid Report--Database Comments: We need a report of those who have signed up for tours and how much they have paid. Information: Use a report format. Instructions: 1. Load the Customer database. 2. Create a report called: Customer Paid Report with a subtitle Prepared by (Your Name). 3. Include the following headings and fields in this order: Last Name, First Name, City, State, Tour Date and Paid. 4. Format the report with appropriate blank lines between the title section and the column headings. 5. Center and bold the title. 6. Center and italicize the sub title. 7. Adjust column widths as needed. 8. Sort the report (database) by Tour Date. 9. Proofread, save, and print. Month of July Search 10. Search the database for those who have sign up for tours in July. 11. Print the information out using the Customer Paid Report. 13. Beaver Mountain Mailing Labels (BMMAILLB)--Database Comments: We need mail labels created for all the customers we have in our database. Information: Format the labels for Avery 5161 labels. Use the format as follows: First Name Last Name Address City, State Zip Instructions: 1. Load the customer database. 2. Use the software's label feature to create the labels. 3. Set the font to 12 point sans serif style (Arial). 4. Use the Avery 5161 label form. It has labels 20 labels on an 8.5" x 11" sheet of labels. The labels are 4.19" by 1". There are 2 labels across the page and 10 down. 5. Sort the labels by zip. 6. Preview, proofread, save, and print. 14. Beaver Mountain Customer Membership Cards (BMMEMCD)--Database Comments: We need membership cards created for all the customers who have signed up for tours at Beaver Mountain Bike Tours. Format these membership cards to be printed on pre-cut sheet of business cards. Information: Use the following format for the customer membership cards. Beaver Mountain Bike Tours Membership Card First Name Last Name Tour: Tour Date Address City, State Zip Instructions: 1. Load the customer database. 2. Use the label or form feature of the software 3. The size of a regular business card is 3.5" by 2". Ten cards will fit on one 8.5" by 11" sheet of cards. (2 across and 5 down) 4. Set the font to 12 or 14 point fancy font for the company name. 5. Bold the title. 6. Use a sans serif font for the sub title and italicize it. 7. Space between the titles and the rest of the card. 8. Use the sans serif font for the rest of the card except for the underlined parts. 9. Preview, proofread, save, and print. It is OK if 10 cards do not print on a page. 15. Beaver Mountain Bike Trail Report (BMREPORT)—Word Processor and Desktop Publishing Comments: At Beaver Mountain Bike Tours we need the following report typed and formatted for our annual meeting. There are grammatical/spelling errors in this report. Please correct. Instructions: 1. Open a new word processing document. 2. Set the margins for a leftbound report. 3. Follow your report guides given by your computer instructor. 4. Center and bold all titles and put a quadruple space after. 5. Bold all subtitles on the left margin. 6. Include the pictures of Kent's Lake and the Paiute ATV Trail. Use textwrap. 7. Put your name and page number at the right side in a footer. 8. Key the references correctly. 9. Proofread, save, and print. 10. Make a cover page for the report. Put a border on the outside, a title in a 36 point font, a graphic, and in a 24 point font your name, your class, and the date. 11. Proofread, save, and print the cover. Beaver Mountain Bike Tours Trails Report Prepared by Your Name Introduction The past three years that Beaver Mountain Bikes Tours have been in business we have made lots of growth. Our company has become the premiere provider of mountain bike tours in Central Utah. Included in this report are some of our most popular bike trails. Bike Safety and Trail Etiquette Safety precautions include: 1. Wear adequate helmet. 2. Keep bike in good mechanical condition. 3. Carry sufficient drinking water. 4. Carry a tire pump & patch kit. 5. Dress for cool weather at higher elevations. 6. Wear sunscreen to prevent sunburn. 7. Bikes are legal vehicles and must follow traffic laws. 8. Use common sense and be a defensive rider! Most of the trails are on Forest Service and Bureau of Land Management land which has some of the most scenic areas in the western United States. Help keep it beautiful. Don't trespass private property or litter. Always yield to hikers, horse riders, vehicles, and other bikes. Never harass wild or tame animal. Beaver Mountain Trails Big John Flat--Kimberly Road. This is a 51 kilometer one-way bike trail. It climbs from 2440 meters to 3355 meters then drops to 1800 meters in elevation. The ride is a 5 to 7 hour trip. The trail winds through pines and aspens up past the timberline. Wildlife commonly seen in this area include elk, deer, and small wild animals. Puffer Lake Loop. This is an 13.5 kilometer loop that takes 2 to 4 hours. It starts by Big John Flat which is about 3050 meters. It then climbs up to City Creek Peak at 3200 meters and then drops down to Puffers Lake at about 3000 meters elevation. Puffers offers lots of good trout fishing. Indian Creek Out & Back. Drive north of Beaver 17 kilometers through Manderfield and then take the Indian Creek Road for about 8 kilometers to the Forest Service boundary to start your bike ride. The ride start at an elevation of 2000 meters and climbs steadily to Indian Creek Reservoir at 2400 meters for a distance of 11 kilometers or 22 kilometers round trip. The trail follows the Indian Creek with a wide range of vegetation and a sparkling stream. Old mines can be found in the area so be careful. Kent's Lake. This trail starts at the Copes Basin Campground in Beaver Canyon and climbs 530 meters in the 9 kilometer ride in to Kent's Lake. This is a 2-3 hour ride where you can stop and picnic or fish at the lake. The ride back out is all down hill. This makes a nice beginner’s ride. Paiute ATV Trail This trail is a 325 kilometer loop over three mountain ranges and through rugged canyons and deserts that has been designed for recreational ATV riding. it is located in central Utah mostly on the Fishlake National Forest. There are numerous possible side trips leading to spectacular scenery, fishing opportunities, picnic and camping sites. The parts of the trail that go through the Tushar Mountains also make excellent mountain bike trails. See map of the trail. Be careful and watch for ATV riders. Special Events Our Pioneer Day 10K family bike ride has become a favorite with the local communities every July 24th. It is nice ride up into the foothills and back. References Beaver Travel Council, Trail Guide--Beaver County Utah, Beaver, Utah. Bridgerland Travel Region, Bridgerland Mountain and Roadbike Trails, Logan, Utah, 1995. Paiute ATV Trail Committee, Paiute ATV Trail--South Central Utah, Richfield, Utah. US Bureau of Land Management, BLM Edition Beaver Utah 1:100,000-scale topographic map, Denver, CO, 1983. 16. Beaver Mountain Presentation (BMPRESENT)—PowerPoint Comments: We have been asked to do a presentation at the local Chamber of Commerce and the tourism board for the county on our business. Please prepare a presentation of at least 15 slides on Beaver Mountain Bike Tours. Include information about what we do, tours that we provide, our sponsoring of the Pioneer Day 10K family ride, charts of our growth over the years, photos of the area, bike safety rules that we follow, etc. Include our new logo on each page. Use our trail report for ideas if needed. Make it a nice presentation with some animations and nice slide transitions. Pictures are available in the BM Picture folder. Information: Use any previous documents you have created and appropriate pictures. Instructions: 1. Open up the presentation software program. 2. Set up a title page. 3. Make an introduction page. 4. Choose a nice layout for the slide show. 5. Use the ideas above for the creation of the presentation. 6. Add transitions and animations when finished. 7. Save in your Beaver Mountain folder. 8. Have your presentation ready to show if asked. 9. Print a copy of your presentation with at least 6 slides to the page. 10. Proofread, save, and print.
Pages to are hidden for
"Beaver Mountain Simulation"Please download to view full document