Lesson Plan
1
1
Curated OER

Paying Off Student Loans

For Teachers 9th - 12th
Students plan financing postsecondary education and explain how loan repayments work. They build a spreadsheet, listing the categories of expenses in the left hand column.
Lesson Plan
Curated OER

Formula for Fitness

For Teachers 7th - 10th
Many youngsters don't understand that fitness is a life-long endeavor, and that it really pays off to be healthy. Use a spreadsheet to document progress in a fitness plan to see if there really in a benefit to running and exercise. Adapt...
Lesson Plan
Curated OER

Shared Birthdays

For Teachers 6th - 8th
Students gather information on their classmates birthdays and create a spreadsheet with the dates. Using the internet, they find a famous person who shares their own birthday. They research the life of the famous person and develop a...
Lesson Plan
Curated OER

Team Apollo

For Teachers 7th
Seventh graders brainstorm about problems with a school track. They research different possibilities for a solution. They test different track materials with erosion, durability, abrasiveness and resiliency. They determine the area,...
Lesson Plan
Curated OER

Physical Fitness: Lesson number 2

For Teachers 7th - 12th
Students are assessed on the amount of improvement they make over a period of 6 weeks. They keep track of their improvement on an Excel spreadsheet so they can also see their improvement. This lesson focuses on leg and arm strength.
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 5th - 7th
Are we there yet?  Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
Lesson Plan
Curated OER

Hominid Traits: Ape to Man

For Teachers 12th
Twelfth graders collaborate and analyze information about our hominid lineage. They discuss evidence researched by anthropologists. Students use spreadsheet data to compare means of locomotion, diet and brain size.
Lesson Plan
Curated OER

Excel Lesson Plan Coin Statistics

For Teachers 2nd
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Lesson Plan
Curated OER

Make Your Health Count

For Teachers 4th - 6th
Students write down the meals they have eaten in the past few days and then research the calorie and fat content of at least 5 of the food items. They create a poster with the information they found and then put that information into a...
Lesson Plan
Curated OER

The Price is Right

For Teachers 7th - 12th
Students, through various activities, explore online databases. Using the internet, students explore the distributors websites. They collect specific information on selected products. An spreadsheet with price comparisons is developed....
Lesson Plan
Curated OER

Influence of Beauty, The Beauty of Influence

For Teachers 10th
Tenth graders explore the influence of art on modern societies. Through the internet, they assess paintings of advertisements for commercial products and social-political beliefs. Using spreadsheet software, the class compares and...
Lesson Plan
Curated OER

Zebra Mussel Population Simulation

For Teachers 9th - 12th
Pupils are taught how to format and enter data into an Excel spreadsheet. They make a graph, and interpret graphed data. Students discuss the possible impacts of zebra mussels on the Hudson river. They graph zebra mussel data.
Lesson Plan
Curated OER

Water Chestnut Graphing Activity

For Teachers 9th - 12th
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
Lesson Plan
Curated OER

Appalachia: Physical Fitness

For Teachers 6th - 8th
Students plan a family fitness outing. In this physical education lesson, students will research possible physical activities which might be completed by a family during a daily-long outing in the Appalachian area. Students will...
Lesson Plan
Curated OER

Managing a Checkbook

For Teachers 8th - 11th
How do grown ups do it? Teach your upper graders the ins and outs of personal finance by having them use their algebra skills to balance a checkbook. They examine the financial side of math, set up a checking account, and balance their...
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 3rd
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
Lesson Plan
Curated OER

Sorting

For Teachers 4th - 6th
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
Lesson Plan
Curated OER

Put Your Heart Into It

For Teachers 1st
First graders sort Valentine candies according to kind. Data is inserted into a spreadsheet and displayed in various graphic formats.
Lesson Plan
Curated OER

"Favorite Fairy Tale Characters"

For Teachers 3rd
Third graders enter the results of their survey on a spreadsheet. They construct a bar graph showing the results.
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Students access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

Spreadsheet Activity

For Teachers 7th - 8th
Young scholars create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
Lesson Plan
Curated OER

How is Your Driver Doing?

For Teachers 6th
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.

Other popular searches