Using XLS Form

Hello,

My name is Shreya and I am working at CHAI. We are looking to use ODK to collect data in one of our country offices. Can you please help me with the following questions:

  1.   We have 6 different languages that the surveys will be based in - so can I have 6 different columns will the label::language in the excel so that I only have to create document that will have the option to switch between language or would you recommend creating multiple forms?
    
  2.   We are looking at about 150 different variables/questions - would you recommend using ODK?
    
  3.   We would like to code each of our responses (for all questions, but particularly multiple choice) through numbers - how exactly could we do that? This way, we can tabulate it better in STATA afterwards.
    

Thank a lot!

Take care,
Shreya

Hello,

My name is Shreya and I am working at CHAI. We are looking to use ODK to
collect data in one of our country offices. Can you please help me with
the following questions:

  1.   We have 6 different languages that the surveys will be based in 
    

– so can I have 6 different columns will the label::language in the excel
so that I only have to create document that will have the option to switch
between language or would you recommend creating multiple forms?

  1.   We are looking at about 150 different variables/questions – 
    

would you recommend using ODK?

  1.   We would like to code each of our responses (for all questions, 
    

but particularly multiple choice) through numbers – how exactly could we do
that? This way, we can tabulate it better in STATA afterwards.

Thank a lot!

Take care,

Shreya

Dear Shreya,

If you are planning to use STATA please do have a look at odkmeta. If you
search in the group you will find the necessary links. Its a STATA module
that proved to be invaluable for importing data from the ODK output files.
Its relatively simple to use; I've used it myself for a dataset from a 350+
question household survey of 1400 respondents. If you plan on using
multiple response questions (select multiple type) you might want to look
at the STATA modules mrdum and mrtab as well.

Warm Regards

··· On Tuesday, 22 July 2014 04:51:25 UTC+6, Shreya Agrawal wrote:

Hi Shreya,

  1. One form with label::language would be the way to go.

  2. The amount of questions is not the biggest limiting factor and 150
    sounds like an amount ODK can handle.

  3. The same way you use name and label for the questions, you also use it
    for the answers.
    For example:

name,label::english,label::portuguese
1,yes,sim
2,no,não

The values in the name column will show up in the export.

For more info on XLSForm and the syntax:
http://opendatakit.org/help/form-design/xlsform/
Good luck with the project.

best,
Olaf

··· -- olaf.veerman@flipside.org http://flipside.org On Jul 21, 2014 11:51 PM, "Shreya Agrawal" wrote:

Hello,

My name is Shreya and I am working at CHAI. We are looking to use ODK to
collect data in one of our country offices. Can you please help me with
the following questions:

  1.   We have 6 different languages that the surveys will be based in
    

– so can I have 6 different columns will the label::language in the excel
so that I only have to create document that will have the option to switch
between language or would you recommend creating multiple forms?

  1.   We are looking at about 150 different variables/questions –
    

would you recommend using ODK?

  1.   We would like to code each of our responses (for all questions,
    

but particularly multiple choice) through numbers – how exactly could we do
that? This way, we can tabulate it better in STATA afterwards.

Thank a lot!

Take care,

Shreya

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.