Monday, 31 March 2014

Interesting Ways to Use Google Forms

Interesting Ways to Use Google Forms

1. Gather information from parents

2. Get to know you 

3. Reading Record

4. Place orders for fundraiser

5. Exit Ticket

6. Quiz/Test

7. Feedback from parents

8. Spelling Test

9. Book Review

10. Emotion Graph

11. Rubric

12. Self Assessment for Learning Skills

13. Contact Information

14. Choose your own Adventure Story

15. Making Inferences

16. Observations

17. Incident Form

LGBTQ Workshop

Resources from the workshop I attended today on LGBTQ Awareness:
Presented by EGALE Canada

LGBTQ stands for Lesbian, Gay, Bisexual, Transgender, Transsexual, Two-Spirit, Queer and Questioning People

Questions to ask yourself:

1. What makes school unsafe for LGBTQ students, staff and parents?
2. How can I help to make a LGBTQ safer school?

Great Website for Staff Development

Online Resources -Go to the Educators Page - includes lesson plans, you can search books to use in the classroom or purchase for the library

Genderbread Person - a visual to help explain gender identity, expression and sex

What ways can we create LGBTQ safer schools pro-actively:

1. Break cycles of silence and stigma
2. Address and effectively intervene in harassment
3. Increase visibility of LGBTQ
3. Challenge heterosexism and cissexism in our schools.

Planning a community!

What better way to bring the curriculum to live then with a visit from an expert!

 My grade 3 class has been exploring land use categories and creating the ideal community for Social Studies. 

On an whim, I emailed the planning department with the County of Wellington with the hope that they may have some resources I could use in the classroom.

I was thrilled when I received an email back with a positive response! To the students delight we will be hosting guest speakers from the County of Wellington's Planning and Development Department. Talk about making learning authentic.

Now we must prepare appropriate thought provoking questions to ask our guests!

Reflection: Take a risk, send an email who knows what may come out of it!


Flubaroo is an add on that you can use with google forms to help you grade a multiple choice or fill in the blank test. 

More than just a grading tool, Flubaroo also:
  • Computes average assignment score.
  • Computes average score per question, and flags low-scoring questions.
  • Shows you a grade distribution graph.
  • Gives you the option to email each student their grade, and an answer key.
  • Lets you send individualized feedback to each student.

Steps to Use Flubaroo:

1. Create an assignment

Enter the questions you want to ask
Choose new spreadsheet as the destination

View Live Form and create the answer key by completing the form with the correct answers. (Be sure to label the answer key in the name field so you will be able to find it later!)

2. Send the form out to your class

3. Open the responses (spreadsheet) go to Tools - Script Gallery - Search Flubaroo and click add. You will have to authorize Flubaroo (Click Accept)

4. Now you should see a new tab "Flubaroo" 
Go to Grade assignment
Flubaroo will ask you a few questions, such as:
  • If any questions should not be graded.
  • Which questions are for the purpose of student identification (e.g. name, student id, email).
  • Which submission should be used as the answer key.
Once answered, Flubaroo will grade your assignment. This process should take less than a minute. 

The grades will show up in a new spreadsheet

5. You can now email each student their grades, view a summary report or regrade the assignment

Data Validation

What is Data Validation?

It can be very frustrating if you are collecting information from numerous people using a google form and the information you collect is inaccurate. 

By using Data Validation in a google form you can ensure that the respondent is including the correct information in the responses.

For example: If you want to collect email addresses from your respondents: add a text item (data validation only works with text), click on data validation, choose text, email address and type in an error message (works well to use an example here) If the respondent does not put in a correct email address they will receive an error message.

Another option for using data validation is to limit the number of words (or have a requirement for the number of words) a student can use when responding to a question:

 Number Less than 15 - if a student types over 15 words they will get an error message!

See Video for step by step instructions:

See Molly Harder's post on her blog titled:-An Error Message! for more ways to use data validation. 

How to Video: Google Forms Basics

Here is a video I found by Joe Wood that helps teach you the basics for creating a google form.

Monday, 24 March 2014

Why Use Google Forms?

5 Reasons to use Google Forms

1. Forms are mobile friendly

2. You can get email notification of results
To do it, change your response method to be a spreadsheet by clicking on “Choose Response Method” in the toolbar. Then click on “View Responses” to see the spreadsheet. Choose Tools > Notification Rules and pick whether you’d like immediate or daily batch notifications.

Google Forms Reasons notification rules   5 Awesome Reasons To Use Google Forms

3. Page Direction

You have the ability to direct respondents to questions based on their answers. 

4. Results can go directly into a shareable spreadsheet

5. It is free, easy to use and students are engaged!

6. Since students are online they can use read/write! Think of the functionality for young students or as an accommodation for older students!

Video on how to pre-populate a list in google form. The video shows how to copy and paste the states into a list - this would work well for provinces and territories or copying a class list of student names!

Saturday, 22 March 2014

Adding a Video to Google Forms

Step by Step instructions to add a video in google forms

Click image to view full size. 
Click image to view full size. 

Data verification AKA the "are you human?" test.

Here is an example of an assessment I used for a grade 2/3 class for multimedia

New Spin on Bedtime

Story Online

Tonight my daugther and I listened to Guji Guji read by Robert Guillaume for our bed time story. Lots of books to choose from read by well known actors/actresses. Check out Storyline Online

Stop Motion

Stop Motion Studio App  


I used this app with my grade 2/3 class to create claymations. My students were so engaged from designing their story board to creating their characters to filming! Connections to the curriculum: multimedia and art.

Here is the assessment I used: Multimedia Assessment

Inserting a Picture in Google Form

How to Insert a Picture in Google Form:

There are two ways to enter an image into google forms: 

Go to Add Item and click on the arrow to get more options and then choose image

Imagine the possibilities:

You could add a picture for a quick diagnostic assessment like the one below and ask:

  What can you tell me about this picture?

You can add a QR code 

Example of a Form with an Image

New Book on My Must Read List

Front Cover

A proven program for enhancing students' thinking and comprehension abilities
Visible Thinking is a research-based approach to teaching thinking, begun at Harvard's Project Zero, that develops students' thinking dispositions, while at the same time deepening their understanding of the topics they study.? Rather than a set of fixed lessons, Visible Thinking is a varied collection of practices, including thinking routines?small sets of questions or a short sequence of steps?as well as the documentation of student thinking.?Using this process thinking becomes visible as the students'?different viewpoints are expressed, documented, discussed and reflected upon.
  • Helps direct student thinking and structure classroom discussion
  • Can be applied with students at all grade levels and in all content areas
  • Includes easy-to-implement classroom strategies
The book also comes with a DVD of video clips featuring Visible Thinking in practice in different classrooms.