Before we start the activities of today's lab, you need to know some basics on Excel. We had a lab on Excel yesterday and you can use the folling online resources to learn more. At the end of this lab you will email me one MS Word file containing your answers and activities. Note that you will use Excel to complete your work for Activities 1 & 2, and you post your results in a MS Word file for me to see what you have done. For activity 3 you will generate a map and will post the map in your MW Word file as well. Basically, you will create one MS Word file that contains the answer for all three activities and will e-mail me that file. On the Subject Line of your e-mail, please indicate SVM Excel 2 (a couple of people missed this). Make sure to send a copy the email to yourself as well (use cc).
Go to the http://www.fgcu.edu/support/office2007/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 as you will 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. You can get the air distance between two zip codes using This Page . ASU's zip code is 28608. Please record the distance in Miles. Basically, we construct a table that looks like this:
Distance from Town (Miles)
RT 28607 0
------ --------- -----
Then we will enter this data into an Excel Spreadsheet to generate several
charts to illustrate some relationships in the data you have collected.
You are required to generate at least 3 different charts.
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.
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.
Hint: USGS Web Page
3) Which graph works best if you wanted to find out which towns have the same elevation?
Activity 3 - Include your results in the MS Word report.
This web page allows you to create a map of your choice based on the longitude and latitude pairs you will give for the region of interest. When you go to the web page you will find a default set of points that creates the map of Cape-area towns. Please find as best as you can the points (as many as you see necessary) that describes your region (county perhaps) and create a map for your county. Then include the map in your MS Word report. The USGS Map Genrator