AKA Gobs of Goodies from Google and Other Cool Stuff that Plays Well with Google

Disclaimer: If using a managed Google account, follow your IT Department procedures for using any of these resources/services, especially before trying to use them with students or student data.

Top Goodies

• Sir Links-a-lot  - Easy access to modified Google links.

• Crxcavator - an online tool for digging into Chrome extensions & seeing how safe they are. Also, check if it uses manifest version 2 or 3. Always be conscious of the permissions you are giving any extension!

Extensions:

• YouTube & Article Summary powered by ChatGPT  - Quickly access the summary of both YouTube videos and web articles. Here is a video to try this with - Copy Down Google Sheet Formulas in Google Form Responses

• Screen Mask  - Lowers the opacity of all but one horizontal bar to eliminate page distractions so that you can focus on reading one passage at a time.

• Save image as Type - Save a .webp image as .jpg or .png. This page explains .webp and has some you can use to try the extension.

• Revision History  - Show summary of history of edits in a Google Doc including "active writing time."

• Meow, The Cat Pet  - Virtual Cat pet who walks on your screen & can remind you of things. Dog option too. Doesn't work on a new tab in Chrome. Try this page.

• Stickity - Add-on For Docs and For Slides - Digital stickers to help support learning. More info here. Lots of stickers for free but they also have a Pro account with a trial - more on pricing here.

• Extensions I have published via my district: Hide Search Games; Hide YT Smart Chip Preview; Hide YT Renderer; Hide Video Carousel; Hide Wikipedia Audio Player

• FYI - Each extension enabled uses memory. Too many extensions can slow down Chrome. Use the extension Extensity to disable extensions when not needed.

• FYI - To manage extensions, click on the puzzle piece on your extensions bar and select Manage extensions. Review/Remove extensions; set up keyboard shortcuts for extensions.

Features / Techniques:

• Search Tools to filter your search results on Google Search - transparent images, Google Books > magazines. Don't miss using Advanced Search, Advanced Image Search, Advanced Book Search, Advanced Video Search. Also: AutoPagerize  - Automatically load the next page of search results. Another also: Dataset Search - discover datasets hosted in thousands of repositories.

• Shortcut Faves

• Drive - Preview Mode - OLD SHORTCUT: Select a file and press P. Use arrow keys to move to other files in that folder. NEW SHORTCUT: Option+Command+P

• Calendar - Views: Day (d); Week (w); Month (m); Year (y); Schedule/Agenda (a); Custom View (x) - set your custom view in Calendar Settings. NOTE - If your keyboard shortcuts aren't working, go to your Calendar Settings and enable Keyboard Shortcuts.

• Chrome - Open Location: ⌘+L (ctrl+L);

• Multiple services - Insert Link: ⌘+K (ctrl+K);

• See all keyboard shortcuts in most Google services: ⌘+/ (ctrl+/)

• Drive tip - How to update a PDF in Google Drive without changing the link 

• Docs tip - Download all images in a Google Doc - bit.ly/GetImagesFromDoc. If you want to try it, make a copy of this Google Doc that has a bunch of photos in it.

• Chrome tips -

• Tab Groups - You can save groups now!

• Tab Organizer - Must have Experimental AI enabled to use. Chrome can suggest and automatically create tab groups.

• Type @ in Omnibox and select SEARCH TABS

• Bookmark all tabs at once (without an extension) - More > Bookmarks and Lists > Bookmark all tabs

• See what Chrome is up to with the Task Manager - More > More Tools > Task Manager

• Paint Format Button - Quickly copy/paste formatting (Slides, Docs, Sheets).

• Workspace for Education - Info about types of licenses

• Some EDU PLUS license features you may hear about (and many more new ones coming Monday morning of ISTE!)

• Custom Building Blocks in Google Docs - Turn content in your document into a custom building block so you can quickly reuse it in the future.

• Slides Recording - Record video while presenting a Slides file

• Speaker Spotlight - Embed your webcam into a slide deck when presenting.

• Keeping track of what's new:

• Help > Updates
• Subscribe to Google calendars: Rapid Release; Scheduled Release
• Google Keyword Blog
• Google Workspace Updates Blog

Other Online Goodies:

• Sodaphonic - Great share from Tony Vincent (Learning in Hand) on Facebook: "You can record, edit, and download audio on the Sodaphonic website for free. No login required! In addition to trimming, you can select waveforms to cut—making it easy to remove mistakes. (via Josie Gaudet)"

• Forms History - Google Form Add-on - "Revision History" for Forms! See if changes have been made to a Google Form, create back-up versions, and view copies.

Experiments:

• Labs.Google - The home of newer Google Experiments. May not be able to use these with a managed account. Requires enabling access to Early Access Apps. Users must also be 18+.

• NotebookLM - notebooklm.google.com - Google's reimagining of what note-taking software might look like if you designed it from scratch knowing that you would have a powerful language model at its core. Help doc. Also see this recent blog post from Google: NotebookLM goes global with Slides support and better ways to fact-check

• GENTYPE - labs.google/gentype - Make an alphabet out of anything

• Illuminate - Turn academic papers into AI-generated audio discussion

• AI Test Kitchen (from Google - requires signing in)

• MusicFX - Generate synthetic music from text prompts. Can download the mp3. A sample prompt: "Smooth jazz that sounds like sipping wine" and here was a result - MP3. You can even do DJ Mode where you change the music while it's playing by adjusting the prompts.

• TextFX - Expand the writing process by generating creative possibilities with text and language. I like Fuse - find similarities between unrelated things.

• ImageFX - Image generator with guides for building and editing prompts.

Honorable Mention Goodies

• Slides Toolbox (Add-on for Slides) - Lots of time-savers. Faves: export all slides as images at once; export all hyperlinks; OCR & Send to Docs; and more. Google super-admin can apply to get a premium activation key for your entire K-12 domain!

• GIF Maker in Google Chrome  - Make animated GIF from static photos - like those from Slides Toolbox. A sample Google Slides file to use.

• AI for Busy Readers - Also AI for Busy Email  - A sample to use

• 18 Best Practices for Working with Data in Google Sheets - via Ben Collins. Check out all of his great Google Sheet posts!

• Google Sheets Macros - HUGE timesaver. Great intro to Google Apps Script.

• Google Tasks - How to; Tips & Tricks; and check out TasksBoard

• Secure your Google Account: Sites & apps that have access to your Google account data. Learn more about 2-Step Verification.

• Change your default font for Google Docs! (Directions using iorad)

• Shapegrams - Fun way to learn all the Drawing tools. Cheap for what you get (if you purchase). Check out more from Tony Vincent here.

• IconsMania - Icons & illustrations optimized to be edited and used by non-professionals. Some examples: Chemistry Icons (outlined; monochromatic); School Icons; Calendar Icons; Sports Icons;

• Gmail Tables  - Add tables to Gmail.

• Graphic Organizer Templates - from Eric Curts

• Applied Digital Skills - Engaging, ready-to-use video lessons. Here is a great blog post about Applied Digital Skills from Eric Curts.

• Virtual Field Trips from Google Arts and Culture - An alternative to the now deprecated Google Expeditions.

• Fabricius - using the power of AI to decode Egyptian hieroglyphs

• 20 Years of Google - Interactive visualization of Search queries (English language only) to celebrate 20 Years of Google.

• Talk to Books - Browse passages from books using experimental AI

• What Came First - Compare cultural moments in time. Arts and Culture Experiment.

• Google EDU Teacher Center - Free training & resources for educators. See more about Google Level 1 & 2 Certifications later in this document.

• Naming version of a file for reverting to master copy

• SlideContents - Add-on for Slides - Create a table of contents for a slide deck with heading text linked to slides.

• Bjorn's THUMB-TOCS - Add-on for Slides - Like SlidesContent but instead of text links, creates thumbnails of each slide and links it to the slide. Bonus - Find lots more add-ons from Bjorn here (some free, some require subscription after trial).

• Global GEG (Google Educators Group): Check out - Beginner's Guide to G Suite; Google Guardians; Certified Educator Bootcamp 2021

Basic Goodies

• Keyboard shortcuts: Chromebooks; Gmail; Drive; Docs; Sheets; Slides; Forms. Bonus: Tips in Sketchnote Format - Chromebook & more for G Suite NOTE: If sharing with students, make a copy and share that one - not my copy!

• Interactive Newsletters using Google Slides - some of my past issues. Here is a resource I made for a presentation on the topic.

• Templates in Gmail - Video with no audio or as a GIF

• Groove Pizza (from Experiments with Google) - Playful tool for creating grooves using math concepts (shapes, angles, & patterns). More info here.

• Customized bullets in Docs & Slides - bit.ly/customizedbullets; EmojiCopy - Copy & put anywhere text it (bookmarks, file/folder names, page names in Google Sites, etc)

• InsertLearning  - Insert instructional content on any web page including published Google files. Free accounts have limits. Teacher account $40/yr.

• Doc Variables - Add-on for Docs and Slides - Simple tool to add variables in content, title, header, and footer. Great way to add easy replacements in docs and templates! Freemium (after 20 uses there's a timer you have to wait on).

• formMule   - Send personalized emails from a GSheet.  Run manually or trigger a merge to run automatically on GForm submit or on a timer.

• Google Trends: Explore - Explore what the world is searching for. Use the Google News Initiative Training Center to learn more about Google Trends.

• Google News Initiative - Develop knowledge and skills in digital journalism. Faves: Fundamentals - 12 lessons; Investigative Reporting - 7 lessons; Google Data GIF Maker - 5 minute lesson.

• Open Images Dataset - Used by Google A.I.

• Mathigon - Interactive textbook and virtual personal tutor. Also check out the activities section.

• Toby  - Tab managing + bookmarks + sharing.

• mote  - Enable voice note feedback within Google Classroom, Google Docs & more. Free version has shorter recordings. See pricing.

• Smart Chips 

Search:

• Search Tools - Filter options vary by type of results page: Web (time), Images (color, usage rights [Creative Commons]), Videos (duration, quality, source); Books - time.

• On Google Search - Timer; Coin Flip; Calculator; Convert Units; Tic-Tac-Toe; Solitaire. If your school district wants to block time-wasters (like Snake), have them force install this extension I made - Hide Search Games.

• AR objects in Google Search on a phone - Android or iPhone/iPad

• Search by Images - Find the source to cite an image you have OR see if that artwork a student turned in has been plagiarized.

• Google Dorks (aka Google Hacking) - Specific search queries to narrow down results. Useful Google Dorks for Open Source Intelligence Investigations. Also good for testing vulnerability of websites and online data. Post on FreeCodeCamp; Google Dorks Cheat Sheet 2024; Google Dorks Simplified

Drive:

• Drive20 Lite  - Open first 20 files in a Drive folder

• Checker Plus for Google Drive  - One click to your Google Drive

• Drive Word Cloud    Don’t have to authorize Drive access - just paste in text.

• Folgo for Google Drive  - Bulk actions in Google Drive. Copy, transfer, inspect, rename folders (with subfolders & files).

Docs:

• 11 Google Docs tips I use every day to save time - Google Keyword Blog

• Fabulous Features of Google Docs - from Eric Curts

• Change background color of a Google Doc

• Turn Your Google Doc into a Web Page (Publish to the web) - Allows a Doc (or other file) to be embedded into another webpage. We used to give a principal access to post on the school website without having to give access to the website system. Note: May be limited by permissions in EDU domains

• Voice Typing

• HyperDocs Templates 

Slides:

• Publish to the web as a simple website. Great for layout control. LOOKS the way you want it. Here is a sample. Tip - Use tables with no lines for better layouts.

• Using Google Slides live closed captions in the classroom (blog post) - and here is a video showing it in action.

• Slip-in-Slide (Add-on) - Insert slides into multiple student presentations at one time using Slip-in-Slide. Choose to send one or many slides from your presentation to an assignment folder in Classroom. Video demo - https://youtu.be/bI2CVe-a4yI . More info here.

• Creator Studio - Add-on for Slides - Convert Google Slides to animated GIFs & more. Some features require upgrading at a cost.  Sample deck for a countdown. The GIF. Bonus - Here is a video showing how I used this to make an animated GIF of my Bitmoji. Double bonus - Here is a presentation I did on Stop-Motion Animation with Google Slides. Some other examples: 450-slide animation (YouTube / the Slides file); my #GTAATX video.

• Google Slides as Narrated Storybooks - a blog post

• Slides Mania - Lots of Google Slides templates, especially for EDU. Check out their Google Slides tips 

• Slides Carnival - Great Google Slides templates

• Photos to Slides - Import photos from Google Drive or Google Photos to your slides. Free account is limited to personal Google Photos albums and 50 photos imported at a time. Upgrade to load up to 1000 photos from an album; access Shared photo albums; add captions from photo descriptions; and more. Thanks to Clay Smith! Session example uses Photos for Class with the images in this Drive folder.

• Insert Icons for Slides - Add-on for inserting FontAwesome icons and Google Material Design icons in a variety of colors. Free. Also available for Docs. Another good one for icons is Icons for Slides and Docs from freepik (but freepik may be blocked for students). DON'T FORGET - Add ALT text to increase accessibility.

• Slides Randomizer - Randomly sort slides in Google Slides. Randomize the entire presentation, pairs of slides, or selected slides. Randomize on open.

• Slide-Slide-GIF - Convert slides to animated GIF

• Google Slides Signature Collector - a non-published add-on from Zak Kolar - After copying the Google Slides file and setting it up, a web page is made you can send to students (or staff). The page has a form for students to type and sign their names on a computer or mobile device. All of the signatures are saved into a Google Slide, where they can be resized, rotated, and arranged as desired. Once done, you can download the slide with all of the signatures as a PNG with a transparent file to use for a yearbook page, T-shirt, or any other project that uses signatures. Note: the video doesn't use the latest Apps Script editor. To get to the web app deploy area, click on the blue DEPLOY button and choose "New Deployment." Try adding a signature to this demo slide (you can use a "dummy" name - just keep it clean).

Sheets:

• Ben Collins - Guru of all things Google Sheets (and Google Apps Script). Free course - "Advanced Formulas 30-day Challenge" - Great to share with office staff.

• How to make a Dynamic Search Bar - blog post from freeCodeCamp

• "Don't Fear the F Word" - My virtual Sunday session from #ISTELive 2024 - The easy way to use spreadsheet formulas.

• How to Email Screenshots of Google Sheets on a Schedule - blog post from Amit Agarwal

• 21 essential Google Sheets tips and tricks - blog post

• Google Sheets Timeline Creator - Blog post with template from Eric Curts. Also has two completed examples (Civil War Timeline; Edison vs. Tesla). BONUS - Video, "How to use Timelines in Google Sheets," from Flipped Classroom Tutorials (4 min) that focuses on organizing projects.

• “Paste Special” in a Google Sheet

• Flubaroo - Auto-grade MC/FIB assignments given w/GForms.

• autoCrat - Turn GForms responses into GDocs/PDFs/Slides. Personalized feedback for students/parents/teachers based on information in a GSheet.

• Event-o-Matic   Merge spreadsheet data into calendar events, set logic conditions, form/time triggers, & sync updates. More on paid version here.

• Standards Based Grading GAMIFIED w/badges managed w/GSuite

• Magic Digital Badges  - Create Digital Badges using images stored in your Google Drive that can be assigned to students.

• Awesome Table - A more user-friendly way to access Sheets data. An example. But I do recommend you look to Google Looker Studio (formerly Data Studio) as a better alternative.

• 18 Best Practices for Working with Data in Google Sheets

Forms:

• Share Google Forms with "View Only" Access so others can make copies with you needing to give them edit access - check out my script that does all the heavy lifting.

• Paste options for Google Form questions

• FormCreator  (for Google Sheets) - 1) Build questions in Google Sheets. 2) Select questions to include by checking a checkbox. 3) Generate Form. You can insert embedded images and correct answers for text questions! Handy for creating multiple versions for Form quizzes. More info here. Limits for free plan but domain-wide price is very reasonable.

• Certify'em  - Send customized certificates to anyone who passes quiz.

• Dynamic Fields - Dynamically update values of questions in Google Forms from Sheets, Contacts, Groups, Drive & more. Limitations for free version - 3 updatable questions; 30 updates a month. Paid version is 50 Euros (company is German).

Drawings:

• Google Drawings 

• Google Drawings interactive posters (no glue sticks necessary!)

• Shapegrams - Fun way to learn all the Drawing tools. Cheap for what you get (if you purchase). Check out more from Tony Vincent here.

• Templates of Graphic Organizers 

• Teaching Math with Google Drawings - from Eric Curts (@ericcurts)

• Doodle Yourself with Google Drawing - Great for start of school year

• How to Make a Digital Book Jacket in Google Drawing - Neat project for students.

• “Hands on with Google Drawings” session. Many uses: this & this & this

Gmail:

• Email Templates - HUGE time-saver - Video with no audio or as a GIF

• Gmail Tips and Tricks - My favorite? Undo sending a message!

• Snooze emails

• Schedule emails

• Archive vs. Delete - blog post from 2017 but still relevant

• Pop Out a Gmail Window in a New Separate Free-Floating Window (YouTube)

• Add plus signs to email address - Create alternative addresses. Ex. jsmith+work@gmail.com & jsmith+pta@gmail.com still get delivered. Use these when signing up for newsletters, new apps, etc & filter incoming messages sent to these specific addresses. Explained in this blog post.

• Keyboard shortcuts - When on Gmail, type ? to see shortcuts. If nothing happens, go into Gmail settings > General and enable keyboard shortcuts. Some faves: Compose (c), Archive (e), Toggle Star (s), Mark Unread (Shift+u), Snooze (b).

• Bitmoji for Gmail 

• Gmail Sender Icons  - Shows company domain name of email sender & official logo (favicon) of sender's organization alongside the email message.

• Row Highlighter for Gmail™ and Inbox™  - Highlights Gmail rows on mouse over.

• Free HTML Editor for Gmail by cloudHQ  - Customize Gmail tables, charts, buttons, image formatting, etc.

Calendar:

• Get started with Google Calendar

• Use cal.new to make a new Calendar event

• Appointment Scheduling - Part of appointment slots. Allows external users to schedule meetings without having a Google account.

• Delete Your Google Classroom Calendars - post and template from Alice Keeler

• 10 Tips for using Google Tasks and Google Calendar as a student agenda - blog post from Jennifer Donaldson

• Keyboard shortcuts - When on Google Calendar, type ? to see shortcuts. If nothing happens, go into Calendar settings and enable keyboard shortcuts. Some faves: Day View (d), Week View (w), Month View (m), Schedule View (a), Year View (y), Create an event (c).

• Bulk Calendar Events - Google Sheets Add-on. Bulk creates Google Calendar events with optional Google Meet. Add location, guests, change the event visibility, color and much more.

• Checker Plus for Google Calendar™  - See your events, get meeting notifications, & snooze events without opening Google Calendar.

• More Colors for Calendar!  - Insert custom colors into calendar events.

• Gradient Merge for Google Calendar™ Events  - Duplicate Google Calendar events are visually merged into one event using the colors of each calendar to create a gradient for each event.

• Event Merge for Google Calendar™  - Duplicate Google Calendar events are visually merged into one event using the colors of each calendar shown in diagonal stripes.

• Tags for Google Calendar™  - Event names containing a colon (:) will have the part before the colon being displayed as a colored tag. Event names ending with a question mark will be displayed in italic & transparent.

Chrome:

• Turn on Sync to sync bookmarks, history, extensions, & more!

• Live Captions in Chrome - Show captions for any media you play in Chrome

• Using multiple profiles in Chrome - a MUST if you have more than one account to use in Chrome!

• Crxcavator - * Not an extension - an online tool for digging into Chrome extensions & seeing how safe they are. Always be conscious of the permissions you are giving any extension!

• Make keyboard shortcuts to activate extensions - Get to it using the "More" menu on the side of the Extensions page.

• Magical - Text expander & autofill. Currently free but you can collect credits by referring other users. They do anticipate rolling out paid versions.

• Dualless  - Splits your browser windows into two by just 2 clicks

• Sir Links-a-lot  - Easy access to manipulated G Suite links.

• Use Immersive Reader on Websites  - Great for Chromebooks. No Microsoft account needed.

• AutoPagerize  - Automatically load the next page of Google search results

• Picture-in-Picture Extension (by Google)  - Watch video in a floating window. Here is what it looks like.

• Emoji Keyboard by JoyPixels®  - Copy & put anywhere as text (bookmarks, file/folder names, page names in Google Sites, etc). You can also just visit their website - EmojiCopy

• ReClipped - Take time-stamped notes and screenshots from videos on YouTube and many other platforms.

• Some more extensions to try - How to install & manage Chrome extensions

• Extensity  - Make Chrome faster. Quickly enable/disable extensions/apps.

• Bitmoji  - Quick access to your Bitmoji. New custom Bitmojis too - maybe. ;-)  Custom Bitmoji Feedback [by Mandi Tolen] & a sample Bitmoji sign [Drawing]. Also check out DocStickers [by Stephanie Filardo] including starting set of sticker images [Drive folder] & template to make your own stickers [Drawing]

• Screencastify  Screen Video Recorder

• Loom  - Record quick videos (screen, webcam). Instant share or download. Password protection. Time-stamped comments. 10 min. max video.

• Move It  Be reminded to take a break

• Draftback  Playback the revision history of a Google Doc

• Save to Google Drive  Great way to take full page screenshots

• Magnifying Glass (Hover Zoom)  - Enables you to magnify a portion of a webpage with the click of a button.

• Palette Creator    Instant color palette from a picture

• Mic Note  - Voice Recorder/Notepad - GDrive/Dropbox. Transcribe recorded (or uploaded) audio. Time syncs transcriptions too!

• Alice Keeler Webcam Record  - Quick webcam recording 30-90 seconds.
  Saves to Drive. Shareable link auto-copied.

• Quick Create Plus  - Create new Google files with one click. I made this extension.

• Chrome Capture - Make quick, short animated GIFs. Free for basic tasks. One-time $9.99 fee for more features.

• Toby  - Tab managing + bookmarks + sharing.

• mote  - Enable voice note feedback within Google Classroom, Google Docs & more. Free version has shorter recordings. See pricing.

• Auto Highlight - Automatically highlights the important content on article pages. Addresses *tl;dr* in a similar way to an article summarizer. Can customize the highlight color and can copy all highlights. Sample page to use.

• Google Easter Eggs

• The Dinosaur Game - Or here or by typing chrome://dino into your OmniBox. Feel like cheating? Hack it to bypass the game over.

• You can still play Atari Breakout

• Play Pac-Man instead

• Chrome Remote Desktop - Securely access a computer from your phone, tablet, or another computer.

• Google Chrome Canvas - Basic drawing app native to Chrome

Chromebooks:

• Chromebook Simulator

• 10 Chromebook Touchpad Tips and FREE Poster - from Eric Curts

• How To Chromebook - from Google

• Making Chromebooks accessible for people with disabilities

• Chromebook Help

Google Classroom:

• Google Classroom posts on Teacher Tech blog especially:

• 11 Things to Start with in Google Classroom

• 50 Things You Can Do With Google Classroom

• 60 Ways Math Teachers Can Use Google Classroom

• 7 Hacks for Google Classroom

• 20+ tips to use Google Classroom effectively and efficiently - blog from Matt Miller

• Help your students learn to read with Read Along in Classroom - blog from Google

• Insert images into practice sets in Google Classroom - blog from Google

• What's New in Google Classroom - from Google

• Schoolytics - Get insights on student engagement and learning outcomes in your Google Classrooms.

YouTube:

• YouTube & Article Summary powered by ChatGPT  - Quickly access the summary of both YouTube videos and web articles. Here is a video to try this with - Copy Down Google Sheet Formulas in Google Form Responses

• Saima - AI-based video speed controller and note-taking assistant  - Personalized playback speed, skip silence, voice boost and collaborative video notes on any platform. Limited use with a free account (pricing).

• Edit Auto-Generated Subtitles on YouTube

Earth / Maps:

• Google Earth - Zoom all the way out to rotate the globe

• Timelapse - Watch the change happen

• Google Lit Trips

• GeoGuessr - Guess where you are on a StreetView Map in game.

• Mapping from a Google Sheet - A tutorial from Google Earth Outreach. Also check out Google Earth Education

• Google Earth Inspired Landscapes - Interesting art project

• 57 Google Earth & Maps Tutorials for Teachers and Students from Richard Byrne

Keep:

• Google Keep - Cloud-based stickies

• Category Tabs for Google Keep   fast filtering

• Spark Joy with Google Keep! - Free online course from friedOnline

• Collaborative notes; location-based reminders

• Google Keep Help 

Fonts:

• Google Fonts - Especially check out the Lexend fonts (YT video) which are designed to improve reading speed.

• The Best Google Font Pairings + More Design Tips for Teachers

Apps Script:

• Find my past presentations here

• Learn how to CREATE your own cool Add-ons and scripts 

• Ben Collins - Free "Apps Script Blastoff" Course

• Totally Unscripted - YT Channel

• Apps Script Pulse

• GAS on StackOverflow

• GAS on GitHub

• Alice Keeler's GAS Tutorials & Scripts

• Martin Hawksey blog posts on GAS

• Amit Agarwal - Posts on GAS

• Google Sheets Programming With Google Apps Script (book sample) with accompanying code snippets

• Google Workspace for Developers

• GoogleDev Codelabs

• Sharing a Google Form with "View Access" so someone can copy it - my script 

• Google Apps Script Snippets

• Top 30 Useful Google Apps Script Snippets

Looker Studio (formerly Data Studio):

• Find my past presentations here

• Looker Studio Help from Google

• Looker Studio Help Community

• Courses from Smith Visualizations - Excellent resources from Chris Smith including some sample dashboards and tips.

• Hands on with Google Data Studio (book)

• Filter by email address

• 2 Ways to Use Conditional Formatting in Looker Studio

Google Level 1 & 2 Certification:

• Info from Google: Level 1; Level 2

• The following may be out of date but I am leaving them here since they may not be out of date.

• What to expect - includes sample questions

• Step-by-Step Guide to Registering for Level 1 / 2 Exams

• Google Certified Educator L1 and L2 Exam FAQs

• Fundamentals and Advanced Course Outlines

• Google Workspace Skills Checklist - skills with accompanying videos

• Google Educator Level 1 Basic Tasks

• Google Educator Level 2 Basic Tasks

Other Goodies:

• Voicemail Organizer - Import your Google Voice voicemails to Google Sheets. An Sheets Add-on experiment by Google Creative Lab.

• Google A-Z - from Monica Isabel Martinez

• 8 Googley Wintertime Activities for Kids - from Eric Curts

• 11 Essential Google Lens Hacks Every Android User Needs To Know

• Follow the Keyword Blog from Google to stay up on the latest!

• Teachable Machine - A fast, easy way to create machine learning models for your sites, apps, and more – no expertise or coding required.

• Odd One Out - Find the AI generated image

• Haiku Imagined - Experience traditional and modern haiku lovingly illustrated and animated with AI generated music, fonts, and video.

• 3D Pottery - Sculpt your own historical pot

• Text Blaze - Text expander service. Limited features with free version. Paid version reasonably priced.

• Which Face is Real? - Get students thinking critically about images they see and try to choose the one not created with generative AI.

• Tactiq for Google Meet Transcription  - Captures the Closed Captions in a Meet as a transcript. Can even be saved right into a Google Doc.

• Google Public Data Explorer - Who IS John and why does he have 40 watermelons? Why use made up data when this is available?!?

• Dataset Search from Google

• Google Books Ngram Viewer - Enter three phrases to view a graph showing how those phrases have occurred in books scanned by Google. What can we infer?

• MixKit - https://mixkit.co - Free HD video & art

• Semantris - Word association games powered by machine learning

• Google Experiments - Song Maker on Chrome Music Lab, Morse Typing Trainer, (more Morse stuff here), Bird Sounds (drive your cat crazy with this one - LOL), RadioGarden

• Templates for Teachers - A collection of Google files ready to copy and use from @bethkingsley13 and @SarahJKiefer. BONUS - Check out Sarah's website techyoucando.com

• HyperDocs TeachersGiveTeachers - This is a collection of shared HyperDoc templates and samples

Other Stuff:

• How I zoom in on my Mac for presentations - System Preferences > Accessibility > Zoom. Set zoom style to picture-in-picture. I also turn on "Use scroll gesture with modifier keys to zoom." You can click the Advanced button to adjust levels of zoom.

• Geeks for Geeks - A computer science portal. Lots of useful info, tutorials, videos, and tools - including topics like machine learning, data science with Python, and school subjects like mathematics, physics, chemistry, and biology.

• iorad - the tutorial builder - Instantly make guided, step-by-step directions for any website. Directly in the browser.

• Scribe - Similar to iorad. Auto-generate step-by-step guides, just by clicking record.

• Zoom Earth (not from Google) - Interactive world weather map. Updates every 10 minutes or so.

• Constitute Project - The world's constitutions to read, search, and compare.

• TwistedWave - Online audio editor

• Generate AI Warm Ups from Teacher Tools AI

• Procreate app for iPad. My go-to for Sketchnoting.

• Space Elevator

• National Jukebox from the US Library of Congress

• remove.bg - Remove the background of an image

• Squoosh - Optimize images for faster loading

• BigJPG - AI Image Enlarger. Great for making Bimoji images bigger and not pixelated.

• Unscreen - Remove the background of a video

• FontStruct - Free font-building tool. Combine geometrical shapes in a grid pattern.

• Calligraphr - Create an installable font from your own handwriting

• Scan Barcodes into a GSheet - Scan to Web. Apps for iOS or Android.

• Method Draw - Free online vector graphics software

• 5 Clue Challenges from Michael Soskil - Mystery location videos, mystery animal videos, and more.

• Photos For Class - Classroom/edu images. Attribution added when downloaded.

• SoundTrap - Online music editor. Great for podcasting!

• GapMinder - Free teaching resources making the world understandable based on reliable statistics.

• EGVideos (on YouTube) - Thousands of standards-aligned topic videos.

• BotLogic - Coding game. No login required.

If you want to reach me more directly, you can give me feedback here: 

http://bit.ly/feedback4wanda 

Back to the top

About this document:

This document changes frequently so hang on to the original short URL - https://bit.ly/googlegoodies - and drop by to pick up the latest version from time to time.  If you want to be prompted to make your own copy, try this link instead - https://bit.ly/googlegoodiescopy 

When using this document to guide a workshop or session, I usually hit the TOP GOODIES first. Then, as time allows I will hit some or all of the HONORABLE MENTION GOODIES. I usually try to scan over the remaining items (sorted by service or area) and toss in a few more for good measure.

If you are attending a session and already know the material I am sharing, I hope you will find something contained in this document that is new. Explore as you wish.