Spreadsheets, Graphing Calculators and the Line of Best Fit

dc.creator	Bernie O'Sullivan
dc.date	2003-07-01T00:00:00Z
dc.date.accessioned	2015-07-20T22:06:21Z
dc.date.available	2015-07-20T22:06:21Z
dc.identifier	1448-6156
dc.identifier	https://doaj.org/article/f98b8e7fa7ff40cea61fdddcff214224
dc.identifier.uri	http://evidence.thinkportal.org/handle/123456789/10461
dc.identifier.uri	https://doaj.org/article/f98b8e7fa7ff40cea61fdddcff214224
dc.description	The advent of the hand-held graphing calculator has produced its own mini revolution within the Mathematics classroom. The ability for students to now perform complex mathematical procedures quickly and accurately has pushed back the boundaries of content coverage that is possible within senior Mathematics courses in much the same way as the introduction of the scientific calculator did in the late 70’s. There has been much quality debate and research into the best way to incorporate this new technology, and what balance should be reached between “by hand” methods and hand-held technology. For a discussion on the incorporation of computer algebra systems (CAS), see Flynn et al [1].One technique that can now be done, almost mindlessly, is the line of best fit. Both the graphing calculator and the Excel spreadsheet produce models for collected data that appear to be very good fits, but upon closer scrutiny, are revealed to be quite poor. This article will examine one such case. I will couch the paper within the framework of a very good classroom investigation that will help generate students’ understanding of the basic principles of curve fitting and will enable them to produce a very accurate model of collected data by combining the technology of the graphing calculator and the spreadsheet.
dc.language	English
dc.publisher	Faculty of Information Technology, Bond University
dc.relation	http://epublications.bond.edu.au/cgi/viewcontent.cgi?article=1004&context=ejsie
dc.relation	https://doaj.org/toc/1448-6156
dc.source	Spreadsheets in Education, Vol 1, Iss 1, Pp 58-65 (2003)
dc.subject	spreadsheets
dc.subject	graphs
dc.subject	line of best fit
dc.subject	calculators
dc.subject	Theory and practice of education
dc.subject	LB5-3640
dc.subject	Education
dc.subject	L
dc.subject	DOAJ:Education
dc.subject	DOAJ:Social Sciences
dc.subject	Theory and practice of education
dc.subject	LB5-3640
dc.subject	Education
dc.subject	L
dc.subject	DOAJ:Education
dc.subject	DOAJ:Social Sciences
dc.subject	Theory and practice of education
dc.subject	LB5-3640
dc.subject	Education
dc.subject	L
dc.subject	Theory and practice of education
dc.subject	LB5-3640
dc.subject	Education
dc.subject	L
dc.subject	Theory and practice of education
dc.subject	LB5-3640
dc.subject	Education
dc.subject	L
dc.title	Spreadsheets, Graphing Calculators and the Line of Best Fit
dc.type	Article