Need some Google form advice

[Anne Truger]

Can you do this with a Google Form? I have been asked to assist with this project but I am feeling out of my depth here...any suggestions?

I am creating a google docs form, but my ultimate goal is to have one form that feeds into a separate spreadsheet for each student (and a single master spreadsheet).  I would like to set this up to collect as much of the data in a graph-able format as possible. From there I want to be able to instruct each staff member to set up subscriptions to the individual student spreadsheets so that they are automatically notified any time an incident has been entered. 

Thanks in advance!
~Anne

[Curts, Eric]

Anne,

This can be done, but the exact setup may depend on the details about your project.  For example, does each student have to have their own workbook?  Or is it ok for each to just be a different sheet in the main workbook?  Both can work.

See the link below for an example where the students are in the same workbook.  The first sheet is where the form data goes.  Each sheet after that is one sheet per student.  I use the QUERY formula to pull in only the data for each student to their specific sheet.

https://docs.google.com/spreadsheet/ccc?key=0AtNBY_GGSzrPdGd6ZVZWTWQ1eWhGTzhSWTJtRjAzMXc

Anyway, if you go this route, then the teachers would just need to:

1. Go to the sheet for the student they need
2. Click "Tools"
3. Click "Notification Riles..."
4. Check "Anything on this sheet is changed"
5. Check "Email right away"

This would send them an email when something updates on the sheet for that specific student.

Of course, a single workbook can only have 200 sheets, so this approach would only work for up to 199 students.  If you had more than that you would have to go with a different workbook for each student, or would have to use more than one form.

Let me know if you have questions about this, or have more details about what you need.

Eric

* Eric Curts

* Technology Director, North Canton City Schools

* 525 - 7th St NE, North Canton, OH 44720

* te...@northcantonschools.org

* (330) 497-5600 x377, FAX (330) 497-5618

*  Google+ Profile - Click here

*  Follow me on Twitter - http://twitter.com/ericcurts

*  Find me on Facebook - http://www.facebook.com/ericcurts

* http://www.ericcurts.com

* http://www.northcantonschools.org

* http://www.ohiotreasurechest.org

* http://www.appsusergroup.org

* http://www.thestateoftech.org

~Anne

--
You received this message because you are subscribed to the Google
Groups "Google Apps K12 Technical Forum" group.
To post to this group, send email to k12ap...@googlegroups.com
To unsubscribe from this group, send email to
k12appstech...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/k12appstech?hl=en?hl=en

[Gail Markson]

How does the form designate which student the inputted info is for. For example, if one wanted students to input their service hours. Is there a way for them to input hrs as they accumulate them and have it add up and appear in their sheet?

 

Mrs. Gail Markson

Director of Technology

Eleanor Kolitz Academy

12500 NW Military Hwy, Suite 150

San Antonio, TX 78231

www.eka-sa.org

 

CONFIDENTIALITY NOTICE: The documents accompanying this email transmission contain confidential information belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of these documents is strictly prohibited. If you have received this email in error, please notify the sender immediately to arrange for return of these documents.Notice of Non-Discrimination
Eleanor Kolitz Academy admits qualified students of any race, color, gender, national or ethnic origin to all the rights, privileges, programs, and activities generally accorded or made available to students at the School.  It does not discriminate on the basis of race, color, gender, national or ethnic origin in the administration of its educational policies, admissions policies, athletic and other school administered programs