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

Epson Wins 2017 Tech & Learning Stellar Service Award

Epson’s Brighter Futures® program won The Ultimate Reputati...

PepsiCo Recycle Rally Earns Gold Honor in 2017 MarCom Awards

PepsiCo recycling initiative encourages K-12 students to become enviro...

Illuminate Education Acquires eduCLIMBER, Improves Data Analysis for Teachers and Districts

Irvine, CA. (December 14, 2017) — Illuminate Education, the com...

Vernier Software & Technology Wins Two Tech & Learning Stellar Service Awards

Vernier recognized for its free, hands-on workshops that help science ...

CDI’s Leasing Program Helps Schools on Tight Budgets Meet Technology Needs

Schools can use technology immediately while stretching payments over ...

Apperson’s “Get the Lead Out” Campaign Rewards Customers with Free Pencils

For every $100 spent on Apperson products, schools will receive a free...

3M and Discovery Education Host Second Installation of the Young Scientist Lab Virtual Field Trip Series

To extend the impact of their joint Young Scientist Lab program, 3M an...

Funds For Learning Report Indicates Progress and Pitfalls of E-rate Program

Edmond, Okla. (Dec. 13, 2017) – The impending decision by the FC...

T&L Partner Post
Tweets