10am-12pm: Workshop

12-1pm: Lunch

1-3pm: Workshop (continued)

Create a map and add places

1. Create a new folder for your project. In your web browser, go to Drive.Google.com sign into your account. Click the +New button and create a folder. Double click to open the folder.
2. Click the +New button, scroll down to "More" and click Google My Maps.
3. Click on the word "Untitled map" in the lefthand panel. Give your map a title and description.
4. If desired, change your base map style. At the bottom of the lefthand panel, click the arrow next to "Base Map". Click on one of the base map options like satellite.
5. Add three important resources for your community to the map. You can use points, lines or polygons:
   • Adding a point - There are two ways to do this:
     • Find the place you want to mark on the map (pan and zoom). Click the placemark button (under the Search bar), then click the map where you want to add the marker. Add a title (place name) and description (what is this place?), then click "Save".
     • Search for the place in the search bar by name, address or lat long. Click on the correct search result, then in the pop up that appears click "+Add to map". In the pop up that appears, the title (place name) has already been filled out by the search results, but you need to add a description (what is this place?). To do this, click the pencil icon in the pop up to make the point editable, then type in the description. Click "Save".
   • Adding a line. Click the "Draw a line" button under the search bar and select "Add a line or shape" from the drop down box. Click on the map to draw your line. Double-click the end point to end your line. Then add a title and description and click "Save".
   • Adding a polygon / shape. Click the "Draw a line" button under the search bar and select "Add a line or shape" from the drop down box. Click on the map to draw your line. Finish by clicking on the first point to end the polygon drawing. Then add a title and description and click "Save".

6. Give each resource a title and description.

7. Change the style of your icon, line or polygon.

• Change your icon style. Hover over a placemark and click the paint bucket that appears. Then click "More icons". Choose an icon and click "OK". Then color the icon by selecting from the color palette.
• Change your line or polygon style. Hover over a line or polygon and click the paint bucket that appears. Select a new color from the color palette and move the width slider to see the width of the line or border change.

Add images and videos

1. Add a photo to your map.
   • Click on a placemark, then click the camera icon in the pop up.
   • Choose any of the options to add a photo (upload from your computer, take a picture with your web cam, get a photo from your Google Photo Album, search for a photo with Google image search, etc.). When you find the photo you want, click "Select" to add it to the map.
2. Add a video to your map.
   • Click on a placemark, then click the camera icon in the pop up.
   • Click the More option to get a drop down box and enter the YouTube url of your video or search for a video add. When you find the video you want, click "Select" to add it to the map.

Direct-to-Digital Method

1. Go Google Drive and create a new My Map.

2. Find a partner to interview - you will build your partner's map and they will build yours. Make sure to leave enough time to create both of your maps.

3. Interview your partner and during your interview create a map of significant places that are important to your partner (below are sample questions to help you develop your interview script).

4. Add text from your interview. Tell us why each of these places is important.

5. Work together to find photos, YouTube video, and other rich media to add to the map.

6. Create custom placemarks using the University of Victoria Icon Library or other images (make sure the images are bold and simple because they will be quite small on your map).

7. Now switch roles, and have your partner build a map of significant places that are important to you.

8. Explore your maps and think about your script - what might you do differently to get the information you think would be important to create a good map?

Developing an interview script

Think about your interview, this will help us lead up to the Direct-to-Digital techniques we will use (interview techniques start on page 8 of the guide).

Your interview questions should be organized around places; marking the map will be your technique for organizing the material. Take a few minutes to work with your partner to develop a script you will both use.

Here is one possible example of the types of questions you may want to ask:

Family and local culture

1. Where do your ancestors come from?
2. Where were your grandparents born?
3. Where were your parents born?
4. Where were you and your siblings born?
5. What place in the world do you identify with as your real home?

What are the nonhuman influences in your life?

1. What is your favorite place?
2. Where is your favorite mountain, body of water, etc.?
3. Where was your favorite place to play (or hide) when you were 5 years old? 10 years old? 15? Today?
4. Who were the most important animals and plants in your life and where did you encounter them?
5. Where did you see the most interesting, unusual, or otherwise important, animal or plant you have ever seen?

Beliefs that help shape your thinking

1. Where are the spots that are important to your beliefs located? (only share what you want to)
2. Where are the places that are important to you personally? (only share what you want to)

Edit Data Table

Open one of the maps you created in the activities this morning

1. Add a column in the data table for additional information and add content directly to the data table. Open your markers and see what has changed.
2. Now open the map marker balloon for one of your locations. Click the pencil icon to get into edit mode and add content to the description box. Open the data table and take a look at what has changed.
3. Create a new layer, add some points, lines or polygons. Open the data table. Is it different from your other layer? How can you use different layers to organize content?

Data Sources

First Nations Locations

Inuit Communities Location

Activity

1. Create a new folder in your Google Drive by clicking on the +New button on the upper left side. Name your folder.

2. In your Google Drive folder create a new My Maps by clicking +New>More>My Maps. Give your map a name.

3. Now you will get the spreadsheet file that you will use to create your map layer. On this page, scroll up and find the folder with the activity files. Click on the icon for the Spreadsheet Activity #1 file. Download it to your laptop, then upload it to your Google Drive folder by clicking on the +New button and selecting File Upload. Make sure you open it as a Google Sheet (not as an Excel file).

4. Go back to your My Maps and import the Hands on 5 Google Sheet from your Google Drive folder. Use the latitude and longitude columns to place your markers.

5. Change the base map to Satellite.

6. Open and edit the data tables (click on the three dots on the layer menu). Delete any columns that you don't want and add columns of data that you think would be useful.

7. Click on the Preview icon (it looks like a stylized eye). This will open a new window and you will see what your map will look like to the public. Click on one of the map markers and look at the information panel.

Extra Credit

1. Go to your Hands on 5 sheet in your Google Drive folder. Take a look at the spreadsheet; it has columns for Band Name, Latitude and Longitude.

2. Now we will try using the Band Name column to locate our icons; this will work if the Band Name is used to identify the location on the Google base map. Go to your My Maps, create a new layer and import the Sheet again, but this time use only the "Band name" column (not Latitude and Longitude) to locate the icons. Were all the locations properly placed on the map?

3. Go back to your Sheet and add a column for "Country" and autofill "Canada". Try importing it again, this time using both the "Band Name" and "Country" columns. Did it correctly locate more of the locations? Did adding additional location information improve the accuracy of placing the markers?

Data Sources

Indian Reserves - Administrative Boundaries

US Census Cartographic Boundary Shapefiles - American Indian/Alaska Native Areas/Hawaiian Home Lands

Activity

1. Using the map from Activity #5 create a new layer.

2. Now you will get the KML file that you will use to create your map layer. On this page, scroll up and find the folder with First Nations Vancouver Island. Click on the icon for the KML file. Download it to your laptop, then upload it to your Google Drive folder by clicking on the +New button and selecting File Upload.

3. Go back to your My Maps and import the KML file from your Google Drive folder.

4. Click on the point and the polygon to open the panel and see the information from your data tables.

5. Open and edit the data tables (click on the three dots on the layer menu). Delete any columns that you don't want and add columns of data that you think would be useful.

6. Search for HOPE ISLAND 1 (to search click on the magnifying glass icon). Do you see the point data from your spreadsheet (CSV file) and the polygon from your KML file? (Make sure both layers are turned on.)

7. My Maps can locate points using either CSV files or KML files, but you can only import polygons and lines using KML or KMZ files. Think about how you would most effectively use spreadsheets and KML files to build maps, and when you might want to manually add points, lines and polygons to your map.

Extra Credit

1. If time allows, go to the "Extra Credit Activity" folder. This folder contains files that were downloaded from the Open Canada data portal and the U.S. Census Bureau. Add these files to your Google Drive folder.

2. Edit the CSV files in Google Sheets, removing any columns you don't want in your map data table.

3. Add new layers to your My Maps and import the sheets.

4. Import the KML file of U.S. Census Bureau cartographic data. You will now have boundaries for American Indian and Alaska Native lands.

5. Explore the data layers you created from downloaded files from different government agencies. How might you use these files in your own work?

Data Sources

2016 Canadian Census

Activity

For this activity we will use a spreadsheet to create both a My Maps layer and a graph, allowing us to explore two different ways to visualize geospatial data.

You can see an example of the spreadsheet with additional data columns, graphs and map layers below.

1. Create a Google Drive folder for this activity. Download the Hands on 7 spreadsheet file from the folder above and upload it to your folder.

2. Open the spreadsheet as a Google Sheet (this is a version that you can edit online and import into My Maps; if you have it saved as an Excel file you will have to convert it). Take a look at the columns, what information do you have to work with?

3. Think about ways to use the information in the spreadsheet to more easily visualize the patterns in the data. For example, in the spreadsheet below, data on provincial total populations, Aboriginal Identity and language were used to calculate percentages. You can use spreadsheet functions such as =DIVIDE(D2,C2) and autofill to quickly calculate the percentages (you need to fill in at least 2 cells and highlight them to autofill).

4. Create graphs by highlighting the columns you want to graph: go to the first column and click on the first cell of the column, scroll down and shift click on the last cell. Now go to the second column and hold down the command key for Mac users (or for PC users hold down the CTRL key) while clicking on the first cell then scroll down to the last cell and hold down the Mac command key (or PC CTRL key) as well as the shift key while you click on the last cell. This selects the values in two columns (and can be used for non-adjacent columns).

5. Click on the chart icon and the chart wizard will give you a suggested chart. This isn't always what you want, so use the chart editor to change the chart style, axis labels, etc.

6. Now use the same data to create a map visualization. Go to your Google Drive folder and create a new My Maps in your folder, give it a title. Import the spreadsheet into your map. Choose Style by data column and pick the data column you want to use for the layer. Choose Ranges and set the gradient you want to use.

7. Add another layer, import the spreadsheet again, and visualize another data column. Choose a different gradient color for this layer.

Compare the data visualizations in your graphs and maps. How might you use these two different visualization techniques to explore your data and communicate your results?

Historic Treaties in Canada

2016 Canadian Census

Indian Reserves - Administrative Boundaries

US Census Cartographic Boundary Shapefiles - American Indian/Alaska Native Areas/Hawaiian Home Lands

First Nations Locations

Inuit Communities Location