Dear 2015 Sec 1 students,
INTRODUCTION TO GOOGLE FORMS and sheets
In the Pre-School Engagement Activities - Session 2, we briefly encountered Google Forms and Sheets. Here's a recap of the basics you have learnt in Google sheets (from one of the guides I shared in Session 2):
- Google Sheets handles data and make meaning out of them using functions and formulas.
- Like Docs, Sheets are cloud-based and facilitates collaborative editing and commenting.
Furthermore, Forms are tightly integrated with Sheets and data collected from a form can go straight to a sheet.
Let's watch a video introduction to the latest change in Google Sheets.
For session 3, we will start with a video introduction to Google Forms.
For references on specific technical skills involving Google Forms, read the guide created by Eric Curts.
Let do a simple activity in Forms to collate information on the participation of 2015 Sec 1 students on the Pre-School Engagement Activities:
Progress Track Form Activity
- Based on your participation in the activities so far, complete the form below:
2. Access the form data at http://goo.gl/75CD00 and make a copy in your own drive.
3. Using built-in functions such as AVERAGE or COUNTIF, create a summary of responses for the progress.
4. Check out the auto summary of responses generated by Google Forms.
Data Gathering Task
- Each of you will design a survey with at least 3 questions and at most 10 questions.
The questions must revolve around a general theme or hypothesis, eg, Study habits of 2015 Sec 1 SST students, Food that we love etc .
- Create a Google Form and get at least twenty five Sec 1 Students (2015) to respond. Store the responses in a separate spreadsheet with the same name as the form.
- Generate a report of the findings in a one-page Google Doc. The Doc must have at least a few charts and a concluding paragraph. Embed the Google Doc as a post in your blog.