1. General Model Information


Acronym: ACI_TX

Main medium: terrestrial
Main subject: biogeochemistry
Organization level: ecosystem
Type of model: not specified
Main application: database, decision support/expert system
Keywords: crop, sorghum, pest, management, database


TAEX Software Catalog
Texas Agricultural Extension Service
Extension Computer Technology Group
College Station
Texas 77843-2468


AUTHOR: Dr. John A. Jackman, Dr. Layne J. Westover PROGRAMMER: Eric L. Pang


The Sorghum Pest Management Report Database System was developed to provide growers, scouts and county agents with a computerized method of entering, storing and summarizing pest management data collected in sorghum fields. This system has computerized entry forms, the ability to edit the data, facilities to search for particular records in the database, report generation and simple character-level graphics. Several report formats are available, along with the ability to create external ASCII files. Data is entered into the Sorghum Pest Management Report system via blocked entry forms displayed on four screens. Records can be modified by selecting the edit option from the Add/Edit menu. The following is the information stored in the database: field identification number, name of grower or operator, name of county, name of scout(s), date of survey report, time of survey, sorghum growth stage, average number green bug/plant, green bug damage rating, corn leaf aphid damage rating, average number of sorghum midge/head, average number of adult lady beetles/plant, average number of larval lady beetles/plant, average number of parasite mummies/plant, percent green bugs parasitized, rating of other benefits, and any desired comment. The only requirement needed to generate a report is selection of the output variables. Any variable in the database can be selected to generate preset reports. Reports can be based on certain search parameter, e.g. a report for fields in a particular county or a report for sorghum stage between 2 through 10 and green bug population between July 1 and July 31. If numeric variables are chosen, the average for each variable is printed at the end of the report. The reports can be in a tabular format, bar chart or scatter plot. Tabular reports can be sent to the printer, a disk file or the screen. Character level graphs are available, but are normally displayed on the screen. Printed graphs are available using the print screen option of the host computer. Program Limitations The program does not check all input data ranges for appropriate values and there is no check for duplicate records. Only 2 variables are allowed in the bar charts and scatter plots. Variable headings and report output may not always line up correctly. No specific search capabilities are available for all combinations of variables and value ranges. However, since this application was written in dBASE II, functions or options not available in this program can be done 'manually' at the dBASE prompt by typing the proper command. Creating ASCII files from the database copies all data fields. This program does not handle multiple drives properly in all cases. It is best to run the program on a hard disk to provide ample room for data storage and file manipulations.

Source of the Abstract:

II. Technical Information

II.1 Executables:

Operating System(s): DOS , 128k of memory or greater. The user must have a copy of dBASE II. The computer should have a hard disk to allow entry of areasonable number of records. The Executables can be obtained from Extension Computer Technology Group Pricing: US$ 25.- inside Texas , $35.- outside Texas.

II.2 Source-code:

Programming Language(s): dBASE II

II.3 Manuals:

II.4 Data:

III. Mathematical Information

III.1 Mathematics

III.2 Quantities

III.2.1 Input

III.2.2 Output

IV. References

V. Further information in the World-Wide-Web

VI. Additional remarks

Last review of this document by: , 21.Apr 1997
Status of the document:
last modified by Tobias Gabele Wed Aug 21 21:44:39 CEST 2002

Go back to Register of Ecological Models (R E M)