Lesson Plan
Curated OER

Graph It

For Teachers 1st - 2nd
Learners create a spreadsheet and graph using Open House attendance data.
Lesson Plan
Curated OER

Buying My First Car Worksheet 3

For Teachers 10th - Higher Ed
In this math worksheet, students create a spreadsheet for the different costs of the purchase of a car and use the information to answer 3 questions.
Lesson Plan
Alabama Learning Exchange

Find a Pattern Using Children's Literature

For Teachers 6th
Sixth graders listen to Demi's, On Grain of Rice: A Mathematical Folktale. They use the problem solving strategy of finding a pattern to determine the number of rice Rani will receive after 30 days. They create a spreadsheet which...
Lesson Plan
Curated OER

Snow Cover By Latitude

For Teachers 6th - 8th
Students create graphs comparing the amount of snow cover along selected latitudes using data sets from a NASA website. They create a spreadsheet and a bar graph on the computer, and analyze the data.
Lesson Plan
Curated OER

The Dangers of Being Obese/Overweight

For Teachers 3rd
Third graders determine if they are eating healthy. In this healthy living lesson, 3rd graders watch a video titled Happy Health and review the food pyramid. Students create a spreadsheet where they list their food intake for the week...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Assessment
Concord Consortium

Boards I

For Students 7th - 9th Standards
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
Lesson Plan
Curated OER

Historical Population Changes in the US

For Teachers 9th - 12th
Students conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their...
Lesson Plan
Curated OER

All The Bell & Whistles

For Teachers 9th - 12th
Young adults are so eager to get that first cell phone. And, cell phones have so many cool extras! Learners conduct real-life research to determine which cell phone carrier offers the best deals on things like wall paper, ringtones, and...
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
Activity
Howard Hughes Medical Institute

Scientific Inquiry Using WildCam Gorongosa

For Teachers 9th - 12th Standards
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
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 plan is excellent for use with upper-elementary and middle-level learners and uses spreadsheet...
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

How Tolerant Are Kids in Your School?

For Teachers 6th - 12th
Students graph results of a survey about attitudes and tolerance in their school. They discuss the social climate of their school. Students complete a questionnaire, and tabulate the raw data from their class. They create a bar graph...
Lesson Plan
Curated OER

Counting Coins

For Teachers 2nd
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Lesson Plan
Curated OER

What Goes Up Must Come Down!!

For Teachers 5th
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Lesson Plan
Curated OER

"Living in the Limelight The Universal Dream"

For Teachers 9th - 12th
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
Activity
1
1
Agile Mind

Isabella’s Credit Card

For Teachers 8th - 12th Standards
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Lesson Plan
Curated OER

Thinking Outside the Box

For Teachers 9th - 12th
Now this lesson sounds fun! Young scholars throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Lesson Plan
Howard Hughes Medical Institute

Lesson 8: WildCam Gorongosa Data Analysis

For Teachers 9th - 12th
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
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

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.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Curated OER

Budget Making

For Teachers 9th - 11th
Learners develop a budget for spending and saving. In this economics lesson, students create a budget based on personal, family and government income. They discuss jobs at home and allowances. They discuss how they manage their money...

Other popular searches