Oh no! I forgot something in my template before I shared it!

A colleague of mine had to come up with a way to insert student names into a folder full of documents AFTER they had already been shared. She had no interest in opening 100 different documents one at a time, so we came up with a way to do it programmatically.

Multi-Dropdown Datavalidation Creator

This tool came about as a collaboration between Dan Sharpe and myself. He had the idea that there needed to be a better way to create the data validation dropdowns in Google Sheets. Since I was not super familiar with data validation I jumped on the opportunity to learn some new parts of Google Apps Script.

Check it out on the app store, or play around with the code below!

Creating a reading portfolio for the library

How can we better motivate students to read what they get from the library? I often feel like students are only taking out books because they are being forced to by their teachers and librarians. After a discovery discussion with one of the wonderful librarians I work with, I came up with a short list of requirements for a tool.

  1. iPad friendly
  2. Creates an individual folder to store student reading projects
  3. Randomly assign short reading projects.
  4. Provide a method for recommending books and allow students to choose their own books.

The first working prototype of these requirements can be seen here:

The Library Portfolio!

Let me take you through a quick tour of what it does, and how you can use it.

When you first visit the portfolio, you will arrive at a screen similar to above. You will have a missing avatar, your email address will display, and you will get a list of all of the projects in your portfolio folder. This folder is linked directly to your Google drive.

You can see that there was a drawing created in this directory. That can become the student avatar that will show up on the portfolio page. Change the filename to whatever you want, and it will become the name that is displayed also.

Once you have edited this file, you need to ‘Publish to the web..’ before it will display correctly on the portfolio page.

Students have the ability to search the Goodreads database for books of their own choosing. My students can select a book from the library on our campus, then find the book using search and add it to their portfolio using ‘Start Project’.

The real strength of this tool is in recommending books for students who don’t already know what they want. There is a short quiz designed by the elementary librarian that results in 5 suggestions being plucked from a list generated directly by the librarian using Google Forms.

Once you have a recommendation, you can start a new project in the same way that you did with the search feature. Each of these projects generates a separate document in the student’s folder on drive. They contain short activities that can be done with any book that the student selects (we hope!)


This is just the beginning of the project. We have a bunch of other great ideas (and a bunch of bugs to fix in the code!) Please let me know what you think on Twitter! @rheajt

Caption Creator for Google Drive

Creating captions for videos is a great way to create accessibility in your classroom. YouTube has a system that works very well for their videos. However, in Google Drive you don’t have this option. Melissa Oliver wanted a way for her students to write captions as they watched a video. We worked together to come up with this prototype.

Create subtitles for videos in your Drive and save the output into Google Docs to make shared videos more accessible to students.

bit.ly/captioncreatorforgoogledrive (Shout out to Melissa Oliver for the project idea!)

Email Summarizer

Create document summaries from Gmail labels. This is an apps script that I deployed as a web app. It allows you to create a daily trigger that will create a document based on labels in your Gmail. You just need to create a filter that applies a label to incoming emails. bit.ly/emailsummarizer (Thanks to Educator Alexander for the idea in our Google Innovator group!)

Import Data from Achieve3000 into a Google Sheet

I wanted to create a sidebar that would allow me to take one of the CSV files from Achieve 3000 and import the data that I need right into a Google Sheet. I am also going to be using this as part of the #GoogleEduOnAir event on Saturday, December 3rd.

What else do you want to track from A3K? There is a huge range of possibilities I can think of, but I would like to hear how others track data!

How do you track reading logs in your classes?

This is a joint effort between myself and the librarian at my school. She wanted a way to more easily recommend books to students, and this is the first result of our ideas. How can we improve upon the idea? What other tools can we incorporate to make it a more effective tool for engaging young readers?

In the interest of being completely open source, I am posting the code below. However, it is already out of date! The code will change significantly in the next few weeks as we try and get this project built in time to start the second term. Please feel free to give me a show on twitter for help/ideas/feedback.

ClassDojo Attendance Extension UPDATES!

I have made some updates to what my extension can do. The first update is that you no longer need to have the attendance screen open. You ONLY need to be in the class window. So you just need to put in your attendance and save. Then you are good to go!

The more important updates are that you can save your data into a spreadsheet on Google Sheets now!

There is a little bit of a setup that I will explain here.

First you need to create the sheet. This can be a brand new spreadsheet, or just create a new sheet inside an existing spreadsheet. Follow the format below:


Then you need to open the options menu:


Finally, select the spreadsheet with the file picker.


You are now good to go! You can use the ‘Update Spreadsheet’ button inside the extension. This will grab the most current attendance information for the class you have open and post it into the spreadsheet.

This new feature will also grab the student’s current avatar and point information. I added these for a long-term goal of gamify-ing some of the tasks in my classroom. Since my students already love the avatars that they get from ClassDojo, I figured I would be able to use them for a more visual appeal to whatever gamification I add later.

How would you use ClassDojo avatars for gamification?

Google Innovator Dashboard

Add a little more functional information to your new tab pages.

[su_button url=”https://chrome.google.com/webstore/detail/google-innovator-dashboar/hfadelfcjkdfldjajgnlcakfnfecbpcg” target=”blank” style=”flat” background=”#f7294d” color=”#ffffff” size=”8″ wide=”yes” center=”yes” radius=”0″ icon=”icon: calendar-o” text_shadow=”0px 0px 0px #000000″]Install the extension here.[/su_button]