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)

• Data Analysis and Probability - http://standards.nctm.org/document/appendix/data.htm 

Illinois Learning Standards

• Mathematics:  Goal 10 - Data Analysis and Probability - http://www.isbe.state.il.us/ils/math/pdf/goal10.pdf 
  

National Educational Technology Standards (NETS)

• Technology Foundation Standards for All Students - http://cnets.iste.org/students/s_stands.html 
  
  

Lessons

General

• Create a Graph - 
  http://nces.ed.gov/nceskids/Graphing/ 
  Create graphs online - area, bar, line, or pie.  Add your own data 
  and print out the results.  Great resource for those with no access to 
  spreadsheet software.
  
  

• Grade Graph - http://www.sfusd.edu/schwww/sch634/Webpages/Misc.6th%20gr/grgraph.html 
  
  

• Exploring Data - 
  http://mathforum.org/workshops/usi/dataproject/ 
  Links for K-4, 5-8, 9-12
  
  

• Using Spreadsheets to Create Graphs - http://mathforum.org/alejandre/spreadsheet.html 
  Ideas using ClarisWorks. Can be applied to Excel.
  
  
  

• Display Fractions in an Excel Spreadsheet - http://www.microsoft.com/education/DisplayFractions.mspx 
  
  

• Here's the Scenarios - 
  http://www.microsoft.com/education/ExcelScenario.mspx 
  How to create and use scenarios in Excel.  As Microsoft state, "A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to predict the outcome of different situations in your spreadsheet."
  
  

• Assigning Labels to Information - http://www.microsoft.com/education/Labeling.mspx 
  Creating interactive labels for images in Excel.
  
  

• Using Macros to Speed up Work - http://www.microsoft.com/education/UseExcelMacros.mspx 
  
  

• Using Data to Make Charts and Graphs - http://www.microsoft.com/education/ChartsandGraphs.mspx 
  Surveys - Includes a Word document to record results and an Excel file to analyze the data.

Elementary

General

• Spreadsheets: A Variety of Activities - http://www.fi.edu/fellows/fellow4/may99/spreadsheet.html 
  
  

• Computer Capers: K-2 Spreadsheets
  
  

• Computer Capers: 3-5 Spreadsheets

 

Math

• Santa's Elf Spreadsheet - http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss1.htm 
  
  

• Group Graphing - 
  http://www.fi.edu/qa98/me5/me5.html  
  conducting a poll of their classmates
  
  

• Million Dollar Project - 
  http://cnets.iste.org/students/pf/pf_million_dollar.html 

Science

• Using Spreadsheets in Thinking Science - http://www.edu.dudley.gov.uk/science/case4.html 
  Spinning Coins Activity
  
  

• Understanding Weather - http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss2.htm 
  
  

• How Much Would I Weigh on Mars? - http://mathforum.org/sum95/math_and/spreadsheets/examples/
  marsWeight.html
  
  

• Left-handed or Right-handed?
  http://math.rice.edu/%7Elanius/Algebra/rightleft.html  
  
  

• Simple Machines - 
  http://www.microsoft.com/education/Machines.mspx 
  

Social Studies

• Lemonade Business - 
  http://www.teachers.net/lessons/posts/1542.html 
  Use the information generated playing the Lemonade Stand to create an income statement using Excel to use in the Power Point presentation.
  

Language Arts

• Amazing Autobiographies - http://www.microsoft.com/education/AmazingAutobiographies.mspx 

Middle School

General

• Middle School Net: Spreadsheets - http://www.middleschool.net/lesspln/mathF/mathlp.htm 
  Links to many lesson plans.

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 spreadsheet-based '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 (4th-12th)
  
  

• 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 hands-on 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 problem-solving strategies and simple algebraic variables.

Health

• Making a Mess o' Mousse! - Recipe - http://www.sfusd.edu/schwww/sch634/Webpages/7thgr/mousse.html - server down??
  
  

• Nutrition Goodies - http://www.sfusd.edu/schwww/sch634/Webpages/Nutrition/nut.html - server down??
  

Science

• Bird Watching - http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss6.htm 
  
  

• Zoo Mathematics - http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss4.htm 
  
  

• Collecting Weather Data - http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss3.htm 
  
  

• Climate Change Over 50 Years - 
  http://www.netcore.ca/~gibsonjs/g200-3t.htm 
  
  

• Scale Solar System Model - http://mathforum.org/sum95/math_and/spreadsheets/examples/solSystem.html 
  
  

• Chesapeake Bay Population Studies 
  http://www.baylink.org/lessons/pop-density_right.html 
  
  

• It's in the (Chocolate) Chips - http://www.microsoft.com/education/chocchip.mspx    
  Students will investigate which brand of chocolate chip cookies contains the most chocolate; they analyze and compare data using Microsoft Word and Microsoft Excel, and then use Microsoft PowerPoint to communicate their findings.
  
  

• Clues to Climate Change - http://www.microsoft.com/education/ClimateChangeClues.mspx 
  Students address questions and form opinions about global warming by studying, analyzing, and interpreting weather information and analysis available online.
  

Social Studies

• Lemonade Business - 
  http://www.teachers.net/lessons/posts/1542.html 
  Use the information generated playing the Lemonade Stand to create an income statement using Excel to use in the Power Point presentation.
  
  

• Surfing Amusement Parks - 
  http://score.kings.k12.ca.us/lessons/amprks.htm 
  
  
  

• Let's Have a Field Day - 
  http://www.itdc.k12.ca.us/curriculum/fieldday.html  Students plan a school field day including event planning and cost spread sheets.
  
  

• How Much Tax Would You Pay? - 
  http://web.ai/club/spread02.html 
  
  

• Do Vampires Really Exist? - 
  http://www.microsoft.com/education/vampire.mspx 
  
  

• Celebrate the USA - 
  http://www.microsoft.com/education/celebusa.mspx 
  Students act as marketers hired to promote one state in the U.S.A. Each team researches their state, creates a marketing brochure, and gives a presentation to entice people to move to or visit that state.
  
  

• Making Ends Meet - 
  http://www.microsoft.com/education/endsmeet.mspx 

Language Arts

• Who's the Greatest? - 
  http://www.teachers.net/lessons/posts//1211.html Persuasive writing

High School

General

• Dancing with the Data - 
  http://www.microsoft.com/education/dancingdata.mspx  Teacher Brenda A. Dyck shares two electronic tools that help teachers track student grades and quiz results.
  
  

• Personal Best - 
  http://www.microsoft.com/education/PersonalBest.mspx 
  Students choose one personal goal - anything from improving a class score to perfecting a jump shot - and use a private online journal to chart their own progress as they work toward that goal.

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

• Introduction to the Waste Problem - http://www.csun.edu/~vceed002/BFI/lessons/spreadsheets.html 
  
  
  

• Personal Energy Meter- 
  http://www.microsoft.com/education/picenergy.mspx 

  Students take a look at their own energy use, tally up the costs in dollars and the environmental impact , and then think of ways to save. They explore energy conservation techniques and advocate for conservation in their own communities.
  
  

• How Do Earthquakes Effect Buildings? - http://www.microsoft.com/education/Earthquakes.mspx 
  
  

• How Much Water Does Your Family Use? - http://www.microsoft.com/education/WaterUse.mspx 
  
  

• Acid Rain in Our State -
  http://www.microsoft.com/education/acidrain.mspx 
  

Social Studies

• Buy Low, Sell High - 
  http://www.microsoft.com/education/buylow.mspx 
  This lesson will teach students how to invest in corporate stocks by creating investment 'portfolios.' Step-by-step instructions will enable students to develop worksheets that track their portfolio's performance over a specified time period and report the results to the class.
  
  

• Bridging the Generation Gap - http://www.microsoft.com/education/gengap.mspx Students get a real life lesson in sociology as they create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.

• Biographies Alive - 
  http://www.microsoft.com/education/BiographiesAlive.mspx 
  

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

• Atomic Learning - 
  http://www.atomiclearning.com/ 
  Some portions of the site are free; others require a subscription
  
  

• Creating Pictographs with Microsoft Excel - http://www.lttechno.com/links/pictographs.html 
  
  

• Excel Tests - 
  http://aitt.acadiau.ca/tutorials/Excel2000/Excel2000tests/index.htm 
  How to create tests using Excel
  
  

• Florida Gulfcoast University Excel 2000 Tutorials 
  http://www.fgcu.edu/support/office2000/excel/ 
  
  

• Internet 4 Classrooms Excel Tutorial - Microsoft Excel Modules - 
  http://www.internet4classrooms.com/on-line_excel.htm 
  
  

• MI Stupid Excel Tutorials - 
  http://mistupid.com/tutorials/excel/ 
  
  

• Tech Train: Overview of Microsoft Excel 
  http://www.techtrainteam.com/services/olt/office2000/xls.html
  
  

• School Spreadsheet Safari - 
  http://library.thinkquest.org/J0110054/index.html 
  
  

• Spreadsheet Tutorial
  http://www.usd.edu/trio/tut/excel/1.html 
  

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

• Central Intelligence Agency - http://www.odci.gov/cia/publications/factbook/index.html 
  The World Fact Book 2002.  Collect and analyze data about different counteries.
  
  

• U.S. Census Bureau - 
  http://www.census.gov/ 
  Excel files throughout the site depending on the topic you are looking for.
  
  

• Federal Reserve:  Economic Data - 
  http://research.stlouisfed.org/fred/ 
  
  

• FedStats - http://www.fedstats.gov/ 
  The gateway to statistics from over 100 U.S. Federal agencies    
  
  

• StatLib: Datasets Archive - 
  http://lib.stat.cmu.edu/datasets/ 
  From the Carnegie Mellon University Statistics Department. Datasets from articles and books, and other sets submitted by readers.
  

Science

• National Center for Health Statistics - 
  http://www.cdc.gov/nchs/ 
  
  

• National Oceanic and Atmospheric Administration - 
  http://www.noaa.gov 
  
  

• National Geophysical Data Center -  
  http://www.ngdc.noaa.gov 
  
  

• Regional Climate Centers - 
  http://met-www.cit.cornell.edu/other_rcc.html 
  
  

• National Climatic Data Center - 
  http://lwf.ncdc.noaa.gov/oa/ncdc.html 
  
  

• National Oceanographic Data Center - 
  http://www.nodc.noaa.gov/ 
  
  

• MIT Center for Space Research - 
  http://space.mit.edu/ 
  
  

• NSF Geosciences Integrated Earth Information Server (IEIS) - http://atm.geo.nsf.gov/ 

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

• WhaleNet - 
  http://whale.wheelock.edu/Welcome.html 
  Focusing on whales and marine research.  Click on "WhaleNet Tour" then scroll down to "Research Tools" - "WhaleNet Data".
  
  

• Exploring Oceans of Data - 
  http://mathforum.org/workshops/usi/dataproject/ 
  This site contains data and projects for K-4, 5-8, and 9-12.
  
  

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.

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

Click here for the current version of the page.