Google+Spreadsheets+&+Forms

Google Spreadsheets and Forms are part of the Google Documents suite of programs. These two __#|cloud__ based programs are also free with a Google account and provide an outstanding way to collect and organize data. Google Forms provides an excellent means to quickly collect and analyze data. With a little extra effort they can also be created to self-grade and email participants analysis of their assessment**: think self correcting formative assessments or quizes that give students instant feedback**. The automatic analysis of __#|survey__ information is amazing and can provide a welcome means for teachers to quickly analyze their student performance.

>
 * Unit Objectives:**
 * **Create** a Google From that can be used in the classroom to collect data in the first month of school
 * **Identify** how Google Forms can be used for educational assessments
 * Required Reading:**
 * Google Apps Education Module 4, Chapter 6: Forms


 * Google Spreadsheet/Form Assignment **** Rubric: **

//All written components should be turned in using a Google Docs link.//

 * || **Not Proficient (3)** || **Proficient (4)** || **Exceeds Proficiency (5)** ||
 * **Classroom Spreadsheet-Form** || * Google Form is not complete, does not function correctly, or is unusable for the first month of school
 * Google Form contains less than four selected response questions and/or no user response question || * Google Form that collects data on a topic of your choice (pre-assessment, learning styles, student interest, etc) that can be used in the first month of school
 * Google Form contains at least four selected response questions (multiple choice type) and one user response question (fill in or multiple choice) || * Google Form that collects data on a __#|topic__ of your choice (pre-assessment, learning styles, student interest, etc) that can be used in the first month of school
 * Google Form contains at least three different type of question types
 * Self-grading form is created using Flubaroo: includes form key and email response ||
 * **Assessment Tool** || * Tool is identified but discussion does not describe how it can be used as an assessment tool within the classroomand/or is not at least one paragraph or two minute video clip || * Describes how Google Form & Spreadsheets can be used as an assessment tool within the classroomin a minimum of one paragraph or a maximum of a two minute video clip
 * Description includes tool, how students will use the tool, and value of using technological to increase student learning || * Describes how Google Form & Spreadsheets can be used as an assessment tool within the classroom in a minimum of one paragraph or a maximum of a two minute video clip
 * Description includes tool, how students will use the tool, and value of using technological tool to increase student learning
 * Created form that can be used to collect/organize assessment data: shared with Rott at drott@ttsd.k12.or.us ||

**Google Spreadsheet & Form Resources:**
Although different programs in Google Docs, Spreadsheets and Forms are very dependent on one another. When a Google Form is created, the data is collected and presented in a Google Spreadsheet. In your list of Google Documents you will not see any Forms but rather the name of your Form as a Spreadsheet file. A Form can be edited after it is initially created by opening the Spreadsheet and selecting "Form" from the menu and "Edit Form" from the drop down menu (took me a bit to figure this out the first time).

media type="youtube" key="IzgaUOW6GIs?rel=0" height="349" width="560"

__Forms__:
Google Forms allow for a large amount of data to be quickly collected and analyzed. Better yet they can be shared, published as a link, or embedded into a website/blog similar to a Google Document. Of all the tools in this course I believe this may be the most efficient time saver.

"How to" Form Resources:

 * Create a Form
 * Managing Form responses
 * View automatic Form summary

Self-Correcting Forms:
With a little manipulating, Google Forms can be set up to automatically correct themselves. This can be accomplished by either setting up your own spreadsheet formulas or using a Google Spreadsheet Script. Scripts are essentially program commands that can be added to a spreadsheet. Once set-up they preform their specific functions. This is an amazing feature of Google Docs and can be a huge time saver. Here's how to create your own self correcting quiz.

media type="youtube" key="QJ60szcUbBE" height="315" width="420"

__Spreadsheets__:
Google Spreadsheets are similar to Microsoft's Excel or Apple's Pages in it's ability to organize and manipulate data. From my experience, is not as user friendly nor have as many options as Excel, but as a free program can be functional for classroom use. Spreadsheets can be used to create self-grading assessments (can be used with or without Google Forms), is an excellent means to collect and organize data for students (science and math in particular), and the ability to create (and publish to the internet) graphs and charts.

How to make a line graph How to make a bar graph How to make a pie graph

"How to" Spreadsheet Resources:

 * Enter data into a spreadsheet
 * Share and collaborate a spreadsheet
 * Managing & formatting a spreadsheet
 * Analyze spreadsheet data
 * Create & publish data & charts

//Create a self grading spreadsheet: Mark Wagner// media type="custom" key="10141785"

//Quick & Easy IF Formulas for Grading Google Spreadsheet: Mark Wagner//

media type="youtube" key="MMce4cdKnv4?rel=0" height="390" width="480"
//Create a Graph in Google Spreadsheets:// media type="youtube" key="t9-ysq1640Q?rel=0" height="390" width="480"

//Advanced Features in Google Spreadsheets// media type="youtube" key="Fa7NxA4ujrw?rel=0" height="390" width="480"

Classroom Forms & Spreadsheet Examples:
//Results in Google Spreadsheet for Google Form classroom homework assignment://

[[image:tech4efficiency/Google_Form_Example.jpeg width="800" height="392" caption="Google Form Example"]]
//Analyze results from previous for Google Form classroom homework assignment://

Google Spreadsheets/Forms Examples:
Dielle's Form

Rachel Dinger

Google Spreadsheets/Forms Assignment:
//Please embed or post a link to your Google Spreadsheet/Form assignment with your name here://

//Dan's Survey//

Carol Rutschman's survey

//[|Kim McDill's Form]// //Michelle's Metric Pretest//

//Karen Scholte PreAssessment//

//Sheri LeDrew's Math Pre-Assessment//

//Kim Brown's Mindset Survey//

//Alison Heath's Author's Purpose Quiz//

//Jessica Blount's Character Quiz//

//Soderquist's 1st grade Ch 4 Science Quiz//

//Matt//

//Johns form//

//[|Harry's form]//

//Alanna//

//Carol Anderson//

//Joyce Woods: 3rd Grade Math Pre-Test//

//[|Jen Cannon Beginning of the year questionnaire]//