Lesson Plan
Curated OER

Think GREEN - Utilizing Renewable Solar Energy

For Teachers 7th - 12th
Young scholars use data to find the best renewable energy potential.  In this solar energy lesson students import data into Excel and explain how solar energy is beneficial. 
Lesson Plan
Polar Trec

Temperature Profile above the South Pole

For Teachers 5th - 8th Standards
Collecting and understanding data is a big part of understanding the world and how it changes. To better grasp what temperatures are changing and how they affect global populations, learners create a graph based on the date provided....
Lesson Plan
Curated OER

Shopping Around

For Teachers 3rd
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
Lesson Plan
Curated OER

Graphing Data from the Chemistry Laboratory

For Teachers 9th - 12th
Students graph and analyze data using a spreadsheet.
Lesson Plan
Curated OER

Sequences and Series

For Teachers 9th - 12th
Students use Excel Database to explore sequences and series. They examine how to calculate term positions and Sigma Notations. Students use Excel to calculate the values and they print the pages for grading.
Lesson Plan
Curated OER

Do You Measure Up?

For Teachers 4th - 5th
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
Lesson Plan
Curated OER

Curious Clouds

For Teachers 2nd
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Lesson Plan
Curated OER

States Of Matter

For Teachers 4th
Delv into the states of Matter. Students engage in the scientific inquiry process to uncover the exciting world of Matter. They watch a series of videos, and conduct experiments in order to collect and analyze data on the various state...
Lesson Plan
Curated OER

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Lesson Plan
Curated OER

Thinking Outside the Box

For Teachers 9th - 12th
Now this lesson sounds fun! High schoolers throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Students create graphs using collected data. In this algebra lesson plan, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Lesson Plan
Curated OER

Careers

For Teachers 8th
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Curated OER

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 6th - 8th
Students read the sports section of the daily newspaper to find daily totals of what countries have won medals and find articles to keep in their journal (notebook) on the different events and athletes. They then create a spreadsheet to...
Lesson Plan
Curated OER

Turn UP the Volume!

For Teachers 8th
Eighth graders find the surface area and volume of the figures and enter formulas into the spreadsheet to calculate surface area and volume for the given figures. They also find the volume and determine the shape which has the least...
Lesson Plan
Curated OER

Converge or Diverge?

For Teachers 11th - 12th
Students prepare for the calculus concepts of limits by examining sequences that converge and diverge. By using an Excel program that generates sequences, students manipulate the starting number, multiplier and add-on values, and examine...
Lesson Plan
Curated OER

Graphing Your Favorite Pizza Topping

For Teachers 5th
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Students explore the concept of cell phone plans. In this cell phone plan lesson, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
Lesson Plan
Curated OER

M & Ms in a Bag

For Teachers 3rd - 5th
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Lesson Plan
Curated OER

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Learners create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

Alzheimer's Disease

For Teachers 9th - 12th
Investigate Alzheimer's disease. Conduct research using a variety of resources, obtain information, and input the data into a Microsoft Excel spreadsheet. Identify trends in the data and categorize them for an audience.
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.