Colour by numbers in Excel 2007 : solving algebraic equations without algebra

Sugden, Stephen (2010) Colour by numbers in Excel 2007 : solving algebraic equations without algebra. Spreadsheets in Education, 4(2), pp. 1-15.

View at publisher (open access)


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.

Impact and interest:

Citation counts are sourced monthly from Scopus and Web of Science® citation databases.

These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.

Citations counts from the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

ID Code: 73053
Item Type: Journal Article
Refereed: Yes
Keywords: Solving Equations, Excel 2007, Conditional Formatting
ISSN: 1448-6156
Divisions: Current > Schools > School of Mathematical Sciences
Current > QUT Faculties and Divisions > Science & Engineering Faculty
Deposited On: 30 Jun 2014 23:37
Last Modified: 02 Jul 2014 00:26

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page