Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Insert excerpt
Header
Header
nopaneltrue


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

  1. Find the

    Status
    colourBlue
    titleuploaded: to be calculated
    transaction on which you want to conduct quality control.

  2. On the left side of your transaction’s row, click (tick) .

image-20240313-033536.png

  1. 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.

image-20240308-012427.png

Info

Click the hyperlinked location name in the Quality Control page. This returns you to the DC data browser filtered by the location.

image-20240308-012618.png

Compute

Traits

traits

The Compute tab displays the traits with formulas for computation. This allows the trait data to be computed automatically in the EBS.

  1. After clicking the QC button ((tick)) beside the transaction with the

    Status
    colourBlue
    titleUPLOADED: TO BE CALCULATED
    status, you will see that all traits are selected automatically for computation. But you may also unselect those you don’t need by ticking the checkbox ((blue star)) beside them.

image-20240308-020607.png

  1. Once done, click Calculate.

image-20240308-020633.png

  1. You will be redirected back to the Data Collection main browser and the computations will be done in the background. Click the Notifications ((blue star)) to check if it is done.

image-20240308-020646.png

  1. To review the computed traits, click the QC button again and go to the Review tab.

image-20240308-020659.png

Review the dataset

The Dataset tab reflects detailed information about the uploaded data. A user can review if any values are invalid (records that did not have any values 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.

image-20240308-021016.png

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.

image-20240308-021039.png

View variable information

  1. Under the Variable column, click the variable name whose information you want to see.

image-20240308-021112.png

  1. A pop-up window will appear containing the General Information, Property, Method, and Scale of that variable.

  1. Click Close once you are satisfied.

View the plot/cross data browser

  1. From the Summary tab, locate the row of the variable whose plot or cross values you want to see.

  2. Once found, click on the value under the Data Unit column.

image-20240308-021146.pngimage-20240308-021239.png

  1. Wait to be directed to the Plot/Cross subtab. Here you can see all the plot or cross values under that specific variable.

image-20240308-024504.png

  1. You may click Remove Filters to continue navigating the Plot/Cross subtab. Otherwise, click the Summary subtab to go back.

Info

A simpler way to view the Plot data browser is by clicking on the Plot subtab found above the Summary table.

image-20240308-024542.png

View the minimum or maximum values

  1. From the Summary tab, locate the row of the variable whose minimum and maximum values you want to see.

  2. 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.

image-20240308-022029.png

  1. Wait to be directed to the Plot subtab. Here you can see plot information with that specific value.

image-20240308-024609.png

  1. You may click Remove Filters to continue navigating the Plot subtab. Otherwise, click the Summary subtab to go back.

image-20240308-024624.png

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).

  1. From the Summary tab, locate the row of the suppressed values you want to see.

  2. Under the Suppressed column, view the sub-column Count for the number of values suppressed for that variable.

image-20240308-022244.png

  1. 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.

image-20240308-023522.png

  1. You may click Remove Filters to continue navigating the Plot subtab. Otherwise, click the Summary subtab to go back.

image-20240308-024655.png

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.

image-20240308-024731.png

For experiments with cross combinations, this subtab is indicated as Cross subtab.

Cross data collection.gif

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 in the Experiment Manager.

Bulk update trait data

You may apply changes to the selected or all plot data through bulk update.

  1. From the Plot subtab, tick the (blue star) of the row(s) of the plot data that you want to update.

  2. Click (blue star) on the upper-right side of the table.

  1. On the Bulk Update modal window, select the trait to be updated from the drop-down menu.

  1. Indicate the updated trait value in the given field.

Info

If you need to indicate plots with unspecified values, tick the checkbox ((blue star)) to mark them as NA.

  1. After that, click either Apply to Selected for selected plots or Apply to All for all plots.

  1. The trait values have been updated. Wait to be directed to the Plot subtab

Sort plot information

Click the headers to sort the values in either ascending or descending order. To reset sorting, click the Refresh icon ((blue star)).

sort headers.gifimage-20240312-053725.png

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.

  1. From the Plot subtab, locate the plot data that you want to suppress and tick the checkbox ((blue star)).

  2. Click Suppress from the upper-right side of the table.

image-20240312-054005.png

  1. 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

  1. 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.

image-20240312-054124.png

Using rules

Info

This method should be used if you have a large dataset.

  1. From the Plot subtab, click Suppress on the upper-right side of the table.

  2. Wait for the Suppress Plot Data modal windowto appear. Select the trait that you want to suppress.

  3. Click Add Rule. These rules will be used to find which plot data to suppress.

  1. Modify the rules based on the provided columns. You may refer to the dropdown menu below for additional information. Then, click Suppress.

Expand
titleRules for suppressing data
  • Conjunction - describes how one or more rules interact with each other; values are “AND” or “OR”

  • Trait - drop-down menu where you can select which trait you want the rules to be applied to

  • Operator - describes the relationship between the selected trait and indicated value

  • Value - describes the desired value of the trait; the value must be an integer

  • Suppress Remarks - a text field that describes the reason for suppressing the plot data

  • Actions - an option to delete the suppress rules

  1. 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 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.

  1. From the Plot subtab, locate the plot data that you want to unsuppress and tick the checkbox ((blue star)).

  2. Click Unsuppress on the upper-right side of the table.

image-20240312-054214.png

  1. Wait for the Suppress Plot Data modal window to appear. Select the trait that you want to unsuppress. and click Unsuppress.

  1. 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.

image-20240312-054824.png

3. Once ready, click Complete on the lower right of the screen.

image-20240312-054854.png

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
colourGreen
titleCOMMITTED
. You can now see all your committed transactions.

Info

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 ((blue star)) 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.

image-20240312-054929.png
Info

If you download more than 1000 observations, it will be processed in the background. Click the Notifications ((blue star)) 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.