• Case studied: Yes x2
  • Proofreading priority: Done
  • Date added: 5/30/2019
  • Lesson topic: Survey with Sheets
  • Main subject: Math
  • Related subjects: Science, ICT
  • Duration in minutes: 45
  • Age groups: Age 11, Age 12
  • Submitted by: Hanna Särkkä

Learning objectives:

  • a)  Learn how to make a short survey study  
  • b) Learn how to make a digital diagram
  • c) Practice to present  results of a study.

Implemented digital tools:

  • iPads 1/1 students with an internet connection 
  • iPad for the teacher with an internet connection
  • Sheet app to iPads
  • A digital processing visualizer 
  • A data projector

Supported digital competence for student:

  • Information and data literacy,
  • Communication and collaboration,
  • Digital content creation, Problem solving

Elaboration of the competences

  • Information and data literacy will be learnt when a student learns how to create digital data by him/herself and he/she sees how the digital diagram is formed.
  • Communication and collaboration is learnt by collecting opinions for the survey and presenting one’s  own survey. 
  • Problem solving is learnt when students need to think of their own topic for the survey.

Preparation:

Organize 1/1 digital devices with internet access  to students. Prefer mobile devices for example iPads or smartphones. If possible,  add the app “google sheets” onto the devices. The application can also be used via an internet browser. Chrome is recommended.

The teacher and each student need an account to google services. Create one for each student if needed and/or confirm that students know/remember  their accounts and passwords. (Many countries/municipalities have a school account for all students. Check before creating accounts  if your employer has already created such an account..  To create a new account: https://accounts.google.com/signup/v2/webcreateaccount?flowName=GlifWebSignIn&flowEntry=SignUp)

Book a study space with a digital processing visualizer and a data projector. Check that the system is working properly.

Introduction:

Introduce the goal of the lesson to  students: a)  Learn how to make a short survey study  b) Learn how to make a digital diagram, c) Practice to present  results of the study.

Do a warm up discussion face to face: ask if students have seen diagrams before. Where? What kind of  diagrams were they? Do they know what  a survey study is? Have they been interviewed for  a survey study before?  Have they done diagrams by themselves? What kind of diagrams? Etc…

Implementation:

An example survey and a diagram to show to students : Open google sheet program and a new blank spreadsheet. Give it a name: example study. Make sure students see what you are doing. Ask what  students’ favourite dishes are, e.g. Tell them that their answers  will all be the options to choose from in this example survey. 

a) List the answers (the students’ favourite dishes) to column A one dish per each row. Continue to collect choices of favourite dishes from about one third of the students present.  Ask students to vote for their favourite dish by raising their hand when the dish is mentioned.

b ) Count the votes and put the number of votes each favourite dish gets to  column B (next to each dish).

THESE INSTRUCTIONS ARE FOR IPAD/MOBILE VERSION, DESKTOP VERSION IS A BIT DIFFERENT BUT THE SAME FUNCTIONS ARE AVAILABLE

c) Drag and hold from the left top to the right end  to activate columns A and B and then press + from the right corner of the display. Add a diagram and choose the type of the diagram >pie chart. Accept the chart by the green checkmark on the left side of the chart.  Move the chart by tapping and dragging next to the columns A and B

d) Drag and hold from the left top to the right end  to activate columns A and B and then press + from the right corner of the display. Add a diagram and choose the type of the diagram >column. Accept the chart by the green checkmark on the left side of the chart.  Move the diagram by tapping and dragging next to the columns A and B

e) Present the results of the survey. Ask students to consider  what  other topics apart from favourite dishes fellow students could be  interested in knowing  about their classmates.  Favourite colours? Favourite games? Favourite animals? Ask the students to figure out  and choose a topic for their survey and at least five choices under the topic.

2. Students make and present their own surveys: Ask students to log in to google sheets. Ask students to create a new survey.  Ask students to do exactly the same you did in 1 a and b. Repeat the steps if needed.  When ready, students can walk around in the classroom and ask about the votes of  their classmates’ surveys. Guide students to communicate accurately about the topic of the survey and the choices  for their classmates.

a) When ready,  ask students to do exactly the same you did in 1 c and d.

b) Ask each student to come and present their survey and its results

Ask the student to present the topic of the study, choices of the study and results of the study.

c) Ask students to log out from google sheets.