Teachers get invited to a fair number of graduation parties, and for years I’ve told myself that graduation “season” would be easier if I had a map of where the parties were. Last year I got organized and made a map. It was surprisingly easy. This should work with any sort of address data, so if you’re making maps for graduations or garage sales this should still work.
Step one: Trick Seniors into Getting you Graduation Information
The trick here is to make it easy for them to do so. I created a Google form to capture the data, but you could use any survey type site. We get the seniors to setup a Facebook Group each year, so I recruited a senior, convinced him that having a map of graduation parties would be a good idea (the seniors can use it too). He posted the form to the Facebook group and harassed seniors until we had all of the information.
Step two: Fix the data
Part of fixing the data will be standardizing all of the information that the seniors submitted so that everything is consistent (dates, times…). The rest is simply arranging the data in the correct order for the mapping service and sorting it by date and time. This is the order that I found makes a nice map. The order of the first 4 is mandated by the mapping software.
Address | City | State | Zipcode | Name | Date | Time | Venue | Notes |
Step three: Paste your spreadsheet data into BatchGeo
BatchGeo is free as long as you have reasonably small sets of data. If you have hundreds of graduation parties you can still use it, but you’ll have to pay for the maps.
- Copy your spreadsheet data including header.
- Paste it into the “spreadsheet box” on the batchgeo site (if you then click outside the box it will format it nicely).
- Click on “Validate and Set Options”.
- Set your region and group by date.
- Click on “Advanced Option”
- You probably don’t have to change anything here. Just look at the options and make any changes that you think would look nice. If you notice that anything looks odd, you can always start over at step 1.
- Click on “Make Map”.
- After you admire your map, click on “Save and Continue”.
- Enter a title, description and your email address (so you can update it if needed). You probably want an unlisted map so that only people to whom you give the URL will be able to see it. Click on “Save Map” and you’ll be sent an email with the links.
The image above links to the actual map, but batchgeo only keeps your map until people stop visiting it. After that, they will send you an email and you can visit it if you want to keep it.
Notice that you can filter by day and that the markers are labeled in alphabetical order by when the party gets started (assuming you sorted your data by date and time before you pasted it in).
Step four: Share your map
Just one note about sharing your map: if you make changes later, batchgeo generates a new URL for the edited version of your map. So if you make a change, make sure you send out the new URL to teachers and seniors. For that same reason, you probably don’t want to use URL shortening services like bit.ly that do not allow you to update the URL after the shortened link is created. Oh, it might also be polite to tell both the seniors and the teachers that just because you’re providing a map to the parties doesn’t imply that everyone is automatically invited to every party.