DFI - day 4

8/4/26 - Dealing with Data

💡Top Tips
Command+shift+T - if it was the most recently closed (by accident)
Google Calendar for the class and embedding it on the site
Cathoven - http://cathoven.com/
Diffit - https://web.diffit.me/

🤔 Remember
Table of contents on docs and Headings.

Connecting with Manaiakalani - Dorothy

Sharing has a profound effect on academic shift.

Harnessing digitial technologies has a big effect on this as well. Create adds academic value and sharing adds to this again.

Make it intentional, not an add-on

Sharing is not a new concept it has been happening since time began. Recording our connections is key. Don't just share our wins but our failures.

Social media started in 2005. YouTube April 2005. The way we share has changed a lot since then. How do we harness technology to enable people to connect...appropriately?

Post-2005, the speed and amplification were immense.

Don't forget more traditional types of sharing - going to share with the principal, displays, yearbooks, fiafias, film festivals, performances, etc.

An authentic audience are the people who choose to listen to you.  You can be a compulsory audience or an authentic audience.

Cybersmart supports digital citizenship.  How to be positive, thoughtful, and helpful online.

Pitomata is a pilot "programme" to replace blogs.  Next year, this will be used.

It is important to share learning.  Experiencing that moment of finishing is socially important as well as academically important.

Learn-Create-Share is linear and cyclical.

You can share at the start to check prior-knowledge.  Capture this so you can refer to it at the end of hte learning.

John Hatties work on effect sizes.  Feedback and feedforward is empowered on this scale.

Children love feedback from outside their bubble, from a stranger.

Chalk n Talk - Stacey (google forms)

You can do forms or a quiz - You can then link to sheets and see your students answers as a sheet or graph.

Chalk n Talk - Hinewa (google my maps)

Google my maps is different to google maps.  

Great for classroom or personally.

When teaching this in class.  Discuss being a smart learner.  Why we don't share our address online etc.  You can do it if it is just you and your class but not if it's to go wider e.g. on your blog.

Deep Dive - Vicki (google sheets)

- Column size change. Highlight all your column and then click onto the line between two columns and change the size of a column.  This will change them all at once.
- Total all the rows. If I want to do the total for all the rows you can hover over the little circle at the bottom of a cell and scroll down and it will total all the rows.  You can also double click on the circle and it's going to put the total for all rows if you have lots.
- Make an average - double click in the cell and press = key type average and select cells.  To do the other columns select the blue circle like above.
- Decrease decimal places until i'm happy with how many decimal places are showing.
- Separate the names - click on the column header, right click and insert column to the right.  Select student data and go to data and split to columns.
- Change birthdates with words to just numbers.  Select columns, select 123 and scroll down to custom date and time.  Select what you'd like. Click apply.
- Filter function - looks like a funnel on the toolbar.  Everything goes to a green tinge.  Then you can select the lines in the headings (that look like a tornado).  I can then untick what I don't want to view e.g. 7 year olds.  I can filter by gender at the same time and you can then see maybe 8 year old females.  You can also go by ethnicity, classes etc.  This is temporary and can turn off the filters.
If you create a filter view using the calculator symbol by the tornado.  You can then save with a new title.  You can exit this view then go back into it when wanted.
- Autofill.  If I want to do say the days of the week, I could type Monday and then click the circle on the corner again and it will auto fill the other columns.  You can fill anything with an easily recognisable pattern.  If I just put a 1 and pull it down then it wont recognise but if you do 1 then 2 it will do the pattern.  If you want to skip count you do the same thing.
- Google translate words into other languages.
- Conditional Formating - Create a rule: e.g. format cells if the text is less than 1490 and it will highlight all the cells that are less than 1490 and I can choose a colour.  This is great for heat mapping.
- A spark line. in a blank cell hit the =key and start writing sparkline and select the data I want to be included in this cell.  It will create a line showing the progress (graph).