CSV Export from Workbench
The Workbench CSV export provides a number of different layout options.
This page deals with the data content and its interpretation, not the instructions on how to run an export from the Workbench tool. For that, see All Signifier module page.
Column Guide
FragmentID
This is the system identifier for the particular fragment capture and thus acts as the main key to each data record. It is a Universally unique identifier (UUID) Universally unique identifier.
NarrID
This is an ID that is generated with each export generation and can be used as a unique identifier whenever it is not important for the same ID to be associated with an entry in subsequent export generation. It exists as an historical item but some users find it helpful as they are easier to visualise than the UUID.
Session Start Date
This is the date when the respondent started to enter their fragment and signification process for a given fragment. It is often not present (why???). See date time zones
Session End Date
his is the date that the respondent pressed the save button for the fragment being entered. See date time zones
Server Entry Date
This is the date that the fragment was successfully updated to the server. See date time zones
Triad Columns
Each triad is output in either 5 or 6 columns. If all 5 or 6 columns are blank, then the triad was optional and the respondent did not select this triad but passed it by.
Each triad has what we call 3 anchors. The anchors are the labels at the triad corners or vertices. Triad data represents compositional data, thus the 3 anchor values together are not represented in Cartesian Coordinates but in what is called the Simplex Coordinate system. This is important because it means that normal multi-variate statistical methods cannot be used when analysing triad data. Thus we have the Left, Top and Right anchors for a triad.
See John Aitchison's | A Concise Guide to Compositional Data Analysis for details.
These are in order left to right for each of the triad columns:
Triad Top Value
The value between 0 and 100 of the proportion of the triad value associated with the top anchor.
Triad Left Value
The value between 0 and 100 of the proportion of the triad value associated with the left anchor.
Triad Right Value
The value between 0 and 100 of the proportion of the triad value associated with the right anchor.
Triad X and Y Value
Two columns, one with the x value and one with the y value between 0 and 1. This is the actual 2D plot value. If you do a simple point plot of the X and Y values (provided you scale to an equilateral triangle) you will replicate the values as entered by the respondents.
Triad NA column
If the triad allowed for an NA checkbox, thus the respondent could declare that the triad was not applicable, then the 6th triad column is the NA column. It might not be labeled NA as SenseMaker® enables the user designing an instrument to provide their own text label for this checkbox. The CSV output will give the integer "1" if the respondent had clicked the NA. If so, the other 5 triad columns will be blank.
Dyad Columns
Dyads are also compositional, but with two components and not three as with the triads.
Dyad Left Value
The value between 0 and 100 of the proportion of the dyad value associated with the left anchor.
Dyad Right Value
The value between 0 and 100 of the proportion of the dyad value associated with the right anchor.
Dyad X Value
The value between 0 and 1 of the actual x label value entered.
A little explanation: If the Left Anchor Value is 20 then the Right Anchor value is going to be 80. But the Dyad X value is going to be 0.8 as it represents the pointer placed toward the right of the slider bar (giving it a high right hand side label value than a left hand side label value).
Thus when plotting a histogram of the dyad values, simply plot the X value.
Dyad NA column
If the dyad allowed for an NA checkbox, thus the respondent could declare that the dyad was not applicable, then the 5th dyad column is the NA column. It might not be labeled NA as SenseMaker® enables the user designing an instrument to provide their own text label for this checkbox. The CSV output will give the integer "1" if the respondent had clicked the NA. If so, the other 4 dyad columns will be blank.
Multichoice question (MCQ) Columns
The MCQ output will depend on whether the MCQ was a single select or multi-select. A single select MCQ means that the respondent may only select a maximum of one of the options, whereas in a multichoice MCQ, the user may select more than one option.
Single Select MCQ
Each MCQ contains a single column containing the value that was selected by the respondent.
Multiselect MCQ
A separate column is created for each MCQ option. In the MCQ option column, an integer "1" is placed to indicate that the respondent had selected that option.
MCQ NA Column
If the MCQ enabled the Not Applicable checkbox, then the output will contain an NA column that will contain an integer "1" if the MCQ Not Applicable was selected by the respondent. If this is the case, the other MCQ column(s) will be blank. The NA column might not be labeled NA as SenseMaker® enables the user designing an instrument to provide their own text label for this checkbox.
MCQ Other Column
It is possible in SenseMaker® to provide for an Other textbox for the respondent to select and provide a value not available within the MCQ option list. If this is allowed, then the CSV will contain an additional column for the Other option and will contain the value entered by the respondent. The column header may not be labeled "Other" because SenseMaker® enables the user designing an instrument to provide their own label for the other option.
Textbox values
A column is created for each textbox in the instrument. The column values are the respondent entered text.
Stone Columns
Each stone defined to the project will have a number of columns sets.
Stone Ratio
This indicates how stretched the stone canvas background is past being a square. This is the x axis multiplier if any reproduction of the stone values are to match the shape of the input. A ratio of 1 means that the input canvas was square.
Stone Values
Each individual stone has two columns. These columns give the compositional value of the stone X and stone Y values as though the stone was two dyads. The X axis "dyad" having the Left Value as 1 - XRight and the XRight value (summing to 1). The Y axis Dyad consists of the Y Bottom value (which is 1 - YTop) and the YTop value. Thus if the pointer is placed in the middle, the stone output is represented as two compositions. <0.5, 0.5> for the X axis and <0.5, 0.5> for the top.
To make the stone as a whole a compositional then the 4 stone values, for each individual stone (remember only 2 output in the CSV so the other 2 have to be calculated) needs to be closed. Then a pointer for a stone placed in the middle of the triad will have a single value <0.25, 0.25, 0.25, 0.25>
X Right Column
This is the value of the right hand side anchor of the X axis of the stone. It is a value between 0 and 1.
Y Top Column
This is the value of the top anchor of the Y axis of the stone. It is a value between 0 and 1.
This means that to plot a dot plot of the stones, simply plot the X Right and Y Top values (adjusting the X by the Stone Ratio if
NA Column
If the NA option is available a separate NA column will be added for the stone canvas (i.e not per individual stone but for the stone as a whole). It will contain an integer "1" if the respondent has selected the NA checkbox. It might not be labeled NA as SenseMaker® enables the user designing an instrument to provide their own text label for this checkbox.
Entry Yr Mth
This column contains the server entry date in Year/Month format. This is useful for grouping data.
EntryYrMthDay
This column contains an unformatted Year Month Day value for the server entry date in YYYYMMDD order and is useful for grouping.
fullFragmentEntry
This is the fragment in html format containing the text for all of the fragment boxes (with their corresponding labels) with isFragmentPart set to "true" in the project definition.
csvFragmentEntry
The fullFragmentEntry without the html.
wordCloud
This contains the text used to build the wordcloud (and will be other natural language processing facilities). It is in the html format (so might need to be altered).
Triad Zone Values
Contains for each fragment the zone for each triad. Thus will contain as many columns as there are triads. The value in each column is simply the zone the triad value was placed in. Thus will be one of L, T, R, Centre, LT, LR, TR.