Computational thinking and constructionism: creating difference equations in spreadsheets

ABSTRACT

The invention of the computer has led to the establishment of a new research paradigm, computation, which has recently become more and more popular in scientific exploration. However, computation is not well represented in high school and university curricula in science and engineering, although it applies to a wide range of disciplines beyond computer science and software engineering. In light of the increasing need to provide students with computational education, this paper presents a novel way to develop computational thinking among students. The proposed approach is based on the implementation of Papert's theory of constructionism in electronic spreadsheets. In this approach, students build their knowledge while constructing the difference equation that describes a physical (or engineering) phenomenon, based on specific cases investigated in the spreadsheet. The method does not require the students to write code or perform complex calculations in the spreadsheet and makes it possible to teach advanced subjects at a relatively early stage. The method is demonstrated through contents taken from the secondary and tertiary curricula in mechanics and electromagnetism.

KEYWORDS:

• Computational thinking
• constructionism
• difference equations
• spreadsheets

Disclosure statement

No potential conflict of interest was reported by the authors.

Notes

1. There is still the need for auditing, which at times can be a complex process similar to the debugging that takes place when writing a code.