DFI: Dealing with Data

Connecting with Manaiakalani - Empowered (Agency) 

If the Chromebook is not changing lives we should not be enforcing it on our families. If it is just a tool we can and should do something cheaper. 
The Chromebook empowers students and families to have a great connection and greater skills. 

Most of the families in the Manaiakalani community are living off $19,000 p.a. and they are making it work. They are so talented at stretching their money. 

3 is the average age of development of students when they get to Manaiakalani schools. 

32 million less words spoken in a low socio-economic household by the age of 5. 

1/3 turn over of students in schools. 

Google Forms 

We learnt about the different ways you can make a form and the different settings your form could have... here is my test form Do You Wanna Taco 'bout It?

Google Sheets 

Exciting!!! I was shown a way to protect sheets so that only certain people can edit them!

QR codes! You can also turn url's into QR codes - this is done through an add on called QR generator... currently not working... 

Other things that came up that were handy: 

Sparkline - a way to create a mini graph with a row of cells on a sheet 

Macro - a way to record settings & formatting so that they can be applied to multiple sheets

Filtering - a way to organise the data, for example by males only or by year 7 males only  

Collecting information from other sheets - type = then go to the sheet and click what you wanted to share in two places

Pixel Art - make the cells in the sheet smaller, then colour by clicking and control on each square. 

Cool way to track student blog posts as a statistical inquiry. 

Student Blog & Sheet created with the data from the blog. 

Thinking forward to next week... the Google Exams... thinking about looking into Google Trainer or Hapara Champion