+
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
+
Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Young scholars 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

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Young scholars, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
+
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  For this data analysis lesson students use an Excel spreadsheet to map their data. 
+
Lesson Plan
1
1
Curated OER

The Solstices

For Teachers 6th - 9th
Compare surface temperatures when the solstice occurs in the different hemispheres. Young scientists draw conclusions from their investigation of data collected using spreadsheets and a globe.
+
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
+
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
+
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Young scholars collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Young scholars answer statistical questions regarding the...
+
Lesson Plan
Curated OER

Creating Climographs

For Teachers 6th - 8th
Young scholars use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite instructional activity students create graphs and explain the differences between weather and climate. 
+
Lesson Plan
Curated OER

Drawing One and Two Playing Cards With Replacement

For Teachers 6th - 9th
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
+
Lesson Plan
Curated OER

All About Me: Measuring Height and Weight

For Teachers 2nd - 4th
Students take personal fitness inventories. In this personal health instructional activity, students take measurements of their heights and weights. Students record the data, calculate their BMI, and then chart their physical activity.
+
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Learners explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Learners utilize graphs and charts to analyze the results of the experiment and help...
+
Lesson Plan
Curated OER

GeoHunt

For Teachers 7th - 8th
Students describe the difference between geological resources and othe natural resources. They list the rocks, minerals, and fossil fuels that are found in Illinois and their uses. They identify ways to conserve natural resources.
+
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.