DFI 4 Data data data

Hapara

Firstly looking at Hapara hot tips. Checking comments especially those in red. They could be spam. If it is spam then don't click on it. Go to the blog and follow the procedure (not sure if I know it - will check on that). 

Everyone loves to share. The reason for sharing is the audience. Purpose... An authentic audience is people who choose to listen to you...E.g. Someone clicks on your post.

Blogger

PURPOSE of Blogger 

Blogger resembles the platform students want to be on but can be used to teach students how to make positive, thoughtful, helpful comments. 

To be cyber smart. Functional. Teach digital citizenship.

Essential that teachers keep a close eye on what our students are doing online.

The side effect if to connect with parents and whanau. LCS cyclical - sharing starting place for learning or the completion of learning.

Fun fun fun! 

Created a form and learnt all the possible settings available.

Google Maps - I got distracted but really enjoyed having a play and looking at all the new functions I learnt.

Google Sheets

Things I already knew how to do but found this as a useful reminder that it is there or saw a different way how to do it:

• Freeze row and column - just use hand to select columns and rows
• Resize columns
• Totals - sum
• Average
• Organise numbers
• Filtering
• Drag handle for days of the week, months of the year, numbers, patterns etc.
• Custom date format - NZ date
• Explore tool - ask questions about data, or charts, 
• Insert chart
• Conditional formatting - set the parametres 
• select data and sort
• adding a rule - which is so much quicker than what I used to do it which is using the filter
• Format - alternating colours to make the view easier to read
• Ctrl Shift F to ring back menu bar
• Protect cells and rows - can't be edited
• Add-ons increase functionality of sheets

New:

• Insert a chart using explore
• Find an average - how do we round off the average?
• Change SUM to Mult by  using shift 8
• Conditional formatting
• Data validation

I created a chart to show the data collected about a student's blogs.

Blog Comments

Remember to make quality blog comments:

Insert display text here - Use this code to insert a hyperlink on a comment.   

 "<a href="insert URL here">Insert display text here</a>"