Profile cover photo
Profile photo
Warren Apel
1,024 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,024 followers
About
Warren Apel's posts

Post has attachment

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.

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

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

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

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 

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

Post has attachment
Highlights from my walking tour around Milan the day before #learning2

Post has attachment
Foucault's pendulum, in the Pantheon, Paris. 

Post has attachment
Wait while more posts are being loaded