Intel
Pedal Power
Show your classes the importance of mathematics in something as simple as bicycle design. The final lesson in the six-part STEM series has each group research a different aspect of the bicycle. Learners use mathematical formulas, linear...
Curated OER
Iditarod
For this Iditarod worksheet, young scholars complete word problems about fractions, money, and more, based on the Iditarod race. Students complete 10 problems.
Curated OER
Buying Cars/Financing Cars Compound Interest
Provide a real world context in which exponential functions are used to determine a eal world phenomena such as compound interest and exponential growth. This activity should be taught after students have mastered the laws of exponents...
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...
Statistics Education Web
Walk the Line
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Education Development Center
Interpreting Statistical Measures—Class Scores
Explore the effect of outliers through an analysis of mean, median, and standard deviation. Your classes examine and compare these measures for two groups. They must make sense of a group that has a higher mean but lower median compared...
Curated OER
Flavorful Spreadsheets
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Curated OER
Spreadsheet Activity
Students create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
Moving Day!
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
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
Louisville's Best Field Day Park
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Curated OER
ExplorA-Pond: 6th Grade Area and Random Number Tables
Sixth graders estimate surface area of a pond using a random number table.
Curated OER
Two-Variable Linear Inequalities
Here is an engaging lesson plan on solving equations with two variables. Have the class rewrite linear equations in the slope intercept form, y=mx + b. They graph the lines using the slope and y-intercepts.
Curated OER
Population Growth Rates
Students determine the average annual rate of change (growth rate) of U.S. national population for each decade of historical census data.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
Nascar Unit Activity 2
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Curated OER
What Happens on Average
Fifth graders are introduced to convergence of sequences based on averaging previous terms in the sequence. The power of the "fill-down" function in spreadsheets is exploited. By using various starting numbers, and inferring the limit,...
Curated OER
Using Computer for Statistical Analysis
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Curated OER
Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Curated OER
Scale Basketball
Young scholars discuss scale diagrams and maps as well as the use of spreadsheets to find the best scale to use in a model before practicing scale and ratio problems on their own.
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.