
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.
Is your brain sad that it has to live in the same house as my brain?
Will sharing this lead to everyone showing up at the same party first? You could have the pick of the buffet if you went to the middle party first. Was that your plan all along? All the shrimp cocktail you can eat?
I thought about that last year, and if every teacher was invited to every party I think that could happen. I was usually trying to get to parties before they were over.
Ouch. My brain hurts just trying to follow the steps of this ingenious plan.
Btw: If you parked at one of the centrally located houses, could you walk to all the others?
And good call Brad! You’re on to Lloyd! You’re on to him.
In Seward that would work. In Lincoln you would spend a lot of time walking.
Trying this one for the first time. Not bad, but doesn’t work as well for us youth directors. My parties are spread over 10 dates and the free version from BatchGeo only allows for up to 7 groups. It’s still better than the old lancaster county map with a bunch of circles on it.
Maybe 2 maps? one for each week. Or each 5 days or whatever. The time consuming part if making the spreadsheet.
Hey, can I go to Taft’s party? I bet he will have some really good food there.
Awesome, admire your ability. Enjoy the parties.
I might be seeing you at a few of those this year, due to a youth group trip I went on 2yrs ago and am going on again this summer. What do high school boys want?? Besides girls, of course.