Curated OER
Conversation Heart Graphing
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...
Curated OER
Graph Lesson
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.
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
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.
Teach Engineering
Air Pollution in the Pacific Northwest
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...
Curated OER
Excel Lesson
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...
Curated OER
Data Lesson Vital Information
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.
Curated OER
Class Birthday Graph
Young scholars 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.
Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
kind of Bean
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.
Curated OER
Graph Frenzy!!
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Curated OER
Water Chestnut Graphing Activity
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
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.
Curated OER
Creating Circle Graphs with Microsoft Excel
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.
Curated OER
Graphing Surveys and Analyzing Data
Students analyze data and graph the results of their surveys. In this statistics lesson plan, students create graphs using excel to make graphs to be able to better observe their data. They conclude how great we as unique individuals.
Curated OER
Does cloud type affect rainfall?
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Students compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
Curated OER
Using Averages to Create Graphs Through Excel
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...
Curated OER
Relations and Graphs
Here is a simple, yet clever lesson on how to teach the important concepts of greater than, less than, and equal to. Pupils write their names down on grid paper - one letter per box. They compare their names and find a name that is...
Curated OER
Investigating Seasonal Variability in NO2 Concentrations
Young scholars study different formats of data and determine the nitrogen dioxide concentrations. In this seasons instructional activity students understand the different relationships that NO2 can have.
Curated OER
Trends of Snow Cover and Temperature in Alaska
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Curated OER
Case Study of Local Trends in the Carbon Cycle
Students examine the relationship between chlorophyll and carbon dioxide in the atmosphere. In this investigative lesson plan students study the local effects of climate change.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
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...
Curated OER
Using Imported Data in Excel
Young scholars import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
Curated OER
Determining the Density of a Liquid
Students find the density of diet soda and regular soda. In this density lesson plan, students measure the mass of a graduated cylinder with 10 different volumes of each soda. They find the mass of the liquid alone and use the volume to...
Curated OER
Curious Clouds
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.