Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Curated OER

Is Global Warming Happening?

For Teachers 6th - 8th
Students investigate the probability of global warming and the effects of global warming on the environment. They conduct Internet research and collect data, transfer the data onto an Excel spreadsheet, and create a presentation that...
Lesson Plan
Curated OER

Remembering Our Veterans

For Teachers 8th
Eighth graders research a variety of military statistics while using the theme of Remebering Our Veterans. They use data management to plan and create a PowerPoint presentation with their findings. They incorporate different types of...
Lesson Plan
Curated OER

Let's Measure

For Teachers 2nd - 5th
Students learn how to measure length using inch units.  In this measurement lesson, students use two different units of measure to measure the length of a Leopard Shark and then use pattern blocks to measure its length. ...
Lesson Plan
Curated OER

Examine Your State Government's Demographics

For Teachers 8th - 11th
How is your state government organized? How many elected officials are women? What is the mean age of your state representatives? Young scholars answer these questions in a research project before creating a chart to reflect their...
Lesson Plan
Curated OER

My Community

For Teachers 1st
First graders design a Powerpoint presentation to reflect information about their community.  In this community lesson, 1st graders create slides to explain the weather, geography and other information about the city.
Lesson Plan
Curated OER

College Costs are on the Rise

For Teachers 9th - 12th
Students examine college costs in different states. In this college cost lesson, students create a table and determine the average cost of college for the states listed. They organize the data into measurement categories. Students create...
Lesson Plan
Curated OER

Employee Payroll Simulation

For Teachers 9th - 12th
Students simulate creating and calculating employees payrolls using hourly wages, deductions, and proper taxes.
Lesson Plan
Alabama Learning Exchange

Who Sank the Boat?

For Teachers 5th
Fifth graders experiment with student-made aluminum boats to test for buoyancy. They design a boat and determine how many marbles it takes to sink it while recording their data in a spreadsheet. They design a graph using the data and...
Lesson Plan
Curated OER

Giant Mystery

For Teachers 3rd
Third graders determine the relationship between hand size and body size using centimeters as the unit of measure, They use the relationship to find the size of a hypothetical giant. They graph the measurements using a spreadsheet program.
Lesson Plan
Curated OER

Zoo Poo

For Teachers 10th - 12th
Students use Internet research to determine the amount of carbon dioxide produced per unit energy for biomass and coal. In this alternative energy lesson, students research to find out how much energy and carbon dioxide several coal and...
Lesson Plan
Curated OER

Atlatl Lessons Grades 4-12: Lesson for Beginning Users of Atlatl

For Teachers 6th
Sixth graders determine the mean, range median and mode of a set of numbers and display them. In this data lesson students form a set of data and use computer spreadsheet to display the information. They extend of the process by...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.
Lesson Plan
Curated OER

The 400-acre wood

For Teachers 6th - 8th
For this forest planning lesson plan, students visit the 400-acre wood website and work in groups to learn about the specific aspects of forest development. Students create, label and color a forest planning map and present their...
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Using Tables to Solve Linear Functions

For Teachers 9th - 12th Standards
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...
Lesson Plan
Curated OER

Credit Card Danger and Abuse

For Teachers 9th - 11th
Students, utilizing the computer, excel and internet, study all the downfalls of consumer debts and the complications that come with them. They assess a spreadsheet to graph their data and then present their graphs to their classmates.
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Lesson Plan
Code.org

Discover a Data Story

For Teachers 9th - 12th
"Data is so boring, there's no way to find any patterns in them."  Or is there? Pairs investigate data sets using different data visualization tools to discover a trend that may exist in a data set. Once they find a trend or...
Lesson Plan
Curated OER

Fabulous Fossils

For Teachers 7th
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

Butterflies in the Garden

For Teachers 4th - 6th
Learners estimate the population of a butterfly ecosystem and create a chart and graph based on information they find.
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.

Other popular searches