Group Leadership Project-CEP 812
Group 2-Ashley Bartkowiak, Jessica Haggerty, Robert LaRocque, James Rolle
Subject: Google Forms
Tool: Slideshare - slides and video
Script done collaboratively here
Storyboard done collaboratively on Google Presentation
1) Creating a Google Form- Bob
2) How to look at the data - Jess
3)Why/How to use it - James
Making the presentation look nice/uniform- Bob (A PowerPoint file)
Recording - Ashley (An MP3 file)Putting it together via SlideShare- Jess
Screen by screen script
Title Screen: Introduction
Google Docs is an online productivity suite that allows users to create professional products (such as documents, spreadsheets, and presentations), share and collaborate in real time, store and organize work, and control who has access to the work. In today’s presentation, we are going to explore Google Forms and their role in an educational setting.
Part 1: Creating a Google Form (LaRocque)
Part 1 Slide 1
Google Forms have many applications in the world of education. Google Forms are very user friendly and can be created in a few easy steps. To begin creating a Google Form, first log into Google Docs by going to docs.google.com . Sign in with your Google ID and password. If you do not have a Google ID, click on the link below the sign in box that says “ create an account now.”
Part 1 Slide 2
On the Google Docs home screen, click the “Create New” button on the left side of the page and choose “Form” from the drop down menu. This will take you to a new screen to begin creating a form.
Part 1 Slide 3
Now you are ready to begin creating a form. The first step is to give the form a title by replacing the “untitled form” with a title of your choosing. In the box directly below the title, you can add any information or directions that will help people fill out the form.
Part 1 Slide 4
The next step is to create questions. The question can be typed in the “Question Title” box and, if you need to include text or clues to help people with the question, you can enter it in the “Help Text” box. There are seven different question types you can choose from. The seven choices include text, paragraph text, multiple choice, check-boxes, choose from a list, scale, and grid. We will explore each question type on the next slide.
Part 1 Slide 5
Here is a brief overview of each question type that you can choose and what it will look like in a Google Form.
*For a text question, the user gives a short answer
*For a paragraph text question, the user gives a longer answer in paragraph form.
*For a multiple choice question, the user selects the best answer from the given choices
*For a check-boxes question, the user selects the answer from a list (this option allows for more than one choice)
*For the choose from a list question, the user selects a response from a drop down menu (only one response is allowed)
*For scale questions, the user gives an opinion using a scale.
*For grid questions,the user provides answers to related questions based on the given scale.
Part 1 Slide 6
To add additional questions to your form, click on the add item button in the upper left hand corner of the screen. You will have a drop down menu appear where you can choose what question type to add.
Once you have completed the form, you have the option to choose a theme. Google has almost 100 different themes to choose from. Click on the Theme button in the upper left hand corner of your screen to choose a new theme.
Par 1 Slide 7
Finally, Google Docs allows you to get responses from people in several different ways: by sending it through e-mail, either embedded in the email, or as a link; by embedding the form in your website or on your wiki; or by posting the link. You can view results in real time in a spreadsheet format or in a summary format with graphs of your results. You also have the option to embed your form in a website or blog and receive notification when someone has completed the form.
Now that you know how to create a Google Form, let’s take a look at how they can be used in an educational setting.
Part 2 Screen 1
You can use Google Forms to create surveys
You can assess prior learning or attitudes.
You can get feedback, or track the progress of work that is done over a longer period.
You can create short quizzes and longer assessments.
and You can collect all related work in one place
In terms of use, forms are flexible and can help in any number of ways where you are trying to collect data or information. They are NOT limited to what we discuss here.
And remember that you can always share the results with colleagues and your students.
Part 2 Screen 2
Let’s take a look at Surveys
Online surveys are a great tool for collecting information in or out of class. Surveys might be about prior knowledge before a unit, or attitudes about a topic during a unit. You might survey students about their use of technology at home and in school, or about what they think of using technology in class.
Note that you can also have students use Google forms to survey people - a lot of people - with little effort beyond creating the survey and inviting others.
Part 2 Screen 3
Forms can also be useful for keeping ongoing track of work done, changing opinions and attitudes, observations, and anything that you want students to report on regularly. Here’s an example of having students self-assess their own work habits every week.
Part 2 Screen 4
and these are the results.
Part 2 Screen 5
In much the same way, you can use forms to keep track of your own information. A form is a great way to jot down what got done in class (and what didn’t get done); what problems arose and what went well. You can even keep track of student performance or your observations about students.
Part 2 screen 6
Because the data is placed neatly and automatically in a spreadsheet, it’s always there for you to review. More about that later.
Part 2 Screen 7
Forms can be used for any type of exercise or assessment. Readings can be placed in the form itself, while other prompts, such as pictures or videos or formulas, can be provided alongside.
The different question types gives you the flexibility to vary how students respond.
Part 2 Screen 8
Displaying the results provides an opportunity for discussion as students can compare and contrast different answers. This works regardless of the subject.
Part 2 Screen 9
Forms are a flexible assessment tool, whether used in class or at home. They can be used to check for understanding, create a short quiz, or for a longer assessment.
Part 2 Screen 10
Or just use them as an answer sheet for work done at home.
Part 2 Screen 11
Forms are also an efficient way to collect all student work on a given assignment in one place. Just create a simple 2-question form, and all the submissions will go into the same spreadsheet for easy review.
Part 3: Analyzing the data (Haggerty)
Part 3 Screen 1
Now we will discuss how to analyze the data from the forms you have created.
Part 3 Screen 2
Once you have finished creating your form and have collected responses, you are ready to start analyzing the data. Keep in mind that you can continue to analyze data as you collect responses, because the results will automatically update.
In the upper right hand corner of the form, click “see responses.” Here you will see two different options to view the data: summary and spreadsheet. Throughout this section we will look at the two different options, the benefits of each, and what to do with the data after it has been analyzed.
Part 3 Screen 3
When you click “summary, “ the information from your responses will look like this. We have circled a few important pieces of information that you will find when opening the summary page. Circled in red is where you can see how many people have responded to the form.
In the summary there is a graphical representation of the answers to each question asked. To the right of the graph, circled in yellow, there is numerical data for each question.
Circled in green is an example of a question that had “other” as one of the options. In the form, the person who is answering can write in an answer when they click “other,” but it is simply represented as a number under the “other” category in the summary.
Part 3 Screen 4
As shown here, each column to a grid question has its own graph and data. For this survey we asked how often in the summer do you: read a book, go swimming, and ride a bike. The people taking the survey could answer using a range of never to every day. As you can see, each activity has a graph and data to represent the answers that were given. After reviewing the spreadsheet option, we will discuss the benefits of looking at the summary view of data.
Part 3 Screen 5
If you go back to the form and click spreadsheet, or click “see complete responses,” you will be taken to a spreadsheet that has all of the responses to your form. On the screen is an example. The questions are written in columns and the responses in rows. The spreadsheet gives a detailed view of all the responses.
Once you created the form, it is then in your Google Documents list as a spreadsheet where the data is collected. If you need to edit the form, go to “form” and click “edit form”
Part 3 Screen 6
Here is an example of another survey done in Google forms where the name of the person taking the survey is one of the questions. This would be a necessary question for most surveys given in the classroom. The spreadsheet view of the data shows the name, date, and time the survey was taken.
Part 3 Screen 7
With the new push in schools toward state standards, professional learning communities, and common assessments, the value placed on data analysis is more prominent than ever before. We’ll go through examples of how both summary and spreadsheet results can be used in different settings to best represent the data.
Part 3 Screen 8
The summary option is great to use in the classroom setting. It is a clear and simple visual representation of the data. The graphs and straightforward numbers allow you to analyze opinions quickly. If you are using the Google form in the classroom as a quiz, you can quickly see the students’ common misconceptions. The other pro for the summary data analysis is that students cannot be identified by the data and so it can be viewed by any group of people.
Part 3 Screen 9
The spreadsheet gives a much more detailed view of the data. If you have a question that has an “other” option, you can actually see the responses that are given. You can see that the summary view only says that 3 people chose “other” for their favorite color, while on the spreadsheet view you can see that two people wrote orange and one wrote purple. It also allows you to see names, dates, and times on all of the responses given.
Part 3 Screen 10
When you you select spreadsheet to view the data, it opens in Google spreadsheet. This spreadsheet can be used in a way that is similar to using Microsoft Excel or it can be exported to Excel. This means that you can organize the data in a variety of ways, such as sorting and filtering, adding comments, performing mathematical functions, inserting charts and graphs, and setting a color code.
Part 3 Screen 11
Here are the buttons that can be used to organize the data.
Part 3 Screen 12
In the upper right hand corner of the spreadsheet, you can see the “share” button. From here you can publish the results as a webpage to attach to your classroom website or blog. You are also given the option to email the results or email the results as an attachment. If you choose to email results as an attachment, this means that you are giving access to the Google spreadsheet, to whoever receives the email.
Wrap-Up
To sum up our presentation, Google forms are easy to create, include a wide range of question types, and are easy for students to fill in. The results go directly into a spreadsheet, making them easy to analyze and share with others. Forms and their results are useful for tracking student and self progress on homework assignments, assessments, teaching techniques, or attitudes. This functionality is beneficial across the entire spectrum of courses, subjects and grades.
Final screen
For more help with Google Forms, see the following 3 links. More specific help is available by following the last link to the Google Docs help page.
Audio link: Let’s hope this works!