Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Young scholars examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating...
Lesson Plan
Curated OER

Geoboard Area

For Teachers 3rd - 6th
Students explore the basic geometric shapes and geometric shape vocabulary through the use of geoboards and virtual geoboards. They create a variety of shapes with a partner, build ten different rectangles on their geoboards, and...
Lesson Plan
Curated OER

Find Yourself with Global Positioning

For Teachers 9th - 12th
Students examine different types of new mapping technologies. They use the internet to gather information about mapping and navigation. They create their own global positioning tool and defend it to the class.
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

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
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

Pumped Up Gas Prices

For Teachers 3rd - 6th
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This activity is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
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.
Interactive
Curated OER

Elbow Room - Exploring Population Density

For Students 6th - 12th
In this population worksheet, students click on the links and research the internet about population, land, and government. Students answer 16 short answer questions including making spreadsheets.