Fusion Tables – Data Visualization

Fusion Tables is a free web-based data visualization tool from Google.  Using Fusion Tables, latitude and longitude data in a spreadsheet can be “connected” to a Google Map.  Street addresses can also be connected to maps showing locations based on those addresses.  Using this tool, students can apply knowledge of spreadsheets to make maps like this interactive map showing all the school buildings in Ohio.  In order to create each point on the map, the columns in the original spreadsheet had to be merged into a working address.  This is application of spreadsheet knowledge.

Ohio School Building Designations

In the following example, latitude and longitude data was collected and used to form the shape of school districts.  The spreadsheet contained a column showing the level of poverty in each district.  The colors of the districts were adjusted so that red signifies most impoverished and blue is least impoverished with lighter shades of red and blue indicating poverty levels some where in the middle.

Ohio School Districts and Poverty

The final example shows a map with symbols created by collected latitude and longitude readings for specific locations at Camp Berry.  This was created as part of the Findlay City Schools Outdoor Environmental Camp.  Using a GPS, location data was collected for each structure in the camp.  Those latitude and longitude readings were entered into a spreadsheet and imported into a Fusion Table.  This is application of latitude and longitude knowledge.

A Field Trip to Camp Berry

Advertisements
This entry was posted in Technology Integration and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s