Curated OER
The Viewing Tube
Looking for an excellent lesson plan that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
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....
Concord Consortium
Be Well
How much do you spend on healthcare each year? Data shows the expenditures in the US rise significantly each year. Young scholars use the data to calculate a rate of change over a 30-year period and look for—as well as provide— possible...
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
Houses and Cars and Loans
Students create a spreadsheet to track their spending. For this algebra lesson, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and house.
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
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Curated OER
Discovering Pi
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Curated OER
Heartbeat Project
Students enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
Curated OER
A Cylinder Workshop
Pupils work with given formulas to solve for specific variables. The calculation of the volume of a cylinder and the change in volume when there is a constant surface area is analyzed in this lesson.
Curated OER
Using Excel To Teach Probability And Graphing
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
PBL Pathways
Do Homework?
To complete homework or not to complete homework ... that is the question. Decide whether it makes a difference on finals by doing homework. Individuals create a scatter plot and find a line of best fit for data on the percent of...
101 Questions
Coins in a Circle
Round and round you'll go! Learners watch as different-sized circles fill with coins. They collect data and then make a prediction about the number of coins that will fit in a large circular rug.
Curated OER
Window-Eyes Lesson 11 Numbers and Capitalization Alert In the Screen Menu
Students practice using the Window Eyes setting to work with numbers settings, and upper and lower case letter alerts.
Curated OER
Sorting
Learners examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
Curated OER
How is Your Driver Doing?
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.
Curated OER
Cannot Buy Me Love
Students investigate the concepts that are related to finance and how it is used in the world. They take part in activities that are focused around the use of a spreadsheet while using a T-chart to simulate a ledger of credits and debits.
Curated OER
Your Just Desserts
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Curated OER
Society, Cyberspace and the Future
Students locate information on the rapid growth of world population and consumption needs through the use of Internet, Cd-ROMs, laser dics and other media. They use spreadsheet to present data gathered on world population growth between...
Curated OER
Management of Wildlife Resources
Students investigate how wildlife management policies affect the size of large animal populations. They develop a spreadsheet that incorporates a mathematical model to predict big game herd sizes, and using worksheet data manage a bison...
Curated OER
Sequences
Students solve problems using the TI. In this calculus lesson, students evaluate functions using sequences. They graph the functions on the TI and make observations.
Curated OER
A "Capital" Idea
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...