To Build A Survey

Research scripting technology helps an addictions institute take some of the sting out of building up survey data.
"The script SPSS is using allows us to rapidly create the questionnaire and test it almost in one sitting," he says. "That whole testing and debugging cycle -- we can get things fixed earlier." Called Quancept, the SPSS scripting technology is a proprietary language that has made Gogos' job a bit easier. In the past, the IT department had to become much more involved in that testing process, going into the system and helping RIA researchers work out the glitches. Sometimes those glitches -- mostly having to do with skip logic and all the loops that occur inside the questionnaires -- wouldn't be corrected until after the surveys were in actual use. "Looping errors are usually tough to debug," Gogos says, but, he added, the SPSS product is better than the RIA's previous technology at letting programmers where in loop the error has occurred.

The institute first installed SPSS in April 2004 and deployed it in its first study, a relatively simple one, five months later. Since then, the institute has slowly phased out an older DOS-based interview and survey-generating product, which suffered from a few drawbacks. Gogos won't reveal the name the vendor. "It was a great product for its time," he says, but it had aged substantially over the years.

Because it was DOS-based, the scripting technology was cumbersome. Also, it was not automated. After researchers completed a survey, the IT department had to manually extract the data from each individual workstation and laptop. With SPSS, the data is removed each night automatically and placed into one cohesive file in a data warehouse, where it is "scrubbed and checked," Gogos says. RIA researchers can then easily view the data via the Internet -- another new capability offered by SPSS -- and obtain a "thumbnail sketch" of a study's progress. Furthermore, Gogos and his team have been freed up from those workflow demands, and they can concentrate their time on other work, such as helping to create questionnaires and prepare studies.

Gogos wouldn't divulge how much the institute paid for its 25 SPSS licenses. Nor would Rich Rodts, director of higher education sales at SPSS, who said that pricing varies widely from customer to customer, depending on the package of bells and whistles that each user might need. Higher-ed business at SPSS is significant. Rodts said about 90 percent of American universities use SPSS in one way or another, many of them for research projects similar to those carried out by RIA.

So far, at the University of Buffalo, RIA is using SPSS in only about ten of its ongoing projects. In an additional five studies, the institute is employing SPSS "in the background," by which Gogos means that researchers are using the software only to define a study's data requirements, rather than actually deploying the questionnaires via the SPSS interface.

Also, the institute has not yet implemented call-management software from SPSS. For telephone surveys, the RIA still stores its sample lists on the old DOS-based product. A homegrown bridge program -- written by Gogos in PERL using a connectivity protocol designed by Microsoft -- then transfers the information from the call management software to SPSS, which tracks and runs the surveys from that moment on. "We logged over 20,000 calls in just a few weeks, and the bridge has worked flawlessly," Gogos says.

Editor's Choice
Carrie Pallardy, Contributing Reporter
Cynthia Harvey, Freelance Journalist, InformationWeek
James M. Connolly, Contributing Editor and Writer
Mary E. Shacklett, President of Transworld Data