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-citationCognitive Load Measurement as a Means to Advance Cognitive Load Theory
Paas, F., Tuovinen, J. E., Tabbers, H., & Van Gerven, P. W. M. (2003) · Educational Psychologist · doi:10.1207/s15326985ep3801_8 · Cited by 2,527
Mayer, R. E. (2001) · doi:10.1017/cbo9781139164603 · Cited by 2,304
Expert and Novice Performance in Solving Physics Problems
Larkin, J., McDermott, J., Simon, D. P., & Simon, H. A. (1980) · Science · doi:10.1126/science.208.4450.1335 · Cited by 2,109 · cited 1×
“A schema (see Chi, Glaser, & Rees, 1982; Larkin, McDermott, Simon, & Simon, 1980 ) can be defined as a cognitive construct that allows multiple elements of information to be treated as a single element categorized according to its use.”
BackgroundKalyuga, S., Ayres, P., Chandler, P., & Sweller, J. (2003) · Educational Psychologist · doi:10.1207/s15326985ep3801_4 · Cited by 1,927
Self-citationAdvances in the psychology of human intelligence
Eysenck, H. J. (1983) · Behaviour Research and Therapy · doi:10.1016/0005-7967(83)90111-0 · Cited by 1,563
Michelene, T. H., Glaser, R. A., & Rees, E. T. (1981) · Defense Technical Information Center (DTIC) · Cited by 1,531
The Use of Worked Examples as a Substitute for Problem Solving in Learning Algebra
Sweller, J., & Cooper, G. A. (1985) · Cognition and Instruction · doi:10.1207/s1532690xci0201_3 · Cited by 1,214 · cited 2×
“To avoid such problem-solving approaches and enhance learning, instructional designers have successfully employed worked examples in a number of domains, including mathematics (see Cooper & Sweller, 1987; Paas & van Merrienboer, 1994; Sweller & Cooper, 1985 ).”
MethodSelf-citationPaas, F. G. W. C., & Van Merriënboer, J. J. G. (1994) · Journal of Educational Psychology · doi:10.1037/0022-0663.86.1.122 · Cited by 1,198 · cited 2×
“To avoid such problem-solving approaches and enhance learning, instructional designers have successfully employed worked examples in a number of domains, including mathematics (see Cooper & Sweller, 1987; Paas & van Merrienboer, 1994; Sweller & Cooper, 1985).”
BackgroundMethodMayer, R. E., & Anderson, R. B. (1992) · Journal of Educational Psychology · doi:10.1037/0022-0663.84.4.444 · Cited by 1,000 · cited 4×
“That is best depicted in temporal contiguity in order to permit learners Table 2 Group means and standard deviations (in brackets) of test scores and cognitive load measures to more easily make important connections (see Mayer & Anderson, 1991, 1992).”
BackgroundInfluential(1999) · Cited by 944
Self-citationPaas, F. G. W. C., & Van Merriënboer, J. J. G. (1993) · Human Factors: The Journal of the Human Factors and Ergonomics Society · doi:10.1177/001872089303500412 · Cited by 921 · cited 1×
“Su bj ective measures have been used extensively by cognitive load researchers to obtain a measure of cognitive load (see Paas & van Merriënboer, 1993; Paas, Tuovinen, Tabbers, & van Gerven, 2003), and were employed in this study.”
MethodAnimations need narrations: an experimental test of a dual-coding hypothesis.
Mayer, R. E., & Anderson, R. B. (1991) · Journal of Educational Psychology · doi:10.1037/0022-0663.83.4.484 · Cited by 883 · cited 2×
“That is best depicted in temporal contiguity in order to permit learners Table 2 Group means and standard deviations (in brackets) of test scores and cognitive load measures to more easily make important connections (see Mayer & Anderson, 1991, 1992).”
BackgroundTaking the Load Off a Learner's Mind: Instructional Design for Complex Learning
van Merrienboer, J. J. G., Kirschner, P. A., & Kester, L. (2003) · Educational Psychologist · doi:10.1207/s15326985ep3801_2 · Cited by 857 · cited 3×
“van Merriënboer et al. (2003) have argued that”
BackgroundResultInfluentialWhy are some problems hard? Evidence from Tower of Hanoi
Kotovsky, K., Hayes, J. R., & Simon, H. A. (1985) · Cognitive Psychology · doi:10.1016/0010-0285(85)90009-x · Cited by 722
Assimilating complex information
Pollock, E., Chandler, P., & Sweller, J. (2002) · Learning and Instruction · doi:10.1016/s0959-4752(01)00016-0 · Cited by 692 · cited 1×
“CLT researchers have identified strategies to reduce intrinsic cognitive load, such as isolating integrated elements in instructional materials ( Pollock, Chandler, & Sweller, 2002 ) and simpleto-complex sequencing of learning tasks (van Merrienboer, Kirschner, & Kester, 2003).”
BackgroundSelf-citationEffects of schema acquisition and rule automation on mathematical problem-solving transfer.
Cooper, G., & Sweller, J. (1987) · Journal of Educational Psychology · doi:10.1037/0022-0663.79.4.347 · Cited by 688 · cited 4×
“A workedexample approach requires learners to study solutions to problems rather than just solve them, although in most applications of the workedexamples approach, learners also solve some problems, either in a paired format (study one, solve a similar one, see Cooper & Sweller, 1987 ), or as completion problems (com…”
BackgroundMethodInfluentialSelf-citationRenkl, A., & Atkinson, R. K. (2003) · Educational Psychologist · doi:10.1207/s15326985ep3801_3 · Cited by 540 · 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.”
BackgroundInfluentialEvolution of human cognitive architecture
Sweller, J. (2003) · Psychology of Learning and Motivation · doi:10.1016/s0079-7421(03)01015-6 · Cited by 511 · 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-citationGuidance during mathematical problem solving.
Tarmizi, R. A., & Sweller, J. (1988) · Journal of Educational Psychology · doi:10.1037/0022-0663.80.4.424 · Cited by 464 · cited 2×
“Researchers have overcome this impediment to learning by devising strategies that physically integrate the two sources, thus eliminating split attention (see Tarmizi & Sweller, 1988 ).”
BackgroundSelf-citationResearch on cognitive load theory and its design implications for e-learning
van Merriënboer, J. J. G., & Ayres, P. (2005) · Educational Technology Research and Development · doi:10.1007/bf02504793 · Cited by 399
Self-citationMoreno, R., & Valdez, A. (2005) · Educational Technology Research and Development · doi:10.1007/bf02504796 · Cited by 274
Schnotz, W., & Rasch, T. (2005) · Educational Technology Research and Development · doi:10.1007/bf02504797 · Cited by 273
Learner Experience and Efficiency of Instructional Guidance
Kalyuga, S., Chandler, P., & Sweller, J. (2001) · Educational Psychology · doi:10.1080/01443410124681 · Cited by 184 · cited 1×
“Worked examples, for instance, are very effective for novices (van Merrienboer and Ayres, this issue), but as expertise develops (resulting in more sophisticated schemas), a problem-solving approach may be superior ( Kalyuga, Chandler, & Sweller, 2001 ).”
BackgroundSelf-citationJust-in-time information presentation and the acquisition of complex cognitive skills
Kester, L., Kirschner, P. A., van Merriënboer, J. J. G., & Baumer, A. (2001) · Computers in Human Behavior · doi:10.1016/s0747-5632(01)00011-5 · Cited by 119
Kester, L., Kirschner, P. A., & van Merriënboer, J. J. G. (2005) · British Journal of Educational Psychology · doi:10.1348/000709904x19254 · Cited by 115
Some Conditions under Which Integrated Computer-Based Training Software Can Facilitate Learning
Cerpa, N., Chandler, P., & Sweller, J. (1996) · Journal of Educational Computing Research · doi:10.2190/mg7x-4j8n-ckyr-p06t · Cited by 99 · cited 1×
“From an e-learning perspective, research has shown that the split-source of a computer screen and manual can be eliminated by integrating all material into a computer manual only (Chandler & Sweller, 1996), or onto a computer screen only ( Cerpa, Chandler, & Sweller, 1996; Moreno & Valdez, this issue).”
MethodSelf-citationCognitive load theory and instructional design
Sweller, J., Chandler, P., & Tindall‐Ford, S. (1997) · Research Online (University of Wollongong) · Cited by 80
Self-citationWallen, E. S., Plass, J. L., & Brünken, R. (2005) · Educational Technology Research and Development · doi:10.1007/bf02504798 · Cited by 76
Timing of Information Presentation in Learning Statistics
Kester, L., Kirschner, P. A., & van Merriënboer, J. J. G. (2004) · Instructional Science · doi:10.1023/b:truc.0000024191.27560.e3 · Cited by 68 · cited 1×
“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.”
Result(1996) · doi:10.1002/(sici)1099-0720(199604)10:2<151::aid-acp380>3.0.co;2-u
Self-citation
Cited by
Cognitive load theory, educational research, and instructional design: some food for thought
de Jong, T. (2010) · Instructional Science · doi:10.1007/s11251-009-9110-0 · Cited by 1,180
Expertise Reversal Effect and Its Implications for Learner-Tailored Instruction
Kalyuga, S. (2007) · Educational Psychology Review · doi:10.1007/s10648-007-9054-3 · Cited by 1,056
“Thus, acquiring basic technology skills while learning a specific subject discipline is unlikely to be effective for beginners, and the technology should be learned prior to learning a specific subject area ( Clarke et al. 2005 ).”
BackgroundInfluentialSCHMIDT, H. G., LOYENS, S. M. M., VAN GOG, T., & PAAS, F. (2007) · Educational Psychologist · doi:10.1080/00461520701263350 · Cited by 382
“When an instructional technique or technology is used that is in itself unfamiliar, it is important to train students in it before instruction starts, in order to reduce the additional extraneous cognitive load that engaging in this technique or with this technology would bring along (cf. Clarke, Ayres, & Sweller, 200…”
MethodHandbook of Research on Effective Electronic Gaming in Education
(2009) · IGI Global eBooks · doi:10.4018/978-1-59904-808-6 · Cited by 363
Integrating cognitive load theory and concepts of human–computer interaction
Hollender, N., Hofmann, C., Deneke, M., & Schmitz, B. (2010) · Computers in Human Behavior · doi:10.1016/j.chb.2010.05.031 · Cited by 328
“Clarke, Ayres, and Sweller (2005) showed that training learners to use a spreadsheet application prior to mathematics instruction reduces memory load compared to concurrently receiving instructions on spreadsheet usage and on mathematics.”
BackgroundMethodInfluential
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.