Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Students calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Lesson Plan
Curated OER

Virtual Field Trip: Lodging and Meals

For Teachers 5th - 7th
Students calculate the costs for lodging and meals for a virtual field trip. They calculate the number of nights lodging needed for road and city travel and the number of meals needed, the costs for each, and input the data using...
Activity
Teach Engineering

Applying Statistics to Nano-Circuit Dimensions in Fabrication

For Students 11th - 12th Standards
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Lesson Plan
Cornell University

Sound Off!

For Students 10th - 12th
Time to witness the effects of sound. Learners analyze different materials to determine their abilities to absorb sound waves. They use free software to monitor the amplitude of the waves to verify results.
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Lesson Plan
Curated OER

Analyzing Tree Rings to Determine Climate Change

For Teachers 6th - 8th
Young scholars examine how to locate and access data sets.  In this climate change lesson students import data into Excel and graph it.   
Activity
Curated OER

Tech Integration Project Lesson Accelerator: Project Overview

For Teachers 7th - 8th
Prepare middle schoolers for life in the tech world with a lesson on entering, storing, sorting, and creating database collections. They use a database tool, such as excel, to record the contents of their CD collections. They then...
Lesson Plan
Curated OER

Think GREEN - Utilizing Renewable Solar Energy

For Teachers 7th - 12th
Students use data to find the best renewable energy potential.  For this solar energy lesson students import data into Excel and explain how solar energy is beneficial. 
Lesson Plan
Curated OER

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
Students explore the changes in sea ice over several years. In this life science lesson, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
Unit Plan
Mathematics Vision Project

Circles: A Geometric Perspective

For Teachers 10th - 12th Standards
Circles are the foundation of many geometric concepts and extensions - a point that is thoroughly driven home in this extensive unit. Fundamental properties of circles are investigated (including sector area, angle measure, and...
Lesson Plan
Curated OER

I Can Build It.....Yes I Can!

For Teachers K
Kindergartners listen to a story read by their teacher, then use magnetic shape pieces to construct simple designes. They "build" their own house using pre-cut paper shapes. This age-appropriate lesson would be an excellent choice for...
Lesson Plan
Curated OER

Symphonic Poetry

For Teachers 6th - 8th
Students interpret the themes in Tchaikovsky's Romeo and Juliet Fantasy Overture, create a 6-line poem based on the themes in the Romeo and Juliet Fantasy Overture, and define musical terms related to the study of programmatic music in...
Lesson Plan
Illustrative Mathematics

How Many Leaves on a Tree?

For Teachers 9th - 12th Standards
This is great go-to activity for those spring or fall days when the weather beckons your geometry class outside. Learners start with a small tree, devising strategies to accurately estimate the leaf count. They must then tackle the...
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Young scholars work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
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

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

Getting Started With Java-Background

For Teachers 10th - 12th
Students study the history of computers including hardware and software, binary representation of data and examine the beginnings of programming languages. They investigate the development of software and the fundamentals of...
Lesson Plan
Curated OER

Making a Spreadsheet

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

The Racing Heart

For Teachers 5th
Fifth graders locate their own pulse rate from their carotid or radial artery, and graph their pulse rates after completing various exercise activities. They graph their data on a pie graph using Microsoft Excel software.
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
Activity
PBL Pathways

College Costs 2

For Students 10th - Higher Ed Standards
What is the financial benefit for attending a community college for the first two years before transferring to a four-year college? The second part of the educational lesson asks young scholars to explore this question through data...
Lesson Plan
Curated OER

Terrific Tessellations

For Teachers 6th - 10th
Students create to pieces of artwork using two primary colors and tessellation techniques. This is an excellent lesson that can be accomplished using standard art techniques or educational software such as Adobe Photoshop or Microsoft...
Lesson Plan
Curated OER

Our Client Is The Cincinnat Art Museum

For Teachers K - 12th
Students design various commercial products for the Cincinnati Art Museum using on-line sources, past designs, and creative educational software. This lesson has excellent project ideas for various student levels including: K-2, 3-5,...
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...