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
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Lesson Plan
Curated OER

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Lesson Plan
Curated OER

Class of 2000 - Student Loans

For Teachers 10th - 12th
Students determine how they will finance their postsecondary education. In this student loan lesson, students create spreadsheets that help them budget their first year of college. Students identify methods to fund the budgets and...
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Lesson Plan
Curated OER

How Much Is It?

For Teachers 6th - 8th
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Lesson Plan
Curated OER

First Class First? Using Data to Explore the Tragedy of the Titanic

For Teachers 9th - 12th
Students analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
1
1
Curated OER

What Makes Our Community Special?

For Teachers 3rd - 12th
Explore websites, complete research, and use technological tools to create a final multimedia presentation on what makes a community special. Learners of all ages work with a partner to research an interesting aspect of their community,...
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

Touring the Regions of the United States

For Teachers 5th
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
Lesson Plan
Curated OER

Holiday Flier in Publisher

For Teachers 2nd - 5th
Students use Publisher in this lesson to make a holiday flier. For this technology lesson, students create a holiday flier. Students choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash drive or...
Lesson Plan
Curated OER

History Trifold in Publisher

For Teachers 4th - 7th
Students create a timeline of events happening around the world. In this timeline lesson plan, students use Microsoft Publisher to create a timeline of events happening around the world as they live their lives presently.
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

E-mailing the Chamber of Commerce

For Teachers 9th - 12th
Encourage effective internet research and e-mail correspondence as scholars investigate a US capital city they've never visited to find pertinent and relevant information. They begin by picking a city, then visit that city's chamber of...
Lesson Plan
Curated OER

Hot, Wet, and Cold

For Teachers 7th - 9th
Students research climate data for a city in each of the 5 major geographic sections of Texas. They use data to describe the climate and what influence the geography of that section has on the weather.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

The Mayflower Compact

For Teachers 8th
Eighth graders investigate historical documents of the United States by reading the Mayflower Compact.  In this U.S. History lesson, 8th graders analyze the wording of the original Mayflower Compact of the first U.S. settlers and...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Population Growth Rates

For Teachers 10th - 12th
Students determine the average annual rate of change (growth rate) of U.S. national population for each decade of historical census data.
Lesson Plan
Curated OER

American Colonies

For Teachers 6th - 8th
Students record information in a database about the three American colonies. They are comparing and contrasting them. They are to log into a given database and fill in the corresponding sections. Once it is filled in the similiarities...