The impact of sequencing and prior knowledge on learning mathematics through spreadsheet applications
Open accessThe DOI matches its Crossref record; 40 of the 44 references it cites were found in a registry or an index.
Abstract
According to cognitive load theory, instruction needs to be designed in a manner that facilitates the acquisition of knowledge in long-term memory while reducing unnecessary demands on working memory. When technology is used to deliver instruction, the sequence in which students learn to use the technology and learn the relevant subject matter may have cognitive load implications, and should interact with their prior knowledge levels. An experiment, using spreadsheets to assist studient learning of mathematics, indicated that for studients with little knowledge of spreadsheets, sequential instruction on spreadsheets followed by mathematics instruction was superior to a concurrent presentation. The reverse was found for studients with more knowledge of spreadsheets. These results are explained in terms of cognitive load theory.
Overview
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
Citations
Cites
The magical number seven, plus or minus two: Some limits on our capacity for processing information.
Miller, G. A. (1956) · Psychological Review · doi:10.1037/h0043158 · Cited by 17,812 · cited 1×
“Humans are only able to store and process a few novel combinations of elements or chunks at any given time (Miller, 1956).”
BackgroundThe magical number seven, plus or minus two: Some limits on our capacity for processing information.
Miller, G. A. (1994) · Psychological Review · doi:10.1037/0033-295x.101.2.343 · Cited by 17,161
Cognitive Load During Problem Solving: Effects on Learning
Sweller, J. (1988) · Cognitive Science · doi:10.1016/0364-0213(88)90023-7 · Cited by 11,048 · cited 2×
“Early research into CLT found that instructional formats that required problem-solving search strategies imposed a heavy working memory load that retarded learning (Sweller, 1988).”
BackgroundSelf-citationMayer, R. E. (2009) · doi:10.1017/cbo9780511811678 · Cited by 7,800
Mayer, R. (2020) · doi:10.1017/9781316941355 · Cited by 7,777
Cognitive Architecture and Instructional Design
Sweller, J., van Merrienboer, J. J. G., & Paas, F. G. W. C. (1998) · Educational Psychology Review · doi:10.1023/a:1022193728205 · Cited by 6,023 · cited 4×
“In particular, it is argued by cognitive load theorists (see Paas, Renkl, & Sweller, 2003; Sweller, 2003; Sweller et al., 1998) that information stored in long-term memory can vastly increase the capacity of working memory.”
BackgroundInfluentialSelf-citationThe Psychology of Learning and Motivation
(2021) · Psychology of Learning and Motivation · doi:10.1016/s0079-7421(21)x0002-3 · Cited by 5,027
The Taxonomy of Educational Objectives
(2012) · Encyclopedia of the Sciences of Learning · doi:10.1007/978-1-4419-1428-6_6027 · Cited by 4,103
Ericsson, K. A., & Kintsch, W. (1995) · Psychological Review · doi:10.1037/0033-295x.102.2.211 · Cited by 3,498 · cited 2×
“Working memory has no known limitations when dealing with previously learned information stored in long-term memory ( Ericsson & Kintsch, 1995 ).”
BackgroundCognitive Load Theory and Instructional Design: Recent Developments
Paas, F., Renkl, A., & Sweller, J. (2003) · Educational Psychologist · doi:10.1207/s15326985ep3801_1 · Cited by 3,041 · cited 5×
“The findings concerning the least experienced spreadsheet group are also consistent with the work of Kester et al. (2001, 2004, in press) , who found it advantageous to present additional information sequentially rather than simultaneously.”
BackgroundMethodResultInfluentialSelf-citation
Cited by
Items 201–226 of 226
Oqilat, A. (2013) · Griffith Research Online · doi:10.25904/1912/3099 · Cited by 4
Working Memory on Mathematical Problem Solving Activity: Case Study in Low Ability Students
Utami, N. W., & Warniasih, K. (2019) · Journal of Physics Conference Series · doi:10.1088/1742-6596/1254/1/012070 · Cited by 3
The Weight of Medical Authority: The Making and Unmaking of Knowledge in the Obesity Epidemic
Rogers, J. H. (2018) · eScholarship (California Digital Library) · Cited by 1
خليل, م. ج. م. (2020) · Maǧallaẗ Kulliyyaẗ Al-Tarbiyyaẗ Bil-Manṣūraẗ · doi:10.21608/maed.2020.174705 · Cited by 1
A Digital Wire for the Fostering Mathematical Medication Learning in Vocational Education
Zwart, D. P. (2021) · Utrecht University Repository (Utrecht University) · doi:10.33540/713
(2013) · IGI Global eBooks · doi:10.4018/978-1-4666-4876-0.chcrf
Clark, R. C., & Mayer, R. E. (2016) · Wiley eBooks · doi:10.1002/9781119239086.refs
Dehn, M. J. (2010) · Wiley eBooks · doi:10.1002/9781118269688.refs
Worked Examples Learning about the English Tense Grammatical Rules of Junior Middle School Students
张, 笑. (2022) · Advances in Psychology · doi:10.12677/ap.2022.126241
Demonstration-Based Training Model and Its Implications for Video Tutorial Design
胡, 勇. (2022) · Advances in Education · doi:10.12677/ae.2022.125271
المرادني, م. م. (2018) · تکنولوجيا التعليم سلسلة دراسات وبحوث · doi:10.21608/tesr.2018.224857
Axiomatic Theory of Intentional Systems (ATIS) and Options-Set Analyses for Education
Thompson, K. R. (2023) · Springer eBooks · doi:10.1007/978-3-319-17461-7_93
Shiralinejad, F., Ghasemi, M., & Emamipour, S. (2022) · doi:10.61838/kman.aftj.3.1.18 · Cited by 1
The Sociological Imagination in Challenging Times
Palmer, N. S. (2024) · The Journal of Public and Professional Sociology · doi:10.62915/2154-8935.1188 · Cited by 1
Paschke, J. D., & Ditta, A. S. (2024) · NACADA Journal · doi:10.12930/nacada-23-18 · Cited by 4
Bowen, B., & Peterson, B. (2024) · Journal of STEM Education Innovations and Research · doi:10.63504/jstem.v25i2.2644
“Clarke et al., (2005) determined that how activities are integrated in the classroom have an impact on student learning, and therefore teachers need to make informed choices about curriculum design.”
Liu, Z., & Jiao, L. (2025) · Journal of Intelligence · doi:10.3390/jintelligence13110137
“Pre-training is a well-established instructional strategy designed to reduce extraneous cognitive load (Clarke et al. 2005).”
(2015) · Emerald Group Publishing Limited eBooks · doi:10.1108/978-1-68123-136-520251015
Low, R., Jin, P., & Sweller, J. (2012) · Emerald Group Publishing Limited eBooks · doi:10.1108/book-978-1-61735-634-620251013 · Cited by 2
Self-citationGüzel, A. A., & Güzel, M. (2025) · Buca eğitim fakültesi dergisi (Online)/Buca Eğitim Fakültesi dergisi · doi:10.53444/deubefd.1597025 · Cited by 1
ŞAHİN, M., Başkurt, İ., & Deringöl, Y. (2026) · South African Journal of Education · doi:10.15700/saje.v46n1a2621
Hachmi, A. (2026) · Physics Education · doi:10.1088/1361-6552/ae5568
(2026) · Cambridge University Press eBooks · doi:10.1017/9781009776660.021
Manage: Principles to Help Learners Manage the Flow of Relevant Information
Mayer, R. E. (2026) · Cambridge University Press eBooks · doi:10.1017/9781009776660.019
Zhang, Y., Gao, J., Huang, X., Li, S., Wu, M., Lin, Y., & Lobczowski, N. G. (2026) · Canadian Journal of Science Mathematics and Technology Education · doi:10.1007/s42330-026-00494-1
“The results were echoed by a study, which also identified that students with prior knowledge gained less in mathematics than students with less knowledge (Clarke et al., 2005).”
Metadata
- Authors
- Clarke, T., Ayres, P., & Sweller, J.
- Affiliations
- UNSW Sydney (AU)
- Corresponding author
- Ayres, Paul
- Venue
- Educational Technology Research and Development
- Published
- 2005-09
- Volume
- 53
- Issue
- 3
- Pages
- 15-24
- ISSN
- 1042-1629 (ISSN-L)
- 1556-6501
- OpenAlex
- W2140072163
- Cited by
- 227
- References
- 44
- Citations by year
- 2026: 6 · 2025: 6 · 2024: 8 · 2023: 9 · 2022: 13 · 2021: 12 · 2020: 15 · 2019: 10 · 2018: 14 · 2017: 9 · 2016: 17 · 2015: 15 · 2014: 9 · 2013: 20 · 2012: 8
- FWCI
- 10.82
- Type
- journal article
- Language
- en
- Open access
- green
- handle.unsw.edu.au
- Licence
- cc-by-nc-nd
- www.springer.com/tdm (tdm)
- Locations
- Educational Technology Research and Development (publishedVersion)
- UNSWorks (UNSW Sydney) (submittedVersion, cc-by-nc-nd)
- UNSWorks (University of New South Wales, Sydney, Australia) (submittedVersion, cc-by-nc-nd)
- Topics
- Social Sciences › Psychology › Experimental and Cognitive Psychology › Visual and Cognitive Learning Processes
- Social Sciences › Education › Mathematics Education and Teaching Techniques
- Social Sciences › Psychology › Developmental and Educational Psychology › Innovative Teaching and Learning Methods
- Keywords
- cognitive load theory, spreadsheet software, mathematics learning, prior knowledge, instructional sequencing, working memory, long-term memory, technology-assisted instruction
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.