Day 8:  Creating a Model Using Data from Another Model Continued

Objectives:    

1.    Organize and analyze data collected from a model (Estimating Runoff Model) into a spreadsheet.

2.    Create a scatterplot graph of the data.

3.  Graph a trendline and determine a regression equation for the data.

4.  Interpret the results by doing each of the following:

      a. Describe the situation (what the data means)

      b. Identify the function, if the relationship does exist and write it in functional notation.

      c. Describe the transformations of the parent function.

      d. Identify domain and range.

      e. Identify the independent and dependent variables.

      f. Evaluate the accuracy of the regression equation.

      g. Apply the results to the situation.

Texas Standards (TEKS) and National Standards:

            Ab1A, b2C, c1B, b1A and b1B; included on TAKS

Materials: 

1.      Computer Lab with Internet assess and a word processing program

2.   Excel program with the Data Analysis Tool installed. (This comes with the program, but it is not loaded in a typical installation. It is on the Microsoft Office CD as an Add-In Tool and must be loaded into the program in order to do this assignment.)

3.  Projection device for displaying PowerPoint Presentations

Activity:

1.      Using the PowerPoint presentation, Runoff Analysis of a 100-Year Flood, the teacher will guide the students through the situation/problem, explaining how to create a spreadsheet from the data, how to create a graph, how to draw a trendline, and how to write a regression equation.

2.      Using the graph in the presentation, the teacher will review the concepts of identifying the type of function, functional notation, independent variable, dependent variable, domain, range and transformations of parent functions.

3.      Using selected slides from the PowerPoint handout, the students will take notes and complete the assignment.