Lesson Plan
Curated OER

Break Even Analysis and Budgeting

For Teachers 11th - Higher Ed
Learners analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
Lesson Plan
Curated OER

#4 School Survey

For Teachers 9th - 12th
Students, after brainstorming on health data, design a class or school survey on asthma. They collect, tabulate, and summarize the data. The data is placed on an Excel spreadsheet program. Upon completion, many demographic questions are...
Lesson Plan
Curated OER

May The Force Be With You

For Teachers 8th
Eighth graders investigate Newton's Laws of Motion. They use the example of a roller coaster for illustration purposes. A force associated with a roller coaster is tested, data graphed, and a conclusion is drawn. They use excel in order...
Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Young scholars calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Lesson Plan
Curated OER

Virtual Field Trip: Lodging and Meals

For Teachers 5th - 7th
Students calculate the costs for lodging and meals for a virtual field trip. They calculate the number of nights lodging needed for road and city travel and the number of meals needed, the costs for each, and input the data using...
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

Money Management

For Teachers 5th - 6th
Students explore money management skills and economics thru a creative project where students earn "money" for their assigned "jobs." They keep track of their income and expenses in a transaction record and explore the Excel money...
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

Chaucer's Characters in The General Prologue

For Teachers 12th
Twelfth graders explore the characters in The General Prologue. They describe the characters and their occupations and their lands of origin. Students organize the characters using Excel spreadsheets.
Lesson Plan
Curated OER

The Survey Says

For Teachers 8th - 12th
Learners experience the development of statistical data. In groups, they construct a survey questionnaire for a target audience. Students produce the questionnaire, distribute it, collect it, and tabulate the data. Using EXCEL, the...
Lesson Plan
Curated OER

Phiolosophy and Politics

For Teachers 7th - 9th
Young scholars study about Aristotle, Plato, and Socrates and how their role affected the Greek culture. They look at a video clip from Bill and Ted's Excellent Adventure and note similarities and differences from the movie and what is...
Lesson Plan
Alabama Learning Exchange

What's Your Favorite Chocolate Bar?

For Teachers 5th - 6th Standards
Students complete a math survey. In this math graphs lesson, students complete a survey about their favorite candy bars. Students create different kinds of graphs using Microsoft Excel to show their results.
Lesson Plan
Curated OER

Food Groups in our Lunch

For Teachers 3rd - 5th
Young scholars make a graph. In this food groups and graphing lesson, students pack a sack lunch and then work in groups to tally the number of foods from each food group that they have. Young scholars use the data collected to create a...
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th - 12th
Students explore and use different computer programs for collecting data. In this technology based instructional activity, students set up a survey and use the Excel and Lotus software to collect data.
Lesson Plan
Curated OER

Computer Olympics

For Teachers 2nd - 6th
Young scholars compete to achieve excellence in math facts, writing terms, problem solving, and writing skills on the computer. In this Computer Olympics lesson plan, students practice the skill of drill and practice in order to succeed...
Lesson Plan
Curated OER

Dancing Rainbows: A Pueblo Boy's Story

For Teachers 1st - 4th
Learners read the book "Dancing Rainbows," and complete a variety of activities across the curriculum. In this Native Americans lesson plan, students create pottery, discuss Pueblo traditions, discuss the importance of rain, and learn...
Lesson Plan
Illustrative Mathematics

Bike Race

For Teachers 7th - 9th Standards
A graph not only tells us who won the bike race, but also what happened during the race. Use this resource to help learners understand graphs. The commentary suggests waiting until the end of the year to introduce this topic, but why...
Lesson Plan
Curated OER

Excel Probability with Dice

For Teachers 4th - 6th
Students play a dice game to complete probability exercises. In this probability lesson, students collect data using a dice game and organize it into a spreadsheet format. Students also write a lab report for an experiment on probability.
Lesson Plan
Curated OER

Lesson Plan for C.S Lewis’ The Magician’s Nephew

For Teachers 4th - 5th
Here is a instructional activity that incorporates music writing, and reading literature. The class reads chapter eight from the C.S. Lewis classic The Magician's Nephew. Then, just like in the story, they use music as inspiration...
Lesson Plan
Curated OER

Concept Formation Lesson Plan: Understanding "Protest"

For Teachers 7th - 10th Standards
After analyzing both examples and non-examples of a variety of protests conducted by ethnic groups in Seattle and the state of Washington during the twentieth century, your class members will work to identify the key ideas and...
Lesson Plan
1
1
Smithsonian Institution

Art to Zoo: Life in the Promised Land: African-American Migrants in Northern Cities, 1916-1940

For Teachers 4th - 8th Standards
This is a fantastic resource designed for learners to envision what it was like for the three million African-Americans who migrated to urban industrial centers of the northern United States between 1910 and 1940. After reading a...
Lesson Plan
Historical Thinking Matters

Scopes Trial: 1 Day Lesson

For Teachers 7th - 12th Standards
Why did many Tennesseeans support the 1925 Butler Act, which forbade the teaching of evolution? Using several primary source documents and a brief video clip, your young historians will draw connections between the broader historical...
Lesson Plan
Historical Thinking Matters

Social Security: 1 Day Lesson

For Teachers 7th - 12th Standards
Should the United States provide relief for those who are unemployed? Trace this question back to the Great Depression with your young historians, who will engage in careful reading of historical documents and classroom discussion...
Lesson Plan
Historical Thinking Matters

Rosa Parks: 1 Day Lesson

For Teachers 7th - 12th Standards
You've heard of the historical moment when Rosa Parks refused to give up her seat on a bus, but did you know that some historical accounts disagree on where she sat? Investigate this query with your young historians, and practice...

Other popular searches