Paperless Is Not A Pedagogy
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…
I have an Add-on (NOW available in the marketplace) to quickly create a unique bingo board for each student. Use the Bingo template to create a unique choice board per student. Tell students to choose 5 in a row from the choice board to make Bingo! The Add-on randomizes your choices for each student and…
Make a table of contents for a folder in Google Drive. Make it easier to organize and make notes about what is in your folder. Use this for your own use or when you are sharing with friends and colleagues.
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…
Want to print out a bunch of student work from Google Drive? Try PDF my Folder by Alice Keeler to quickly download as PDF’s and print!
TemplateTab Copies a Graphic Organizer Per Student TemplateTab is one of the first things I ever coded, and I think one of the best things I’ve coded. Special thanks to Alicia Williams and John McGowan for helping me get this published to the G Suite Marketplace. All Students in the Same Spreadsheet If you have…
Update Student Slides with First Slide When you make a copy of a document for every student it is slow to open and give feedback. It just takes time for digital documents to load, especially if the internet is not super fast. First Slide allows you to give feedback without opening up any student slides….
Create Badges in Google Slides I definitely have a coding addiction. For fun I created an Add-on for Google Slides that will make gamification badges for you. Template alicekeeler.com/makebadges This makes is fast and easy to add digital stickers or badges to student work. Make a copy of the template and wait maybe a minute…
Push to Slides If you would like to assign each student a different prompt or question I have coded an Add-on for Google Slides that will allow you to take a list of prompts, randomize them, and push them to an individual Google Slides per student. Template alicekeeler.com/pushtoslides After copying the template, make a list…
Create a Branching Google Form Design your Google Forms to provide immediate feedback by utilizing branching options. Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be…
G Suite Admin – Bulk User Removal I am the apps admin on my G Suite EDU domain. For a training I had created 100 temporary accounts and then wanted to delete them after the training. Doing a Google Search the results show me how to tediously remove one user at a time. Unacceptable. It…
Updating One Google Sheets Spreadsheet From Another You have more than one spreadsheet of data. You need the information from one spreadsheet to interact with the data in another spreadsheet. There are 2 ways to do this in Google Sheets. Copying and pasting from one spreadsheet to another has the problem that if the data…
You can code!! Step 1: what app are you using? Jeff says “Slides!” Great! You start with SlidesApp and press period. Coding is Multiple Choice! In Google Slides go to the Tools menu and choose Script Editor. Once in there, within the curly braces of the function type SlidesApp Press period. A multiple choice list…
Connect 4 in Google Sheets Chris Brownell (and Sunil Singh)’s book Math Recess is a bad influence on me 🙂 In the book there is a list of games you can play to have fun with math. If I want to play these games asynchronously with someone who isn’t physically with me, Google Sheets is…
Play Yahtzee in Google Sheets! Created by Alice Keeler
You must be logged in to post a comment.