I’m currently running a survey and am having an issue with the format of the responses I’ve downloaded.
In the survey design I named each question in my survey so it would be easier to analyse once I’d downloaded the responses. However, I only named a large number AFTER the survey was running (this was my first time using the platform for a survey!). So, when I downloaded them most rows were labelled Q1,2,3 etc., and unfortunately do not appear in the order in which they appeared in the survey (if I remember correctly when I was creating the survey questions were numbered according to the order in which they were created not their position within the survey). I’m not sure if there is a way to access the original question names (i.e. their numbers) but so far I haven’t been able to so as of right now I effectively have no idea what questions the answers I have correspond to. It’s not a huge deal for the qualitative questions as it’s easy enough to determine based on the responses, but the quantitative is another story.
I was told that responses download alphabetically according to question name but unfortunately this is not the case for my data (a question labelled ‘road accident’ appears before ‘court’ , ‘substance’ before ‘friends’ etc.). I’ve already tried everything I can think of so any and all advice/suggestions would be much appreciated!
Description of the problem: I’m currently running a survey and am having an issue with the format of the responses I’ve downloaded.
In the survey design I named each question in my survey so it would be easier to analyse once I’d downloaded the responses. However, I only named a large number AFTER the survey was running (this was my first time using the platform for a survey!). So, when I downloaded them most rows were labelled Q1,2,3 etc., and unfortunately do not appear in the order in which they appeared in the survey (if I remember correctly when I was creating the survey questions were numbered according to the order in which they were created not their position within the survey). I’m not sure if there is a way to access the original question names (i.e. their numbers) but so far I haven’t been able to so as of right now I effectively have no idea what questions the answers I have correspond to. It’s not a huge deal for the qualitative questions as it’s easy enough to determine based on the responses, but the quantitative is another story.
I was told that responses download alphabetically according to question name but unfortunately this is not the case for my data (a question labelled ‘road accident’ appears before ‘court’ , ‘substance’ before ‘friends’ etc.). I’ve already tried everything I can think of so any and all advice/suggestions would be much appreciated!
One of my students renamed her questions midway through data collection and so she has answers to the same question split across columns in the csv file.
I’ve done my best to salvage it but since she doesn’t know what the questions were named originally there’s no way to match up the split columns (unless there’s a way to see the history of a question’s name?).
At least if the questions were stored in the order they appear in the survey, then matching up might be more possible.
@wakecarter sorry to ping you directly but wondering if anyone on the team has a solution for 1) question order in downloads and 2) name changes after data collection has started? Maybe having a lock on the name once some responses have been collected, or a warning at least?
I’ve now added a warning about this to my Pavlovia guide, but if there’s a way to make sure that can’t happen in the first place that would be great.