Lesson Plan
Curated OER

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

For Teachers 7th - 12th
Learners improve data entry in a spreadsheet.
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

Class Birthday Graph

For Teachers 2nd - 3rd
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
Lesson Plan
Curated OER

What's the Scoop?: Our Favourite Ice Cream Flavours

For Teachers 6th
Sixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a "Favorite Flavors" spreadsheet. Students graph and analyze the data.
Lesson Plan
Curated OER

Writing Fables

For Teachers 7th - Higher Ed
Students write their own fables. In this writing fables activity, students use handheld computers to write a fable. The class designs a spreadsheet to organize common elements of fables. Students also edit each others' work.
Lesson Plan
Curated OER

Mythology Spreadsheet

For Teachers 4th - 8th
Learners read a large variety of myths and discuss the characters and their attributes found in mythology. Then they identify and learn to set up an appropriate spreadsheet program. Students also enter the data to the class spreadsheet...
Lesson Plan
Curated OER

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

For Teachers 6th - 8th
Middle schoolers 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...
Lesson Plan
Curated OER

Using a Spreadsheet to Understand Density

For Teachers 8th - 12th
Students use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
Lesson Plan
Curated OER

A Line Graph of the Ocean Floor

For Teachers 4th - 5th
Learners develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed...
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

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, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider weather...
Lesson Plan
Curated OER

Using a spreadsheet and the Internet to learn about stock market performance

For Teachers 9th - 12th
Students record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.
Lesson Plan
Curated OER

Shopping Around

For Teachers 3rd
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
Lesson Plan
Alabama Learning Exchange

How Big Can a Bee Be?

For Teachers 7th - 10th Standards
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
Lesson Plan
Curated OER

Historical Population Changes in the US

For Teachers 9th - 12th
Students conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their...
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
Lesson Plan
Curated OER

How Would You Spend a Million Dollars?

For Teachers 5th - 8th
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
Lesson Plan
Curated OER

Collect the Weather Lesson Plan

For Teachers 3rd - 8th
Students explore the weather. In this weather spreadsheet lesson, students keep track of weather patterns as they use instruments and resources to chart the data the collect in spreadsheet form.
Lesson Plan
Curated OER

Should Voting in the United States be Mandatory? Research Activity

For Teachers 8th
Eighth graders research how many voters actually vote in the U.S. and nine other nations. They create a spreadsheet using this information and write a persuasive essay.
Lesson Plan
Curated OER

Math: Football Fever Fun

For Teachers 5th - 8th
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
Lesson Plan
Curated OER

Spreadsheet Moon Comparison

For Teachers 4th - 6th
Students use the Internet to research characteristics of moons for other planets They use a spreadsheet to organize information for all of the moons researched. They use the spreadsheet data to make statements showing comparisons and...
Unit Plan
Radford University

Fibonacci is All Around

For Teachers 9th - 12th Standards
One ratio to rule them all. Young mathematicians investigate the Fibonacci sequence and the Golden Ratio. To begin the first lesson, they use a spreadsheet to see how the Fibonacci sequence gives the Golden Ratio. The second lesson...

Other popular searches