Google Sheets Add-Ons - GTT050

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"]

---

<