首页    期刊浏览 2025年09月21日 星期日
登录注册

文章基本信息

  • 标题:Colour by Numbers: Solving Algebraic Equations Without Algebra
  • 本地全文:下载
  • 作者:Sugden, Stephen J.
  • 期刊名称:Spreadsheets in Education (eJSiE)
  • 印刷版ISSN:1448-6156
  • 出版年度:2006
  • 卷号:2
  • 期号:1
  • 页码:6
  • 出版社:Bond University
  • 摘要: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.
  • 关键词:solving equations; Excel; conditional formatting
国家哲学社会科学文献中心版权所有