+
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

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson plan, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
+
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

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
+
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
+
Lesson Plan
Curated OER

How Big Is Your Head?

For Teachers 4th - 5th
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
+
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

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 Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
+
Lesson Plan
John Hopkins University

Diets and Influence on Food Choice

For Teachers 9th - 12th
From start to finish, this is a truly excellent lesson plan addressing the epidemic of diet-related disease in the United States. Learners begin with a reading excerpt of detailed information on trends in the American diet and the...
+
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...
+
Lesson Plan
LABScI

Population Dynamics: The Predator-Prey Lab

For Teachers 9th - 12th Standards
Wolves eat better when the bunny population increases, but how long does that last? A series of 12 biology lessons uses the sixth installment to explore the predator-prey relationship between bunny and wolf populations. Young scientists...
+
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
+
Lesson Plan
Curated OER

Class Birthday Graph

For Teachers 2nd - 3rd
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
+
Lesson Plan
The New York Times

Revolt! Comparing Historical Revolutions

For Teachers 9th - 12th Standards
What elements are needed to have a revolution? How do historical revolutions from across the globe and generations compare with one another? This is an excellent activity that incorporates group work, source analysis, and an engaging...
+
Lesson Plan
Curated OER

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I lesson, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the relation defines a...
+
Lesson Plan
Curated OER

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
+
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

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
American Chemical Society

Setting the Standards of Excellence

For Teachers 9th - 12th
A number doesn't have much meaning without a standard of reference. Learners read about the history of developing standards to measure chemical and physical properties and complete reading guides to process the information. They focus on...
+
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
+
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
+
Lesson Plan
Curated OER

Thirteen Original Colonies

For Teachers 5th - 12th
An outstanding lesson on the Thirteen Original Colonies, and the settling of Pennsylvania by William Penn is here for your learners. Valuable discussion takes place regarding how the colonies were settled, and some excellent handouts are...
+
Lesson Plan
Curated OER

Sense, Sensibility and Sentences: Examining and Writing Memorable Lines

For Teachers 7th - 12th
Involve your readers in finding works of literary genius. Have each individual write down compelling sentences that they read or hear, whether in a newspaper, advertisement, book, movie, song, or any other place! Once each person has a...

Other popular searches