Skip to main content

DFI Session 7 - Dealing with Data

Today we've had a deep, but very quick dive, into google forms, google maps and google sheets.
I'm pretty comfortable with using google forms & have previously used this app.  I've recently made the shift to google sheets from excel & have been using basic features for my own purposes of data analysis.  My new learning today was pivot tables.  These will be useful for organising data in different ways - particularly if there are selected points of interest to analyse & interpret.
I'd never used MyMaps before.  We completed some simple exercises of pinning locations, using the measuring tool & uploading data from a google form database to the map.  The teachers in our group may find a fun use for this with their classes.  As for me, maybe I'd use it for tracking or measuring personal travel.  Time will tell.

Here's the map I created.  The pins show my DFI colleagues best holiday destinations.  I've also pinned my school.

After lunch, we took a look at children's blogs and how the data from posts and locations etc can be analysed and displayed. I looked at a student from Point England School's blog post data.  The graph below, that I created on google sheets, shows the monthly data thus far.  From looking at this graph you can tell that this student took part in the Summer Learning Journey - he had 29 blog posts in January - a very impressive effort for the young fella!!



I'm going to have a go at adding some gadgets - the first being my fellow DFIers blog urls.
Let's see how this works out.

Labels

Labels:

Comments

  1. Cathy RowellSeptember 5, 2019 at 7:16 PM

    Great going Perky!! Going to use the map and look see where everyone favourite destinations are...then find some PD there and suggest we go! Like you I also can see the benefits of the google forms and think they would be great to use with our more senior classes! Only one more DFi to go before the exam...am sure you will do well as you seem to be able to confidently do most digital things!

    ReplyDelete
  2. Willie Y GBHSSeptember 5, 2019 at 10:30 PM

    A blog every day in the holidays -or just about. Good graphing

    ReplyDelete
  3. Cheryl @ ManaiakalaniSeptember 5, 2019 at 10:42 PM

    Kia ora Perky,
    Pivot tables is the next level - good on you. They do make accessing and analysing data easier.
    Looking forward to seeing the gadget added onto your blog.
    Cheryl

    ReplyDelete
  4. AnonymousSeptember 6, 2019 at 12:06 AM

    Love the 3D graph work, very nice! Good luck with your gadgets.

    Thanks for drying the dishes! Always some quality conversation in that petite kitchen.

    ReplyDelete
  5. AnonymousSeptember 19, 2019 at 3:18 PM

    Kia ora Perky,
    I always enjoy your upbeat blog posts.
    Glad you made the shift to google sheets. I find that with add ons you can do anything you could do previously in excel. And you have the sharing functionality; so much easier than multiple versions.
    I like that someone put Israel in the holiday destination map. A fascinating place. We will have to compare notes at some point.

    Regards,
    Maria

    ReplyDelete

Post a Comment

Popular posts from this blog

DFI Session 1 The Principal Becomes the Student

The Principal Becomes the Student I've previously dabbled with the Google suite of apps and used Google Drive out of necessity in my professional life but to be honest I still feel more at ease and in control using Microsoft Office products to create.   Today's first DFI (Digital Fluency Intensive) session had moments "Whoa! Can I keep up?" and "Yeah, I've got this!"  I have to say that in this first session I have learned truckloads & today's day out of school has not felt like a chore. Here's a few of the things that Dorothy Burt, aka Mrs. Manaiakalani, has put me (and my esteemed colleagues) through in our very first DFI session: 1. 'Marie Kondoing' our google drives.  Yes, these are in desperate need of a tidy up and reorganization.  It will make life simpler, faster & easier.  Make folders, colour code & have calendar years on them.  Simple!!! 2.  Useful tips and tricks.  This included keyboard short ...
4 comments
Read more

DFI Session 6 Computational Thinking - Unplugged & Hardwired

Today's little ripper of a session was at Tonui Collab (formally Mindlab). We've had a great day exploring, hands-on, digital technologies. Our morning kicked off with Dave Winter, the Manaiakalani Programme Outreach Co-ordinator, presenting on the Visible component the Learn, Create, Share pedagogy.  Visible learning through digital affordances opens the door of the classroom and the learner to whanau, professional colleagues and further afield if desired.  It also means that learning is re-windable.  Students can catch up if they've missed something or if they need to revisit learning.  Visibility of learning can be found in class and individual student blogs and through the google sites spaces that teachers set up for learning.  Students can find what they need for learning within a couple of clicks.  They can find exemplars of the learning, instructions, rubrics, information, learning tasks etc... (if the teacher has this set up for them).  Da...
4 comments
Read more

DFI Day 3 Creating & Collaborating

Today's session gave us a crash course on multi-modal learning and use of Google sites. As teachers. this is directing us into the CREATE aspect of the Learn, Create, Share kaupapa and pedagogy of Manaiakalani. We had a look at other teacher's examples of multi-modal planning & learning platforms.  These were examples of google docs with hyperlinks to resources, learning activities & video clips, etc...  The next stage was funked-up versions of these that way more visually appealing.  This is where teachers would have a class site.  Their learning was visible & accessible 24/7.  Class sites can have a page (or several) dedicated to the particular learning area or learning theme/context.  This can be kids one-stop-shop for information (LEARN),  & learning activities.  (Create & share). As a principal, I need to think about how I can use these tools & the pedagogy in my leadership.  For now, I have dabbled in the c...
3 comments
Read more