Sample Forms (and Spreadsheets) Used By Administrators:
Activity 1: How might Google Forms be valuable to an educator? In a small group, create a form to illustrate your answer. Activity 2: Create a self-grading quiz!Publish the file and add the lead learner as a collaborator. Links to the files will be added below. One member of each small group will present the file to the large group. In a small group, create a three question quiz using a Google Form. Solicit sample answers from other participants. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.) Fill Down so that the IF formulas you've written can "grade" all the responses at once! Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades! Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below. Activity 3: Forms for Teacher Observation or Data Collection Create a form for collecting data. Examples include:
Send the "live form" link to colleagues so they can fill out your form. Share the results with colleagues or publish them as a web page. Optional: Create (and publish) charts of the results. Add the lead learner as a collaborator. One member of each small group will present the form to the large group. More Sample Uses of Google Docs Forms (for Administrators) Sample Forms (and Spreadsheets) Used By Administrators:
Resources for Administrators Using Google Forms (from GCT Jason Borgen at Portical.org):
Additional GCT Resources for Administrators:
Even More Ideas...
Link Library: How to Make a Self Calculating Survey - Collete Cassinelli 10 Google Forms Ideas for the classroom - provides template copies for each form by Tom Barrett How to Create a Self Grading Quiz Using Google Forms Excellent Google Form Templates for Teachers and Administrators By Youssef Elias Google Form Templates for Administrators by Todd Roth | Kentucky Standards
KY Teacher Standard 2.3.
KY Teacher Standard 3.2. KY Teacher Standard 4.2 KY Teacher Standard 5.3 KY Teacher Standard 6.1 KY Teacher Standard 6.4
KY Teacher Standard 8.1
KY Teacher Standard 8.2
KY Teacher Standard 8.4
NETS-A
NETS-A 1.a
NETS-A 1.b
NETS-A 2.b
NETS-A 2.c
NETS-A 2.d
NETS-A 3.b
NETS-A 3.c
NETS-A 4.b
NETS-A 5.a
|