BatchGeo + Google Form = Cool Collaborative Map!

---

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:

• A Google account for the teacher (students will NOT need accounts)
• A Google form/spreadsheet to gather the data
  https://drive.google.com
• The BatchGeo tool to map the data
  http://www.batchgeo.com

---

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)

---