Digital Fluency Intensive Day 7 - Dealing with Data

Another full on day. Forms, sheets, My Maps, data, data and more data.

My Maps was fun. And what a range of destinations we have in our sights. Ahhhhh! to have the holiday time (and money) to go to them all. In one of the classes I am facilitating in they are right into the Rugby World Cup. I already have in my mind a My Maps tasks to do with this hub of learners.



Sheets are such a versatile app. We use them for everything in our role as facilitators. My next learning is to link data from another sheet into a new tab I already have a target sheet in mind.

Forms are another versatile app and we use them lots for students to turn in links to work completed e.g. comments made on other student's blogs. Yes, we can see comments on our student's blogs by using Hapara, but once they comment on another student's blogs at another school and click Publish, as we do in Tuhi Mai Tuhi Atu, we have no way of moderating the comments from our end. So a Form is a great tool to use for this. I have the Form embedded in the class site so it is accessible for classes. An example is here. An if you embed the Response sheet as well then the 2 parts are together.

Analysing blogs stats is a great way to get student's into ownership of their blogs and to use Sheets as a visual representation of their blog stats.
I looked at Quasia's blog. Here is the number of blog posts over 7 years - the first year being the setting up of the blog ready for the following year.

Just found out I could embed the graph. So here it is embedded...

Thinking about Sheets, statistics and graphing the hub I am working is that is right into the Rugby World Cup could be using Sheets as the competition begins. They are in teams so a collaborative tasks would be a great way to explore Sheets and graphing.
When I did the stats for the number of visitors form countries I copied and pasted the data from the blog page of stats and then deleted the columns I didn't need. Much quicker way of getting the larger numbers into the Sheet rather than trying to remember and type in separately.