Curated OER
Excel, Word, and Basketball
Wow, this lesson packs a punch. Pupils interview basketball players, write about a game, and use Excel to organize statistics related to the players and the points scored. Afterward, they create posters, presentations, and much more.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
How to Graph in Excel
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Curated OER
A Financial Flower Garden
Here is another in the interesting series of lessons that use the special State Quarters as a learning tool. This one uses the Mississippi State Quarter. During this lesson, pupils learn about the variety of state flowers that represent...
Curated OER
Be Sharp and Never Flat
An outstanding activity on music awaits your young composers! They learn about patterns found in music, the different sections of an orchestra, and see the differences between musicians and a composer. Excellent streamed videos and good...
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Young scholars, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Curated OER
Calculating Profits from Selling Virtual Lemonade
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider weather...
Kenan Fellows
Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
Curated OER
World of the Pond
Field trip! The class will review what they know about organisms that dwell in freshwater ponds, then trek down to the old water hole to collect specimens for examination. This includes several web links, useful tips, and an excellent...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Bunny Cakes and Graphing
Third graders graph and analyze data relating to the book "Bunny Cakes" by Rosemary Wells. They listen to and discuss the book, vote on their favorite cake using Excel computer software, and discuss the results.
Curated OER
State Economy Chart
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Curated OER
Graphing and Analyzing Biome Data
Students explore biome data. In this world geography and weather data analysis lesson, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Curated OER
Getting to the Point
Students determine location by using the technique of triangulation. They imagine that they are out in the wilderness and have come to the top of a ridge. How can one identify the ridge on the topo map? How can one figure out where you...
Curated OER
The Human Memory
This is a well-designed, creative lesson to help young scholars learn more about the human memory. Working in pairs, students complete tasks and gather data. Excellent websites for resources are also provided.
Curated OER
Ancient Peoples of the Middle East
This is an excellent multidisciplinary lesson plan designed by Scientific American. It provides three creative activities--designing a garden, studying hieroglyphics, and writing poetry--relevant to the ancient peoples of the Middle...
Space Awareness
Navigation in the Ancient Mediterranean and Beyond
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
Curated OER
Are You My Little Peanut?
Fourth graders explore the mass and length of peanuts by pretending to parent a peanut. In this mode, median and range lesson students graph their measurements and then use them to find the mode, median and range. Students discuss peanut...
Curated OER
Learning Inference
Making inferences can be a tricky proposition for middle schoolers. In the lesson presented here, pupils practice the skill of drawing a conclusion and making a judgment - which are what making an inference is all about! There are five...
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Young scholars examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data...
Curated OER
Weather instruments
Students explore weather instruments. In this weather lesson, students make rain gauges, anemometers, and barometers following the instructions given in the lesson. Students set up a weather station using their instruments and record and...
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...