Beaver Mountain Simulation

Document Sample
Beaver Mountain Simulation Powered By Docstoc
					                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.