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:

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

Reading Intensive Programme - Session on Vocabulary & Decoding

  Yet again, another very busy but well-constructed session from the Research Team at Manaiakalani.  Vocabulary is the key to learning.  We kicked off by having a korero from Dorothy Burt on vocab growth being directly related to achievement.  Many of our learners start school on the back foot.  As schools, we have. the job of each child learning 8-10 new words a week, 700 a year and being able to use and understand these words in context.  We cannot leave the teaching of vocabulary and decoding to chance.  It needs to be planned for.  Students need to learn how to explore words - one exposure is not enough.  We need to raise children's (and our teachers) lexical bar and find the Goldilocks zone - just right to give some stretch and challenge to their learning.  There are four approaches to explicit vocabulary instruction.  These are: Build word consciousness Deliberate, robust teaching of words (affixes, base words, contexts) Skill...
Post a Comment
Read more