Advanced Google Docs, Sheets, and Slides

For Docs, Slides, and Sheets:

Revision History (Click to see)

Adding Comments

When you highlight a portion of text, the comment bubble automatically appears!

If you want to make a comment directly to someone, simply type "+" with his/her name. He or she will receive an email with the text you typed along with a link to the document.

You can "require" that person to "resolve" the comment as well.

Using the Explore Tool: (Click to see)

Add-Ons

You can find add-ons for Doc and Sheets -- not Slides.

Some Add-ons for Docs:

Some Add-ons for Sheets:

Tips for Docs:

Linking to Other Docs

  1. Highlight and Copy the URL of the Doc that you want to link.
  2. Highlight a portion of text in your other Doc.
  3. Click the Link icon.
  4. Paste the URL.

Reasons to link Docs to each other:

  • Create HyperDoc for students.
  • Link Docs for your lessons to Lesson Plans.
  • Link maps or drawings to Docs for students.

Inserting Bookmarks

Bookmarks can be added when you have a long Doc.

Reasons to add Bookmarks:

  • Direct students to specific portions of text.
  • Have students bookmark portions of their own assignments. (Questions they had trouble with, work they are proud of, etc.)

1) Select an area that you wish to bookmark.

Click "Insert" and scroll to the bottom and then click on "Bookmark."

A blue flag will appear next to the text.

2) Go back to the top of the document and click on the "Link" icon.

3) Select the one of the "Bookmarks" you created.

Creating a Table of Contents

Creating a Table of Contents is very simple, but it does require a little prep work.

  • Make sure you are using "Headings" if you want that text to appear in the Table of Contents

Reasons to use Table of Contents:

  • Digital Syllabus
  • Portfolio of Lesson Plans
  • Students can create a digital portfolio of work such as writing journals

1) Click on "Insert" and scroll down to "Table of Contents."

2) As you change your document, click on the arrow going in a circle in order to update the Table of Contents.

Tips for Slides:

Editing the Master Slide

The Master Slide is the main template for your Slides presentation.

You can choose an overall Theme and then change fonts, styles, and colors.

1) Click on "Insert" and then "Master."

The Master Slide screen pops up, and you can begin editing.

2) Begin editing as you see fit!

Reasons to edit the Master Slides:

  • Create a Drag and Drop simulations -- students will not be able to move portions that you create on a Master Slide.
  • Create a custom template for your course.

Applying an Image Mask

1) Click on your image.

2) Click on the cropping tool drop-down arrow.

3) Select any shape that suits your presentation design.

Reasons to Apply Masks:

  • Create more polished presentations.
  • Show students how to create more polished presentations.

Tips for Sheets:

Insert an Image into a Single Cell

In your cell, type “=image(“URL”)

  • Find the URL by doing a Google image search, then view only the image.
  • Copy that URL

Add a number (e.g. “=image(“URL”, 1)) for formatting:

  • 1 is image scaled
  • 2 is image stretched
  • 3 is keep the original size
  • 4 is custom size (so “image(“URL”, 4, 1600, 900) for example)

Highlighted cell with image function entered

Reasons to Insert Images into Cells:

  • Individualize your spreadsheets.
  • Used scaled images as part of data collection.

Import Tables of Information Directly from the Internet

Use "ImportHTML" function:

  • Type =IMPORTHTML ("URL", "table", #)
    • e.g. =IMPORTHTML("http://www.indexmundi.com/china/demographics_profile.html","table", 1)

Demographic information about China imported to Google Sheets

Reasons to Use Import HTML:

  • Have students research, aggregate, and compare data.
  • Have students use data to create graphs and charts.