GForms+&+Spreadsheets+201

Objectives
 * Create
 * Edit
 * Charts & Equations
 * Share & Publish
 * Scripts

Scenario

You need to create a climate survey to collect data on perceptions of your school's learning environment. You want to use a Google Form to collect the data and Google Spreadsheets to analyze it. You must:

1 - Download this example survey (click here). 2 - Create a Google Form to collect the same demographic information. 3 - Then choose 5 questions for collecting the survey data. 4 - After creating the GForm, fill out your form and submit it with random data 5 times (so we have data to analyze). 5 - In the GSpreadsheet, deselect accepting responses to close your form. 6 - Analyze your data by averaging student scores for each of your 5 questions. 7 - Create a chart with the averages.