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
Graphing the Past Using Today's Technology
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
Curated OER
Code Crackers Math Game
Students, through this math game, are provided with opportunities to work with math operations and simple algebraic equations. They create a spreadsheet-based "rule machine."
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.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Back-To-School Shopping
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
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
Correlation of Variables by Graphing
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Curated OER
Yellow Pages Ad-dition
Students determine the revenue generated by sample pages from the Yellow Pages. They discuss the value of advertising a business in this venue. They use the local telephone directory and some fictitious ad rates to lead their inquiry.
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.
Alabama Learning Exchange
How Big Can a Bee Be?
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
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...
Space Awareness
Navigation in the Ancient Mediterranean and Beyond
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
Virginia Department of Education
Organizing Topic: Data Analysis
Learners engage in six activities to lead them through the process of conducting a thorough analysis of data. Pupils work with calculating standard deviations and z-scores, finding the area under a normal curve, and sampling techniques....
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
M&M Graphing
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
EngageNY
Sampling Variability in the Sample Mean (part 2)
Reduce variability for more accurate statistics. Through simulation, learners examine sample data and calculate a sample mean. They understand that increasing the number of samples creates results that are more representative of the...
Curated OER
Fruit Loop Graphing
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
Curated OER
The Egg Drop
High schoolers design and create a container that allows a raw egg to drop from the second floor of a building without breaking. They develop and compute an invoice for project expenses using spreadsheet software. Students role-play a...
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Curated OER
Discovering Pi
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Curated OER
What's the Scoop?: Our Favourite Ice Cream Flavours
Sixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a "Favorite Flavors" spreadsheet. Students graph and analyze the data.