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
Learners determine how they will finance their postsecondary education. In this student loan activity, students create spreadsheets that help them budget their first year of college. Learners 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
Middle schoolers explore foreign currencies. For this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Middle schoolers use a conversion table...
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Learners 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 identify the...
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
Learners create brochures on subjects they are studying in Publisher. In this nonfiction writing lesson, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Learners use text boxes, fonts...
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
Learners use Publisher in this lesson plan to make a holiday flier. In this technology lesson plan, students create a holiday flier. Learners choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash...
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 activity, 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
Pupils 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

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...
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.