Link Two Google Docs for Translating

An interesting Stack Overflow question popped up about auto-translating one document into another when edits are made. Most Google services have things called "triggers" which run functions after some kind of event - opening the doc, making a change, etc. A Google Doc does not have access to the onEdit trigger, so there is noRead More

Building a Custom Web App from Google Sheets

I'm working with a group of teachers to run a mock election this week. They had a basic Form set up for students to vote along with two other "pie-in-the-sky" ideas: Assign electoral votes by homeroom to simulate the Electoral College. Have a live-update view of the election teachers could show in their classrooms. ElectoralRead More

Push Announcements With a Chrome Extension

Patrick Donovan put out a tweet the other day with a screenshot to a Chrome extension he had just put together. It caught my attention and led to this post because it's a really, really good idea. Got my Chrome Extension created, now to refine and then publish to our organization. Thank you @curt_truc #COL16Read More

An Easier Way to Get Plain Text

Our school is moving to more active use of Lexile scores for reading selections. The Lexile website has a nice analytic tool which allows you to upload text (after you create a user account) for analysis. The pain in this process is that A) you can only do it from the Lexile.com website, and B)Read More

My Robot Will Fight Your Robot

Spam on Twitter feels like an all-time high right now. Twitter itself is woefully horrible at taking reports of abuse and spamming and all a user can do is use the completely un-fulfilling "Report Tweet" option to block the user. When they spam hashtags, companies create robots faster than you can report. Twitter spam isRead More

Quickly Make Bulletin Board Words

Marc Seigel is always doing great things in his classroom and he tweeted out a great picture of a bulletin board that now lives at the front of his room. My new bulletin board at the front of the #roomofawesome No more boring announcement board. Now positive messages are what the students will see everyRead More

More Scripts to Make Life Easier

It's been an intense week of teaching, church band practice, and Google Apps Scripting. I'm really focusing this year on using the computer to do what it does well so I can focus on doing my job better. In particular, I'm using the desktop to do repetitive, marginal jobs as efficiently as possible. This week,Read More

Getting Random Post Suggestions from Custom Google Search Engines

Update 3/31 - After more tinkering, I've changed the code to be more stable with any changes Google makes in the future. Code snippets are up to date and irrelevant instructions are now struck out. You can create a custom Google search engine for your website (or group of websites) which can be very handyRead More