[virtualcommons-svn] SF.net SVN: virtualcommons:[101] mentalmodels/trunk/src/main/db/init-mme. sql
Status: Beta
Brought to you by:
alllee
From: <see...@us...> - 2009-04-15 00:30:27
|
Revision: 101 http://virtualcommons.svn.sourceforge.net/virtualcommons/?rev=101&view=rev Author: seematalele Date: 2009-04-15 00:30:17 +0000 (Wed, 15 Apr 2009) Log Message: ----------- cleaned the init-mme.sql Modified Paths: -------------- mentalmodels/trunk/src/main/db/init-mme.sql Modified: mentalmodels/trunk/src/main/db/init-mme.sql =================================================================== --- mentalmodels/trunk/src/main/db/init-mme.sql 2009-04-15 00:26:54 UTC (rev 100) +++ mentalmodels/trunk/src/main/db/init-mme.sql 2009-04-15 00:30:17 UTC (rev 101) @@ -49,311 +49,3 @@ insert into question_group(sequence_no) values(25,"Some final questions about the experiment"); insert into question_group(sequence_no) values(26,"Some final questions about you"); insert into question_group(sequence_no) values(27,"The end"); - - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Leaving strategy design -During a quick check of your strategy the following possible errors were found",1,0,1) - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Explain the strategy in your own words.Please explain your strategy with a few sentences. Particularly consider the following aspects: -\x95 Why did you design the strategy the way you did? What did you consider and why do you think your strategy is an adequate solution? -\x95 What actions do you expect from the other fishermen in your group? Why do you think, they might act this way? -\x95 How do you think your strategy will work? Will the fish population grow or shrink in the different bays? What earnings do you expect? -",1,0,2) - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What goals did you follow when designing your strategy? -Please specify three goals that most influenced the design of your strategy. You can select from 18 different goals grouped in three categories (foci). -First select the focus of the goal (earnings, fish population or the other fishermen). Based on this selection, the list on the right hand sight will be filled and you can select one of these goals. For the second and third most important goal, also state, how much less important they are in relation to the most important goal. -The information you write into these fields will be available the next time you edit your strategy. -",1,0,3) - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Most important goal:",2,0,3); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Second most important goal:",3,0,3); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Third most important goal:",4,0,3); - - -//Catergorial -insert into categorial(id) values(4); -insert into categorial(id) values(5); -insert into categorial(id) values(6); - -insert into categorial_choices(categorial_id,element,choices) values(4,); -insert into categorial_choices(categorial_id,element,choices) values(5); -insert into categorial_choices(categorial_id,element,choices) values(6); - - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What goals do you think the others follow? -Specify the three goals that you think most influenced the design of the strategy of the other fishermen in your group. You can select from 18 different goals grouped in three categories (foci). -First select the focus of the goal (earnings, fish population or the other fishermen). Based on this selection, the list on the right hand sight will be filled and you can select one of these goals. For the second and third most important goal, also state, how much less important they are in relation to the most important goal. -",1,0,4); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Most important goal:",2,0,4); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Second most important goal:",3,0,4); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Third most important goal:",4,0,4); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How do you perceive your group?",1,0,5); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Over all, how much do like your group (i.e. the other players)?",2,0,5); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How important is it for you what the others think about you and your behavior (i.e. your reputation in the group)?",3,0,5); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How important is it for you that the others can reach their goals (i.e. the outcomes are fair)?",4,0,5); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What do you think, how important is it for the others that you can reach your goals (i.e. the outcomes are fair)?",5,0,5); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Do you perceive the group as a team or as competing players?",6,0,5); - - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much do you count on others and how much can they count on you?",1,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much do you trust the others in your group?",2,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How important is it for you that the others in your group can and do trust you?",3,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much do you think your group trying to coordinate their actions to reach better outcomes for all?",4,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much are you trying to follow rules or agreements that emerged from the communication?",5,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much do you think the others are trying to follow rules or agreements that emerged from the communication?",6,0,6); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What else influenced your strategy design?",1,0,7); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Do you feel a sense of \x91commitment\x92 to act in the way you specified in your strategy?",2,0,7); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Would you feel any discomfort or tension if you would act differently than you specified in your strategy?",3,0,7); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Do you feel any sort of \x91social pressure\x92 to act in the way you specified in your strategy?",4,0,7); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Would you feel guilt or shame if you had acted differently than you specified in your strategy?",5,0,7); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Are you afraid of some sort of \x91punishment\x92 if you had acted differently as specified in your strategy?",6,0,7); - - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How confident are you in reaching the outcomes you are expecting?",1,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How well did you understand the dynamics of the fish population?",2,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Did the others in your group understand the dynamics better or worse than you?",3,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How confident are you in having developed a strategy that leads to \x91good\x92 outcomes regarding your goals?",4,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How much does your strategy depend on how the others in the group will act to reach the desired outcomes?",5,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Would you classify your strategy as \x91safe\x92 in the sense of having acceptable but suboptimal results for sure, or rather as \x91risky\x92 in the sense of having the optimal results if everything runs like expected or very poor results otherwise?",6,0,8); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Leaving strategy design -During a quick check of your strategy the following possible errors were found: -",1,0,9); - - - -Page 2-5-02 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What are your emotional reactions to the outcomes?",1,0,10); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"First we want to know your emotional reactions to the results:",2,0,10); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"I feel the outcomes are\x85 ",3,0,10); - -Page 2-5-03 - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What is your evaluation of the outcomes?",1,0,11); - - -Page 2-5-04 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What might be the causes for the outcomes?",1,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"I did not understand well enough the dynamics of the fish population. ",2,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Some of the other fishermen did not understand well enough the dynamics of the fish population.",3,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"The others in my group acted differently then would have been necessary for my strategy to work out well.",4,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Some of the other fishermen acted too reluctantly (harvested too few).",5,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Some of the other fishermen acted too aggressively (harvested too much).",6,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"The group acted too uncoordinated. ",7,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"The group did not follow enough the rules or agreements that emerged from the communication.",8,0,12); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"The rules or agreements that emerged from the communication did not work out well.",9,0,12); - -Page 3-1-02 - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Did the communication have any effect on you?",1,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, I now better understand the dynamics of the fish population. -",2,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, I now better understand the other fishermen in my group.",3,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, I now better understand how to design the strategy.",4,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, I now feel a \x91team spirit\x92 in the group.",5,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, I now appraise the other fishermen in my group differently. Now I think about the others",6,0,13); - -Page 3-1-03 - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What do you think were the effects of the communication on the others?",1,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, the other fishermen in my group better understand the dynamics of the fish population.",2,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, the other fishermen in my group better understand the other fishermen in my group.",3,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, the other fishermen in my group better understand how to design the strategy.",4,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, the other fishermen in my group feel a \x91team spirit\x92 in the group.",5,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Due to the conversation, the other fishermen in my group appraise the other fishermen in my group differently. Now I think about the others",6,0,13); - -Page 3-1-04 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Did the communication lead to some sort of coordination of the fishing?",1,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Did the communication have any form of reference to how to fish or design the strategy?",2,0,13); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Describe in your own words what the (maybe unclear) rule, agreement or other coordination attempt states. - De-scribe how you and the others should act and what would happen, if one does not act in this way. -If you cannot identify any sort of coordination attempt in the communication write \x93no coordination\x94 in the field below. -",3,0,13); - - -Page 3-1-5 - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What is your opinion about the rule that emerged from communication?",1,0,14); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"The rule, agreement or coordination attempt is",2,0,14); - - -Page 3-1-06 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"What will be the effects of the rule?",1,0,15); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How clear is it to you, that you have to fish conforming to this rule, agreement or coordination attempt?",2,0,15); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Do you think the other fishermen understood how they have to act according to this rule? -I think the others",3,0,15); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Will you follow the rule, agreement, or coordination attempt that emerged from communication?",4,0,15); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Do you think, the other fishermen in you group will follow the rule, agreement, or coordination attempt? -I think, the others will",5,0,15); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Considering the effects you expect for following the rule and your expectations of how the -group will follow the rule, do you think the group will do better or worse due to the rule?",6,0,15); - - -Page 3-1-07 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Lessons Learned",1,0,16); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"New understanding of fish dynamics",2,0,16); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"New expectations on how the others of the group will act",3,0,16); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Ideas for improving your strategy",4,0,16); - -Page 4-1-01 -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Some final questions about the experiment.Congratulations! You finished the actual experiment. We want to ask you some final questions.",1,0,17); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How interesting was the experiment for you?",2,0,17); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How would you rate the effort you invested to design your strategy?",3,0,17); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How difficult was it to understand the problem?",4,0,17); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How difficult was it to find a good strategy?",5,0,17); - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"How clear was it what you have to do?",6,0,17); - - -Page 4-2-1 - -insert into question(misc_location,multi_location,question,sequence_no,single_location,question_group_id) -values(0,1,"Would you have acted similarly in these real-world situations as you did in this experiment?",1,0,18); - - - - This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |