Computational thinking and spreadsheets

11/12/2013 12:00:00 AM
One way you can “get into” computational thinking is through spreadsheets. Taking a practical view of what “computational thinking” means (see What is Computational Thinking?), I’d say that spreadsheets definitely fit the bill. In order to try to solve a problem using a spreadsheet, which is a tool for modelling or simulation, you have to do the following things:

 

Data Model Template, by Ivan Walsh http://www.flickr.com/photos/ivanwalsh/

  • Work out what it is you are trying to find out
  • Frame the problem in terms a computer (spreadsheet) will understand
  • Work out what the influential changeable elements are (ie the variables)
  • Decide what operation/s is/are required, ie what algorithm is/are needed
  • Design the spreadsheet
  • Construct it, automating as much of it as possible, especially the error-checking
  • Test it
  • Decide on the best (eg most efficient) solution

As a bonus, if you use Excel then you will automatically have the built-in programming language, Visual Basic for Applications (VBA). In a forthcoming post I will relate what the benefits of VBA are. In another post or two I will give examples of spreadsheets I’ve created that exemplify computational thinking.

cross-posted on www.ictineducation.org

Terry Freedman is an independent educational ICT consultant with over 35 years of experience in education. He publishes the ICT in Education website and the newsletter “Computers in Classrooms."


 
comments powered by Disqus

KIBO from KinderLab Robotics wins 2017 Parents’ Choice Gold Award in the Toy Category

Unique robot kit helps young children develop STEM skills and confiden...

CDI Reaches 2.5 Million Recertified Computers and Notebooks Deployed into K-12 Schools

CDI Recertified Program’s rigorous quality control process benef...

Registration for Learning.com’s 2017 Code-a-Thon Opens October 18

Annual Competition Provides Young Learners With Introduction to Coding...

StudySync Announces its Fifth Annual MyStudySyncTV Contest

NEW YORK (Oct. 18, 2017) – Budding actors, actresses and film di...

Fuel Education Adds Reading Literacy Platform to its Suite of K-12 Digital Solutions

Big Universe provides thousands of high-interest eBooks and reading to...

T&L Partner Post
Tweets