In the last video, you built a pivot table to help you understand specific data in your spreadsheet.
Another way to use and understand the data is with a map.
A list of addresses in a spreadsheet alone is not very clear or useful information.
It doesn’t tell you what is at the address or why someone would travel there.
In this video, you will import your spreadsheet into Google My Maps in order to pinpoint each location on a map.
That way, you can see where each location is and what is located there.
Then, you can make inferences about why someone would travel to each address.
To start, open Google Drive and create a new Google My Maps.
Give the map a title.
Next, import your spreadsheet into Google My Maps.
Choose the spreadsheet from your Google Drive.
Select the “Start” column to add those addresses to the map.
Select the check box for the "Start" column to add the location labels.
You will update these labels when you know more about each location.
Now your map includes all of the places the person visited.
However, any location visited more than once has multiple markers.
A marker is an icon that identifies a particular location on a map.
To fix this, customize the appearance of your map.
Choose “start” as the style by data column.
Good job -- each location has only one marker.
Click on each marker, then zoom in on the map to get a better idea of the locations.
What does each place suggest about the pretend person’s driving habits?
Keep in mind, more than one business might use the same address.
Include unit or suite numbers in your searches to learn all you can about the different places.
In the next video, you will make some inferences about the user based on this data and add custom map markers to identify some of their most frequently visited spots.
Now it’s your turn: Create and name a new Google My Maps.
Import the Driving Data spreadsheet you chose into the map.
And select the start column for locations and for labels.
- Create and name a new Google My Maps
- Import the Driving Data spreadsheet you chose into the map.
- Select the start column for locations and labels.
Shared work attachment
This project will be shared with your teachers
Students can submit their work on this page. View their submitted work on the student progress page of My Classes.