Search this site

Today's Law...

Last 100 articles
Free subscriptions

 Subscribe to our free newsletter, Digital Education!

Digital Education cover early July 2014

 It's free. Signing up entitles you to various freebies. We use a double opt-in system, and we won't spam you.

Sign-up page.


The DfE Assessment Innovations series collated. This booklet is free to subscribers of Digital Education.

Be notified by email if you prefer:


Preview | Powered by FeedBlitz

The Amazing Computer Education Project Book

Remember this?

Amazing Web 2.0 Projects

It’s been downloaded over 35,000 times. I’m hoping to create a similar Computer Education Projects book, which will also be free. Find out how you can help by reading this article:

The Amazing Computer Education Projects Book


Digital Education

News, views and reviews. In-depth articles. Guest contributors. Competitions. Discount codes.

(Not necessarily all in the same issue, but each issue is full of good stuff nonetheless!)

Sign up for our free newsletter now!


Oh No!!If you can't find what you're looking for...

Assuming you’ve tried variations of your search term and checked the spelling without any luck, you may find the article Finding stuff on the ICT in Education website helpful.

Alternatively, if it’s not an article you’re looking for, try looking through the menus at the top of the screen.

E-Books for Sale

Want to make your ICT lessons more interesting?

Then Go on, bore ‘em: How to make your ICT lessons excruciatingly dull is just right for you.

Clustr Map
Terry Freedman's Social Profile
Powered by Squarespace

« 10 reasons to attend BETT | Main | The BETT Blog Begins! »
Monday
Nov042013

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

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.