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.

Comments

  1. 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. A blog every day in the holidays -or just about. Good graphing

    ReplyDelete
  3. 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. 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. 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 ...

DFI Session 9 Ubiquitous & Google Educator Exam

"Whew!" is all I can say!!! The Google Educator Level 1 exam was intense but, as the screenshot image above shows, I passed.  Completing the exam was two hours, 58 minutes and 33 seconds of intense concentration, intense completion of tasks and a bit of googling on the side to find out how to do tasks I couldn't automatically do.  The parts of the exam that got my blood pressure rising to places it should never go were:  creating You Tube playlists filtering data in descending order in Google Sheets  The final thing to stump me was performing tasks in the Google Omnibox.  What the #@%& is the Google Omni box?  I asked my facilitator & was promptly told to google it.  I thought to myself through gritted teeth 'What the #@%& do you think I've been doing for the last seven minutes!!' After reading and watching YouTube clips I discovered that the Google Omnibox is just the search bar - something I frequently use!!! Anyway, r...

Reading Programme Intensive: The Pilot Group # 1 Reading is Core to Learning

Our awesome design team at Manaiakalani are working on designing a common practice reading model.  Although I am part of the pilot group who is critiquing and reviewing the content and experience I am completing this reflection as if I am a teacher - moreover, a newbie teacher. Our WHY for doing this is equity for learners, especially those from disadvantaged homes, to increase teacher effectiveness and accelerate learning outcomes.  We want to grow reader self-efficacy - to have a big push on learner engagement and motivation.   Today we had a mini dive and overview into the Manaiakalani Reading model.  We covered the background & findings from longitudinal research that led to this being developed.  The model is a cyclical plan that is ambitious and it begins with planning and finishes with sharing. In terms of building my capability and confidence in teaching reading, I now realise the importance of being ambitious in my planning.  I also need t...