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