danryan.us

Be comfortable using subscripts and understanding what we mean when we write $X_{n} = 2 \times X_{n-1}$ and be able to work out the value of, say, $X_{4}$ given $X_{0}$ and an expression for $X_{n}$.

Translate a problem into difference equations
Recognize in a problem what the quantities of interest are, what the time periods are, and what amounts and rates represent the differences from one period to the next.

Create and Use P_n+1 vs. P_n charts to assess difference equation system behavior

1. Constructing difference equation chart from equations/table with 45 degree line
2. Be able to explain how chart is made and what a point (x,y) on the line means, explain what 45 degree line represents
3. Based on slope of DE line, describe kinds of equilibria, if any
4. Describe difference equation in P_n+1 = a P_n + b terms and calculate P_e from this.

Implement difference equations model in Excel and graphically display outcome"]]

1. Translate standard subscript notation into Excel formulas
2. Use autofill to extend integer time periods and formula for quantity of interest
3. Use other cells to contain parameters that are referred to in the difference equation formula
4. Make appropriate use of relative and absolute cell references so that formulas autofill correctly
5. Use a "spinner" to make a parameter variable; use a "divide by (a power of) ten" formula to make a spinner control parameters of arbitrary precision.
6. Format text in Excel to show subscripts.
7. Create XY scatterplot charts with legends and titles depending on data

Convey understanding of relationship between difference equations and related models/techniques.
Describe how to get from difference equations to stock and flow models

Suggest indications and contraindications, identify and respond to typical concerns and caveats
Describe assumptions and caveats

stock
flow
valve
information
positive/negative feedback
causal loops
equilibrium

Translate system description into causal loop diagram

Translate system description into stock and flow diagram

Translate stock and flow diagram into difference equations

Describe generic system performance possibilities (oscillating, growing, asymptotic, damped, etc.)

Find a source for system dynamic software
Stock and flow models are a part of an approach to modeling called systems dynamics. A search on that term will get you all you need.

Caveats