The E-DataAid application allows viewing and editing of E-Prime data files. This application is necessary because E-Prime uses a proprietary, binary data file format, which prevents direct viewing or manipulation of the data via a common application such as a text editor.
About the Interface
The title bar is displayed at the top of the application screen. The title bar displays the E-DataAid icon, the name of the open file, and the name of the application (E-DataAid). The menu bar is displayed at the top of the application screen below the title bar. The menu bar lists the menus available within the E-DataAid application, including the File, Edit, View Tools, and Help menus. Other features include: the Toolbar, Spreadsheet, Filters bar and Status bar.
Below is a list of all of the menus in E-DataAid.
|Open…||Ctrl+O||Opens an existing E-Prime data file.|
|Admin Open…||Opens a file as an Administrator, allowing access to security restrictions on the file.|
|Close||Closes the currently opened file but does not exit E-DataAid.|
|Save||Ctrl+S||Saves the opened file to the current name.|
|Save As…||Displays the Save As dialog, which allows the file to be saved to a specific name or folder.|
|Import||Imports text files containing raw data collected using MEL Professional, PsyScope, or E-Prime.|
|Export||Exports all displayed (unhidden) columns and rows in the E-DataAid spreadsheet to a text file, with flexibility of formatting to accommodate import requirements from other packages.|
|Print Setup…||Allows the setting of print properties (Printer, Paper, Orientation).|
|Print Preview||Allows the viewing of the document as it would appear in printed form.|
|Print…||Ctrl+P||Sends the currently displayed spreadsheet to the printer.|
|Properties||Displays the properties for the opened file.|
|File Security…||Allows the setting of file security settings. This command is only active when logging in as an Administrator.|
|Change Password…||Allows the user to change the password required to log in as an Administrator.|
|Recent File History||List of the most recently accessed files.|
|Exit||Exits the application.|
Reverses the most recent edit operation performed. E-DataAid supports undo for all modifications made during the current E-DataAid session (i.e., until the application is closed). When an edit operation is undone, the audit trail corresponding to that operation is also deleted. Copy
Copies the contents of the selected items to the clipboard. Paste
Pastes the contents of the clipboard into the selected area. Delete
Designates the selected cell(s) as having missing data (“NULL”). Available only for cells containing data which may be edited. Select Column
Highlights the column in which the currently selected cell is located. Find…
Displays the Find dialog box in order to search for specific text. Replace…
Searches a range of cells, columns, or rows for specific text to be replaced by a designated string. Fill Down
Fills all cells in the selected range within a single column with the contents of the first cell in the selected range. Selected range may be only one column wide. Only available for cells containing data which may be edited. Add Variable…
Displays the Add Variable dialog box in order to enter the name, level, and data type for the creation of a new variable at the end of the spreadsheet. Rename Variable…
Displays the Rename Variable dialog box in order to enter the new name for a variable. Not available for session level variables (i.e., Subject, Session, or ExperimentName).
|Toolbar||The Toolbar command turns the display of the toolbar on or off depending on its current state. A checkmark next to the Toolbar command indicates the toolbar is displayed.|
|Status Bar||The Status Bar command turns the display of the status bar on or off depending on its current state. A checkmark next to the Status Bar command indicates the status bar is displayed.|
|Hide Columns||Hides the currently selected columns.|
|Unhide Columns||Unhides (i.e., redisplays) all hidden columns.|
|Restore Column Order||Restores the columns to the default order: Experiment Name, Subject, Session, and all remaining variables in alphabetical order within their hierarchical level (e.g., session, block, trial).|
|Restore Spreadsheet||Clears all filters, unhides all columns, and restores the columns to the default order.|
|Display Annotations…||Displays the Annotations dialog box in order to view and add annotations.|
|Options…||Displays the Options dialog box in order to view and change the application's display options. The View options allow the user to set options concerning the font and color of the display, whether to prompt the user to enter an annotation when modifications are made, and options concerning the display of data in the spreadsheet.|
|Collapse Levels...||Displays the Collapse Levels dialog box in order to collapse all levels below a designated level. Collapsing levels automatically restores the columns to the default order, unhides all columns, clears all filters, filters all levels below the designated level on instance 1 or NULL, and hides all columns below the designated level.|
|Arrange Columns||Displays the Arrange Columns dialog box in order to unhide, hide, and arrange columns within the spreadsheet display.|
|Filter...||Displays the Filter dialog box in order to apply new filters to the spreadsheet, and clear active filters. Filters may also be applied or cleared by double clicking the column header, or by right-clicking the column header and selecting the Filter command in the context menu.|
|Refresh Filters||Refreshes the filters to include edits or changes in the display.|
|Analyze||Displays the Analyze dialog box in order to specify and run an analysis. The results of each analysis are displayed in a table format that may be copied to the clipboard or exported to a text file.|
|Batch Analysis||Displays the Batch Analysis dialog in order to specify and run a group of saved analyses in succession.|
|Play||F5||Plays the WAV sound file in the selected cell.|
|Apply Column Definition||Allows the User to Apply a Column Definition to the current .edat3 file.|
|Help Topics||F1||Displays the E-DataAid Help system.|
|About E-DataAid…||Displays a dialog box indicating the version information for the application.|
The Toolbar is displayed at the top of the application display below the title bar and menu bar, and may be toggled on or off using the Toolbar command in the View menu.
The Toolbar includes shortcuts to frequently used functions in E-DataAid.
The Filters bar is located at the bottom of the application display below the spreadsheet.
The Filters bar displays any filters currently applied to the data. If no filters are being applied, the Filters bar area remains blank. The Filters bar may be resized by placing the cursor over the border between the Filters bar and the spreadsheet. After the cursor changes to a double pointed arrow (pointing up and down), click and drag the border up or down until the Filters bar is the desired size, and release the mouse button.
The Filters bar area is read-only (i.e., may not be edited). However, the contents of the Filters bar may be copied to the clipboard and pasted into another application.
The Status bar is located at the bottom of the application display below the Filters bar, and may be toggled on or off using the Status bar command in the View menu. The Status bar displays the state of the application and the number of unhidden rows displayed in the spreadsheet.
Next Article: E-DATAAID: Spreadsheet (E-DataAid)