+
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Learners practice creating graphs in Microsoft Excel. In this technology instructional activity, students conduct a random survey and collect data. Learners use the Microsoft Excel program to create a bar graph of the data.
+
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

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

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

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
+
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 graph are...
+
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

Data Analysis and Probability: Graphing Candy with Excel

For Teachers 5th - 8th
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
+
Lesson Plan
Curated OER

Going Graph-y

For Teachers 2nd
Second graders listen to and dicuss the story Where the Wild Things Are. They play a pantomime game and act out various feelings so their classmates can guess. They listen for the frequency of certain words, and record their findings on...
+
Lesson Plan
Curated OER

Hemlock Trees and the Pesky Pest, The Woolly Adelgid

For Teachers 5th - 6th
Young scholars review Excel and how to create graphs with this program. They create two graphs in Excel, one showing the average number of woolly adelgid egg sacks on the outer 15 cm of hemlock branch at sites sorted by latitude, then...
+
Lesson Plan
Curated OER

Does cloud type affect rainfall?

For Teachers 7th - 9th
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Learners compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
+
Organizer
Curated OER

Tides at the Battery, NY

For Students 7th - 12th
Skill in using Excel and increasing proficiency in manipulating data are challenged with this data analysis work.  A web link supplies data and step-by-step instructions help learners create a graph.  There are many extension activities...
+
Lesson Plan
Curated OER

A Picture is Worth a Thousand Words

For Teachers 3rd - 6th
Pupils create various types of graphs. They go to suggested websites to collect data and create graphs to organize the data. Then they answer questions according to their graph.
+
Lesson Plan
Curated OER

Creating Climographs

For Teachers 6th - 8th
Students use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite lesson students create graphs and explain the differences between weather and climate. 
+
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
Houston Area Calculus Teachers

Polynomial Graphing

For Students 11th - Higher Ed Standards
Your AP Calculus learners probably have their ID numbers memorized, but have they tried graphing them? Pique your pupils' interest by asking each to create a unique polynomial function based on their ID numbers, and then analyze the...
+
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
+
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
+
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

Graphing Surveys and Analyzing Data

For Teachers 10th - 11th
Students analyze data and graph the results of their surveys. In this statistics lesson, students create graphs using excel to make graphs to be able to better observe their data. They conclude how great we as unique individuals.
+
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
+
Lesson Plan
Curated OER

Let's Get Linear

For Teachers 8th - 10th
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
+
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
+
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.