Saturday, 1 July 2017

Homage to the Digitally Curious Colleauge

I have been thinking back on my experience of the last year as an Microsoft Innovative Educator Expert.  I have come a long way.  My confidence in new digital environments has increased and I realised a very important thing about being a digitally fluent don' t have to know everything there is to know about all the tools available to you in your kura, you just have to have the confidence to know you can work it out if you play around long enough.

BUT, it is quicker if you have a colleague to brainstorm with!

Enter (Stage Left) - Digitally Curious Colleague

Much of the digital world I try to get my head around these days has large components of collaborative capability, which are the ultimate digital tools for a teacher.  Having a curious colleague to help you explore it all means that one of you can be the teacher and one of you can be the student, nutting out all the useful tricks of the tool.  The Web must be littered with carcasses of old embryonic 'Test' files and accounts of collaborative digi-tools created by teachers and their digitally curious side-kicks.

Microsoft Teams is out and true to form, I have created a 'Test Team' and roped in 3 digitally curious colleagues to work out how it all works.  Another embryonic digital carcass in the making.  My colleagues go along with their role as side kick with enthusiasm, and helpfully answer all the internal dialogue questions I ask such as "Who can see this, I wonder if this chat stream is private?" and daft comments like "Ooo - it doesn't look like this turns up in my email feed".  My trusty, digitally curious side-kicks just join in the conversation.

On Friday, I was building a conference presentation with a colleague and had a need to ask this question "Is group blogging even a thing?".  Even when all curious colleagues nearby don't know the answer, there is always someone in world who has asked your digi-curious question before and what do you know?  I googled that question and came across an unknown digitally curious colleague who not only had the answer, but also published the important 'how to' information.   I worked it all out, joined my co-presenting colleague to the blog and hey presto, I had gone from not knowing group blogging was even a thing to starting and publishing a group blog in 25 min.

Some of my digitally curious colleagues have applied to become Microsoft Innovative Educator Experts and so it seems our time of  exploring digital tools together is set to increase.  My personal learning has been great as a MIE-expert over the last year but this learning would not have been as productive, as fun, or as expansive, if I had not had the privilege of working with my digitally curious colleagues.


Sunday, 30 April 2017

Decreasing Teacher Admin Workload with Office 365

The school term break in New Zealand is just finished.  I don't call it the school holidays...we all know it isn't a holiday for teachers as they spend it marking, writing feedback, preparing lessons, going to conferences to learn more, and in some cases, still teaching.  By the end of this week or certainly next week, teachers all over the country will be feeling like they are starting to count down to the next term break when they can catch up on all the jobs that are already beginning to build.

Decreasing our workload is really important. REALLY important.  We want amazing teachers to stay in the profession and we want to attract amazing teachers to our profession. 

Marking student work and giving quality feedback is a teacher task that is incredibly important and is an effective way of causing learning.  TKI - Effective Feedback webpage states that feedback is "most effective when given at the time of learning".  This means that amazing teachers prioritise this job amongst all the other jobs they have to do.  AND they prioritise it for each student they secondary schools, this could be 90-100+ students per teacher.

In the past we have used something like Word to write a feedback template which we photocopy and hand write for each student, stapling it to their papers or gluing it into their books.   Sometimes it is lost by the student and your access to what you wrote is certainly lost to you, the teacher, relying on memory when having further discussions with the student.

Microsoft Forms is an app in the Office 365 suite.  Most people think of setting surveys for their students to seek feedback, but you can also set a Form as a formative or summative test for your students.  Forms automatically analyses the results for you, and you can export the results cleanly to another Microsoft app, Excel.  In Excel you can print off the test for each student, you can re-visit their answers at any time and compare their progress over time. 

Microsoft Forms can also be used to create marking schedules.  You can complete a response for each student, even providing long sections of feedback when you need to.  Again, this can be exported cleanly to Excel and re-visited at any time and you can compare the progress of students over time.

Tips for marking schedules in Forms:
  • Make sure when setting the Form up, you select Multiple Responses so you can enter one response per student
  • Make sure the first question you ask yourself is "Student Name"
The very first time I used Forms for a marking schedule, it only took me 10min to set up and I now have that Form for the same topic next year.  So easy.

Wednesday, 12 April 2017

My grounds duty is IT-Drop In

Problem = offering one off PLD about digital tools to teachers is not effective because more than half of them can't keep up with the lesson, there is too much content, and teachers weren't given time to play with it and think about how it fits their classrooms.
Solution = offering teachers ongoing support much more often; what they need, when they need it
                   2nd Problem = IT staff don't have time to do this, not enough IT staff too many teachers
My version of this solution = "IT-Drop In" which is an allocated grounds duty

All teachers have duty in schools, designed to make the environment during break times safe for students.  All schools have those cushy duties where your relationship-management skills are not really needed, it is just supervision.  In my school, that cushy duty is the Library Classroom - a suite of computers the students can use at break time.  The students are so busy in their virtual worlds, they don't have time to annoy anyone in real world.

To make this a productive duty time I introduced IT-Drop In and in 2016 offered digital support to my colleagues during my lunch time duty slot.  In 2016 myself and another teacher offered 2 lunch times a week to our colleagues for help.   This year we have every lunch time duty in the library classroom covered by digitally savvy teachers and we are really beginning to create confidence in our colleagues to try new digital tools in their classrooms.

It-Drop In works because teachers don't need an appointment, they just turn up when they have a few minutes.  By offering it 5 days a week we can capture most of the teachers in the school and offer them a time that suites their busy schedules.  Teachers can come back as often as they need to and many come regularly, to get the next step.

We don't just help teachers, we help any student that drops by too.  Our aim is to increase the use of digital tools in the classroom and so it naturally follows that if the teachers begin to use digi-tools then more students will also need more support.

The most common requests for support are: 
  • Connecting BYOD devices to the wi-fi 
  • Accessing online lesson content the teacher has posted 
  • Sharing online content they have created with someone else, usually their teacher 
  • Navigating Office 365 and all the apps 
  • Understanding the difference between online apps and client apps 
  • Downloading the free Office 365 students have access to

  • Using and navigating the Office 365 online environment 
  • Creating and using OneNote or ClassNotebook 
  • Adding/Removing students from Onenote 
  • Brainstorming the best app to use for a particular learning situation 
  • Using Kamar (Kamar is our student management system)
  • Emailing the whole class using a group class email (which is populated from Kamar)
  • Setting up PLG groups in O365 

Students tend to only come to see me once or twice but teachers often return regularly for the "next step".  Students like getting that help when someone has time to help them, they often find the teacher in the classroom is not able to spend as much time with them or they have only done it once in class and have forgotten; just needing a reminder.
Teachers report an increasing confidence in giving something new a go because they know they can easily get help at lunch time if they get stuck.  Large learning curves are broken down into small learning curve chunks with help available at the next step.  This gives teachers the head space to think about how a particular tool could enhance student learning.

I learn new things too.  A teacher will brainstorm with me about something they want to do in class that I hadn't thought about.  We work out a strategy and digi-tool(s) together and I enjoy hearing about it afterwards.  Our IT staff are getting busier in some ways and less busy in others.  They are being asked questions that are utilising their tech-minds more and stretching their IT to learning knowledge.  Less often do they get requests for help about sharing digital content, setting up ClassNotebooks, printing etc. 
The teachers who come to IT-Drop In are spreading their new knowledge within their departments and digital knowledge is disseminating quickly amongst my colleagues.  I am starting to get teachers coming to IT-Drop In who have been shown something by a colleague and need the next step. Or... teachers say "____ is doing ___, how can I do that?"

Disseminating digital knowledge to teachers this way is a slow process but it is always at the pace of the teachers who seek it, delivered in a timely manner for them, and is able to be linked to class lessons quickly because it is a small chunk at a time, allowing for thinking  and processing time in the mind of the teacher.

Monday, 24 October 2016

Changing the Heart of Teachers of Māori Learners

After all, it isn't Māori learners who need to change, it is us.

Teaching with cultural responsivness - I thought I was alright at this, but it just goes to show, that we are never done learning...learning about ourselves, learning about others.  This is my ako.

These last school holidays I was fortunate enough to go in the place of a colleague to a hui in Wellington about embedding Tātaiako into our school. I thought I would be over my head, but it turned out to be just the perfect PLD I needed, right now.  It was run by TRCC and was THE best conference I have ever been to.  A big claim, I know, but there it is.

It began at Te Herenga Waka Marae with powhiri and yummy kai.  We remained at the marae all morning, surrounded by its visual beauty, sheltered by it in the Wellington rain.  The first session after kai was Toku Ao, where we each shared a taonga and/or kōrero of cultural significance to us.  It was emotional and heartfelt.  People shared their hopes, whakapapa, fears and joys.  A lovely Kuia shared with us the locatedness of the marae, explaining its kōrero, the poupou, and tukutuku panels.  It brought the Wharenui to life and as each poupou represented a different iwi in Aotearoa, we all felt connected, settled, truely comfortable in our welcome.  It was here that the best gem of the conference was spoken,
"You must bring all of yourself to your teaching and share it with your students before you impose your kaupapa upon them.  To do this, you must first know your own culture before you can expect to accept the culture of others."
I left the marae feeling very relaxed and connected to everyone in our group that shared Toku Ao.  I left the marae knowing a lot more about myself.

The rest of the hui took place at a local hotel in downtown Wellington.  We heard a kōrero by Hana O'Regan and she dynamically confronted us with the stereotype of being Māori, created out of law changes and infuences out of their hands; shaped by products of their time and by people who were products of their time.  We must strive to find many, many positive stories about local Māori successes and share them, often, with many people to counter the negative media and popular beliefs of Māori.  Her wero (challenge) was that,
"You are products of your time, a different time, and so it is you who must change the view of Māori, don't perpetuate the values and thoughts of an old time."

This is our time, we are products of our time, and so we must make changes and not accept the products of earlier times.

The final overwhelming reflection from the conference was a reminder on the last day when some lovely primary, secondary, and tertiary rangatahi were brave enough to stand up and speak in front of 120 kaiako, and share their wisdom.  Their kōrero was about what makes them successful, what good teachers do, what schools do, what parents and whānau do, and what they do for themselves.  The students spoke of their own apsirations, and those of their parents and whānau. Their kōrero was full of hopes that all teachers would expect them to do their best all the time and push each student for their best every time.  They asked that teachers didn't try to help them because they were Māori, but help them because they asked for help...and never give up on them.  This reminded me that,

"Our ākonga never come to class alone or empty of knowledge.  They bring with them a wealth of their aspirations, dreams, experiences, knowledge, values, beliefs, and culture."

Believing that students need filling up or that they come with nothing is how deficit thinking can take hold of teachers.  Ako comes from the teacher honouring the wealth students bring with them and accepting that the student knows a lot about themselves and their world, and we teachers know a lot about learning.  Imagine what is possible and the heights all rangatahi would reach if we teachers combined our wealth with the wealth of each student in every class...think of the richness of learning.

Monday, 14 March 2016

QR Codes as a literacy tool

Why would you want to use it in your teaching resources?

  • Most URLs are very long and students often miss-type them when entering them
  • Most URL addresses have_underscores in the URL and you can't see them in a printed resource because the underlining that indicates the section of text is a link covers up the_underscore
  • Students who are pre-literate or who struggle with their literacy can just scan the code and it takes it to the right place straight away
  • Senior students in your classes don't have time to fluff about typing in long URL addresses, and feel that there are much more productive ways to use their class time.

What is a QR Code?

What is a QR Code
This is a QR code - it is like a bar code and when it is activated, it will take you to a website or other kind of digital information.  now you know what this is, I bet you will see them everywhere.

You need a QR Reader to be able to scan one of these with your devices camera.  QR Readers are free apps you can download to your phone or tablet.

QR code generator

There are a number of free online QR code generators that work wonderfully.  I use this one  

How do you generate a QR Code?

Go to a free QR Code generator such as
  1. Select the type of media you want the QR code to take the person to, most of the time I choose the first icon of the world as I am usually linking a website
  2. Copy the location URL of your target website into the contents box
  3. DOWNLOAD or EMBED the qr code.  Note: If you save the code for future use, then give it a sensible name as they are impossible to tell apart by looking at them.









How would you use it in a resource for a class?

I always provide the URL and the Qr Code together.  Students using their phone or tablet will likely use the qr code, and students using a laptop or desktop computer will likely click on the URL link.  I often provide a paper copy of the task, but always an electronic copy to the students via our OneNoteClass or you could post it to your LMS or send it out as an email out to all the class.

Check out more cool ideas to do with QR codes here 


Friday, 1 January 2016

Looking back - planning forward


Our department.  The people working in our department at the moment have gelled.  They are energetic, sharing, and are willing to try new ideas by pushing their boundaries.  They support each other when you need a hand.  I am excited to work with them, I get new ideas from them all the time.

I published an article in the New Zealand Science Teachers' Magazine.  This took a lot more to write than I expected and the editor, Melissa, was enormously helpful.  It was about a teaching inquiry project I did in 2014 which was inspired by a young south Auckland man, Joseph Iosefa's, TED talk "Brown Brothers", combined with Carol Dwek's growth mindset ideas, and class of Y11 science students who struggled with learning.  Invisible borders  and barriers affect all of us and we all need to kick down our borders to find our purpose.

In 2015, I took this a bit further and used the ideas of breaking barriers with a growth mindset to tackle students' emotions around "doing maths". 
There are amazing teachers in this world.  They know their subject so well.  Hattie says Expert teachers can identify key representations in their subject, guide learning, monitor learning, provide feedback, attend to effective attributes, and influence student outcomes.  BUT Amazing teachers do more than that though.  Amazing teachers nurture the soul of their students.  Amazing teachers feed them lunch if they need to, they feed their knowledge, they feed their courage.  Amazing teachers are champions for kids.

Rita Pierson: Every kid needs a champion: TED talk  I love what this lady has to say.  You can know all the great knowledge about your subject you like, but if you don't form a good relationship, then they wont learn, if they don't believe in themselves, the wont learn.


Kids need confidence - I want to create a class that creates kids with confidence.  I can take a course on the Carol Dwek website called Brainology.  It will cost me $60USD.  I think that will be worth it.

I want to utilise Office 365 more.  OneNoteClassroom has some great changes such as embedding in Moodle etc, I want to do that as I use moodle a lot and all my resources are already in Moodle.

I want to help other teachers with their - a drop in help centre at lunch time for teachers and students will be good.  I can do this in the library classroom.  Twitter, blogging, Office 365, OneNote.

MakerSpaces.  I dabbled with this in 2015.  The tinkering sessions were less successful than the origami session.  Might be that not having a finished product in the time frame isn't appealing to the kids.  Would like to get some coding in there too...maybe we can do some app building maker spaces.  3D printer would be nice.

I want to continue to work with people who inspire me, doing things for kids that help them.  Words for 2016: brave, fun, laughter, new.


Tuesday, 27 October 2015

Excel Pivot Tables ('sigh of relief')

Oh, I am pleased for pivot tables!  They make your life soooo much easier.  I am not an expert on pivot tables or excel, in fact, I am an absolute pivot table beginner.  But this is pretty easy and worth the hour it has taken me tonight to figure out how to solve the problem.  It won't take you this long, because I have the solution right here!

My goal: I wanted to analyse the student success data from NCEA results that NZQA offers which is 2004-2014.  I wanted to find out if the changes I had made since becoming HOD of our department in 2007, had long term effects on our student outcomes.

I already had many years worth of NCEA data but made sure I had all of it.  I had to edit the format of the data to make sure it was uniform in format. 

Problem: to get the averages of % achieved, % merit, % excellence for each subject, for each level, for each year WITHOUT calculating it all by hand.  I figured it was worth spending time to find an answer because the alternative was going to take me hours and hours and be mistake ridden.

So I am writing the steps here as much for you as for me.  In January when I come to add the 2015 data, I want to remember how to do this.  You know how it is, you do these things once a year and then forget again by next year and have to spend that time figuring it out all over again.

By-the-way...I should also state that I am using Excel from Office 2013 but I know earlier versions have pivot tables but the details of the instructions might differ slightly.

Place cursor somewhere in data
INSERT Pivot Chart & Table - the dialogue box comes up
The data range selected all by itself
I chose where to put the pivot table, it can be in the existing sheet or another one
Click OK
The table appears at the place you chose and a 'chart' or graph appears too.  You can move the graph about later to a final spot.
CHECK in the list at the top date, subject, level, %A, %M, %E.  This all appears in random places in the bottom section.  Pick up the Date with your mouse and move it to the AXIS box, Put the subject and level in the FILTER box, and put the %A, %M, %E in the VALUE box. 
You can alter the mathematical function applied to the %A, %M, %E by clicking on it and choosing VALUE FIELD SETTINGS and selecting AVERAGES.  All the time you make these changes the chart will alter to reflect your changes.
When this is complete click the X in the pivot table wizard in top right hand corner and the wizard disappears to reveal the pivot table underneath.
You can select, using the filters, the data you want to see, it shows in the table and the change is reflected in the chart too.

If you have subject reports to write then you can copy the pivot table info and paste it into your report as PASTE VALUES and just the numbers pastes into your report, without all the excel algorithm bit behind it.

You'll have the swishest reports ever.  Happy days.