Google Classroom: Guardians Who Need a Google Account – Teacher Tech Great information on setting up parents to access their child’s information on Google Classroom. Twitter tips for new users Some basic information for those teachers just starting out with Twitter. Highlight rows in Google Sheets with conditional formatting Go beyond highlighting cells and highlight…
As you probably know, Google Drive is far more than a place to store files online. It also includes a suite of versatile creation tools, many of which perform the same functions as the ones we use in other spaces. These include Google Docs, a word processing program that behaves similarly to Microsoft Word, Google Slides, a presentation program similar…
This is part 1 of 13 things to do before the first day of school For a lot of scenarios, creating a Google Form to collect information works well. But it could also be overkill to create a form just to collect a student’s username from a web service, or to have a student select…
Flippity.net is an awesome website that integrates with Google Sheets. There are 8 tools that you can use, Flashcards, Quiz Show, Spelling Words, MadLibs, Random Name Picker, Badge Tracker, Progress Indicator and Certificate Quiz. Each tool has a link to a demo page so you can see it in action, and a link to the…
Create Random Assignments is a Google Apps script that takes a spreadsheet of questions and student names and creates random assignments. Once added to Google Chrome and you’ve authorized the script, your ready to get started! The author has a complete help sheet available to get you started with using the script.
Create an mp3 of translated text with Sound of Text Use this website to create short snippets of audio of translated text. Backing up your Google account with Google Takeout How to back up your Google account. ⓔ Highlight the minimum and maximum cell in a Google Sheet column An oldie but still a goody,…
I’ve been playing around with gamifying my classroom this semester. After looking at Classcraft I decided I wanted something a little simpler, so I put together a Google Sheet to keep track of XP, AP, and HP. The problem came when I needed to add or subtract a stat from a student. Entering the data…
Exploring Graphing with Kindergarten using Google Sheets Use this Google Sheets template with Kindergarteners to explore graphing. Students use physical manipulatives to count and then represent the number in a graph. What an awesome collection of templates to use with Kindergarteners in Google Sheets! These could be used at the higher grade levels too. Do…
If you use Google Forms to collect entry or exit tickets, or other information from students, a quick and fast way to offer custom feedback is to use the formMule add-on. I posted a how-to before on using formMule, and you can follow that page with a couple of changes. By using formMule, you can…
There have been several times that I needed to send out a customized email to students. I could create the email, and make my changes for each student, but there’s a better way, Form-Mule! For this example, I created a spreadsheet with the student’s name, email address, and when they have a meeting scheduled. Under…