PubMed Health⌕ Search
Home/Archive/PubMed

PubMed · 12948548

Behavioral data management using Visual Basics for Applications to automate data capture and analysis.

Maurice L Sipos·Richard E Sweeney
View original source ↗Export metadata ↓

Abstract

Many researchers are familiar with the spreadsheet capabilities of Microsoft Excel, but have never explored using customized VISUAL BASIC FOR APPLICATIONS (VBA) macros embedded in the program. At the United States Army Medical Research Institute of Chemical Defense (USAMRICD), the implementation of VBA program code to carry out repetitive operations has resulted in a tremendous savings in both the time and manpower required to reliably capture, analyze, and plot data from research protocols. A set of "template" workbooks was developed and is used to organize data from different types of studies. At the heart of the concept is a "setup information" worksheet onto which the user enters information about the study (i.e. the number of subjects, groups, graphs). Clicking a control button on this worksheet launches the VBA code that creates worksheets for each subject, group and chart specified. A "pairmatch" function allows the user to create groups either randomly or by pair matching based on user-specified variables. Controls are provided that run VBA program code to parse subject data files into the proper worksheets and perform group averages. Charts are updated automatically whenever group averages change so that the researcher always has an up-to-date plot available. The ability to reformat the captured data onto a "statistical output" worksheet allows data to be imported easily to statistical software packages. The concept is being used for several different types of studies at USAMRICD and has significantly reduced not only amount of time spent on data management, but also the number of data entry errors. Readers interested in acquiring an electronic copy of the startle workbook example, which contains the complete VBA code, should send the request to the authors at reseco@erols.com or maurice.sipos@us.army.mil.

Explore related subjects

Acoustic StimulationAnimalsChemical Warfare AgentsDatabase Management SystemsGuinea PigsReflex, StartleSoftwareJournal ArticleResearch Support, U.S. Gov't, Non-P.H.S.

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

Maurice L Sipos, Richard E Sweeney. 2003-09-30. Behavioral data management using Visual Basics for Applications to automate data capture and analysis.. https://doi.org/10.1016/s0165-0270(03)00150-x

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed2008

Sensory filtering phenomenology in PTSD.

Disrupted sensory filtering, or problems with suppressing irrelevant environmental sensory stimuli, has been reported in individuals with posttraumatic stress disorder (PTSD). However, the relationship of sensory filtering deficits to specific PTSD symptoms versus an association with general trauma exposure is unclear. These relationships were examined by administering self-report measures of trauma exposure, PTSD, and sensory gating phenomenology to undergraduate participants with PTSD (n=32), with trauma history but without PTSD (n=144), and with minimal trauma history (n=153). Subjects with PTSD reported greater filtering disruption than individuals in the trauma only and low trauma groups, who did not differ. Individuals endorsing reexperiencing and numbing symptoms, and females endorsing hypervigilance, reported disrupted sensory filtering phenomenology. These results suggest that impaired filtering differentiates between individuals with PTSD symptoms and asymptomatic individuals exposed to multiple traumas and low-trauma controls.

Acoustic Stimulation↗
PubMed2007

Hypoglycemia reduces the blood-oxygenation level dependent signal in primary auditory and visual cortex: a functional magnetic resonance imaging study.

Studies of the effects of hypoglycemia on the brain using neurocognitive testing have suggested that mainly complex functions subserved by secondary and tertiary cortex are affected by mild to moderate hypoglycemia and that intensively treated patients with Type I diabetes mellitus (T1DM) may have altered sensitivity to the central nervous system effects of hypoglycemia. Functional magnetic resonance imaging provides a sensitive, regionally-specific probe of possible neurophysiologic changes related to hypoglycemia in the brain. Eleven intensively-treated T1DM patients and 11 matched non-diabetic controls took part in a 2-day protocol in which functional magnetic resonance imaging (MRI) was used to measure changes in the patterns of brain activation produced by simple auditory and visual stimuli in different conditions. On one day, participants were euglycemic the entire time. On the other day, an initial 50-min euglycemic period was followed by a 50-min hypoglycemic period. Results indicated that hypoglycemia reduced the amplitude of the blood-oxygenation level dependent response in primary auditory and visual cortex to simple auditory and visual stimuli. The latency and duration of the transient hemodynamic response function were not affected. Responses to hypoglycemia were similar in diabetic and non-diabetic participants. These results suggest that mild to moderate hypoglycemia may alter the balance of blood flow and oxygen extraction when glucose levels are lowered. Intensively-treated T1DM, with its attendant frequent hypoglycemic episodes, did not seem to alter hypoglycemic responses in primary visual and auditory cortex.

Acoustic Stimulation↗
PubMed2007

Song discrimination learning in zebra finches induces highly divergent responses to novel songs.

Perceptual biases can shape the evolution of signal form. Understanding the origin and direction of such biases is therefore crucial for understanding signal evolution. Many animals learn about species-specific signals. Discrimination learning using simple stimuli varying in one dimension (e.g. amplitude, wavelength) can result in perceptual biases with preferences for specific novel stimuli, depending on the stimulus dimensions. We examine how this translates to discrimination learning involving complex communication signals; birdsongs. Zebra finches (Taeniopygia guttata) were trained to discriminate between two artificial songs, using a Go/No-Go procedure. The training songs in experiment 1 differed in the number of repeats of a particular element. The songs in experiment 2 differed in the position of an odd element in a series of repeated elements. We examined generalization patterns by presenting novel songs with more or fewer repeated elements (experiment 1), or with the odd element earlier or later in the repeated element sequence (experiment 2). Control birds were trained with only one song. The generalization curves obtained from (i) control birds, (ii) experimental birds in experiment 1, and (iii) experimental birds in experiment 2 showed large and systematic differences from each other. Birds in experiment 1, but not 2, responded more strongly to specific novel songs than to training songs, showing 'peak shift'. The outcome indicates that learning about communication signals may give rise to perceptual biases that may drive signal evolution.

Acoustic Stimulation↗