Standard

Gradual structuring : Evolving the spreadsheet paradigm for expressiveness and learnability. / Miller, Gary; Hermans, Felienne; Braun, Robin.

2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET). Danvers : IEEE, 2016. p. 1-8 7760759.

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

Harvard

Miller, G, Hermans, F & Braun, R 2016, Gradual structuring: Evolving the spreadsheet paradigm for expressiveness and learnability. in 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET)., 7760759, IEEE, Danvers, pp. 1-8, 15th International Conference on Information Technology Based Higher Education and Training, ITHET 2016, Istanbul, Turkey, 8/09/16. https://doi.org/10.1109/ITHET.2016.7760759

APA

Miller, G., Hermans, F., & Braun, R. (2016). Gradual structuring: Evolving the spreadsheet paradigm for expressiveness and learnability. In 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET) (pp. 1-8). [7760759] IEEE. https://doi.org/10.1109/ITHET.2016.7760759

Vancouver

Miller G, Hermans F, Braun R. Gradual structuring: Evolving the spreadsheet paradigm for expressiveness and learnability. In 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET). Danvers: IEEE. 2016. p. 1-8. 7760759 https://doi.org/10.1109/ITHET.2016.7760759

Author

Miller, Gary ; Hermans, Felienne ; Braun, Robin. / Gradual structuring : Evolving the spreadsheet paradigm for expressiveness and learnability. 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET). Danvers : IEEE, 2016. pp. 1-8

BibTeX

@inproceedings{1ac4eb90d1db4176bbf32c88d03383c5,
title = "Gradual structuring: Evolving the spreadsheet paradigm for expressiveness and learnability",
abstract = "Spreadsheets are arguably the most used form of programming and are frequently used in higher education to teach fundamental concepts about computation. Their success has shown that they are simple enough for a huge number of end users to learn and use. This is in contrast to traditional programming languages and the high dropout rate from introductory programming and computer science. However in comparison to traditional programming languages and structured modelling, spreadsheets are not expressive, placing a limit on the levels of computational thinking that can be taught using the spreadsheet paradigm. This limitation is imposed by the lack of programming language features and abstractions in the paradigm. Furthermore, more advanced spreadsheet features (e.g. array formulae, lookup formulae, R1C1 syntax) can be difficult to learn and use. This paper discusses the idea of adding language features to spreadsheets, enabling the gradual structuring of free-form spreadsheets to more structured models. We propose that this concept is termed Gradual Structuring, and is analogous to the programming language concept of gradual typing. In this analogy, spreadsheets take the place of dynamic programming and structured modelling of static programming. In programming languages, gradual typing allows dynamic programming to be mixed with static programming. It is our contention that dynamic programming is more learnable while static programming is more expressive and abstract. Gradual typing could be used to mitigate the issues in the teaching of traditional programming. Likewise Gradual Structuring can mitigate the conceptual limits that can be taught using current spreadsheets. The key language feature required to enable Gradual Structuring is the ability to logically group cells together so that a single formula can be applied to the grouped cells. This concept, termed cell grouping diminishes and can even eliminate the need for the ubiquitous and error-prone use of copy-pasted in spreadsheets. Moreover, it makes the structure present in spreadsheet models explicit. Cell grouping requires a cascade of other new languages features. Namely a more expressive referencing style, which in turned requires enabling labels to be moved to the row and column headers, and the hierarchical structuring of these headers. Respectively these language features are termed enhanced referencing and semantic axes. The ongoing research focusses on the usability and learnability of these language features. Spreadsheet applications exist that contain aspects of the features mentioned. However these applications do not enable Gradual Structuring and have taken a mainly technical, not human behavioural, approach to evolving the spreadsheet.",
author = "Gary Miller and Felienne Hermans and Robin Braun",
year = "2016",
month = nov,
day = "28",
doi = "10.1109/ITHET.2016.7760759",
language = "English",
isbn = "978-1-5090-0779-0",
pages = "1--8",
booktitle = "2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET)",
publisher = "IEEE",
address = "United States",
note = "15th International Conference on Information Technology Based Higher Education and Training, ITHET 2016 ; Conference date: 08-09-2016 Through 10-09-2016",

}

RIS

TY - GEN

T1 - Gradual structuring

T2 - 15th International Conference on Information Technology Based Higher Education and Training, ITHET 2016

AU - Miller, Gary

AU - Hermans, Felienne

AU - Braun, Robin

PY - 2016/11/28

Y1 - 2016/11/28

N2 - Spreadsheets are arguably the most used form of programming and are frequently used in higher education to teach fundamental concepts about computation. Their success has shown that they are simple enough for a huge number of end users to learn and use. This is in contrast to traditional programming languages and the high dropout rate from introductory programming and computer science. However in comparison to traditional programming languages and structured modelling, spreadsheets are not expressive, placing a limit on the levels of computational thinking that can be taught using the spreadsheet paradigm. This limitation is imposed by the lack of programming language features and abstractions in the paradigm. Furthermore, more advanced spreadsheet features (e.g. array formulae, lookup formulae, R1C1 syntax) can be difficult to learn and use. This paper discusses the idea of adding language features to spreadsheets, enabling the gradual structuring of free-form spreadsheets to more structured models. We propose that this concept is termed Gradual Structuring, and is analogous to the programming language concept of gradual typing. In this analogy, spreadsheets take the place of dynamic programming and structured modelling of static programming. In programming languages, gradual typing allows dynamic programming to be mixed with static programming. It is our contention that dynamic programming is more learnable while static programming is more expressive and abstract. Gradual typing could be used to mitigate the issues in the teaching of traditional programming. Likewise Gradual Structuring can mitigate the conceptual limits that can be taught using current spreadsheets. The key language feature required to enable Gradual Structuring is the ability to logically group cells together so that a single formula can be applied to the grouped cells. This concept, termed cell grouping diminishes and can even eliminate the need for the ubiquitous and error-prone use of copy-pasted in spreadsheets. Moreover, it makes the structure present in spreadsheet models explicit. Cell grouping requires a cascade of other new languages features. Namely a more expressive referencing style, which in turned requires enabling labels to be moved to the row and column headers, and the hierarchical structuring of these headers. Respectively these language features are termed enhanced referencing and semantic axes. The ongoing research focusses on the usability and learnability of these language features. Spreadsheet applications exist that contain aspects of the features mentioned. However these applications do not enable Gradual Structuring and have taken a mainly technical, not human behavioural, approach to evolving the spreadsheet.

AB - Spreadsheets are arguably the most used form of programming and are frequently used in higher education to teach fundamental concepts about computation. Their success has shown that they are simple enough for a huge number of end users to learn and use. This is in contrast to traditional programming languages and the high dropout rate from introductory programming and computer science. However in comparison to traditional programming languages and structured modelling, spreadsheets are not expressive, placing a limit on the levels of computational thinking that can be taught using the spreadsheet paradigm. This limitation is imposed by the lack of programming language features and abstractions in the paradigm. Furthermore, more advanced spreadsheet features (e.g. array formulae, lookup formulae, R1C1 syntax) can be difficult to learn and use. This paper discusses the idea of adding language features to spreadsheets, enabling the gradual structuring of free-form spreadsheets to more structured models. We propose that this concept is termed Gradual Structuring, and is analogous to the programming language concept of gradual typing. In this analogy, spreadsheets take the place of dynamic programming and structured modelling of static programming. In programming languages, gradual typing allows dynamic programming to be mixed with static programming. It is our contention that dynamic programming is more learnable while static programming is more expressive and abstract. Gradual typing could be used to mitigate the issues in the teaching of traditional programming. Likewise Gradual Structuring can mitigate the conceptual limits that can be taught using current spreadsheets. The key language feature required to enable Gradual Structuring is the ability to logically group cells together so that a single formula can be applied to the grouped cells. This concept, termed cell grouping diminishes and can even eliminate the need for the ubiquitous and error-prone use of copy-pasted in spreadsheets. Moreover, it makes the structure present in spreadsheet models explicit. Cell grouping requires a cascade of other new languages features. Namely a more expressive referencing style, which in turned requires enabling labels to be moved to the row and column headers, and the hierarchical structuring of these headers. Respectively these language features are termed enhanced referencing and semantic axes. The ongoing research focusses on the usability and learnability of these language features. Spreadsheet applications exist that contain aspects of the features mentioned. However these applications do not enable Gradual Structuring and have taken a mainly technical, not human behavioural, approach to evolving the spreadsheet.

UR - http://www.scopus.com/inward/record.url?scp=85007367467&partnerID=8YFLogxK

U2 - 10.1109/ITHET.2016.7760759

DO - 10.1109/ITHET.2016.7760759

M3 - Conference contribution

AN - SCOPUS:85007367467

SN - 978-1-5090-0779-0

SP - 1

EP - 8

BT - 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET)

PB - IEEE

CY - Danvers

Y2 - 8 September 2016 through 10 September 2016

ER -

ID: 45795756