Curated OER
Iditarod
For this Iditarod worksheet, middle schoolers 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 instructional activity should be taught after students have mastered the laws...
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
Young scholars 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 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
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?
Pupils 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. Pupils 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
Students 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 instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Calculating & Graphing Using a Spreadsheet
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Curated OER
Thank You... Thomas Edison!
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.