DFI Day 8

DFI Day 8
10.09.19


Dealing with Data
With Mark and Dorothy

Agenda

Connecting with Manaiakalani- Empowered

Empowered as opposed to agency- agency for many-has other not so positive connotations.

It’s not just a tool, if it’s not transforming lives….is it working?
Enables a level of control in their lives
View- It’s not just a Tool- Nigel Latta


Dorothy shared how whanau in her neighbourhood ( and so many others) are disempowered.

5+ a day makes a difference- conversation that goes back and forwards 5 times a day. Build on that!- especially for our little ones.

Dealing with Data
Google Forms
Chalk ‘n talk

Need to be purposeful and useful
No need for Survey Monkey or costs.

There are three main ways to send a form:
1.Email - Allows your to directly send the form. Add the recipient's address, customise your message and hit send
2.Link - Share via link. Highlight, copy then paste the link in the desired location
3.Embed - Copy and paste the embed code to share via Google site or blog

Tips
A dropdown box or choices make responses more consistent, accurate.
Created my first google form

My Maps
You can turn on map sharing (phone) with a partner, friend. Could do with it with a group of friends, colleagues who are meeting up- can do it for a short term. Good for teenagers. Useful for planning walks and trips when you are away.
Customisable collaborative maps- can import data from a sheet-
Operates on multiple layers
Useful for maths- scale, measurement
We used the info from our Google form, then imported info to our MyMap

Google Sheets
Tips for me to practice and remember:
To freeze the top row, go to View- freeze
Freeze left column- go to view freeze 1 column
To resize columns select, shift click- drag to resize
Added Crop it to remove all of those extra cells
Use the Explore tool will do graphs automatically. Click on the 3 dots of the graph to move it to it’s own sheet. Rename it.
Use the dropdown box on the tab to protect the sheet and who can access it.
Check add ons that are available- QR codes, split names. (1 a day free)
Select rows, columns with a pattern to repeat pattern, click on corner, drag down.
If I get stuck, think… is it data, format, or a shortcut???
Sort highest to lowest Z-A

Tip of the Day: If in doubt, click on the three dots.
You can hide a column by clicking on arrow on tab. Left arrow to return it.
An idea to follow through with is to have a Google form on our learning site. Students can fill it when they have made a comment on a blog.
Your name
Blog you posted on
Post link to that blog
Post onto class site.


Eeeeeeek, have registered for next week’s exam!!!!
Need to brush up ready for Level 1 Google Educator, feel totally unprepared and rather anxious.