Lesson Plan
Curated OER

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

For Teachers 6th - 8th
Learners 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

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

Triangle Midsegment

For Teachers 9th - 12th Standards
Learn how to calculate the length and midsegments of triangles. Learners differentiate between similar and congruent triangles. They create a spreadsheet with their findings.
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Graphing the Past Using Today's Technology

For Teachers 8th
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
Lesson Plan
Curated OER

Download and Analyze

For Teachers 3rd - 9th
Students download information from a NASA website into a database. They transfer it to a spreadsheet by completing the information and analyze the information. They determine temperature averages, mode, and graph the results. They write...
Lesson Plan
Curated OER

What's Our Department Budget?

For Teachers 9th - 12th
Analyze the influence of culture, media, technology, and other factors on health and examine a hospital budget. Learners will create a budget for a hospital taking in account factors such as staff and departmental needs and necessary...
Lesson Plan
Curated OER

How Much Does That Car Cost?

For Teachers 8th - 12th
Young scholars calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create...
Lesson Plan
Curated OER

Supply and Demand

For Teachers 9th - 12th
Students define economic terms, list three conditions that must be present in order for demand to exist, define law of supply and demand, differentiate between buyer's and seller's markets, examine concept of elasticity, view tutorial on...
Lesson Plan
Curated OER

Bingo!

For Teachers 1st
First graders practice and reinforce phonics and/or math skills by creating Bingo! game using computer spreadsheet. Students incorporate phonics or math skills class has been practicing onto Bingo! cards, which can be printed and made...
Lesson Plan
Curated OER

Backyard Birds: Who's Who Out There?

For Teachers 3rd - 4th
Students practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects of...
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 10th - 12th Standards
Learners find common ratios of geometric sequences on a spreadsheet. Using this data, they create scatter plots of the sequences to determine how each curve is related to the value of the common ratio. They will consider whether series...
Lesson Plan
Curated OER

The Effects of Light Intensity and Wavelength on the Rate of Photosynthesis

For Teachers 9th - 12th
Learners use an on line website to simulate the effects of light intensity and wavelength on photosynthesis. In this photosynthesis lesson plan, students determine how wavelength of light and intensity of light affect the rate at which...
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson plan, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Why Would I Owe My Soul to the Company Store?

For Teachers 6th
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics activity, 6th graders determine what a miner's income was minus his expenses graphing findings in...
Lesson Plan
Curated OER

Data Analysis: Infiltration Rate and Composition of Concrete

For Teachers 9th - 11th
Students collect and graph data. In this statistics lesson, students analyze data using a spreadsheet program. They display their data effectively and analyze it.
Lesson Plan
Curated OER

Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School

For Teachers 4th - 9th
Students study practical data analysis within the constraints of the scientific method.  For this data lesson students collect and enter data into a computer spreadsheet then create graphs.
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

The Statistics of Shoes

For Teachers 7th - 10th
Students open a blank spreadsheet and format it for a class survey about the number of shoes owned by the men and women in the class. They enter the data before finding the mean, median, mode, quartiles, variance, and the standard...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....

Other popular searches