Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
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

"Reality Math: Fact or Fiction"

For Teachers 6th - 8th
Pupils investigate the use of math in everyday life. They investigate several occupations and pay scales. They complete spreadsheets that show how monthly bills can be organized using technology. They use word processing software to...
Lesson Plan
Sea World

Endangered Species

For Teachers 4th - 8th
Study different endangered species with several activities that incorporate math, science, language arts, and research strategies. A great addition to your lesson on conservation or Earth Day.
Lesson Plan
Curated OER

Calculating Profits from Selling Virtual Lemonade

For Teachers 5th - 7th
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson plan, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider...
Lesson Plan
Curated OER

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Learners explore state populations. In this state geography lesson, students use a variety of technology tools to research and graph population and area of assigned states.
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.
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

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis instructional activity, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius...
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

Predicting Temperature: An Internet/Excel Learning Experience

For Teachers 3rd
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Virtual Field Trip: Lodging and Meals

For Teachers 5th - 7th
Learners calculate the costs for lodging and meals for a virtual field trip. They calculate the number of nights lodging needed for road and city travel and the number of meals needed, the costs for each, and input the data using...
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology lesson, students investigate the water quality in their community and compare their findings to the water quality in other geographic...
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 6th - 8th
Students read the sports section of the daily newspaper to find daily totals of what countries have won medals and find articles to keep in their journal (notebook) on the different events and athletes. They then create a spreadsheet to...
Lesson Plan
Curated OER

Enhancing Writing Through Technology

For Teachers 1st - 3rd
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
Lesson Plan
Curated OER

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard instructional activity, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet...
Activity
1
1
Teach Engineering

Live Like an Animal

For Teachers 6th - 8th Standards
When your parents say that your room's a pig sty, tell them about biomimicry. The sixth installment of a nine-part Life Science unit has scholars research the shelters used by animals in the natural world, like turtle shells. Using the...
Lesson Plan
National Wildlife Federation

Get Your Techno On

For Teachers 9th - 12th Standards
Desert regions are hotter for multiple reasons; the lack of vegetation causes the sun's heat to go straight into the surface and the lack of moisture means none of the heat is being transferred into evaporation. This concept, and other...