Lesson Plan
Curated OER

The Game of Business

For Teachers 9th - 12th
Young scholars practice the economic concepts of scarcity and opportunity cost. They imagine creating their own businesses and brainstorm what they need to know in order to determine when the business is profitable.
Lesson Plan
Curated OER

Understanding Tone

For Teachers 8th
Eighth graders define tone and determine the tone of a particular passage making a web of tone words on Inspiration. They write a journal entry expressing how a piece of music makes them feel and create a PowerPoint to share.
Lesson Plan
Curated OER

Charting Seasonal Changes

For Teachers 6th - 10th
Students research the Earth's patterns of rotation and revolution, create a chart and graph of these patterns and use them to explain the causes of night and day and summer and winter.
Lesson Plan
Curated OER

Candy Bar Survey

For Teachers 2nd
Second graders investigate the skill of graphing data by using candy bars to create context for the instructional activity. They use technology for graphing and organizing information like a spreadsheet. The instructional activity...
Lesson Plan
Curated OER

Graphs and Spreadsheets

For Teachers K - 12th
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Lesson Plan
Curated OER

Colonialism in Africa

For Teachers 11th - 12th
Pupils examine Africa from a regional perspective. They appreciate the historic and geographic relationships that unite and divide the regions of Africa. Students create a comprehensive document outlining problems in the assigned region....
Lesson Plan
Curated OER

Get A Life

For Teachers 9th - 12th
Students explore choosing a career and living on a budget. They receive an alternative identity and must make choices and decisions based upon given situations. Students research possible solutions, and use spreadsheet technology to...
Lesson Plan
Curated OER

Gathering, Recording, and Presenting Data

For Teachers 6th
Sixth graders use the local newspaper to find and discuss examples of uses of statistics and the ways in which the information is presented. They create and represent their own set of data showing how students get to school each day.
Lesson Plan
Curated OER

Power Metering Project

For Teachers 9th - 12th
Young scholars collect and analyze variable data and understand the concept of electrical power.  In this energy lesson plan students use a spreadsheet to manage their data and create box plots. 
Lesson Plan
Curated OER

Stock Market Investment

For Teachers 6th - 8th
Students create a $100,000 stock portfolio by selecting stocks from a list of one hundred companies. They complete sell/buy orders, track their portfolio values through Yahoo Finance over an eight-week period, conduct Internet research...
Lesson Plan
Curated OER

Weather v. Climate

For Teachers 9th
Ninth graders discuss the differences between climate and weather as a class. Using data they collected, they create a graph of the data to share with the class over a specific time period. They compare and contrast this data with...
Lesson Plan
Curated OER

Education for Global Peace

For Teachers 7th - 8th
Students survey the class and graph the results. In this graphing and data collection lesson, students conduct a survey to see where their shirts were produced. Individuals use software to graph the results and create a written...
Lesson Plan
Curated OER

Getting Physical with Estuaries

For Teachers 9th - 12th
Young scholars study estuaries and how the physical factors change over time.  In this investigative activity students use a website to gain knowledge of estuaries then in groups they create and present their charts.
Lesson Plan
Curated OER

Compare 2-D Shapes

For Teachers 2nd
Second graders explore and analyze plane shapes. In this plane shapes instructional activity, 2nd graders evaluate shape attributes to classify shapes correctly. Students work in groups to create different shapes.
Lesson Plan
Curated OER

A Budget Can Help Young People Cut Their Spending

For Teachers 9th - 12th
Students explore the concept of budgeting. In this budgeting lesson, students read an article about how a budget helps young adults keep track of their spending. Students discuss financial issues that young adults have to deal with as...
Lesson Plan
Intel

Prototyping

For Teachers 6th - 10th
I need something to test. The three sessions in this lesson have individuals build and test a prototype of their design. The first two sessions are devoted to prepping for the prototype by drawing up specifications and materials. The...
Lesson Plan
Curated OER

Stock and Inventory

For Teachers 5th - 8th
Young scholars create databases. In this spreadsheet lesson, students take stock of their toys and create databases. Young scholars consider good business practices as they listen to guest speaker discuss how to control inventory.
Lesson Plan
Curated OER

Save Our Forests

For Teachers 5th
Fifth graders discuss the forest products industry and its affects upon their communities. They inventory the wood and paper products they consume and determine how it translates into the number of trees cut. Using a spreadsheet, they...
Lesson Plan
Curated OER

State Lottery Numbers

For Teachers 7th - Higher Ed
Students sort and graph numerical data using a spreadsheet.
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

The Transformer

For Teachers 4th
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length...
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.

Other popular searches