Spreadsheet Conditional Formatting: An Untapped Resource for Mathematics Education

Electronic spreadsheets have been with us for almost 25 years. In that period, innovative educators have found many ways in which this ubiquitous class of software may be leveraged in support of learning, especially in mathematics and the physical sciences. Conditional formatting is a relatively recent feature of the modern graphical spreadsheet, and may be viewed as a generalization of the accounting procedure of indicating debits by red ink and other amounts in black. The paper discusses advances in technology-enabled pedagogy made possible by this seemingly trivial feature of the modern spreadsheet program.

[1]  Philip Clarkson,et al.  Language Factors in Mathematics Teaching and Learning , 1996 .

[2]  Sharon Dugdale,et al.  K-12 teachers' use of a spreadsheet for mathematical modeling and problem solving , 1994 .

[3]  M Miraç Özar.  Spreadsheets in education , 1996 .

[4]  J. W. Bruce,et al.  Microcomputers and Mathematics , 1990 .

[5]  Frank Eade.  Secondary trainee teachers' understanding of convergence and continuity , 2003 .

[6]  Sergei Abramovich,et al.  What Are Billy's Chances? Computer Spreadsheet as a Learning Tool for Younger Children and Their Te , 2002 .

[7]  Janet Ainley.  Re-viewing Graphing: Traditional and Intuitive Approaches , 1995 .

[8]  J. H. van Lint,et al.  What is discrete mathematics and how should we teach it , 1994 .

[9]  Stephen I. Brown,et al.  The Art of Problem Posing , 1983 .

[10]  David Tall,et al.  Functions and Calculus , 1996 .

[11]  Robert Kanigel.  The Man Who Knew Infinity: A Life of the Genius Ramanujan , 1991 .

[12]  Douglas A. Grouws,et al.  Handbook of research on mathematics teaching and learning , 1992 .

[13]  Kurt Kreith,et al.  Iterative Algebra and Dynamic Modeling: A Curriculum for the Third Millennium , 1999 .

[14]  Sergei Abramovich,et al.  Solving equations within spreadsheet , 1992 .

[15]  Edward A. Silver,et al.  Thinking through Mathematics: Fostering Inquiry and Communication in Mathematics Classrooms. The Thinking Series. , 1990 .

[16]  Hollylynne Stohl Drier.  Do Vampires Exist? Using Spreadsheets To Investigate a Common Folktale. , 1999 .

[17]  R. D. Murphy,et al.  Iterative solution of nonlinear equations , 1994 .

[18]  Sergei Abramovich,et al.  Technology for deciding the convergence of series , 1995 .

[19]  Sergei Abramovich.  Cognitive Heterogeneity in Computer-Mediated Mathematical Action as a Vehicle for Concept Development , 2003 .

[20]  John E Baker,et al.  Spreadsheets in Education-The First 25 Years , 2007 .

[21]  Bruce Schneier,et al.  Practical cryptography , 2003 .

[22]  Jan Bezuidenhout.  Limits and continuity: some conceptions of first-year students , 2001 .

[23]  Sergei Abramovich,et al.  Spreadsheets in teaching and learning topics in calculus , 1994 .

[24]  Norman G. Lederman,et al.  School Science and Mathematics 101 , 2002 .

[25]  William J. Masalski.  How To Use the Spreadsheet as a Tool in the Secondary School Mathematics Classroom. Second Edition (for Windows and Macintosh Operating Systems). , 1990 .

[26]  Dave Pratt,et al.  The construction fo meanings for trend in active graphing , 2000, Int. J. Comput. Math. Learn..

[27]  Erich Neuwirth,et al.  The Active Modeler: Mathematical Modeling with Microsoft Excel , 2003 .

[28]  J. Bruner,et al.  The role of tutoring in problem solving. , 1976, Journal of child psychology and psychiatry, and allied disciplines.

[29]  Hollylynne Stohl Drier,et al.  Teaching and Learning Mathematics With Interactive Spreadsheets , 2001 .

[30]  David Tall,et al.  Conflicts in the Learning of Real Numbers and Limits. , 1978 .