Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Credit Cards: The Good, the Bad, and the ugly

For Teachers 10th - 12th
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson plan, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Learners create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Students examine and chart data about safety hazards and unsafe situations. For this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Activity
Howard Hughes Medical Institute

Measuring Biodiversity in Gorongosa

For Teachers 9th - 12th
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Lesson Plan
Polar Trec

Ozone Data Comparison over the South Pole

For Teachers 6th - 12th Standards
Did you know the hole in the ozone is seasonal and filled by January every year? The lesson uses scientific measurements of the ozone over the South Pole to understand patterns. Scholars learn that the hole grew bigger annually before...
Lesson Plan
1
1
Chicago Botanic Garden

Micro-GEEBITT Climate Activity

For Teachers 5th - 6th Standards
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Lesson Plan
Curated OER

Graphing Pendulum Results

For Teachers 6th
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Lesson Plan
Curated OER

Fitness plan: number 3

For Teachers 7th - 12th
Students monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This lesson...
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Young scholars explore spreadsheet software.  In this personal finance and computer technology lesson plan, students develop a vacation spreadsheet on the computer.  Young scholars represent hotel, food, transportation, and...
Lesson Plan
Curated OER

Where Will You Go?

For Teachers 5th
Fifth graders participate in a WebQuest in which they calculate mileage and cost per person for a trip to an amusement park. They explore various websites, and produce an Excel spreadsheet.
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
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

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

Zebra Mussel Population Simulation

For Teachers 9th - 12th
High schoolers 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

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

Back-To-School Shopping

For Teachers 5th
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
Lesson Plan
Curated OER

Daily Time Ratios

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

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...