Discussion Analysis Tool

By Dr. Allan Jeong [ homepage ] [ updates ]

Instructional Systems Program at Florida State University

Last updated 3/28/12

This is a beta release of the Discussion Analysis Tool (DAT) for sequentially analyzing patterns in event sequences, generating transitional state diagrams to map, identify, and analyze patterns observed in social and human-computer interactions, processes, and/or other complex, dynamic procedural tasks. This tool is intended for researchers (see example studies), instructional designers, and human performance experts.

See screen shots:Main menu

Enter codes

Enter code sequences

Transitional probability matrix & output

Drawing state diagrams

Example state diagram

Tally number of replies elicited per message

Minimum Software Requirements:MS Excel with Macro security set at low or medium level

Download:DAT.xls (434k) Excel 2006 or earlier | DAT 1.986.xlsm for Excel 2007+

Possible features in upcoming versions:

- Compute mean number of responses elicited per message category (e.g. mean number of BUT replies per ARGument)
- Generate state diagrams with more than six nodes
- Include observed frequencies in the nodes of each state diagram
- Flag down transitional probabilities that are based on low cell frequencies with gray-colored fonts in matrix and gray-colored arrows in diagrams.
Questions?Email Dr. Allan Jeong

**Transitional Probability Matrix
and
Outputs**

**Tally number of responses elicited per given
message**

*By Allan Jeong*

*Florida State University*

*Copyright 2005-2012*

*All Rights Reserved*

- 2/22/12 Added glow circles around each node to convey the number
of times each particular event was observed in the data set.

- 2/22/12 Added function to create "historical state diagrams" so
that for any given event, one can determine how often one particular
event preceded the given event.

- 6/9/09 Automaticallly draws four node diagrams if number of codes = 4
- 6/9/09 Prompts user when a code is missing in the DefineCodes sheet when running StartSeqAnal
- 11/8/08 In the CodeSequence page, sequence numbers are automatically inserted into column B from top to bottom of the event list when no sequence numbers are entered by the user (when column B is left blank)
- 11/8/08 Fixed error in draw diagram where transitional probability of .64 is inserted in link from node 5 to node 2, and where transitional probably of .62 was inserted into link from node 5 to node 3.
- 11/8/08 When there are only four codes specified in the Draw Diagram matrix, the program now draws a four node diagram rather than a six node diagram.
- 3/28/12 Links in state diagrams are colored gray if probability
is not significantly higher than expected based on z-scores