i-nth logo

Authors

Maria Csernoch & Piroska Biro

Abstract

Sprego is a programming tool for novice and end-user programmers within graphical spreadsheet environments. The main idea of Sprego is to use as few general purpose functions as possible, and based on these functions we create multilevel formulas to solve real world programmable spreadsheet problems.

Beyond providing the framework for the theoretic background and the tools which support Sprego, in order to demonstrate the power which lies within it, we present a converted authentic table and, based on this table, data retrieval tasks, their algorithms, and coding in full details.

Sample

Sprego functions
Sprego functions

The Sprego functions are classified based on the development made by the students. Sprego1 and Sprego2 consist of the dozen functions which are required. Sprego1 is for beginners, while the functions of Sprego2 are more demanding. Sprego3 is for intermediate and advanced students and end users.

Publication

2015, EuSpRIG

Full article

Problem solving in Sprego