| Tutorial: How to use the Zeus StudyMart |
|
|
|
| Written by Manfred Carlo Cardenas | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Monday, 25 January 2010 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tutorial: How to use the Zeus StudyMartOverviewThis document is a brief tutorial on how to make simple queriesusing the Zeus StudyMart application. The StudyMart application essentially has two parts, the Search Filters screen and the Results screen. Each has its own set of capabilities. Basically, you need to fill up some Search Filters with some values and display observation units matching your filters on the Results screen. In this tutorial, we will be going through the capabilities available on each screen. Click here to begin loading the application. Quick links: Specifying values of type Value Enumeration Specifying values of type Numeric Range Uploading an XML for the Search Filters grid Hiding column headers in the Query Results Screen The Search Filters ScreenThe first screen of StudyMart shows us a grid (also known as table) with a loaded list of Study Variables. Let us call it the Study Variables Grid. Each row in this grid is a Study Variable. It has six (6) columns, Actions, Study Variable, Property, Method, Scale and Value(s). The Study Variable, Property, Method and Scale columns each contain information about the Study Variable. Study Variable contains the name of the Study Variable, Property contains the Property/Trait Name, Method contains the Method Name and Scale contains the Scale of the Study Variable. The Value(s) column remains hidden initially, as we add values to a particular Study Variable, this column will contain those values. The Actions column contains icons which does some special things to a particular Study Variable. See the table below. Actions and their Descriptions
Some other functionalities are available in this screen. If you notice there are several buttons and a combo box surrounding the grid. These buttons enable you to load the top study variables, save the current list of study variables in your grid into an xml file for uploading later, uploading an xml file containing a list of study variables, adding more study variables into the grid, and finally, loading a pre-defined list of study variables. Search Filters Screen Buttons and their Descriptions
Once we are satisfied with our Study Variables and their values we can go ahead and click the The Query Results ScreenThis is the second screen of StudyMart. It also shows us a grid but with different contents. Let us call it the Results Grid. Each row in this grid is an observation unit and the column headers are Study Variables and contains corresponding values per observation unit (row). This grid also has several functionalities which are similar to the Study Variables Grid. We can add more column headers, hide or show column headers already displayed, save the current column headers in a list into an xml file, upload an xml file containing a list of column headers, pick from a list of predefined column headers, and finally save the query results into a csv file. Results Screen Buttons and their Descriptions
Below are some of the other functionalities of StudyMart that are discussed in detail. Back to Top The Study Variables WindowAdding study variables in our grid, we will be presented with the window below. ![]() As we can see, there is a search box on top which we can type in some text. See the screenshot below. ![]() As we can see from the vertical scrollbar on the right, the information inside the grid has been trimmed to anything that contains the "germplasm" text. We can add study variable(s) to our search filters grid by ticking the checkbox of the study variable we want to add and then clicking the ![]() Back to Top The Numeric Range WindowWhen specifying values that are numeric, we are presented with the numeric range window. See below. ![]() Here we have a text box to accept our input. We can type in ranges separated by a dash (-) or just a single number. Clicking the Back to Top The Value Enumeration WindowWhen specifying values we are presented with the window below. Here we can select values from the left-hand side by clicking the + button. Selected values goes to the right-hand side of the window. In some cases, there might be many values for a particular study variable, hence the left-hand side grid has a paging toolbar. Clicking the ![]() Value Enumeration Window Buttons and their Descriptions
The Upload XML WindowWhen uploading an xml file containing a list of preferred study variables we are presented with several windows as seen below. Clicking the Browse button will open a file browsing window wherein we will select the xml file we wish to upload. Once a file is loaded, the search filters grid will reload its contents as well.![]() Back to Top Hiding Column HeadersWhen we want to hide columns we are presented with a window containing the list of column headers we can hide (see image below). ![]() By simply checking items in this window, that checked column headers gets hidden. If we uncheck an item, it gets show back into the grid (see image below showing checked items). ![]() Notice that there are three (3) items left unchecked and they are the only ones left show in the grid. Back to Top The Column Headers WindowAdding more column headers into our grid, we are presented with the window below. ![]() It is very similar to the Study Variables Window. Clicking the all checked / ticked Study Variable as column headers for our grid. Back to Top The Histogram WindowClicking the ![]() Here we have a list of study variables. We can pick a study variable here and produce a histogram / frequency distribution of that study variable using the data from our grid. After we pick a study variable, clicking the However, if you click the Histograms done via the Search Filters Screen may be different from when it is done from the Query Results Screen. This is because data in the Query Results Screen is already filtered, whereas in the Search Filters Screen, data is not yet filtered by a search criteria. This behavior applies the XY Graphs as well. Here we can see a frequency distribution of the study variable Drought Resistance. Here is another histogram for study variable GRAIN YIELD, method paddy rice, scale kg / ha. Back to Top The XY Graph WindowClicking the ![]() Here we can pick study variables (which are numeric) for our X-Y graph. The study variables available here are all numeric. Clicking the XY Graphs done via the Search Filters Screen may be different from when it is done from the Query Results Screen. This is because data in the Query Results Screen is already filtered, whereas in the Search Filters Screen, data is not yet filtered by a search criteria. This behavior applies to Histograms as well. Here is the resulting X-Y graph based from our selected study variables above. Back to Top |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Last Updated ( Wednesday, 10 November 2010 ) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||





















