Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Embracing Diversity

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

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
Lesson Plan
Curated OER

Iterating the Function over Real Numbers

For Teachers 8th - 10th
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.
Lesson Plan
Curated OER

Power Metering Project

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

Finding Patterns with the Hundreds Chart

For Teachers 2nd - 3rd
Students review their numbers up to one hundred. Using a chart, they compare and predict patterns that might be in the numbers. They practice skip counting and grouping numbers. Using a spreadsheet, they graph different sets of numbers...
Lesson Plan
Curated OER

Canada Or Bust

For Teachers 7th
Seventh graders answer the following problem based lesson with the essential question, "Which city or town in Canada would adequately meet my family's needs for relocation?" They present their city and provide rationale for its...
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

Color Matters

For Teachers 6th - 8th
Middle schoolers create a spreadsheet to chart favorite colors, then collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Virtual Vacation

For Teachers 6th - 8th
Middle schoolers select a foreign city, research the city using the Internet, and plan an eleven-day vacation to that city. This lesson is ideal for a social studies classroom and includes ideas for using iMovie, Excel, and MS Works or...
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

Unemployment, NAIRU, and the Phillips Curve

For Teachers 12th - Higher Ed
Students participate in three different lessons. They analyze the relationship between fiscal expansion and short and long run consequences using the AS/AD framework. They organize appropriate data from a range of sources. They interpret...
Lesson Plan
2
2
Federal Reserve Bank

Creating a Budget

For Students 9th - 12th Standards
Learning to create and maintain a budget is an important life skill. Guide individuals in the discovery of their spending habits and how to track them. They then use what they learned to create a budget and make decisions on where they...
Lesson Plan
Curated OER

Numbers, Patterns, and Algebraic Thinking

For Teachers 5th
Fifth graders use spreadsheets.
Lesson Plan
Curated OER

Graph the Density of Fruit

For Teachers 5th
Fifth graders review the definition of mass and volume. They calculate and graph the density of various types of fruit while working in groups on a spreadsheet program. They look at how size of the fruit can be similar but the weight is...
Unit Plan
We are Teachers

What Goes Up Must Come Down

For Teachers 9th - 12th Standards
From understanding stock market performance and return on investment to identifying the costs and benefits of credit and avoiding debt problems, this is an absolute must-have resource for financial planning and literacy.
Lesson Plan
Curated OER

Favorite Food

For Teachers K
Students are given three choices of food. They then decide on their favorite and predict what the class's favorite food will be. After the teacher enters the data into the computer, students gather around the computer to view the...
Lesson Plan
Curated OER

Texas Weather Report

For Teachers 4th - 5th
Students use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Lesson Plan
Curated OER

Graphing Galore!

For Teachers K
Students practice sorting and counting different objects. Using this information, they create graphs on a worksheet given to them. They describe and analyze the results and discuss them as a class to end the lesson. They also complete...
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Students study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Students chart their results in an Excel document...
Lesson Plan
Curated OER

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
Lesson Plan
Curated OER

2D Kinematics w/ String Racers

For Teachers 11th - 12th
Students calculate the speed of string racers. In this physics lesson, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Lesson Plan
Curated OER

Social Demographics and Election Statistics

For Teachers 9th - 12th
Students identify the type of data contained in a spreadsheet. They manipulate a spreadsheet of presidential election returns. Students develop the skills to use the Microsoft Excel program.