In this lesson you will be using Google Sheets to create a Digital Activity guide (Think tourist guide) to a real place.

You will need to pick a real place, and do some research to come up with 10 locations or attractions that someone would want to see if visiting that place, they could then use your Digital Guide to decide how to spend their time.

You need to pick a REAL place, ideally someplace you may have already visited, or have always wanted to visit.

You will need to do some online research and use REAL ADDRESSES for the location, since later will be creating a map.

You will login into our Google Digital Skills Class and and look for: "Create A Guide To An Area"

We will start with Lesson 1.

Be sure to complete all the steps - you can skip the "Reflection" Step 8

Requirements

Your spreadsheet must include

1. At least 10 locations or places to see. (rows in the spread sheet)

2. Use the same column headings shown to you in the videos. (columns in the spreadsheet)

Lesson/Part 1:

Go here to Login with PUSD GMAIL:

https://applieddigitalskills.withgoogle.com/s/en/home

Turning Your Work Into Google Classroom

To turn in part one you can just "ADD" your spreadsheet from your Google Drive in Google Classroom. Be sure to hit the "Turn it In Button"

Be sure to keep you SpreadSheet in a folder in your drive so you can easily find it.

Most likely I will have you "Make A Copy" for each Lesson to continue adding features to your Digital Activity Guide

Lesson/Part 2: Rating Scale

You can skip the reflection #6

If your SpreadSheet is now "Read Only" since you turned it in to Google Classroom for Part 1 -

just MAKE A COPY. Name this one Part 2 so you can keep track. Keep them all in your Folder for this project!!

Lesson/Part 3

Creating A SideBar and Embedding Interactive Images

This one is going to require that you closely follow the directions in the video and do what they are showing. They will have you:

1. Researching for a code "snippet"

2. Copy and Pasting the Code into your project

3. Modifying the code

4. Testing your program

Don't get discouraged and give up if it does not work the very first time - just retrace your steps and try again.

Getting the Custom Side Bar to Work

Make sure when you are copying the code from the Google Developers resource you are using "Sidebar" and not "Dialog" code (there is a difference)

Here is link to a working Sidebar - check out the Code

https://docs.google.com/spreadsheets/d/1L4SmUnzZ0b4TCFHGRWYVoq4wrW-fD4pXZDGkjaFsKDI/edit?usp=sharing

Some Tips When Embedding Links/Images

Be sure that you are in the "Street View" mode when you are getting images so that you get the "Embed" option - or else you will just get "share".

Watch video again for this part in case you missed it.

Modifying the Code: Tips

Be sure to follow the steps outlined by Kumar in the video, code can be very specific. When you are typing code, you will get some prompts for auto-fill commands - so keep and eye out for those.

Here is the code that works!! (you can copy and paste if you get totally stuck)

function onOpen() {

SpreadsheetApp.getUi() // Or DocumentApp or SlidesApp or FormApp.

.createMenu('MurphMaster')

.addItem('Show sidebar', 'showSidebar')

.addToUi();

}

function showSidebar() {

var html = HtmlService.createHtmlOutput(SpreadsheetApp.getActiveRange().getDisplayValue())

.setTitle('My custom sidebar');

SpreadsheetApp.getUi() // Or DocumentApp or SlidesApp or FormApp.

.showSidebar(html);

}

Lesson 4/Part 4

Make A Custom Map & Link To Your Guide

This activity will have you importing your spreadsheet to MyMaps and then customizing the locations with the following:

1. Change the colors for each location marker

2. Choose a custom icon for each location (try and pick something related to the place)

3. Add a picture of the place.

Turning in to Google Classroom

Be sure to set sharing on your Map so anyone with the link can see.

Copy and turn the Link into Google Classroom (do not share directly with me)

Lesson 5/Part 5: Wrap Up

For this wrap up will take the "Reflection". This will be considered an assessment so you will take it live on the Zoom and it will be part of your grade for the assignment.

I can see your progress as you take the assessment - when you are complete you are all done and can leave the Zoom!

Be sure "submit" when you finish.

**You can skip the question about workin with a Partner**

Go here to Login with PUSD GMAIL:

https://applieddigitalskills.withgoogle.com/s/en/home