Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
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

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

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
Curated OER

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

For Teachers 6th - 8th
Students 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 examine any...
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
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 lesson, 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

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

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

A Financial Flower Garden

For Teachers 4th - 6th
Here is another in the interesting series of lessons that use the special State Quarters as a learning tool. This one uses the Mississippi State Quarter. During this lesson, pupils learn about the variety of state flowers that represent...
Lesson Plan
Curated OER

Get My Point!

For Teachers 3rd - 7th
Here is one of the better lessons I've come across on how to teach fractions and decimals. This lesson does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent websites, printable...
Lesson Plan
Curated OER

Making Money and Spreading the Flu!

For Teachers 9th - 11th Standards
Paper folding, flu spreading in a school, bacteria growth, and continuously compounded interest all provide excellent models to study exponential functions. This is a comprehensive resource that looks at many different aspects of...
Lesson Plan
Curated OER

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

For Teachers 5th - 12th
Students, 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

World of the Pond

For Teachers 5th - 8th
Field trip! The class will review what they know about organisms that dwell in freshwater ponds, then trek down to the old water hole to collect specimens for examination. This includes several web links, useful tips, and an excellent...
Lesson Plan
Curated OER

I Can Build It.....Yes I Can!

For Teachers K
Kindergartners listen to a story read by their teacher, then use magnetic shape pieces to construct simple designes. They "build" their own house using pre-cut paper shapes. This age-appropriate lesson would be an excellent choice for...
Lesson Plan
Curated OER

Tens! Hundreds! Thousands!!! of Tons

For Teachers 5th
Fifth graders take a close look at the types of ships that travel through the Hudson River Valley on the Hudson River. They utilize worksheets embedded in the plan in order to answer questions about exactly what is being shipped, and how...
Lesson Plan
Statistics Education Web

NFL Quarterback Salaries

For Students 9th - 12th Standards
Use statistics to decide if NFL quarterbacks earn their salaries! Learners study correlation coefficients after using technology to calculate regression equations. Through the data, they learn the meaning of correlation and correlation...
Lesson Plan
Curated OER

Nascar Unit Activity 2

For Teachers 8th
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Graphing Pendulum Results

For Teachers 6th
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Lesson Plan
Curated OER

How Long...?

For Teachers 3rd - 5th
Students explore measurement. They use appropriate units of measurement for different sized objects. Students collect their data and enter it into an Excel data base. They graph their findings and analyze their outcomes.
Lesson Plan
Curated OER

Band Tour Across America

For Teachers 8th - 10th
Learners plan the trip of a band across America. In this money planning lesson, students create a budget for the band using excel basic functions. They manage the band and its budget and relate the tour to future budgeting needs of the...