Spreadsheet
Simulation

A WebQuest for Spreadsheet

Designed by

Carol Young
Meade Senior

Introduction | Task | Process | Evaluation | Conclusion | Credits


Introduction

You are employed by a large corporation located in Baltimore, MD.  This corporation has several branches in the Northeast section of the United States.  Your supervisor has just been given the assignment of organizing a conference for all  branches.  Your supervisor wants you to do some research for his presentation to the officers of this cooperation.

Based on your research, the officers will select a conference site for this year's conference.
 


The Task

From your research, you will prepare charts listing the number of rooms in hotels being considered to host our conference.  Your supervisor would also like a chart to show the distance of the various cities from Baltimore. 

When you are finished, you will submit both the charts and the data that you have compiled.  (Remember, to use different charts, ones that will best show the differences in the data.)

You will use Lotus 1-2-3 97 to compile your data and produce the charts.  You will use the Web to do your research.


The Process

The President of our corporation has decided that he would like to select from the following cities:

Baltimore
Boston
Philadelphia
Pittsburgh
Washington

Hotels being considered:
 

Hilton
Hyatt Regency
Marriott
Radisson
Sheraton

You will use travelocity to search for your information.  In each city you will determine if the hotel has a facility and, if it does, how many rooms does it have. Be sure to include only those hotels that are currently open, not those with a future opening date
The officers have indicated they wish the hotel to be downtown, not on the outskirts of the city.

The other determining factor will be the distance from our main office to the city of choice.

Now that you have finished your research, use the software Lotus 1-2-3 97 to enter your data.  Your charts must be in a format that you supervisor can use for his presentation.
 

Evaluation
 
 
  Beginning

1

Developing

2

Accomplished

3

Exemplary

4

Score
Met requirements for mileage
All mileage was
correct.
All mileage was 
correct.
All mileage was 
   correct.
All mileage
was 
   correct.   .
 
Met Requirements for Hotels














 

Not all hotels requested were searched for, not all were located within the downtown area of the city and may have had the correct city name corresponding to the correct city but not located in the correct city.
All hotels requested were searched for, not all were located within the downtown area of the city but were located in the correct city.
All hotels requested were searched for, all that were found were located within the downtown area of the city.
All hotels requested were searched for,
all that were found  were located within
the downtown area of the
city.
 
Mileage Chart











 

Not the best type of chart to illustrate the difference in miles.  Legend, X-axis and Y-axis could have been easier to read.  Title could have been more descriptive of chart.
Used chart that was easy to see difference in miles.   Legend, X-axis and Y-axis could have been easier to read. Appropriate title used.
Used chart
that was easy to see
difference in miles.
 Legend, X-axis
and Y-axis were easy to see and properly labeled. Appropriate title used.
Used chart
that was easy
to see
difference in miles.
Legend, X-axis and Y-axis
were easy to
see and 
properly
labeled.  Appropriate title used. 
 
Hotel Chart
Not the best type of chart to use to identify the room differences.  Legend, X-axis, and Y-axis could have been easier to read.  Title could have been more descriptive of chart. 
Used chart that was easy to see the difference in room size, hotel name is not entirely printed, did not identify hotel if more than one chain in same downtown area.  Legend, X-axis, Y-axis, could be easier to read.  Title could have identified chart better.
Used chart that was easy to see the difference in room size, entire hotel name is printed, identified hotels if more than one chain in same downtown area.  Legend, X-axis, Y-axis, were easy to read.  Used appropriate title. 
Used chart that was easy to 
see the difference in room size,
 entire hotel name is
printed,
identified
hotels if more than one chain
in same downtown
area. Legend, X-axis, Y-axis, were easy to read.  Used appropriate title.
 
Adding to the visual appeal
   
.
Changed font. Used bold, shading,outlining, etc. to improve the appearance of chart.
 



Conclusion 

Many supervisors have employees help with research that they do not have the time to do.  By using the World Wide Web you will do many different searches for an employer.  You have learned how to search for requested information and then take that information and put it into chart form. You should also have a better understanding of how different charts emphasis different information. 
 
 



Credits & References
 

YourBaltimore.com for our skyline of Baltimore

321clipart.com for people

free-clip-art.net/index3.shtml for airplane
 

Return to the Top of the Page
 


Last updated on August 15, 1999. Based on a template from The WebQuest Page