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….
Category: Apps Advanced
Push a Column to Each Sheet in Google Sheets
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…
Google Slides: Add Audio Recording with @screencastify
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…
FREE!! Make a Pile of Google Slides for Students and Update Them
NOTE: I have rolled the features of pile slides into First Slide. 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…
MAGICALLY go Remote with Automagical Forms
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…
Give Checklist Feedback in Google Docs using Google Keep
Keep a checklist of feedback in a Google Keep note and easily add them to a student’s Google Doc for faster feedback. Checklist feedback helps students know what they did and did not do for the assignment requirements.
Kick Your Teaching Efficiency Up a Notch with Google Apps Script
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…
Google Sites: Try Shift Enter When Typing
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…
Count Up Checkboxes in Google Sheets
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…
Google Slides: Create a Venn Diagram
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…
Google: Solve the Source of All Your Problems – Use Chrome Logins
“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.”…
Google Slides: Share Templates
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…
Automagically PDF Worksheet to Google Form
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…
Prepare with a Google Voice Number
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…
script.new TRY IT
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…
You must be logged in to post a comment.