Lesson Plan
Curated OER

Forces of Flight - Lift

For Teachers 3rd - 8th
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson is excellent for use with upper-elementary and middle-level learners and uses spreadsheet software...
Lesson Plan
Curated OER

Build Your Dream Bedroom

For Teachers 7th Standards
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Learners construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Learners familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Lesson Plan
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Lesson Plan
Curated OER

Circles and Stars

For Teachers 3rd - 4th
Students solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
Lesson Plan
Curated OER

Using Fractions to Represent M&M Colors

For Teachers 9th - 11th
Young scholars investigate the concept of fraction and tangible application. In this algebra instructional activity, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the...
Lesson Plan
Curated OER

Math Lesson: What Do You Want to Know? - Country Statistics

For Teachers 9th - 12th
Students are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing the...
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

Hominid Traits: Ape to Man

For Teachers 12th
Twelfth graders collaborate and analyze information about our hominid lineage. They discuss evidence researched by anthropologists. Students use spreadsheet data to compare means of locomotion, diet and brain size.
Lesson Plan
Curated OER

Make Your Health Count

For Teachers 4th - 6th
Pupils write down the meals they have eaten in the past few days and then research the calorie and fat content of at least 5 of the food items. They create a poster with the information they found and then put that information into a...
Lesson Plan
Curated OER

Predicting Monthly Precipitation

For Teachers 8th - 12th
Students should log onto, and collect data from, a specific site on the Internet. They average and compare the data using the Excel spreadsheet program, make predictions from their data, and determine the percent error of their predictions.
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Defining Moments-from the past with lessons for a post 9/11 world

For Teachers 9th - 12th
Students use the spreadsheet to determine policy options, establish criteria for the solution, weight the criteria in terms of importance and rate the options relative to each criterion to determine a solution to the problem. They...
Lesson Plan
Curated OER

Global Warming Statistics

For Teachers 6th - 9th
Students research and collect data regarding temperature changes for a specific location and find the mean, median, and mode for their data. In this climate change lesson, students choose a location to research and collect data regarding...
Lesson Plan
Curated OER

Deric's Blotto

For Teachers 9th - 10th
Students solve the handshake problem and investigate triangular numbers. In this geometry lesson, students investigate Blotto games as they apply concepts of triangles and geometric theorems.
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving instructional activity, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

Excel Probability with Dice

For Teachers 4th - 6th
Young scholars play a dice game to complete probability exercises. In this probability lesson, students collect data using a dice game and organize it into a spreadsheet format. Young scholars also write a lab report for an experiment on...
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

Kindergarten Class Favorites

For Teachers K
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...