For VERSION 37
AGROBASE Generation II
Chia Tai Co., Ltd., THAILAND
November 30 - December 4, 2015
Copyright c 2001-2015 by
Agronomix Software, Inc
PRINTED IN CANADA
PRIVATE CUSTOMIZED
Training Course
Page
Who S
softwa
profici
more o
days,
se, bu
new to
Requi
operat
own la
are en
any da
are the
Day
This d
compe
previo
the fol
8:30 -
¡E Welc
¡E Verif
¡E Unde
¡E Crea
¡E Data
¡E Navig
¡E Using
¡E Addit
¡E Mana
¡E Clas
10:00-
¡E Refr
10:15
¡E Addit
¡E Trea
¡E Impo
¡E Grou
¡E Drag
| 1
Should Attend
are ¡V but hav
ency, or those
of the software
those wanting
ut variety testin
o the software,
irements. In al
ting systems as
aptop computer
ncouraged to d
ata to develop t
e main ones, th
1- Researc
day of instructi
etency in using
usly, could beg
llowing days of
10:00 am
come and introd
fy installation of
erstanding rese
ating, accessing
security, back
gating a resear
g the data expl
tion and definit
aging traits: gro
s Exercise: Cr
-10:15 am
reshment break
to 12:00 pm
tion and definit
tments (varietie
orting treatment
uping treatment
g and drop
Introduc
Five Da
d? This cours
e at least vie
who have an
e¡¦s features inthe
advanced
ng, or not inter
otherwise the
ll cases, this co
s well as basic
r with a demo o
data files, typic
their own resea
here are more
ch Groups
ion is mandato
g AGROBASE.
gin on the follo
f instruction.
ductions
f the SQL Serv
earch groups a
g, restoring, co
kups, and LAN
rch group ¡V me
lorer to access
tion of an initial
ouping, exporti
reation and init
k
tion of locations
es, hybrids, fer
ts from entry lis
ts
ctory to Ad
ay Course I
Oc
Agronom
Winnipe
www.ag
e is designed
ewed some of
intermediate k
-depth. The mo
topics would t
ested in the p
second and th
ourse assumes
c terminology in
or registered v
cally ExcelR, w
arch group (SQ
in the course to
s, Experime
ory for all new
. More advanc
owing day. The
ver version in a
nd relational da
pying and man
issues
enus, interface,
treatments, ex
l set of data tra
ng, importing
tial developmen
s and location g
rtilizer levels, h
sts and other fi
dvanced Tr
Informatio
ctober, 2015
mix Softwar
eg, MB, Can
gronomix.c
for those who
f the online tu
knowledge, or
ore experience
take the last tw
lant breeding t
ird days.
s a basic comp
n agronomy an
ersion of the s
with your own
QL database) d
o facilitate lear
ents, Data
w users, or for
ced users, or th
e topics from t
all trainee lapto
atabases
naging a resear
, Help system
xperiments, nu
aits for your pra
nt of your ¡§prac
groups
erbicides, etc.)
iles
Training Co
on and Age
re, Inc.
nada
com
o have never o
utorials ¡V yet
the more adva
ed users might
wo days. Traine
topics, would f
petence in the
d plant breedin
software installe
entry lists, exp
during the cour
rning.
Import and
r those who ne
hose who have
this day will be
ps ¡V must be d
rch group
rseries, trials, l
actice research
ctice¡¨ research
): their creation
ourse
enda
or only occasi
want to incre
anced users w
t not need to ta
ees not into pla
focus on the fi
use of comput
ng. All trainees
ed before the c
periments, nurs
rse. The exercis
d Export, T
eed to ensure
e taken this pa
e assumed and
done prior to th
locations, year
h group
group for this
n, grouping, and
onally used th
ease their bas
ho wish to lea
ake the first tw
ant breeding p
rst three days
ter software an
s must have the
course. Trainee
series, etc., an
ses noted belo
Trials
the most bas
art of the cours
d not covered
e course
rs
course
d use
his
sic
rn
wo
er
if
nd
eir
es
nd
ow
sic
se
in
Page | 2
¡E Finding treatments in the research group
¡E Class exercise: importing sample treatment lists
12:00 to 1:00 pm
¡E Lunch break, possibly as a group depending upon venue
¡E Interaction with the course instructor as possible with the group
1:00 to 3:00 pm
¡E Designing experiments ¡V RCBD and split plots, other designs depending upon group interest
¡E Exporting experiments to Excel or dBase
¡E Importing experiments from the DEMO research group
¡E Viewing data in experiments ¡V display options, locking traits, sorting, setting trait orders
¡E System settings, split screens, data entry and validation, etc.
¡E ¡§Static¡¨ traits ¡V their use in experiments, relevance
¡E Class exercise: importing experiments and data into your practice research group
3:00 to 3:15 pm
¡E Refreshment break
3:15 to 4:30 pm
¡E Perennial experiments
¡E Sub-sampling
¡E Modifying and deleting experiments
¡E Fillers in experiments, correcting for planting errors
¡E Grouping experiments
¡E Grouping and managing multi-location experiments (trials)
4:30 to 5:00 pm
¡E Review from the day ¡V questions from the day¡¦s topics
¡E Trainee¡¦s own time to work on the day¡¦s topics
¡E Interact with instructor on specific questions
Day 2 ¡V Field Planting Plans, Reports, Labels, Data Entry
This day focuses on the practical aspects of laying out experiments, trials and nurseries, and then bringing
in data. The trainee will use the experiments created in Day 1 in their practice research group.
8:30 to 10:00 am
¡E Exporting trials
¡E Class exercise: Importing a trial from the DEMO research group
¡E Optimizing your use of your research group through grouping experiments, trials, and treatments
10:00 to 10:15 am ¡E Refreshment break
10:15 to 12:00 pm
¡E Visual design of planting plans
¡E Creating fields maps and sowing order lists
¡E Planting and harvest order numbers
¡E Saving and exporting planting plans to Excel and other file formats
¡E Management of sites and plans
¡E Class exercise: make your own planting plan(s) using experiments from your practice research group
¡E Generating reports via the report generator
12:00 to 1:00 pm
¡E Lunch break, possibly as a group depending upon venue
¡E Interaction with the course instructor as possible with the group
1:00 to 3:00 pm
¡E Introduction to the report generator: Designing field books
¡E Advanced report features ¡V conditional printing, data grouping, report objects, calculations in a report
¡E Designing labels and barcodes, printing multiple labels, thermal labels
¡E Sorting and filtering prior to generating reports or labels
¡E Class exercise: make your own reports or labels using your practice research group
¡E Using the Generation II to Excel ¡§express link¡¨
Page | 3
¡E Using the AGROBASE TabletR application to enter data into experiments and nurseries from the field or
greenhouse and upload to an AGROBASE database over the internet
3:00 to 3:15 pm
¡E Refreshment break
3:15 to 4:30 pm
¡E Import data by relational index
¡E Importance of import profiles
¡E Notes on traits in each experiment
¡E 4:30 to 5:00 pm
¡E Review from the day¡¦s topics, answers for any trainee specific questions
¡E Trainee¡¦s own time to work on the day¡¦s topics
¡E Interact with instructor on specific questions
Day 3: Data Manipulation, Analysis, Varietal Comparisons, Images
With the experiments planted and data coming in during the season, this day focuses on data manipulation
and calculations, basic analysis of variance, and varietal comparisons.
8:30 to 10:00 am
¡E Transformation (calculation) of data in your research group
¡E Building functions and logical conditions (filters)
¡E Managing calculated traits
¡E Transformation scales for categorical and other types of data
¡E Graphs ¡V bar, line, point, 3D and trend maps of field data
10:00 to 10:15 am
¡E Refreshment break
10:15 to 12:00 pm
¡E Linear models, options, and basic understanding ANOVA output
¡E The GenStatR to AGROBASE Generation II Link
¡E The R to AGROBASE Generation II Link
¡E Modified augmented design Type 2 for early generation yield testing
¡E Incomplete block and alpha design analyses
¡E Nearest-neighbor spatial analyses of yield trials
¡E Combined multi-location analyses, non-orthogonal situations, missing values
¡E Saving analyses to MS-WordR or Adobe AcrobatR
Note: Only a very basic knowledge of statistics is assumed
12:00 to 1:00 pm
¡E Lunch break, possibly as a group depending upon venue
¡E Interaction with the course instructor as possible with the group
1:00 to 3:00 pm
¡E Performing multiple single analyses of variance
¡E Accessing other analyses in Generation II ¡V histograms, descriptive statistics, regression, correlation
¡E Viewing means stored from analyses of variance for single factor experiments
¡E Computing ranks, percent of checks or varieties
¡E System settings for displays
¡E Generating reports from means tables
¡E Creating selection indices and new groups of varieties or hybrids
¡E Strategies for completing the yield testing cycle from one year to the next
¡E Class exercise: creating a selection index and new treatment group using your practice research group
3:00 to 3:15 pm
¡E Refreshment break
3:15 to 4:30 pm
¡E Varietal comparisons ¡V context in Generation II
¡E Head-to-Head comparisons of varieties or hybrids over years and locations
¡E Rolling average summaries across multi-year trials for unbalanced data sets
Page | 4
¡E Performance grid to view relative varietal performance across locations within a year
¡E GxE analyses with stored means
¡E Hybrid performance analysis for gca and sca across experiments, locations, and years
¡E Image Display Module: Image display for treatments, traits, plots, experiments
4:30 to 5:00 pm
¡E Review from the day¡¦s topics, answers for any trainee specific questions
¡E Trainee¡¦s own time to work on the day¡¦s topics
¡E Interact with instructor on specific questions
Day 4 - Plant Breeding System: Parents, Crosses, Populations, Nurseries
This day focuses entirely on the breeding system. This would be an introduction if you have never used the
software before, or a refresher to help in ¡§fine tuning¡¨ the software if you are a more advanced user. We will
try to accommodate as many different crops and breeding schemes ¡V whether self-pollinating, hybrid
development, clonal crops breeding, and more.
8:30 to 10:00 am
¡E Identifying genotypes with desirable traits ¡V querying the research group
¡E Parental genotypes for a breeding program ¡V grouping, history, etc.
¡E Class Exercise: Impor
For VERSION 37AGROBASE Generation IIChia Tai Co., Ltd., THAILANDNovember 30 - December 4, 2015Copyright c 2001-2015 byAgronomix Software, IncPRINTED IN CANADAPRIVATE CUSTOMIZEDTraining CoursePageWho Ssoftwaproficimore odays,se, bunew toRequioperatown laare enany daare theDayThis dcompepreviothe fol8:30 -¡E Welc¡E Verif¡E Unde¡E Crea¡E Data¡E Navig¡E Using¡E Addit¡E Mana¡E Clas10:00-¡E Refr10:15¡E Addit¡E Trea¡E Impo¡E Grou¡E Drag| 1Should Attendare ¡V but havency, or thoseof the softwarethose wantingut variety testino the software,irements. In alting systems asaptop computerncouraged to data to develop te main ones, th1- Researcday of instructietency in usingusly, could begllowing days of10:00 amcome and introdfy installation oferstanding reseating, accessingsecurity, backgating a researg the data expltion and definitaging traits: gros Exercise: Cr-10:15 amreshment breakto 12:00 pmtion and definittments (varietieorting treatmentuping treatmentg and dropIntroducFive Dad? This course at least viewho have ane¡¦s features intheadvancedng, or not interotherwise thell cases, this cos well as basicr with a demo odata files, typictheir own reseahere are morech Groupsion is mandatog AGROBASE.gin on the follof instruction.ductionsf the SQL Servearch groups ag, restoring, cokups, and LANrch group ¡V melorer to accesstion of an initialouping, exportireation and initktion of locationses, hybrids, ferts from entry listsctory to Aday Course IOcAgronomWinnipewww.age is designedewed some ofintermediate k-depth. The motopics would tested in the psecond and thourse assumesc terminology inor registered vcally ExcelR, warch group (SQin the course tos, Experimeory for all new. More advancowing day. Thever version in and relational dapying and manissuesenus, interface,treatments, exl set of data trang, importingtial developmens and location grtilizer levels, hsts and other fidvanced TrInformatioctober, 2015mix Softwareg, MB, Cangronomix.cfor those whof the online tuknowledge, orore experiencetake the last twlant breeding tird days.s a basic compn agronomy anersion of the swith your ownQL database) do facilitate learents, Dataw users, or forced users, or the topics from tall trainee laptoatabasesnaging a resear, Help systemxperiments, nuaits for your prant of your ¡§pracgroupserbicides, etc.)ilesTraining Coon and Agere, Inc.nadacomo have never outorials ¡V yetthe more advaed users mightwo days. Trainetopics, would fpetence in thed plant breedinsoftware installeentry lists, expduring the courrning.Import andr those who nehose who havethis day will beps ¡V must be drch grouprseries, trials, lactice researchctice¡¨ research): their creationourseendaor only occasiwant to increanced users wt not need to taees not into plafocus on the fiuse of computng. All traineesed before the cperiments, nursrse. The exercisd Export, Teed to ensuree taken this pae assumed anddone prior to thlocations, yearh groupgroup for thisn, grouping, andonally used thease their basho wish to leaake the first twant breeding prst three dayster software ans must have thecourse. Traineeseries, etc., anses noted beloTrialsthe most basart of the coursd not coverede courserscoursed usehissicrnwoerifndeiresndowsicseinPage | 2¡E Finding treatments in the research group¡E Class exercise: importing sample treatment lists12:00 to 1:00 pm¡E Lunch break, possibly as a group depending upon venue¡E Interaction with the course instructor as possible with the group1:00 to 3:00 pm¡E Designing experiments ¡V RCBD and split plots, other designs depending upon group interest¡E Exporting experiments to Excel or dBase¡E Importing experiments from the DEMO research group¡E Viewing data in experiments ¡V display options, locking traits, sorting, setting trait orders¡E System settings, split screens, data entry and validation, etc.¡E ¡§Static¡¨ traits ¡V their use in experiments, relevance¡E Class exercise: importing experiments and data into your practice research group3:00 to 3:15 pm¡E Refreshment break3:15 to 4:30 pm¡E Perennial experiments¡E Sub-sampling¡E Modifying and deleting experiments¡E Fillers in experiments, correcting for planting errors¡E Grouping experiments¡E Grouping and managing multi-location experiments (trials)4:30 to 5:00 pm¡E Review from the day ¡V questions from the day¡¦s topics¡E Trainee¡¦s own time to work on the day¡¦s topics¡E Interact with instructor on specific questionsDay 2 ¡V Field Planting Plans, Reports, Labels, Data EntryThis day focuses on the practical aspects of laying out experiments, trials and nurseries, and then bringingin data. The trainee will use the experiments created in Day 1 in their practice research group.8:30 to 10:00 am¡E Exporting trials¡E Class exercise: Importing a trial from the DEMO research group¡E Optimizing your use of your research group through grouping experiments, trials, and treatments10:00 to 10:15 am ¡E Refreshment break10:15 to 12:00 pm¡E Visual design of planting plans¡E Creating fields maps and sowing order lists¡E Planting and harvest order numbers¡E Saving and exporting planting plans to Excel and other file formats¡E Management of sites and plans¡E Class exercise: make your own planting plan(s) using experiments from your practice research group¡E Generating reports via the report generator12:00 to 1:00 pm¡E Lunch break, possibly as a group depending upon venue¡E Interaction with the course instructor as possible with the group1:00 to 3:00 pm¡E Introduction to the report generator: Designing field books¡E Advanced report features ¡V conditional printing, data grouping, report objects, calculations in a report¡E Designing labels and barcodes, printing multiple labels, thermal labels¡E Sorting and filtering prior to generating reports or labels¡E Class exercise: make your own reports or labels using your practice research group¡E Using the Generation II to Excel ¡§express link¡¨Page | 3¡E Using the AGROBASE TabletR application to enter data into experiments and nurseries from the field orgreenhouse and upload to an AGROBASE database over the internet3:00 to 3:15 pm¡E Refreshment break3:15 to 4:30 pm¡E Import data by relational index¡E Importance of import profiles¡E Notes on traits in each experiment¡E 4:30 to 5:00 pm¡E Review from the day¡¦s topics, answers for any trainee specific questions¡E Trainee¡¦s own time to work on the day¡¦s topics¡E Interact with instructor on specific questionsDay 3: Data Manipulation, Analysis, Varietal Comparisons, ImagesWith the experiments planted and data coming in during the season, this day focuses on data manipulationand calculations, basic analysis of variance, and varietal comparisons.8:30 to 10:00 am¡E Transformation (calculation) of data in your research group
¡E Building functions and logical conditions (filters)
¡E Managing calculated traits
¡E Transformation scales for categorical and other types of data
¡E Graphs ¡V bar, line, point, 3D and trend maps of field data
10:00 to 10:15 am
¡E Refreshment break
10:15 to 12:00 pm
¡E Linear models, options, and basic understanding ANOVA output
¡E The GenStatR to AGROBASE Generation II Link
¡E The R to AGROBASE Generation II Link
¡E Modified augmented design Type 2 for early generation yield testing
¡E Incomplete block and alpha design analyses
¡E Nearest-neighbor spatial analyses of yield trials
¡E Combined multi-location analyses, non-orthogonal situations, missing values
¡E Saving analyses to MS-WordR or Adobe AcrobatR
Note: Only a very basic knowledge of statistics is assumed
12:00 to 1:00 pm
¡E Lunch break, possibly as a group depending upon venue
¡E Interaction with the course instructor as possible with the group
1:00 to 3:00 pm
¡E Performing multiple single analyses of variance
¡E Accessing other analyses in Generation II ¡V histograms, descriptive statistics, regression, correlation
¡E Viewing means stored from analyses of variance for single factor experiments
¡E Computing ranks, percent of checks or varieties
¡E System settings for displays
¡E Generating reports from means tables
¡E Creating selection indices and new groups of varieties or hybrids
¡E Strategies for completing the yield testing cycle from one year to the next
¡E Class exercise: creating a selection index and new treatment group using your practice research group
3:00 to 3:15 pm
¡E Refreshment break
3:15 to 4:30 pm
¡E Varietal comparisons ¡V context in Generation II
¡E Head-to-Head comparisons of varieties or hybrids over years and locations
¡E Rolling average summaries across multi-year trials for unbalanced data sets
Page | 4
¡E Performance grid to view relative varietal performance across locations within a year
¡E GxE analyses with stored means
¡E Hybrid performance analysis for gca and sca across experiments, locations, and years
¡E Image Display Module: Image display for treatments, traits, plots, experiments
4:30 to 5:00 pm
¡E Review from the day¡¦s topics, answers for any trainee specific questions
¡E Trainee¡¦s own time to work on the day¡¦s topics
¡E Interact with instructor on specific questions
Day 4 - Plant Breeding System: Parents, Crosses, Populations, Nurseries
This day focuses entirely on the breeding system. This would be an introduction if you have never used the
software before, or a refresher to help in ¡§fine tuning¡¨ the software if you are a more advanced user. We will
try to accommodate as many different crops and breeding schemes ¡V whether self-pollinating, hybrid
development, clonal crops breeding, and more.
8:30 to 10:00 am
¡E Identifying genotypes with desirable traits ¡V querying the research group
¡E Parental genotypes for a breeding program ¡V grouping, history, etc.
¡E Class Exercise: Impor
การแปล กรุณารอสักครู่..
