Authors
Maria Csernoch & Piroska Biro
Abstract
Spreadsheet management lies between office applications and programming, however, it is rather communicated that spreadsheeting is nothing more than an easily-handled piece of fun. Consequently, the complexity of spreadsheet handling, the unprepared end-users, their problem solving abilities and approaches do not match.
To overcome these problems we have developed and introduced Sprego (Spreadsheet Lego). Sprego is a simplified functional programming language in the spreadsheet environment, and such as can be used both as introductory language and the language of end-user programmers.
The essence of Sprego is that we use as few and as simple functions as possible. Based on these functions, we build multilevel formulas. With this approach, similar to high level programming, we are able to solve advanced problems, developing algorithmic skills, computational thinking.
The advantage of Sprego is the simplicity of the language, when the emphasis is not on the coding but on the problem. Beyond that, spreadsheets would provide real life problems with authentic data and tables which students are more interested in than the artificial environment and semi-authentic problems of high level programming languages.
Sample
Sprego uses the INDEX() and MATCH() matrix functions, which are general purpose, rather than the HLOOKUP() and VLOOKUP() functions, which are troublesome.
Publication
2015, Spreadsheets in Education, Volume 8, Issue 1, Article 4
