+
Lesson Plan
Curated OER

Microsoft Excel Lesson Plan

For Teachers 5th
Fifth graders collect, organize, interpret data. In addition, they compare different textures, color including graphical representations such as bar graph, line graph .Students also describe the uses of rocks and how to use that to...
+
Lesson Plan
Curated OER

Mineral Matters

For Teachers 6th - 8th
Students work in a team to use the ProScope Digital USB Microscope and a computer to collect microscopic images from a variety of mineral specimens. They compare specimens and determine how they are alike and different by comparing their...
+
Lesson Plan
Curated OER

Graph and Compare the Adventure's Temperature Vs. Local Temperature

For Teachers 7th - 9th
Students explore the concept graphing data. In this graphing data lesson, students use weather data from their local weather and some other city and graph them. Students plot the local weather vs. another city. Students record...
+
Lesson Plan
Curated OER

Speed + Graphing = Winners!

For Teachers 5th
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
+
Lesson Plan
Curated OER

World Statistic Day

For Teachers 11th
Eleventh graders collect data about the state they live in. In this statistics lesson, 11th graders collect and analyze data as they compare themselves to students in other states. They analyze data about a person's education level, and...
+
Lesson Plan
Curated OER

Tall Tale Rollers

For Teachers 4th - 6th
Students explore American tall tales. In this tall tale lesson, students discover the six characteristics that are included in tall tales. Students survey their class to find each student's favorite tall tale character and organize the...
+
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

Fruit Loop Graphing

For Teachers 5th
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
+
Lesson Plan
Curated OER

School Lighting Audit

For Teachers 9th - 12th
Learners identify the data included in an energy audit. They perform an audit on the lighting in their school building. They complete a worksheet and discuss lighting issues with school staff.
+
Lesson Plan
Curated OER

Pika Chew

For Teachers 6th - 8th
Students work in collaborative teams with specific roles, use the Internet to research the behavior and ecology of pikas, make predictions about survival rates of pikas in different habitats and organize their data in graphs.
+
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

Banquet Menu Assessment: Exposure Investigation Exercise

For Teachers 9th - 12th
Learners identify sources of Food Borne illness and their prevention. They formulate hypotheses based on collected information. Pupils become aware of Nutrintional value of food. Students collected data are synthesized to formulate...
+
Lesson Plan
Curated OER

Paper Airplane Science

For Teachers 5th
Fifth graders recognize the need to follow the scientific method carefully and be aware of variables in experiments.  In this airplane lesson, 5th graders design and test an airplane, and complete a data sheet. Students retest five times...
+
Lesson Plan
Curated OER

Identifying My Spider

For Teachers 3rd
Third graders navigate the Internet and research spiders.  In this spider instructional activity, 3rd graders view photos of spiders and use their characteristics to determine the variety of spider.  Students complete a spider data sheet.
+
Lesson Plan
Curated OER

Count The Letters

For Teachers 6th - 9th
Students perform activities involving ratios, proportions and percents. Given a newspaper article, groups of students count the number of letters in a given area. They use calculators and data collected to construct a pie chart and bar...
+
Lesson Plan
Curated OER

SUNSPOTS SPOTTED

For Teachers 11th - 12th
Students study sunspots and their motion, from data gathered, they determine the significance of the sunspot data. The data be used to calculate the rotational period of the sun. They draw conclusions as to the sunspot's impact on the...
+
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
Mathematics TEKS Toolkit

Grade 6: Exploring c/d = pi

For Teachers 6th Standards
Introduce your math class to the perimeter of a circle. Teach them that pi describes the relationship between the circumference and the diameter. As a hands-on investigation, pairs or small groups use string to compare these two values...
+
Lesson Plan
Curated OER

Bernoulli's Principle

For Teachers 7th - 8th
Learners explore Bernoulli's principle, how it is related to flight, and the effect of lift, thrust, and drag on flight. They design and develop an experiment that tests for distance traveled by their paper airplane, and record and...
+
Lesson Plan
Curated OER

Range, Mean, Median and Mode Through the Internet

For Teachers 6th - 8th
Middle schoolers compute measures of central tendency.  In this range, mean, median and mode lesson, students gather information on the internet, organize the data and then compute the measures of central tendency.  They create a...
+
Lesson Plan
Curated OER

Food Classification

For Teachers 6th - 8th
Students are introduced to classification and some of the difficulties surrounding classification and how classification systems need to be able to adapt and how they may need to be changed when new information is discovered. They...
+
Lesson Plan
Curated OER

Box-and-Whisker Plots

For Teachers 8th
Eighth graders measure in feet and inches and convert to explore the relationship between the converted measurements. In this measurement lesson plan, 8th graders use the whisker and box plot to represent the measurement of a cat. ...
+
Lesson Plan
Curated OER

Cockroach Slope

For Teachers 10th - 11th
Students identify the slope of linear functions. In this slope lesson, students collect data and graph it. They write equations with no more than two variables and use technology to explain their data.
+
Lesson Plan
Curated OER

Creating an Enzyme-Substrate Model

For Teachers 9th - 12th
Students explore the reaction rates of an enzyme-mediated reaction through experimentation. In small groups, they use everyday objects to demonstrate the effects of environmental variables on enzyme function. Students graph and...