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

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

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

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

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

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

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

Thank You... Thomas Edison!

For Teachers 2nd - 3rd
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.
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
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

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

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

"How to Succeed as a Nontraditional Student"

For Teachers Higher Ed
Students create a one hour lesson plan on "How to Succeed as a Nontraditional Student." They brainstorm and research all the alternatives to becoming a "norm" student in today's society. They compile their research and findings into a...
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

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

Find Yourself with Global Positioning

For Teachers 9th - 12th
Students examine different types of new mapping technologies. They use the internet to gather information about mapping and navigation. They create their own global positioning tool and defend it to the class.
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

Giving'Em The Business

For Teachers 1st - 2nd
Students work in groups of 4-5 to form a business, create, market & sell their product, and track their expenses and profits. They experience the roles of producer, distributor, and consumer of goods. They collect, organize and...
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

Fire Safety Survey

For Teachers 3rd - 6th
Students collect data regarding fire safety and create a graph. Working in small groups, they administer a survey to family and friends regarding their attitudes toward fire safety. After data has been gathered, students graph their...
Interactive
Curated OER

Elbow Room - Exploring Population Density

For Students 6th - 12th
In this population worksheet, students click on the links and research the internet about population, land, and government. Students answer 16 short answer questions including making spreadsheets.
Lesson Plan
Curated OER

Making a Travel Brochure of a Louisiana Parish

For Teachers 7th - 10th
Although the attachments for this travel brochure project are no longer linked, you can still use the idea here and create your own assignment sheet and rubric. Learners choose a parish in Louisiana (or a city in your state) to research,...
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...