DFI Session 4: Sharing Data

Sharing Data

Sharing via social networking is the hook for these learners. This does not replace how we would usually share learning eg certificates, art work displays, stickers from the principal etc 

Sharing with a purpose: 

The audience is real! We are able to bring authenticity to the idea of sharing.


We want learners to be able to finish tasks so they are set up for the future.

“People who choose to listen to you” Dorothy Burt 2007

There is benefits of both ‘sharing to finish learning’ as well as ‘sharing to learn’ An example of sharing to learn might be that a learner uploads their draft to a blog to receive feedback/next steps.

In order for people to follow/ read my blog, I need to be commenting on other people blogs.

I can view my blog traffic feed by a tracking widget.

Here is a video that explains cyber safety.

Google Forms

Test your knowledge about capital cities around the world here.

How to use in the classroom:

- A great medium to collect data from learners/colleagues.
- There are so many options for how to format questions such as multiple choice, slide bar etc
- If you turn on the required button, nobody can submit the form without answering a question.
- Depending on people’s answers, you can decide which questions they go to next.

Settings:

- You can collect email addresses of all respondents.
- Depending on who you want filling out the form, you might have to change settings so that it doesn’t restrict to only users within my organisations domain.
- You can limit to only having only one response.
- You can change it so that people can or cannot see other people’s responses.

Google maps:

Gerhards amazing example to use my maps:

We completed a Google form that answered these questions:

That data was then put into a spreadsheet. Using the add layer tool in mymaps, he added in the data from that spreadsheet which showed everyone’s favourite holiday destination.
Maps then downloaded this data and made pinpoints for every person and all their favourite places.

Ideas to use in the classroom:

Could be used to show where learners families are from
Could be used to show where learners have been over the holidays
Could be used before and after school trips
Once pins have been pinned on map, you can turn pins into shapes and measure angles etc
Can use for measurement of distances
Create a google form for example times tables - results will then be put into a spreadsheet
Create a form to get permission slips from parents

Tiles:

These tiles are so cool! They are connected to your phone and you can attach to things that you might lose often.

Google sheets

- To freeze my headers: highlight headings > view > freeze > 1row 
- To sort my columns: highlight columns > sort A-Z
- To resize multiple columns together > highlight columns and resize 1 row or you can do it manually 
- To find a total: click on target cell > find and click on the formula button on the toolbar and select SUM > select data range > Press enter
- The SUM will be repeated in each cell if you drag 
- You can hide/protect tabs/rows on your sheets 
- If I want to send someone just a copy of my documents add ‘copy’ to the end of the URL but make sure it doesn't say edit. can do the same for present mode
- Addon - split names - this will split the names of learners into first name and last name columns
- Addon - crop sheets - will crop my data and delete all other cells - useful for if sharing a document on a site etc 
- If i want to copy a list of names across to a new tab, put = into column I want the list >go back to the list and highlight > enter
- Conditional format rules > select cells you want to focus on > add rules 
- Add comments to specific cells > can tag people into that cell 
- Add a note to cells 
- Create a sparkline: =sparkline > highlight data > enter 

- To change title direction > text direction button > add border lines to columns Tip* change colour to grey so it’s not as harsh

- To change colours: Highlight data and format > alternating colours

This will be great to see their progress

Pixel art

Set up a new sheet > squeeze cells down to squares > get them to create themselves as pixels > geometry > measurement

Add checkboxes
Data validation > add in options for validation eg yes, no, maybe

QR codes

I have now downloaded a QR code converter add on to my laptop
If I select a sight I to have a QR code eg blog and convert into a QR code

How I could use this in the classroom:

If I put a book online into a QR code and hang it around the room, my learners will be able to scan and read.

How to make a GIF:

Download Giphy Capture from apple store

Data Analyse: 

I looked at a learners blog and analysed their views. This was the graph that I made about the views they've had from each country.