You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.

Notes

  • Make a copy of the google sheet
  • Setup your roster
  • Grab the ID or Key from one of the handouts you want to copy for your class (make sure it is viewable to all)
  • Paste the ID into the variables are, set the naming convention and the name of the folder you want all the handouts to go into
  • Press "Generate Handouts" and check your docs list to make sure it worked! 

NOTE - unfortunately, this script doesn't yet work for Google Presentations or Drawings.  It will only work for sheets or docs.  This is a known issue, and I bet that it is resolved soon.  

 

Useful links

Handout Generator

Comments

davidrothauser
davidrothauser12 weeks 4 days ago

A slight modification...

Hi Evan,

I love this tool. I made a slight modification to the spreadsheet to make things easier for people who have a) multiple classes and b) who want to differentiate the handouts based on a given criteria. I added a sheet called "Class Lists" where a teacher can store his/her class lists - this data could be pushed from another master doc somewhere. On the sheet "Roster" I modified cells A4 and B4 to have data validation - they have a little pulldown menu with only select values. Cell A6 has a conditional formula in it that says only to display the class lists with the criteria selected. 

I'm not sure how to set up the formula in A6 to select all values - like if a teacher wants to make a handout for all of the possible values in A4. 

Here's a link: https://docs.google.com/spreadsheet/ccc?key=0AkYl7o1TUOnEdEo2UmgyY3hGa2t5b3FxUVhMTEhVZFE#gid=0

Thanks for making this!

David

eodonnell
eodonnell12 weeks 4 days ago

Yes - definitely needed

Thanks David - this is definately needed.  I added your improvements to the linked file on this hack.  I changed your formula slightly to allow for a blank status cell to filter by so you can generate handouts for a whole class or use the status filter as you said for differentiation.  

Handout Generator
eodonnell's picture
Featured
Published: 02/20/12
License: Creative Commons Attribution-NonCommercial 3.0 Unported
Views: 1,169
Google Apps for EDU
Google Apps for EDU, Google Apps Script, handout

Problem of practice

Creating google templates, instructing students to share appropriately and then organizing all the shared files correctly can be a time-consuming task.

Solution

This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.

Cast your vote

5
Recommend

Tweet this

Post to Twitter Post to Twitter

Browse other items with similar tags

DIY Student Information System: Module 1, "The Lateness Zapper"
This introductory module provides what you need to start building the modular and lightweight data system of your dreams. The first installment is a "Lateness Zapper" that automates logging, communications, and reporting on student lateness.
Recommended by 1 educator(s).
Embed a User-Specific Progress Chart in Your Google Course Site
This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 1 educator(s).
Simple shared assessment tracker
This is an attempt to create a simple tool that a team of teachers could use to track indicator-level data on shared assessments. It's low-stakes, hopefully approachable and can be customized to fit the team's needs.
Recommended by 1 educator(s).
rePortlet Script: Individualized data reports in a Google Sites Page
The Reportlet Script, written in Google Apps Script, serves up easily-templated tabular reports that can include custom data, images, and charts keyed to the logged in user. Power users get a dropdown to allow viewing of any report.
Recommended by 1 educator(s).
Student Goal Setting Platform
Using a script stolen from another project and a student template, this platform will allow a teacher to enter in their classroom roster, hit a button and automatically create goal setting sheets for their class and monitor their students' progress!
Recommended by 1 educator(s).
Close the Communications Loop with a Forms-Driven Email and Tracking System
The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 1 educator(s).
Script Allows a Teacher to Add a Single Assignment (Event) to Multiple Google Calendars
You can embed this script as a gadget into your Google Site, and then use it to create the same event on multiple Google calendars at the same time. See the link below this video to copy and paste the script.
Recommended by 1 educator(s).