Lesson Plan
Curated OER

Rise Over Run

For Teachers 9th - 12th
Students define the slope of the line, find the slope between any two points on the line, and allow them to name other areas where the slope is used. They explain why the slope is defined as the rise over the run.
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

Heat of an Unknown Metal

For Teachers 8th
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
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

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

Hero Research

For Teachers 9th - 12th
Students examine and research the idea of heroism. They watch and discuss a Powerpoint presentation, conduct research, and write a research paper about the qualities and characteristics of a hero.
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Lesson Plan
Curated OER

Visiting the Medical Fields

For Teachers 9th - 12th
Students act as medical pioneers to establish a clinic in an under served area.t They work in teams of two to complete a portfolio about their clinic and examine new treatments in various area of medicine.
Lesson Plan
Curated OER

How Quickly Disease Spreads

For Teachers 9th - 12th
Students demonstrate how quickly disease spreads and the importance of protective measures with communicable diseases. They examine past epidemics such as the Bubonic Plague and make predictions about future epidemics.They compare and...
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

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

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Learners improve data entry in a spreadsheet.
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

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

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

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

Battery Power

For Teachers 6th
Sixth graders examine how much energy they use in the form of battery power. They examine the cost of using regular vs. rechargeable batteries and examine the effect on the environment of the two types of batteries. They discover that...
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

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

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

Pythagorean Theorem Spreadsheet

For Teachers 6th - 8th
Studetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Young scholars work individual...
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

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...

Other popular searches