Lesson Plan
Curated OER

Brick Memorial Flyer

For Teachers 7th - 8th
Students conduct research using the internet, school server and newspapers on the history of the brick memorial for veterans and its developmental process. They create and design a three column page layout for a brochure using Microsoft...
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Middle schoolers collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and...
Lesson Plan
Curated OER

Career Exploration

For Teachers 7th - 8th
Students complete a unit about career choices. They conduct research on a selected career that interests them, conduct an interview, explore various websites, create a five-page HyperStudio stack, and write ten checks that relate to...
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

Crispy Cookie Class Fundraiser

For Teachers 7th
Seventh graders see the relationship of math and the real world application by manufacturing a product for making a profit. They create a food product from a recipe, record their sales and analyze and report their gross profit.
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

Family Search We All Came To America

For Teachers 8th
Eighth graders participate in a computer based Family Search Unit. They use multimedia resources to research their country of origin, conduct interviews, and use software to produce narratives, databases, spreadsheets and graphs in this...
Lesson Plan
Curated OER

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
Lesson Plan
Curated OER

Unit Plan for Mark Twain and American Humor

For Teachers 10th - 11th
Students create brochures about the humor of Mark Twain. In this literature-analysis lesson plan, students read "The Celebrated Jumping Frog of Calaveras County" and other short stories by Twain. Students write analytical paragraphs and...
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

Baseball Relationships - Using Scatter Plots

For Teachers 6th - 10th
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Lesson Plan
Curated OER

Modeling Mitosis and Meiosis

For Teachers 9th - 12th
Students construct and manipulate models of mitosis and meiosis and compare/contrast them. They create the models using index cards and yarn, interpret diagrams and photographs, and summarize written descriptions.
Lesson Plan
Curated OER

Fire Safety Survey

For Teachers 3rd - 6th
Students collect data regarding fire safety and create a graph. Working in small groups, they administer a survey to family and friends regarding their attitudes toward fire safety. After data has been gathered, students graph their...
Lesson Plan
Curated OER

A Holiday Card in KidPix

For Teachers K - 3rd
Students create a holiday card using computer software.  In this computer card making lesson, students design an original holiday card using a variety of tools.  Students navigate the software utilizing various tools.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Lesson Plan
Curated OER

Lesson 14: Genetic Disorders

For Teachers 9th - 10th
Students create PowerPoint presentation on the topic they researched. In this biology lesson, students fill out a storyboard about their topic. They share their project in class.
Lesson Plan
Curated OER

DNA Technology

For Teachers 9th - 10th
Students prepare PowerPoint presentation on DNA and cells. In this biology lesson, students create a storyboard of their presentation. They share the finished project in class. 
Lesson Plan
Curated OER

Making a Travel Brochure of a Louisiana Parish

For Teachers 7th - 10th
Although the attachments for this travel brochure project are no longer linked, you can still use the idea here and create your own assignment sheet and rubric. Learners choose a parish in Louisiana (or a city in your state) to research,...
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

Graphing With a Spreadsheet

For Teachers 4th
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

Pedestrian Safety for Students Lesson 4: A Walkable Survey

For Teachers 4th - 5th
Students create a survey. In this survey lesson, students use www.walktoschool.org to help them come up with questions to ask other students. They put the information in spreadsheet format.