Hi, what do you want to do?
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
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...
Open Oregon Educational Resources
Beginning Excel
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,...
Curated OER
Multiplication Tables Using Microsoft Excel
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.
Curated OER
Shoe Showdown
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.
Curated OER
Using Excel To Teach Probability And Graphing
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...
PBL Pathways
Medical Insurance
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...
Curated OER
The "U's" Have IT!
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.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
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...
Curated OER
Student Costs Data Table
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.
Teach Engineering
Understanding the Air through Data Analysis
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...
Curated OER
USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION
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...
Curated OER
Embracing Diversity
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.
Curated OER
Using Excel to Draw a Best Fit Line
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...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
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.
Curated OER
Fish and Clips
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...
Curated OER
Lunch Food? Mmmm! Mmmm! Good!
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,...
Curated OER
The Three Rock Groups
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...
Curated OER
Deep Blue Sea
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...
Curated OER
This Little Light of Mine
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...
Curated OER
Be Sharp and Never Flat
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...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
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.
PBL Pathways
Students and Teachers 2
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...
Curated OER
Is the Rainbow Fair?
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....
Curated OER
Using a Spreadsheet
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.