My Maps Examples

Data Sources

• Statistics Canada Table 2: Number and distribution of the population reporting an Aboriginal identity and percentage of Aboriginal people in the population, Canada, provinces and territories, 2011
• First Nations Locations CSV file
• Drinking Water Advisories in First Nations Communities CSV file
• Pre-1975 Treaties CSV file

Create a survey using Google Forms

1. Go to Google Drive and create a new folder and give it a name.

2. Create a new form in your folder. Give it a name.

3. Add questions; try creating different types of questions, like a short answer and a multiple choice question.

4. Add a question that has a location (city and province, for example).

5. Style your form using different color schemes and images for the header.

6. Create a spreadsheet for the responses (this should appear in the same Google Drive folder as your form).

7. Turn to your neighbors and send them the form through email, ask them to fill it out and submit it.

8. Take a look at the response spreadsheet and see what the columns and answers look like.

Data visualizations using Google Sheets and My Maps

1. Download the Google Sheets in the Data Downloads folder (above).

2. Go to your Google Drive folder and upload the files (click the +New button on the upper left side to get to the upload menu). Hint: it will be easier if you create a folder on your laptop for all the files, and then upload the entire folder to your Google Drive folder (it will create a subfolder).

3. In the same Google drive folder create a My Maps. Give it a name.

4. Import the Pre1975Treaties.csv sheet in your folder into the map.

5. Style your My Maps using the range option and turn on labels.

6. Open and edit the data table. Delete any columns that you don't want and add columns of data that you think would be useful. Notice that when you import datasets your ability to edit markers is limited by the data table, unlike when you add markers, lines and shapes directly to the map. You can, however, still add photos without changing the data table.

6. If you have time, create a new layer and import the Premiere_Nation_First_Nation.csv sheet from your folder into the map (or create a second map and import this file).

7. Turn to your neighbor and explain what your map tells you.

1. Go to your Google Folder and create a new My Maps. Give it a name.

2. Import the Google Sheet "Statistics Canada, National Household Survey 2011"

3. Use the column "Aboriginal identity population as a percentage of the total population" to group your data.

4. Use "Ranges" to show differences between provinces.

Use Google Sheets to create graphs and charts

1. You can use the same spreadsheet that you used to create your My Maps to create other data visualizations like bar graphs and pie graphs.

2. Try sorting the columns from highest to lowest.

3. Calculate the sum of the Aboriginal identity population from all of the rows.

4. Create charts to illustrate different points. Try creating a bar graph and a pie graph.

Go directly to Google Sheet

1. Use the Drinking Water advisories in First Nations CSV file for this activity.

2. Use the "Advisory type" column to create a chart.

2. Now go back to your Google Drive Folder create a new My Maps.

3. Import the Google Sheet into your My Maps. Give your map a name and attribution.

4. Use the "Advisory Type" column to style the markers.

5. Change the icons using "more icons".

6. Change the basemap.