Pivoting the paradigm: the role of spreadsheets in K-12 data science

Nicholas Jon Horton; Oren Tirschwell

REVIEW 3 major objections 4 minor 8 references

Pivoting the paradigm: the role of spreadsheets in K-12 data science

T0 review · 3 major / 4 minor · reviewed 2026-08-07 · deepseek-v4-flash

Challenge this review Re-run · record.json Download PDF Read on arXiv ↗

Pith's one-line read Spreadsheets have a meaningful role in K-12 data and computing education, despite their analytic limits.

desk verdict A clear, honest position paper making a modest case for spreadsheets in K-12 data science; worth reviewing but it stops short of demonstrating the transfer it asserts. read the letter →

arxiv 2506.03232 v2 pith:Y3465JDD submitted 2025-06-03 stat.OT cs.CY

Oren Tirschwell , Nicholas Jon Horton This is my paper

classification stat.OTcs.CY

keywords spreadsheetsK-12datascienceacumencomputationalfluencythinkingskillsGoogleSheetsstatisticseducation

verification ladder T0 review T1 audit T2 compute T3 formal

The pith

A machine-rendered reading of the paper's core claim, the machinery that carries it, and where it could break.

The reading

The paper argues that spreadsheets, despite being weak tools for advanced statistical analysis, have a meaningful role in K-12 data and computing education and can serve as a foundation for work in other tools. Its case rests on three observations: spreadsheets are near-universal in schools, they make data visible and directly manipulable, and they already map onto existing learning standards. To make the case concrete, the paper proposes five data skills—data entry, aggregation, and visualization; data consistency checking; mathematical applications; algorithmic thinking and implementation; and scripting, automation, and tool integration—each illustrated with classroom activities. The paper does not claim to prove these activities raise testable outcomes; it explicitly says it does not provide empirically validated lesson plans. If the claim is right, schools can build data and computing instruction on software they already license.

What carries the argument

The mechanism carrying the argument is the spreadsheet grid itself, treated as a first-order data object—meaning the data are the primary thing the student sees and touches—together with the five skill categories the paper proposes. The spreadsheet's grid makes data visible and directly editable, and the paper uses that property to argue for rapid development of a student's conception of data. The five skills—entry, aggregation, and visualization; consistency checking; mathematical modeling; nested-logic and algorithmic formulas; and scripting and tool integration—are the proposed bridge from ordinary classroom use to computational thinking. The paper also leans on the analogy between spreadsheet cell references and variables in programming, and between spreadsheet formulas and function composition, as conceptual footholds.

What would settle it

A controlled classroom study would settle it: randomly assign K-12 students to equivalent data-science lessons taught with spreadsheets versus a non-spreadsheet tool, and measure data acumen and transfer to a new tool before and after. If the spreadsheet group does not show at least as much growth as the comparison group, the paper's claim that spreadsheets can serve as the foundation loses its empirical support.

Watch

Extended reading notes

Core claim

The central claim is that spreadsheets should be treated as a legitimate component of the K-12 data science toolkit rather than as a tool to be avoided because of its analytic limitations. The paper grades spreadsheets on an adapted framework for data-science tools and finds their strengths where data are shown plainly and can be touched—accessibility, data as a first-order object, ease of entry—while conceding weaknesses in interactivity, flexible plotting, reproducibility, and inferential analysis. From that balance it derives five proposed skills that students should develop through repeated spreadsheet use, and it argues that these skills translate to other tools. The paper's final position is that spreadsheets are a foundation, not a replacement: they prepare students for environments such as visual interfaces and scripting languages.

Load-bearing premise

The load-bearing premise is that using spreadsheets in the ways proposed actually causes the intended growth in data acumen and computational fluency; the paper offers example activities but no empirical evidence that the learning happens.

Editorial extensions

If this is right

Schools can begin data and computing instruction immediately with the spreadsheet software they already license, without new procurement.
Repeated spreadsheet activities across science, math, and computer science classes can build data acumen and computational fluency before students encounter scripting languages.
Spreadsheet proficiency can make later tools easier to learn, because the five skills of organizing, checking, modeling, algorithmic logic, and automation transfer.
The cell-reference and formula analogies give teachers a concrete language for introducing variables and function composition.
Teacher professional development becomes a binding constraint, since instructors who lack spreadsheet fluency will be reluctant to teach it.

Reading between the lines

Editorial extensions of the paper, not claims the author makes directly.

If the learning mechanism is real, the five skills could be organized into an explicit progression with assessment items attached to each skill, something the paper does not supply.
A natural test would compare spreadsheet-first and visual-tool-first groups on a transfer task, since the paper's argument predicts positive transfer from spreadsheets to other tools.
Generative AI tutors could lower the teacher-knowledge barrier the paper identifies, but could also let students skip the foundational practice the argument depends on; the paper notes the tension but does not resolve it.
The paper's case centers on a single web-based spreadsheet system, leaving open whether the same argument holds in districts that rely on other spreadsheet software.

Share X Bluesky LinkedIn Reddit HN

Editorial analysis

A structured set of objections, weighed in public.

Desk editor's note, referee report, and a circularity audit.

Desk Editor's Note

read the letter

Here's my take. This is a solid position paper. It makes a modest claim—spreadsheets have a role in K-12 data science as a foundation, not as the only tool—and it mostly stays inside that claim. The authors know they're not offering empirical evidence; they say so in Section 5. That honesty matters.

What's actually new: the five data skills in Section 4 (data entry/aggregation/visualization, consistency checking, math applications, algorithmic thinking, scripting/automation). They're a reasonable organizing device, and they don't reduce perfectly to prior categories like data moves—they add a spreadsheet-specific flavor, especially skills 4 and 5 with Apps Script. The bundled set is not in the cited standards, so it's a genuine synthesis. The demo sheets and Appendix code are real, reproducible resources; that's more concrete than most position papers.

The paper also does a good job reviewing the standards landscape (GAISE, CSTA, National Academies, etc.) and mapping spreadsheets onto them. The Table 1 informal grades are a nice quick overview, though they are subjective—the authors could have said more about how they assigned those grades.

Soft spots, in order: (1) The 'foundation for work in other tools' claim is a transfer-of-learning assertion with no evidence and no mechanism. If a student learns VLOOKUP and pivot tables in Sheets, will those skills transfer to R or Python? The paper says they will build data acumen and computational fluency, but it doesn't show how. That's the weakest link, but it's a weakness in the proposal, not a false claim—the paper explicitly says it's not providing validated lesson plans. (2) The teacher input is anecdotal; fine for a position paper, but it's not data. (3) The paper leans on some self-citations, but they're relevant prior work, and there's no circular reasoning.

The citation pattern looks fine. The argument is coherent on its own terms.

Bottom line: this deserves peer review. It's not going to change scientific understanding, but it could influence curriculum design and teacher PD. A serious referee should ask the authors to (a) sharpen the transfer argument, perhaps by citing transfer-of-learning literature or proposing a pilot study, and (b) either justify the Table 1 grades or soften them. I'd send it to review.

Referee Report

3 major / 4 minor

Summary. The paper argues that spreadsheets, despite their well-documented limitations for statistical analysis, have a valuable role in K-12 data science education as one component of a broader data and computing toolkit. It evaluates spreadsheet tools against the Pimentel et al. (2022) framework, reviews several K-12 standards and frameworks (CSTA, Data Science Learning Progressions, Common Core, GAISE II, NRC Framework, NASEM 2026), and proposes five data and computing skills—data entry/aggregation/visualization, consistency checking, mathematical applications, algorithmic thinking, and scripting/automation—each illustrated with Google Sheets activities and Apps Script examples. The paper discusses adoption barriers, teacher professional development needs, and limitations such as reproducibility, multivariate visualization, and scaling to big data. It explicitly states in Section 5 that it does not provide empirically validated lesson plans or a comprehensive curriculum; the contribution is deliberately conceptual and illustrative.

Significance. If the central claim is accepted as a carefully hedged proposal, the paper makes a useful contribution by synthesizing existing K-12 standards and arguing that spreadsheets should not be dismissed outright in favor of purpose-built tools. Its concrete strengths include the integration of widely cited frameworks, freely available sample Google Sheets activities, and copy-ready Apps Script code, which practitioners can adapt immediately. The paper also responsibly identifies limitations and does not claim to have demonstrated learning gains. However, the significance is diminished by the gap between the assertive language of 'demonstrating utility' and 'serving as a foundation for other tools' and the absence of any empirical or theoretical support for those strong claims; as a result, the contribution is best viewed as a well-grounded position piece that should motivate future studies rather than as an established conclusion.

major comments (3)

[Section 5 and Section 4] The central claim that spreadsheets 'can serve as a foundation for work in other tools' (Section 5) is a transfer-of-learning assertion, but the paper provides neither a theoretical mechanism (e.g., abstraction, metacognitive bridging, or deliberate comparison across tools) nor empirical evidence that skills acquired in spreadsheets generalize to CODAP, R, or Python. The activities in Section 4 are largely tool-specific (VLOOKUP, pivot tables, Apps Script), and Section 5 concedes that no empirically validated lesson plans are provided. I ask the authors to either weaken this claim to a hypothesis ('may serve') or add a concrete transfer design and evidence; as written, the strongest version of the central claim is unsupported.
[Abstract and Section 1] The abstract states that the paper 'demonstrates the potential utility of spreadsheets,' and Section 1 lists 'Demonstrate the potential utility of spreadsheets' as a goal, but the body of the paper offers a reasoned argument, a standards review, and illustrative activities rather than an empirical demonstration. Section 5 explicitly disclaims validated lesson plans. Please reframe the stated contribution as arguing for or proposing a role for spreadsheets, and move the effectiveness question to an explicitly open research problem; otherwise the claimed contribution exceeds what the manuscript can support.
[Section 4] The five 'aspirational' data and computing skills are presented as 'derived from existing learning standards and frameworks,' but no selection criteria or systematic mapping are provided. For example, Skill 5 (scripting, automation, and tool integration) is justified mainly through Google Workspace examples, and its connection to particular CSTA or NASEM competencies is asserted rather than demonstrated. I recommend adding a table that maps each of the five skills to specific standards statements, lists which frameworks were considered, and explains why other candidate skills were not included, so that the proposed skill set can be evaluated as a coherent and justified contribution.

minor comments (4)

[Table 1] The 'Grade' column is described as an informal assessment, but the table would benefit from a caption note stating explicitly that these letter grades are the authors' subjective judgments rather than the result of a formal rubric or independent rating, since the table currently appears to be a more objective evaluation than it is.
[Section 5] The statement that 'numerous conversations between the authors and selected K-12 educators' shed light on pedagogical considerations provides no protocol, participant count, or analytic method; as presented, this anecdotal evidence should be labeled as informal consultation or removed from statements that carry evidentiary weight.
[Sections 4.1.1 and 5] Please replace the non-standard ligature characters in 'efficiently', 'difficult', and 'sufficient' with standard ASCII spellings, as these appear to be encoding artifacts.
[References] Several references lack complete identifying information, including Erickson (2022) and Frischemeier et al. (2022), which have no URL or DOI; please complete these entries to allow readers to locate the sources.

Circularity Check

0 steps flagged · score 0.0 of 10

No circularity: the paper is an argumentative pedagogical proposal whose claims rest on external frameworks, standards, and examples, with self-citations used as foils rather than as proof.

full rationale

The paper does not derive a quantitative result, fit parameters, or make a prediction that reduces to its inputs by construction. Its central claim, that spreadsheets can play a role in K-12 data and computing education, is a position argued from external standards and frameworks (CSTA, Common Core, GAISE II, NRC, National Academies 2026), external surveys (Rosenberg et al. 2022; Pierson & Moore 2024), and concrete example activities. The five proposed skills in Section 4 are explicitly described as aspirational and derived from existing learning standards, not as empirically validated findings; the paper states in Section 5 that it does not provide empirically validated lesson plans. The most potentially load-bearing self-citation, Pimentel et al. (2022), which is co-authored by Horton, is used as the evaluation framework in Section 2, but the paper explicitly argues that Pimentel et al. understates spreadsheet strengths and concurs only with its narrower conclusion about spreadsheets as a sole analysis tool. The citation thus functions as a foil, not as an authority whose acceptance forces the paper's conclusion. Other self-citations (Baumer et al. 2014; Horton et al. 2015; McNamara & Horton 2018; Stoudt et al. 2014) are peripheral supporting references. The claim that spreadsheets can serve as a foundation for work in other tools involves an untested transfer-of-learning assumption, but that is an evidential gap, not circularity: the claim is not equivalent to its inputs by definition or by fitted construction.

Assumptions & free parameters 0 free parameters · 3 assumptions · 1 invented entities

No free parameters. The central argument rests on assumed validity of educational frameworks and on an untested causal link from spreadsheet activities to learning outcomes.

assumptions (3)

domain assumption The National Academies data and computing competencies are valid educational goals for K-12 students.
The paper uses these competencies as the basis for its proposed skills (Sections 3.6 and 4).
domain assumption Spreadsheet-based activities can promote data acumen and computational thinking in K-12 students.
This is the central pedagogical premise, asserted via examples and informal grades, not empirically tested (Sections 2 and 4).
domain assumption The Pimentel et al. framework is an appropriate lens for evaluating K-12 data tools.
The paper grades spreadsheets against this framework in Section 2, Table 1, without validating the framework's completeness for its argument.

invented entities (1)

Five data skills framework
purpose: Organizational structure for teaching data and computing with spreadsheets
Introduced in Section 4 as 'aspirational data and computing skills'; no empirical validation is provided.

how reviews work

0 comments

Cite this review

Pith. "Pith review of Pivoting the paradigm: the role of spreadsheets in K-12 data science." pith.science (2026). https://pith.science/paper/Y3465JDD

@misc{pith2026250603232,
  author       = {Pith},
  title        = {Pith review of: Pivoting the paradigm: the role of spreadsheets in K-12 data science},
  year         = {2026},
  howpublished = {\url{https://pith.science/paper/Y3465JDD}},
  note         = {Machine review of arXiv:2506.03232}
}

read the original abstract

Spreadsheet tools are widely accessible to and commonly used by K-12 students and teachers. While spreadsheets are not ideal for many types of statistical analysis, they have an important role in data collection and organization. From a pedagogical standpoint, spreadsheets make data visible and easy to interact with, facilitating student engagement in data exploration, analysis, and computation. Though not suitable for all tasks, spreadsheets can facilitate learning and practicing data and computing skills for K-12 students. This paper 1) demonstrates the potential utility of spreadsheets in K-12; 2) reviews prior frameworks and standards that are relevant for K-12 data tools; and 3) proposes data-driven data skills to help develop data acumen and computational fluency. We provide some example activities, identify challenges and barriers to adoption, suggest pedagogical approaches to ease the learning curve for instructors and students, and discuss the need for professional development to facilitate deeper use of spreadsheets for data science and STEM disciplines.

Figures

Figures reproduced from arXiv: 2506.03232 by the authors.

**Figure 2.** Snapshot of header row and first four rows of data in the “Data” tab for the first [PITH_FULL_IMAGE:figures/full_fig_p021_2.png] view at source ↗

Discussion (0). Sign in to comment.

Reference graph

Works this paper leans on

8 extracted references · 4 canonical work pages

[1]

American Statistical Association (2020), ‘Pre-K-12 Guidelines for Assessment and Instruc- tion in Statistics Education I| (GAISE II): A Framework for Statistics and Data Science Education’ . URL: https://www.amstat.org/education/guidelines-for-assessment-and-instruction-in- statistics-education-(gaise)-reports Applications of Geometric Series | Grade 11 M...

arXiv 2020
[2]

URL: https://iase-pub.org/ojs/SERJ/article/view/41 McDaniel, S. N. & Green, L. B. (2012), ‘Using applets and video instruction to foster students’ understanding of sampling variability’, Technology Innovations in Statistics Education 6(1). URL: http://dx.doi.org/10.5070/T561000177 46 McNamara, A. (2018), ‘Key attributes of a modern statistical computing t...

arXiv 2012
[3]

D., Agarwal, M., A verett, M., Baumer, B

URL: https://studentprivacy.ed.gov/data-security-k-12-and-higher-education De Veaux, R. D., Agarwal, M., A verett, M., Baumer, B. S., Bray, A., Bressoud, T. C., Bryant, L., Cheng, L. Z., Francis, A., Gould, R. et al. (2017), ‘Curriculum guidelines for 43 undergraduate programs in data science’, Annual Review of Statistics and Its Application 4, 15–30. URL...

arXiv 2017
[4]

Designing a Data Analysis Tool for Learners

URL: https://www.ed2go.com/bunkerhill/online-courses/intro-excel-microsoft-excel- 2019 Konold, C. (2007 a), ‘Designing a data analysis tool for learners’, Thinking with Data pp. 267–291. Konold, C. (2007 b), Thinking with Data , Lawrence Erlbaum Associates Publishers, chapter “Designing a Data Analysis Tool for Learners”, p. 267–291. Launched: Google Apps...

work page 2009
[6]

R., Horton, N

URL: https://magazine.amstat.org/blog/2024/11/01/survey-masters-graduates-2024 Pimentel, D. R., Horton, N. J. & Wilkerson, M. H. (2022), ‘Tools to support data analysis and data science in K–12 education: Commissioned paper for NASEM K–12 Data Science 48 Workshop’ . URL: https://nicholasjhorton.github.io/K12-Data-Tools/static/data_tools.pdf Prodromou, T. ...

work page 2022
[7]

& Parameswaran, A

URL: https://k12teacherstaffdevelopment.com/tlb/using-spreadsheets-in-the-classroom/ Rahman, S., Mack, K., Bendre, M., Zhang, R., Karahalios, K. & Parameswaran, A. (2020), Benchmarking spreadsheet systems, in ‘Proceedings of the 2020 ACM SIGMOD Inter- national Conference on Management of Data’, SIGMOD ’20, Association for Computing Machinery, New York, NY...

arXiv 2020
[8]

(2014), ‘Tidy data’, Journal of Statistical Software 59(10), 1–23

URL: https://ww2.amstat.org/censusatschool Wickham, H. (2014), ‘Tidy data’, Journal of Statistical Software 59(10), 1–23. URL: https://www.jstatsoft.org/index.php/jss/article/view/v059i10 Wing, J. M. (2006), ‘Computational thinking’, Communications of the ACM 49(3), 33–35. URL: https://doi.org/10.1145/1118178.1118215 Witte, V. & Schwering, A. (2025), ‘Dat...

work page arXiv 2014
[2025]

(2024), ‘Using AI chatbots to produce engineering spreadsheets in an ad- 42 vanced structural steel design course’

URL: https://web.spcollege.edu/instructors/uploads/481c6941b2/CGS1515_Syllabus_Section_0165.pdf Campbell, A. (2024), ‘Using AI chatbots to produce engineering spreadsheets in an ad- 42 vanced structural steel design course’ . URL: https://peer.asee.org/using-ai-chatbots-to-produce-engineering-spreadsheets-in-an- advanced-structural-steel-design-course Com...

work page 2024

Pith tools

Reviewed August 7, 2026 · model on record in the stance chip above.

[1] [1]

American Statistical Association (2020), ‘Pre-K-12 Guidelines for Assessment and Instruc- tion in Statistics Education I| (GAISE II): A Framework for Statistics and Data Science Education’ . URL: https://www.amstat.org/education/guidelines-for-assessment-and-instruction-in- statistics-education-(gaise)-reports Applications of Geometric Series | Grade 11 M...

arXiv 2020

[2] [2]

URL: https://iase-pub.org/ojs/SERJ/article/view/41 McDaniel, S. N. & Green, L. B. (2012), ‘Using applets and video instruction to foster students’ understanding of sampling variability’, Technology Innovations in Statistics Education 6(1). URL: http://dx.doi.org/10.5070/T561000177 46 McNamara, A. (2018), ‘Key attributes of a modern statistical computing t...

arXiv 2012

[3] [3]

D., Agarwal, M., A verett, M., Baumer, B

URL: https://studentprivacy.ed.gov/data-security-k-12-and-higher-education De Veaux, R. D., Agarwal, M., A verett, M., Baumer, B. S., Bray, A., Bressoud, T. C., Bryant, L., Cheng, L. Z., Francis, A., Gould, R. et al. (2017), ‘Curriculum guidelines for 43 undergraduate programs in data science’, Annual Review of Statistics and Its Application 4, 15–30. URL...

arXiv 2017

[4] [4]

Designing a Data Analysis Tool for Learners

URL: https://www.ed2go.com/bunkerhill/online-courses/intro-excel-microsoft-excel- 2019 Konold, C. (2007 a), ‘Designing a data analysis tool for learners’, Thinking with Data pp. 267–291. Konold, C. (2007 b), Thinking with Data , Lawrence Erlbaum Associates Publishers, chapter “Designing a Data Analysis Tool for Learners”, p. 267–291. Launched: Google Apps...

work page 2009

[5] [6]

R., Horton, N

URL: https://magazine.amstat.org/blog/2024/11/01/survey-masters-graduates-2024 Pimentel, D. R., Horton, N. J. & Wilkerson, M. H. (2022), ‘Tools to support data analysis and data science in K–12 education: Commissioned paper for NASEM K–12 Data Science 48 Workshop’ . URL: https://nicholasjhorton.github.io/K12-Data-Tools/static/data_tools.pdf Prodromou, T. ...

work page 2022

[6] [7]

& Parameswaran, A

URL: https://k12teacherstaffdevelopment.com/tlb/using-spreadsheets-in-the-classroom/ Rahman, S., Mack, K., Bendre, M., Zhang, R., Karahalios, K. & Parameswaran, A. (2020), Benchmarking spreadsheet systems, in ‘Proceedings of the 2020 ACM SIGMOD Inter- national Conference on Management of Data’, SIGMOD ’20, Association for Computing Machinery, New York, NY...

arXiv 2020

[7] [8]

(2014), ‘Tidy data’, Journal of Statistical Software 59(10), 1–23

URL: https://ww2.amstat.org/censusatschool Wickham, H. (2014), ‘Tidy data’, Journal of Statistical Software 59(10), 1–23. URL: https://www.jstatsoft.org/index.php/jss/article/view/v059i10 Wing, J. M. (2006), ‘Computational thinking’, Communications of the ACM 49(3), 33–35. URL: https://doi.org/10.1145/1118178.1118215 Witte, V. & Schwering, A. (2025), ‘Dat...

work page arXiv 2014

[8] [2025]

(2024), ‘Using AI chatbots to produce engineering spreadsheets in an ad- 42 vanced structural steel design course’

URL: https://web.spcollege.edu/instructors/uploads/481c6941b2/CGS1515_Syllabus_Section_0165.pdf Campbell, A. (2024), ‘Using AI chatbots to produce engineering spreadsheets in an ad- 42 vanced structural steel design course’ . URL: https://peer.asee.org/using-ai-chatbots-to-produce-engineering-spreadsheets-in-an- advanced-structural-steel-design-course Com...

work page 2024