Summer Ventures – Visualization/ Image Processing Course

Tuesday July 3, 2007

 

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 Spreadsheet Basics 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 towns 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 zip code 28607 for Boone and your zip code and will record the distance in miles. 

 

NameOfStudent                     Distance

 

Then we will enter this data into an Excel Spreadsheet to generate some charts.  You are required to generate at least 3 different charts.  

 

You will create a MS Word file that contains all the charts you have created.  Each chart should have a title and proper labels.  Under each chart you will add one or two sentences of your observation.  You will send the MS Word file as an attachment to rt@cs.appstate.edu.  It is best that you send a copy of the file to yourself so you can get it in case you need it later.  We will find a way to back our files up soon.

 

Answer these questions in your MS Word report.  

 

1) Which one of the chart types do you think was best suited for visualizing the above data?

 

2) Suppose we wanted to include the elevation of your town in our analysis.  First, where do you look to find the elevation and second, how would you incorporate the elevation with the distance in your charts?

 

 

Hint: Search GNIS at:

http://geonames.usgs.gov/domestic/index.html