Thursday, 21 March 2019

Keynote Fraction Animations

A really boring title I know, but this activity was lots of fun and was a great example of learning and understanding concepts rather than just knowing answers.

We are studying fractions in grade 6, in my experience students often know shortcuts and tricks to do equations with fractions

While this approach gives them an answer it doesn't promote understanding, rather it focuses on answers. I am much more interested in students understanding a concept rather than knowing an answer. Often they don't understand what the equations actually mean and written explanations are complicated and confusing.

There are lots of great visual examples online and sites like Myimaths have animations and videos explaining what is actually happening when you add, subtract, divide or multiply a fraction. While these sites promote understanding and make it easy for students to see what it means to solve equation problems, I prefer making my own or even better get the students creating their own fraction animations.


Keynote Fraction Animation

To achieve this we used Keynote and added actions to a variety of shapes and text boxes so that students could create their own fraction animations. About half way through the activity I remembered magic move and that made things so much easier.


Magic move compares one slide to the next, takes note of any changes and then animates the changes. You can easily duplicate a slide, make some changes and turn it into a nifty animation in no time at all.

Here are a series of videos I created on how to make your own fraction animations the first two use regular animations and the second two (multiplication and division use magic move)

Adding Fractions
Subtracting Fractions
Multiplying Fractions

Dividing Fractions

What I really like about this activity is that it is hard work, the students really need to think about what it means to perform operations on fractions. What does it mean to add fractions beyond a set of rules.

They look at fractions and operations in different ways, work backwards and need to problem solve to make their animations reflect what is actually happening when performing operations on fractions.



Monday, 11 February 2019

Make your own Random Google Sheets worksheets

I finally found a use for Macros

A couple of months ago I started playing with Google Sheets IF Formula and RANDBETWEEN to create interactive google sheet Maths sheet, this was essentially a drill and practice activity. I wanted my students know how to do this and create their own drill and practise activities. The idea was that the students could create maths worksheets that have a random selection of the numbers in the equations.

It was easy enough to set up a sheet using predetermined number and the IF statement to check if the students had the correct answer or not. I added some colour and extra formatting using conditional formatting. I then used COUNTIF to count the number of correct answers. It was all starting to look pretty and come together. Then I introduced RANDBETWEEN to make the numbers random to gamify and increase the longevity of the sheet.

The only problem is that when you use RANDBETWEEN anytime a change is made to the worksheet a new random number is generated. that means when an answer is written the numbers that make up the equation change.
Bitmoji Image

I searched online, checked out add ons, tried pasting values, but couldn't find a way to make the random numbers stick, I started playing with Macros and was almost there when I got distracted by some other bright shiny thing. Someone showed me a few websites that do this automagically. Which was OK but not as good as the students creating their own.

I had put this in the back of my mind until yesterday someone in my PLN on twitter asked for some free drill and practice websites that he could give to the teachers in his school, I suggested getting the students to create their own using Google Sheets, the IF formula and RANDBETWEEN. He reminded me of the issues of the constant changing random numbers. I got back to work.

I created a series of ten random numbers in ten cells (H3 to H12),
I then recorded a Macro that copied the ten cells and pasted the values only into the cell next door. A Macro allows you to record a series of steps or activity that you want to do over and over again on a Google Sheet, it then turns those steps into a script, which you can then run and it will do them for you.




















Often to run a script you need to use the tools menu.

But you can also add a script to a Google drawing, so I created a button to randomise the numbers when a user clicks the button the script runs. 

Essentially when the button is pressed the script runs, ten random numbers are copied and their values are pasted into the cells next to the random numbers. Because I used paste values only, it doesn't matter how many time the original cells change those numbers in cells I3 to I12 wont change until the button is pressed again.

I then use those values (I3 to I12) to populate my tables test. The Random numbers stick. I hid the columns with all the data so all the user sees is the equations and a button to change the numbers.

I can the use COUNTIF to calculate the number correct and put that as a fraction on the page.

My next step is to work out a way to time how long it takes to complete the equations and add a super cool pop up message when the user gets 10/10.

For your very own copy of the Google sheet to see all the formulas and play with click here

Wednesday, 6 February 2019

Turning lego into an AR experience

Wind them up and let them go

I have a bit of a reputation around school as the VR and AR guy (I don't know why?) so it was no surprise when a grade 10 student came to me asking for help with his MYP Personal Project. He was in a bit of a panic and sent me this email


He had created several Lego models of buildings in Kuala Lumpur in the Lego Digital Designer program. He has examples of old style buildings and new buildings. The problem was that the Personal Project Exhibition was fast approaching and he didn't have time to order the bricks and build his model. He was hoping he could turn his model into an AR experience.

When I met him I checked out his models (he had put a lot of work into them) then explained that I didn't have a clue how to turn these models into AR. 

We sat together and started searching online for possible solutions (it was a strong example of me being able to model my searching techniques and show me being a learner) after a rather tedious and long search, we came across this post AR augmented reality Lego. There were some sketchy details of how to do it.

We played and finally worked it out
  • we had to open the .lxf (lego digital designer) file in the Mecabricks.com website
  • download the file from Mecabricks as a .stl file
  • on a computer download the edrawingsviewer app and open the .stl file
  • save the edrawings version as an .eprt file
  • download the edrawings app on an iPhone
  • transfer the file to the iPhone (the files can be rather large) open the file in app
  • using the downloadable mat from the website bring your model to AR reality
The effect was pretty cool, you could walk around it, zoom in and out, it was AR, while it took a while we did it. The only real issue was that is wasn't a colour version and we needed the mat. The student went away pretty happy. As the AR guy I was feeling pretty chuffed with myself, as per usual when you start getting over confident a dose of humility soon follows.

The best bit

A couple of days later I got this email from the student.
Hi Mr. Derry,

I have been playing around with the different formatting when exporting the files as I had found out that the .stl format takes all the colours out (which was the main problem). After looking through a few ways - I have successfully transferred both my buildings from the Lego Digital Designer, into AR, with colour (it doesn't even need a QR code!). I found another website which supports 3D modelling called Sketchfab, and uploaded the files through a .dae format from Mecabricks, and got Sketchfab on my phone as well, which allows it to be seen in AR and VR. I have attached all the pictures of how they turned out. 

I am very excited to show you everything in school soon (perhaps in innovation tomorrow right after break time), and would like to thank you for all the help you have given me. I wouldn't have managed to pull this out without it! 

Have a great day,
Jordan. 


On his own, he found another way to do it, a better way with colour and no need for a mat or a QR code. You could even go close up and inside the AR model and check out the interior, something you couldn't even do in real life. This is what I love about empowering students with technology, as a teacher I showed him a thing or two and showed him how to search and what is potentially possible. He then took this knowledge and skill and built on it.



I like to call this "wind them up and let them go" get them enthused and excited and watch what they create.

I love doing this with programs like Scratch and GarageBand, just the other day after showing all the grade 5 students live loops,  I had a grade 5 student say to me "Mr D I love live loops in garage band on my iPad. I can't stop playing with it, my parents don't believe I am making such cool music".

We are also doing this in a big way at school through our innovation time, which is 2 blocks per week (the same as every other subject) of passion project time in secondary school, we certainly are winding them up and letting them go. That is a whole other post and we have some great examples to share.

Long may schools and teachers empower students with knowledge, skills and the time to explore their passions.

Friday, 18 January 2019

Everyone can Create - silhouettes


I recently was asked by Apple to run an everyone can create workshop during the latest “Kuala Lumpur Innovation at schools session”. The theme was student agency, but the team were also keen to have some sessions on the everyone can create books.


I had been reading and using the everyone can create photos book and have been doing some of the activities with my own kids at home and thought it would be a great opportunity to share some of the activities in the books.

We looked at techniques and strategies to empower students to take 'good' photos with iPads. We looked at variety, perspective, details, the rule of thirds and Backgrounds. Dave Caleb's book Stories through the Lens was a super resource for this.

We then explored three of the activities from the everyone can create book - photos including telling photo stories, pictorialize your name and silhouette portraits. It was very hands on, was well received and we had some discussion on how we could use these activities in our classes as soon as we got back to school. Here is a link to the participant created padlet of ideas.


The silhouette portraits is my favourite, I loved using it with my own kids. Seeing as though I was presenting on it, I thought I better try it with some students at school. The next time I had my grade 5 cover we started exploring creating our own silhouette portraits. 

Only using the class iPad's we took profile pictures with a plain bright background, basically we were doing the thing I have been telling my IGBTV students not to do "Don't video with a bright background as you can't see the person being filmed". By doing this we got side on images that we could edit and play with (crop, turn black and white, change the contrast, explore different colours) all using the edit button in photos.

I then took this to the next level, by combing this with another activity from the book. We imported our images into Keynote and then applied Instant Alpha to completely remove all of the background.

Once we did this, we used the add shapes option in Keynote to get the students to add their favourite things to their silhouettes. 

You can search via the magnifying glass and change the colour of the shapes / images, they are also all free from copyright and allow the students to be super creative.

The kids loved personalising their images.


I showed them how to export them as new images and we had a silhouette gallery of all the students in the class and their interests.


The students had lots of fun identifying each other and seeing other peoples interests. We got some insights into the students that we weren't expecting. It was a great way for the teachers to find out about their students and we got a few pleasant surprises. 

As they played with Keynote and shapes the students started exploring different ways to add images they worked out some pretty cool stuff including how to add graded backgrounds and create multicolour and image filled shapes.

The students now have ready made silhouettes that can be used over and over again for a variety of activities. Including
  • Exit Tickets
  • End of unit reflections
  • Brainstorming sessions
  • Guessing games
  • Poetry (reverse the colours and fill the silhouette with the poem
  • Fill the head with a maths problem and solution
  • Class displays 
  • Add their artwork to the silhouette

The limit is your creativity

We can't wait to explore some of the other activities in the everyone can create books.

Thursday, 17 January 2019

Save paper and time with Google Drawings

Creating Google Drawings worksheets


I found this great Factors and multipliers puzzle online here

It's one of those activities where students (or teachers) have to cut out all the bits of paper (right hand side) of the sheet. That means cutting 25 numbers and 10 headings. They then manipulate them on the puzzle sheet until they get the right combination. It is a hands on activity and encourages students to use a variety of problem solving techniques and think about different types of numbers.

When we did it in our 80 minute maths block, many of the students took more than 20 minutes just to cut out the bits of paper, (some took 60 minutes) then bits of paper went missing or were blown around by the fans and air conditioning. A couple of students finished, but then it took for ever for them to glue them in their book. Once the lesson was over, we then had to find a way to store the hundreds of bits of paper.

Rather than being the wonderful learning opportunity it promised, it ended up being an exercise in frustration. 

In hindsight it would have been better to make it a group activity and do the puzzle on A3 paper or spend hours cutting them out and laminating them for the students. Who has time for that? 

Then I got thinking, I could save a lot of time, paper and anguish by turning this activity into a digital Google Drawings worksheet (I hate the term worksheet). It will take me a bit of time to set up, but once it is created I will have a permanent version that can be used over and over again and I would rather spend my time playing with Google drawings rather than cutting out bits of paper.





The whole process took about 12 minutes,I sped the above video up by a factor or 8 so you get to see it happen in just over a minute

I started by creating a 5x5 table, then added rounded shapes for the headings, if you create one shape and format it exactly as you want it (Shape, colour, font etc) then it is easy enough to copy and replace the text. I then did the same for all the number cards.

Once I made my worksheet I could have grouped all the objects together (so that students couldn't accidentally move the tables and heading etc) but in Google Drawings I find it is easier to take a screen shot, delete the other images and add the screenshot as a single image.


Once the Google Drawing worksheet has been created it is then a matter of sharing it with your students I like to use a force copy link (I like to use Sir Links a lot) so each student has their own copy, the students can then move the shapes around to solve the puzzle. They can rotate the shapes and move them. Do pretty much anything they can do with a paper copy (plus a fair bit more).


No wasting time cutting paper or gluing tiny bits of paper to a sheet, no worries about losing or storing tiny pieces of paper. The puzzle is stored on the students drive. 

You can share different versions for students at different levels. e.g. perhaps one version with the labels in the correct spot or the labels facing the correct direction or half the numbers in the correct position or some blank tiles. It offers lots of scope for quick differentiation, make a copy of the drawing then make the change, make another copy, make the change.

This technique works for lots of different worksheets and once you have created the resource, you have it forever and can share it or use it again and again.

The next maths lesson I used the Google drawings version and the kids completed it much quicker with less stress and we were able to have those valuable discussions about problem solving techniques and how different students solved the puzzle. I am now making many more digital worksheets for my Maths class.


Friday, 30 November 2018

Learning 2 it's true it is all about the learning

In 2010 I had just started teaching overseas and was based in Suzhou (just outside of Shanghai). I had a job as the Middle school Tech integrator. I had only been at the school for two months when the school had the foresight to send me to Shanghai for Learning2.


I had attended large edtech conferences in Australia, but they were the usual keynote speakers and workshop type conferences nothing innovative, new or exciting. Learning2 was different, I was placed in a cohort with people in similar positions to me (great for networking). There was also plenty of time to network and the quality of the workshops was second to none, (I even got to meet some of my edtech heroes) with some really big names and the unconferences were completely new and intriguing. It was conference like no other and upon leaving I thought I am going to the next one no matter what (and hopefully bringing some more teachers with me). It was worth going just for the networking.

I was lucky enough to attend the next 6 learning 2's and presented a variety of 1 hour workshops. I missed Learning 2's return to Shanghai in 2017, (I had already spent my PD budget and had a few other goals that year.

In 2019 applied to be a L2 Leader and was fortunate enough to get the call up. This was something I was keen to do since attending L2 2012 in Beijing where 2 hr extended sessions were first run and the workshop leaders gave pecha kucha talks. At each L2 since then I thought I would love to be up there in front of a large crowd and give a more in depth workshop.

After being a tech coach for 8 years overseas (and a few years in Australia before that) I had presented at a heap of conferences, workshops and school events and had even given a 12 minute TED style talk to over 1800 Heads of schools at the IB world conference in Singapore. I had ticked a few boxes and was a fairly confident presenter. Regardless I was still excited to be a L2 leader and I was going to Japan. I knew the calibre of the sessions and the rigour of the L2 talks.

From my first acceptance email, this was different, I had to sign a contract and commit to a process (including a three week online training course) rather than just showing up and running a one or two hour session. The organisers were constantly in contact and the whole process was super professional.

I had a fairly good idea of what my extended session (AR and VR creation tools) was going to look like. I had done my Google Innovator project on this topic and had already presented at Edtech summits, 21CLHK and the AIMS conference in Malaysia on exactly this topic with good feedback. I also had a couple of ideas for a L2 talk.

Then the pre conference training started and everything changed.


I loved the fact that my preconceptions were challenged and that I had to clearly articulate a set of goals and objectives for my extended session. It made me rethink things and empathise with my learners (that people who would attend my session). The three week online course also allowed me to get to know the other leaders and revisit was L2 and adult learning was all about.

I already felt that I was better prepared for my session than any other workshop I had ever run. Part of the process of being a L2 leader is that you spend a couple of days before the conference starts training and refining your presentation and talk. I was looking forward to working with some super professional coaches and picking the brains of people who know what they are talking about.


The onsite training and planning time was like nothing I had done before, having time to practice my L2 talk and to work with other educators hearing what they were doing and watching them prepare, share and collaborate was one of the best learning experiences of my teaching career. Everyone was focussed on the conference and how to make it great for the participants.

The social aspect was also second to none, a great opportunity to catch up with friends and meet new and dynamic people in a relaxed setting helped build bonds and foster new friendships. I was already getting so much out of this conference before it even started.


Once we did start I felt confident, ready and couldn't wait to get my participants playing with and creating their own AR and VR experiences and I felt like I was giving them a variety of tools and strategies they could take back to their classrooms straight away.

My first two and a half hour extended session went so quickly and it was refreshing to not have to rush through activities and give the participants time to explore, play and create.


Even better though was that an hour after we finished we had in our hands the feedback from participants and the L2 leaders as a team debriefed our sessions and shared successes and failures in a safe environment with the sole purpose of improving ourselves. Like having time before the conference to acclimatise and prepare this immediate feedback and debrief time was new for me and was probably the most valuable part of presenting at the conference. Other times I had presented I might get a spreadsheet back a week later with some scores and ideas on how to improve, not as useful as the immediate L2 feedback and debrief.

Then I got to do my new and improved session again acting on the feedback, although it must have been OK the first time because I had a few people come to me and ask if they could sneak into my second session because they heard from other people how good it was the first time round. Needless to say my feedback scores were even higher the second time.


Finally it was my turn to get up on stage, My L2 talk had been chosen to be done on the last night as part of the closing, talk about pressure. I really couldn't relax and unwind until I was all done. I was nervous as could be, but still had a heap of fun presenting and enjoyed the fact that I had opportunities to workshop my talk and even practice on stage before I did it.

(photo credit to Dave Caleb - a fellow L2 leader)

I got some good feedback, had lots of fun and learnt so much about myself as a learner and presenter.



The entire process (and yes it is a process and not just an event) of being a Learning2 leader was one of the most valuable learning experiences I have had as an educator. Simple things like making a video to advertise my session helped me to clarify my thoughts and ideas. I also had a blast and made a heap of great friends.

It is true that Learning2 is all about the learning.

Tuesday, 4 September 2018

Google Innovator (still working on it)

It has been a year since the Sydney 17 Google Innovator Academy and talking to many of my fellow #syd17 alumni the common theme is that things are going slow. Honestly the same is true for me, although in the last couple of months I have managed to get a bit of momentum.


A couple of things have happened to help get me moving including

I have led teacher workshops at various conferences on how to get students creating AR and VR experiences, including 21st Century Learning in Hong Kong, the AIMS conference in KL, an apple innovation day as well as teachmeet KL and staff meetings and PD sessions here at school.


I was also asked to speak at the IB Heads world conference, just a small group of 1800 heads of schools and teachers from IB schools all over the world.



The most important thing I have been doing is testing out ideas and lessons with real life students here at school. I have been pushing AR and VR, especially AR and VR creation as an alternative to posters and wasteful paper displays that get pulled down a week later and can't be shared or stored for other people to see in the future.

We have had students playing with VR and AR all over the school including
Early years students using a merge cube to hold a beating heart or a brain when learning about body systems



Grade 3 students using Metaverse to create interactive AR experiences about a body system they have researched

Grade 4 students have been using Google Streetview to explore different cities and communities around the world

Grade 5 students have been using Google Expeditions to explore the effect that humans have on the rainforest

Grade 5 have also created AR and VR experiences for their PYP exhibition, several students used Metaverse to create AR experiences including a bullying simulation where participants were given scenarios and they had to decide what to do. Other students use roundme.com to create their own VR experiences, mostly to increase empathy and show their understanding by creating VR tours of the ocean and the rainforest.

In secondary school we have been using AR and VR in design classes, students were given the design problem of creating an AR or VR experience for someone at school. We explored several tools for creating VR and AR experiences including roundme.com, metaverse, creating 360 videos hosted on youtube and cospaces. (Google expeditions tour creator wasn't yet released)

The students created some incredible experiences including


While none of these are perfect or even in a format that can be published (yet!) they are a good start and the students came up with creative ideas. I even had several students teach themselves how to use the unity game engine to create AR experiences.

Now that Tour Creator has come out of beta, we have started playing with that as a student creation tool. I have some projects for students in mind and can't wait to get back into it.

My final product for my Innovation Project is my edu-create.com website, which is a selection of creation resources for teachers and students, including a database of students submitted experiences where students, teachers and parents can showcase all the cool things they have made using VR and AR. It is still being built but I hope to have it up and running before the EdTechTeam Singapore summit.



This should prove to be a great resource for teachers to get ideas on how to get students creating AR and VR experiences and a place where students can showcase the incredible work they are doing.

On the weekend I watched the Innovation Program Sydney Cohort showcase
And this really got me motivated to finish my project and get this thing running.

While watching this one of the things that stuck with me was when Les reminded us to fail often and fail fast, that is something I haven't been doing I have been living with the fear that maybe my site won't work, no one will use it, someone will do it before me. That is going to change now, I am going to get this site up and running and if need be I will fail, very fast and then innovate and modify and try it all again.

Watch this space.