Google Sheets & My Maps - Connect Student Literature with Geography
There are many cool things that can be done with My Maps, but this is one that uses Google Sheets. Often when students are reading a novel, they have no location context to put cities or places that are mentioned. There are teachers that have been using Google Lit Trips for many years, but what if you are unable to use Google Earth? What if you want a simpler activity that students can complete quickly? What if you want something that is accessible to students in their G Suite Drive? You can build a quick activity using Google Sheets and My Maps. Here's how: 1. Set up your Google Sheet Provide headers for anything you want included on the pop-ups for the markers on the map. Here I have set up so students can add the following: Place, Description, Chapter, Location, Support Link 2. Fill in the data This can be done by you, or you can share the sheet with your students and have them fill it in. Any cells can be left blank, with the...