Dealing with Data
Deep Dive with Dorothy - Share
- Sharing is a human instinct
- 2005 April - You Tube was born which changed society. All future social media knew the idea to 'share' was the way forward.
- Share along with Create is a hook
- sharing with an audience is a part of it - like taking your work to the principal to get a start - now with online/blog sharing has become global
- an authentic audience - not in assembly that have to be there but people that see what you have shared authenticity
- sharing can be from one to one, groups, class to global
- Our kids have to learn how to share in an open forum.
- Understanding the satisfaction of what it's like to finish something and then share it.
- Learn, create, share is a cycle - you may start with share so the learning has an understanding of what it's like to finish work ready to share.
Google Forms - Jeremy
- required selected means they can not move to the next question unless this one has been answered.
- description - can add this if you want a specific question in number 5 to go directly to 9 instead of having to answer every question.
- Limit to 1 response - this allows only one form per person
- add collaborators to allow someone to edit the form/ share with someone to change
- Can create a new map my typing in Google maps or through your drive under 'new'
- When published it doesn't always look like it does when making it - look at preview to see that look
- can overlap journeys on the same map
- If students are sharing their maps we don't want a marker on their home address - double check they have not put their address.
- Can add your own marker eg favourite place to chill on the beach
- Use as a measurement tool when talking about distance and time
- ruler can measure distances on the map - it disappears when you are not using it so won't be on the map - the ruler tool is in straight lines
- Check for blue line on the side if using more than one journey to make sure you are working on the right map
- When there is a lot of data - go to uniform style and change to individual style and change colour or/and icon
- click and it can be embedded on blog
Google Sheets - Dorothy/Jeremy
- There is more than one way to use sheets - hold and drag, using the instructional tabs
- Conditional formatting - can chose what range eg greater than 7 - change colour to show which ones they are.
- Conditional formatting - custom formula is - eg medial is one colour. behaviour another colour, boys/girls, year 7/8.
- Can add as many formulas as you need.
- If sheet names in cells changes you need to make sure conditional formatting is changed too.
- Data range - change what column you want to show the age from youngest etc
- Duplicate each page to keep all the cells the same.
- Drop down box - data validation.
- Tick box - has a certain child been tested etc
- Notification rule - if someone other than owner has made a change.
Analysing data with a spread sheet.
UPDATE
I used what I had learnt about Google maps in this DFI and added the Google Maps as part of my reading plan. We were working on current events and adding the map component gave the lesson another layer of thought and interest to the students. They had to plot where the events happened in either New Zealand or internationally.