Spreadsheets
Tutorials & Resources
To Excel in the Classroom is Elementary An excellent resource for teachers that includes lesson plans and ideas for using Excel in the classroom. Classroom strategy, data links, and teacher resources are included. |
Includes ideas for using spreadsheets in education and a clear explanation of what is a spreadsheet. |
|
Real world data on the Internet. tutorials, creating graphs, elementary, middle and secondary uses by content area and much more. |
|
|
DASL (pronounced "dazzle") is an online library of datafiles and stories that illustrate the use of basic statistics methods. We hope to provide data from a wide variety of topics so that teachers can find real-world examples that will be interesting to their students. |
School Spreadsheet Safari (2001 ThinkQuest Site) Do you want to learn about spreadsheets? In this website you'll learn about the history of spreadsheets, how to use them, and vocabulary. You will find out how spreadsheets can be used in a variety of school subjects and how they can help you organize information and practice skills. There are also some cool quizzes and puzzles. |
Lesson Plans/Ideas
|
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. |
It's a Sale (Percentages- Gr. 5-8) Purpose: have students make good decisions about making purchases of items on sale. Understand how percentages affect cost. Objectives: students will comparative shop with items on sale; students will use a spreadsheet to explore how percentages affect cost |
|
How much does a Big Mac cost in Ireland? A complete list of the cost of a Big Mac in the local currency of many countries compared to US dollars. A good data index for spreadsheets and graphing. |
Oceans of Data- lesson plans by grade level and standard. |
|
Focusing on whales and marine research. Click on "WhaleNet Tour" then scroll down to "Research Tools" - "WhaleNet Data". |
Chesapeake Bay Populations Studies |
Everyday Spreadsheets in the Classroom This is a useful site containing utilities for teachers and student lessons. |
The ABC's to Excel: a list of 26 activities to be done with Excel. |
|
Links from the University of Virginia mathematics teacher education site. |
How much water does your family use? A secondary lesson from Microsoft. |
|
Good real life examples: Cleaning service, auto shop, car rental, small businesses. |
Three Squirrels and a Pile of Nuts Middle school students learn to solve story problems using a spreadsheet in combination with various problem-solving strategies. |
|
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.' |
|
|
In this real-life simulation, students create a monthly budget, showing income earned from an imaginary job versus estimated monthly expenses. They then encounter unexpected monthly expenses and must adjust their budget to compensate for those expenses. |
Students will enter data and formulas into an electronic spreadsheet to compute the life span and average age at death of famous North Carolinians. (4th grade lesson) |
Online Spreadsheet Projects
The Global Water Sampling Project From March 28 until May 27, 2005, students will team up around the globe to test fresh water. Join us in this collaborative project, comparing the water quality of your local river, stream, lake or pond with other fresh water sources around the world. |
Down the Drain- How much water do you use? How much water do you use everyday in your home? Would you be surprised to learn that according to the USGS the average American uses between 80-100 gallons (approx. 300 - 375 liters) of water per day? Do you think people in other parts of the world use more or less water than Americans? Well, this collaborative project will help you find out the answers to these questions. |
|
Classroom projects using real world data. |
Spreadsheet Tool: an interactive math tool |
Data and Statistics Sites
NOAA Satellite and Information Service The National Oceanographic Data Center archives & provides public access to global oceanographic and coastal data, products, and information. |
National Climatic Data Center- Protecting the Past, revealing the future |
|
Let's you generate and export air quality data based on your select criteria. |
Ready to use datasets in Excel format on a variety of topics. |
|
This site contains many data sets related to US Census data. |
This site contains a lot of data on labor statistics. |
National Center for Educational Statistics Many many statistics on education. |
|