Create a List of Your Assignments in Google Classroom Every year is a new opportunity to be better than you were last year. This is one of the advantages to teaching, unlike any other profession we get a fresh start every year. The kids from last year are not the same as the kids from…
Category: Apps Script
Save Hours: Pull The Tables
Pull Student Responses From a Google Doc I’ve said many times, I would rather hit myself in the head with a brick than open 30 Google Docs (or Slides, or Sheets…). My rule of thumb is to only assign individual student work that I have to open 20% of the time or less. For those…
5 Basics to Know for Coding
Coding with Google Apps Script As a G Suite user you may find yourself wishing… “Why can’t I …. in Google Docs/Sheets/Forms/Slides?” You can if you know how to code! Go to script.google.com to get started with standalone coding or in Docs, Sheets, or Slides use the Tools menu and choose “Script Editor.” This allows…
1st Graders Making a Spreadsheet
Have Students Respond in a Spreadsheet This morning I woke up to see this tweet “What about first graders responding to a question in graph format through Google classroom?” There are many ways to accomplish this but here is a suggestion for how first graders might do this. This gives me some great ideas! What…
Google Sheets: What is On My Google Calendar
Create a List of Your Google Calendar Events Have you ever wanted a simple list of every event on your Google Calendar? Use this Google Sheets template to extract a list of your events. Template alicekeeler.com/listcalendar Calendar ID When you create a copy of the template you will notice a spot in cell B2 on…
Create an Infographics Report Card
Design Your Own Infographics Report Card I saw on Twitter that @teachtech4kids was thinking about creating an Infographics report card. BRILLIANT! I got sucked into the idea immediately and started to create a template to help facilitate that. The problem with a traditional infographic is that you’re going to have to make a copy per student…
Easy! Google Forms: Automatically Sort on Submit
When a Google Form is filled out, you may want to automatically have the new response sort to the top.
Create a Google Calendar Event from Google Forms
Code a Google Calendar Event from Google Forms You might want to send a response from Google Forms™ to Calendar. There is no native way to do this. You are going to need to code some Google Apps Script or use someone’s Apps Script (see below, I have my code for you). Try it Out…
Use Macros in Google Sheets to Cheat Coding
Code Google Apps Script Coding Google Apps Script is not as scary as you think. It’s multiple choice and copy and paste. Starting Nov 19th, 2018 I have an online workshop for “Introduction to Coding with Google Apps Script.” If you are already familiar with Google Apps Script (or have some grit) “Coding Google Forms…
Google Sheets: Code Adding Content to Multiple Tabs
You Can Code Google Sheets Coding Google Apps Script is easier than you think it is. Learning to code can increase your productivity significantly. One thing I frequently code is adding the same piece of information to multiple tabs in a spreadsheet. I like to have all students in one spreadsheet, their name on a…
Google Slides Essay
Google Slides Essay Template A little tongue in cheek I like to say “Don’t use Google Docs.” When we go digital we want to take advantage of what digital offers that paper did not. Oftentimes what we might use a Google Doc for we would really want a Google Form or to use something like…
Teach Students How to Give Peer Feedback
Teach Peer Feedback Peer feedback can be powerful for learning, but only if students do a good job at it. Analyze and critique can be higher critical thinking levels than doing the task in the first place. I guarantee if you ask students to give peer feedback the quality of the feedback will not be…
Google Slides: First Slide – Fast Feedback for a Daily Journal
Read the First Slide Google Slides make a great platform for a daily journal. Have students add a new slide… at the top… each day. If the first slide is their newest journal entry you can try my First Slide Google Slides Add-on. The text boxes from the first slide will be sent to a…
More Google Apps Script Coding
Code More Google Apps Script Google Apps Script allows you to code Google Apps such as Docs, Sheets, Slides, Forms, Maps, Gmail, and more. If you’ve ever wondered “why doesn’t G Suite do…” you probably can if you code it yourself! Google Apps Script is based on JavaScript and is a lot easier than you…
Google Classroom: Spiral Review on the About Tab
Put Your Spiral Review on the About Tab For each lesson each day what is one or two questions you might want to ask a week from now, a month from now, two months from now to keep the learning on the minds of the students? Spiraling is an important technique for making learning sticky;…
You must be logged in to post a comment.