Lesson Plan
Curated OER

Cloud Databases

For Teachers 7th - 9th
Students complete a unit on clouds and a report about one type of cloud. They collect data through observation about different types of cloud cover and then create a spreadsheet to reflect their observations over a 2 week period.
Lesson Plan
Curated OER

Computer Science: Temperature

For Teachers 9th - 10th
Students conduct an experiment on heat transfer and how it works. They record the temperature in whatever environment is surrounding the container and run experiments that use at least two different ambient temperatures. Students...
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
Lesson Plan
Curated OER

A "Capital" Idea

For Teachers 8th
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...
Lesson Plan
Curated OER

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
Lesson Plan
Curated OER

Accounting

For Teachers 10th - 11th
Students create bank reconciliation spreadsheet. In this algebra lesson, students discuss the basics about business, money and bank accounts. They use a bank reconciliation statement correctly.
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...
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

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

PowerPoint Presentation

For Teachers 4th - 6th
Students learn how to design and create a PowerPoint presentation that they then present to the class.
Lesson Plan
Curated OER

Political Issues Survey

For Teachers 5th
Fifth graders develop and conduct a survey regarding issues in a current political campaign. They distribute and collect the surveys, input the data using a spreadsheet program, and compare/contrast the recorded results.
Lesson Plan
Curated OER

When Dinosaurs Ruled the World

For Teachers 3rd - 4th
Students graph the varying sizes of dinosaurs.  In this math and dinosaur lesson plan, students view dinosaur models and compare the different shapes and sizes of the dinosaurs.  Students complete a dinosaur math activity, read...
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

There's No Accountin with Ledgers

For Teachers 10th
Tenth graders create and maintain a ledger, write an essay for the process, and learn to keep financial accounts through the ledger. In this ledger lesson, 10th graders define an accounting ledger and create one for the money they've...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Moving On Up!

For Teachers 7th - 9th
Students complete a game-like simulation to determine a career and salary. In groups, they collect information and decide what is the "best" city in which to live. They create a monthly budget for their "best" city based on salary from...
Lesson Plan
Curated OER

Kindergarten Money

For Teachers K
Students identify the various coins and their values through presentations, a rubric, a value pretest, and coin manipulatives. Money is incorporated into various activities whether at home or in school. Students create money webs using...
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

The Numbers Tell the Story

For Teachers 3rd - 9th
Students demonstrate how to gather and interpret statistical data. In this data analysis lesson, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts online...
Lesson Plan
Curated OER

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

For Teachers 4th - 9th
Young scholars 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 Effects of Light Intensity and Wavelength on the Rate of Photosynthesis

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

Students Analyze Data With Scatter Plots

For Teachers 4th - 8th
Scatter plot lessons can help students create different types of graphs by hand or with the aid of technology.

Other popular searches