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.
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.
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.