abstract |
The current period of development of science is characterised by the widespread introduction of various systems of information accumulation and management into the research practice, which fully applies to zoological and environmental research. All this requires researchers to be able to systematise a variety of incoming information and conduct its in-depth comprehensive analysis. A simple and affordable tool for this task is MS Excel, which is part of the standard set of office programs. Excel allows to record unlimited information in spreadsheets, both in terms of volume and the number of different database factors. At the same time, Excel tools such as filters, summary tables, etc. allow to instantly extract any information from the database, group according to the necessary conditions, analyse and present in the form of summary tables or graphs, calculate data in the existing package of mathematical statistical analysis. The article shows step by step, with illustrations, how to create an electronic database based on any, numerical or semantic, measured or descriptive information available to the researcher. It demonstrates how to use multiple filters and how to create summary tables, depending on user queries. The paper shows how various data of field and laboratory research included in the corresponding electronic databases are used in the work of medical zoologists when conducting epizootological monitoring of natural zoonoses and when creating medical epizootological forecasts. |
references |
Alekseev, A. F., V. I. Chirniy, L. M. Bogatyreva, et al. 1996. Peculiarities of tularemia epizootics in Crimea. Journal of Microbiology, Epidemiology and Immunology, No. 6: 28–32.
Balashov, Yu. S., A. B. Deiter. 1973. Blood-sucking arthropods and rickettsiae. Nauka, Leningrad, 1–249.
Burke, K., P. Carey. 2005. Data Analysis with Microsoft Excel. Transl. from English. Williams Publishing House, Moscow, 1–560.
Dulitsky, A. I., I. L. Evstafiev, A. B. Khaitovich. 2000. Epizootological situation, fauna of mammals and arthropod ectoparasites (Distribution of natural foci of infectious diseases in the area of the created national park "Sivash"). In: Current state of Sivash. Collection of scientific articles. Kyiv, 42–66. (pdf)
Evstafiev, I. L. 2002. Lyme disease: epizootological aspect. Bulletin of V. N. Karazin Kharkiv National University. Series Medicine, No. 4 (546): 42–46.
Evstafiev, I. L., V. B. Pyshkin, A. I. Evstafiev, N. N. Tovpinets. 2005. Electronic databases and geoinformation technologies in environmental and medical-biological research. In: Culture of the peoples of the Black Sea region. Crimean Science Center of the NAS of Ukraine, 7–10.
Formozov A. N. (ed.). 1952. Methods for census of the number and geographical distribution of terrestrial vertebrates. Publishing House of the USSR Academy of Sciences, Moscow, 1–341.
Karaseva, E. V., N. P. Sveshnikova. 1971. Wild vertebrates—carriers of Leptospira in nature and the nature of epizootics in their populations. Leptospirosis of humans and animals. Medicine, Moscow, 163–207.
Kucheruk, V. V. 1952. Quantitative census of the most important species of harmful rodents and shrews. In: Methods for census of the number and geographical distribution of terrestrial vertebrates. Publishing House of the USSR Academy of Sciences, Moscow, 9–45.
Kucheruk, V. V., E. I. Korenberg. 1964. Quantitative census of the most important warm-blooded carriers of diseases. In: Methods for studying natural foci of human diseases. Meditsina, Moscow, 129–154.
Nefedova, V. V., E. I. Korenberg, Yu. V. Andreychuk, et al. 2005. Genetic characteristics of pathogenic borrelia of the A14S group isolated in Ukraine. Journal of Microbiology, Epidemiology and Immunobiology, No. 4: 23–27.
Nechaev, V. 2006. Microsoft Excel. Electronic Tables and Databases in Problems. Intellect-Center, 1–96.
Popov, V. A. 1967. On standardization of methodology for accounting mouse-like rodents and small mammals. Fauna and Ecology of Rodents. Issue 8. Moscow State University Press, Moscow, 197–202.
Tovpinets, N. N., I. L. Evstafiev. 2003. Natural focality of zoonotic infections in Crimea: epizootological and epidemiological aspects. Issues of Development of Crimea, 15: 94–104.
Winston, W. L. 2008. Microsoft Office Excel 2007. Data Analysis and Business Modeling (+CD-Rom). BHV-Petersburg, SPb., 1–608.
Zagorodniuk, I., M. Korobchenko. 2007. Distribution and dynamics of rabies in mammal populations in Luhansk province. Visnyk of the Lviv University. Series Biology, 45: 127–138. (In Ukrainian). (pdf) |
