Google Teacher Podcast

Google News and Updates

• Add custom links to the navigation bar in the new Google Sites
• New in Google Slides: linking in Docs, guides and rulers, and improved commenting
• Checkboxes in Google Sheets
• Get more control over chart data labels in Google Sheets

Featured Content Stay composed: here’s a quick rundown of the new Gmail With new security and intelligent features, the new Gmail means business

• Improved security
  • Confidential mode
  • 2-step verification to open
  • Block forwarding and printing
  • can also make messages expire after a certain time
• Busy
• New tasks
  • Improved functionality and you can SEE it!
• Calendar and Keep integration
• Hover
• Similar to Inbox by Gmail features
• How to get it
  • Don’t feel left out b/c some of these features aren’t even available yet
• Cannot control size of sidebar
• Display density
• Settings looks mostly the same
• Expect add-ons to continue to grow
• Fancy splash page
• Default view: icons with G Suite files (under Settings > Display density)
• Snooze items until later (“someday”)
• AI suggested responses (like Inbox)
• Warnings for risky emails

Google Teacher Tribe Mailbag

Zach Ripley - Sheets add-ons (50), teacher question: middle school PE with data. Functions and formulas … import range function: master spreadsheet, one at a time: open student spreadsheet (only do once), copy key from URL, paste URL into import range function, master spreadsheet: import data from student sheet, real-time update (not copy paste) as students update.

Sara Reed (Aledo, TX) -- Google Classroom: see time stamp when a student turns in an assignment or mark it as done? If not, how do you handle students that say they did it and it doesn’t reflect in Classroom? (Click on “done” from assignment>then click on the student’s name from the roster on the left>then click “see history”)

Beth Cohen (Pennsylvania) -- HI Matt and Kasey! I love all the tips, tricks, and resources you share! Every year our Freshmen complete a unit on Academic Integrity. We have been using Moodle, which includes a self-grading quiz that lets students know whether they have achieved the minimum score and prompts them to review the resources and retake the quiz if they didn't pass. We will have GAFE instead of Moodle next year, so I want to reproduce the quiz in Forms, but I can't figure out how to set a minimum passing grade and notify the student whether he/she passed at the end. I could use branching and direct students back to the resources after every wrong response so that ultimately everyone ends up with a perfect score, but I'm hoping for a final pass or fail submission response. Hope you have some ideas! Thanks, Beth

Ben Whitaker (Oswaldtwistle, Lancashire, UK) Sheets: In Excel, can lock down certain tabs so they can’t be edited in collab spreadsheet. Is there a way in Sheets? Add-on? Keep up great work!

3 Ways to Protect You Google Sheets Data

On The Blogs

• Matt - 10 ways Google tools can make the end of the year rock
• Kasey - When the Lecture Ends, the Learning Begins from @Mo_Physics (Mike Mohammad)

  [shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• Rolling Study Halls: turning bus time into learning time
• How the Dynamic Learning Project is building teacher confidence
• Smarter sharing of files with updated Google Drive Access checker

Featured Content

Kaizena (voice comments) (kaizena.com)

• Leave voice comments for students
• Discuss student work in an online hub
• Reuse commonly use comments
• Track and rate student progress

Highlight tool

• Highlight a document in different colors
• Pull highlighted text from a document and sort in a table at the end of the document

DocSecrets

• Hides and reveals text in a document
• Use a password to reveal hidden text

WriQ

• WriQ is a new Add-on from Texthelp that helps teachers score and keep track of students’ spelling, punctuation and grammar errors so you can focus on the things computers can’t score.
• WriQ auto-scores your students’ docs and tracks the following measures over time:
  • Time spent writing
  • Text Maturity
  • Spelling error rate
  • Grammar error rate
  • Punctuation error rate
  • Percentage error free
  • Correct Word Sequences score
• The teacher dashboard gives you a clear graphical view of your students’ writing activity, and let’s you track their progress over time.
• Video overview

Read&Write for Google Chrome

• Technically a Chrome extension but can use in Docs (and web)
• Read&Write offers a range of powerful support tools to help you gain confidence with reading, writing, studying and research, including:
  • Text-to-speech to hear words, passages, or whole documents read aloud with easy-to-follow dual color highlighting
  • Text and picture dictionaries to see the meaning of words explained
  • With speech-to-text, dictate words to assist with writing, proofreading & studying
  • Word prediction offers suggestions for the current or next word as you type
  • Collect highlights from the text in documents or the web for summarizing and research
  • Create and listen to voice notes directly inside of Google Docs
  • Simplify and summarize text on web pages to remove ads and other copy that can be distracting
  • FREE for teachers

Easy Bib Add-On

• The Bibliography Creator by EasyBib allows you to easily create a bibliography for your research paper.
• Automatically cite books, journal articles, and websites just by entering in the titles or URLs. Format citations in MLA, APA, Chicago, Harvard, and over 7K other styles.
• When you're finished creating your bibliography, click Generate Bibliography and we'll alphabetize your citations and add them to the end of your paper.

BONUS: Equatio (chrome extension)

• Easily create mathematical equations, formulas, and quizzes. Intuitively type or handwrite, with no tricky math code to learn.

Google Teacher Tribe Mailbag

• Renee Johnson (Oakhurst, CA) - ctrl+z - to add to another location in Drive … Add student work samples to PD folder for teacher training.
• Craig Klement (Garland, TX) - Same three questions on student forms: First name, last name, class period (drop down) … Spreadsheet: right click on awesome box, sort range (by class period, then by last name) Differentiate forms: three dots, section based on answer (if correct: to next question, if incorrect: YT vid, article, picture, do over or similar question)
• How to Differentiate Questions in Google Forms

On The Blogs

• Matt - Creating a low-cost, printed school yearbook with Google Slides
• Kasey - Teachers Deserve #Respect

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates ()

• Add a custom favicon in the new Google Sites
• Google Maps learns 39 new languages
• Making it easier to find and share GIFs with Google
• Chromebook tablets for versatile learning

Featured Content () Examples with G Suite: 

• Student-Created Learning Goals with Google Keep
• Student-Created Vision Boards with Google Slides
• Using G Suite for Discussion
  • Google Classroom Discussion
  • Google Groups Discussion
  • Blogger Blog with Comments
  • Interactive Google Slide Deck
  • Google Forms Survey
• Using G Suite to go BEYOND the Tools
  • Create an eBook with Google Slides
  • Stop Motion with Google Slides
  • 10+ Things You Didn’t Know Google Slides Could Do
  • Pixel art in Google Sheets
• Using G Suite for Student Choice
  • Create Interactive Learning Menus with G Suite
  • Give Students Choice in Google Classroom Assignments
  • Build Choice into Hyperdocs

Do This, Not That [infographic] Kasey’s Dynamic Learning with G Suite Presentation SUBMIT LESSONS!!! Buy the Book: Shake Up Learning Google Teacher Tribe Mailbag ()

• Melissa Widrick recently commented on a previous episode's post: Keyboard shortcuts: Use CTRL+D in google slides to duplicate objects or word art. I love using word art over the text box, because you can adjust the size quickly, and if you use CTRL +D to copy it, you don't have to change the color and the font every time.
• Thank you to Monica Spillman and Laura Steinbrink for your recent Apple Podcasts Ratings and Reviews!

On The Blogs ()

• Matt - Shukes and Giff Podcast
• Kasey - 20 Tech Tips for Teachers

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• Want to Change The Game? Design one with Google Play
  • Change the Game Challenge
• A smarter search for files on your phone with Files Go
• OK Go makes some noise in the classroom
• Just a Line app (justaline.withgoogle.com)

Featured Content Sheets Add-Ons

• What are add-ons?
  • Add-ons run inside Google Sheets, Docs, Slides, and Forms, but they're built by developers like you and tie into over a dozen Google services without even spinning up a server.
  • Add-ons are built with Apps Script, a server-side JavaScript platform that requires zero setup.
• Where to find them in Sheets?
• Connection to forms
  • Google Sheets and Google Forms work hand-in-hand. The data collected from your form is placed in a Sheet where you can then manipulate results, perform additional calculations, and even create mailmerges using any number of add-ons.

Resources

• Autocrat
• Remove duplicates
• Super Quiz
• Flubaroo
• Flippity
• Doctopus

Google Teacher Tribe Mailbag

• #GTTribe One of my favorite ways to use #Google #Forms is to use the add on Form Recycler. We encourage Ts to use it to create test banks as they can pull ?s they have used before. Also saves on clicks! @ShakeUpLearning @jmattmiller

  — Lindsay Foster (@BSGSCSFoster) March 28, 2018
• Bailee Sandsmark (email), a 6th-grade middle school PE teacher asks, "

  I’d like to send out a Sheets template to all 250 of my students for them to individually track their fitness testing data, but then I would like to have an efficient way for them to share that info with me so that I can see all of my students' data in one sheet. Having to access 250 different sheets makes my head spin. Currently, my students track this data on a piece of paper, but it would be great for them to have a digital copy that can travel with them all three years of middle school so they can truly track their growth and so that their 7th and 8th grade PE teachers can see the data as well.

  I’m hoping you might be able to point me in the right direction of an extension that would do the trick."

Check out the Alice Keeler Template Tab! On The Blogs

• Matt - 11 tips for creating stop motion in Google Slides by Jake Miller (Episode 33 Guest)
• Kasey - The Nutritional Value of Learning

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• “Pup View” from the home of Japan’s adorable Akita dogs
• EDU in 90: Apps that work with Google Classroom
  • 50 Awesome Apps That Integrate with Google Classroom

Featured Content Forms Add-Ons

• What are add-ons?
• Where to find them in Forms?
• Difference between add-ons for Forms vs. Sheets
• Recommended Add-Ons for Forms (We will cover Sheets in another episode!)
  • Form Publisher
  • Choice Eliminator 2
  • Certify ‘Em
  • CheckItOut

Google Teacher Tribe Mailbag

• Sean Fahey (via Speakpipe) - Insert a Video into a Google Doc
• Becca Pierce, NC - First of all, I love your show! I listened to my first show last night and it was so informative! I will definitely be going back to listen to more! Thank you so much for all you do! My question: I recently have been looking into Hyperdocs. I went on the website and saved some of the already created ones to my Drive. One of them is a Google Doc. As the student scrolls down, he can click on these fraction problems. It brings up a smaller screen with a Google Drawings that can be edited. The student draws on some fractions and types answers. I love it! But I can't seem to recreate this concept. How do you put the editable version of a Google Drawing into a Google Doc (or slide)? Thank you!

On The Blogs

• Matt - Students Learn More When THEY Do The Work (Catlin Tucker)
• Kasey - The Shake Up Learning book comes out THIS WEEK! - April 4, 2018

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• Machine learning meets culture
• Learn what you can do #withClassroom
• Math Games now integrates with Classroom

Featured Content

Google Forms have come a long way since starting as a simple survey tool. Educators quickly found ways to use Forms in other ways; from teaching math to using them to give various assessments.

• Get started with Quizzes
• Google Forms Quizzes support
• Adding links to feedback to differentiate
• The immediacy of feedback makes it more valuable
• Focus on Formative Feedback (Valerie Shute):
  • Rresent elaborated feedback in manageable units,
  • Keep feedback as simple as possible but no simpler
• Settings:

• Export grades to Classroom
• 24 Tips for Google Forms Quizzes

Resources Google Teacher Tribe Mailbag

• Sarah Gershon (Waukegon, IL) -- Made a choice board for students, loves the show and told us via our SpeakPipe!
• Mr. Blight (via Twitter): I'm having some issues when putting my Drawings files onto my Site. It shows up faded when the site is published. Any thoughts or ideas? #gttribe #gsuiteedu

On The Blogs

• Matt - OMG Becky, PD is getting so much better! (via Cult of Pedagogy Podcast)
• Kasey - Pre-order the Shake Up Learning book and get The Dynamic Learning Workshop Course FREE!

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• • More menu and toolbar updates
  • Improve collaboration in Google Docs, Sheets, and Slides with Activity dashboard
  • Celebrating women’s voices around the world on International Women’s Day
  • Machine learning meets culture
  • Learn what you can do #withClassroom

Featured Content Google Drive Deep Dive

• Find shared content with new file organization in Google Drive
• Shared with me situation...it’s a filter, don’t try to clean it up!
• What is “computers” - Backup and Sync
• Google Drive support
• Google Drive keyboard shortcuts
  • Switch between grid and list in items view v
  • Show or hide activity pane i
  • Share selected items . (dot)
  • Show or hide details paned
• 8 Ways to Find Anything in Your Google Drive

Google Teacher Tribe Mailbag

• Add yourself to our community map! Thanks to Kathryn Laster for creating this and promoting!
• Chris Nesi’s House of EdTech Final 4 (includes Keep, Classroom, and several other tools that play well with Google!) 
• Whitney Hines - Using Google Slides to do #BookSnaps

On The Blogs

• Matt - Redefining Annotation: Ditch That PDF and hyper annotate (by Joe Marquez)
  • Joe was our GTT guest in episode 24!
• Kasey - Empower Your Students with the 4 C’s Learning Menu
  • Shake Up Learning with the FREE QUICKSTART GUIDE

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• Bringing online safety education programs to UK schools
• Providing more comprehensive results to your questions in Search
• Capture more of your favorite moments with Google Clips
• Google.org and StoryWeaver feed a hunger for reading

Featured Content

• The Guide to Keeping Up with Google
  • Part 1 – The #Google Hashtag Dictionary
  • Part 2 – Twitter
  • Part 3 – Who & What to Follow on Google+
  • Part 4 – Google+ Communities
    • Google Educator Groups
  • Part 5: Blogs
    • Keeping Up with Google: The One Blog to Rule Them All!
      • The Keyword Blog
      • G Suite Updates Blog
• @GSuiteEDUHelp Twitter account

Google for Education EDU in 90 YouTube channel Google for Education Facebook page Google Teacher Tribe Mailbag Kathleen Mathis (Annandale, Virginia) shared,

I wanted to offer two ideas that tie in to your bell ringer tips in Episode 43. Now that my school is 1:1, I have my students do warm-ups in an interactive journal using Google Slides. It used to take me forever to grade their paper journals and I always dreaded it...until this year. I now collect the online "journals" once a quarter and I use the Doctopus add-on with a Goobric to grade them. This has saved me a lot of time AND increased how much feedback I'm able to give them. Win win! Also, I've used their bell-ringer/warm-up journals to review vocabulary words. I randomly assigned students a vocabulary word and asked them to find an image that show the words meaning. Next, students put their slides in presentation mode, then do a gallery walk. As they view each other's work, they write down the vocabulary word they think is being depicted on a sticky note next to each laptop. When students return to their seat, they'll know whether their picture sufficiently showed their assigned word's meaning based on their peer's anonymous feedback. Plus, it gets them up and moving. :)

Tyler Osborne from Canada - Quick tips and keyboard shortcuts via Speakpipe Allison Gerken and her students are sharing Booksnaps on Twitter and Seesaw!

Library Chrome Extension recommendation from Noah Geisel lets you know if a book is available at the library:

This chrome extension lets you know if the book you're about to buy is avail at the local library!!! https://t.co/uRPjSOhF0D h/t @bhwilkoff cc #gttribe #gsuiteedu @StackupScore

— Noah Geisel (@SenorG) February 13, 2018

On The Blogs

• Matt - The 30-Day PIRATE Challenge and Kim Snodgrass’s PIRATE hook lessons on Twitter
• Kasey - 350+ Google Classroom Tips and Resources

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• Google Keep integrates with Google Drawings now
• Docs, Slides, Sheets, Drawings, etc. get a menu facelift
• Classroom updates
  • Teachers, you can now email a full summary of individual student work from #GoogleClassroom to any student and their guardians.
  • UI updates
• With just a flick of a wand, “Harry Potter: A History of Magic” is on Google Arts & Culture

Featured Content

As educators, we sometimes need to break out the duct tape or channel our inner MacGyver. Today, Matt and Kasey share some great Google based hacks!

If you have your own favorite hacks we'd love to know what they are. Leave a comment below this post or send us a message.

• Use Hangouts as a doc cam
• Use emoji extension to spice up drive and classroom
• Add a video to Google Drawings
• Hack URLs
• Boomerang for Gmail

[tweetshare tweet="My favorite Google hack is" username="GTTribe"]Google Teacher Tribe Mailbag

• “I have to go get my copy!” (Sienna Griggs - via SpeakPipe)
• Carol McLaughlin (2nd-grade teacher in Alabama)
• Kelly Davis (Chemistry, Downingtown East HS) - I would like to add pictures to feedback (my drawings, not a URL). Is this an option?

On The Blogs

• Matt - 5 Google Drawings features you (probably) don’t know about
• Kasey - Dynamic Learning with G Suite

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.

Google News and Updates

• New Google for Education Facebook Page
• Google Edu in 90 is Back in Season 2
• Jamboard now a core G Suite service
• Google Earth FAQ page launched
• Google for Education Transformation Center got an update!

Featured Content

• Humor in the Classroom
  • Research to back this up
  • The Effect of Humour and Mood on Memory Recall
  • Do’s:
    • Do use humor have fun
    • Do use humor to develop a community
    • Do use humor to enhance content
    • Do use age-appropriate humor
    • Do use humor to break up the mundane
    • Do use humor in transitions
• Teach Like the Tonight Show
  • Google Chrome Word Sneak
  • #DLDay Rap (Hashtag Challenge)
  • Internet Pop Quiz (Teacher Edition) with Google Slides
• Google Drawings Comic Strips
• 5 Clue Challenge
• CSI with MyMaps (place pins with “evidence”, state the “crime”/”mystery” in the description)

Resources Google Teacher Tribe Mailbag

• Peggy Volak (2nd grade PA): Published a slideshow, move poem to bottom of list without doing it manually
  • View slides as a grid (bottom left), Denis Sheeran Slide Sorter
• Emoji Exit Ticket from Don Yerks, Jr.

@ShakeUpLearning @jmattmiller Hi Kasey and Matt I am using this Health - Emoji Exit Ticket this week in my #healthed class 😊 Since you spoke about "Exit Tickets" this week on your Podcast, I thought I would share it out to the #gttribe Link 2 Exit Ticket https://t.co/PaBEZA5GUs pic.twitter.com/zUuhkoZzPJ

— Don Yerks, Jr. (@dyerksjr1) February 20, 2018 On The Blogs

• Matt - Create Interactive Stories With Story Speaker Add-on by Meredith Akers
• Kasey - What You need to Know to Pass the Google Certified Educator Level 2 Exam
  • Join the waitlist for my certification courses
    • Level 1
    • Level 2
    • Trainer

[shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.