In quality control, you can verify and manage the uploaded data. The quality control has two main tabs - Dataset and Complete Transaction.
Navigate to the Quality Control page
Find the
transaction on which data collection transaction that you want to conduct quality control.Status colour Blue title uploaded: to be calculated On the left side of your transaction’s row, click the QC button ().
Wait to be directed to the Quality Control page. Here you can see three tabs: (1) Compute, (2) Review, and (3) Complete Transaction. The tabs reflect important information about the dataset which will be discussed in detail below.
Info |
---|
The Compute tab will appear for transactions with trait data that have valid formulas. Otherwise, the tab will not be visible on the QC page. |
Click the hyperlinked location name
on the Quality Control page. This returns you to the
Data Collection data browser filtered by the location.
Select traits for computation
The Compute tab displays the traits with formulas for computation. This allows you to select the trait data to be computed automatically in the EBS.
After clicking the QC button () beside the transaction with the
status, you will see that all the traits are selected automatically for computation. But you may also unselect those you don’t need select one or more of them by ticking the checkbox ().Status colour Blue title UPLOADED: TO BE CALCULATED
You can also select all traits by ticking the checkbox () beside
the column headers.
Once done, click Calculate.
You will be redirected back to the Data Collection main browser and the computations will be done in the background. Click the Notifications () to check if it is done.
The transaction will change its status to
after the computation. To review the computed traits, click the QC button again and go to the Review tab.Status colour Blue title uploaded
Review the dataset
The Dataset tab reflects detailed information about the uploaded data collection transaction. A user can review if any trait data values are invalid (records that did not have any values or had wrong formats when uploaded), missing (records with missing values), or voided (records whose values were intentionally removed by the user). This tab is also used for suppressing or unsuppressing plot data if needed.
Summary subtab
This subtab provides a table of the summarized values for each variable/trait in the dataset. It provides a quick view of the statistical values (e.g. Min, Max, Avg), invalid or voided values, and records of suppressed values.
View variable information
Under the Variable column, click the variable name whose trait information you want to see.
A pop-up window will appear containing the General Information, Property, Method, and Scale of that variable.
Click Close once you are satisfied.
View the plot/cross data browser
From the Summary tab, locate the row of the variable whose plot or cross values you want to see.
Once found, click on the value under the Data Unit column.
Wait to be directed to the Plot/Cross subtab. Here you can see all the plot or cross values under that specific variable.
You may click Remove Filters to continue navigating the Plot/Cross subtab. Otherwise, click the Summary subtab to go back.
A simpler way to view the Plot data browser is by clicking on the Plot subtab found above the Summary table.
View the minimum or maximum values
From the Summary tab, locate the row of the variable whose minimum and maximum values you want to see.
Under the New column, view the sub-columns Min and Max for the exact minimum and maximum values. Click the value whose information you want to see.
Wait to be directed to the Plot subtab. Here you can see plot information with that specific value.
You may click Remove Filters to continue navigating the Plot subtab. Otherwise, click the Summary subtab to go back.
View suppressed plot data
Info |
---|
By default, there are no suppressed variables. You will only see data under this column after you suppress data (refer to Suppress plot data section). |
From the Summary tab, locate the row of the suppressed values you want to see.
Under the Suppressed column, view the sub-column Count for the number of values suppressed for that variable.
Click the indicated value to be redirected to the Plot subtab. Here you can see the plot information of all the suppressed values of that variable.
You may click Remove Filters to continue navigating the Plot subtab. Otherwise, click the Summary subtab to go back.
Plot/Cross subtab
This subtab provides a data browser of all the plot data for all the collected variables/traits. It allows users to filter and update the data, and suppress or unsuppress any values if needed.
For experiments with cross combinations, this subtab is indicated as Cross subtab.
info
You may view the Occurrence Data in the Plots subtab by clicking the dropdown display. This is used for reviewing the calculation of your plots. You may also modify the occurrence data also add and hide the data columns in either Plot or Cross subtab. Click to access the personalized grid settings and add or remove the columns.
Info |
---|
You can view the Occurrence Data in the Plots subtab by clicking the dropdown display. This is shown when a certain trait data was calculated from the occurrence data. An example is flowering date - seeding date = flowering days. The seeding date can be seen and modified in the Experiment Manager. |
Bulk update trait data
You may apply changes to change the selected or all plot data through bulk updateupdating.
From the Plot subtab, tick the of the row(s) of the plot data that you want to update.
Click on the upper-right side of the table.
On the Bulk Update modal window, select the trait to be updated from the drop-down menu.
Indicate the updated trait value in the given field.
If you need to indicate plots with unspecified values, tick the checkbox () to mark them as NA.
After that, click either Apply to Selected for selected plots or Apply to All for all plots.
The trait values have been updated. Wait to be directed to the Plot subtab
Info |
---|
Computed trait values will also be recalculated after updating the trait data. |
Sort plot information
Click the headers to sort the values in either ascending or descending order. To reset sorting, click the Refresh icon ().
Suppress plot data
Suppressing plot data is useful when we have values that we want to be part of the dataset but do not want to be included in the analysis (e.g. outliers). You can suppress plot data using two ways:
Selecting individual plots
Info |
---|
This method should be used if your dataset only contains a few variables and plot data. |
From the Plot subtab, locate the plot data that you want to suppress and tick the checkbox ().
Click Suppress from the upper-right side of the table.
Wait for the Suppress Plot Data modal window to appear. Indicate the trait and the remarks for suppression. Note that Suggested Remarks is a required field. Then. click Suppress
Once satisfied with the selected trait data to be suppressed, click Apply and wait to be directed to the Plot subtab.
You have successfully suppressed your data! Unsuppressed data will be highlighted as green, while Suppressed values will be grayed out.
Info |
---|
Computed trait values will also be recalculated after suppressing the trait data. |
Using rules
Info |
---|
This method should be used if you have a large dataset. |
From the Plot subtab, click Suppress on the upper-right side of the table.
Wait for the Suppress Plot Data modal windowto appear. Select the trait that you want to suppress.
Click Add Rule. These rules will be used to find which plot data to suppress.
Modify the rules based on the provided columns. You may refer to the dropdown menu below for additional information. Then, click Suppress.
Expand | ||
---|---|---|
| ||
|
Once satisfied with the selected trait data to be suppressed, click Apply and wait to be directed to the Plot subtab.
Info |
---|
Computed trait values will also be recalculated after suppressing the trait data. |
You have successfully suppressed your data! Unsuppressed data will be highlighted as green, while suppressed data will be highlighted as brown.
Unsuppress data
If you want to unsuppress plot data, you can do so by selecting individual plots/traits. Remember that you can only unsuppress data that has already been suppressed.
From the Plot subtab, locate the plot data that you want to unsuppress and tick the checkbox ().
Click Unsuppress on the upper-right side of the table.
Wait for the Suppress Plot Data modal window to appear. Select the trait that you want to unsuppress. and click Unsuppress.
Once satisfied with the selected trait data to be suppressed, click Apply and wait to be directed to the Plot subtab.
Great job! You’re done managing your dataset and are now ready to complete the transaction.
Complete the transaction
The Complete Transaction tab provides a table of the summarized values for each variable/trait available in the dataset. It provides a quick view of the statistical values (e.g. Min, Max, Avg), invalid or voided values, and records of suppressed values.
After reviewing your dataset and suppressing any data if required, you are now ready to complete the transaction. Completing the transaction means that your validated data will be committed to the experiment as operational data. You will no longer be able to modify the data after committing it.
1. From the Quality Control page, click the Complete Transaction tab.
2. Review the summary of the transaction based on what you have changed in the dataset.
3. Once ready, click Complete on the lower right of the screen.
4. Wait for the modal dialog to appear. Click Confirm.
5. Wait to be directed to the Data Collection tool where the status of your transaction is now set to
Status | ||||
---|---|---|---|---|
|
If your total number of observations is more than 1,000, it will be processed in the background. This way you can do other tasks in the EBS while waiting. Click the Notifications () button and select the topmost notification.
6. You may also download the dataset before completing the transaction by clicking the Download Dataset button at the lower right corner.
If you download more than 1000 observations,
they will be processed in the background. Click the Notifications () button and select the topmost notification to start downloading the file.
Great job! You’ve completed your transaction and have finished conducting quality control. Remember that you can repeat the data collection process to add data over time. After data collection, you may start a new experiment or generate seed or germplasm records using the Harvest Managertool.