Colour by Numbers in Excel 2007: Solving Algebraic Equations Without Algebra

This is an update of an earlier paper, and is written for Excel 2007. A series of Excel 2007 models is described. The more advanced versions 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. Rele...

Full description

Bibliographic Details
Main Author: Stephen Sugden
Format: Article
Language:English
Published: McMaster University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4581-colour-by-numbers-in-excel-2007-solving-algebraic-equations-without-algebra.pdf
Description
Summary:This is an update of an earlier paper, and is written for Excel 2007. A series of Excel 2007 models is described. The more advanced versions 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. Relevant features of Excel 2007 used are Names, Scatter Chart and Conditional Formatting. Several sample Excel 2007 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.
ISSN:1448-6156