Curated OER
Build Your Dream Science Lab
Would your ideal science lab be filled with bubbling beakers and zapping Tesla coils? Or would it contain state-of-the-art computer technology and data analysis? Dream big with an innovative lesson that connects math and language arts...
Curated OER
Area, Surface Area and Volume of 3-D Shapes
Math whizzes examine the relationship between area and volume and the relationship between a 3-D shape and its surface area. Following discussion and practice, pupils participate in a project in which they design packaging for a new...
Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Noyce Foundation
Time to Get Clean
It's assessment time! Determine your young mathematicians' understanding of elapsed time with this brief, five-question quiz.
Curated OER
Which Amusement Park Would You Choose?
Young scholars analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on...
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...
Curated OER
Better Traffic Flow
Students calculate the maximum number of cars passing a point in a given amount of time. In this better traffic flow instructional activity, students work with an existing Excel spreadsheet to solve the traffic flow problem. Students...
Curated OER
What Time is it?
Here is a nice presentation on time; how to read analog clocks and calculating elapsed time. The graphics, and problems posed in this PowerPoint are especially good. One nice feature is that students are encouraged to work together in...
Curated OER
Putting Your Money to Work
Students create a collect data on expenses. In this algebra lesson, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson.
Curated OER
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. For this data analysis lesson students use an Excel spreadsheet to map their data.
Curated OER
How Many?
Middle schoolers explore and design ways to collect data through simulations and random samples. They perform two experiments to determine the answers to various probability problems, and present the data/graphs in the form of a...
Curated OER
Math Operations/Formulas
Middle schoolers discuss the ways spreadsheets can help them solve story problems. In groups, they must set up a spreadsheet with the correct formulas based off of different scenerios using the correct order of operations. To end the...
Curated OER
Forces of Flight - Lift
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson is excellent for use with upper-elementary and middle-level learners and uses spreadsheet software...
Agile Mind
Isabella’s Credit Card
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Google
The Law of Large Numbers and Probability
Learners investigate why theoretical probability doesn't always match reality. The activity involves using Python 2.7 (or Sage) to set up a Bernoulli Trial. It also involves setting up a spreadsheet to simulate the Birthday Paradox....
Curated OER
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Curated OER
Loving Literature
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Curated OER
Circles and Stars
Young scholars solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
Curated OER
Data Handling
In this data handling worksheet, 6th graders solve and complete 4 various types of problems. First, they draw a bar chart to represent the information provided in the table shown. Then, students show beneath the table how to work out the...
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
School Yard Waste
Fourth graders examine the types of garbage that they collect on the playground. They collect the information in a spreadsheet and create a graph that displays the number of types of trash found. They design and monitor a playground...