Mapping on Google Sheets #gafe #google #edtech @rmbyrne

I think Google Maps is often overlooked when it comes to Google's amazing suite of tools, but I keep finding great uses for it besides just looking at locations.  Last week I presented at a conference and showed off the Mapping Sheets extension that allows you to make a sheet with locations, (or get data from a Google Form) and, with a few clicks of your mouse, plot those locations on a Google Map.

Today I read on FreeTech4Teachers about how Google already has that capability baked in.  Simply create a sheet with a column called 'Location', in Google Drive go to New > More > Google My Maps to create your map.  On the left sidebar under the first layer you can import your Google Sheet and the locations will appear.  You have to point it to the Google Sheet with the data and tell it which column has the locations.

In a social studies class you could use this to plot where all of our stuff comes from by looking at labels and tags.  It's quite eye-opening.  In an ELA class you could also plot a character's movements around the globe, complete with additional information that shows up on the map.  It's worth checking out and then letting your students figure out stuff to map on it.