The Day I Felt Out of My Depth!

To share is innate in human nature,  to share is instinctual.  The impact of Social Media/technology has influenced this and we can share instantly and to a wider audience

In 2005 world changed when in April YouTube started.  This meant people could harness technology to establish authentic audiences for LEARNING - but face to face still vital.  Audience is essential - must be authentic, how can you ask writers to write for an audience when you don't provide the audience. authentic audiences are the ones who choose to 'listen' to you

Blogger has functionally similar to spaces kids want to be on -  Manaiakalani uses it with the purpose is to learn to use it not to be on the latest app.  Pupils learn to connect on line, functionally without distractions.

There are different types of share - finish learning (end product), share to learn -  learning more from comments etc opening new things to think about, share to teach.  Sharing is not linear

Google forms

I have used this in the past for a variety of purposes and will look into using for quizzes.  When using it for quizzes it is important to have it in locked mode so pupils can't open any other tabs while taking quiz.

There is the ability to share forms across the whole school - could be good for school wide testing and may be something I look into in my role of leading mathematics

Hapara Hot Tip

I already use Hapara to look at comments and who has blogged.

Chalk and talk - Google My Maps

In this session we learnt to create a map, including:-

titling a map, adding layers, using a polygon to get the area, a line gives distance, you can get directions, to get a temporary measure use the ruler, you can change view for satellite, terrain etc. You can share map, the preview of a map looks a little different from when you are making it.  You can add or delete text photos etc for markers.  You can import data from spreadsheets, you can change icons and colour of pins .  to share on site use the embed code

While it looks good it is quite time consuming and I would need a lot more time to play with it to figure out how to use it properly.  I can't really see me using it at this stage.  After plotting the points I couldn't get back to put in the route so just got frustrated and gave up! I also dislike it plots only has driving route rather than sailing route! Here is my poor attempt at a map.

 

Google Sheets

In tis session we were told how to resize columns.  I learnt a new shortcut - click first column, hold down shift click last column then resize them.

To get a sum click the sum icon and then highlight the cells, you can use auto fill that will transfer the equation either across rows or down columns.  You can also do this to get the average.  There were reminders about how to change the format for dates etc.

The filter function looks like a little funnel, you can filter groups and then saved filtered data.

When you have many tabs across bottom - look at three lines and you can see the names of all tabs.

Spark line does little graph in cell so you can see trends - this add on looks really cool

You can change format for colours - this will save me time.

Conditional format rules can highlight those that are low or high this is also a time saver.

I really liked that Vicki said she is still learning (it shows we don't need to know it all yet). She found recently how to split text to columns.  I think this will be a tool I will use a lot.

By using concatonate you can join cells together in a string

Beyond text wrapping - type on 1 line the press alt+enter and this takes you to new line but in the same cell

It was great to have a tutorial on how to move data across tabs/sheets and it is something I will have to practice.

You can add ons things like cropping sheets, might also save on toner when printing out, when copying to another document if you paste linked then the data will update on the doc you have pasted it to when you update the original sheet.

The explore function at the bottom right of the sheet will help tell you what data is available

Analysing blogs

We spent time analysing a blog on sheets.  Unfortunately embedding the chart was too small to see properly so I have also included a screenshot or my chart.

Blog commenting from Kelsey  

Kelsey has shared this with us in staff meetings. I have all the comment notification settings done for me and my class.

I learnt that you can insert links into comments by using using html code  <a href="insert URL here">Insert display text here</a>.