• IT Skills for Students

    Surveys

    Google Forms and Microsoft Forms are both online survey tools.

    It is very useful at times to be able to send out surveys or questionnaires. The applications explored in this module both allow you send electronic forms to people and collect the responses via the internet. 

    For this module you only need to do one of either Activity 1 (Google Forms) or Activity 2 (Microsoft Forms) depending on whether you prefer to use the Google or Microsoft option. The badge is based on being able to complete the skills in either of these options.

    Activity 3 (Excel Survey) is included as optional extra. It is not included in the self-assessment.

    • Activity 1

      Google Forms

      Allow 60 minutes

      Google Forms is an application that is available as part of your Google account. This activity guides you through the basics of setting up and sending a survey, and then collecting the data.


      Task 1: Overview

      Work through the resources below and then have a go at the challenge.

      Link: Google Forms Overview

      Link: Create beautiful forms

      Challenge:

      • Log in to (or create) your Google Account
      • Locate Google Forms

      Task 2: Create a Survey

      Work through the resources below and then have a go at the challenge.

      Link: Create a survey using Google Forms

      Link: Choose a form response destination

      Challenge:

      • Create a survey with at least 5 questions
      • Choose a response destination

      Task 3: Share a Survey

      Work through the resources on this website, then have a go at the challenge.

      Link: Send your form to people

      Challenge:

      • Invite some friends to complete your survey by choosing one or more of the options available
      • You could also send the form to yourself to complete

      Task 4: Analyse the Survey Responses

      Work through the resources on this website, then have a go at the challenge.

      Link: View and manage form responses

      Challenge:

      • View the responses from your survey
      • Download the responses
      • Stop collecting responses

    • Activity 2

      Microsoft Forms

      Allow 60 minutes

      Microsoft Forms is an application that is available as part of an Office 365 account. This activity guides you through the basics of setting up and sending a survey, and then collecting the data.


      Task 1: Overview

      Work through the resources on the website, then have a go at the challenge.

      Link: What is Microsoft Forms?

      Challenge:

      • Log in to your Office 365 Account
      • Locate and open the Forms app

      Task 2: Create a Survey

      Work through the resources below and then have a go at the challenge.

      Link: Create a survey form

      Link: Adjust your form settings

      Challenge:

      • Create a survey with at least 5 questions
      • Choose form settings based on your preferences

      Task 3: Share a Survey

      Work through the resources on this website, then have a go at the challenge.

      Link: Send your form to others

      Challenge:

      • Invite some friends to complete your survey by choosing one or more of the options available
      • You could also send the form to yourself to complete

      Task 4: Analyse the Survey Responses

      Work through the resources on this website, then have a go at the challenge.

      Link: Check your form results

      Challenge:

      • View the responses
      • Download the responses
      • Stop collecting responses

    • Activity 3

      Excel Survey

      Allow 30 minutes

      Another option for creating surveys in Microsoft Office 365 is to use Excel Survey. It works in a similar way to the other applications in this module, but it returns the results directly to an online Excel spreadsheet. This can be very handy if this is where you want your data to end up.


      Task 1: Overview

      Work through the resources on these websites for an alternative method of creating surveys with Microsoft Online.

      Link: Surveys in Excel, hosted online

      Link: Create an Online Excel Survey

      Link: How to collect data with an Excel Survey and Office 365 Education

      Optional Challenge:

      Following similar steps to the above activities, set up, send and analyse an Excel Survey. Which of these options might you use and when might you choose to use it?

    • Checkpoint

      Surveys Self-Assessment

      Now that you've completed the activities in this module, take the time to complete this self-assessment of how competent you think you are in using Surveys.

      Follow the instructions by clicking the link below.

    • Surveys Self-Assessment Quiz
      You have to add at least one completion condition.

    • Discussion

      Surveys Forum

      Using the forum below, click the 'Add a new discussion topic' button and perform the following tasks.

      1. Using a PNI format (Positive, Negative and Interesting) post something that you found useful, something that you found difficult or confusing, and something that you would like to find out more about relating  to the activities in this part of the module.
      2. Share at least one additional resource (web link, video etc.) that you think would help any other students working through this module.
    • Surveys Forum