1 / 21

# Teaching Systems Thinking in Spreadsheets - PowerPoint PPT Presentation

Teaching Systems Thinking in Spreadsheets. Mohammad Mojtahedzadeh Attune Group, Inc Deborah Upton Stonehill College. Modeling Spectrum:. Exposé. System Dynamics. Spreadsheet. Simple Manipulation. Complex Formulation. Build on Simple manipulation to arrive at Complex formulation.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' Teaching Systems Thinking in Spreadsheets' - onslow

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Teaching Systems Thinking in Spreadsheets

Attune Group, Inc

Deborah Upton

Stonehill College

### Modeling Spectrum:

Exposé

System Dynamics

Simple Manipulation

Complex Formulation

Build on Simple manipulation to arrive at Complex formulation

### Modeling Spectrum:

System Dynamics

Simple Manipulation

Complex Formulation

• Hidden relationships

• Visualization of structure

• Local in time and space

• Global in time and space

• Circular Causality

• Stock-and-Flow

• Mathematical Nonlinearity

• Data-Point Nonlinearity

Makes it difficult to

understand,

analyze and, communicate…

Tree Diagrams of Precedence

make the connections among the CELLS visible

Working with numbers (not equations)

One relationship, one time period

No clear model boundaries

…. makes it easy to master!

…. but inadequate for modeling complexity!

Purchases (Jan)

Savings (Jan)

1000 – 95.26 = ?

• Translate cell reference formulas to equations:

February

\$1,000

January

\$95.26

Savings (t) = Savings (t - 1) - Purchases

• Reconstruct the structure

Tree Diagrams of Causal Drivers

make the connections among the VARIABLES visible

Two distinguished tree diagrams

Tree Diagrams of Precedence

Tree Diagrams of Causal Drivers

Global

(interconnected)

System Dynamics

Complex Issues

Local

(isolated)

Simple Issues

Short term

Long term

### The Value Proposition:

Exposé allows the user to interact with Numbers and Equations any time in the process of modeling

Sometimes it might be easier to start with Numbers and then move to Equations

Purchases (Jan)

Savings (Jan)

1000 – 95.26 = ?

### Example:From Numbers to Equations and back again

Savings = Integ( purchases, 1000)

Lack of focus on

integration point and

feedback processes

Make integration points visible

Launch Exposé with Examples from the book

Circular Causality

Identify and work with feedback processes

Launch Exposé with Examples from the book

Allows data-point non-linearity

Launch Exposé with the MARKET GROWTH MODEL

Do “what if” analysis more often

Launch Exposé perhaps with Market growth model