SUPPORT MATERIALS FOR TOPIC N1, NON-LINEAR MODELING

SUPPORT MATERIALS FOR TOPIC N1 and N2, NON-LINEAR MODELING

MODELING SPREADSHEETS:

For linear models – LinearModel.xls

For quadratic models – QuadraticModel.xls

For exponential models – ExponentialModel.xls

For any kind of model (after adaptation) – GeneralModel.xls

Combined: Has all four of the above models in one workbook - Several.xls

TOPIC N1 ACTIVITY SPREADSHEETS

Activity 1 – Simple-parameter quadratic formula

Activity 2 – Simple-parameter quadratic data

Activity 3 – Natural-parameter quadratic data

TOPIC N1 EXAMPLE SPREADSHEETS

Example 1 (path of basketball)

Example 2 (U.S. population growth)

Example 4 (Radioactive decay)

Example 6 (Warming of soda can)

Example 7 (Comparing linear and exponential)

TOPIC N2 ACTIVITY and EXAMPLE SPREADSHEETS

Activities 1-3 answers .

Examples 1-3 (usual formulas)

Examples 2-3 (Other forms of the formulas)

Example 4 (cooling cup of coffee)

Additional materials:

Problems to do on paper: Linear | Quadratic | Exponential
To actually play with the data / models in these problems, use the Excel workbooks below.