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.
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.
Curated OER
Phenomenal Weather-Related Statistics
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Curated OER
Box-and-Whisker Plots
Students explore nutritional information for several fast food hamburgers using statistical applications. In this statistics lesson, students analyze calories, fat, and sodium content of various fast food restaurants. Students also...
Curated OER
How Would You Spend a Million Dollars?
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
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
Geoboard Area
Students explore the basic geometric shapes and geometric shape vocabulary through the use of geoboards and virtual geoboards. They create a variety of shapes with a partner, build ten different rectangles on their geoboards, and...
Curated OER
Lobster Roll!
Students collect data by playing a game that illustrates the delicate ecological balance between fishing, fishing regulations and fish populations. They graph and analyze the data and explain how economic decisions can affect the...