Google+Forms

=** With **= =** Google Forms **= ||=  ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||=   ||
 * = [[image:forms-64.png]] ||=  ||=   ||= =** Collect and Organize Information **=

**What are Google Forms?**

 * Part of the Google suite of products
 * Able to create electronic forms to collect various types of data
 * Data is collected directly into a Google spreadsheet to make it easy to analyze the data

**Examples**
OneWord... Create a Wordle from the data collected
 * Simple Example:**

Book Survey Spelling Test Our Map - Create a map using Google Forms and BatchGeo
 * Other Examples:**

**Ways to create Forms**
Create a new Form from scratch Create a Form using a Template (Examples from Google) Create a Form from a Spreadsheet

**Let's get started by creating a Google Account**
Sign up for a Google Account

Embed Forms
This link will take you to another wiki (website) for you to embed your forms.

__**Shortening URLs**__
goo.gl- Example: http://goo.gl/Xb8JB (//**All About Us**// Form) Also creates a QR code for the link!

bit.ly

tinyurl

Google Formulas to use with Google Forms
At times, you may want your data to be displayed vertically instead of horizontally. If that is the case, you will want to use the Transpose Formula below.

//**Transpose Formula**// Create a new sheet from the Insert Menu > New Sheet Highlight cell A1 and enter in the following formula:
 * =Transpose(Sheet1!A:L)**
 * NOTE**: If you named the Sheet1, you will substitute the sheet name for Sheet1. Adjust A:L to represent the range of columns. If you do not want the timestamp to show, enter in B:L

//**Array Formula**// To make a duplicate of your data on Sheet 1, use this Array Forumla. You may want to make a copy if you want to experiment with creating charts, etc. That way your original data stays in tact.
 * =ArrayFormula(Sheet1!A:H)**
 * NOTE**: If you named Sheet1, you will substitute the sheet name for Sheet1 in the formula. Adjust the A:H to represent the range of columns.

Try this formula if you would like to view a single record at a time. //**Indirect Formula**// =INDIRECT("Sheet1!C"& B$3 )

&B$3 is the cell reference for the record number on your current sheet.
 * NOTE**: If you named Sheet1, you will substitute the sheet name for Sheet1 in the formula. C is referencing the column of data that you want to display.

Graded Quiz Example Using the IF Conditional Formula =IF(logical test,value if True,value if False) Example: =IF(B2=4,1,0) If the cell B2 is equal to 4, then the student will receive 1 point, if B2 is not equal to 4, the student will receive a zero

Mobile Device Apps
Forms App for iPad

Forms for iPhone

Resources
Edutraining - Google Forms Google Apps in the Classroom - Forms

media type="custom" key="18843894"