Discussion Analysis Tool
By Dr. Allan Jeong  [ homepage ]  [ updates ]
Instructional Systems Program at Florida State University
Last updated November 28, 2011

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.984.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

Main Menu

 

Define Code Sheet

 

Code Sequence Entry Sheet

 

Transitional Probability Matrix and Outputs

 

Draw Diagram Menu

 
 

State Diagram Output

Tally number of responses elicited per given message

By Allan Jeong
Florida State University
Copyright 2005-2009
All Rights Reserved
 

Recent Updates:

• 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.