Originally published in BeeScience, Vol. 3, No. 1, pp. 10-15.

Electronic Delivery of Apicultural Information

By

Malcolm .T. Sanford, Thomas R. Fasulo, Jane C. Medley
Department of Entomology/Nematology
University of Florida
Gainesville, FL 32611-0620

ABSTRACT:

This is a review of the various means used to deliver apicultural information electronically by personal computer. A summary is presented of educational and informational databases and spreadsheet software presently available. In addition, information delivery through remote bulletin boards (RBBS) and mainframe networking is described. The possible future of computer delivered apicultural information is analyzed.

================================================================= Contact Address: Department of Entomology/Nematology, University of Florida, Gainesville, FL 32611-0620, ph 904/392-1801, FAX 904/392- 0190, BITNET: MTS@IFASGNV; INTERNET: MTS@GNV.IFAS.UFL.EDU =================================================================

Author Bios:

M.T. Sanford is Extension Apiculturist, T.R. Fasulo is Extension Computer Coordinator, J.C. Medley is Graphics Artist, Department of Entomology-Nematology, University of Florida

Key Words: Apiculture, Information, Delivery, Database, Computer

INTRODUCTION:

A recent review discussed the role of computers in systems science and simulation modeling in apicultural research (DeGrandi- Hoffman, 1992). Beyond the existing interactive models mentioned in that paper, however, there lies a larger world of electronic delivery of apicultural information. The principle methods for computer storage and retrieval of information are databases and spreadsheets. In conjunction with these basic technologies, innovative ways of distributing the information they generate have been developed.

The purpose of this paper is to describe efforts in several kinds of apicultural electronic information delivery at the University of Florida and elsewhere. As an example of this evolving technology, we discuss in some detail the history and fate of one beekeeping information database. Finally, we prognosticate on the future of electronic information delivery in both the scientific and lay apicultural community.

DATABASES:

Traditionally, apicultural information has been disseminated by printed materials, slides and scripted audio and, more recently, videotape. With the advent of the computer revolution, electronic manipulation of huge amounts of information became possible. Thus, databases of specific information incorporating text and graphics can now be compiled and presented in a variety of ways (Fasulo et. al. 1992).

Screens:

One approach to delivering information electronically using a traditional database of information is a program called SCREENS, developed in the University of Florida's Agricultural Engineering faculty. It was designed to run on small microcomputers, and its core philosophy was to be amenable to both experts developing the information and consumers.

SCREENS has four simple components: software for text, tables and graphics, cross-reference utilities, a screen file manager and screen data, table, graphic and executible files (Zazueta and Smajstrla, 1978). This program proved amenable for adaptation to deliver a static econometric model of a Florida beekeeping enterprise. This is no longer available, but the information same information is delivered as a printed circular (Sanford, 1986a) and spreadsheet program (1986b).

PC-Teach:

Similar to SCREENS in concept, PC-TEACH added variations. It was written in 1986 by Mark Notess for the Cooperative Extension Service at Virginia Tech (formerly known as Virginia Polytechnic Institute, or VPI). PC-Teach was written in TURBO PASCAL (R), however, the educator/author and user did not need to know that particular language nor purchase that product. Instead, a special development environment was created to allow a specialist to explore how best a particular subject matter might be presented to the student.

PC-TEACH was easy to learn, relatively flexible, and inexpensive to acquire because there were no copyright restrictions for educators in non-profit institutions. In the long run, it also helped teach structured programming concepts and show how they might be included in an educational setting. Three specific kinds of files were used by PC-TEACH: text, graphics and music.

The text file is the basic unit of the PC-TEACH environment. It is created with any word processor, much like the files in SCREENS, as a standard DOS text file with the extension .txt. A program in Spanish was developed to introduce a Hispanic beekeeping audience to the possibilities of the personal computer (Sanford, 1988a).

Fairs:

Beyond small-scale systems like SCREENS and PC-TEACH, other organizations continue to develop sophisticated, proprietary databases to store and retrieve greater and greater amounts of information. The Florida Cooperative Extension Service with its need to provide accurate, up-to-date information to sixty-seven county offices in the state developed a videotext system called FAIRS (Florida Agricultural Information Retrieval System). The system was designed to be as uncomplicated (friendly) for the person using it as possible.

To effectively retrieve information, someone sitting at a computer only has to press a letter next to a choice in a menu to see the information. Screens of text and graphics are linked together so the operator can quickly view topics of interest. At its nadir, FAIRS consisted of thousands of screens of information which county offices could access. In addition, the information was automatically updated by telecommunications through a campus mainframe on a regular basis.

As part of Cooperative Extension Programming at the University of Florida, a specific database on Bees and Beekeeping was developed using FAIRS. Support for modifying and expanding the FAIRS Bees and Beekeeping database has been discontinued in favor of disseminating text and graphics using CD-ROM technology. However, most of the information is still good and the system will work on almost any kind of IBM compatible computer. In an effort to further distribute the extensive information that has already been developed, the database is now being made available to a wider clientele through the American Association of Professional Apiculturists (AAPA).

Contents of the Bees and Beekeeping Database:

The first screen of the FAIRS Bee and Beekeeping database provides links to several hundred screens of text and graphics. Because it was developed with beekeepers in mind, most of the information is found in the honey bees and beekeeping section of the database (Figure 1). However, information is also provided on other bees, wasps and hornets.

 Figure 1 - Main Honey Bee Index.                                   

 			Honey Bees and Beekeeping

a.  Sources of Information			g.  Bee Stings and Reactions
b.  Biology				h.  Pesticides and Honey Bees
c.  Diseases and Pests			i.  Upward Ventilation
d.  Plants Important to Bees		j.  Good Neighbor Guidelines
e.  Pollination				k.  Nuisance Honey Bees
f.  Bee Products				l.  Africanized Honey Bee

			Press x for Bees Index

Perhaps the largest section of the database has to do with sources of beekeeping information (Figure 2).

Figure 2. - Sources of Beekeeping Information Index.

			 Sources of Beekeeping Information
a.  Newsletters				g.  National Honey Board
b.  Journals and Newspapers		h.  Supply Houses
c.  Beekeeper Associations		i.  Circulars
d.  Videos and Films			j.  Hints Series
e.  Books				k.  Federal Government Agencies
f.  Regulations on Beekeeping		l.  Africanized Honey Bee
m.  Personalized Information

                  Press x for Beekeeping Index

Figures 1 and 2 only provide a hint of the breadth of text information presented in this database. Graphics provide another dimension and some animated sequences are included. One sequence shows the decomposition of an American foulbrood infected older larva into a scale. The life cycle of the honey bee is also graphically portrayed in a series showing development from egg to pupae (Figure 3). Popup windows can be called from this display which describe each of the developmental stages in more detail.

The database supports sixteen on-screen colors. The picture of the ventral and dorsal side of a Varroa bee mite is made much more realistic by a bright reddish orange coloration and sense of relief in shading (Figure 4). Striking images of bumble bees and bears, among others, are also presented

Modifying the Database:

Because the information was developed for Florida conditions, there are some parts of the FAIRS Bees and Beekeeping database that do not apply to all geographic areas. This especially applies to bee inspection and plants important to honey bees. Unfortunately, screens of text or graphics in the database cannot be directly modified. There are, however, other ways to customize or add information. One possibility is through a "Personalized Information" option.

A copyrighted, but free, program called FILECTRL.COM (R), can be placed in a special subdirectory. When m for "Personalized Information" (see Fig. 2) is pressed, the program provides basic details on how to acquire and install this program. Documentation is distributed along with the program.

Other software programs can be used to extract information from the database. For example, PIZZAZ PLUS (R), a commercial program developed by Application Techniques, Inc., and other screen capture programs will send database screens to a printer or save them in several graphics formats. The figures in this paper were printed on a laser printer using PIZZAZ PLUS (R). The screen capture program that comes withWORDPERFECT Corporation products [WordPerfect 5.1 (R) and Presentations 2.0 (R)] will also crop graphics from a database screen and save them in .WPG format. These files can then be incorporated into flyers and sales brochures.

Captured screens can also be used to develop slide presentations. Several popular computer programs allow users to link screens together for presentations at meetings and/or to distribute freely in a run-time format. Run-time programs would allow users to select different sequences of screens to be displayed according to their interests. In essence this creates the possibility of creating a dynamic clip art program.

Another way to customize the database is to add external programs which run in their own environment, but are called up by menus. One version of the database was configured to call up BEETOX, developed by Dr. Jerry Bromenshenk and colleagues at the University of Montana who have also developed PC-BEEPOP (see DeGrandi-Hoffman, 1992). This option is not available in the database currently being distributed.

Basic Requirements and Installation:

The basic requirements for using the FAIRS Bees and Beekeeping Database are minimal (See Figure 5). It is highly recommended that at least an AT (80286) computer be used. The database makes extensive use of graphics and the processing speed of the 80286 and 80386 systems greatly decreases the time required for screen displays. The database requires the computer to have at least 1.7 MB of available disk storage space. More file space will be necessary if users add their own text files to customize this database. Finally, it supports use of a mouse.

Figure 5. Chart of PC Software Delivering Apicultural Information

        Available PC Software and Hardware Configurations

Program Name		Description		Hardware		Availability

PC-TEACH		Teaching Program	Any DOS Version	Va. Coop. Ext. Service or
									Authors; Only to Nonprofits

SCREENS			Infor. Generator	Any DOS or CP/M	Authors or Dr. F. Zazueta
									Ag. Eng. U. of Florida,
									Gainesville,  FL 32611-036


FAIRS			Database of 		DOS 2.0 or Higher,	AAPA, $35.00
BEEKEEPING		Beekeeping Infor.	640 K RAM, EGA	See Web Site
DATABASE

FILECTRL.COM		File Manager		DOS 2.0 or Higer	Authors, $2.00

PIZZAZ PLUS,		Graphics Manger		DOS 2.0 or Higher	Commercial
WORDPERFECT,		Word Processor		CGA, EGA, VGA		Software
PRESENTATIONS,	
MULTIPLAN		Spreadsheet

BEE ECONOMICS		MS Excel		Windows 3.1		AAPA Web Site



SPREADSHEETS:

Another method of presenting information using the computer is by spreadsheet. These programs work within a row-column format which provides great flexibility in manipulating numbers. The first program of this nature was called VISICALC (R). However, many more powerful applications are now on the market. At one time, this kind of program could only effectively deal with numbers, but now text, numbers and graphics are easily manipulated.

One beekeeping spreadsheet program, developed at the University of Florida, is presently available to the public. This program is designed to be a flexible financial model for a beekeeping operation (Sanford, 1986b). It consists of a series of 14 sheets linked together in specific ways. It was developed for use with the program MULTIPLAN (Verson 1.0), operating under DOS 2.0 with only 128 K of memory required. The fact that MULTIPLAN (R) itself has been upgraded and many more spreadsheet programs are now available, increases the potential use of this program. It was originally designed as only a guide to financial planning for a beekeeping enterprise (Sanford, 1986c). This program has been updated to Windows and Macintosh Excel and is available from the American Association of Professional Apiculturists.

OTHER IFORMATION DELIVERY:

Concurrently with development of the FAIRS Bees and Beekeeping database, an electronic bulletin board system or RBBS was implemented (Sanford, 1988). A good deal of beekeeping information now present in the FAIRS Bees and Beekeeping database was available to callers through a modem. There are no longer facilities to support this service, but other bulletin boards are presently operating which contain much of this information.

One beekeeper-run bulletin board is Wildbees BBS in California. The Systems Operator (SYSOP) continues to supply information on markets, current press releases and other information important to beekeepers. The use of graphics on this system is extensive. The SYSOP is Mr. Andy Nachbaur, 115 Paradise Lane, Los Banos, CA 93635, dataline number 209/826-8107.

The Camelnose Project is a European bulletin board system that has extensive electronic mail capability and links to the Association for Progressive Communications (APC). APC is a worldwide body of member networks dedicated to providing low-cost global communications services for people and organizations working for the environment, peace, conflict resolution, health and public interest. From any APC host, electronic mail can be exchanged with Geonet, Internet, Poptel, Janet, Bitnet, UUCP, Telecom, DASNet, Fidonet, and most other academic or commercial networks. Users can send and receive telex and send fax messages directly from the network.

A BBBS (Bee Bulletin Board System) has recently been implemented as part of the Camelnose Project by Dr. Hugo veerkamp, C. Springerstr.21HS, 1073LE AMSTERDAM, HOLLAND, dataline number (31).20.6764105. Other bulletin board systems are being established in Holland and Prague, Csekloslavakia.

The international mainframe networking community (Bitnet and Internet, often available to APCs and RBBSs) also provides beekeeping information through the BEE-L conference (BEE- L@CNSIBM.ALBYNVM.EDU). Over 200 subscribers from around the world exchange information on all species of bees through this network. Two beekeeping newsletters (APIS, published by the Florida Cooperative Extension Service, and BUZZWORDS, organ of the New Zealand Beekeepers Association) are published monthly as part of this forum.

FUTURE DEVELOPMENTS:

The above developments are just the beginning of a revolution in electronic delivery of apicultural information. Even to the initiated, the general field of computer-assisted information management is expanding at a furious pace. New technologies are emerging daily. Several software packages employ hyper management of text and graphics. In addition, the concept of virtual reality will play an increasing role. In this context, it will be possible to literally don the eyes of a honey bee and immerse oneself in this insect's complex society for a close up and personal look.

ACKNOWLEDGEMENTS:

We wish to thank the initial pioneers of the FAIRS project under the administration of Dr. F.A. Johnson, as well as the Kellogg Foundation, for significant financial support by during its development. This is Fla. Agric. Exp. Sta. Journal Series #..

REFERENCES:

DeGrandi-Hoffman, G. 1992. Applications of systems science and simulation modeling in apicultural research, Bee Science, Vol. 2, No. 1, pp. 43-49.

Fasulo, T.R., M.T. Sanford and J.C. Medley. 1992. Distributing and Modifying Electronic Databases, Proceedings of the Fourth International Conference on Computers in Agricultural Extension Programs, IFAS, University of Florida, February. pp. 725-729.

Sanford, M.T. 1986a. A Study in Profitability for a Mid-Sized Beekeeping Operation. Circular 722, Florida Cooperative Extension Service, IFAS, University of Florida, August, 39 pp.

Sanford, M.T. 1986b. Profitability Model for a Mid-Sized Beekeeping Operation. Circular 692, Florida Cooperative Extension Service, IFAS Software offering #043, August, 26 pp.

Sanford, M.T. 1986c. Designing a Spreadsheet Program to Track Beekeeper Profitability, Proceedings of the International Conference on Computers in Agricultural Extension Programs, IFAS, University of Florida, February. pp. 246- 251.

Sanford, M.T. 1988a. Using PC-TEACH in Several Environments, Proceedings of the Second International Conference on Computers in Agricultural Extension Programs, IFAS, University of Florida, February. pp. 759-764.

Sanford, M.T. 1988b. The Bee Board--An RBBS Application, Proceedings of the Second International Conference on Computers in Agricultural Extension Programs, IFAS, University of Florida, February. pp. 516-521.

Zazueta, F.S. and A.G. Smajstrla. 1978. SCREENS: An Information Delivery Utility Generator, American Society of Agricultural Engineers, Paper No. 87-5017, 14 pp.

Return to top of page

© 1993, M.T. Sanford, "All Rights Reserved"