|
|||||
|
Just arriving? Check out Part 1 and Part 2. Link lookup list values to each variable 11. Import the question.xls and lookupEntry.xls files into a NEW MS Access database. 12. Create a relationship between the tables using the LookupID field in the lookupEntry table and the popupOptions field in the [...] This post picks up where Part 1 left off. There are two ways to open Pendragon Forms: using MS Access or the MS Access runtime if you don’t have MS Access installed. If you use the runtime, all you see is the main console where you can build forms and view data. [...] Since I started using Pendragon Forms 5.1 in 2007, my biggest gripe has been the lack of integration between Pendragon and statistical software packages like SPSS or STATA. Sure, you can export data to Excel or text files, but a lot of information is lost — namely numeric variable values and value labels.
I have posted previously about using Pendragon Forms 5.1 to conduct surveys in low resource areas (here and here). Several colleagues and I recently finished a baseline survey in northern Uganda using Forms. And I am currently helping another colleague conduct an HIV survey using Forms in rural Kenya. I learn a few [...] I found a helpful trick yesterday that saved me a lot of time preparing my SPSS data file that was exported from Pendragon Forms 5.1 (Pendragon Forms –> MS Excel –> SPSS). I don’t claim to have discovered fire or the wheel or anything, but what I learned was useful for me. If you want [...] |
I am an Associate in the Poverty, Gender and Youth Program at the Population Council and an Adjunct Assistant Professor of Global Public Health in the New York University Master's Program in Global Public Health. 
 
|
||||
|
Copyright © 2010 Eric P. Green - All Rights Reserved |
|||||