Profile cover photo
Profile photo
Warren Apel
1,003 followers -
I like playing with new technology to see how it can be applied to education. I'm a Google Certified Innovator (GTA UK '12).
I like playing with new technology to see how it can be applied to education. I'm a Google Certified Innovator (GTA UK '12).

1,003 followers
About
Posts

Post has attachment
Registration is open for Learning2 - it's the best annual learning conference in Asia, and there's always a lot of great workshops for technology coaches and IT staff. Early bird pricing ends in a few weeks, but if you want to reserve a block of seats for your school, you can pay the early bird pricing and then decide which teachers attend later. This is the first time Learning2 has been in Japan, so I'm really excited about it!

Post has attachment
Add a comment...

Post has attachment
Warren Apel commented on a post on Blogger.
Brilliant! This was exactly what I was looking for - a way to combine two columns of data into one column and remove duplicates. In case it helps other people I used Named Ranges first to make the formula easier to write. My end result looked like this: =ArrayFormula(unique(transpose(split(concatenate(FatherName&char(9),MotherName&char(9)),char(9)))))

Credit to Taz002 where I got the idea to use the Char(9) [tab] instead of " " spaces.
Add a comment...

Post has attachment
Sure, it's true that My Little Pony also referred to dreams. Maybe looking at all three quotes side-by-side will shed some clarity on whether it was plagiarism or not.
Photo
Add a comment...

Post has attachment
My favorite new Google Docs feature! Insert chart from Sheets into Docs. This is going to make so many teachers happy!
Animated Photo
Add a comment...

Post has attachment
Boxer Rebellion played a great set at the Paradiso North on Monday.
Animated Photo
Add a comment...

Post has attachment
This live-streamed hangout from yesterday is totally worth watching - +Sheldon Bradshaw explains the Writenowbooks.org project with +Marcello Mongardi, +Paula Guinto, +Maureen Cullen, +David Beaty, +ben sheridan, on the 16th episode of the Innovation and Learning Series. https://youtu.be/841kDEqcUz8
Add a comment...

Post has shared content
Geeking out with choropleth maps at the demo slam.
Add a comment...

Post has attachment
Highlights from my walking tour around Milan the day before #learning2
Add a comment...

Post has attachment
Foucault's pendulum, in the Pantheon, Paris.
Add a comment...
Wait while more posts are being loaded