Lesson Plan
Curated OER

Statistics and Graphing with Accelerated Math

For Teachers 3rd - 7th
Young scholars create charts and graphs, using a spreadsheet program, of their results from their accelerated math lessons. Students discover how graphs can be used to interpret data in our everyday lives as well as how several...
Lesson Plan
Curated OER

Job Distribution After 1945

For Teachers 7th - 10th
Learners research job distribution in the U.S. after 1945. They study a spreadsheet of employment data and identify changes in the distribution of jobs in America since World War II. They create pie charts reflecting the data of jobs...
Lesson Plan
Curated OER

Learning About Graphics

For Teachers 4th - 6th
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
Lesson Plan
Curated OER

Demographic Changes in 19th Century England and Wales

For Teachers 7th - 12th
Students examine population in England and Wales during the period of 1801-1911. They calculate the percentage of population and how it changed from one census to the next in various towns. They record data on a spreadsheet and create...
Lesson Plan
Curated OER

Kindergarten Money

For Teachers K
Students identify the various coins and their values through presentations, a rubric, a value pretest, and coin manipulatives. Money is incorporated into various activities whether at home or in school. Students create money webs using...
Lesson Plan
Curated OER

Hollywood's Top Ten

For Teachers 6th - 12th
Students gather data on top 10 highest grossing movies, and make a bar graph and a pictogram.
Lesson Plan
Curated OER

Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School

For Teachers 4th - 9th
Students study practical data analysis within the constraints of the scientific method.  For this data lesson students collect and enter data into a computer spreadsheet then create graphs.
Lesson Plan
Curated OER

The Census

For Teachers 6th - 8th
Students analyze why the census is important and the benefits of it. Determine rights and responsibilities in real life situations. They are divided into groups and take a mock census of a list of teachers and students each. Results of...
Lesson Plan
Curated OER

China's Giant Panda

For Teachers 3rd
Third graders read an article called "All About Pandas." In this Panda lesson,  students become familiar with the connection of the Panda to Chinese culture.  Students recognize that Pandas are endangered. Students complete a...
Lesson Plan
Curated OER

The Earth Moves Under My Feet

For Teachers 6th - 8th
Students study earthquakes, monitor seismic activity using the Web, and plot real-time activity. They examine movement of the Earth's tectonic plates. They create an earthquake preparedness project.
Lesson Plan
Curated OER

It's Your Life

For Teachers 6th - 7th
Students make a multiple line graph showing income levels for each education level for the past 8 years and the number of people for each ethnic group and gender is compared within each education level.
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

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

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

The 400-acre wood

For Teachers 6th - 8th
In 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 map...
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
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

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

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Lesson Plan
Curated OER

Tell Me a Story

For Teachers 10th
Tenth graders read short story, "The Storyteller" by Saki, and expand on concept of stories for students by reading and evaluating several popular students's stories as well as writing their own original students's stories.
Lesson Plan
Curated OER

A Self Directed Inquiry into the Identification of Unknowns

For Teachers 9th - 12th
Students gain experience in designing an experiment and use logic in selecting specific tests for unknowns. Students recognize the use of spreadsheets in helping one to make clear comparisons.
Lesson Plan
Curated OER

What is for Sale and at What Price?

For Teachers 7th
Seventh graders will research information on products carried by a store (such as sporting goods, department, clothing, etc.) They will create purchase prices for the products they wish to carry. They also will decide what percentage...
Lesson Plan
Curated OER

Campaign 2000

For Teachers 5th - 9th
Students research newspapers and the Internet to learn about the election. Students work in groups and choose a state that they want to compare to Florida. Students organize the data they have found into a graph labeling an "x" and "y"...
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Young scholars create spreadsheets and bar graphs based on results of survey of favorite holidays.