
02354331
j
2004b.00153
Lov\'aszov\'a, Gabriela
Hvoreck\'y, Jozef
On programming and spreadsheet calculations.
Spreadsheets Educ. 1, No. 1, 4451 (2003).
2003
Bond University, Faculty of Business, Gold Coast, Queensland
EN
P55
R75
Q65
constructive learning
simulation of program tracing
'Experiment', 'discovery' and 'selfteaching' are basic components of active learning. Despite the fact that learners are investigating notions and relationships known long before, their own discovery of something new and unknown for them results in their fascination with an irreplaceable educational value. Spreadsheets are one of many environments that can successfully be used for building stages for similar experimentation. Activities described in this paper show how spreadsheetbased calculations can lead students to a deeper comprehension of algorithms, their execution and notation in a programming language. Their goal is to identify a relationship between a notation of an algorithm and the series of figures produced by its execution. During their investigations, students exploit the adaptability of spreadsheets  each change of an input value evokes the complete recalculation of the entire sheet. The instant recalculations allow the students to observe many 'runs' of the studied algorithm, to formulate hypotheses and to verify them much faster than any other methods of traditional programming.