Lesson Plan
Curated OER

Graphs and Spreadsheets

For Teachers K - 12th
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Lesson Plan
Curated OER

Power Metering Project

For Teachers 9th - 12th
Students collect and analyze variable data and understand the concept of electrical power.  In this energy instructional activity students use a spreadsheet to manage their data and create box plots. 
Lesson Plan
Curated OER

Save Our Forests

For Teachers 5th
Fifth graders discuss the forest products industry and its affects upon their communities. They inventory the wood and paper products they consume and determine how it translates into the number of trees cut. Using a spreadsheet, they...
Lesson Plan
Curated OER

Stock Market Investment

For Teachers 6th - 8th
Students create a $100,000 stock portfolio by selecting stocks from a list of one hundred companies. They complete sell/buy orders, track their portfolio values through Yahoo Finance over an eight-week period, conduct Internet research...
Lesson Plan
Curated OER

Weather v. Climate

For Teachers 9th
Ninth graders discuss the differences between climate and weather as a class. Using data they collected, they create a graph of the data to share with the class over a specific time period. They compare and contrast this data with...
Lesson Plan
Curated OER

Education for Global Peace

For Teachers 7th - 8th
Students survey the class and graph the results. In this graphing and data collection lesson, students conduct a survey to see where their shirts were produced. Individuals use software to graph the results and create a written...
Lesson Plan
Curated OER

How Credit Card Interest Works

For Teachers 10th - 12th
Students experiment with an Excel spreadsheet model that demonstrates the effects of interest on payments. They calculate actual costs, interest paid, and time necessary to pay off credit purchases and draw conclusions about the...
Lesson Plan
Curated OER

Energy Efficiency Ambassadors

For Teachers 9th - 12th
Students research energy conservation devices. They also create their own light efficiency project and presents their findings on science fair night.
Lesson Plan
Curated OER

How Many?

For Teachers 6th - 8th
Middle schoolers explore and design ways to collect data through simulations and random samples. They perform two experiments to determine the answers to various probability problems, and present the data/graphs in the form of a...
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Creating Literacy Centers Using Technology

For Teachers Higher Ed
Students create two literacy (reading and/or writing) centers to implement in an elementary classroom. Students review examples of educational software and determine the best potential centers to use in elementary classroom. Two centers...
Lesson Plan
Curated OER

Writing a Fictional Narrative

For Teachers 4th
Fourth graders write a fictional narrative using the computer. They can use files to help them focus on including a beginning, middle and end, characters, setting and plot or planning a story by answering questions.
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Young scholars create graphs using collected data. In this algebra lesson, 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

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

For Teachers 8th
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Lesson Plan
Curated OER

"who Lives in Your House?"

For Teachers 4th
Fourth graders collect data about the people and animals living in their homes, and the students' shoe sizes. They work in groups to enter the information into a database from which they create graphs. They analyze the data to find the...
Lesson Plan
Curated OER

Introduction to Limits

For Teachers 9th - 12th
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Lesson Plan
Curated OER

First Grade Shoe Sizes

For Teachers 3rd
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...
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

Student Census

For Teachers 7th - 9th
Students collect data from their peers and store the information in a database. As students manage the information they realize the usefulness of a database as a tool to manage large amounts of information in an efficient and accurate...
Lesson Plan
Curated OER

Data Displays with Excel

For Teachers 8th - 10th
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Lesson Plan
Curated OER

"Data Dabble"

For Teachers 7th - 8th
Students engage in a lesson which facilitates their use of web sites to find data, graph it, and interpret it, thus scaffolding graphing skills to prepare students for their 8th grade I-search exit project.
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

Create your own plane.

For Teachers 3rd - 5th
Students create and or modify a plane to have the longest duration and/or flight distance, then record the flight and distance and repeat the activity for three flights Using calculators, students find the average of their three flights.