Thanks in advance for the help on this one. The logic for the study is a little complex, but I will try to simplify it here.
The study is a learning study where participants are asked to learn and memorize a social network by being exposed to questions about the relationships in the network and then learn from their mistakes. It is important that the participants be able to demonstrate mastery of the social network by being able to answer a series of 12 (randomized) questions with 100% accuracy twice (sequentially).
So, if a participant can answer all 12 questions about the social network with 100% accuracy the first time, they are asked to do so again with a "reshuffled" series of the same questions. Now, if they are 100% successful at this second series, they complete the study. If they are not 100% accurate in EITHER the first or the second series, then they must "go back to the beginning" and start anew.
Thus far, we have successfully created questionaires that will randomly ask the participants the social network questions. We have also attempted to create the Excel responses file that will aggregate the participants' answers to determine if they answered all the questions correctly. What I need help with is how to create these two "loop" structures:
IF, the participant misses one or more questions in the first series, go back to the start. Otherwise, continue to the reshuffled second series.
IF, the participant misses one or more questions in the second series, go back to the start of the first series. Otherwise, continue to the completion of the study.
Attached are the experiment, questionaires, and response Excel spreadsheet. Thanks greatly for any insight you can provide us!