Lesson Plan
Curated OER

Data Analysis and Probability: Graphing Candy with Excel

For Teachers 5th - 8th
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
eBook
Open Oregon Educational Resources

Beginning Excel

For Students 9th - Higher Ed Standards
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

For Teachers 8th
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
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

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
PBL Pathways

Medical Insurance

For Students 10th - Higher Ed Standards
Design a plan for finding the best health insurance for your money. Learners compare two health plans by writing and graphing piecewise functions representing the plan rules. Using Excel software, they create a technical report...
Lesson Plan
Curated OER

The "U's" Have IT!

For Teachers 10th - 12th
Students explore the maximum and minimum values of parabola. In this exponential equations lesson, students use graphing calculators or TI Interactive Software to calculate values of parabola and graph x-intercepts of parabola.
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

Student Costs Data Table

For Teachers 5th - 7th
Learners compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
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...
Lesson Plan
Curated OER

USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION

For Teachers 6th - 12th
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th - 12th
Pupils explore and use different computer programs for collecting data. For this technology based lesson, students set up a survey and use the Excel and Lotus software to collect data.
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
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

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

Lunch Food? Mmmm! Mmmm! Good!

For Teachers 7th - 12th
Examine how nutrition plays an important role in our lives by conducting online research and developing lunch menus that satisfy nutritional requirements set up by the United States Department of Agriculture. Students download recipes,...
Lesson Plan
Curated OER

The Three Rock Groups

For Teachers 1st
Firts graders distinguish between sedimentary, igneous, and metamorphic rocks. They group the rocks into the appropriate group. This is one of the best-organized plans I've seen! Learners watch a PowerPoint presentation which is embedded...
Lesson Plan
Curated OER

Deep Blue Sea

For Teachers 3rd - 5th
Elementary schoolers identify the ocean floor in a geological sense. They create a presentation that highlights the key features of the ocean floor. This terrific lesson plan has excellent streaming video segments embedded in it, and the...
Lesson Plan
Curated OER

This Little Light of Mine

For Teachers 3rd - 5th
Elementary schoolers discover how electricity travels and create an electron flow through a closed circuit. They work together to make a closed circuit and observe the electricity being made. This outstanding lesson plan is well worth...
Lesson Plan
Curated OER

Be Sharp and Never Flat

For Teachers 2nd - 4th
An outstanding lesson plan on music awaits your young composers! They learn about patterns found in music, the different sections of an orchestra, and see the differences between musicians and a composer. Excellent streamed videos and...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis lesson students use an Excel spreadsheet to map their data. 
Activity
PBL Pathways

Students and Teachers 2

For Students 10th - Higher Ed Standards
Examine trends in student-to-teacher ratios over time. Building from the first task in the two-part series, classes now explore the pattern of student-to-teacher ratios using a non-linear function. After trying to connect the pattern to...
Lesson Plan
Curated OER

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Young scholars create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.