ArticlePDF Available

Spreadsheets in Education –The First 25 Years

Authors:

Abstract

Spreadsheets made their first appearance for personal computers in 1979 in the form of VisiCalc, an application designed to help with accounting tasks. Since that time, the diversity of applications of the spreadsheet program is evidenced by its continual reappearance in scholarly journals. Nowhere is its application becoming more marked than in the field of education. From primary to tertiary levels, the spreadsheet is gradually increasing in its importance as a tool for teaching and learning. By way of an introduction to the new electronic journal Spreadsheets in Education, the editors have compiled this overview of the use of spreadsheets in education. The aim is to provide a comprehensive bibliography and springboard from which others may develop their own applications and reports on educational applications of spreadsheets. For despite its rising popularity, the spreadsheet has still a long way to go before becoming a universal tool for teaching and learning, and many opportunities for its application have yet to be explored.The basic paradigm of an array of rows-and-columns with automatic update and display of results has been extended with libraries of mathematical and statistical functions, versatile graphing and charting facilities, powerful add-ins such as Microsoft Excel’s Solver, attractive and highlyfunctional graphical user interfaces, and the ability to write custom code in languages such as Microsoft’s Visual Basic for Applications. It is difficult to believe that Bricklin, the original creator of VisiCalc could have imagined the modern form of the now ubiquitous spreadsheet program. But the basic idea of the electronic spreadsheet has stood the test of time; indeed it is nowadays an indispensable item of software, not only in business and in the home, but also in academe. This paper briefly examines the history of the spreadsheet, then goes on to give a survey of major books, papers and conference presentations over the past 25 years, all in the area of educational applications of spreadsheets.
Spreadsheets in Education (eJSiE)
|Issue 1Volume 1 Article 2
7-24-2007
Spreadsheets in Education –The First 25 Years
John Baker
Natural Maths, john@naturalmaths.com.au
Stephen J. Sugden
Bond University, ssugden@bond.edu.au
This Regular Article is brought to you by the Faculty of Business at ePublications@bond. It has been accepted for inclusion in Spreadsheets in
Education (eJSiE) by an authorized administrator of ePublications@bond. For more information, please contact Bond University's Repository
Coordinator.
Recommended Citation
Baker, John and Sugden, Stephen J. (2003) "Spreadsheets in Education –The First 25 Years," Spreadsheets in Education (eJSiE): Vol. 1:
Iss. 1, Article 2.
Available at: http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education –The First 25 Years
Abstract
Spreadsheets made their first appearance for personal computers in 1979 in the form of VisiCalc, an
application designed to help with accounting tasks. Since that time, the diversity of applications of the
spreadsheet program is evidenced by its continual reappearance in scholarly journals. Nowhere is its
application becoming more marked than in the field of education. From primary to tertiary levels, the
spreadsheet is gradually increasing in its importance as a tool for teaching and learning. By way of an
introduction to the new electronic journal Spreadsheets in Education, the editors have compiled this
overview of the use of spreadsheets in education. The aim is to provide a comprehensive bibliography and
springboard from which others may develop their own applications and reports on educational applications
of spreadsheets. For despite its rising popularity, the spreadsheet has still a long way to go before becoming a
universal tool for teaching and learning, and many opportunities for its application have yet to be explored.
The basic paradigm of an array of rows-and-columns with automatic update and display of results has been
extended with libraries of mathematical and statistical functions, versatile graphing and charting facilities,
powerful add-ins such as Microsoft Excel’s Solver, attractive and highlyfunctional graphical user interfaces,
and the ability to write custom code in languages such as Microsoft’s Visual Basic for Applications. It is
difficult to believe that Bricklin, the original creator of VisiCalc could have imagined the modern form of the
now ubiquitous spreadsheet program. But the basic idea of the electronic spreadsheet has stood the test of
time; indeed it is nowadays an indispensable item of software, not only in business and in the home, but also
in academe. This paper briefly examines the history of the spreadsheet, then goes on to give a survey of major
books, papers and conference presentations over the past 25 years, all in the area of educational applications
of spreadsheets.
Keywords
Spreadsheet, education, mathematics education, statistics education, survey.
This regular article is available in Spreadsheets in Education (eJSiE): http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
John E Baker
Director, Natural Maths
john@naturalmaths.com.au
Stephen J Sugden
School of Information Technology, Bond University
ssugden@bond.edu.au
July 24, 2003
Communicated by S. Abramovich.
Submitted June 2003; revised and accepted July 2003.
Abstract
Spreadsheets made their rst appearance for personal computers in 1979 in the form of VisiCalc
[45], an application designed to help with accounting tasks. Since that time, the diversity of
applications of the spreadsheet program is evidenced by its continual reappearance in scholarly
journals. Nowhere is its application becoming more marked than in the eld of education. From
primary to tertiary levels, the spreadsheet is gradually increasing in its importance as a tool for
teaching and learning. By way of an introduction to the new electronic journal Spreadsheets in
Education, the editors have compiled this overview of the use of spreadsheets in education. The
aim is to provide a comprehensive bibliography and springboard from which others may develop
their own applications and reports on educational applications of spreadsheets. For despite its
rising popularity, the spreadsheet has still a long way to go before becoming a universal tool for
teaching and learning, and many opportunities for its application have yet to be explored.
The basic paradigm of an array of rows-and-columns with automatic update and display of results
has been extended with libraries of mathematical and statistical functions, versatile graphing
and charting facilities, powerful add-ins such as Microsoft Excel’s Solver, attractive and highly-
functional graphical user interfaces, and the ability to write custom code in languages such as
Microsoft’s Visual Basic for Applications. It is dicult to believe that Bricklin, the original
creator of VisiCalc could have imagined the modern form of the now ubiquitous spreadsheet
program. But the basic idea of the electronic spreadsheet has stood the test of time; indeed it
is nowadays an indispensable item of software, not only in business and in the home, but also
in academe. This paper briey examines the history of the spreadsheet, then goes on to give a
survey of major books, papers and conference presentations over the past 25 years, all in the area
of educational applications of spreadsheets.
Keywords: Spreadsheet, education, mathematics education, statistics education, survey.
1ABriefHistory
Paper-based spreadsheets have been around for centuries, primarily for use as record-keeping and
accounting tools. The rst electronic spreadsheet, VisiCalc [45], [36] appeared in 1979, created by
Dan Bricklin (concept) and Bob Frankston (programmer) for the Apple II platform. It was conceived
and developed as a tool to do repetitive calculations for Bricklin’s studies at Harvard Business School.
They formed a company, Software Arts, to market the product. In 1981, Bricklin received the Grace
Murray Hopper Award from the Association for Computing Machinery (ACM) for the creation of
VisiCalc. It has been said that VisiCalc was the application, more than any other that sold millions
of Apple II computers. Houghton [87] notes:
The invention of the spreadsheet made personal computers have real value in the marketplace
and legitimated the personal computer industry. Without the invention of this software category,
spreadsheets, the impact of the personal computer might have been delayed for years.
eJSiE 1(1):18-43 c
°2003 Bond University. All rights reserved.
http://www.sie.bond.edu.au 1
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
Bricklin and Frankston sold the rights in VisiCalc to Lotus Development Corporation, which
developed Lotus 1-2-3, a huge killer application for the new IBM PC in 1982. This product introduced
rudimentary database and graphics functionality into the spreadsheet domain, and it dominated
the market for most of the 1980s. Then came Microsoft Excel, which was developed rst for the
Apple Macintosh, but which was also the rst real Microsoft Windows application. In fact, the
earliest versions of Excel ran under MS-DOS, but with a special Windows runtime environment [193].
Other major spreadsheets were SuperCalc (1980, for CP/M operating system), Multiplan (Microsoft),
PlanPerfect (WordPerfect Corp.), Quattro Pro (Borland), VP-PLANNER and AsEasyAs. Since the
mid-1990s, Microsoft has held the dominant market share, and now commands in excess of 90% of
the spreadsheet market [193].
The basic paradigm of an array of rows-and-columns with automatic update and display of re-
sults has been extended with libraries of mathematical and statistical functions, versatile graphing
and charting facilities, powerful add-ins such as Microsoft r
°Excel’s Solver, attractive and highly-
functional graphical user interfaces, and the ability to write custom code in languages such as Mi-
crosoft’s Visual Basic for Applications r
°.
Useful summaries of spreadsheet history are given by Power [154] and Walkenbach [194] and
the authors gratefully acknowledge these sources in preparing the present very brief section on the
historical background and emergence of electronic spreadsheets. Dan Bricklin’s own website [45] has
some very interesting titbits of information and, at the time of writing, also includes a downloadable
copy of VisiCalc. Bob Frankston’s website [71] is also interesting.
2 Programming vs Spreadsheets
As early as 1984, just one year after Lotus 1-2-3 made its presence felt in the commercial market,
educators were beginning to discuss their experiences with using spreadsheets in education [25], [26].
Hsiao [88] makes the point that while computers are clearly useful tools for education generally, one
of the main disadvantages is having to program them. In many cases, (at least in 1985), students
had to learn a programming language in order to benet from computers. Hsiao observes that use
of spreadsheets helps to get around this problem. This view is still supported by other writers; for
example, Morishita et al [133] state that:
Our experience in computing was that it took a very long time to learn computer languages
and it was sometimes very hard to obtain proper results in a limited time. The spreadsheet,
however, is rather easy to use and almost instantaneous numerical simulations are possible.
Hsiao considers examples such as function tabulation and plotting, integration by Simpson’s rule,
and makes a brief mention of the possibility of matrix computations, including the Gauss-Jordan and
inverse matrix methods of solving linear algebraic systems. Although this is quite an old paper, it is
clear that the potential for educational uses of spreadsheets wherever mathematics is involved was
obvious to many people even in the early 1980s. The author makes some interesting closing remarks.
1. The rst is that the spreadsheet has allowed teachers to adopt a middle course, compared to
the extremes of fully coding an algorithm in some programming language such as BASIC or
Pascal, or using an o-the-shelf package with a canned solution. It is argued that neither of
these methods is ideal for learning and the spreadsheet approach is recommended.1
2. The second one concerns the absence (in 1985) of a number of desirable features, such as
transposition of rows and columns, absence of regression lines on scatter graphs, 3D graphs, and
so on; all of these features are available in modern versions of spreadsheets such as Microsoft’s
Excel.
1In many instances, at least, the present authors are in agreement.
eJSiE 1(1):18-43 19
2
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
Essentially the same points are made in a more recent paper by Steward [176]:
I would suggest that when both are possible, students nd it easier and quicker to use a
spreadsheet than write a computer program. Moreover, once written a program can often mask
the mathematics that it is intended to represent, while on a spreadsheet the procedure is constantly
exposed.
In this paper [176], the author considers three examples illustrating his claim: linear regression
from rst principles, convergence of recursive sequences, and rst-order ordinary dierential equa-
tions.
Relf and Almeida [157] give the example of the spreadsheet being used to (comprehensively) solve
the Birthday Problem, which can be stated as nding the least number of people in a group for which
there is a probability 0.5 that two will have the same birthday. In comparing the cost/benets of
programming vs spreadsheets, they say:
...theprimeneedis foramediumwhich will facilitate consideration of conceptual issues while
requiring minimal technical expertise, will provide insights into the mathematical context without
necessitating attention to extraneous distractions, will permit modication without the need for
major changes in design and will ag and encourage the pursuit of connected enquiries.
It is the spreadsheet that meets all of the above.
With access to VBA (Visual Basic for Applications), educators are also nding great benetin
tying programming to spreadsheet use, thereby overcoming much of the time spent in organizing data
input and output. For example, Martin [121] outlines a course for Operations Research students in
which he reports that:
...using the spreadsheet as a platform, the student is led to a position where they can write
virtually a stand-alone program to support a simple OR application, even from a position of little
previous spreadsheet or computing experience.
From the above, it appears that if the goal is not to teach a programming language, but to achieve
understanding of a concept/topic for which some sort of program is needed to show, for example,
variation over time, then the spreadsheet should be the rst choice.
3 Packages vs Spreadsheets
The Association for Educational Communications and Technology (AECT) has a useful website, and,
in particular, an interesting page [201] entitled Spreadsheets as cognitive tools. On it, we read the
following quotation from the doctoral dissertation of Leon Argyla [109]:
Spreadsheets are powerful problem-solving tools. However, the diculty in using spreadsheets
for problem solving depends on the amount of abstractness and information processing the problem
contains (Leon-Argyla, 1988).
At the same time as spreadsheets, a number of computer packages have been developed that
parallel business and educational applications. In the arenas of statistics and geometry, sites such as
CTI2[202] and CIGS3[203] show that specially designed packages are preferred to the computational
and graphical features of spreadsheets.
However, on the benet side, we would suggest that:
2ComputersinTeachingInitiative
3Corner for Interactive Geometry Software
20 eJSiE 1(1):18-43
3
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
1. Building spreadsheets requires abstract reasoning by the learner.
2. Spreadsheets are rule-using tools that require that users become rule-makers (Vockell and van
Deusen [192]).
3. Spreadsheets promote more open-ended investigations, problem-oriented activities, and active
learning by students (Beare [31]).
Feicht [67] describes the use of Excel to investigate relationships between matrices and geomet-
ric transformations, and in doing so, opens up a very rich eld for further investigation. Today’s
mathematical syllabus has little time for geometry, but it may see a resurgence if it can be shown
that electronic versions of theorems have the power to excite the imagination and enthusiasm of
learners–see the mathematics site of Bogomolny [204], which is testimony to the power of animating
concepts in mathematics and statistics. For an example hosted in Microsoft Excel, consider the work
of Staples [175]. We have seen that when it comes to programming, spreadsheets have desirable
features; it may be that in the future, the animation of concepts is an area in which spreadsheets
will have an increasingly inuential role over computer packages.
4MathematicsEducation
For applications of spreadsheets in mathematics education, especially that of mathematics educators,
Abramovich, along with co-workers, is the most prolic author ([1]—[22], [110]). Indeed, Abramovich
and co-workers are leading the eld in this area. The website [1] for Abramovich’s course “Using
Spreadsheets in Teaching School Mathematics” contains a number of useful links, and is well-worth
investigating. Abramovich and Brantlinger [11] examine the suitability of spreadsheets for mathe-
matics teacher education. They note that the typical classroom is not well-equipped when it comes
to a range of mathematical software.
The appearance of computers as alternative instructional tools has created serious problems in
undergraduate pedagogy. This is particularly the case for mathematics teacher education, because
technology as a mathematical/pedagogical tool is not always used appropriately in schools. Indeed,
some teachers who attempt to incorporate technology into the curriculum limit its use to routine
computations only due to a lack of experience with this technology. The mathematics education
community views this problem as a great challenge to educational reform [11].
In [10], the same authors give examples of the use of recursion in a spreadsheet, the visualization
of the limit of a sequence, and cobweb diagrams. The paper concludes that, given the wide avail-
ability of spreadsheets, a toolkit of computer resources (such as a scientic calculator, a graphing
package and a database program) can be just one program: a modern spreadsheet. Abramovich and
Norton [15] extend this work to investigation of chaos, and associated basic concepts of convergence,
divergence, cycling and period doubling. They further argue that for mathematics education majors,
the spreadsheet is the ideal vehicle for the illustration of mathematical fundamentals such as these.
Similar topics are covered in another paper by Abramovich et al [13].
4.1 Collaborative Constructivist Learning
D’Souza and Wood [200] investigate the benets of spreadsheets in a collaborative learning environ-
ment at secondary school level, with the application being elementary nancial mathematics. The
authors state that:
Spreadsheets have enormous potential for assisting in the learning of algebraic concepts. They
can be of great benet at all levels. Spreadsheets enable students to concentrate on thinking about
the subject matter at hand rather than on the software. There are many mathematical applications
of spreadsheets as noted by Beare [32].
eJSiE 1(1):18-43 21
4
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
It is worth repeating the relevant citation from Beare [32]:
Spreadsheets.... have a number of very signicant benetsmanyofwhichshouldnowbe
apparent. Firstly they facilitate a variety of learning styles which can be characterised by the
terms: open-ended, problem-oriented, constructivist, investigative, discovery oriented, active and
student-centred. In addition they oer the following additional benets: they are interactive; they
give immediate feedback to changing data or formulae; they enable data, formulae and graphical
output to be available on the screen at once; they give students a large measure of control and
ownership over their learning; and they can solve complex problems and handle large amounts of
data without any need for programming.
Herrington and Standen [84] consider that many multimedia educational packages tend to present
material in an instructivist manner, thus placing the learner in a passive role. They would prefer to
see learning posed in an authentic setting to provide a constructivist learning environment, and it is
the spreadsheet that provides just such an environment4.
In a 1997 conference presentation, Sher [165] asserts that:
The spreadsheet is the ideal environment for software that follows the Harvard ap-
proach.
In a nutshell, the so-called Harvard approach [for mathematics teaching] is that every topic should
be presented geometrically, numerically, and algebraically. Such an approach is exemplied in the
work of Hughes-Hallett [89] and many others. Similarly, Friedlander [72] suggests that:
Spreadsheets build an ideal bridge between arithmetic and algebra and allow the student free
movement between the two worlds. Students look for patterns, construct algebraic expressions,
generalize concepts, justify conjectures, and establish the equivalence of two models as intrinsic
and meaningful needs rather than as arbitrary requirements posed by the teacher.
Thus, in mathematics education, we are seeing the emergence of the spreadsheet as a key compo-
nent of the constructivist teaching repertoire. There is no doubt that this role will grow in importance,
as students become more and more competent in the mechanics of using spreadsheets.
We close this section with some comments from a relatively modern work, that of Ainley et al
[24]:
Over recent years, we have explored the conjecture that particular pedagogical settings that
exploit immediate and continuous access to computers can change the way in which knowledge
about graphs is constructed.
...the spreadsheet provides the facilities that allowed Clara and Colin to construct these mean-
ings for trend ...
...Through activities with spreadsheets in this pedagogic setting, children expressed new mean-
ings in which scattergraphs became increasingly powerful tools for analysing ongoing experiments.
4.2 K-12 mathematics
Lewis [114] notes that:
Spreadsheet assignments oer concrete ways to explore abstract concepts in mathematics and
other subjects.
4We are not implying here that spreadsheets are the silver bullet that will transform traditional classrooms into
constructivist ones. Indeed, it is quite possible to imagine students being taught to program spreadsheets in teacher-
centred ways.
22 eJSiE 1(1):18-43
5
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
Lewis [115] has also produced a spreadsheet resource book for mathematics teachers of grades
K-8. Nowhere is the exploration of an abstract concept more fully researched than in the study of
Sutherland and Rojano [184] in which the potential of the spreadsheet to enable students to form a
correct understanding of algebraic concepts such as pronumerals is investigated. This frequently cited
work, in a sense, sets the benchmark for educational studies of spreadsheet potential. Sutherland
[187] has much more recently used the spreadsheet environment to allow secondary school students
in the UK to develop basic concepts of algebraic dependency. Since the students have trouble with
the abstract nature of algebra, the spreadsheet is used to develop relationships with point-and-click.
Note the following remarks from Sutherland’s paper [187]:
The more traditional approach to teaching algebra often involved imposing an algebraic
method with an over-emphasis on the manipulation of symbols and with no acknowledgement
of the value of the pupils’ own approaches. This way of teaching algebra was only successful for
the minority of pupils.
Our experimental work has shown that most pupils do not spontaneously engage in the alge-
braic processes of expressing generality, acknowledging and manipulating the unknown, focusing
on structure, using an analytic algebraic method.
One way to help pupils move from a non-algebraic to an algebraic approach can be through
work with spreadsheets. . . ..Pupils use the mouse to support the expression of general relationships
and to move from thinking with situation-based to more abstract algebraic objects. . . ..Mouse
pointing becomes a way of supporting pupils to express general relationships, which are then
represented automatically in spreadsheet code. Pupils become aware of this spreadsheet code
without explicit instruction and interact with it when they need to modify their constructions.
They begin to use the spreadsheet code in their talk when communicating with their partner and
can write it down when communicating with others. In this way the algebra-like spreadsheet code
is learned eortlessly without explicit teaching. Pupils use the spreadsheet specic calculations
to help in the construction of general rules and often verify their general rule with reference to
specic numbers. In this way links between symbols and general numbers are established.
Similar comments are made by Abramovich [12]. Referring to a spreadsheet model to support an
inductive proof, it is stated that the model:
...allowsforthevisualizationofaninductive proof of combinatorial identity, and it cognitively
supports a transition from computing to a formal language of mathematics.
Ruthven & Hennessy [162] give an account of the use of various forms of computer technology and
software to support mathematics learning in seven English secondary schools, in the year 2000. In
this rather lengthy paper, although there is much interesting material, we generally conne ourselves
here to aspects relevant to spreadsheets. Some of the major points are:
1. Students are nowadays more familiar with basic IT applications, including spreadsheets, so that
much less time is spent on trivial matters in Excel, and the class can spend most of its time on
mathematical activities within the spreadsheet. This is in contrast to the graphics calculator,
which is not as ubiquitous as the spreadsheet, and is typically only used in mathematics classes,
whereas the spreadsheet could be used in IT skills courses, business, economics, etc.; it is a
more generic tool.
2. Teacher and students have more control over spreadsheet models, e.g., sequences, than for other
software.
3. In a comparison of classes of software used for mathematics instruction and modelling in the
seven schools (courseware, graphware, Logo, spreadsheet), the spreadsheet was the only one in
use at all the schools.
eJSiE 1(1):18-43 23
6
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
4. A teacher at one school had his year 11 students doing statistical text processing in Excel:
some text from newspaper website was transferredintoExcel,thenanalyzedstatistically,in a
short space of time.
In hindsight it seems obvious, but probably one of the most profound, clear benets of using
spreadsheets that emerges from this study is just that of saving time. The time gained can then be
spent on investigating properties of the mathematical objects created in the spreadsheet environment:
the so-called what-if scenarios. There is huge scope for investigation of dependence on parameters in
almost any spreadsheet model of a mathematical process. This includes not only the “traditional”
mathematics that we might classify under the headings of algebra, calculus, trigonometry, geometry
etc., but also more modern and discrete areas such as string processing, language theory, automata
theory, and of course, combinatorics and recurrence relations. Note the following comments from a
teacher of years 7 and 8:
We’ve used spreadsheets in Year 7 and 8, to enable them to look at handling data, because
they can quickly get tables and produce charts that are much better quality than those that they
can produce themselves. I’ve got the bottom set in Year 7 and it can take them the whole lesson
to draw a bar chart. So it’s particularly successful from that point of view because they don’t
have to draw all the axes so much, and it doesn’t take them so long to develop the ideas because
they’re not having to spend a whole lesson drawing something. They can draw twenty graphs in
a lesson and actually see connections, rather than spend twenty minutes drawing the axes and
then twenty minutes talking and then twenty minutes drawing all the graph.
It saves a lot of time as well with the Further Maths and the graphing that we did. It would
have taken forever to actually plot all the points and see what happens when you transform certain
shapes. Whereas it was done in a ash and they could see and they learnt an awful lot. So then
they were ready and they’d accepted it because they’d seen it happening... Whereas it would have
taken many lessons if we’d actually plotted all these graphs, they’d have just got bored by it. So
that denitely helped, just kept the pace going. [162]
It needs to be added that, despite the growing number of studies that show positive results for
the use of spreadsheets, curriculum goals such as those produced by State and National Education
Departments place less emphasis on the role of spreadsheets than on that of calculators as a tool for
social constructivism in mathematics. There is little doubt that the main reason for this emphasis
on calculators is based on educational administrators being constrained by the number of computers
that are available in any given classroom. As a referee of this paper has noted: “it is not that
graphing calculators are a superior tool it is rather that graphing calculators are a more accessible
tool.” However, curriculum administrators are beginning to acknowledge the enormous potential of
the modern spreadsheet program to enhance learning opportunities.
For a review of the K-12 uptake of spreadsheets, the ERIC digests by Ozgun-Koca [145] for
the years 2000 and 2001 make a good starting point, as they contain numerous links to web-based
resources. The book [101] is a good source of spreadsheet examples for grades 3 to 8. See also the
work of Dugdale [59].
4.3 Number Theory
In spite of number theorist G.H. Hardy’s claim [82] that “I have never done anything useful”, the
utility of number theory nowadays is undeniable, with prime applications being mathematical cryp-
tography and cryptology. Modern CS/IT graduates need to know at least the basics of cryptographic
computer security systems, and the use of spreadsheets in particular for the illustration of number-
theoretic concepts appears to be on the rise. Just a few examples are the work of Abramovich and
co-workers, cited earlier, and that of Sugden [182]. Sugden uses Excel for illustration of Euler’s
ϕ(n)(totient) function, τ(n)(number of divisors), the Möbius function µ(n),aswellasthebasic
24 eJSiE 1(1):18-43
7
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
operations of modular arithmetic, including modular inverse, modular exponentiation, leading to a
32-bit implementation of the RSA public key cryptosystem in Excel.
Abramovich [7] also considers the use of Excel for some basic investigations into number theory,
and gives an implementation of the Sieve of Eratosthenes using a few very simple formulas. He goes
on to consider gaps between primes, primes in arithmetic progression, even showing how to tabulate
and graph the function π(x)(numberofprimeslessthanx), all in Excel. His formula for this latter
task is very long but consists of a sequence of very similar sub-formulas, and one suspects that this
could be simplied somewhat, given the modern facilities of, for example, Microsoft Excel XP. In his
article, Abramovich quotes earlier authors MacKinnon [119]:
...thebest use of computers in mathematics education is to runprofessional software written
for real purposes.
and Steward [176] (op cit, p20).In a later paper, Abramovich and Brantlinger [11] present further
topics in elementary number theory within the spreadsheet environment. These include Pythagorean
triads, Euclidean algorithm, Bride’s Chair, and the representation of integers as the sum of perfect
powers.
4.4 Combinatorics
Neuwirth [135] showed that:
...spreadsheets as a model for mathematical relations can help gaining insight into recursive
relations for combinatorial formulas.
This paper and Neuwirth [136] use the very fundamental features of a spreadsheet to illustrate
the structure of elementary recursive combinatorial identities, introducing an arrow diagram notation
to demonstrate the concept:
We see immediately that in this graphical notation the formula is the same for any case in a
very intuitive sense.
Neuwirth aims to avoid algebra as much as possible as the students have trouble with this and
with the closely related concept of mathematical induction. Sugden [179] also uses Excel to assist
with investigations into mathematical induction and recursive implementations of arithmetic and
geometric sequences (directly applicable to simple and compound interest respectively). The concept
of a recursive relation is one that lies at the heart of Microsoft Excel’s Fill Handle implementation,
which takes a range of cells in which formulae apply and spreads them over a range in a way that
replicates the recursive process. We believe that an investigation into student understanding of
recursion can be greatly enhanced by implementing such a process on the spreadsheet. For example,
Sugden [179] uses this technique for his discrete and business mathematics classes to implement a
full superannuation model, complete with rollover and schedule of net worth, in Microsoft Excel,
with just one addition and one multiplication–no exponentials or intrinsic functions. Given such an
environment, the traditional conceptual diculty of recursion is replaced by the visual simplicity of
a single-step formula (one recursive step) and Excel’s ll-down. Hvorecký and Trencansky [94] use
cell insertion in Excel, under VBA/macro control, to investigate graphs of functions of one and two
variables, and to the generation of fractals. As further cells are inserted (their requirement for extra
cells grows exponentially), graphs and fractals of higher precision are obtained.
eJSiE 1(1):18-43 25
8
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
4.5 Numerical Analysis
There is a healthy literature on the uses of spreadsheets in numerical analysis (NA). A topical example
would be Lawson and Tabor [108], in which a model arithmetic and geometric growth is presented
using a spreadsheet. Their application is to model the spread of Variant Creutzfeldt-Jakob disease
(mad-cow disease, or vCJD). In all references located, the positive aspects of spreadsheet use recur.
For example, Soper and Lee [178] conclude:
The versatility of computer spreadsheets makes them a very suitable means of accurately
undertaking numerical calculations. The formulae required are easily entered into the spreadsheet,
and the approach has the further advantage that the users can see what is being calculated, so
enhancing their understanding of the method. With the availability of graphical facilities, a plot
of the value of a variable at successive iterations can easily be displayed. A further benetof
the approach is that students become procient in the use of a very popular business computer
package.
Another two examples of using spreadsheets for numerical analysis are from Australia: Smith
[174] describes an entire NA course at Monash University, Australia (1989) taught entirely using the
spreadsheet program VP-PLANNER, and McLaren’s book [126] has been used to support his NA
course at LaTrobe University.
Sequences, a key element of numerical modelling, are a natural for a program such as Microsoft
Excel. There is no doubt that the modelling of sequences is one of the great strengths of the modern
spreadsheet program; in fact, even the very early versions such as VisiCalc were almost as good.
Sequences can be dened by just listing the terms, by a direct formula, or by a recurrence. For the
most basic of sequences (arithmetic and geometric), the most natural denition is the recursive one:
start anywhere and either keep adding a constant or keep multiplying by a constant. From the point
of view of student understanding, such a prescription is almost too easy to implement in a modern
spreadsheet such as Microsoft Excel.
For the 21st century, IT-literate student, it must seem like a total a waste of time that the teacher
has to write a recurrence relation to express such a simple operation as ll-down ! Students familiar
with spreadsheets already know all about this. The challenge for the teacher is, of course, to relate
the mathematical formalism of a recurrence relation to the readily comprehended spreadsheet notion
of ll-down. Student reaction to the translation of mathematical formalisms such as the algebraic
expression of a recurrence relation such as that of Equation 1 into the spreadsheet environment are
discussed briey by Sugden [179]. Equation 1 represents a superannuation model with $100,000
rollover (initial value), 1% interest per month, and $500 contribution per month. It is interesting
that many students have diculty even understanding Equation 1 (let alone solving it), yet have
very little trouble implementing the corresponding model in Microsoft Excel. Clearly, there is ample
scope for future research here.
an=½1.01an1+ 500 if n>0
100,000 if n=0 (1)
It is clear that immediate application of such recursion is to be found in the area of elementary
mathematics of nance. Coupled recurrence relations (dierence equations) relating to population
dynamics, for example, are also easily handled. Since many sequences are most naturally dened
recursively (arithmetic, geometric, Fibonacci etc.), the spreadsheet oers a very rich environment for
investigation of sequences, in most instances, with no coding required. Further discussion may be
found in [180].
4.6 Mathematics not otherwise cited
Due to limitations of time, it was not possible to obtain a copy of every publication considered
relevant to the application of spreadsheets to mathematics teaching and learning. However, in the
26 eJSiE 1(1):18-43
9
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
interests of providing as complete a bibliography as possible in the present survey paper, the following
additional works are cited: [30], [41], [58], [60], [61], [62], [63], [85], [86], [93], [96], [97], [117], [118],
[120], [122], [127], [125], [132], [138], [139], [142], [143], [148], [151], [152], [158], [159], [161], [164],
[172], [173], [185], [190], [191], [195], [197] and [199].
5 Statistics
Does the spreadsheet have advantages that make it a more acceptable tool for teaching and learning
than the use of statistical packages? In this respect, Hunt [91] refers to teacher belief as follows:
Many teachers now believe that a spreadsheet provides a better educational environment
in which to teach statistics at an elementary level. The spreadsheet can be made much more
transparent to the student, allowing them to look inside the black box.
Overall, however, the jury is still out on this question–at least at the tertiary level. Although
Neuwirth [137], for example, has demonstrated that spreadsheets may be employed to assist statistical
learning beyond just that of using intrinsic functions (he writes about visualizing correlation), there
is a good deal of negativity in the literature when it comes to statistical computations. For example,
writing about versions of Excel 5.0 and earlier, Nash and Quon [134] conclude that:
Spreadsheet vendors must be encouraged to do better. Closer attention to statistical issues
would result in tools better suited to data exploration and analysis, and cleaner software design
would avoid some obvious sources of error.
They would like to see options for:
1. Histograms, possibly with unequal class intervals.
2. Stem and leaf diagrams.
3. Boxplots, especially with multiple boxplots on the same scale.
4. Quality-control charts.
5. ppand qqplots for distributions, especially the Gaussian distribution.
If the requirement, even at tertiary level, is to cover only elementary concepts, others nd that the
spreadsheet serves admirably. For example, in teaching an engineering subject, Hall [81] concludes
that:
This approach to teaching mathematics, with an intimate mix of mathematical theory, nu-
merical examples and graphical representations, together with the use of modern computing aids,
seems appropriate for engineers.
Warner and Meehan [196] express similar support, stating that:
Individual instructors will need to weigh the costs and benets of using a spreadsheet program
versus specialized statistical package, but we believe a spreadsheet, such as Excel, will prove more
attractive in many situations.
Hunt [92] reasserts the belief of teachers, concluding that although Microsoft Excel has a great
deal to oer at the elementary level, it is of limited use to serious students of the subject. He points
to features such as NORMDIST(1.96) which returns the tail probability of 0.975 and commends the
function NORMSINV(RAND()) which can be used for simulating a standard normal random deviate.
eJSiE 1(1):18-43 27
10
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
Features such as these really do make the spreadsheet a simple-to-use tool for the constructivist
learning environment. Hunt also identies two types of computer-assisted learning activities that are
well-supported by spreadsheets. There is the ‘do-it-yourself’ type of activity favoured by Callender
and Jackson [49], and the ‘Blue Peter5’ activities where students experiment with pre-set spreadsheets
such as the DISCUS materials of Hunt and Tyrrell [90].
Callender [48] demonstrates how the spreadsheet, with simple-to-write macros, can be used to
demonstrate the normal distributions and the central limit theorem. He suggests that a benetof
using spreadsheets to introduce such key topics in statistics is:
The normal distribution has been introduced without ‘denitions’ being needed and all the
components of the Central Limit Theorem are demonstrated as a consequence of probability
sampling.
However, a recurring complaint is that Microsoft Excel does not cater for exploratory data analy-
sis. We would question the value in Excel’s catering for such a specic and small audience as that
for whom exploratory data analysis is an issue. Features such as box and whisker plots can readily
be constructed on XY-scatter charts, and once the framework for such a plot has been made, it can
be quickly copied for use with dierent data. To make a histogram with uneven intervals, our advice
would be ‘Don’t!’ and if you have data that needs to be summarized on a histogram, the Pivot Table
facility provides a very speedy way of generating the required data table. It would appear that the
true value of these educational oddities of exploratory data analysis have not been recognized by the
wider business community, and hence not implemented by Microsoft programmers.
More serious is the common complaint that Excel statistical functions are unreliable [123], [124],
[104]. Indeed the present authors would hesitate to recommend any version of Microsoft Excel
for professional statistics work, although the second author has done much consulting work based
(stochastic modelling) in Excel [181] and the package performed very well. But, from a pedagogical
standpoint, it is here argued that a collection of totally robust algorithms for computing statistical
functions and distributions is not the principal requirement for students when learning basic statistical
techniques and functions. Provided the implemented functions are reasonably accurate for normal
ranges of the parameters, it is far more important that the student is able to understand the operation
of such functions and so see the many connections, patterns and properties; these are amply illustrated
in the spreadsheet environment. However, a revamp of the statistical functions appears to be on
Microsoft’s wish list for Excel 2003 [193].
In this context, please forgive us for slipping in a positive comment about the MODE function; one
that is taught in very elementary statistics courses, never again to rear its head. In Excel, however,
we nd that the MODE function is a powerful tool for locating duplicates in a list, particularly when
combined with conditional formatting (e.g., if the value of this cell is =MODE(range) then format
the cell to have a blue colour). Some further useful information concerning the use of conditional
formatting with Excel’s MODE function was pointed out by an anonymous reviewer, and is included
here, with permission.
It appears that in the case of poly-modal array of numbers, the MODE function recognizes the
rst number that appears most in this array. For example, using conditional formatting jointly
with this function, in the array {2,1,3,2,1,5,5,3,4,4}twos will be highlighted only, whereas in
the array {1,2,3,2,1,5,5,3,4,4}ones will be highlighted only.
It would be inappropriate to complete this section without mentioning the Association of Statistics
Specialists Using Microsoft Excel (ASSUME) [205] whose main interest appears to be the use of Excel
in higher education. Queries to the ASSUME list will almost always receive an answer from someone
who knows.
5This name refers to the English children’s TV program ‘Blue Peter’ catchphrase — “Here is one that I
prepared earlier".
28 eJSiE 1(1):18-43
11
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
6 Physical Sciences
Spreadsheets have long been used both for teaching mathematical principles of physical science and
analysis of empirical results; for example [27], [31], [34], [35], [39], [40], [42], [43], [44], [46], [47], [50],
[51], [52], [53], [56], [57], [65], [66], [68], [69], [75], [77], [79], [80], [99], [100], [102], [103], [105], [108],
[111], [128], [129], [130], [131], [133], [140], [141], [144], [149], [153], [163], [169], [188], and [198].
However, in his 1992 paper, Smith [171] notes the comparative rarity of using the spreadsheet as a
mathematical teaching tool. He goes on to mention some uses of spreadsheet in teaching physics, and
cites the texts of Misner & Cooney [130] and Crow [52]. In his closing remarks, Smith predicts three
positive outcomes for students:
1. Reversal of the declining interest in mathematics.
2. Improvement of technological literacy and enhancement of career preparation.
3. Revitalization of mathematical skills through problem solving.
Some textbooks, not mentioned elsewhere, and which employ spreadsheet-based models, algo-
rithms and solutions are [25], [26], [27], [33], [37], [38], [54], [55], [83], [106], [107], [150], [155], [170],
[183], and [186].
An interesting modern paper is that of Lim [116], which describes how spreadsheets are used to
support the teaching of quantum chemistry. It is reported that students with weak mathematical
backgrounds have proted from this approach.
This author prefers the use of spreadsheets for weaker students for the following reasons. The
symbolic mathematical packages depend on the use of a symbolic, quasi-programming language,
which can present an additional learning obstacle for many students....
Furthermore, the access to symbolic mathematical packages is usually more limited than
that of spreadsheets, which are widely available in home, business and community settings. The
“worldware” ...also called “application-software” ... nature of spreadsheets means that students
will have greater opportunities to use and become familiar with spreadsheets than with (eg)
symbolic mathematical packages, leading to greater utility and expertise. Software that isn’t
designed for instruction can still be good for learning....
A “straw poll” of physical chemistry faculty suggests that signicantly more faculty use spread-
sheets in teaching and learning activities than symbolic mathematical packages [116].
7ComputerScience
Shinners-Kennedy [166] reports on the use of early work in which spreadsheets provide a host envi-
ronment for teaching assembly language programming. Even as early as 1986, he notes:
It is surprising the range of applications that have been coaxed into this format.
In another paper [167], the same author describes computer programming and data structures and
algorithms courses and refers to the well-known obstacles to comprehension of run-time behaviour of
programs for "weaker students". The response of several educators to this problem is the creation of
run-time visualization environments. Similar considerations are expressed by Rautama et al [160].
Once again, the authors state that many students have trouble understanding basic algorithms, and
it is a signicant challenge to inspire them to investigate why and how a given algorithm works.
Examples they cite are binary search, and edit distance for string editing. Rautama et al use
Microsoft Excel as an algorithm animation environment, and also point out that such an approach
leads to useful tools for algorithm research too. Shinners-Kennedy [167] recommends the use of
spreadsheets for construction of such visualization systems, and goes on to describe the benets of
the Microsoft Excel Object Library for such endeavours:
eJSiE 1(1):18-43 29
12
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
The spreadsheet concept is deceptively simple.
In essence the spreadsheet system is a toolkit (emphasis ours) for exposing and explaining the
principal concepts associated with the object-oriented methodology.
Fone [70] demonstrates the value of using Excel to model neural networks. In an end-of-course
survey, Fone found that:
Unlike previous groups, there were no comments suggesting the need for better models. How-
ever, ve comments typied by the statement, “I found the Excel example particularly helpful, not
only in helping me understand the networks but with aspects of other modules” were of particular
interest.
Other applications of spreadsheets in computer science are described in [95] (programming),
[112] (arithmetic unit simulation), [113] (automata), [168] (object-oriented programming), [64] (ani-
mation).
8 Economics and Operations Research
Thiriez [189], in an invited review of the role of spreadsheets in operations research teaching begins
by pointing out that there is:
...no point in demonstrating the eciency of the spreadsheet as a tool for teaching basic
modeling and programming.
Thiriez also notes that there are less well-known features of spreadsheets that turn out to be
powerful, so long as you know how to use such features. He goes on to give examples in decision
theory, linear programming and simulation:
The spreadsheet is the best tool for teaching deterministic simulation.
Suggestions are also made that users should view the Solver capabilities with caution. However,
hiskeypointisthat:
A major asset of spreadsheets resides in the speed with which a model may be designed.
Recently, I had the opportunity to build a simulation model for the automatic handling of luggage
at the Paris Roissy airport. When the model (totally developed in Excel) was nished, I learned
that all other proposals for the tender oer of this application, all of them based on the use of
professional simulation software, had all been at least vetimesasexpensiveasourproposal.
Many other examples of the use of Excel’s Solver are to be found on the WWW; for example, see
[177].
Jones and Judge [98] support the general views of Thiriez in a paper that gives examples from
micro-economics and macro-economics, illustrating how a spreadsheet can be used to assist in the
development of a student’s understanding of dynamic models and their properties. Adams and Kroch
[23] point to the value of the graphical component of spreadsheets:
The linkage between algebraic, numerical and graphical presentations in spreadsheet programs
on the personalcomputeris asignaladvantage for theteaching of macroeconomics...toillustrate
the principal elements of macrotheory.
Goddard et al [78] note the way in which spreadsheet usage supports a shift from active to passive
learning by enabling students to explore what happens to income-expenditure economy models (the
IS-LM model) as equilibrium is disturbed.
Barreto and others use Excel for the teaching of Economics and Econometrics at Wabash College
[29].
30 eJSiE 1(1):18-43
13
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
9 Some spreadsheet esoterica
9.1 Conditional formatting
An interesting feature, introduced in Excel 97 is that of conditional formatting. It may be viewed
as a generalization of the common accounting practice of colouring amounts of money red or black,
depending on their natures as debits or credits (negative or positive). Microsoft Excel is able to
automatically format (colour, border, font etc.) a cell based on its current value. A simple example
of the use of this feature is solving f(x)=0without algebra, but by just observing change of sign
(change of colour). Those interested in the use of this facility will nd downloadable models on
the Spreadsheets in Education (SIE) eJournal site [28]. The literature on the use of this feature for
educational applications within the spreadsheet environment is scant indeed, although applications
abound. One reference to its use is that of Sugden [179], who uses it for solving f(x)=0without
algebra, and illustrating the solution of simultaneous linear congruences, among many others.
9.2 Names
One of the most benecial features of the modern spreadsheet is the facility to dene a Name. Such
a feature allows the spreadsheet user to refer to a cell or collection of cells by a single identier; this
is similar to the use of variable names in programming languages rather than hard addresses (relative
or absolute). Many benets accrue with the use of names; some of these being:
The troublesome, but sometimes necessary, absolute references are handled automatically.
Models may be expressed in notation very close to that of standard algebra. Instead of using
an obscure formula with hard cell references such as = A2*$E$3, one may write something like
= GrossPay*TaxRate.
Large areas of the worksheet such as tables or lists may be easily selected by just going to the
Name box (Microsoft Excel)
Models become at least partially self documenting and tend to be easier to debug.
Despite the fact that problems with relative and absolute addressing simply vanish, and that
formulasmaybeexpressedintermsverycloseto an algebraic model when one uses names, it is
rather surprising how rarely these are used in published examples.
9.3 Auditing and debugging
In this paper, we have trumpeted the benets of spreadsheets for educational purposes. What is the
downside? There exist quite a number of papers which highlight negative aspects of spreadsheets,
and in the interests of a more balanced presentation, it seems only fair that our survey should
include some of these papers too. The main objection appears to be debugging (touseacomputer
programmer’s term), or auditing (to use an accounting term). When applied to spreadsheets, these
two terms refer to much the same thing: the problem of ensuring that a given model is correct.
The diculties of auditing spreadsheets are well-known, and the level of complexity seems to be
comparable to that of debugging a moderate-sized computer program; this problem is well-known to
be hard [73], [74], [146], [147], [156].
To put our negative remarks about spreadsheet auditing in perspective, we note that modern
spreadsheets such as Microsoft Excel have some quite useful auditing tools; for example, even without
invoking the auditing toolbar, just a double-click in a cell will highlight immediate antecedents, that
is, cells which directly aect the value of the current cell. Secondly, spreadsheet models developed for
educational purposes tend to be founded on a sound mathematical model, and if wrong results are
produced, or a limitation of the model is reached, then students can be asked to investigate why such
eJSiE 1(1):18-43 31
14
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
a happening has occurred. In other words, in an interactive learning environment, it is often possible
to turn an apparently negative outcome to a positive one. For an example of this, see Sugden [179].
10 Conclusion
In this brief outline of spreadsheets in education, one of our principal aims has been to provide
arguments and motivation for further research in this area. There is no longer a need to question
the potential for spreadsheets to enhance the quality and experience of learning that is oered to
students. Traditional barriers (particularly the lack of facilities to use spreadsheets in assessment
contexts) need to be removed, either by ensuring that access to computers is improved or by changing
assessment methods. Further expansion is needed of the types of topics that can be eectively covered
by spreadsheet examples; for example, one of the authors has recently completed a spreadsheet to
enable the investigation of cellular automata as described by Gardner [76].
Hence the electronic journal Spreadsheets in Education! The goals of the journal [28] are:
1. To create a forum in which ideas on the use of spreadsheets can be exposed and explored.
2. To provide an avenue for scholarly research into the use of spreadsheets at all levels of education
to be reported to a receptive, practising audience.
3. To enable teachers to take on board a technology which can rightly claim to be one of the
founding fathers of the personal computer and which is a tool for life to which all students
should be exposed.
The electronic medium was chosen over print so as to provide a facility to discuss spreadsheets
in education and at the same time giving access to the spreadsheets under discussion. In the view of
the authors, to do otherwise would be inappropriate in this age of technology.
Acknowledgment
The authors are grateful to the reviewers for many useful comments and suggestions, and espe-
cially to Sergei Abramovich, State University of New York, for coordinating the review process.
References
[1] Abramovich, S. (2003) GRED 504 Using Spreadsheets in Teaching School Mathematics (Web
Site) http://www2.potsdam.edu/EDUC/abramovs/gred595site.htm.
[2] Abramovich, S., and Levin, I. (1994). Microcomputer-Based Discovering and Testing of Combi-
natorial Identities. Journal of Computers in Mathematics and Science Teaching 13(2): 223—246.
[3] Abramovich, S., and Levin, I. (1994). Spreadsheets in Teaching and Learning Topics in Calculus.
International Journal of Mathematical Education in Science and Technology 25(2): 105—126.
[4] Abramovich, S. (1995). Technology Motivated Teaching of Advanced Topics in Discrete Math-
ematics. Journal of Computers in Mathematics and Science Teaching 14(3): 391—418.
[5] Abramovich, S. (1995). Technology for Deciding the Convergence of Series. International Jour-
nal of Mathematical Education in Science and Technology 26(3): 347—366.
[6] Abramovich, S., and Brown, G. (1995). Teaching Mathematics through Spreadsheet-Oriented
Problem Solving. The Mathematics Educator 6(2): 34—40.
[7] Abramovich, S. (1996). Exploring prime numbers within a spreadsheet. International Journal
of Mathematical Education in Science and Technology 27(5): 693—699.
32 eJSiE 1(1):18-43
15
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[8] Abramovich, S., and Pieper, A. (1996). Fostering Recursive Thinking in Combinatorics through
the Use of Manipulatives and Computing Technology. Mathematics Educator 7(1): 4—12.
[9] Abramovich, S., and Nabors, W. (1997). Spreadsheets as Generators of New Meanings in
Middle School Algebra. In D.L. Johnson, C.D. Maddux and L. Liu (eds) Using technology in
the classroom. New York, Haworth Press: 13—25.
[10] Abramovich, S., and Brantlinger, A. (1998). Tool Kit Approach to Using Spreadsheets in Sec-
ondary Mathematics Teacher Education. In S. McNeil,J.D.Price,S.Boger-Mehall,B.Robin,
J. Willis (Eds), Technology and Teacher Education Annual, 1998, 573—577. Charlottesville, VA.
[11] Abramovich, S., and Brantlinger, A. (1998). Spreadsheet-Based Tool Kit for Modeling Concepts
in Elementary Number Theory. In H. Skala (Ed), Proceedings of the Third Biennial Symposium
on Mathematical Modeling in the Undergraduate Curriculum, 28—38, University of Wisconsin-
La Crosse: Mathematics Department.
[12] Abramovich, S. (1998). Manipulative and Numerical Spreadsheet Templates for the Study of
Discrete Structures. International Journal of Mathematical Education in Science and Technol-
ogy 29(2): 233—252.
[13] Abramovich, S., Brantlinger, A., and Norton, A. (1999). Exploring Quadratic-like Sequences
through a Tool Kit Approach. In G. Goodell (Ed.), Proceedings of the 11th Annual International
Conference on Technology in Collegiate Mathematics, Addison-Wesley.
[14] Abramovich, S., Drier, H., Dugdale, S., Mochon, S., Neuwirth, E., and Woodward, J. (1999).
Spreadsheets: A New Form of Educational Software for School Mathematics? In D. Thomas
(Ed.), Proceedings of the Proceedings of the International Conference on Mathematics/Science
Education and Technology, 390—395, Charlottesville, VA: Association for the Advancement of
Computing in Education.
[15] Abramovich, S., and Norton, A. (2000). Technology-Enabled Pedagogy as an Informal Link
Between Finite and Innite Concepts in Secondary Mathematics. The Mathematics Educator
10(2): 31—46.
[16] Abramovich, S. (2000). Mathematical Concepts as Emerging Tools in Computing Applications.
Journal of Computers in Mathematics and Science Teaching 19(1): 21—46.
[17] Abramovich, S., Stanton, M., and Baer, E. (2002). What Are Billy’s Chances? Computer
spreadsheet as a learning tool for younger children and their teachers alike. Journal of Com-
puters in Mathematics and Science Teaching 21(2): 127—145.
[18] Abramovich, S., and Strock, T. (2002). Measurement model for division as a tool in comput-
ing applications. International Journal of Mathematical Education in Science and Technology
33(2): 171—185.
[19] Abramovich, S., and Brouwer, P. (2003). Revealing hidden mathematics curriculum to pre-
teachers using technology: the case of partitions. International Journal of Mathematical Edu-
cation in Science and Technology 34(1): 81—94.
[20] Abramovich, S. (2003). Cognitive Heterogeneity in Computer-Mediated Mathematical Action
as a Vehicle for Concept Development. Journal of Computers in Mathematics and Science
Teaching 22(1): 19—41.
[21] Abramovich, S. (2003). Spreadsheet-Enhanced Problem Solving in Context as Modeling, eJour-
nal of Spreadsheets in Education 1(1):1—17.
eJSiE 1(1):18-43 33
16
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
[22] Abramovich, S., and Brantlinger, A. (In press). Linking numeric, graphic, and geometric rep-
resentations of number theory concepts in a spreadsheet environment. In G. Goodell (Ed.),
Proceedings of the 15th Annual International Conference of Technology in Collegiate Mathe-
matics, Addison-Wesley.
[23] Adams, F. G. and Kroch, E. (1989). The computer in the teaching of macroeconomics. Journal
of Economic Education,20(3): 269—280.
[24] Ainley, J., Pratt, D., and Nardi, E. (2001). Normalising: Children’s activity to construct
meanings for trend. Educational Studies in Mathematics 45(1): 131—146.
[25] Arganbright, D. (1984). The Electronic Spreadsheet and Mathematical Algorithms. The College
Mathematical Journal 15: 148—157.
[26] Arganbright, D. (1985). Mathematical Applications of Electronic Spreadsheets,McGraw-Hill.
[27] Arganbright, D. (1995). Practical Handbook of Spreadsheet Curves and Geometric Construc-
tions,CRCPress.
[28] Baker, J.E., and Sugden, S.J. (eds) (2003). eJournal of Spreadsheets in Education. Electronic
Journal, URL: http://www.sie.bond.edu.au.
[29] Barreto, H. (2001). Teaching Comparative Statics with Microsoft Excel.URL:
http://www.wabash.edu/econexcel/compstatics/
[30] Battista, M., and van Auken Borrow, C. (1998). Using spreadsheets to promote algebraic
thinking. Teaching Children Mathematics,4(8): 470—478.
[31] Beare, R. (1992). Software tools in science classrooms. Journal of Computer Assisted Learning
8: 221—230.
[32] Beare, R. (1993). How spreadsheets can aid a variety of mathematical learning activities from
primary to tertiary level. Technology in Mathematics Teaching: A Bridge Between Teaching
and Learning. B. Jaworski. Birmingham, U.K.: 117—124.
[33] Beare, R. (1994). Mathematics in Action - Modelling the Real World Using Mathematics,
Chartwell-Yorke.
[34] Beare, R., and Hewitson, J. (1996). Asking and answering all sorts of scientic questions using
spreadsheets. School Science Review 77(281): 43—53.
[35] Beichner, R. J. (1997). Visualizing Potential Surfaces with a Spreadsheet. The Physics Teacher
35(2): 95—97.
[36] Bellis, M. Inventors of the Modern Computer: VisiCalc: Dan Bricklin & Bob Frankston.
http://inventors.about.com/library/weekly/aa010199.htm
[37] Benninga, S. (1989). Numerical Techniques in Finance, MIT Press.
[38] Benninga, S. (1998). Financial Modeling,MITPress.
[39] Berk, K. N., and Carey, P. (1998). Data Analysis with Microsoft Excel, Duxbury Press.
[40] Billo, J. (1997). Excel for Chemists,JohnWiley.
[41] Black, T. R. (1999). Simulations on Spreadsheets for Complex Concepts: Teaching Statisti-
cal Power as an Example. International Journal of Mathematical Education in Science and
Technolog y 30(4): 473—81.
34 eJSiE 1(1):18-43
17
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[42] Blickensderfer, R. (1990). Learning chemical kinetics with spreadsheets. Journal of Computers
in Mathematics and Science Teaching 9(4): 35—43.
[43] Bloch, S. C. (1992). SSP: The Spreadsheet Signal Processor, Prentice-Hall.
[44] Bloch, S. C. (1995). Spreadsheet Analysis for Engineers and Scientists,Wiley.
[45] Bricklin, D. Dan Bricklin’s Web Site. http://bricklin.com/
[46] Brosnan, T. (1989). Teaching Chemistry Using Spreadsheets - 1: Equilibrium Thermodynamics.
School Science Review 70: 39—47.
[47] Brosnan, T. (1990). Teaching Chemistry Using Spreadsheets - 2: More Ideas and Some Limi-
tations. School Science Review 71: 53—59.
[48] Callender, J. Probability by Spreadsheet, Sheeld Hallam University, URL:
www.shu.ac.uk/schools/sci/maths/ssuser/probabil.doc
[49] Callender, J. T. and Jackson, R. (1995). Exploring probability and statistics using spreadsheets,
Prentice Hall.
[50] Carter, A. J. R. (1999). Using Spreadsheets To Model Population Growth, Competition and
PredationinNature.American Biology Teacher 61(4): 294—296.
[51] Cooke, B. A. (1997). Some ideas for using spreadsheets in physics. Physics Education 32(2):
80—87.
[52] Crow, T. T. (1989). Spreadsheets and Their Use in Physics, unpublished manuscript, cited in
Smith, R., Spreadsheets as a Mathematical Tool.
[53] de Levie, R. (2001). How to Use Excel in Analytical Chemistry and in General ScienticData
Analysis, Cambridge University Press.
[54] Diamond, D., and Hanratty, V.C.A. (1997) Spreadsheet Applications In Chemistry Using Mi-
crosoft Excel. Wiley, ISBN: 0471140872.
[55] Dopfer, G., and Reimer, R. (1995). Tabellenkalkulation im Mathematikunterricht, Klett-Verlag.
[56] Dory, R. A. (1988). Spreadsheets for Physics. Computers in Physics 2(3): 70—74.
[57] Drago, P. (1993). Teaching with Spreadsheets: An Example from Heat Transfer. The Physics
Teacher 31(5): 316—317.
[58] Drier, S. (1999). Do vampires exist? Using spreadsheets to investigate a common folktale.
Learning and Leading with Technology 27: 22—25.
[59] Dugdale, S. (1994). K-12 teachers’ use of spreadsheet for mathematical modeling and problem
solving. Journal of Computers in Mathematics and Science Teaching 13(1): 43—68.
[60] Dugdale, S. (1998). Newton’s Method for Square Root: A Spreadsheet Investigation and Ex-
tension into Chaos. Mathematics Teacher 91(7): 576—585.
[61] Dugdale, S. (1998). A Spreadsheet Investigation of Sequences and Series for Middle Grades
through Precalculus. Journal of Computers in Mathematics and Science Teaching 17(2—3):
203—222.
[62] Dugdale, S. (2001). Order Out of Chaos: A Spreadsheet Excursion into a Mathematical Fron-
tier. Journal of Computers in Mathematics and Science Teaching 20(4): 347—365.
eJSiE 1(1):18-43 35
18
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
[63] Durkin, M. B., and Nevils, B.C. (1994). Using Spreadsheets to See Chaos. Journal of Computers
in Mathematics and Science Teaching 13(3): 321—338.
[64] Dybdahl, A., Sutinen, E., and Tarhio, J. (1998). On animation features of Excel. ITiCSE ’98,
Integrating Technology into Computer Science Education,ACM.
[65] Dykstra, D. I., and Fuller, R.G. (1988). Wondering About Physics...Using Spreadsheets to Find
Out,Wiley.
[66] Elliot, C. (1988). Spreadsheets in Science teaching. School Science Review 70: 87—93.
[67] Feicht, L. Creating a Mathematical Laboratory Using Spreadsheet to Investi-
gate the Connection between Matrices and Geometric Transformation. URL:
http://www.feicht.com/lou/matst2.htm.
[68] Filby, G. (1998). Spreadsheets in Science and Engineering, Springer Verlag.
[69] Finnemore, D. J. (1990). More Spreadsheets in Science teaching. School Science Review 71:
94—98.
[70] Fone, W. (2001). Using a familiar package to demonstrate a dicult concept: Using an Ex-
cel spreadsheet to explain concepts of neural networks to undergraduates. Proceedings of the
6th Annual Conference on Innovation and Technology in Computer Science Education,URL:
http://doi.acm.org/10.1145/3767435.3776675.
[71] Frankston, R. Bob Frankston’s Website. URL: http://www.frankston.com/
[72] Friedlander, A. (1998). An EXCELlent bridge to algebra. Mathematics Teacher 91(50): 382—
383.
[73] Galletta, D.F., Abraham, D., El Louadi, M., Lekse, W., Pollailis, Y.A., and Sampler, J.L.
(1993). An Empirical Study of Spreadsheet Error-Finding Performance, Journal of Accounting,
Management, and Information Technology 3(2): 79—95.
[74] Galletta, D.F., Hartzel, K.S., Johnson, S., and Joseph, J.L. (1997). Spreadsheet Presentation
and Error Detection: An Experimental Study, Journal of Management Information Systems,
13(3): 45—63.
[75] Gallop, R. The Use of Excel to Investigate Simple Climate Models. URL:
http://www.worc.ac.uk/Departs/Envman/Research/Rowland/Modelling.html.
[76] Gardner, M. (1970). Mathematical Games: The fantastic combinations of John Conway’s new
solitaire game "life". ScienticAmerican223: 120—123.
[77] Gipps, J. (1998). Spreadsheets and Learning in Science. Where is IT & T at? Proceedings of
the Australian Computers in Education Conference 1998, Computer Education Group of South
Australia.
[78] Goddard, J. A., Romilly, P. J. and Tavakoli, M. (1995). Macroeconomics and in-
formation technology applications. Computers in Higher Education Review, 9(1), URL:
http://www.economics.ltsn.ac.uk/cheer/ch9_1/ch9_1p06.htm.
[79] Goodfellow, T. (1990). Spreadsheets: powerful tools in science education. School Science Review
71(257): 47—57.
[80] Guglielmino, R. (1989). Using Spreadsheets in an Introductory Physics Lab. The Physics
Teacher 27: 175—178.
36 eJSiE 1(1):18-43
19
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[81] Hall, A. G. (1995). A workshop approach using spreadsheets for the teaching of statistics and
probability. Computers in Education 25(1/2): 5—12.
[82] Hardy, G. H. (1940). A Mathematician’s Apology, Cambridge University Press.
[83] Healy, L., and Sutherland, R. (1991). Exploring Mathematics with Spreadsheets.Herts,UK,
Simon and Shuster Education.
[84] Herrington, J., and Standen, P. Moving from an instructivist to a constructivist learning envi-
ronment, Journal of Educational Multimedia and Hypermedia,9(3): 195—205.
[85] Holmes, E. D. (1997). The Spreadsheet—Absolutely Elementary! Learning and Leading with
Technology 24(8): 6—12.
[86] Horne, M. (1994). The Use of Spreadsheet as an Algebraic Environment. Mathematics Educa-
tion Research Group of Australia, Lismore, Australia.
[87] Houghton, R. S. Spreadsheets. URL: http://www.ceap.wcu.edu/Houghton/EDELCompEduc/
Themes/spreadsheets/spreadsheets.html.
[88] Hsiao, F. S. T. (1985). Micros in mathematics education - Uses of spreadsheets in CAL. Inter-
national Journal of Mathematical Education in Science and Technology 16(6): 705-713.
[89] Hughes-Hallett, D., et al. (1998). Calculus, Single Variable.NewYork,Wiley.
[90] Hunt, D. N., and Tyrrell, S. E. (1995). DISCUS — Discovering Important Statistical Concepts
Using Spreadsheets, Coventry University Enterprises Ltd.
[91] Hunt, N. (1994). Teaching statistics using a spreadsheet, Proceedings of the Fourth International
Conference on Teaching Statistics.
[92] Hunt, N. (1996). Teaching Statistics with Excel 5.0, Maths and Stats Newsletter,URL:
http://www.stats.gla.ac.uk/cti/activities/reviews/96_05/excel.html.
[93] Hulse, J.W. (1992). A comparison of the eects of spreadsheet use and traditional methods on
student achievement and attitudes in selected collegiate mathematics topics (doctoral disserta-
tion, University of South Dakota). Dissertation Abstracts International 45(8): 2723.
[94] Hvorecký, J., and Trencansky, I. (2000). Expanding Spreadsheet Calculations. The Fifth
Asian Technology Conference in Mathematics (ATCM2000), Chiang Mai University, Thailand,
ATCM, Inc.
[95] Hvorecký, J., and Lovászová, G. (2003). On Programming and Spreadsheet Calculations. eJour-
nal of Spreadsheets in Education 1(1):44—51.
[96] Ionvinelli, R. (1998). Using Spreadsheets To Analyze Historical Perspectives of Apportionment.
Mathematics Teacher 91(2) : 176—82.
[97] Jones, A. J. (1997). Spreadsheet in Mathematics for CSF Levels 2, 3 and 4. Mathematics:
Imagine the Possibilities, The Mathematical Association of Victoria, Thirty-Fourth Annual
Conference.
[98] Jones, R., and Judge, G. (1990). Using spreadsheets in the teaching of dynamic economic
models, British Review of Economic Issues,12: 93—112.
[99] Kaess, M., Easter, J., and Cohn, K. (1998). Visual Basic and Excel in Chemical Modeling.
Journal of Chemical Education 75: 642.
eJSiE 1(1):18-43 37
20
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
[100] Kari, R. (1990). Spreadsheets in Advanced Physical Chemistry. Journal of Computers in Math-
ematics and Science Teaching 10(1): 39—48.
[101] Keeling, R., and Whiteman, S. (1990). Simply Spreadsheets, KW Publications.
[102] Kellogg, D. (1993). Spreadsheet Circuitry. Science Teacher 60(8): 21—23.
[103] Kinderman, J. V. (1992). Investigating the Compton Eect with a Spreadsheet. The Physics
Teacher 30(7): 426—428.
[104] Knüsel, L. (1998). On the Accuracy of Statistical Distributions in Microsoft Excel 97. Compu-
tational Statistics and Data Analysis 26(3): 375—377.
[105] Krieger, M. E., and Stith, J.H. (1990). Spreadsheets in the Physics Laboratory. The Physics
Teacher 28(6): 378—384.
[106] Laub-Hruby, et al. (1991). Mathematik Arbeitsbuch 3. Vienna, hpt-Verlag.
[107] Laub-Hruby, et al. (1992). Mathematik Arbeitsbuch 4. Vienna, hpt-Verlag.
[108] Lawson, D. A.,and Tabor, J.H. (2001). APs, GPs and vCJD. Teaching Mathematics and its
Applications 20(1): 2—9.
[109] Leon-Argyla, E.R. (1988). A study of spreadsheet problem solving and testing for problem solving
ability (doctoral dissertation, Michigan State University). Dissertation Abstracts International
49 (10): 3005.
[110] Levin, I., and Abramovich, S. (1992). Solving Equations Within a Spreadsheet. Journal of
Computers in Mathematics and Science Teaching 11(3/4): 337—345.
[111] Levin, I. (1993). Matrix Model of Logical Simulator Within Spreadsheet. International Journal
of Electrical Engineering Education 30(3): 216—223.
[112] Levin, I. (1994). Behavioral Simulation of an Arithmetic Unit Using the Spreadsheet. Interna-
tional Journal of Electrical Engineering Education 31: 334—341.
[113] Levin, I. (1994). The State Machine Paradigm and The Spreadsheet Learning Environment.
Engineering Education, Increasing Students Participation.A.J.Smith.Sheeld, England,
Sheeld Hallam University: 351—355.
[114] Lewis, P. (2001). Use Spreadsheets to Teach Mathematics and Meet Standards. NECC2001.
[115] Lewis, P. (2001). Spreadsheet Magic - 40 Lessons Using Spreadsheets to Teach Curriculum in
K—8 Classrooms.Eugene,Oregon,USA,ISTE.
[116] Lim, K. (2003). Using spreadsheets in chemical education to avoid symbolic mathe-
matics. Newsletter: Using Computers in Chemical Education, Spring 2003. URL:
http://www.deakin.edu.au/%7Elim/KFLim/papers/2003_Spreadsheet_CCEN/spreadsheet_abs.html.
[117] Lockwood, G., and Boland, J. (1998). The use of spreadsheets to illustrate mathematical con-
cepts. Where’s ITT at? The 15th Australian Computers in Education conference, Adelaide.
[118] Luehrmann, A. (1986). Spreadsheets: More Than Just Finance. The Computer Teacher 28:
24—28.
[119] MacKinnon, N. (1993). Friends in youth. Mathematical Gazette 77: 2—25.
38 eJSiE 1(1):18-43
21
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[120] Manouchehri, A. (1997). Exploring Number Structures with Spreadsheets. Learning and Lead-
ing with Technology 24(8): 32—36.
[121] Martin, A. (2000). An integrated introduction to spreadsheet and programming skills for op-
erational research students. Journal of the Operational Research Society 51: 1399—1408.
[122] Masalski, W. J. (1999). How To Use the Spreadsheet as a Tool in the Secondary School Math-
ematics Classroom.Reston,VA,NCTM.
[123] McCullough, B. D., and Wilson, B. (1999). On the accuracy of statistical procedures in Mi-
crosoft Excel 97. Computational Statistics and Data Analysis 31(1)
[124] McCullough, B. D., and Wilson, B. (2002). On the accuracy of statistical procedures in Mi-
crosoft Excel 2000 and Excel XP. Computational Statistics and Data Analysis 40(4): 713—721.
[125] McDonald, J. (1988). Integrating Spreadsheets into the Mathematics Classroom. Mathematics
Teacher 81(8): 615—620.
[126] McLaren, D. (1997). Spreadsheets and Numerical Analysis, Chartwell-Bratt.
[127] McClintock, E., and Jiang, Z. (1997). Spreadsheets: Powerful Tools for Probability Simulations.
Mathematics Teacher 90(7): 572—579.
[128] Mills, J., and Jackson, R. (1997). Analysis of microbial growth data using a spreadsheet. Journal
of Biological Education 31(1): 34—38.
[129] Misner, C. W. (1988). Spreadsheets Tackle Physics Problems. Computers in Physics 2(3):
37—41.
[130] Misner, C. W., and Cooney, P.J. (1991). Spreadsheet Physics, Benjamin Cummings.
[131] Misovich, M., and Biasca, K. (1990). The power of spreadsheets in a mass and energy balance
course. Chemical Engineering Education 24: 46—50.
[132] Molyneux-Hodgson, S., Rojano, T., Sutherland, R., Ursini, S. (1999). Mathematical Modelling:
the Interaction of Culture and Practice. Educational Studies in Mathematics 39(1): 167—183.
[133] Morishita, E., Iwata, Y., Yoshida K.Y., and Yoshida H. (2001) Spreadsheet uid dynamics for
aeronautical course problems. International Journal of Engineering Education 17(3), 294—311.
[134] Nash, J.C., and Quon, T.K. (1996). Issues in teaching statistical thinking with spreadsheets,
Journal of Statistics Education 4(1).
URL: http://www/amstat.org/publications/jse/v4n1/nash.html.
[135] Neuwirth, E. (1995). Spreadsheet Structures as a Model for Proving Combinatorial Identities.
Journal of Computers in Mathematics and Science Teaching 14(3): 419—434.
[136] Neuwirth, E. (1995). Visualizing Formal and Structural Relationships with Spreadsheets. Jour-
nal of Computers in Mathematics and Science Teaching. A. DiSess, Hoyles, C., and Noss, R.,
Springer-Verlag.
[137] Neuwirth, E. (1995). Visualizing Correlation with Spreadsheet. Teaching Statistics, 12, 1990.
[138] Neuwirth, E. (1996). Spreadsheets: Helpful for Understanding Mathematical Structures. The
Computing Teacher 89(3).
[139] Niess, M. L. (1998) Using Computer Spreadsheets To Solve Equations. Learning and Leading
with Technology;26(3): 22—24, 26—27.
eJSiE 1(1):18-43 39
22
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
[140] Orvis, W. J. (1993). Excel 4 for Scientists and Engineers,SYBEX.
[141] Osborn, P. M. (1987). Spreadsheets in Science teaching. School Science Review 69: 142—143.
[142] O’Sullivan, B. (2002). Interactive Spreadsheets Part 1: Unlocking the Power of Excel. Teaching
Mathematics (June 2002): 8—11.
[143] O’Sullivan, B. (2002). Interactive Spreadsheets Part 2: Unlocking the Power of Excel. Teaching
Mathematics (September 2002): 12—14.
[144] Ouchi, G. I. (1988). Lotus in the Lab: Spreadsheet Applications for Scientists and Engineers,
Addison-Wesley.
[145] Özgün-Koca, S. A. (2000). Using Spreadsheets in Mathematics Education.ERICClear-
inghouse for Science Mathematics and Environmental Education Columbus OH. URL:
http://www.ericfacility.net/databases/ERIC_Digests/ed463951.html
[146] Panko, R.R., and Sprague, R.H., Jr. (1998). Hitting the Wall: Errors in Developing and Code
Inspecting a ’Simple’ Spreadsheet Model," Decision Support Systems,22: 337—353.
[147] Panko, R.R. (1999). Applying Code Inspection to Spreadsheet Testing. Journal of Management
Information Systems,16(2): 159—176.
[148] Parker, J., and Widmer, C. (1989). Using Spreadsheets to Encourage Critical Thinking. The
Computing Teacher: 27—28.
[149] Pearce, J. M. (1990). Playing around with spreadsheets in science (and other modeling tools).
Lab Talk 29(2): 19.
[150] Piele, D. (1990). Introductory Statistics With Spreadsheets, Addison-Wesley.
[151] Pinter-Lucke, C. (1992). Rootnding with a spreadsheet in pre-calculus. Journal of Computers
in Mathematics and Science Teaching 11(1): 85—93.
[152] Ploger, D., Klinger, L., and Rooney, M. (1997). Spreadsheets, Patterns, and Algebraic Think-
ing. Teaching Children Mathematics 3: 330-334.
[153] Potter, F., Peck, C.W., and Barkley, D.S. (1989). Dynamic Models in Physics,Simonson.
[154] Power, D. J. A Brief History of Spreadsheets.
URL: http://dssresources.com/history/sshistory.html.
[155] Ragsdale, C. T. (1995). Spreadsheet Modeling and Decision Analysis: A Practical Introduction
to Management Science, Course Technology, Inc.
[156] Reithel, B.J., Nichols, D.L., and Robinson, R.K. (1996). An Experimental Investigation of the
Eects of Size, Format, and Errors on Spreadsheet Reliability Perception. Journal of Computer
Information Systems, 54—64.
[157] Relf, S., and Almeida, D., (1999), Exploring the birthdays problem and some of its variants
through computer simulation. International Journal of Mathematical Education in Science and
Technolog y 30, 81—91.
[158] Richards, A. (1997). Pre-service education and the potential for spreadsheets in the primary
mathematics classroom. In D. Fisher & T. Rickards (Eds.), Science, mathematics and technol-
ogy education and national development, Proceedings of the 1997 International Conference of
Science, Mathematics and Technology Education, 240—249. Hanoi, Vietnam, Curtin University
of Technology.
40 eJSiE 1(1):18-43
23
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[159] Roland, L. (1997). Distributing Representatives: Using Spreadsheets To Study Apportionment.
Learning and Leading with Technology 24(8): 26—29.
[160] Rautama, E., Sutinen, E., and Tarhio, J. (1997). Excel as an algorithm animation environment.
ITiCSE ’97, Integrating Technology into Computer Science Education, Uppsala, ACM.
[161] Russell, J. (1992). Spreadsheet Activities in Middle School Mathematics, National Council of
Teachers of Mathematics.
[162] Ruthven, K., and Hennessy, S. (2002). A practitioner model of the use of computer-based
tools and resources to support mathematics teaching and learning. Educational Studies in
Mathematics 49 (1): 47—88.
[163] Schlenker, R.M., and Yoshida, S.J. (1991). A clever lever endeavor: you can’t beat the spread-
sheet. The Science Teacher 58(2): 36-39.
[164] Sgroi, R.J. (1992). Systematizing trial and error using spreadsheets. Arithmetic Teacher 39(7):
8—12.
[165] Sher, D. B. (1997). Spreadsheets for Applying the Harvard Approach to Precollege Algebra.
Eastern Regional NCTM conference, Long Island, NY.
[166] Shinners-Kennedy, D. (1986). Using Spreadsheets to Teach Computer Science. Technical Sym-
posium on Computer Science Education, Cincinnati, Ohio, United States, ACM Press.
[167] Shinners-Kennedy, D. (1994). Visualisation: Hard Work Made Easy. 2nd Annual Conference
on the Teaching of Computing, Dublin, Ireland, Computers in Teaching Initiative (CTI) Centre
for Computing.
[168] Shinners-Kennedy, D. (1995). Object-Orientation: Seeing Is Believing. 3rd Annual Conference
on the Teaching of Computing, Dublin, Ireland.
[169] Silva, A. (1994). Simulating electrical circuits with an electronic spreadsheet. Computers and
Education 22(4): 345—353.
[170] Sjostrand, D. (1994). Mathematics with Excel, Chartwell-Bratt.
[171] Smith, R. (1992). Teaching Precalculus with a Spreadsheet. Fifth Annual International Confer-
ence on Technology in Collegiate Mathematics, Rosemont, Chicago, Illinois, Addison-Wesley.
[172] Smith, R. (1994). Applications of Spreadsheets in Precalculus and Calculus. Proceedings of the
11th International Conference on Technology and Education.
[173] Smith, R. (1995). Applications of Spreadsheets in Calculus. First Asian Technology Conference
in Mathematics.
[174] Smith, R. S. (1992). Spreadsheets as a Mathematical Tool. Journal on Excellence in College
Teaching 3: 131—147.
[175] Staples, E. (2003). The Euler Segment: An investigation exercise for Upper Secondary Students.
In The Classroom: Spreadsheets in Education 1(1).
[176] Steward, A. (1994). Spreadsheets in Mathematical Education. International Journal of Math-
ematical Education in Science and Technology 25(2): 239.
[177] Stone, J. (1996). Using Excel’s Solver in Modelling. Spreadsheet User 3(2).
eJSiE 1(1):18-43 41
24
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
Spreadsheets in Education–The First 25 Years
[178] Soper, J. B., and Lee, M. P. (1994). Computer spreadsheets for numerical analysis. International
Journal of Mathematics, Education, Science and Technology,25(2): 245—253.
[179] Sugden, S. J. (2001). Bits, Binary, Binomials and Recursion: Helping IT Students Understand
Mathematical Induction. Quaestiones Mathematicae, Journal of The South African Mathemat-
ical Society, Supplement #1, 133—140.
[180] Sugden, S. J. (2002). Illustrating Mathematical Fundamentals with Microsoft Excel. CATE 2002,
The 5th IASTED International Multi-Conference in Computers and Advanced Technology in
Education, Cancun, Mexico, ACTA Press, 323—327.
[181] Sugden, S.J., and Noble, C. (2002). Stochastic Recurrences of Jackpot KENO. Computational
Statistics and Data Analysis 40: 189—205.
[182] Sugden, S. J. (2003). Elementary Number Theory in a Discrete Mathematics Class: The RSA
Cryptosystem. To be presented at Delta 03, The Fourth Southern Hemisphere Symposium on
Undergraduate Mathematics Teaching, Queenstown, New Zealand, 23-27 November 2003.
[183] Sugden, S. J. (2003). Business Mathematics with Microsoft Excel. Hybrid Solutions Group,
Gold Coast, Australia. ISBN 0-9750656-0-2.
[184] Sutherland, R., and Rojano, T. (1993). A Spreadsheet Approach to Solving Algebra Problems.
Journal of Mathematical Behaviour 12(4): 351—383.
[185] Sutherland, R. (1994). Synthesising Situation-based and Formal Models: The Role of Spread-
sheets. Learning with Articial Worlds: Computer Based Modelling in the Curriculum.B.R.
Mellar, H., Bliss, J., Ogborn, Tompsett C. London, Falmer Press: 68—75.
[186] Sutherland, R., Howell, D., and Wolf, A. (1996). A Spreadsheet Approach to Maths for GNVQ
Engineering. London, Hodder Headline.
[187] Sutherland, R. A. Dramatic Shift of Attention: From Arithmetic to Algebraic Thinking. To
appear in Kaput, J., (Ed.) Employing Children’s Natural Powers to Build Algebraic Reasoning
in the Content of Elementary Mathematics. (in press).
[188] Tebbutt, M., and Flavell, H. (1995). Spreadsheets in Science. London, John Murray.
[189] Thiriez, H. (2001). Improved OR Education Through the Use of Spreadsheet Models. European
Journal of Operational Research,135: 461—476.
[190] Verderber, N. (1990). Spreadsheets and Problem Solving with AppleWorks in Mathematics
Teaching. Journal of Computers in Mathematics and Science Teaching 9(3): 45—51.
[191] Vermay, R. (1998). Let Excel Bring Some Life to Your Functions. Exploring all Angles,The
Mathematical Association of Victoria, Thirty—fth Annual Conference.
[192] Vockell, E., and van Deusen, R. M. (1989). The computer and higher-order thinking skills.
Watsonville, CA, Mitchell Publishing Company.
[193] Walkenbach, J. Microsoft Excel. URL: http://www.j-walk.com/ss/excel/.
[194] Walkenbach, J. Spreadsheet History.URL:http://www.j-walk.com/ss/history/index.htm.
[195] Walsh, T.P. (1996). Exploring Dierence Equations with Spreadsheets. Learning and Leading
with Technology;24(1): 28—32.
[196] Warner, C. B., and Meehan, A. M. (2001). Microsoft Excel as a tool for teaching basic statistics,
Teaching of Psychology,28(4): 295—298.
42 eJSiE 1(1):18-43
25
Baker and Sugden: Spreadsheets in Education
Produced by The Berkeley Electronic Press, 2003
J. Baker and S. Sugden
[197] Watkins, W., and Taylor, M. (1989). A spreadsheet in the mathematics classroom. Collegiate
Microcomputer 7(3): 233-39.
[198] Whitmer, J. C. (1990). Modeling the Milky Way: spreadsheet science. The Science Teacher
57(7): 19—2 1.
[199] Wood, J. (1990). Utilizing the Spreadsheet and Charting Capabilities of Microsoft Works in the
Mathematics Classroom. Journal of Computers in Mathematics and Science Teaching 9(3).
[200] Wood, L. N., and D’Souza, S.M. (2001). Investigating the Eects of Using Spreadsheets in a
Collaborative Learning Environment. The Sixth Asian Technology Conference in Mathematics
(ATCM2001), RMIT University, Melbourne, Australia, ATCM, Inc.
[201] URL: http://www.aect.org/intranet/publications/edtech/24/24-10.html.
[202] URL: http://www.stats.gla.ac.uk/cti/links_stats/index.html.
[203] URL: http://mathforum.org/dynamic.
[204] URL: http://www.cut-the-knot.org.
[205] URL: http://www.jiscmail.ac.uk.
eJSiE 1(1):18-43 43
26
Spreadsheets in Education (eJSiE), Vol. 1, Iss. 1 [2003], Art. 2
http://epublications.bond.edu.au/ejsie/vol1/iss1/2
... Luis H. Hernandez-Carrasco 1 , Miguel X. Rodríguez Paz 2 , Saul E. Crespo 3 1 Tecnologico de Monterrey (MEXICO) 2 Tecnologico de Monterrey (MEXICO) 3 Tecnologico de Monterrey (MEXICO) Abstract Context: ...
... The use of SS in education has given the educators, an important tool to reduce time in mathematical processes and focusing on the meaning of each variable involved in the process. Baker wrote "educators are also finding great benefit in tying programming to spreadsheet use, thereby overcoming much of the time spent in organizing data input and output" [2]. ...
... A DBL lesson requires students to work with computers for dataset analysis, typically using spreadsheet programs [73] or other subject-specific software. Software selection is an important part of this phase and should align with the size and complexity of the dataset and with the intended learning outcomes. ...
... Consideration should also be given to the time the students might need to learn to use the given software, and if necessary, the teacher can provide software, spreadsheets, or pre-wri en code to assist them. This is recommended when the A DBL lesson requires students to work with computers for dataset analysis, typically using spreadsheet programs [73] or other subject-specific software. Software selection is an important part of this phase and should align with the size and complexity of the dataset and with the intended learning outcomes. ...
Article
Full-text available
While there are references available in the literature regarding learning experiences with Dataset-Based Learning (DBL) approaches, there is a noticeable absence of a standardized model for designing DBL activities. This gap was identified in this work after performing a systematic literature review (SLR). In contrast to other active learning methodologies, the lack of a common framework for the DBL methodology makes it challenging to compare different DBL approaches. This paper highlights the knowledge gap in the methodology for designing DBL activities and aims to provide a common approach for sharing the view and details about what DBL entails in higher education and how to design a DBL activity. Additionally, we illustrate these concepts with three case studies in different engineering fields. Based on the SLR results and the review of additional literature, this work defines DBL as an active teaching methodology that focuses on using datasets to promote the learning and understanding of specific concepts and skills. These datasets should contain real data presented in different formats. As a common starting point, in a DBL lesson, the dataset not only provides information and context in the activity statement but also serves as the material to work with, and the solution to the activity is entirely extracted from the information contained in the dataset.
... It is also worth noting that a desktop version of MATLAB, used by many engineering professors, was introduced in 2000 [8]. Other computing packages, such as Mathcad, Aspen Plus, Maple, Matematica, and Microsoft Excel also grew in popularity around that time [9]- [11], [24], [27]. ...
... An instructional goal was to develop an integrated exercise to demonstrate and tie together key concepts through a comprehensive example project. The authors developed an integrated spreadsheet model that was easy to use and provided a natural interface for model building (Baker, et al., 2007). ...
Article
Earned Value Management (EVM) provides the basis for assessing work progress against a baseline plan, relates technical, time and cost performance, and gives managers a summary of effective decision making. It is a useful technique for objectively measuring project performance and progress. This paper discusses developing and implementing an integrated example problem that can teach students the effective use of EVM techniques. This approach is designed to deepen student understanding of the basic concepts of EVM, from initial project planning through execution, including data analysis techniques and baseline revisions. Successful implementation of EVM requires an understanding of important project elements, including requirements, schedule, budget, assumptions, constraints, and objectives, and therefore reinforces many of the key project management concepts students study in our courses. Implementing the integrated example aims to inspire an appreciation for the earned value concept and emphasize how performance measurement techniques can be a valuable management tool for analyzing cost and schedule performance.
... Aplikasi yang kemungkinan akan tersedia secara luas tentu layak dipertimbangkan sebagai alat potensial untuk pengajaran dan pembelajaran matematika. Baker & Sugden (2007) mensurvei literatur tentang penggunaan spreadsheet dalam pendidikan, dan menyimpulkan bahwa tidak ada lagi kebutuhan untuk mempertanyakan potensi spreadsheet dalam meningkatkan kualitas dan pengalaman belajar yang ditawarkan kepada siswa. Sebuah studi dari (Chaamwe & Shumba, 2016) menyimpulkan bahwa spreadsheet menawarkan lingkungan di mana ide-ide awal dapat dikembangkan. ...
Article
Dalam pembelajaran matematika, perangkat komputer berupa spreadsheet dapat berperan sebagai alat bantu belajar siswa serta sumber belajar bagi guru agar pembelajaran menjadi lebih optimal. Spreadsheet telah meluncurkan berbagai fitur yang dapat dimanfaatkan sebagai media dinamis yang dapat mensimulasikan konsep matematika selain operasi aljabar, yakni visualisasi grafik fungsi kuadrat. Melalui penelitian pengembangan, peneliti terdorong untuk mengimplementasikan pembelajaran matematika yang terintegrasi media spreadsheet demi tercapainya pemahaman tentang grafik fungsi secara optimal. Penelitian ini adalah penelitian pengembangan/Research and Development (R&D). Pembuatan media pembelajaran mengacu pada model pengembangan Plomp. Subjek penelitian ini siswa kelas X SMA. Selain itu, terdapat dua subjek lain yaitu validator dan guru. Hasil penelitian ini menunjukan bahwa media pembelajaran matematika berbantuan spreadsheet memenuhi kriteria valid, praktis, dan efektif.
... The optional spectrum is wide and varies from one methodological criterion to another. A specific call for using computer spreadsheets as didactic tools for education first appeared more than 40 years ago; since then, countless documented expressions attest to their potential to contribute to a constructivist learning model in teaching mathematics, physics, chemistry, and biology; indeed, virtually any branch of science or engineering discipline field makes recourse to them [20,[68][69][70][71][72][73][74][75]. In an effort to contribute to formal education in irrigation engineering, particularly in sprinkler irrigation systems, in a learning environment that privileges multiple perspectives or interpretations of reality, knowledge construction, and activities based on enriched experiences in context [76], this work evidences the articulation of theoretical and experimental learning through an Excel ® spreadsheet which includes methods and techniques that support an efficient engineering design of sprinkler irrigation systems equipped with stationary devices. ...
Article
Full-text available
Since being released 40 years ago, computer spreadsheets have proven to be worthwhile for use in educational contexts. There is plenty of evidence for this in practically every scientific discipline and engineering field. In view on this fact, the present work exposes a didactical resource, named the sprinkler irrigation tool, developed in Excel® spreadsheet licensed by 2018 Microsoft©. The objective of this tool is to offer an alternative to students in irrigation engineering, particularly for those training in the design of sprinkler irrigation systems so they can develop their theoretical knowledge and practical skills acquired in laboratory and field experiments. The main findings reported in this paper address well-agreed methodologies for evaluating radial patterns of precipitation rates, diameter distribution frequency, ballistic simulation of water drops’ movement through air, kinetic energy, and performance indicators as part of the core parameters of efficient irrigation system management. This computing tool provides outcomes in tabular and graphical formats that are consistent with those found in studies previously published in specialized literature on related topics. Likewise, spreadsheets have been proven to be adequate pedagogical instruments on the path to achieving meaningful learning; however, this assertion still needs to be confirmed through a rigorous study of students who have used the developed tool.
Article
The use of spreadsheet has huge potential to enhace experience and learning quality for students. For this reason, it is not surprising that spreadsheet is widely used as a learning tool in academe. This article discusses the use of Microsoft Excel as a learning tool with application for Laffer curve. The Laffer curve is a popular yet controversial tool so that it is very important for students to learn it in Introduction to Economics course to show relationship between tax rate and tax revenue. With reviewing the exisiting literature it is shown origins and prospects regarding the Laffer curve and the possibility of Microsoft Excel for estimating it. Estimating the existence of the Laffer curve can be easily done, but identification of the optimal tax rate and prerequisites for the optimal rate to achieve are beyond the scope of standard Introduction to Economics textbooks. In addition, using real data to construct the Laffer curve make it possible for the students to firstly expose to regression analysis as well as how to analyse data in real world practice.Keywords: Spreadsheets, Microsoft Excel, Laffer curve, Tax, Introduction to Economics.
Article
The COVID‐19 pandemic forced instruction into remote formats, rendering active learning efforts in business classrooms infeasible. In response, we adopt a novel model for interactive classroom activities by hosting classroom games on Google Sheets, the free and widely used cloud‐based spreadsheet application. First developed for a synchronous Zoom class during the COVID‐19 pandemic, this approach was integrated into face‐to‐face courses in two countries. Due to its instructional flexibility, minimal need for resources, and tendency for student acceptance, using Google Sheets for classroom interaction has far‐reaching educational applications beyond the pandemic era. To illustrate this approach, we introduce three operations and supply chain management activities created on Google Sheets: the Virtual Assembly Line (VAL) activity, the Just‐in‐time Game, and the Dice Game. An in‐depth examination of implementing these activities in the classroom offers practical insights into the benefits of utilizing cloud‐based classroom games in teaching. Furthermore, a comparison of test results between students who played the game and a control group showed significantly improved learning outcomes. We also discuss how this approach could foster active learning adoption in environments traditionally less conducive to such practices, such as remote instruction and large enrollment classes.
Article
Full-text available
This study aimed to investigate the effects of spreadsheet application in teaching Data Management in Mathematics of the Modern World on the students' performances among first-year College Students during the Second Semester of School Year 2022-2023. A quasi-experimental research design with the pretest-posttest non-equivalent groups design was employed in the study with the researcher–made questionnaire comprising 40 items test. The statistical methods used to gather data were treated using mean, t-test for independent samples, z-test for correlated samples, and standard deviation. Data were gathered from the 74 first-year college students in Jose Rizal Memorial State University–Main Campus. Results revealed that the pre-test and post-test performance of the students in the control and experimental groups was good. But their post-test performance in the experimental group was excellent. It is concluded that Spreadsheet Application is a very important and effective tool in teaching Data Management in Mathematics of the Modern World to first-year college students. Its application tremendously increases students' performance from the pre-test to the post-test.
Article
What is the first Fibonacci number greater than a million? Can elementary teachers use a challenging problem, such as this, to enhance the algebraic thinking of their students? Even with a calculator, the computations are quite tedious. The computer is certainly the right tool for the job; the problem is to find appropriate software. We have found that elementary school students can productively explore such questions using a computer spreadsheet.
Article
Spreadsheets have become popular and effective tools for the dynamic exploration of recursively defined functions, the generalization of solutions to problems, and the visualization of mathematical ideas. This article discusses a spreadsheet model for approximating square roots then extends that model into the intriguing domain of chaos
Book
Students of the sciences must often integrate large amounts of information into simple, coherent frameworks of insight. They are then expected to use this insight to solve new problems in which the driving principles are obscure. The personal computer may change science instruction by permitting the design of problem sets that enable students to build and interrogate simulations of realistic physical simulations and to exploit these simulations with a full complement of graphical tools. Electronic spreadsheets can serve as a construction kit for such activities.
Article
Traditionally, quantum theory has traditionally relied heavily on the use of mathematics. However, there is a significant cohort of students who are weak in mathematics, for example, students who are majoring in biochemistry, biological sciences, etc. This paper reports on the use of spreadsheets to generate approximate numerical solutions and visual (graphical) descriptions as a method of avoiding or minimizing symbolic manipulations, mathematical derivations and numerical computation. A specific example from quantum theory is provided. Some aspects of educational pedagogy of spreadsheet usage are discussed.
Article
The electronic spreadsheet is now firmly entrenched in the modern business environment. Popular news reports and scholarly studies have found that users are often unaware of flaws in spreadsheet templates. But previously published articles have not identified the factors that lead users to make the mistaken judgment of template reliability. Most models of human information processing include a perceptual "filter" as a precursor to mental processing. Building on the possible existence of template perceptual filtering, this article presents the results of a laboratory experiment that was conducted to investigate some of the factors that influence an individual's assessment of spreadsheet reliability. The study also investigated the subjects' level of confidence in their reliability assessments. Three variables were considered in this study: spreadsheet size, spreadsheet format, and the presence of formula errors. The results of the study indicate that an interaction between large size and elaborate formatting significantly inflated perceptions of reliability. Additionally, the results suggest that the subjects' level of confidence in their reliability assessments was not affected by any of the perceptual factors manipulated in this experiment. The results of this experiment should be considered in the design of end-user training programs designed to help users overcome perceptual filtering tendencies that might allow a misjudgment of spreadsheet template reliability.
Article
Graphical Presentation of Data. Descriptive Methods for Small Data Sets. Probability Methods for Large Data Sets. Binominal and Polsson Probability Distributions. Proportion Defective Charts and Acceptance Sampling. Sampling Distribution. Central Limit Theorem. Statistical Process Control. Analysis of Variance.
Article
The numerical, algebraic, and geometric expressions of basic macroeconomic principles are integrated in this spreadsheet approach.
Conference Paper
Computational Fluid Dynamics is now used daily in scientific and engineering practices. The computation themselves are now based on commercially available software. Personal computers are widely utilized elsewhere these days and many people are using spreadsheets as well as word processors. It is now well-known to the scientific and engineering communities that spreadsheets can be used not only for statistics and data processing calculations, but also for matrix inverse, iteration in a finite difference equation, and for special functions of mathematics. This situation allows us to realize SFD, i.e., Spreadsheet Fluid Dynamics. The authors have demonstrated that the fluid dynamics equations including the Navier-Stokes equations could be solved efficiently by using a spreadsheet. The cells in spreadsheets are viewed as either natural grids in CFD or elements of a matrix. The computational domain corresponds to the real physical shape and/or the computational space by grid generation. The result can be visualized in the same spreadsheet with inherent graphics. The pre- and post-processors are all in one in SFD. © 2000 The American Institute of Aeronautics and Astronautics Inc. All rights reserved.