Colour by Numbers: Solving Algebraic Equations Without Algebra

Colour by Numbers: Solving Algebraic Equations Without Algebra

Show other versions (1)

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 Ex...

Full description

Bibliographic Details
Main Author: Stephen J. Sugden
Format: Article
Language:English
Published: Bond University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4532-colour-by-numbers-solving-algebraic-equations-without-algebra.pdf
id doaj-961243618af34a2ea1eed208677c79aa
record_format Article
spelling doaj-961243618af34a2ea1eed208677c79aa2020-11-25T01:34:38ZengBond UniversitySpreadsheets in Education1448-6156Colour by Numbers: Solving Algebraic Equations Without AlgebraStephen J. SugdenA 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.http://sie.scholasticahq.com/article/4532-colour-by-numbers-solving-algebraic-equations-without-algebra.pdf
collection DOAJ
language English
format Article
sources DOAJ
author Stephen J. Sugden
spellingShingle Stephen J. Sugden
Colour by Numbers: Solving Algebraic Equations Without Algebra
Spreadsheets in Education
author_facet Stephen J. Sugden
author_sort Stephen J. Sugden
title Colour by Numbers: Solving Algebraic Equations Without Algebra
title_short Colour by Numbers: Solving Algebraic Equations Without Algebra
title_full Colour by Numbers: Solving Algebraic Equations Without Algebra
title_fullStr Colour by Numbers: Solving Algebraic Equations Without Algebra
title_full_unstemmed Colour by Numbers: Solving Algebraic Equations Without Algebra
title_sort colour by numbers: solving algebraic equations without algebra
publisher Bond University
series Spreadsheets in Education
issn 1448-6156
description 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.
url http://sie.scholasticahq.com/article/4532-colour-by-numbers-solving-algebraic-equations-without-algebra.pdf
work_keys_str_mv AT stephenjsugden colourbynumberssolvingalgebraicequationswithoutalgebra
_version_ 1725070679412310016

Similar Items