Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Historical Pollution in the Hudson: Part 2

For Teachers 9th
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Learners, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Chart Challenge: Behavior Management

For Teachers 3rd - 4th
Students develop a behavior management plan using Excel. They use the computer to develop a behavior chart. Students record their behavior on a daily basis using the chart they developed using Excel.
Lesson Plan
Curated OER

How Big Is Your Head?

For Teachers 4th - 5th
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Lesson Plan
NOAA

Mapping the Deep-Ocean Floor

For Teachers 7th - 8th
How do you create a map of the ocean floor without getting wet? Middle school oceanographers discover the process of bathymetric mapping in the third installment in a five-part series of lessons designed for seventh and eighth graders....
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Activity
2
2
Teach Engineering

Using Hooke's Law to Understand Materials

For Teachers 10th - 12th Standards
Provide a Hooke for a lesson on elasticity with an activity that has groups investigate a set of springs. They use a set procedure to collect data to calculate the spring constant for each spring using Hooke's Law. The groups...
Activity
Teach Engineering

Applying Statistics to Nano-Circuit Dimensions in Fabrication

For Students 11th - 12th Standards
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Activity
Teach Engineering

Energy Perspectives

For Teachers 8th - 10th Standards
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Activity
Howard Hughes Medical Institute

Gorongosa: Scientific Inquiry and Data Analysis

For Teachers 9th - 12th Standards
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
Lesson Plan
Curated OER

Black Tiger Academy Martial Arts Fitness Unit – Lesson 12

For Teachers 3rd - 6th
“We are what we repeatedly do. Excellence therefore is not an act, it is a habit.”—Aristotle. Black Tiger Academy’s martial arts instructional activity 12 of 20 introduces the class to the amount of sugar contained in a variety of foods...
Lesson Plan
Armory Center for the Arts

Place Value Collage

For Teachers 3rd Standards
How can art represent math? Use a lesson on place value collages to illustrate the different meanings that numbers have in their designated places. Kids observe photographs and paintings that show place value, then work on their own.
Lesson Plan
Curated OER

Data Displays with Excel

For Teachers 8th - 10th
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Microsoft Office Excel

For Teachers 6th - 8th
Learners use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs. 
Lesson Plan
National Wildlife Federation

I’ve Got the POWER Wind Energy Potential at Your School

For Teachers 9th - 12th Standards
The 20th lesson in a 21-part series connects the wind data and expectations of a turbine to whether such devices should be built in your area. Scholars begin with estimating the wind potential at school by using long-term climate...
Lesson Plan
Curated OER

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Activity
1
1
Teach Engineering

Understanding the Air through Data Analysis

For Teachers 9th - 12th Standards
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...