Lesson Plan
Curated OER

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

For Teachers 5th - 12th
Students, 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

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

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

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. For this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Lesson Plan
Curated OER

Geography Fieldwork River Study

For Teachers 8th
Eighth graders collect, record, and analyze data from a local river and input the data into the computer. They collect and record the information, discuss the data collected, and enter the data into a spreadsheet and charts to compare...
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Lesson Plan
Curated OER

Plants Under Attack

For Teachers 3rd
Third graders will identify the four needs for plant survival and gain skills and confidence in using scientific measurement tools, probes as well as the spreadsheets and graphing capacity of a computer to represent and analyze data.They...
Lesson Plan
Curated OER

What Colors Are Your Skittles?

For Teachers 9th - 12th
High schoolers record the numbers of each color in their own Skittles. They compare their results with their partner. Students create a spreadsheet to chart the different colors found in a package of Skittles. They create a PowerPoint...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
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

Lobster Roll!

For Teachers 9th - 12th
Students collect data by playing a game that illustrates the delicate ecological balance between fishing, fishing regulations and fish populations. They graph and analyze the data and explain how economic decisions can affect the...
Lesson Plan
Curated OER

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

For Teachers 5th - 6th
Learners 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

Battery Power

For Teachers 6th
Sixth graders examine how much energy they use in the form of battery power. They examine the cost of using regular vs. rechargeable batteries and examine the effect on the environment of the two types of batteries. They discover that...
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

Western Hemisphere

For Teachers 4th
Fourth graders use a database to compare countries in the western hemisphere. They describe a variety of regions in Texas and the Western Hemisphere such as political, population, and economic regions that result from patterns of human...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Students spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.