Before we start the activities of today's lab, you need to know some basics on Excel. Most of you have used Excel before, so this might be a review for you.
Go to the http://www.fgcu.edu/support/office2000/excel/ web site and first look under the Spreadsheet Basics to make sure you understand what a spreadsheet is in Excel. We will create some charts, thus this section Charts is perhaps the next section you want to visit or refer to when you complete the class activities.
Activity 1 – We will collect the distances of your town to (Boone) and will make a data set containing two columns.
We are interested in the air distance, but that might be a bit harder to collect. For now, we will use Yahoo Map and will use the zip code 28607 for Boone and the zip code of the place where you are from and will record the distance in Miles. Basically we construct a table that looks like this:
Distance from County (Miles)
RT Watauga 0
------ --------- -----
Then we will enter this data into an Excel Spreadsheet to generate some
charts to illustrate some relationships in the data you have collected.
You are required to generate at least 3 different charts. Then,
you will create a MS Word file that contains the three charts that you
have generated. Each chart should have a Title and proper Labels.
Under each chart you will add one or two sentences that reflects your observation
of the data on that chart. You will send the MS Word file as an attachment
to email@example.com. It is best that you send a copy of the file
to yourself so you are sure the e-mail has gone through and also to have
a copy just in case you need it later. We will find a way to back
up our files perhaps on a flash drive later.
Activity 2 - Answer these questions in your MS Word report.
1) Which one of the 3 charts did you find most useful for visualizing the above data? why?
2) Suppose we want to include the elevation of your town in our analysis. First, find out where you can look for the elevation data, and second find out how would you incorporate the elevation with the distance in your charts? If your town was not listed, find the closest location or use the county's elevation.
3) Which graph works best if you wanted to find out which towns have the same elevation?