Using Data from the Web Workshop

Using Data from the Web to Realize the

Vision in Algebra, Data Analysis, and Representations

A Computer Workshop presented at the

NCTM Annual Meeting in

Las Vegas, 23 April 2002, by

Ed Dickey,

University of South Carolina,

Columbia, SC

(ed.dickey@sc.edu)

Betty Gasque,

South Carolina Systemic Initiative, Columbia, SC

(bgasque@aol.com)

Kevin Morgan,

Madison High School, Madison, OH

(morgan@lightstream.net)

http://www.ite.sc.edu/dickey/NCTMLV.htm

Teachers will examine issues related to planning lessons involving Web-based data and explore several examples that involve the use of data for teaching mathematical topics. Web sites containing data will be explored, and sample lessons addressing algebra, data analysis, and different mathematical representations will be shared.

Using the Excel spreadsheet to analyze data:

Several techniques for importing data.

Global warming data analysis involving statistics and a bar graph.

Smoking data analysis involving linear regression and scatterplot.

Using TI-83+ to analyze data:

Techniques for importing data using TI's Graphlink.

CO₂ data analysis involving algebra, scatter plot, and prediction.

Using an applet to analyze data:

Accessing a web-based computer program (applet).

Drug elimination data analysis involving recursion and graphing.

Introduction:

Issues related to planning lessons involving web-based data.

Examples involving the use of data for teaching mathematical topics.

Session Outline:

Introduction and Overview (Ed) 5 minutes
1. Web-based Data
2. Tools for Analysis

i. Spreadsheet (Excel)

ii. Graphing Calculator (TI-83+)

iii. Applets (Illuminations)

Global Warming/Climate Data using Excel (Ed) 25 minutes
1. Importing Data from the Web to Excel
2. Recognizing "nice" data
3. Dealing with data

i. Excel Files

ii. Aligned Columns

iii. HTML Tables

iv. PDF Files

v. Conversion Wizards

vi. Copy and Paste

Global Warming Activity (aligned columns)
Lung Cancer and Smoking Activity(HTML Table)

Analyzing CO₂ Levels in the Earth's Atmosphere (Betty) 30 minutes

a. Using TI-83+ and Graphlink

b. Downloading data from a web site to a computer

c. Transferring the data to a graphing calculator

d. Analyzing the data with a graphing calculator

Drug Elimination/NCTM applet (Kevin) 20 minutes
1. Generating and analyzing data for the Volleyball Medicine problem

i. using the table applet

ii. using the graph applet

Generating and analyzing data for "loading dose" regimens compared to "straight dose" regimens

Wrap-up/questions/web data exploring (Kevin) 10 minutes

Resources:

Bell, Randy; Margaret Niess and Lynn Bell (2002). "El Nino Did It." Learning and Leading with Technology, 29(4), Dec-Jan, 2001-2, pp. 18-26.

Dickey, Ed. "Using Web Data and Applets to Address the Algebra and Representations Standards." [Online] http://www.ite.sc.edu/dickey/scctm2001.htm

National Academy Press (1998). High School Mathematics at Work: Essays and Examples for Educators of All Students. National Academy Press: Washington, D.C. [Online] http://www.nap.edu/catalog/5777.html

National Academy Press (1998). "Drug Dosage." High School Mathematics at Work: Essays and Examples for Educators of All Students. National Academy Press: Washington, D.C. pp. 80-82. [Online] http://www.nap.edu/openbook/0309063531/html/80.html

NCTM (2000). E-Example 7.2.1: Using Graphs, Equations, and Tables to Investigate the Elimination of Medicine from the Body. [Online] http://standards.nctm.org/document/eexamples/chap7/7.2/index.htm

NCTM (2000). Algebra Standard for Grades 6-8 and Grades 9-12. [Online] http://standards.nctm.org/document/chapter6/alg.htm

http://standards.nctm.org/document/chapter7/alg.htm

NCTM (2000). Data Analysis and Probability Standard for Grades 6-8 and Grades 9-12. [Online] http://standards.nctm.org/document/chapter6/data.htm

http://standards.nctm.org/document/chapter7/data.htm

NCTM (2000). Representation Standard for Grades 6-8 and Grades 9-12. [Online] http://standards.nctm.org/document/chapter6/rep.htm

http://standards.nctm.org/document/chapter7/rep.htm

RxList: The Internet Drug Index (2002). ãAzithromycin-RxList Monographs.ä [Online] http://www.rxlist.com/cgi/generic/azith_cp.htm

Starnes, Daren (2001). ãImporting Data to the TI-83Plus Calculator.ä Mathematics Teacher, 94(9), Dec 2001, pp. 767-770.

Stohl, Hollylynne (2001). "Analyzing Smoking and Lung Cancer." Center for Technology and Teacher Education: Mathematics Activities. University of Virginia [Online] http://curry.edschool.virginia.edu/teacherlink/content/math/activities/ex-smoking/

Web Data Sources

Chance Data Sets http://www.dartmouth.edu/~chance/teaching_aids/data.html

TI Data Sites http://education.ti.com/product/software/tii/datasites/category.html

Math Forum Sites http://mathforum.com/workshops/usi/dataproject/

University of Virginia Sites http://curry.edschool.virginia.edu/teacherlink/content/math/relatedlinks/datacollection.html

Whatcom Community College http://math.whatcom.ctc.edu/realdata/realdata.htm

Track and Field http://www.sci.fi/~mapyy/tilastot.html

Climate Data http://met-www.cit.cornell.edu/other_rcc.html

Internet Data Collections Lesson Plan

http://illuminations.nctm.org/lessonplans/3-5/data_also/index.html

Generating and Analyzing Data Lesson

http://illuminations.nctm.org/lessonplans/9-12/gen_data1112/index.html