Odds are you have more than one Google Account. Your personal and your school at least. The best way to manage you multiple accounts is by adding Chrome logins. This allows you to be in both accounts at the same time without conflicts. However, it can be confusing as to which account you are in. One of my tricks to… Read More »Chrome: Change Theme for Each Account
I had a request by a premium member that they had one Google Sheets spreadsheet with a tab per teacher to keep track of the daily contacts with students and parents. She wanted to add a column each day with the date to each of the sheets for the spreadsheet. Authorize the Add-on After making a copy of the spreadsheet… Read More »Push a Column to Each Sheet in Google Sheets
In order to add an audio file to a Google Slides you need an MP3 in Google Drive. How do you make an MP3??? ONE way is Screencastify. Record Your Screen An MP3 is audio only. Use the Screencastify Chrome extension to record. Do not worry about what is being recorded with video, that will be stripped. Download After doing… Read More »Google Slides: Add Audio Recording with @screencastify
When teaching remotely, or just when teaching with digital tools, using Google Slides is a giant help! Students can create muti-media representations of their work and since Google Slides are collaborative you can see their work in real time. Now you want to be able to update and add to the student slides… my Add-on can help. Makes a folder… Read More »FREE!! Make a Pile of Google Slides for Students and Update Them
Many schools are starting remotely in the Fall and this is going to necessitate getting some materials into Google Forms. Google Forms is an amazing way to have students submit their work digitally. You do not have to open up individual PDF’s and hope that the screen orientation isn’t rotated. Instead you can gloriously see all student work in one… Read More »MAGICALLY go Remote with Automagical Forms
Google Keep is a application that allows you to create notes and checklists. It integrates with Google Docs making it an easy way to add feedback to student work. Create a Checklist When you go to keep.google.com you want to click on where it says “Take a note.” However, to create checkboxes in your note, click on the checkbox icon… Read More »Give Checklist Feedback in Google Docs using Google Keep
As a teacher we do things at least 30 times, and as a high school teacher over 100 times! There are so many things that we have to do per student. Knowing how to code Google Apps Script allows you to answer the question “Why can’t I do ___ with Google Docs?” You might be able to, if you code… Read More »Kick Your Teaching Efficiency Up a Notch with Google Apps Script
Google Sites is a quick and easy way to make a website. In 2020 a ton of new features were added (including the ability to create a site from a Template). One thing I use a lot when typing text is SHIFT ENTER. What happens when you press Enter in a Google Doc (and other places) is it creates a… Read More »Google Sites: Try Shift Enter When Typing
My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her. She made a list of checkboxes… Read More »Count Up Checkboxes in Google Sheets
In Google Slides or Google Drawing you can create a Venn Diagram by creating 2 circles and adjusting the transparency of the fill color. Perfect Circles The trick to a perfect circle is to hold down the Shift key when you draw the circle. Fill Color – Reduce Opacity To make your fill on your circle more transparent, first click… Read More »Google Slides: Create a Venn Diagram
“This didn’t work for me.” “It wont’ let me login.” “I can not edit this.” “I can not open this file” Use Chrome logins NOT add accounts. This is the number one reason you have issues. I think I respond more often than not to someone having an issue with “You are having account conflicts.” If when you click on… Read More »Google: Solve the Source of All Your Problems – Use Chrome Logins
If you create a Google Slides template and want to share it with others you can modify the end of the Slides URL to turn your slides into a template. /template/preview Change the Sharing Permissions By default the sharing permissions on any file is private. You can not share templates of private files. Make sure you change the sharing settings… Read More »Google Slides: Share Templates
Upgrade your PDF by making it a Google Form. Former math teacher John McGowan, the creator of g(Math), EquatIO, Form Creator and more has developed a Drive Add-on Automagical Forms on to take your PDF and turn it into a Google Form!! THIS WILL SAVE YOU HOURS!! First install the Add-on from the webstore. This will get you the free… Read More »Automagically PDF Worksheet to Google Form
Stay Connected with Google Voice One of the keys to distance learning is being present. You can not just throw things online and walk away. If students are unable to come to school they will likely have questions. Email and chat are one of several ways for students to reach out and connect. However, being available by phone can alleviate… Read More »Prepare with a Google Voice Number
Try Coding Google Apps Script You can code Google Apps. Google Docs, Sheets, Slides, Forms, etc… (Currently Google new Google Sites you can not). Like the other Google Apps products you can use dot new to quickly make a new file of the product. Once you’re in the code editor you will see a function defaulted to being named myFunction().… Read More »script.new TRY IT
