Back to the Basics Using Google Forms Sections

Sections is a Google Forms basic tool which I like using. I view a section as individual pages in a book. It allows the respondent to focus on answering a question with minimal distractions. Don’t be fooled by the simplicity of a section for they also contain a powerful punch. Following is a list of advance methods for applying Google Forms Sections:

  1. Self Study Quiz
  2. Choose your Own Adventure Story
  3. Collecting Specific data depending upon an answer

Let Sphero & Google Slides Support Math

Sphero MIni Angels.jpeg

Today I’m reminiscing upon my time spent in an Elementary School Math Class, and the teaching of angles. I wonder what would happen in this classroom if the students first watched the teacher model drawing acute, obtuse and right angles. Then the students draw their own angles on paper followed by working in a group where a Sphero Mini is remotely controlled  to move along the rays around the vertex of an angle.

I see this as a group center lesson where one student is responsible for capturing a video as another student formed the angle using a tablet device to move the Sphero bot along the drawn pathway. Once the videos are captured the students would share them in a group Google Drive Folder. They would use this folder to insert the videos into a Google Slide deck. One video for each slide in the deck. This is where the student would write their reflections about each angle type.

The teacher might ask questions to jumpstart the students with writing their reflections.

  • Did the Sphero Mini have difficulties navigating the vertex formed by the two line segments or rays?
    • Why or Why not?

NOTE: The students may answer the questions individually or collaborate in a small group.

Once the angle slide deck is completed this may be embedded into a Classroom Maintained Google Site showcasing student creation and exploration.

Linking Reading Log to Spreadsheet

Recently one of my blog readers requested a tutorial about linking a Google Forms Reading Log to a Spreadsheet. They explained they are a new teacher and not quite so savvy. This was a good lesson for me about simplifying my blog posts. If you are a teacher interested in creating a custom Google Forms Reading Log then the following directions are for you.

The first tutorial will explain how to create the Google Form. This will be followed by a tutorial for linking the Google Forms to a spreadsheet for collecting the student’s reading data. You will also learn how to copy a Form for making it possible to build a spreadsheet which includes a tab for each individual student’s data. This may provide individualized longitudinal data supporting the readers growth. It is possible to import group data onto a separate sheet for further study.

Beyond collecting data using a Forms & Sheets Reading log becomes a timesaver for teachers. It puts all the information in one single place making it easier for accessing the information.

Creating a Google Forms Reading Log

NOTE: You will need to make multiple copies of the Form. One Form per Student because this is the only way to link individual student sheets to One Spreadsheet.

Linking a Sheet to Create a Spreadsheet

 

NOTE: The above steps will allow the teacher to view all the students in one spreadsheet

3 Tips for Using Google Forms

As a Google Top Contributor I’m exposed to an abundance of questions from teachers throughout the world. The following tips lists was created due to answering these questions in the Google Drive, Docs and G Suite for Education Help Forums.

1. Sharing a Google Forms…

It always amazes each year hearing the following question. “What am I doing wrong the students are requesting access to the form?”

This happens when the teacher copies and pastes the Google Forms URL instead of using the Send button to share the forms. Please follow the below steps to send a Google Forms.

FORMS DO NOT PASTE URL

Forms Send by Send button

Choose Forms Send Method.gif

2. Collecting Student Names…

What if a student forgets to enter their name? Is there a way to tell who the form belongs to?

If names aren’t collected from within the form there is no way to find out who completed the form. However teachers can prevent this from happening by using one of the two following steps.

  • Auto Collect Student Emails

    • Set the Form to Auto collect email by using the settings tool

Forms Click Settings

Forms Collect Email Addresses

  • Add a required Name Field

    • Add a Short Answer Question Field to the Google Form
    • Type First Name Last Initial in the question area
    • Set the Short Answer Field to Required

Forms Required Name.gif

3. Changing Submission Message…

Is it possible to edit the message a student receives once a Google Forms is submitted?

Yes, the message may be edited to add a mindful message. Please follow the illustrated steps to customize the Google Forms Confirmation message.

Forms Click Settings

Forms Click Presentation

Forms Type Confirmation Message

If you have further Google related questions you’d like answered please leave them in the comment area of this post. I’d be happy to answer them.

 

Ooo! Smashing Google Slides w/Poll Everywhere…

There I was designing a Google workshop about supporting SPED Students. In my workshops I like to include learning activities for both engagement and assessment reason. This was when I discovered the Poll Everywhere Extension for Google Slides. The Poll Everywhere extension transforms a Google Slide into several different group activities. In my workshop I’m going to tryout both the multiple choice polling activity and the cloud generator.

I found Poll Everywhere to be very easy to integrate and use with a Google Slide. One thing to note when installing the you must register for a Poll Everywhere account. As an Educator I chose the “Free” version, and am extremely happy! I like

Using Poll Everywhere w/Google Slides