
Spreadsheet
Resources
Standards
National
Math Standards (NCTM)
Illinois
Learning Standards
National
Educational Technology Standards (NETS)
Lessons
General
Elementary
General
Math
Science
Social Studies
Language Arts
Middle
School
General
Math

Code
Crackers Math Game  http://www.microsoft.com/education/codecrak.mspx
This engaging and challenging math game provides
students with opportunities to work with math operations and simple
algebraic equations by creating a spreadsheetbased 'rule machine.'

Graphing
Linear Functions 
http://mathforum.org/alejandre/linear.graph.html

Using
Computers to Produce Spreadsheets and Bar Graphs  http://score.kings.k12.ca.us/lessons/spread.bar.html
Links to many
lessons using spreadsheets. Scroll down to the grade levels (4th12th)

Graphing
With Spreadsheets  http://riceinfo.rice.edu/armadillo/Galveston/Curriculum/tech2.html

Judy's
Allowance  http://mathforum.org/sum95/math_and/spreadsheets/examples/allowance.html
Solution
given using ClarisWorks but can be applied to Excel.

Pay
Plans  http://mathforum.org/sum95/math_and/spreadsheets/examples/payPlans.html

Candy is Dandy 
http://www.microsoft.com/education/candy.mspx
Introduces students to the concept of graphing, record color
distribution in spreadsheet format, and utilize information obtained
through handson research and analysis to write a research report.

Creating and Checking
Sequences  http://www.microsoft.com/education/Sequences.mspx
Rather than solve random sequences from a math book
or worksheet, students can create their own sequences and then share
them with classmates.

Geography
Geometry  http://www.microsoft.com/education/GeographyGeometry.mspx

Years,
Months, Days, Hours, Minutes, and Seconds  http://www.microsoft.com/education/YearsMonths.mspx
Students calculate how old they are in years, months, days and on down
to seconds.

Three
Squirrels and a Pile of Nuts  http://www.microsoft.com/education/squirrel.mspx
Students are presented with a fun story problem in
order to learn to solve problems using a spreadsheet in combination with
problemsolving strategies and simple algebraic variables.
Health
Science
Social Studies
Language Arts
High
School
General
Math

DIG
Stats 
http://www.cvgs.k12.va.us/digstats/
A collection of activities and discussions covering Descriptive and
Inferential statistics, two and threedimensional Graphical analysis,
and data visualization appropriate for use in Grades 914.
Includes 19 guides to help students perform statistical and graphical
analyses using Excel or TI83 graphing calculator.

Using
Computers to Produce Spreadsheets and Bar Graphs  http://score.kings.k12.ca.us/lessons/spread.bar.html
Links to many
lessons using spreadsheets. Scroll down to the grade levels (4th12th)

Solving
Polynomial Equations  http://www.microsoft.com/education/solving.mspx
Students
learn smart spreadsheet strategies for solving x and y values. Using a
spreadsheet as a tool for analyzing and visualizing, students discover
new ways of solving mathematical problems.
Science
Social Studies
Business/Consumer Education

Biz
StartUp 
http://www.microsoft.com/education/BizStartUp.mspx
Summary:
hypothetical startup ventures. They use productivity tools to map out
each hopedfor development stage of their enterprises.

Plan
a Trip Anywhere 
http://www.microsoft.com/education/travel.mspx
Students
use selected Internet sites together with productivity tools to plan a
trip to the country of their choice. They learn and communicate about
a foreign country, develop travel planning and budgeting skills, and
build key computer skills.

Buying
a Dream Car 
http://www.microsoft.com/education/dreamcar.mspx
This practical spreadsheet lesson offers easy answers to life's
perplexing math problems like How much will my dream car really cost
after financing?
Resources
Tutorials
Real
World Data
Collaborative
Projects to Join
General
Science
Social Studies

United
States Geological Survey (USGS), U.S. Department of the Interior
 http://www.usgs.gov/pubprod/index.html
Locators & Catalogs, Collections, and Libraries include: Geodata
(geographical information), Geologic Data, Geospatial Data, Water Data,
and Water Use, etc.
Data
Sets and Projects
General

Exploring
Data 
http://exploringdata.cqu.edu.au/
Great site that contains activities, worksheets,
overhead transparency masters, datasets (including stories behind the
datasets) and assessment to support data exploration. It also contains
an extensive collection of articles designed to enhance the statistics
knowledge of the teacher. There is a resources page that gives a select
list of the finest resources available to support introductory
statistics, including texts, websites, datasets, java applets and
mailing lists.

CIESE
Online Classroom Projects  http://www.k12science.org/currichome.html
CIESE sponsors and designs interdisciplinary projects that teachers
throughout the world can use to enhance their curriculum through
compelling use of the Internet, including projects that utilize realtime
data available from the Internet.

The
Data Library  http://mathforum.org/workshops/sum96/data.collections/datalibrary/
The Data Library contains lists of ongoing datasharing projects as well
as downloadable Clarisworks spreadsheets and other sources of data sets
on the web.
Science
Math

Project
SkyMath 
http://www.unidata.ucar.edu/staff/blynds/Skymath.html
This Web Page is designed for middle school mathematics teachers. It
contains all of the information needed for teachers to use the 16
classroom activities of SkyMath, including the module itself.

The
Chance Database 
http://www.dartmouth.edu/~chance/
This data base contains materials designed help teach a Chance course or
a more standard introductory probability or statistics course.

The
Data and Story Library 
http://lib.stat.cmu.edu/DASL/
DASL is an online library of datafiles and stories that illustrate the
use of basic statistics methods.


