TAEX Software Catalog
Texas Agricultural Extension Service
Extension Computer Technology Group
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:
SORGHUM PEST MANAGEMENT REPORT DATABASE SYSTEM Home Page