Curated OER
Correlation of Variables by Graphing
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Curated OER
Holiday Greeting Cards: A Graphing Activity
Students examine statistics about the popular type of greeting cards and create pie or bar chart using an online tool. They illustrate the sales statistics for the greeting cards before making the charts.
Code.org
Good and Bad Data Visualizations
Good versus bad data. Pairs rate online collections of data representations from good to bad and then suggest ways to improve the visualizations. The class then creates a list of best practices and common errors in data representations...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Kenan Fellows
Reading Airline Maintenance Graphs
Airline mechanics must be precise, or the consequences could be deadly. Their target ranges alter with changes in temperature and pressure. When preparing an airplane for flight, you must read a maintenance graph. The second lesson of...
Teach Engineering
Graphing Equations on the Cartesian Plane: Slope
Slopes are not just for skiing. Instructors introduce class members to the concept of slope and teach them how to calculate the slope from a graph or from points. The lesson also includes the discussion of slopes of parallel and...
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
Tides at the Battery, NY
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...
Curated OER
Creating a Spreadsheet and Graph
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...
Curated OER
Rockin' Data
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
Curated OER
The Mitten
Explore the Ukraine through a reading of The Mitten. Readers will determine the sequence of events, cause and effect, make predictions, and find the main idea of the story. They also use math skills to make charts and graphs. Finally,...
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Teach Engineering
Complex Networks and Graphs
Show your class how engineers use graphs to understand large and complex systems. The resource provides the beginnings of graph theory by introducing the class to set theory, graphs, and degree distributions of a graph.
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Kenan Fellows
Designing and Analyzing Data Collected from Wearable Devices to Solve Problems in Health Care
Wearable devices have become more the norm than the exception. Learners analyze data from a sample device with a regression analysis in a helpful hands-on lesson. Their focus is to determine if there is a connection between temperature...
Curated OER
Beginning Graphs in MS Excel
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Curated OER
Ornithology and Real World Science
Double click that mouse because you just found an amazing lesson plan! This cross-curricular Ornithology lesson plan incorporates literature, writing, reading informational text, data collection, scientific inquiry, Internet research,...
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Curated OER
Cold, Clouds, and Snowflakes
Students explore satellite data and graphing. In this weather data analysis math and science lesson, students analyze NASA satellite data to draw conclusions about geographical areas where precipitation might have happened. Students...
Teach Engineering
Start Networking!
Class members create their own social networks by collecting signatures before graphing the interactions with their fellow classmates. The degree distribution of the simulated social network is determined by calculating the degree of...
Teach Engineering
Matching the Motion
It is not always easy to walk the straight and narrow. In the sixth portion of a nine-part unit, groups actively recreate a graph depicting motion. Individuals walk toward or away from a motion detector while trying to match a given...
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
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
Classroom Census (Analyzing Data)
Students create graphs. In this data analysis lesson, students fill out a student census and then use the data collected to produce graphs. Students write paragraphs interpreting the data.