Banner
The banner of the environment Spreadsheet is composed of four tabs (Home, Data, Texts, Display).
Home
Regroups the most frequently used functions concerning the "simple" management of data (add, delete, sort them…).
- The group Direct access contains functions allowing to get access to the home panel or other environments.
- The group Clip-board proposes the functions cut, copy, paste.
- The group Modification allows to unlock the datatable in order to be able to modify data, or add/delete observations.
- The group Export offers the possibilty to save the database in an Excel file.
- The group Edition contains functions allowing to sort, search, replace or delete the data.
Data
Proposes the functions allowing to modify the variables and the database, and to manage the data.
- The group Data contains two accesses to visualize the quality of your dataset graphically, or to prepare the data to the stage of analysis (check the spelling, « deduplicate », combine variables…).
- The group Modify the variables proposes the functions calculate (create a variable, merge variables…), transform and combine variables. Finally the function advanced calculation allows to create a new variable from a calculation of already existing variable(s).
- The group Modify the dataset allows to sort the data, spot and delete the duplicates, adjust the data (define quotas) and improve the quality of the dataset (qualify data).
- The group Data management proposes to import data, to automatically generate responses, and to compare, merge and et assemble the responses with those of another survey.
- The group Change the statistic unity allows to change the unit of data analysis, by regrouping, breaking or dividing data.
Texts
Proposes a set of functions allowing to visualize and analyze the text variables.
- The group Text preparation contains functions allowing to translate text data, to check the spelling, lemmatise them (infinitive, male, singular) and to characterize them (create lexical variables).
- The group Texts proposes a Verbatim function allowing to choose the text variables we wish to visualize in the working area.
Display
allows to manage the display of different elements of the screen.
- The group Presentation allows to modify the display of data in the spreadsheet (increase or decrease the number of lines of the text per cell, present the number of modalities instead of their name…).
- The group Cells allows to define the height and the width of the table.
- The group Display proposes to hide/show the sections of the lateral explorer (Sub-samples and Languages).
Environment
The environment is composed of :
1 a central working area, where a column corresponds to a variable of the survey. For each variable, it is possible to peform the following operations :
2 a four-tab horizontal strip (banner) (Home, Data, Texts, and Display),
3 a three-section lateral explorer (Variables, Sub-sample, Languages).
The section Variables of the explorer lists the variables of the study in order to show or hide them in the central working area.
La partie Sub-sample allows to create then to select a sub-sapmle in order to display the observations in a given profile. (For example : For a survey disseminated in several countries, display only the observations of French respondents, or simpler, display only the responses of males).
The section Languages allows to change the language of the data displayed, in case of a multilingual survey.
Spreadsheet
The spreadsheet restores the data given by the respondents in the shape of a table where the "n" column corresponds to the number of observations and the "m" column to the number of variables of the study. Its usefulness is demonstrated during the stage of data management to visualize, verify, transform, export data, and prepare them for analyses.
How to get access ?
- From the home panel,
- Click on the stage Data management,
- Then Spreadsheet.
