Skip to Main Content

Analyzing Data

Lesson

Analyzing Data

Objectives

In this lesson, students will use the data gathered during the Rocket Lab and create a scatter plot to function as a stepping stone for more meaningful scientific analysis. Students will:

  • create a scatter plot of gathered data, properly labeling both axes and creating a title.
  • determine the line of best fit.
  • determine and define slope.

Essential Questions

Vocabulary

  • Slope: A number that describes how steep a line is. The change in y over the change of x.
  • y-intercept: The point at which the line crosses the y-axis.
  • Line of Best Fit: A line that represents the general trend of the data, also referred to as a trend line.
  • Origin: The point at which the x-axis and y-axis meet.
  • x-axis: The horizontal axis on a graph.
  • y-axis: The vertical axis on a graph.
  • Plot: To place data points on a graph.
  • Extrapolate: To construct new data points outside a set of known data points.
  • x-y Coordinates: A set of two values that are used to determine the position of a data points on a line graph.

Duration

90 minutes/1 class period

Prerequisite Skills

Prerequisite Skills haven't been entered into the lesson plan.

Materials

Related Unit and Lesson Plans

Related Materials & Resources

The possible inclusion of commercial websites below is not an implied endorsement of their products, which are not free, and are not required for this lesson plan.

  • Excel Graph Tutorial

http://phoenix.phys.clemson.edu/tutorials/excel/graph.html

  • Create a Graph

http://nces.ed.gov/nceskids/createAgraph/default.aspx?ID=898a1b2701a44bc6a0d70113a81e646d

Formative Assessment

  • View
    • Assess students as they work through the practice set with you.
    • Assess students as they work through their own graph using the data generated from the Rocket Lab.

Suggested Instructional Supports

  • View
    Scaffolding, Active Engagement, Modeling, Explicit Instruction
    W: Students use the data gathered in the Rocket Lab to create a scatter plot of the number of pennies attached versus the height the film canister reached. They learn how to create a proper scatter plot, with labels, titles, and a line of best fit. Additionally, they learn how to calculate the equation of their line of best fit.
    H: There is no formal hook in this lesson. The lesson is introduced as the “next step” in the Rocket Lab. You can explain to students that communicating data is an integral component in the scientific process and that a properly constructed graph is paramount in that process.
    E: Students experience working with their data as they create the graph by hand. Although students work in pairs to gather the data, they are asked to create their own graph. An extension is provided in which students can create the graph by hand and then create a graph using Excel. Comparing their results could be a useful extension as well.
    R: As students move through the lab in Lesson 1, they may not recognize outlying results. As they create their graphs in this lesson, they begin to see a trend and begin to see which points appear to be different from the rest. This gives students an opportunity to revisit their procedure and perhaps brainstorm what they would do differently the next time.
    E: Students evaluate their Rocket Lab procedure as they spot outlying data on their final graphs. They will have a summative evaluation as they are assessed on their final graph, complete with axis labels, a title, and a line of best fit. Additionally, there are practice problems for students to follow as they work through calculating their line equations.
    T: The lesson can be tailored in several ways. This section allows students to break apart from their groups and create a graph on their own, building independence. Additionally, there is an Excel extension provided for classrooms with access to computers. It is recommended that students work through calculating the equation for their line first, before they let Excel generate one for them.
    O: Students create their graphs step-by-step with you. The steps include determining which values belong on which axis, determining a proper scale, plotting the data, drawing a line of best fit, and determining the equation of the line.

Instructional Procedures

  • View

    Say, “Now that you have completed the data collection portion of the Rocket Lab, it is time to analyze that data. One of the most powerful tools in analyzing data is to create a graph. You will be creating a graph by hand (or by using Excel). The information gathered from the graph will allow you to draw conclusions about your experiment.”

    Present the following information on graphs to the students through handouts, an overhead projector, or copying it a presentation board for students to copy. A copy of Graph Notes can be found in the Resources folder (S-7-6-2_Graph Notes.doc).

    The Graph

    • The independent variable is placed on the x-axis.
    • The dependent variable is placed on the y-axis.
    • Both axes should be labeled with the proper variable and units of measure.
    • The graph should have an informative title that includes the independent and dependent variables.
    • You will plot your average values for each trial.
    • You will draw a line of best fit.
    • The equation of a line will be generated.

    At this time, have students calculate the average height reached by each canister for Pennies 2–7 on the Rocket Lab worksheet (S-7-6-1_Rocket Lab Worksheet-Student Version.doc, and S-7-6-1_Rocket Lab Worksheet-Teacher Version.doc). Recall that to find the average, students will add up the height reached for each trial (for a given penny amount) and divide by 3, as there are 3 trials.

    Hand out a piece of graph paper and a ruler to each student (S-7-6-2_Graph Paper.doc). Have students create graphs for their data. Say, “First, turn your paper to the landscape orientation (longer side parallel to the ground). Using a ruler, draw a long line at the bottom of the page to represent the x-axis. Draw a long line on the left side of the paper to represent the y-axis. Label each axis according to the parameters listed on the Graph Notes. At this point, your graph should look like this:”

     

    l02-01graph.PNG

    Continue, “The next step is to create a scale on both axes. Look at your data. What is the smallest value for both the x and y axes? What is the largest value for both the x and y axes? For the x-axis, start with 0 and move up to 10. This range allows you to plot your data and still leaves room to extrapolate on either end. We will learn more about extrapolating data later in this lesson. The y-axis can also start with zero and go at least 20 cm higher than your highest value. Keep in mind that you CANNOT just write down your experimental values as a scale. The numbers need to be scaled, literally. Let each box or line represent a value and move up and down by the same amount. This graph is an example:”



    l02-02graph.PNG

    “Notice how the numbers are spaced evenly. On the y-axis, the values increase by a factor of 15 each time. The values on the x-axis increase by a factor of 1 each time. Do you notice how the numbers are spaced, so that they take up the entire graph and are not scrunched at either end?”

    “The next step is to plot the data. In this case, we will create a scatter plot, which involves plotting the data as points. Using the data from Part 1 of your Rocket Lab Worksheet (S-7-6-1_Rocket Lab Worksheet-Student Version.doc), create x-y coordinates to represent your data points. Using your coordinates, plot the data on your graph. Do not connect the dots, as that indicates you are sure of every data point in between each point, which you are not.”

     



    l02-03graph.PNG

    “Your next task is to draw a line of best fit. Usually, it is best to guess at a straight line that goes as near as possible to as many points as possible. Generally, it is a good idea to have as many points above the line as you do below the line. It is wise to ignore any data point that looks like an extreme outlier. The ORIGIN is not always included as a point!”

     

    l02-04graph.PNG

    “Now that you have drawn the line of best fit, you need to find the equation of the line.”

    If students are unfamiliar with the slope of a line, refer to the Slope PowerPoint presentation (S-7-6-2_Slope Introduction PowerPoint Presentation.ppt and S-7-6-2_Slope Introduction Presentation PDF.pdf). This will be very useful in analyzing your Rocket Lab data. Recall that the equation of a line is:

    y = mx + b

    m = slope

    b = y-intercept

    “The first step is to calculate slope (m). Slope can be described as the change in y over the change in x, or rise over run.”

    “Pick two points from your graph that are the farthest apart. Write them as coordinates or look at the data on your worksheet (you already wrote all the points as coordinates there). Label the coordinates you will be using to calculate your slope as follows:”

    Example:

     

     

    (2,105) and (7,30)

     

      x1   y         x2   y2

     

     

     

     

    “Plug the correct numbers into the equation to find the slope. Recall that slope is the change of y over the change of x, which can be written as:”

     

    y2 y1
    _________

    x2 x1

     

    “Using the example shown above, the change in y is (30105) or -75, and the change in x is (72) or 5. You can leave the slope as a reduced fraction: -75/5 or write as a decimal -15. Now, insert that value in place of m in the line equation:”

    y = –15x + b

    “You just found the slope of the line or how steep the line is. Notice that the number for slope is negative. A negative number indicates a negative graph, or a line that moves downward from left to right. A positive number for slope would be represented by a positive graph, or a line moving upward from left to right.”

    l02-05graphs.PNG
     

     

    “The next step is to find the y-intercept or where the line would cross the y-axis.

    To do this, use either one of the coordinates that you used to calculate slope. I will use (2, 105) as in the example. Plug the y-coordinate into the y spot in the line equation, plug the x-coordinate into the x spot in the line equation, and solve for b.”

    y = mx + b

    105 = (–15)2 + b

    105 = –30 + b

    135 = b

    “According to my example, the line would cross the y-axis at 135. The complete equation of the line would now look like this:”l02-06graphwithstar.PNG

    “The last part of the graph is the title. Generally, the title is written as the dependent variable (y-axis) vs. independent variable (x-axis). The title of my example graph would be as follows:”

     

     l02-07graphwithstar.PNG

    At this time, have students use their Rocket Lab data to construct a graph. They may show all of their work on Part 2 of the Rocket Lab Worksheet and attach their graph separately.

    Extension:

    • Students who might need an opportunity for additional learning can review an introduction to slope of a line. Provide them with part or all of the Slope PowerPoint presentation (S-7-6-2_Slope Introduction PowerPoint Presentation.ppt).
    • You can give students sample coordinates and have them practice finding the equation of a line before moving on to the Rocket Lab data.
    • Students who might be going beyond the standards can create a graph using Excel after they have made graphs by hand. Excel will generate the equation of a line in much less time. For a full tutorial, go to:

    http://phoenix.phys.clemson.edu/tutorials/excel/graph.html

Related Instructional Videos

Note: Video playback may not work on all devices.
Instructional videos haven't been assigned to the lesson plan.
DRAFT 05/12/2011
Loading
Please wait...

Insert Template

Information