 |
Spreadsheet Resources
Standards
National Math Standards (NCTM)
Illinois Learning Standards
National Educational Technology Standards (NETS)
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
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 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
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://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
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.
|
|
|
