Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Two-Variable Linear Inequalities

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

Population Growth Rates

For Teachers 10th - 12th
Students determine the average annual rate of change (growth rate) of U.S. national population for each decade of historical census data.
Lesson Plan
Curated OER

American Colonies

For Teachers 6th - 8th
Students record information in a database about the three American colonies. They are comparing and contrasting them. They are to log into a given database and fill in the corresponding sections. Once it is filled in the similiarities...
Lesson Plan
Curated OER

Nascar Unit Activity 2

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

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Lesson Plan
Curated OER

Language Arts: A "Perfect" Lesson

For Teachers 3rd - 4th
Pupils read "Be A Perfect Person in Just three days," and participate in a host of activities. Connected to technology, they use online sources to create word searches and puzzles from vocabulary words. In addition, students create...
Lesson Plan
Curated OER

Texas Weather Report

For Teachers 4th - 5th
Young scholars use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Lesson Plan
Curated OER

Baseball Statistics

For Teachers 7th - 8th
Students read "Casey at the Bat" and then use individual player statistics (found through internet research)to determine if their players could be considered baseball "heroes". They must justify their choices for "hero" by creating...
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

Exploring Careers

For Teachers 7th
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.
Lesson Plan
Alabama Learning Exchange

Watch That Plant Grow

For Teachers 6th - 8th
Middle schoolers examine the growth of marigolds in a greenhouse environment. They chart data in spreadsheets showing plant growth over time and under a number of conditions. They record measures of plant height and greenhouse temperature.
Lesson Plan
Curated OER

Ecological Footprint

For Teachers 8th
Eighth graders discover their own ecological footprint and create a plan for reducing this figure. They extend this to the school and community to see how they are doing on this scale. They discuss the concept of the ecological...
Lesson Plan
Curated OER

Backyard Birds: Who's Who Out There?

For Teachers 3rd - 4th
Young scholars practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects...
Lesson Plan
Curated OER

Giving'Em The Business

For Teachers 1st - 2nd
Students work in groups of 4-5 to form a business, create, market & sell their product, and track their expenses and profits. They experience the roles of producer, distributor, and consumer of goods. They collect, organize and...
Lesson Plan
Curated OER

Have Fun With Technical Report Writing

For Teachers 9th - 12th
Students use Clarisworks Word Processing and Spreadsheet, Quick-Take Camera and Software, and produce a publishable technical paper.
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Students use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Western Hemisphere

For Teachers 4th
Fourth graders use a database to compare countries in the western hemisphere. They describe a variety of regions in Texas and the Western Hemisphere such as political, population, and economic regions that result from patterns of human...
Lesson Plan
Curated OER

Wildlife Sampling

For Teachers 7th
Seventh graders use paper bags and crackers to simulate a wildlife sampling of salmon. They record data on spreadsheets and determine a formula to estimate salmon populations.
Lesson Plan
2
2
Federal Reserve Bank

Expense Tracking

For Students 9th - 12th Standards
Where does all your money go? Individuals keep a record of the money they spend over the course of 30 days. They then categorize where they are spending their money and write an essay detailing their findings.
Lesson Plan
EngageNY

Normal Distributions (part 2)

For Students 10th - 12th Standards
From z-scores to probability. Learners put together the concepts from the previous lessons to determine the probability of a given range of outcomes. They make predictions and interpret them in the context of the problem.
Activity
Education Development Center

Interpreting Statistical Measures—Class Scores

For Students 9th - 12th Standards
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...