Spreadsheet Resources 

 

 
Standards Lessons Resources
National Math Standards General Tutorials
IL Learning Standards Elementary Real World Data
NETS Middle School Data Sets and Projects
High School


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

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 three-dimensional Graphical analysis, and data visualization appropriate for use in Grades 9-14.  Includes 19 guides to help students perform statistical and graphical analyses using Excel or TI-83 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 (4th-12th)

  • 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 Start-Up - 
    http://www.microsoft.com/education/BizStartUp.mspx
     

    Summary: hypothetical start-up ventures. They use productivity tools to map out each hoped-for 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

  • Science and Math Projects from CIESE - http://www.k12science.org/collabprojs.html 
    Ccollaborative and real time data projects for K-12 science and math education.  Includes the following projects for Spring and Fall:
    -- Down the Drain: How Much Water Do You Use? -- The International Boiling Point Project -- Human Genetics: A Worldwide Search for the Dominant Trait -- The Global Water Sampling Project -- The Global Sun/Temperature Project -- Square of Life: Studies in Local and Global Environments -- Bucket Buddies -- Take a Dip -- Mission to Eros: Rendezvous with an Asteroid -- Noonday Project: Measuring the Circumference of the Earth

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 data-sharing 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.

 

welcome
about us
Professional Development Services I Provide
Projects I Have Been Involved In
Technology Subject Area Links
Links to Technology Resources
search
contact us
 

Add to Your Favorites

Home | About Us | Professional Development | Projects
Teacher Resources | Technology Resources | Search | Contact Us

ŠLT Technologies 2007
LToulon@LTTechno.com
  

Links verified weekly by Site Integrity

Click here for the current version of the page.