University of Missouri
Money Math
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling their bedroom,...
Curated OER
Math Hunt
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
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...
Curated OER
Pythagorean Theorem Spreadsheet
Studetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Young scholars work individual...
Curated OER
Sales Spreadsheet
Middle schoolers use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
Curated OER
Using Tables to Solve Linear Functions
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...
Curated OER
Using Fractions to Represent M&M Colors
Students investigate the concept of fraction and tangible application. For this algebra lesson, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the numerator and denominator.
Curated OER
Money Math
Students explore the use of money in daily life. Through activities and real-life simulations, students write and balance a checkbook, explore the importance of budgeting, saving, and expenses. Using spreadsheet technology, they examine...
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
Sums and Difference of Cubes
Learners factor polynomials using the sum and difference of cubes. They also learn connections between the graph and expression.
Curated OER
Sampling Bias And the California Recall
Using a 2002 California Gray David recall vote as an example, young statisticians identify sources of bias in samples and find ways of reducing and eliminating sampling bias. They consider ways to select random samples from a...
Inside Mathematics
Graphs (2006)
When told to describe a line, do your pupils list its color, length, and which side is high or low? Use a worksheet that engages scholars to properly label line graphs. It then requests two applied reasoning answers.
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
Creating a Spreadsheet
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Curated OER
Drawing One and Two Playing Cards With Replacement
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
Curated OER
Looking at Circumference
Learners understand where the number for pi comes from. They understand and use the formula for circumference. Students measure the circles given out and the diameters of those circles and record the results on their worksheet.
Curated OER
Metrically Me!
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
Curated OER
Thinking Outside the Box
Now this lesson sounds fun! Students throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Curated OER
Chances Are......You're Right
Young mathematicians study probability. In this math lesson, learners calculate odds, and convert those into percentages of probability. Fractions are also used, making this lesson quite rich in some of the more difficult conversions...
Curated OER
Introduction to the National Debt
Students relate the national debt to the economy. In this algebra lesson, students discuss what the national debt is, create a national budget based on priority and what the government should spend money on. They analyze their findings...
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...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.