Essential Spreadsheet Formulas for Teachers

Spreadsheet formulas for teachersSpreadsheet formulas are essential knowledge for teachers. Whether you’re using Microsoft Excel or Google Sheets, its likely that you’re going to number-crunch some data using one of these apps during the academic year. They both come pre-loaded with a dizzying amount of formulas that you can tap into. Most you’ll never use (unless you decide to leave the teaching profession and become an accountant) but there are seven essential formulas that will help you get the most from the those exam analyses and baseline data tables. Whether you’re new to spreadsheet formulas or need a refresher, here are the most useful formulas teachers will need to use…Read more…

School Email: 9 Top Tips for Teachers & Students

school emailStaff and students are expected to be fully conversant with school email. Not only do users need to check their email regularly enough so that they don’t miss important announcements but they also have to understand and apply the complex landscape of netiquette, respond to emails quickly (and politely) and action any instructions that they receive. Being on top of your email inbox has never been so important in schools. So why, whenever I help a member of staff or a student, do they have an email account that is bursting at the seams with often more than 1000 emails in their inbox? It seems that how email is managed in schools is, well, often not managed well.

The following list of 9 top-tips could make your use of school email even easier, more efficient and slightly less stressful. The following never gets taught to email users. Why? I’ve no idea as my suggestions are key to ensuring that school email users are getting the most from this core communication tool.Read more…

Display Boards 2.0: Upgrade your Classrooms with Augmented Reality

Example Classroom Noticeboard (courtesy: http://mariya2387.wikispaces.com/)Over the years, I’ve spent countless hours putting up displays in classrooms and corridors. Unfortunately, I’ve never actually seen anyone stop, read, and enjoy the content on any of my boards. I’ve also grown weary of that pesky small tear that inevitably appears in the bottom corner of my boards, which rapidly spreads like a crack in a car windscreen, due to students picking at it or the careless brushing of chairs and schoolbags against it. I’ve tried so hard to get a ‘wow-factor’ display every time but I fear that boards are so ubiquitous, they are lost among all of the other classroom and corridor display board offerings.  If I were to be really cynical, I’d say that display boards are not for the students at all but to merely make schools look attractive for Governors, prospective parents and alumni.  Whatever the reason, it’s time to upgrade those 2D display boards and bring them to life with Augmented Reality!

Read more…

Pokemon Go (and never come back?)

img_3510Pokemon Go is everywhere. It’s been in the news, discussed and dissected in blogs, highlighted as an e-Safety concern for children, advertised in Churches, created additional workload for emergency workers, provided work for ‘professional‘ Pokemon Go hunters and has helped discovered a dead body. Oh, there’s even some people playing it. The summer of 2016 will be remembered for, technology speaking, the release of Pokemon Go. I haven’t heard this much fuss about an app since, well, the last big app.

Whatever your thoughts about Pokemon Go, it has certainly caught the imagination of young and old, male and female, technophiles and technophobes everywhere. Now that it’s been downloaded more than 500 million times, the simple question is “was it worth it”? Did all the debate and endless speculation about the game just encourage more people to download it? Did its innovative use of Virtual Reality really change the gaming landscape forever? or will it be another Angry Birds, a highly successful game that quickly lost its appeal? Read more…

Olympic Virtual Reality: Rio in 3D

Beach Volleyball in Virtual RealityDuring the 2016 Rio Olympics, the BBC are broadcasting a number of events, live, in 360° Virtual Reality. Fancy a front row seat at the Olympics? Want to immerse yourself in the fun and excitement of sitting with the crowd? Interested in testing a new way of experiencing sport? If your answer is “yes!” to any of these questions, join me this summer while I test this service during the Olympics. I’ll report my findings on this blog later in the summer. If you are interested in this experimental Olympic Virtual Reality service you’ll need some equipment…Read more…

Flipping puzzlED? EDpuzzle is for you!

edpuzzle-logoIf you’re a teacher then I suspect that you will have asked your students, at one time or another, to watch a video on YouTube. We all know it’s a great place for resources but using it for homework tasks comes with problems. How can you prove that a student has actually watched the video you’ve set? How do you know that they carefully watched the video and didn’t just give it a minimal amount of attention? Or, worse, they just pressed play and then walked away (or got distracted by other more interesting looking videos?). There’s never been a way to ensure that the video you have set as homework is given just as much focus as some traditional paper based homework task. I’m pretty certain students love it when teachers set them a ‘watch a video’ task as part of their homework. No writing, no test and an sanctioned opportunity to get online (where so much procrastination can take place!). Watching a video often doesn’t seem like ‘real’ homework to students as it’s too easy to complete and similar to their normal online activity. Parents may also object to the ‘watch a YouTube video’ as homework. To them, it may not seem as academically rigorous as researching or reading and then writing findings in an exercise book. Step forward EDpuzzle, a great video flipping tool which ensures that your carefully sourced and vetted video is not just watched but is also interactive for your students.Read more…

Gullibooking: the Fever of Facebook Fiction

Don't Panic: GullibookingGullibooking. My Facebook feed is full of it. If you use Facebook then you’ll be familiar with it even if you’ve never heard or noticed it. It’s extremely tall, lighter than a nano-atom, a curious shade of beige and quite possibly hacking into your bank account and ordering 25 copies of Fly Fishing, by JR Hartley, right now. Worried? You should be as fluffy cats, all fast food outlets and quite possibly Donald Trump’s pet guinea pig are all at risk if you don’t take note right now! Gullibooking – it’s all a load of…Read more…