Lesson Plan
Curated OER

Build a Bar Graph

For Teachers 1st - 2nd
Learners discover how to use bar graphs. They will gather and organize specific data in order to put it into a bar graph. Then they will answer several questions based on the information they have graphed.
Lesson Plan
EngageNY

Introduction to Networks

For Teachers 11th - 12th Standards
Watch as matrices break networks down into rows and columns! Individuals learn how a network can be represented as a matrix. They also identify the notation of matrices.
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
Curated OER

Graphing Data

For Teachers 2nd
Second graders graph data about their classmates. In this data analysis activity, 2nd graders ask each other several questions about their hair color and eye color. Students graph the data that they collected.
Lesson Plan
Curated OER

Apple Graphing

For Teachers 1st - 2nd
Do you like apples? Create a taste test for your first and second grade learners. Cut red, green, and yellow apples, and have learners select their favorite. After tasting all of the apples, they collect data and graph the results with...
Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
Lesson Plan
Curated OER

Charting and Graphing Sales

For Teachers 3rd - 5th
Students analyze graphs, charts and tables. For this data analysis lesson, students practice creating and analyzing charts, graphs and tables corresponding to sales and surveys. This lesson uses data relevant to students and includes...
Lesson Plan
Curated OER

Fractions and Measurement

For Teachers 2nd - 3rd
Using a Smart Board, or a plain ol' white board or chalkboard, the teacher pulls up a grid and demonstrates how squares and rectangles can be divided up into equal parts. The class will get their own graph paper to draw shapes and divide...
Lesson Plan
Curated OER

Graphing Data

For Teachers 1st
First graders explore the concept of graphing. In this data lesson, 1st graders gather information from a class survey and display their findings on a picture graph. Students also practice solving problems that their instructor models.
Lesson Plan
Curated OER

Graphing Changes in Weather

For Teachers K - 2nd
Students graph current temperature and weather conditions for three days.  In this weather lesson, students go to the Weather Channel's website and look up weather for their zip code then graph the conditions and record the current...
Lesson Plan
Curated OER

Graphing Integers

For Teachers 5th
Fifth graders explore the math concept of graphing integers. For this graphing integers lesson, 5th graders examine visual examples. Students also practice solving problems that their instructors model.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. For this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
1
1
Virginia Department of Education

Atomic Structure: Periodic Table

For Teachers 9th - 12th
The fifth lesson of seven in the series outlines an in-depth analysis of the periodic table. After direct instruction, pupils take turns practicing in the group before beginning independent study. The assessments include a...
Lesson Plan
Curated OER

Pet Count Excel Graphing

For Teachers 3rd - 5th
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Lesson Plan
Curated OER

Name Count and Graph

For Teachers 6th - 8th
Students find the frequency of a name in selected states by using the Internet. They input data into a spread sheet. They create a graph that illustrates the gathered information.
Lesson Plan
Curated OER

Graphing Absolute value Inequalities

For Teachers 9th - 12th
Students investigate the concept of inequalities and practice graphing them at various degrees of difficulty. They review the basic rules with the teacher at the level of theory which may make it harder for them to understand without...
Lesson Plan
Curated OER

Life Expectancy at Birth

For Teachers 3rd - 5th
Students create a line graph on the life expectancy for males and females in Canada. In this math and health lesson plan, students review table and graph terminology, create line graphs, and analyze the differences in life expectancy...
Lesson Plan
Curated OER

Graphing Game

For Teachers 6th - 7th
Students explore the concept of graphing ordered pairs. For this graphing ordered pairs lesson, students work in teams to play a version of Connect 4. Students use a Cartesian grid with values -4 to 4 as their Connect 4 board. Students...
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
SeaWorld

Marvelous Manatees

For Teachers 4th - 8th
Here is an interesting lesson plan on the manatee for your upper graders or middle schoolers. A game is played where learners work together to complete a successful manatee migration. It's a board game, and all of the game components are...
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

Our Favorite Season Lesson Plan

For Teachers 5th
Fifth graders complete a survey about their favorite season of the year. Using Excel, they create a graph using the chart wizard and copy it into Microsoft Word. They explore the relationship between the survey and the bar graph.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.