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.
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

For Students 9th - 12th
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
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, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

The Disappearing Kelp Forest

For Teachers 6th - 9th Standards
Learners observe the effect "El Nino" left on kelp plants and sea urchins. They analyze the data collected by researchers, by graphing it on a TI calculator. Before graphing and analyzing the data, you may want to revisit the events of...
Lesson Plan
Curated OER

Podcasting Parabolas

For Teachers 8th - 12th
Students explore parabolas.  In this algebra and technology lesson, students construct the equation of a specific parabola, then take digital photos of real-life representations of these parabolas.  Students create a podcast...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
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

Twelve Days of Christmas

For Teachers 6th - 8th
Young scholars create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
Lesson Plan
Curated OER

Marvelous Mathematics

For Teachers 4th - 6th
Students make a table on the computer, but create fractions and equivalent fractions through the use of color. They are able to manipulate fractions in order to gain a greater understanding of the meaning of whole number that is broken...
Lesson Plan
Curated OER

Music Favorites and Place Value

For Teachers 4th
Fourth graders view CD ads and create a chart about an imaginary CD purchase.  In this CD lesson, 4th graders calculate various cost connected with the CD's at the regular price and on sale. Students write a paragraph about the...
Lesson Plan
Curated OER

The Stoichiometry Behind Pollution

For Teachers 9th - 12th
Young scholars research car emissions of various cars and find the toxins emitted.  In this stoichiometry lesson, students calculate the relationship between reactants and products in a chemical reaction. Young scholars collect data...
Lesson Plan
Curated OER

I'm Out of Here

For Teachers 4th - 6th
Students create a travel budget. In this budget lesson, students research vacation destinations. Working independently, students research destinations on the Internet and construct a budget for the vacation.  Resources provided.
Lesson Plan
Curated OER

Comparing Temperatures in Different Cities

For Teachers 6th - 12th
Students generate a spreadsheet to calculate average daily temperature. They create graphs from spreadsheet data and comprehend the components of the a spreadsheet.
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Lesson Plan
Curated OER

CEEN Power

For Teachers 7th - 12th
Students identify the different types of measurements used in industry. In this technology lesson, students investigate how much power CEENBoT has. They collect data and graph results.
Lesson Plan
Curated OER

Historical Mathematicians Project

For Teachers 5th - 12th
Students, in small groups, use the Internet and other traditional sources to research historically significant mathematicians, write a paper, and creatively present research in class.
Lesson Plan
Curated OER

The Hot Dog Stand

For Teachers 6th - 8th
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Lesson Plan
Curated OER

Baseball Stats

For Teachers 6th - 8th
Students explore data sheets and statistics in baseball. They use baseball data available on the Internet to develop an understanding of the different ways in which data can be analyzed.
Lesson Plan
Curated OER

Surfing Amusement parks

For Teachers 4th - 7th
Students must surf the Internet to find out how much it cost for his or her family to go to amusement parks in California.
Lesson Plan
Curated OER

Seaside Science

For Teachers 3rd - 12th
Students research sea life using laptop computers. In this sea life lesson, students participate in a field trip to the beach and enter observations into their laptop computers. Students classify shells and sea life.
Lesson Plan
Curated OER

Probability and Geometry

For Teachers 4th - 5th
Learners examine the relationship between probability and geometry to solve problems. In this geometry and probability lesson, students investigate the effect of changing percentages on a spinner to the probability of landing on a...
Lesson Plan
Curated OER

Friction Fanatics

For Teachers 9th - 12th
Student and compare the three types of friction. In this physics lesson plan, students determine the coefficient of friction using the CEENBoT. They investigate how friction changes as the angle of the incline changes.

Other popular searches