1	ARM Germplasm Manager (AGM) Add-In for ARM 8 Gylling Data Management, Inc. www.gdmdata.com
2	AGM Introduction Database system for managing crop improvement research Is an add-in for ARM version 8 Uses ARM to enter, manage, and report individual trials Uses ARM ST (ST) to summarize and report trial series (ST is also an ARM add-in)
3	AGM Introduction
4	Components Database Use any SQL-compliant relational database. Default is single-user Microsoft Access database. Networked, multi-user DB servers are supported. User Interface Simplifies accessing data in the database. Provides software tools to automate many of the repetitive tasks required to document cultivar improvement. Accesses the database through ARM validation lists.
5	Database Relational design links records associated with development of improved varieties. Integrates with ARM and ST to manage multi-year crop performance trials. Simplifies documenting the release of new lines and varieties.
6	User Interface Point and click interface to find all information related to a cultivar under development. Simplifies entering crosses and selections. Standardizes pedigree and selection naming conventions.
7	User Interface, continued AGM has three main dialogs: Germplasm: shows the plant materials breeders use – varieties, crosses (hybrids), selections, composites (synthetic cultivars). Crossblock: shows entries in crossblocks and crosses made from those blocks. Nursery: shows entries in crop performance trials and related data.
8	Germplasm Dialogs Include sub-views that display genealogy Backward (parentage) Forward (selections and crosses). Attach files to germplasm, including ARM Trials Documents (PDF, Word, ...) Images (JPG, PNG, …)
9	Germplasm Collection Dialogs Allow users to group together crosses or populations. Sub-views show related : ARM trials (Nurseries) Combinations of parents (Cross Blocks)
10	Example 1 The next four slides contain paragraphs quoted from the published registration of ‘Expedition’ winter wheat. (Crop Science 44:1470-1471. 2004).
11	Crop Sci 44:1470 (2004)
12	Crop Sci 44:1470 (2004), cont.
13	Crop Sci 44:1470 (2004), cont.
14	Crop Sci 44:1470 (2004), cont.
15	Viewing Historical Data The next slides show the history of Expedition, as documented in Crop Science, viewed using AGM. In AGM Navigation bar, select “Germplasm” Select the “Open Record” icon from the Germplasm toolbar. Select “Expedition” from the master validation list.
16	Germplasm Dialog – Details (Expedition)
17	Germplasm Dialog – Genealogy tab (Expedition)
18	Germplasm Dialog – Genealogy Tab (Expedition)
19	Germplasm Dialog – Data tab: Phenotype tab (Expedition)
20	Germplasm Dialog – Documents tab (Bennett) For the next slide, click Germplasm, then Browse Validate, then display the master list and select “Bennett”
21	Germplasm Dialog – Documents (Bennett)
22	Germplasm Dialog – Data tab: Trials tab (SD97457) For the next slide, click Germplasm, then Browse Validate, then display the master list and select “SD97457”
23	Germplasm Dialog – Data tab: Trials tab (SD97457)
24	Example 2 A winter wheat line, tested as SD97W609, is ready to be released to growers. The breeder needs to prepare a manuscript for publication in Crop Science.
25	Manuscript Preparation Information required for registration in Crop Science includes: Experimental number or designation Names of agencies, organization or institutions Breeding procedures and pedigree Comparative performance data References for parental germplasm
26	Preparing Data Import or enter in AGM the historical data relating to the development of SD97W609 - crosses, selections and trials, dating to 1992. Export trials from AGM to ARM ST for analysis. Print two reports, one initiated from AGM and one from ARM ST, to provide a summary of SD97W609 development and testing.
27	Germplasm Report Summarizes the information in AGM. Includes information about parent lines.
28	SD97W609 Report Germplasm report also lists trials for the selected germplasm.
29	Summarizing Trials
30	Run ST Use ST to select: Traits to analyze Select the check varieties to compare with experimental lines.
31	Crop Performance Results Released cultivar Selected check varieties In format that is ready to include in registration
32	List of Summarized Trials
33	Other Components AGM also includes tools to simplify many common tasks associated with cultivar improvement, including: Managing cross blocks and pedigrees Tracking seed lots and seed inventory Managing historical data Crop performance testing and selection Cultivar phenotyping
34	Summary AGM is a database plus software interface AGM manages and reports crop improvement trials AGM is an add-in to ARM AGM uses ARM to manage trials AGM uses ST to summarize across trials (ST is also an ARM add-in)