Introduction

Recap last week’s lesson on forms, types of question and how accurate the questionnaires they answered were. Ask the students -

• What types of questions could we include in our forms?
• Did anyone suggest changes to another group and why?
• What are the advantages of collecting data in this way (online)?
• Are there any disadvantages?

Remind them how to get back to the form they built last week through their Google or One Drive. For the person that created the form it will be in My Drive (Google Drive) or My Files (One Drive). For the other group members that were shared into the form it will be in Shared with me (Google Drive) or Shared (One Drive).

 

 

 

Viewing your results

As they open the form, how many people have answered your questionnaire? How do you know? If they sent it out to people (and they answered it) there should now be a number at the top next to responses, this is how many people have completed your form so far.

 

 

 

 

If you click on the Responses tab you will see a summary of the answers given, with graphs and charts already created. This view in itself is really useful, but you can also view your date in a spreadsheet if needed.

 

 

 

 

Opening the results in a spreadsheet

 

As you click on the green icon you will get the option to create a new spreadsheet or add the data to an existing spreadsheet. Create a new spreadsheet, it will name it for you automatically. It will open up a spreadsheet a bit like this once you click Create.

 

 

As you click Open in Excel, a spreadsheet file will be downloaded to your computer. You will need a copy of Excel or Office 365 to be able to open the file.

 

 

Main task

Compare the summary of responses view from the form to the spreadsheet view. Ask - When might the spreadsheet view be more useful? When might the summary view be more useful?

Give them a few minutes to look over their results. How many responses did you get? Did anything surprise you? Can you tell me about the results of one of your questions?

In their groups, ask one of them to return to their Google/One Drive and create a new Google Slides/Powerpoint presentation. Give it a name and ensure all group members and you(the teacher)are shared into it. 

 

 

One person should add a slide for each question in their survey (the Title and body template is probably best for this) and keep one for a title screen. 

 

 

Each team member should choose a question and slide to work on to speed things up. On each question slide ask them to add their question in the title box, for example; We asked “Do you prefer snowy or sunny holidays?” This can be copy and pasted across from the form if it’s faster. 

Then ask them to come up with a conclusion statement(s) for each question they asked. For example “More people prefer sunny holidays to snowy holidays”, or “63% of people preferred sunny holidays to snowy holidays.” and add it to the slide as well. 

 

Finally find an image that represents the question or answer being asked.

 

In Google Slides use the Explore tool (Tools > Explore) Do a search for something appropriate to the question like ‘Sunny beach’ and then choose ‘Images’ from the below the search box.

 

 

Then just drag the image you like onto their page and positioning and sizing it to fit so that the text can still be seen. 

 

    

In Powerpoint, go to Insert > Pictures > Bing Pictures and search for a copyright free image using the Creative Commons filter (turned on).

 

 

Then position and size the image so that it fits and the text can still be seen. 

 

 

Adding Graphs

Finally they can also add graphs from data to support their statements.

 

In the Google Form Responses page, click the copy chart button on any graph you want to use.

 

 

Then go back to your Google slides presentation, select the correct slide and press Ctrl+V on your keyboard to past the chart onto your slide. Double click the image to crop it down to the correct shape. Click away from the image to seal it.

 

 

Then click it once and use the blue handles to resize it and drag it from the centre to position it on the page.

 

 

Ensure they split the slides up between them to get the job done more quickly and add a title page with their names and an image on (if time).

 

In Microsoft Forms you can hover over a graph to reveal the value of a segment, then right-click the graph and copy the image.

 

 

Then go back to your Powerpoint presentation, select the correct slide and press Ctrl+V on your keyboard to paste the chart onto your slide.  Then click it once and use the corner handles to resize it and drag it from the centre to position it on the page.

 

 

Ensure they split the slides up between them to get the job done more quickly and add a title page with their names and an image on (if time).

 

Plenary

At the end of the lesson ask a few groups to present their findings back to the group by opening the presentation on the front computer (as they should have shared it with you earlier) and asking them to talk through the data they collected their conclusions from the responses they received.

• Do you think your results would have changed if you asked 100 or 1000 people?
• Why?
• What would you expect to see?
• Who might want to collect and use data like this?
• How might a holiday company use the data?