Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. For this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day....
Lesson Plan
Curated OER

Create and Analyze Rectangular Patterns

For Teachers 6th - 8th
Students explore the concept of geometric patterns. In this geometric pattern instructional activity, students use Microsoft Excel to explore geometric patterns. Students analyze growth rates of pattern growth. Students create their...
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Middle schoolers examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in...
Lesson Plan
Curated OER

Ict Activity 22

For Teachers 6th - 8th
Students use Excel to solve quadratic equations by trial and improvement. They enter formulas and try different solutions to improve their solutions more quickly. Afterwards, they report the solutions to different levels of accuracy.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Lesson Plan
Curated OER

Candy is Dandy

For Teachers 6th - 9th
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Lesson Plan
Curated OER

Don't Trash the Earth

For Teachers 6th - 8th
Middle schoolers experience a hands-on environmental science project. They access about recycling as they collect data on their own family's trash production. Students analyze the data with worksheets, chart the data, and present their...
Lesson Plan
National Council of Teachers of Mathematics

National Debt and Wars

For Teachers 9th - 12th Standards
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
Lesson Plan
Curated OER

Weights and Measures

For Teachers 6th - 8th
Students master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.
Lesson Plan
Curated OER

Beisbol! Latino Baseball Pioneers and Legends

For Teachers 1st - 6th
Students explore Latin America by researching the favorite past time, baseball. In this Latin culture instructional activity, students identify the leaders in the Latin American baseball movement such as Felipe Alou, Jose Mendze, and the...