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

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
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology instructional activity; 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...
Lesson Plan
Curated OER

How Much Does That Car Cost?

For Teachers 8th - 12th
Students 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 a...
Unit Plan
Intel

Composting: Why Bother?

For Teachers 8th - 10th Standards
The first STEM lesson in a group of 10 explores composting. After discussing how to make a better tomorrow, classes are challenged to track garbage in their communities, visit a local waste management facility, and conduct a survey...
Lesson Plan
Curated OER

A Line Graph of the Ocean Floor

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

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

Writing Fables

For Teachers 7th - Higher Ed
Students write their own fables. In this writing fables lesson, 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

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 lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
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

Creating a Newscast on the Cold War

For Teachers 5th - 7th
Students research the events of a specific year of the Cold War. In this Cold War lesson, students investigate the causes of the Cold War and highlight the events of a particular year.  Students create a...
Lesson Plan
Curated OER

Shared Birthdays

For Teachers 6th - 8th
Learners gather information on their classmates birthdays and create a spreadsheet with the dates. Using the internet, they find a famous person who shares their own birthday. They research the life of the famous person and develop a...
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Learners create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
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

Information Shuffle

For Teachers 7th - 10th
Gather some information, print it onto sentence strips, and then have your class physically shuffle the cards to better understand the importance of organizational patterns in writing. Middle school learners examine information for a...
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.
Unit Plan
Radford University

How Is Your Gender Represented?

For Teachers 9th - 12th Standards
Does the media shape people's views on gender? Scholars use data on gender portrayal in magazines to explore the idea. They use a spreadsheet program to create bar graphs and perform a chi-square test. They also use provided data to...
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.
Unit Plan
1
1
Curated OER

Build Your Dream Science Lab

For Teachers 6th - 8th Standards
Would your ideal science lab be filled with bubbling beakers and zapping Tesla coils? Or would it contain state-of-the-art computer technology and data analysis? Dream big with an innovative lesson that connects math and language...
Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
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...
Lesson Plan
Curated OER

How Tolerant Are Kids in Your School?

For Teachers 6th - 12th
Students graph results of a survey about attitudes and tolerance in their school. They discuss the social climate of their school. Students complete a questionnaire, and tabulate the raw data from their class. They create a bar graph...
Activity
Howard Hughes Medical Institute

Human Impacts on Biodiversity

For Teachers 6th - 12th Standards
Have you always wanted to take your science class on an amazing field trip they will never forget? Now you can! Observe the wildlife in an African savanna through trail cameras with a five-part data analysis activity. Learners analyze...