ICT & Computing in Education

View Original

Spreadsheets: vindicated at last!

I’ve long been an ardent advocate of spreadsheets. They can be an invaluable tool in business, education or any other field in which planning, cost or both are paramount. As far as Computing and ICT is concerned, they can be used for teaching  modelling and computational thinking. However, they have been denigrated as being “just” an office tool, far removed from the exciting world of coding or robotics.

Well, apart from the fact that spreadsheets can be exciting and an enjoyable way of problem-solving, in the real world spreadsheets are still very much in demand. In fact, in most businesses, “spreadsheet literacy”, to coin  phrase, is almost certainly more useful than “coding”, and a recently-published white paper would seem to bear this out.

Photo by Craig Chew-Moulding https://www.flickr.com/photos/craigmoulding/

According to Capitalism’s Dirty Secret, 17% of large businesses have suffered financial loss due to poor spreadsheets, and 57% say that poor spreadsheets have wasted time. Also, 33% of large businesses, 20% of medium businesses and 9% of small businesses have made poor decisions because of bad spreadsheets.

From an educational point of view, these facts are important. I’ve been informed by the Press Association and a small publishing company that new recruits often have to be taught how to create and use a spreadsheet. Recently, someone who runs a digital marketing agency told me that she hoped the new Computing curriculum would lead to school-leavers joining her company with better spreadsheet skills. “Don’t hold your breath”, I told her.

If you give your students the impression that spreadsheets are not only boring, but also that they don’t matter any more, you are doing them a grave disservice. Being comfortable and proficient in the use of spreadsheets will help them to develop their computational skills and, in the case of older students, probably make them more employable.

Useful reading

Computational thinking and spreadsheets

Spreadsheets Across the Curriculum

Why Teach Spreadsheets?


 

cartoon 1 researchYour newsletter editor is hard at work doing research for Digital Education, the free newsletter for education professionals. Have you subscribed yet?

Read more about it, and subscribe, on the Newsletter page of the ICT in Education website.

We use a double opt-in system, and you won’t get spammed.