This is outstanding and takes care of exactly what our issue was, and even creates a folder.  Thanks so much!

I showed this to someone who also had a great google form that the guys at Google NY suggested.  It basically is a form for students to fill out that will act as a type of cover letter or orgainizer for each document a student has.  If each student fills this out and links their doc to it, it will provide the teacher with one spreadsheet listing all students and assignments and then the link to each assignment (doc), which will allow for great indexing and searching/sorting capabilities.  Can this be somehow included in the generator hack?  Perhaps make another version of the hack with this included.  

I've seen it in place, and what is was was a spreadsheet of 100 students with all the assignmetns over the semester, so think of 300 rows, each with student name, assignment name, unit name, and link to the document.  This way, you have full list of all work, without having to go into each folder to find and search for them.  Think of it as a huge table of contents for all student work.  You could then search by student name and see all of that students work for the quarter, search by assignment, unit, etc.  Spreadsheet will allow you to sort by any criteria you want, and each row will have a cell where the url to the doc is so that you click on that and you go right to their document.

Basicly, is ther any way they can be combined, or have the generator include a script that will insert into a designated spreadsheet info similar to what is in the form, and automatically past the url to the document.  I guess we are looking at a script to create an Index Spreadsheet with the student name, period, assignment and URL.

Here is the spreadsheet to take a look at

https://docs.google.com/spreadsheet/ccc?key=0Ansn43R3rG4pdFBzMWg0ZTBtUzFJcC1uTzhja2tZN1E#gid=0

What do you think?  PS: Sorry if explanation was too long winded.  

Thanks

Great hack. Can this be done for docs? Not sure how the field entry boxes would work.

Our problem is that we want to find an easy way to make a document and have each student get their own individual editable copy for them to fill in, without having to make a copy of the form for each student and email it separately for each. That would be 100 copies and 100 sharing emails. Is there a script or hack for this already?

Evan,

I forwarded your hack to my co-facilitators of our coaching initiative. Your solution begins to answer a huge question we've been struggling with, which is how to scale the program up from a few students per teacher to a full advisory class per teacher.

Great work!

Maria Clausen 

Hi Evan,

I'm so excited by what you've created. I made a copy of your spreadsheets and set them up for my advisory. I'm thinking about how I could use this with them to have set weekly goals. I'm curious about columns J and K. It sounded like you set things up so that what the teacher types in there gets automatically pushed to the student's spreadsheet. Is that the case? When I type in those columns, my text immediately disappears and does not end up on the students' spreadsheet. It looks like the formula in columns J and K are part of the importrange formula from column D. Is this doing what it's supposed to?

Thanks,

David

Super exciting to see us building off one another's work!  This is a fantastic Evan.  Do you have a school or teacher to work with on trying and refining this setup?  This looks to be a very promising prototype that could probably use some testing.  Schools like Olympus Academy doing a full blended model could really use something like this.  Let me know if you want to try to connect with any of our teachers.