|
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
|