A Summer 2010 Workshop Project

Displaying Spatial Data Using Excel and Google Earth

Authors:


Sam Donovan
University of Pittsburgh

Daniel Ward
Waubonsee Community College

Possible Audiences:

    Undergraduate biology students.  

Brief Overview:

    This project developed a working classroom model of how to utilize Excel and Google Earth to display spatial data. Students work with real world large data sets from allowing them to engage in citizen science as well as propose and answer questions about abundance and distribution of organisms.
     

Project Materials:

    PowerPoint
    Google Earth
    Microsoft Office Excel
    Earth Point: Tools for Google Earth
    Large data sets.  

Resources and References:

    Google Earth
    (http://earth.google.com/)
    Microsoft Office Excel
    Earth Point: Tools for Google Earth (http://www.earthpoint.us/ExcelToKml.aspx)
    Chicago Wilderness Habitat Project: Calling Frog Survey (http://www.habitatproject.org/frogsurvey/index.html)
    Chicago Wilderness Habitat Project: Illnois Butterfly Monitoring Network
    (http://www.habitatproject.org/projects/ibmn.html)  

Future Directions:

    Possible interaction with the Chicago Wilderness Project Habitat will be explored to make their data available to the general public and to allow graphic representation of the data on their web site. Possible grants related to conservation and rehabilitation of natural areas on the authors campus will be explored.  

Attachments: