Dealing with Data - Day 4 - DFI Online

LEARN:
1. Connecting with each other

• Really encouraging to hear our bubble peeps getting excited about using the tools they have learnt about in the DFI in their classroom and the kids responding positively to it. Go Jason!

2. Connecting with Manaiakalani - SHARE

• Digital 'sharing' came into its own during our first lockdown in Manaiakalani schools
• Sharing is something we are born to do!
• Social media changed sharing by speed and amplification
• When the world changed... 2005... birth of YouTube/twitter/Ebo 
• "Work with learners to establish an authentic audience for their learning outcomes"
• Sharing with purpose... an audience... beyond the local community - globally
• Interesting to hear why Blogger was chosen for sharing - learning to be CyberSmart in real time
• Sharing can be a starting place for more learning - it becomes a cyclic process

3. Chalk 'n Talk - Google Forms

• Google Forms 

- "allowing Google to do the hard work for me"

- send people the correct link! 

- loved the pool testing form Jeremy!  

4. Explore - Creating a Form

• Feel more confident about using this tool as I have now had a chance to develop and use forms a bit lately

5. Deep Dive - Google My Maps / Hāpara Hot Tips

• mymaps.google.com
• fascinating as I have never played with this - could be used for whānaungatanga with classes after doing their digital pepeha
• careful not to share home addresses!

6. Exploring My Maps

• Sooo cool! Lots to explore here!

My Maps Pepeha

7. Deep Dive - Google Sheets 101

• freezing first row/column (via view or grey lines)
• resizing all columns together
• using formula like SUM/AVERAGE and autofill function (+)
• changing format of date using more format
• plain text when using phone numbers
• filtering (a funnel icon)
• auto fill for months of the year/days of the week/numbering patterns - really cool feature
• * for 'times by'
• shortcut to see all sheets = bottom left
• = sparkline gets a line graph for a student
• alternating colours to change spreadsheet colours
• format, conditional formating
• split text to column to separate whole names to first/last name etc
• click in top right of a cell to sort column

9. Chalk 'n Talk - Sheets on Speed

• how to use sheets for exam data:

- averages

- sorting averages

- create charts - use explore tool for suggestions

- select one chart use the three dots, move to own sheet

10. ONLINE Levelling Up - Sheets

• Oh dear... this was a bit of a disaster to start off! Couldn't work out why things weren't working for me until Campbell noticed that I hadn't made a copy of the sheet and was trying to edit a 'view only' one! Note to self... always check that if things don't seem to be working!
• I seem to have two left thumbs... fingers.. when it comes to navigating cells. Try it three times and it won't select the correct cell, try it again and it works! I am pretty good at navigating Excel Spreadsheets; I didn't expect Google sheets to not be my friend... I will have to practice a bit more...
• A-ha! A tip from Vicky - use an external mouse rather than the trackpad! Of course!

Playing with Google Forms

CREATE
Making meaning of content 

• Analysing data from a student's blog - this required a bit of 'head scratching' to embed the graph without it being a huge size! Need to make sure the graph is embedded from the original spreadsheet, rather than trying to embed it if you have moved it to its own spreadsheet

• ANALYSIS: The large increase in 2020 may have been a direct result of increased blogging due to lockdown or maybe just a different teacher with a heavier emphasis on blogging?

Blogging

• Inviting your personal account is a really important step. Witnessed this in the flesh in a classroom in Auckland last week. Matt made a teachers' day by adding her personal email and allowing her to access a blog she had had at a previous school
• Must try this: Creating a link in a blog comment <a href="insert URL here">Insert display text here</a>

1. What did I learn that increased my understanding of Manaiakalani kaupapa and pedagogy? 

Loved hearing the reasons behind choosing to use Blogger as the Manaiakalani platform for sharing. It all makes sense when you hear the reasoning behind choosing Blogger, even though it has its detractors.

2. What did I learn that could improve my confidence, capability or workflow as a professional? 

MyMaps is awesome! I can see me losing quite a few hours having a play with around that tool!

3. What did I learn that could be used with my learners? 

Google forms as a tool to use in collecting student voice, or in my case as a feedback from teachers about how an in-class support session went.

4. What did I learn that could improve my confidence, capability or workflow in my personal life? 

I think for the first time today I really hit something that was hard for me to get my head around! I really struggled with Google Sheets and I didn't think I would. I just couldn't get the cursor to work properly in highlighting, dragging cells etc. 

But... I suspect my problem was not having an external mouse. Thank you to Vicky for suggesting that because I was beginning to think I was going a bit nuts!