Data entry software
Locked
 
|
The shopping survey posting has prompted me to pose a question that's been
troubling me for some time during the course of my PhD. I've been using SPSS itself in a very basic way without too much difficulty; the major problems that I have experienced have been with data entry. I'd be grateful for any thoughts of how I might do data entry better as I look towards post-doc work. I've seen very little on the list (or in the more recent archives) about the best means of inputting data into SPSS. I'm assuming that various brands of survey software are being used. With limited access to such commercial software, my own data entry method originally involved developing Excel spreadsheets and then Access data entry tables. I found that both had their shortcomings. I then managed to get a university license for Data Entry Builder. Although I found it a bit buggy, I managed to build up a considerable suite of very useful data entry tables which I have used extensively during my PhD. Data Entry Builder has now been withdrawn by IBM, who advise that they are unable to provide me with any form of future license for it. I therefore have a valuable suite of data entry tables which are unusable. Fortunately, I had completed the PhD survey work, but I can't now roll them out as I had intended in post-doc work. I'd be grateful for any thoughts as to how to either convert these tables or otherwise access them in a future-proofed format, or how I can avoid a similar situation arising when I have to replicate the tables in new survey software. Thank you Paul Sillitoe ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
For one project I've used Python/Tkinter to build my own data entry tool. That's very flexible and versatile. You can output to csv or some other simple format.
For another project I've used Joomla/LimeSurvey to collect data online. It works wel with spss, but I found it a little impractical. Cheers!!Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: Paul Sillitoe <[hidden email]> To: [hidden email] Sent: Thu, April 21, 2011 2:49:52 PM Subject: [SPSSX-L] Data entry software The shopping survey posting has prompted me to pose a question that's been troubling me for some time during the course of my PhD. I've been using SPSS itself in a very basic way without too much difficulty; the major problems that I have experienced have been with data entry. I'd be grateful for any thoughts of how I might do data entry better as I look towards post-doc work. I've seen very little on the list (or in the more recent archives) about the best means of inputting data into SPSS. I'm assuming that various brands of survey software are being used. With limited access to such commercial software, my own data entry method originally involved developing Excel spreadsheets and then Access data entry tables. I found that both had their shortcomings. I then managed to get a university license for Data Entry Builder. Although I found it a bit buggy, I managed to build up a considerable suite of very useful data entry tables which I have used extensively during my PhD. Data Entry Builder has now been withdrawn by IBM, who advise that they are unable to provide me with any form of future license for it. I therefore have a valuable suite of data entry tables which are unusable. Fortunately, I had completed the PhD survey work, but I can't now roll them out as I had intended in post-doc work. I'd be grateful for any thoughts as to how to either convert these tables or otherwise access them in a future-proofed format, or how I can avoid a similar situation arising when I have to replicate the tables in new survey software. Thank you Paul Sillitoe ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by Paul Sillitoe
Another suggestion for data entry is Epidata (http://www.epidata.dk).
There are two packages epidata entry and epidata analysis, the first one you'd need while the second one I have no experience with. I've used Epidata entry a number of times with students and professional and have encoubtered little to no problems. At first it's a bit difficult getting to know how to program it, but you quickly get the hang of it. hth On Thu, Apr 21, 2011 at 21:49, Paul Sillitoe <[hidden email]> wrote: > The shopping survey posting has prompted me to pose a question that's been > troubling me for some time during the course of my PhD. > > I've been using SPSS itself in a very basic way without too much > difficulty; the major problems that I have experienced have been with data > entry. I'd be grateful for any thoughts of how I might do data entry > better as I look towards post-doc work. > > I've seen very little on the list (or in the more recent archives) about > the best means of inputting data into SPSS. I'm assuming that various > brands of survey software are being used. > > With limited access to such commercial software, my own data entry method > originally involved developing Excel spreadsheets and then Access data > entry tables. I found that both had their shortcomings. > > I then managed to get a university license for Data Entry Builder. > Although I found it a bit buggy, I managed to build up a considerable > suite of very useful data entry tables which I have used extensively > during my PhD. > > Data Entry Builder has now been withdrawn by IBM, who advise that they are > unable to provide me with any form of future license for it. I therefore > have a valuable suite of data entry tables which are unusable. > Fortunately, I had completed the PhD survey work, but I can't now roll > them out as I had intended in post-doc work. > > I'd be grateful for any thoughts as to how to either convert these tables > or otherwise access them in a future-proofed format, or how I can avoid a > similar situation arising when I have to replicate the tables in new > survey software. > > Thank you > > Paul Sillitoe > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > -- ___________________________________________________________________ Maurice Vergeer Department of communication, Radboud University� (www.ru.nl) PO Box 9104, NL-6500 HE Nijmegen, The Netherlands Visiting Professor Yeungnam University, Gyeongsan, South Korea Recent publications: -Vergeer, M., Hermans, L., & Sams, S. (forthcoming). Online social networks and micro-blogging in political campaigning: The exploration of a new campaign tool and a new campaign style. Party Politics. -Pleijter, A., Hermans, L. & Vergeer, M. (forthcoming). Journalists and journalism in the Netherlands. In D. Weaver & L. Willnat, The Global Journalist in the 21st Century. London: Routledge. -Eisinga, R., Franses, Ph.H., & Vergeer, M. (2010). Weather conditions and daily television use in the Netherlands, 1996–2005. International Journal of Meteorology. Webspace www.mauricevergeer.nl http://blog.mauricevergeer.nl/ www.journalisteninhetdigitaletijdperk.nl maurice.vergeer (skype) ___________________________________________________________________ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
Administrator
|
We also use EpiData Entry. Generally, we have been very happy with it--it's very good for a freebie. The only problem I can remember off the top of my head was to do with exporting the data to SPSS. EpiData handles that by taking the following steps:
1. Write the data out to a text file; 2. Create an SPSS syntax file to import the data from the text file. What I found was that when there was missing data, values could end up in the wrong column after exporting to SPSS. A workaround that solves this problem is to: 1. Export from EpiData to SPSS, but only to get the syntax file this generates. 2. Export from EpiData to Excel--everything ends up in the right column here. 3. Modify the syntax from step 1 to import the Excel file rather than the text file -- all other parts of the syntax can be left as they are (e.g., variable label & value label commands). If you will be exporting the data periodically (as new cases are needed), it's a good idea to rename the syntax created above so that it does not get over-written every time you export the data. HTH.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
|
I’m not sure if EpiData has been upgraded recently but a few years ago I had an interesting problem with a user who had used EpiData / EpiInfo to create an SPSS file and we ended up with a number of variables in SPSS with the same name.
In the version they had used it was possible to create more than one variable with the same name and finding out what was happening when the data set was imported was an interesting challenge
J Best Wishes John S. Lemon DIT ( Directorate of Information Technology ) -
Student Liaison Officer Edward Wright Building: Room
G86a
Tel: +44 1224 273350 -----Original Message----- We also use EpiData Entry. Generally, we have been very happy with it--it's very good for a freebie. The only problem I can remember off the top of my head was to do with exporting the data to SPSS. EpiData handles that by taking
the following steps: 1. Write the data out to a text file; 2. Create an SPSS syntax file to import the data from the text file. What I found was that when there was missing data, values could end up in the wrong column after exporting to SPSS. A workaround that solves this problem is to: 1. Export from EpiData to SPSS, but only to get the syntax file this generates. 2. Export from EpiData to Excel--everything ends up in the right column here. 3. Modify the syntax from step 1 to import the Excel file rather than the text file -- all other parts of the syntax can be left as they are (e.g., variable label & value label commands). If you will be exporting the data periodically (as new cases are needed), it's a good idea to rename the syntax created above so that it does not get over-written every time you export the data. HTH. Maurice Vergeer wrote: > > Another suggestion for data entry is Epidata (http://www.epidata.dk). > There are two packages epidata entry and epidata analysis, the first
> one you'd need while the second one I have no experience with. > I've used Epidata entry a number of times with students and
> professional and have encoubtered little to no problems. > At first it's a bit difficult getting to know how to program it, but
> you quickly get the hang of it. > > hth > > On Thu, Apr 21, 2011 at 21:49, Paul Sillitoe > <[hidden email]> > wrote: >> The shopping survey posting has prompted me to pose a question that's
>> been troubling me for some time during the course of my PhD. >> >> I've been using SPSS itself in a very basic way without too much
>> difficulty; the major problems that I have experienced have been with
>> data entry. I'd be grateful for any thoughts of how I might do data
>> entry better as I look towards post-doc work. >> >> I've seen very little on the list (or in the more recent archives)
>> about the best means of inputting data into SPSS. I'm assuming that
>> various brands of survey software are being used. >> >> With limited access to such commercial software, my own data entry
>> method originally involved developing Excel spreadsheets and then
>> Access data entry tables. I found that both had their shortcomings. >> >> I then managed to get a university license for Data Entry Builder. >> Although I found it a bit buggy, I managed to build up a considerable
>> suite of very useful data entry tables which I have used extensively
>> during my PhD. >> >> Data Entry Builder has now been withdrawn by IBM, who advise that
>> they are unable to provide me with any form of future license for it.
>> I therefore have a valuable suite of data entry tables which are
>> unusable. >> Fortunately, I had completed the PhD survey work, but I can't now
>> roll them out as I had intended in post-doc work. >> >> I'd be grateful for any thoughts as to how to either convert these
>> tables or otherwise access them in a future-proofed format, or how I
>> can avoid a similar situation arising when I have to replicate the
>> tables in new survey software. >> >> Thank you >> >> Paul Sillitoe >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to
>> [hidden email] (not to SPSSX-L), with no body text except
>> the command. To leave the list, send the command SIGNOFF SPSSX-L For
>> a list of commands to manage subscriptions, send the command INFO
>> REFCARD >> > > > > -- > ___________________________________________________________________ > Maurice Vergeer > Department of communication, Radboud University (www.ru.nl) PO Box
> 9104, NL-6500 HE Nijmegen, The Netherlands > > Visiting Professor Yeungnam University, Gyeongsan, South Korea > > Recent publications: > -Vergeer, M., Hermans, L., & Sams, S. (forthcoming). Online social
> networks and micro-blogging in political campaigning: The exploration
> of a new campaign tool and a new campaign style. Party Politics. > -Pleijter, A., Hermans, L. & Vergeer, M. (forthcoming). Journalists
> and journalism in the Netherlands. In D. Weaver & L. Willnat, The
> Global Journalist in the 21st Century. London: Routledge. > -Eisinga, R., Franses, Ph.H., & Vergeer, M. (2010). Weather conditions
> and daily television use in the Netherlands, 1996–2005. International
> Journal of Meteorology. > > Webspace > http://blog.mauricevergeer.nl/ >
www.journalisteninhetdigitaletijdperk.nl > maurice.vergeer (skype) > ___________________________________________________________________ > > ===================== > To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except
> the command. To leave the list, send the command SIGNOFF SPSSX-L For a
> list of commands to manage subscriptions, send the command INFO
> REFCARD > ----- -- Bruce Weaver http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Data-entry-software-tp4330718p4331584.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands
to manage subscriptions, send the command INFO REFCARD The University of Aberdeen is a charity registered in Scotland, No SC013683. |
|
In reply to this post by Maurice Vergeer
It's not quite clear what the scale of data entry needs is. There are several outfits offering on-line surveys, some with tutorials and/or as scaled down freebies. See http://surveyresearch.weebly.com/on-line-surveys.html
I also have a set of syntax-based tutorials explaining the entire process of data collection. There are a couple of pieces outlining the nature of survey data and the use of computers in survey analysis followed by a step-by-step set of tutorials and exercises using a short pre-course questionnaire and ending with a saved file. They're all syntax-based rather than GUI. See: http://surveyresearch.weebly.com/block-1-from-questionnaire-to-spss-saved-file.html John Hall [hidden email] www.surveyresearch.weebly.com -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Maurice Vergeer Sent: 21 April 2011 15:41 To: [hidden email] Subject: Re: Data entry software Another suggestion for data entry is Epidata (http://www.epidata.dk). There are two packages epidata entry and epidata analysis, the first one you'd need while the second one I have no experience with. I've used Epidata entry a number of times with students and professional and have encoubtered little to no problems. At first it's a bit difficult getting to know how to program it, but you quickly get the hang of it. hth On Thu, Apr 21, 2011 at 21:49, Paul Sillitoe <[hidden email]> wrote: > The shopping survey posting has prompted me to pose a question that's been > troubling me for some time during the course of my PhD. > > I've been using SPSS itself in a very basic way without too much > difficulty; the major problems that I have experienced have been with data > entry. I'd be grateful for any thoughts of how I might do data entry > better as I look towards post-doc work. > > I've seen very little on the list (or in the more recent archives) about > the best means of inputting data into SPSS. I'm assuming that various > brands of survey software are being used. > > With limited access to such commercial software, my own data entry method > originally involved developing Excel spreadsheets and then Access data > entry tables. I found that both had their shortcomings. > > I then managed to get a university license for Data Entry Builder. > Although I found it a bit buggy, I managed to build up a considerable > suite of very useful data entry tables which I have used extensively > during my PhD. > > Data Entry Builder has now been withdrawn by IBM, who advise that they are > unable to provide me with any form of future license for it. I therefore > have a valuable suite of data entry tables which are unusable. > Fortunately, I had completed the PhD survey work, but I can't now roll > them out as I had intended in post-doc work. > > I'd be grateful for any thoughts as to how to either convert these tables > or otherwise access them in a future-proofed format, or how I can avoid a > similar situation arising when I have to replicate the tables in new > survey software. > > Thank you > > Paul Sillitoe > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > -- ___________________________________________________________________ Maurice Vergeer Department of communication, Radboud University� (www.ru.nl) PO Box 9104, NL-6500 HE Nijmegen, The Netherlands Visiting Professor Yeungnam University, Gyeongsan, South Korea Recent publications: -Vergeer, M., Hermans, L., & Sams, S. (forthcoming). Online social networks and micro-blogging in political campaigning: The exploration of a new campaign tool and a new campaign style. Party Politics. -Pleijter, A., Hermans, L. & Vergeer, M. (forthcoming). Journalists and journalism in the Netherlands. In D. Weaver & L. Willnat, The Global Journalist in the 21st Century. London: Routledge. -Eisinga, R., Franses, Ph.H., & Vergeer, M. (2010). Weather conditions and daily television use in the Netherlands, 1996–2005. International Journal of Meteorology. Webspace www.mauricevergeer.nl http://blog.mauricevergeer.nl/ www.journalisteninhetdigitaletijdperk.nl maurice.vergeer (skype) ___________________________________________________________________ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
| Free forum by Nabble | Edit this page |