Academic Journals Database
Disseminating quality controlled scientific knowledge

Colour by Numbers: Solving Algebraic Equations Without Algebra

Author(s): Steve Sugden

Journal: Spreadsheets in Education
ISSN 1448-6156

Volume: 2;
Issue: 1;
Start page: 101;
Date: 2005;
Original page

Keywords: solving equations | Excel | conditional formatting

A series of Excel models is described. They allow solution of f(x) = 0 by examining change of sign of function values. The function is graphed and change of sign easily detected by a change of colour. Prominent Excel features used are Names, Chart Wizard and Conditional Formatting. Several sample Excel models are available for download, and the paper is intended to be used as a lesson plan for students having some familiarity with derivatives. For comparison and reference purposes, the paper also presents a brief outline of several common equation-solving strategies as an Appendix.
RPA Switzerland

Robotic Process Automation Switzerland


Tango Jona
Tangokurs Rapperswil-Jona