Showing posts with label spreadsheet mapper 3. Show all posts
Showing posts with label spreadsheet mapper 3. Show all posts

Friday, June 1, 2012

Create Heat Maps from a CSV File

Heat Map Tool is a tool for easily creating heat maps or incident maps from a CSV file. To create a heat map all you need to do is upload a CSV file then specify your desired display attributes like scale, colors, and opacity. You can edit the display attributes of your map whenever you like. If you're wondering how to create a CSV file you can do so by exporting from a spreadsheet in Google Documents or exporting from an Excel file. Click here for directions on exporting from Excel. The free version of Heat Map Tool allows you to have up to 100 data points on your map and up to 500 hits per day on your map.

Applications for Education
Like Map a List and Spreadsheet Mapper, Heat Map Tool could be a good tool for students to use to create visualizations of geography-related data that they collect. Students could gather and display data about people's habit in their community or throughout the world. For example, you could have students gather data about dialects and display that information on a map.

Saturday, May 12, 2012

Mapping Data with Spreadsheet Mapper 3

Earlier this week I wrote about using Map a List to place spreadsheet data on a Google Map. Yesterday, the Google Lat Long team released a new Google Spreadsheet script that will allow you to create KML files based on your spreadsheet data. Spreadsheet Mapper 3 allows you to map up to 1,000 placemarks based on your spreadsheet data. And because Spreadsheet Mapper 3 is a part of Google Docs you can share your spreadsheets and maps for collaborative editing. Click here for complete directions on how to use Spreadsheet Mapper 3.

Applications for Education
As I wrote about Map a List, Spreadsheet Mapper 3 could be useful for a classroom genealogy project in which students map the origins of their families. You could also use Spreadsheet Mapper 3 to have students search for an map the locations of things like local history landmarks or geographic features.