Hey ,

​

How’d You Do THAT?

Tricks, Extensions, Websites

& Add-ons

ICE Conference 2019

http://bit.ly/HEYICE19

Check-In for the Win!

​

goo.gl/9k9hN1

SPECIAL ANNOUNCEMENTS

Presenters

Presenters

Gail Stover taught elementary students (K,2-5) for over 13 years prior to becoming an Instructional Coach. She is in her 5th year as an Instructional Coach in District 301.

Leah Herold taught 4th grade for 9 years before taking on the role of Instructional Coach. She is now in her 3rd year as an Instructional Coach in District 301.

Both Gail and Leah taught with 1:1 devices in their classrooms and realized the potential, and challenges, of technology to support learning. Now as Instructional Coaches, they work with teachers to implement new curriculum and utilize technology purposefully in the classroom.

​

In the 2015-2016 school year, District 301:

• Went to 1:1 devices in grades K-12
• Became a Google school district
• Adopted Canvas as their LMS
• Switched to Skyward as a student management system/gradebook.

​

​

Google Tricks

G-Suite Help

• Quick, free, tutorials for Google Tools
• Look for the in upper right-hand corner
• Includes videos or walk-through tutorials

Image Searching

• Color
• Transparent (.png)
• Usage Rights
• Labeled for Reuse with Modification
• Type
• Photo, clipart, etc.

Image Searching

Filtering search terms will help you become more efficient and responsible in locating images.

Add to Dictionary

• Does your name always appear as incorrect?
• Add it to the dictionary in Docs

​

Table of Contents

​

​

Page Setup - Docs

• Set a background color in Docs
• Set Docs to portrait size or customize it
• Little changes make big impacts

​

​

File →Page Setup →Orientation →Choose Paper Size �→Page Color

​

Page Setup - Slides

• Set SLIDES to portrait size or customize it
• Little changes make big impacts
• File → Page Setup →Custom →
• Set dimensions (for portrait page size use 8.5 x 11)
• Setting it to match page size will be helpful if printing (ebooks, study guides, notebooks, etc.)

Dropdown List in Sheets

• Create a dropdown list in a cell in Sheets.
• Data → Data validation
• (or right click on cell → Data validation)
• Criteria - List of items, enter terms in blank
• Once created, copy & paste the cell to other cells needing the same data validation or select all cells prior to setting up data �validation.

Protect Sheets & Ranges

• Set permissions/editing rights for a tab or range of cells. Share tabs with specific people.
• Data → Protect Sheets & Ranges or �Right click on tab → Protect Sheet

​

​

Alternating Colors - Sheets

• Select cells/entire sheet
• Format → Alternating Colors
• Select default styles or set custom �colors/styles

Insert Checkbox - Sheets

• Select the cells for checkboxes
• Insert → Checkbox
• To remove, just select and press Delete

Gradient - Formatting

• Use standard or custom gradients for filling objects or backgrounds in Slides & Drawings.
• Fill bucket → Gradient → “Custom”
• Backgrounds → Gradient → “Custom”
• Change type, angles and colors. Add/remove “stops” (color changes) to fit your needs.

Owner Settings

​

​

• ^{Want to disable download and copy options when sharing�a Doc, Sheet, Slideshow or Drawing?}
• ^{Share → Advanced Options}

Docs - Set Default Font

• Type some text.
• Change the style of that text to what you’d �like your default to be.
• Click the Text Styles dropdown, �go to Normal Text (of whichever you’re changing).
• Click “Update Normal Text to match.”
• Optional: Repeat 1-4 to change any other text styles (i.e. Title, Subtitle, Heading 1, etc.) that you’d like to change.
• Click the Text Styles dropdown again.
• Go down to options and select “Save as my default styles.”

​

Favorite Shortcuts

Open new tab

​

Reopen closed tab(s)

(up to last 10 tabs)

Reopen closed Chrome Window

Open a new window, Ctrl + Shift + T and the last set of tabs will reopen.

​

​

UNDO!!

Ctrl

Chromebook Specific Shortcuts

Rotate screen by 90°

Zoom OUT of workspace

screenshot

Partial screenshot

Lock screen

Sign out of Google

Alt

ctrl

Full list of Chromebook shortcuts from Google

q

shift

ctrl

Keyboard Shortcuts - Formatting

Paste text

Paste text to match current formatting of slideshow

Zoom IN on workspace

Zoom OUT of workspace

Increase text size by one #

Decrease text size by one #

Keyboard Shortcuts - Formatting

Select/unselect specific items

Select all items in order (first to last)

​

Group selected items

Ungroup selected items

ctrl

shift

Forced Copy (1 of 4)

• Click “Share”
• Click “Get shareable link”

​

​

​

Forced Copy (2 of 4)

• Click the down arrow to the right of can view
• Choose your audience
• Copy the link

​

​

​

Forced Copy (3 of 4)

• Paste the link where it will be shared.
• Go to the end of the URL address. Delete everything from the end of the address to the backslash
• Replace edit and all words with copy
• The user will then be prompted to make a copy of the file.

​

Forced Copy (4 of 4)

Original URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/edit?usp=sharing

​

Forced Copy URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/copy

Template Preview (1 of 2)

• Allows the user to preview what the document is before opening. Once they click “Use Template” they have their own, editable copy of the document. It does not have the words “copy of” in the title.
• Follow the same directions�for “Forced Copy”. �Make sure to�turn on sharing.

Template Preview (2 of 2)

Original URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/edit?usp=sharing

​

Template Preview URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/template/preview

Forced PDF (1 of 2)

• When the user clicks on the link, it will automatically download a PDF version of the document.
• Follow the same directions for “Forced Copy”. Make sure to turn on sharing rights.
• At the end of the URL, replace edit with:
• For Google Docs and Sheets: /export?format=pdf
• For Google Slides and Drawings /export/pdf

Forced PDF (2 of 2)

Original URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/edit?usp=sharing

​

Forced PDF URL

https://docs.google.com/document/d/1AcRqTM6GN6kC13abQOmZzx8p_Ep1hVYcdizZykXF9XI/export?format=pdf

Extensions

Only modifies/supports the Chrome Browser

Not App Specific

Extensions, Apps & Add-Ons

• Extensions modify some aspect of the Chrome browser
• Apps are larger stand-alone web programs
• Add-ons are extra tools specifically designed for Docs, Sheets, Forms and Slides � (not consistent across all Apps)

Comparison

What’s the difference between Extensions, Apps & Add-ons?

​

Comparison chart created by Eric Curts.

Sir Links-a-Lot

• Sir Links-a-Lot is a Google Apps URL modifier
• Forced Copy, Template Preview, PDF
• Remember to change your share setting to “anyone can view” 1st

Tab Cloud

• Take a Look
• Manage tabs and bookmarks
• Chrome Extension
• Save tabs as collections to reopen in later sessions.

Mercury Reader

• Mercury Reader is clean print-type of extension
• Remove ads & distractions, leaving only text and images
• Works best on single articles
• Daily Herald Newspaper

​

​

Screencastify

• Screencastify A free extension that allows you to screen record. It’s easy to use and creates a folder in Drive for you.
• There is an Add-on for Slides (not Docs)

​

Eye Dropper

• EyeDropper allows you to pick a color from any webpage or color picker for easy color matching or formatting.

​

DriveSlides

• DriveSlides creates a Google SLIDES presentation out of a Drive folder of images
• 30 photos instantly uploaded
• Random order no specific order

Google Docs Quick Create

• Google Docs Quick Create
• Extension to quickly start a Google Drive file of any type!
• TIP: name the file and then put in a Folder right away at the top of the file

Tab Scissors

• Tab Scissors
• This extension splits a window into two at the selected tab.

​

Tab Glue

• Tab Glue
• This extension “glues” windows together

​

Apps

​

Apps utilized on Chromebooks

​

Math Apps

• Number Pieces: virtual base ten blocks, color coded, infinite manipulatives
• Money Pieces: coins and bills great for counting and arrays
• Pattern Shapes: virtual pattern blocks, colorful polygons
• Geoboard: stretch virtual rubber bands to make and measure polygons, perimeter and area help
• Number Frames: counting, arrays and fraction practice, an easy to annotate screen
• Number Line: skip counting, math operations, and ability to type and write on the number line

Add-Ons

Docs, Sheets, Slides & Forms

*specific to each tool

Extensis Fonts

• Upgrade your FONT game
• Add-on in Docs
• Search by popularity/trending
• Extensis Fonts

Screencastify

• Easily upload videos
• Add-on for Slides

Avery Labels Merge

• Use data from Google Sheets to create labels
• Add-on for Docs

Easy Accents

• Add on for Google Docs or Slides
• Opens to the right of your document.
• Choose from 24 languages.
• Click on accent/character you need to insert in your doc.
• Hold shift when clicking to capitalize.

Flat (Music Notation)

• Create and insert musical notation and snippets in Google Docs or Slides.

​

Websites

Slides Carnival

• Let's find some free templates!
• Free resources
• Credit slides at the end of your slideshow
• Google Slides Templates
• PowerPoint Templates

Free Clipart

• The Noun Project
• Flaticon
• No Backs
• Pixabay
• Unsplash
• Pexels

​

Lunapic - Photo Editor

• Lunapic is a free photo editor.
• You can add borders, special effects, even change the picture color.

HEIC to JPEG

• https://heictojpg.com/
• Convert photos from an Apple device to jpg format

Remove BG (Backgrounds)

• https://www.remove.bg/
• Upload a photo and the site will remove the background for you to download.

Omnibox

• Omnibox offers more than a way to search keywords
• Calculate math problems

QR Code Monkey

• https://www.qrcode-monkey.com/
• Create a QR code for various destinations.
• You can customize colors and design.
• Include an image or logo for �easy identification.

Vocaroo

• A quick audio recording tool
• No login necessary
• Does not store recordings long
• Creates QR codes
• Simple to use
• Vocaroo

Noun Project

• 1000s of free icons
• The Noun Project
• The is an Add-on but there is a limited amount of icons available.

Symbaloo

is the best and simplest starting point on the Internet

• Organize your favorite websites and online resources in one place.
• Share your favorite links, websites and Symbaloo pages with others.
• It’s device neutral.
• All ages can use this!
• Tutorial

Keep

• Note taking-like sticky notes
• Keep Extension allows you to save websites (has been glitchy lately)
• Keep is also a full Google App
• It can also be accessed in the right-side panel in Google tools.

​

Autodraw

• Let's Draw!
• Uses Artificial Intelligence (AI)
• Draw like a pro
• Turn your doodle into art!
• Tutorial

Google Gurus

Want more? Terrific people to follow:

Eric Curts - @ericcurts

Alice Keeler - @alicekeeler

Jake Miller - @jakemillertech

Matt Miller - @jmattmiller

Christine Pinto - @PintoBeanz11

Tony Vincent - @tonyvincent

Steve Wick - @WickedEdTech

Thank you!

We hope you found some helpful tips today! If we can help you in any way, please feel free to contact us.

Please complete:

​

Evaluation Form

​

Your honest thoughts will help us continue to strengthen our future presentations.

​

​

Let us know what you thought!

goo.gl/h3JDkv

​

​

SPECIAL ANNOUNCEMENTS