BatchGeo + Google Form = Cool Collaborative Map!


ttpictiny

I recently presented at the national ISTE conference, and this collaborative map activity was one of the  crowd favorites. It allows you to gather data via a Google Form/Spreadsheet and then easily map the results using the BatchGeo tool!


Resources / Things you’ll need:


Instructions

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Creating the Form:

  1. Go to https://drive.google.com
  2. Pull down the “Create New” button and choose “Form.”

Add a title and some questions similar to these:
– Name
– City
– State or Country
– Interesting Fact
Note – You could find out: where students were born; the farthest they’ve ever traveled; their favorite vacation spot; if they could live anywhere in the world; etc.

 

4. Send students to the live form and give them time to fill it out.
Note – You can use this cool tool to shorten the address!

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Copying the Data:

  1. Go to the spreadsheet that collected the form data.
  2. Click and drag to select the data (including the column headers).
  3. Copy the selected data.
    – Control + C (PC)
    – Command + C (Mac)

 

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

 Creating the Map:

  1. Go to BatchGeo.
    http://www.batchgeo.com
  2. Paste the data into the provided area.
    – Control + V (PC)
    – Command + V (Mac)
  3. Click the “Map Now” button.
  4. Click a placemark on the map to reveal the student’s name and interesting fact.
  5. Click the Save & Continue button. (Optional)
  6. Enter a name for your map and enter your email address. (Optional)
  7. You will receive an email that contains a URL and embed code for your map. Then you can easily share it with others! (Optional)

 

 

Comments

  1. Hi Tammy,

    Interesting post. Thanks.

    You should try out our service, ZeeMaps (http://www.zeemaps.com). We allow you to “attach” a Google Spreadsheet to a map, so that when you make changes to the spreadsheet, the map is also update.

    Pankaj

Share your Comments!

*


six + 3 =