Analyzing Google Forms Result


    1.       The easier way to view the result is viewing a summary of the responses. Click Responses > Summary of Responses


    2.       You will be taken to a summary of Responses page this is particularly useful for viewing your results from time to time.


However, after a set amount of time, you may want to use this data in a spreadsheet and eventually create your own charts.

    3.       To use the data collected through responses, click View Responses button found on the upper part of the page.

    4.       Choose if you want to create a new Google sheet as the destination of your response results or if you want to put it on an existing Google Sheet.  

    5.       Once you click Create, you will be taken to a Google sheet which includes responses for your survey. From here you have two options:

a.       Save this file locally on your hard drive by exporting it to Microsoft Excel. To do this, click on File > Download as > Microsoft Excel Spreadsheet.

b.      Continue working online using Google sheets and use the built-in features like creating a chart for your data (found in Insert > Chart).  

    6.       You may now create a chart for your numerical data in either Google sheets or Microsoft Excel. Note that you must be online to use Google Sheets. Tip: Google Sheets are automatically saved when the internet connection is constant.

33 comments:

  1. Ma'am Karen what are the benefits that we can get by using this google forms?

    ReplyDelete
    Replies
    1. Hi! I will give 5 benefits that we can get by using the Google Form. So let's start;
      First, you can create unlimited free forms because most survey tools online will only offer a certain amount of free polls or surveys before they start charging you for the service. Google, will let you run as many polls and surveys as you like and you can just keep creating new Google Forms until your Google Drive is full. You’ve also got a lot of variety in the types of forms that you can build. You can use all sorts of question types and use a variety of themes on your form.
      Second, the results can go directly into a shareable spreadsheet, if you love collaborating on things with friends or co-workers, then you’ll appreciate that Google Forms will allow you to share both editing the forms and the results. Everyone can view them at the same time, make edit at the same time and see other people’s edits as they make them.
      Third, is the logic threading ability to change the survey based on the answers the participant has given. For instance, if the first question of the survey asks if you are a Mac or Windows user, the following questions can be based on Mac or Windows accordingly.
      Fourth, is that you can get email notification of results because some of the poll-making and survey-making tools available online will insist that you revisit their site in order to check on results and this is not a user-friendly in my opinion.
      Lastly, forms are mobile-friendly Not all web pages are created equally. Some are best displayed on a desktop machine, and some require Java or Flash. Not all of the readily available free survey-making tools are great on a mobile browser. But Google Forms are. All Google Forms are able to be used with any simple browser on any device.
      I hope you learn something :)

      Delete
  2. Is there any disadvantage of using Google Forms?

    ReplyDelete
    Replies
    1. Yes. For instance, the teacher are assigning a form to a multiple Classroom Classes, it will create multiple copies of the forms and the results sheet, this means that the teacher need to check it one by one for which the work is assigned. Also, when copying the form it creates a new results sheet and does not copy the Add-Ons and Settings. Also there are limitations that a Google Form have like it can be completed many times as a person wants to access the survey, no ability to format text and lastly it's hard to move the questions other than up or down. They are all flush left. So, I hope you learn something. Thanks :)

      Delete
  3. My thesis partner and I are planning to use Google Form as means of questionnaire. A friend from other school told me that the validity that you will get from google form is low. Is it true?

    ReplyDelete
    Replies
    1. Its a bit true but you know you can filter the answer of your google form, you can only send a survey within the one you really know.

      Delete
  4. Hi Ma'am! what if while I am answering a google form, the PC suddenly got disconnected from the internet. Is there a way that I can retrieve the lost data? Or do I really need to start over again? :/ thanks in advance!

    ReplyDelete
    Replies
    1. Google Forms have auto saved features, so don't worry. :)

      Delete
  5. If the google forms is easiest way to view a result, what if there is a time that I cant use it, is there any you can suggest me to use?

    ReplyDelete
    Replies
    1. You can also check other online survey form such as Survey Monkey, Typeform, Google Forms, Client Heartbeat, Zoho Survey, Survey Gizmo, and Survey Planet. You can try these all, for you to find out what's the best. :)

      Delete
  6. what is the use of google forms? what its pros and cons?

    ReplyDelete
    Replies
    1. Google Form is one of the tools available from Google Docs collection. They can be a useful tool to help you plan events, send a survey, give students a quiz, or collect other information in an easy, streamlined way.

      Pros:
      Instead of taking the time to view and sort the Google sheet, teachers can just look at the Done vs. Not Done, which updates live as students submit their Forms. This works just like the submission of any other assignments on Classroom.

      If there are multiple files added to the Assignment that includes the form, students will need to click Mark as done manually, otherwise this is now automatic.

      The Cons
      Instead of assigning the live form link to the assignment, it is actually creating a copy of the form itself within Classroom, just like the Make a Copy option would for any other Google doc. The problem here lies in multiple classes: if you are assigning a form to multiple Classroom classes, it will create multiple copies of the form AND the results sheet. This means that the teacher has to check responses for each class section for which the work as assigned. The ease of the automatic Mark as done probably outweighs this extra step for most teachers, though, making the feature still worthwhile. Unless you love Add-ons.
      When you use Add-ons to manipulate data or communicate with users, it often takes a while to program effectively.

      Delete
  7. What if a problem occur while doing my data such as disconnecting to internet or having a brownout.. does it affect my data?

    ReplyDelete
    Replies
    1. Google Forms have auto saved features, so don't worry. :)

      Delete
  8. Ma'am what are the advantages of using google forms? how will it help us as a student?

    ReplyDelete
    Replies
    1. You can create unlimited free forms.
      The results can go directly into a shareable spreadsheet.
      It has a logic threading.
      You can get email notifications of your results.
      Forms are mobile-friendly.

      Delete
  9. Why is it important for us to know Google forms?

    ReplyDelete
    Replies
    1. You can use it in the future, you can use it on your research paper, when you need to survey things, you can use survey forms in educational and personal purposes.

      Delete
  10. what are the benefits that we can get by using this google forms?

    ReplyDelete
    Replies
    1. Hi Ralf!
      I will give 5 benefits that we can get by using the Google Form and these are the following;
      First, you can create unlimited free forms because most survey tools online will only offer a certain amount of free polls or surveys before they start charging you for the service. Google, will let you run as many polls and surveys as you like and you can just keep creating new Google Forms until your Google Drive is full. You’ve also got a lot of variety in the types of forms that you can build. You can use all sorts of question types and use a variety of themes on your form.
      Second, the results can go directly into a shareable spreadsheet, if you love collaborating on things with friends or co-workers, then you’ll appreciate that Google Forms will allow you to share both editing the forms and the results. Everyone can view them at the same time, make edit at the same time and see other people’s edits as they make them.
      Third, is the logic threading ability to change the survey based on the answers the participant has given. For instance, if the first question of the survey asks if you are a Mac or Windows user, the following questions can be based on Mac or Windows accordingly.
      Fourth, is that you can get email notification of results because some of the poll-making and survey-making tools available online will insist that you revisit their site in order to check on results and this is not a user-friendly in my opinion.
      Lastly, forms are mobile-friendly Not all web pages are created equally. Some are best displayed on a desktop machine, and some require Java or Flash. Not all of the readily available free survey-making tools are great on a mobile browser. But Google Forms are. All Google Forms are able to be used with any simple browser on any device.
      I hope you learn something :)

      Delete
  11. is a google forms have a disadvantages?

    ReplyDelete
    Replies
    1. Hi Patrick! Yes it has disadvantages. For instance, the teacher are assigning a form to a multiple Classroom Classes, it will create multiple copies of the forms and the results sheet, this means that the teacher need to check it one by one for which the work is assigned. Also, when copying the form it creates a new results sheet and does not copy the Add-Ons and Settings. Also there are limitations that a Google Form have like it can be completed many times as a person wants to access the survey, no ability to format text and lastly it's hard to move the questions other than up or down. They are all flush left. So, I hope you learn something. Thanks :)

      Delete
  12. Replies
    1. We can use Google forms when we we're planning an event, when we we're sending a survey, and for educators, when giving students a quiz.

      Delete
  13. can the google forms make our researching much easier? how come?

    ReplyDelete
    Replies
    1. Yes, you can use it and it is a really big help for the student like you. It is more relevant nowadays the use of internet than a use of a paper because it is easy to type rather than to write. You can also filter the answer of your respondents by validation so you are sure that you can get proper information because of the validation.

      Delete
  14. ma'am where do we usually use google forms?

    ReplyDelete
    Replies
    1. In my own experience, we usually use it when we we're conducting a survey.

      Delete
  15. Do we need google forms? And what are the advantages and disadvantages of this? Can google forms make research easy?

    ReplyDelete
    Replies
    1. For me I think yes, it can make our life more easier.
      These are the advantages and disadvantages of google forms;
      Advantages:
      Instead of taking the time to view and sort the Google sheet, teachers can just look at the Done vs. Not Done, which updates live as students submit their Forms. This works just like the submission of any other assignments on Classroom.

      If there are multiple files added to the Assignment that includes the form, students will need to click Mark as done manually, otherwise this is now automatic.

      Disadvantages:
      Instead of assigning the live form link to the assignment, it is actually creating a copy of the form itself within Classroom, just like the Make a Copy option would for any other Google doc. The problem here lies in multiple classes: if you are assigning a form to multiple Classroom classes, it will create multiple copies of the form AND the results sheet. This means that the teacher has to check responses for each class section for which the work as assigned. The ease of the automatic Mark as done probably outweighs this extra step for most teachers, though, making the feature still worthwhile. Unless you love Add-ons.
      When you use Add-ons to manipulate data or communicate with users, it often takes a while to program effectively.

      Delete
  16. Can I do it in Microsoft Word?

    ReplyDelete
  17. Is it easy to use even if you're a beginner?

    ReplyDelete
    Replies
    1. Yes of course, you can even try it now. Just make sure that you follows all the step by step procedure of creating a feedback form on my other blog.

      Delete