Transcript Changes in IPM PIPE Data Entry

IPM PIPE Training
May 14th, 2007
PIPE DATA ENTRY FOR
EXPERIENCED USERS :
Changes in data entry for 2007
Julie Golod
IPM PIPE, Penn State University
1
Focus of This Module
PIPE Data Entry for Experienced Users
Topics to be Covered





Changes in Location Type and Setting
Update to the Setup Form
Update to Some Observation Forms
Addition of Data Entry Forms for Viruses and
‘Other’ Insects
Copy Locations Tool – Copying Location from
2006 for Use in 2007
2
Data Entry Steps
There are still two distinct parts to data
entry
1. First, recording site information in the
setup form; including assigning the site a
unique location name, providing location
and host information.
2. Then, uploading observational data for
that location
3
Changes to the Location Setup Form
4
Location Setup On-line Form
5
Location Setup Fields
 Location Type : the type of location
 Required
• Acceptable values:
– Sentinel - any site that is monitored on a regular basis, according
with the sentinel protocol specific to the host and/or organism being
monitored and to the region. A sentinel site can be planted early, or
not; can have multiple or single maturity groups or hosts; can be
planted specifically for the sentinel network or be located in a
research or commercial field.
– Single Observation - can represent any type of location: production
field (commercial), research station, etc, and is monitored only once,
or the expectation is that the site will be monitored once.
– Repeated Observation - can be any location where the monitoring
is expected to occur on a some type of a regular basis, be it weekly,
bi-weekly or monthly.
6
Location
Setup
Fields
Location
Setting
• Location Setting: Clarifies location type
• Required
• Acceptable Values
– Commercial - a grower/production field
– Research - research or experimental station
– Kudzu/wild legumes - a location with kudzu or another non-planted legume
species as the host
– Stand alone (sentinel only) - a site planted especially for the sentinel
network
– Volunteer legumes- Legumes that are not planted, but may have been
planted at some earlier point in time.
– Other/unknown - when the location of the site does not fit into any of the
other location setting or is unknown. However, the host must be known
– Ad-Hoc (aphid only) - This is a site that is sampled weekly during the
season, at least .5 acres in size, and aphid severity values are always
established via count and not an estimate. This is a also a site where only
aphid monitoring is occurring (not disease or virus )
7
Location Setup Fields
• Location Name: A unique name assigned to
each location; and if more than one
cultivar/host/planting date is present for that
location, each one gets a unique name
• Required
• Acceptable Values- alpha numeric w/no
spaces
–
8
Location Naming Protocol
Sentinel site: STNAME”ST”NN_CC
Any other: STNAMENN_CC
• ST = state postal code (2 letter abbrev)
• NAME= County (preferred), but nearest city or another convenient
name is also acceptable. Maximum number of characters is 10, no
spaces.
• **If it is a sentinel site include the following letters “ST” after name
• NN = counter separating one location from another with the same
state and name. (sequence starts over at 01 for new state/name).
Maximum number of characters is 2.
• _ = underscore, a separation between the counters; not needed if
the second counter is not used
• CC = an alpha counter (sequence starts at “a”) or name of the
cultivar/host when more than one of the following is present at a site:
cultivar, host, or planting date. Maximum number of characters is 8
and no spaces are permitted. This counter can be ignored if the site
has only one host/cultivar/or planting date.
• The location names are case-insensitive.
9
How to assign a location name
•
•
•
•
•
•
ST = MI
NAME= Kalamazoo
** “ST”= ST
NN = 01
_ =_
CC = a
Location names are case-insensitive
Complete site name = MIKalamazooST01_a
10
Location Setup Fields
• Removal/Destruction Date – Optional; If a site was
destroyed (not harvested) for any reason, indicate the date that
occurred.
– accepted values (yyyymmdd)
• Moved to a Different Site – Optional; If monitoring was
moved to a nearby field for any reason .
– Date – When the nearby site began to be monitored.
accepted values: (yyyymmdd)
– New Location Name - The location name given to the new
site
accepted values: alpha numeric
11
Location Setup On-line Form
12
Changes in Observation Forms
• Removed the ‘Rain Sampled Since Last Time’ and ‘Rain
Amount ’ fields from the Site/Host Information Form
• Added the ability to Save Host/Site Information w/out the need
to provide Pest Information
• In the soybean rust/disease forms changed ‘number of leaves’
to ‘number of units examined’, added ‘observation unit’ field
and changed the ‘incidence’ field to ‘number of positive units’
• Changed the Soybean Aphid Data Entry to record an average
soybean count for all plants examined and not per plant and
added a count /estimate field
• Added data entry forms for viruses and ‘other’ insects
13
Step 2. Observation
On-line
Form
Observation
On-line Form
- Host/Site
14
Step 2. Observation
On-line
Form
Observation
On-line Form
- Host/Site
15
Observation Pest Fields
• Observation Unit - Conditional. This field
captures the sample type. Acceptable values : plants,
leaves, pods, stems.
• Number of Units Examined – Conditional. The
number of the units examined to make the status or
count determination. Acceptable Values: numeric
• Number of Positive Units – Conditional. The
number of units that were tested or were observed to
be positive for the organism in question. Acceptable
values: numeric
16
Edited : Observation On-line Form
Soybean Rust
17
Edited: Observation On-line Form
Soybean Rust Sentinel Post-Detection
18
Edited: Observation On-line Form
Other Diseases
19
Edited: Observation On-line Form
Soybean Aphid
20
Added: Observation On-line Form
for ‘Other’ Insects
21
Added: Observation On-line Form - Viruses
22
Changes to the Excel Forms
• Fields were added and removed in
accordance with the changes to the online forms
• Field Descriptor were added for all fields;
visible when the user moves the cursor
over the field name in row 4
• As before, entire column(s) can still be
deleted when the field is not required and
will not be of use
23
Location Setup Excel Form
24
Location Setup Excel Form
25
New Tool – Copy Locations Tool
26
New Tool – Copy Location Tool
27
New Tool – Copy Locations Tool
28
– TheLocations
Copy ToolTool
NewNew
ToolTool
– Copy
29
Contact Information
If you have any follow up questions,
please contact me either via e-mail at
[email protected] or at
[email protected], or by phone at
814-441-6070
30