**Using Spreadsheets to Explore
Real-World Data
**Technology can help promote students’ understanding
of mathematical concepts, quantitative reasoning, and achievement
when used as a tool for solving problems, testing conjectures,
accessing data, and verifying solutions.

California mathematics standards: ... The goal in mathematics education is for students to be able to:

• Communicate precisely about quantities, logical relationships, and unknown values through the use of signs, symbols, models, graphs, and mathematical terms.

• Reason mathematically by gathering data, analyzing evidence, and building arguments to support or refute hypotheses.

• Make connections among mathematical ideas and between

Spreadsheets are valuable tools for compiling data, organizing and recording simple statistics, and providing a visual representation of data through graphing. Many teachers are integrating spreadsheets into their classroom lessons allowing students to play a more active role in their learning. Students can change variables and instantly see results of data analysis and calculations.

Examples of lessons:

* Planning a budget

* Recipe calculations/reductions

* Conversion tables

* Calculations of age and weight on different planets

* Planning a trip and calculating the distance

* Charting growth rate

* Tracking votes on election days

* Compare temperatures in different cities

Students can be successful using spreadsheets with just a few basic skills:

- being able to identify specific “cell addresses” (defined using rows and columns)
- being able to construct a formula
- being able to distinguish the type of data being calculated.

There are many quality websites providing tutorials on the use of spreadsheets AND ready-to-use samples for downloading.

- From the Math Forum:
**An Introduction to Math and Spreadsheets**

__http://mathforum.org/sum95/math_and/spreadsheets/intro.html__

- From the Advanced Technology Research Office of the Hawaii Dept. of Education

http://t3.k12.hi.us/t302-03/tutorials/ss/

- From North Carolina Public Schools:
**Computer Skills Lesson Plans**

__http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/sstoc.html__

- From NASA:
**Sine and Cosine Graphing with AppleWorks Spreadsheets**

__http://www.grc.nasa.gov/WWW/K-12/Sample_Projects/Sine_Cosine/sin_cosin.html__

- From Sabine Parish, Louisiana

**Excel Viewlets and Guides**

__http://www.sabine.k12.la.us/training/Excel%202000.htm__

- From University of Puget Sound:
**Introduction to Spreadsheets**

__http://www.ups.edu/community/tofu/lev1f/conframe.htm__

- From Microsoft.com:
**Lesson plans search page**

__http://www.microsoft.com/education/?ID=LessonPlans__

- From Microsoft.com:
**Using Data to Make Charts and Graphs**http://www.microsoft.com/Education/?ID=ChartsandGraphs

- From SunSITE Austria at the University of Vienna:

**Spreadsheets, Mathematics, Science, and Statistics Education**

__http://sunsite.univie.ac.at/Spreadsite/__

This page tries to collect some information about spreadsheets with an emphasis on mathematics and statistics education.

- From the University of Virginia, Center for Technology and Teacher Education:

**Microsoft Excel Interactive Projects**

__http://www.teacherlink.org/content/math/interactive/interactiveexcel.html__

- From Brigham Young University Mathematics Department

**Spreadsheets in the Math Class**

http://www.math.byu.edu/~lfrancis/readings302/Spreadsheets.html

- From ENC online:
by Hollylynne Stohl Drier, Kara M. Dawson, and Joe Garofalo*Using Technology and Real World Connections to Teach Secondary Mathematics Concepts*

__http://www.enc.org/topics/realworld/online/document.shtm?input=FOC-000706-index__

- The Math Forum provides
**downloadable Excel spreadsheets**. The downloaded lists can then be sorted, manipulated, and graphed on your computer in the same way that any spreadsheet is manipulated.

__http://mathforum.org/workshops/sum96/data.collections/datalibrary/data.set6.html__

*Create your own!*From the Math Forum: links to**“Real-World Data Sets”**

__http://mathforum.org/workshops/sum96/data.collections/datalibrary/other.resources.html__* America's Best Colleges - U.S. News & World Reports

* American FactFinder

* The Baseball Archive

* The Bureau of Justice Statistics

* The Bureau of Labor Statistics

* The Bureau of Transportation Statistics

* The Census Bureau

* Data and Story Library (DASL)

* Data Sets, UCLA Statistics Department

* Dr. B's Wide World of Web Data

* Economic Research Service

* Energy Information Administration

* FedStats

* The Gallop Organization

* GovStats

* Journal of Statistics Education Data Archive

* Kentucky Derby Race Statistics

* National Agricultural Statistics Service

* National Center for Education Statistics

* National Center for Health Statistics

* Sports Statistics on the Web

* Statistics Canada

* StatLib---Datasets Archive

* Tax Statistics - IRS

* UK Government Statistical Service

* United Nations: Cyber SchoolBus Resources

* US Business Cycle Indicators

**Harvest Your Own Data:**

- From David Warlick's Landmark Project, connect to a variety of database
and stastical information with suggestions for use in the classroom.

http://www.landmark-project.com/

**Other Resources:**

- From Cupertino Union Schools (K-6):
**Technology Benchmark Lessons**

__http://www.cupertino.k12.ca.us/math/default.html__

- From FOCUS ON BASICS, Vol 4, Issue B • September 00

*Using Software Applications to Teach Math*by Catherine Cantrell

__http://www.gse.harvard.edu/~ncsall/fob/2000/cantrell.html__

- From: Visions Technology in Education

*AppleWorkshop for Students 6.0*by Janet Caughlin

__http://www.toolsforteachers.com/__

- From ENC online:
**Math Topics -> Real Data**

__http://www.enc.org/weblinks/math/0,1544,1%2DReal+Data,00.shtm__

Charlene Chausis, Adlai E. Stevenson High School (retired 2012)