Print Friendly, PDF & Email

Main subject: Math
related subject: Science, ICT
Duration: 45 minutes.
Age groups: Age 11, Age 12
Submitted by: Hanna Särkkä

Learning objectives:

a) Learn how to make a little survey study b) Learn how to make a digital diagram, c) Practice to present the results of the study.

Implemented digital tools:

iPads 1/1 students with an internet connection iPad for 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 is learned when student learn how to do digital data by him/herself and he/she sees how the digital diagram is formed. Communication and collaboration is learned by asking opinions for the surveys ans presenting the own survey. Problem solving is learned when students need to think their own topics for the survey.

Preparation:

Organize 1/1 digital devices to students with an internet access. Prefer mobile devices for example iPads or smartphones. If possible, add the app “google sheets” to the devices. Application can also be used via internet browser. Chrome recommended. Teacher and each student need an account to google services. Create ones if needed and/or confirm that students know/remember their accounts and passwords. (Many countries/municipalities have a school accounts to all students. Check before creating accounts if your employer has already created ones. To create an account: https://accounts.google.com/signup/v2/webcreateaccount?flowName=GlifWebSignIn&flowEntry=SignUp) Book a studyspace with a digital processing visualizer and a data projector. Check the system is working properly.

introduction

Introduce the goal of the lesson to students: a) Learn how to make a little survey study b) Learn how to make a digital diagram, c) Practice to present the results of the study. Warm up discussion face to face: Ask if students have seen diagrams before. Where? What kind of? Do they know what is a survey study? Have been interviewed for a survey study before? Have they done diagrams by themselves? Which kind of? Etc…

Implementation:

An example survey and a diagram to show 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 (for instance) what are students favourite dishes. Tell that these all will be the choices to choose in this example survey. a) List the answered dishes to column A one dish per each row. Continue to collect choices for about one third of the students amount. Ask students to vote their favourite dish by raising their hand when the dish is sayed. b ) Count the votes and put the number each favourite dish gets to the 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 think what are the topics students are interested to know about their classmates. Favourite colours? Favourite games? Favourite animals? Ask the students to figure the topic 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 Ask students to do exactly the same you did in 1 a an b. Repeat the steps if needed. When ready, students can walk around in the classroom and ask votes for their surveys. Guide students to communicate accurately 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 student to represent the topic of the study choices of the study results of the study c) Ask students to log out from google sheets.

Conclusion:

3. Conclusion: Repeat the goals of the lesson. Ask student to put their thumb up if they: a) Learned how to make a little survey study, b) Learned how to make a digital diagram, c) Learned how to present the results of the study. d) If they had fun!

Implemented needed devices: