ICT & Computing in Education

The site for all those with a professional interest in teaching, using, managing and leading educational ICT and Computing

The ICT and Computing in Education site aims to provide practical suggestions and useful information for teachers, users, leaders and managers of educational ICT and Computing.

Computational thinking and spreadsheets

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.

Enhanced by Zemanta

Google Ads

The content on this website is (c) 1995-2016 Terry Freedman, unless otherwise stated. 

Powered by Squarespace

(c) Terry Freedman