­
My best and worst IT lessons #6: Adorable spreadsheets — ICT & Computing in Education
  • Front Page
  • Search
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Search
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Suspicious enthusiasm? Picture from www.pixabay.com CC0

Suspicious enthusiasm? Picture from www.pixabay.com CC0

My best and worst IT lessons #6: Adorable spreadsheets

January 14, 2016

Unless you're a bit of a sad person like me, there is every chance that the thought of "doing" spreadsheets doesn't have you leaping for joy, extolling Life and declaring that we live in the best of all possible worlds.

So it was with some surprise that during a lesson in which I'd told Year 8 (approximately 13 years old) to crunch some sports data using spreadsheets, there was suddenly a real buzz in the room.

"Let's work out the average now!", shrieked one excited youngster.

"No, let's do a rank order!" her friend answered.

I thought to myself, "I didn't know kids would get so excited about cricket scores. I wonder what's going on." (I can be a bit slow sometimes.)

On investigation it transpired that some of the girls had decided that cricket scores were not the most rivetting subject in the world, and had instead decided to rank the boys in the class on attributes such as height, sense of humour, looks and so on, to try and find out who was the most desirable boy in the class.

The next thing I knew was that the boys decided this was a good wheeze, and did a similar thing themselves.

Fortunately, the end-of-lesson bell went about 6 minutes later, and in subsequent lessons neither the kids nor I spoke about this event.

It was difficult for me because I didn't want to encourage them to rate the opposite sex. On the other hand, they were not only fully engaged, but also using the formulae I'd given them properly, and discovering new ones for themselves (in particular the Index and Match functions to get a rank order).

What I learnt from this incident

I learnt two things. First, if you teach the subject properly then students will find little else in life as delightful as a Max, Average or Sum function.

Second, if the work you set is boring enough, the law of unintended consequences decrees that the students will probably find ways to liven it up a bit. Low level disruption like throwing a chair across the room I can cope with. But trying to explain to an Ofsted inspector why the kids are ....

Well, I still have nightmares about it.

In On the lighter side, Unintended consequences, Using and Teaching Computing & ICT, Best and worst IT lessons Tags spreadsheets, unintended consequences
Share
← Review of Thinking Allowed on SchoolingMy best and worst IT lessons #5: Modelling →
Recent book reviews
Backlist: The Written World
Backlist: The Written World

Writing was invented ‘only’ a few thousand years ago. It’s a fascinating story.

Read More →
Backlist: What I'm reading: Bounce
Backlist: What I'm reading: Bounce

What does it take to become an expert? And what can the Computing teacher do about it?

Read More →
Backlist: The Fourth Education Revolution
Backlist: The Fourth Education Revolution

The title of this book invites curiosity: what were the other three ‘revolutions?

Read More →
A book review for your English department colleagues perhaps
A book review for your English department colleagues perhaps

Some of these stories are so richly told, it can almost seem as though you’re right there with him.

Read More →
Review: Pen Names
Review: Pen Names

OK, so this has nothing to do with education technology, but we all read (I hope!). A very interesting examination of the pen names some authors have adopted, and why.

Read More →
Review: The Library of Ancient Wisdom: Mesopotamia and the Making of History
Review: The Library of Ancient Wisdom: Mesopotamia and the Making of History

There's a really interesting section in this book about how ceramic storage of data and information is probably the most likely medium to stand the test of time.

Read More →
A book review for your biology colleagues perhaps
A book review for your biology colleagues perhaps

The subject under discussion here is how human physiology has developed in different ways, in response to different conditions around the world.

Read More →
Review: Social Media for Academics
Review: Social Media for Academics

This book is very readable, and if I sound surprised that is because it’s not always true of academics!

Read More →
Quick looks: VIBE Coding by Example
Quick looks: VIBE Coding by Example

For the time being, this book is free in Kindle format.

Read More →
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too

Despite the relative paucity of immediately obvious National Curriculum links, teachers will find several of sections of this book to be highly engaging.

Read More →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved

Powered by Squarespace