Spreadsheets, Graphing Calculators and the Line of Best Fit

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

Full description

Bibliographic Details
Main Author: Bernie O'Sullivan
Format: Article
Language:English
Published: McMaster University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4516-spreadsheets-graphing-calculators-and-the-line-of-best-fit.pdf
_version_ 1797967801799933952
author Bernie O'Sullivan
author_facet Bernie O'Sullivan
author_sort Bernie O'Sullivan
collection DOAJ
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.
first_indexed 2024-04-11T02:36:53Z
format Article
id doaj.art-8ba51d520a344f5db4f85890fb72cd74
institution Directory Open Access Journal
issn 1448-6156
language English
last_indexed 2024-04-11T02:36:53Z
publisher McMaster University
record_format Article
series Spreadsheets in Education
spelling doaj.art-8ba51d520a344f5db4f85890fb72cd742023-01-02T19:51:57ZengMcMaster UniversitySpreadsheets in Education1448-6156Spreadsheets, Graphing Calculators and the Line of Best FitBernie O'SullivanThe 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.http://sie.scholasticahq.com/article/4516-spreadsheets-graphing-calculators-and-the-line-of-best-fit.pdf
spellingShingle Bernie O'Sullivan
Spreadsheets, Graphing Calculators and the Line of Best Fit
Spreadsheets in Education
title Spreadsheets, Graphing Calculators and the Line of Best Fit
title_full Spreadsheets, Graphing Calculators and the Line of Best Fit
title_fullStr Spreadsheets, Graphing Calculators and the Line of Best Fit
title_full_unstemmed Spreadsheets, Graphing Calculators and the Line of Best Fit
title_short Spreadsheets, Graphing Calculators and the Line of Best Fit
title_sort spreadsheets graphing calculators and the line of best fit
url http://sie.scholasticahq.com/article/4516-spreadsheets-graphing-calculators-and-the-line-of-best-fit.pdf
work_keys_str_mv AT bernieosullivan spreadsheetsgraphingcalculatorsandthelineofbestfit