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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; 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
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
How Much Does That Car Cost?
Young scholars calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
101 Questions
Coins in a Circle
Round and round you'll go! Learners watch as different-sized circles fill with coins. They collect data and then make a prediction about the number of coins that will fit in a large circular rug.
Curated OER
Making a Spreadsheet
Students explore spreadsheet software. In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer. Students represent hotel, food, transportation, and entertainment costs...
Concord Consortium
Boards IV
Build a connection between algebraic sequences and spreadsheets. Learners examine a specific folding pattern and convert the pattern into a spreadsheet. The goal of the spreadsheet is to produce a sequence of a specific pattern modeled...
Concord Consortium
Boards III
Learn to visualize mathematical patterns as a folded pattern. Beginning with a visual display, the task encourages pupils to view sequences as a folded table. The pattern of the table then becomes a formula in a spreadsheet that...
Noyce Foundation
Ducklings
The class gets their mean and median all in a row with an assessment task that uses a population of ducklings to work with data displays and measures of central tendency. Pupils create a frequency chart and calculate the mean and median....
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
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
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.
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Curated OER
Build Your Dream Bedroom
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
PBL Pathways
Do Homework?
To complete homework or not to complete homework ... that is the question. Decide whether it makes a difference on finals by doing homework. Individuals create a scatter plot and find a line of best fit for data on the percent of...
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...
Intel
Composting: Why Bother?
The first STEM lesson in a group of 10 explores composting. After discussing how to make a better tomorrow, classes are challenged to track garbage in their communities, visit a local waste management facility, and conduct a survey...
Curated OER
A Line Graph of the Ocean Floor
Students develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph lesson, students develop a spreadsheet of ocean depths. They import the information into a word processed document. They...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra activity, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Alabama Learning Exchange
Find a Pattern Using Children's Literature
Sixth graders listen to Demi's, On Grain of Rice: A Mathematical Folktale. They use the problem solving strategy of finding a pattern to determine the number of rice Rani will receive after 30 days. They create a spreadsheet which...
Curated OER
Reading & Using a Nutrition Label
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Virginia Department of Education
The Rate of Motion
How much time does it take to jump over three balloons? Pupils calculate the speed of tasks that require different motions. They determine motions for tasks such as walking, skipping, hopping, and jumping before creating a...