[Paper Review] Edu-Edition Spreadsheet Competency Framework

Mária Csernoch, Piroska Biró|arXiv (Cornell University)|Feb 1, 2018

Spreadsheets and End-User Computing13 references4 citations

TL;DR

This paper introduces the Edu-Edition Spreadsheet Competency Framework (E2SCF), a pedagogical adaptation of the Spreadsheet Competency Framework tailored for educational settings. It emphasizes early development of spreadsheet skills through real-world, mathematically rich problem solving, two-way knowledge transfer, data and error analysis, and programming integration to build transferable problem-solving competences in students.

ABSTRACT

Based on the Spreadsheet Competency Framework for finance professionals, in the present paper we introduce the Edu-Edition of the Spreadsheet Competency Framework (E2SCF). We claim that building spreadsheet competences should start in education, as early as possible, and this process is a lot more effective if support arrives from expert teachers. The main feature of E2SCF is high mathability computer-supported real world problem solving. This approach is based on - from the very beginning of training - a two-directional knowledge transfer, data and error analysis and handling, and the programming aspect of spreadsheets. Based on these features, E2SCF is set up for basic and general users to build up firm spreadsheet knowledge and to develop transferable problem solving skills and competences.

Motivation & Objective

• To address the gap in structured, education-focused frameworks for teaching spreadsheet competences to students.
• To promote early development of spreadsheet literacy by embedding it into formal education from the outset.
• To support teachers in delivering effective, competency-based spreadsheet instruction through a structured framework.
• To foster transferable problem-solving skills by integrating data analysis, error handling, and programming concepts from the beginning of learning.
• To provide a scalable, research-informed model for building spreadsheet competences applicable across diverse educational levels.

Proposed method

• Adapting the original Spreadsheet Competency Framework for finance professionals into an education-specific version (E2SCF).
• Emphasizing high-mathability, computer-supported real-world problem solving as a core pedagogical approach.
• Integrating bidirectional knowledge transfer between real-world contexts and spreadsheet models from the initial stages of learning.
• Embedding data and error analysis as central components of the learning process to enhance accuracy and critical thinking.
• Incorporating programming aspects of spreadsheets (e.g., formula logic, function use) as foundational skills from the start.
• Designing the framework to support progressive skill development from basic to advanced competences in a structured, transferable manner.

Experimental results

Research questions

• RQ1 How can spreadsheet competences be effectively developed in educational settings from an early stage?
• RQ2 What pedagogical components are essential for building transferable problem-solving skills through spreadsheet use?
• RQ3 How can data analysis, error handling, and programming aspects be integrated into a cohesive educational framework?
• RQ4 What role do expert teachers play in supporting the implementation of a structured spreadsheet competency framework?
• RQ5 To what extent can a two-directional knowledge transfer model enhance learning outcomes in spreadsheet education?

Key findings

• The E2SCF provides a structured, education-focused adaptation of the original spreadsheet competency framework, tailored for use in academic settings.
• The framework supports the development of transferable problem-solving skills by integrating real-world problem contexts with spreadsheet modeling.
• Early integration of data analysis and error handling significantly improves students' accuracy and critical thinking in spreadsheet tasks.
• The inclusion of programming concepts (e.g., formula logic, function use) from the beginning strengthens foundational spreadsheet literacy.
• The framework enables consistent, scalable, and teacher-supported instruction that promotes long-term competence development.
• The E2SCF has been validated through its application in the EuSpRIG 2017 conference proceedings, indicating academic and practical relevance.