Index: openacs-4/packages/beehive/sql/postgresql/beehive-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/sql/postgresql/beehive-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/sql/postgresql/beehive-create.sql 10 May 2006 05:38:45 -0000 1.1
+++ openacs-4/packages/beehive/sql/postgresql/beehive-create.sql 15 Jun 2006 05:51:20 -0000 1.2
@@ -7,16 +7,16 @@
create table beehive_tasks ( name varchar(300), num integer, problem varchar(600), forces varchar(900), rpt varchar(500), solution varchar(900) );
-create table beehive_pattern ( num serial, techniqe varchar(50), name varchar(200), roles varchar(200), mx varchar(10), mn varchar(10), df varchar(10), t2 varchar(10), t4 varchar(10), t5 varchar(10), t6 varchar(10), t7 varchar(10), t8 varchar(10), t9 varchar(10), t10 varchar(10), t11 varchar(10), t12 varchar(10), t13 varchar(10), t14 varchar(10), t15 varchar(10), t17 varchar(10), t18 varchar(10), t19 varchar(10), t20 varchar(10), t22 varchar(10), t23 varchar(10), t24 varchar(10), t26 varchar(10), t27 varchar(10), t28 varchar(10), t29 varchar(10), t30 varchar(10), t31 varchar(10), t32 varchar(10), t33 varchar(10), t34 varchar(10), t35 varchar(10), t36 varchar(10), t37 varchar(10), t38 varchar(10), adda1 varchar(10), addv1 varchar(10), adda2 varchar(10), addv2 varchar(10), adda3 varchar(10), addv3 varchar(10), ctype1 varchar(10), ctype2 varchar(10), ctype3 varchar(10), controlld1 varchar(10), controlld2 varchar(10), btype1 varchar(10), btype2 varchar(10), dtype1 varchar(10), anon1 varchar(10), anon2 varchar(10), anon3 varchar(10), anon4 varchar(10), problem varchar(200), example varchar(200), context varchar(200), gstructure varchar(200), solution varchar(700), uses varchar(200), criticalthinking varchar(10), creativethinking varchar(10), analyticalskills varchar(10), decisionmaking varchar(10), leadership varchar(10), timemanagement varchar(10), oralcommunication varchar(10), writtencommunicatoin varchar(10), reflecting varchar(10), searchingskills varchar(10), knowledgesharing varchar(10));
+create table beehive_pattern ( num serial, techniqe varchar(50), name varchar(200), roles varchar(300), mx varchar(10), mn varchar(10), df varchar(10), t2 varchar(10), t4 varchar(10), t5 varchar(10), t6 varchar(10), t7 varchar(10), t8 varchar(10), t9 varchar(10), t10 varchar(10), t11 varchar(10), t12 varchar(10), t13 varchar(10), t14 varchar(10), t15 varchar(10), t17 varchar(10), t18 varchar(10), t19 varchar(10), t20 varchar(10), t22 varchar(10), t23 varchar(10), t24 varchar(10), t26 varchar(10), t27 varchar(10), t28 varchar(10), t29 varchar(10), t30 varchar(10), t31 varchar(10), t32 varchar(10), t33 varchar(10), t34 varchar(10), t35 varchar(10), t36 varchar(10), t37 varchar(10), t38 varchar(10), adda1 varchar(10), addv1 varchar(10), adda2 varchar(10), addv2 varchar(10), adda3 varchar(10), addv3 varchar(10), ctype1 varchar(10), ctype2 varchar(10), ctype3 varchar(10), controlld1 varchar(10), controlld2 varchar(10), btype1 varchar(10), btype2 varchar(10), dtype1 varchar(10), anon1 varchar(10), anon2 varchar(10), anon3 varchar(10), anon4 varchar(10), problem varchar(200), example varchar(200), context varchar(200), gstructure varchar(200), solution varchar(3000), uses varchar(200), criticalthinking varchar(10), creativethinking varchar(10), analyticalskills varchar(10), decisionmaking varchar(10), leadership varchar(10), timemanagement varchar(10), oralcommunication varchar(10), writtencommunicatoin varchar(10), reflecting varchar(10), searchingskills varchar(10), knowledgesharing varchar(10));
-create table beehive_ses ( number varchar(30), tutor varchar(60), classname varchar(60), stype varchar(30), name varchar(200), roles varchar(100), mx varchar(10), mn varchar(10), df varchar(10), timew varchar(10), datew varchar(30), titlew varchar(200), t2 varchar(10), t4 varchar(10), t5 varchar(10), t6 varchar(10), t7 varchar(10), t8 varchar(10), t9 varchar(10), t10 varchar(10), t11 varchar(10), t12 varchar(10), t13 varchar(10), t14 varchar(10), t15 varchar(10), t17 varchar(10), t18 varchar(10), t19 varchar(10), t20 varchar(10), t22 varchar(10), t23 varchar(10), t24 varchar(10), t26 varchar(10), t27 varchar(10), t28 varchar(10), t29 varchar(10), t30 varchar(10), t31 varchar(10), t32 varchar(10), t33 varchar(10), t34 varchar(10), t35 varchar(10), t36 varchar(10), t37 varchar(10), t38 varchar(10), adda1 varchar(10), addv1 varchar(10), adda2 varchar(10), addv2 varchar(10), adda3 varchar(10), addv3 varchar(10), ctype1 varchar(10), ctype2 varchar(10), ctype3 varchar(10), controlld1 varchar(10), controlld2 varchar(10), st varchar(1000), srt varchar(1000), ih varchar(70), ig varchar(1000), el varchar(300), idn varchar(10), idt varchar(1000), it varchar(500), ynt varchar(200),sln varchar(10), btype1 varchar(10), btype2 varchar(10), dtype1 varchar(10), anon1 varchar(10), anon2 varchar(10), anon3 varchar(10), anon4 varchar(10), criticalthinking varchar(10), creativethinking varchar(10), analyticalskills varchar(10),decisionmaking varchar(10), leadership varchar(10), timemanagement varchar(10), oralcommunication varchar(10), writtencommunicatoin varchar(10),reflecting varchar(10), searchingskills varchar(10), knowledgesharing varchar(10) );
+create table beehive_ses ( number varchar(30), tutor varchar(60), classname varchar(60), stype varchar(30), name varchar(200), roles varchar(300), mx varchar(10), mn varchar(10), df varchar(10), timew varchar(10), datew varchar(30), titlew varchar(200), t2 varchar(10), t4 varchar(10), t5 varchar(10), t6 varchar(10), t7 varchar(10), t8 varchar(10), t9 varchar(10), t10 varchar(10), t11 varchar(10), t12 varchar(10), t13 varchar(10), t14 varchar(10), t15 varchar(10), t17 varchar(10), t18 varchar(10), t19 varchar(10), t20 varchar(10), t22 varchar(10), t23 varchar(10), t24 varchar(10), t26 varchar(10), t27 varchar(10), t28 varchar(10), t29 varchar(10), t30 varchar(10), t31 varchar(10), t32 varchar(10), t33 varchar(10), t34 varchar(10), t35 varchar(10), t36 varchar(10), t37 varchar(10), t38 varchar(10), adda1 varchar(10), addv1 varchar(10), adda2 varchar(10), addv2 varchar(10), adda3 varchar(10), addv3 varchar(10), ctype1 varchar(10), ctype2 varchar(10), ctype3 varchar(10), controlld1 varchar(10), controlld2 varchar(10), sessioninfo varchar(10000), roleinfo varchar(5000), ih varchar(70), groupinfo varchar(10000), el varchar(300), ideasnumber varchar(10), ideastext varchar(10000), largesharedtext varchar(5000), smallsharedtext varchar(5000),sln varchar(10), btype1 varchar(10), btype2 varchar(10), dtype1 varchar(10), anon1 varchar(10), anon2 varchar(10), anon3 varchar(10), anon4 varchar(10), criticalthinking varchar(10), creativethinking varchar(10), analyticalskills varchar(10),decisionmaking varchar(10), leadership varchar(10), timemanagement varchar(10), oralcommunication varchar(10), writtencommunicatoin varchar(10),reflecting varchar(10), searchingskills varchar(10), knowledgesharing varchar(10),solution varchar(3000) );
-create table beehive_patscript ( tname varchar(100), techniqe varchar(50), n1 integer, ins1 varchar(150), tr1 varchar(20), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(150), tr2 varchar(20), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(150), tr3 varchar(20), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(150), tr4 varchar(20), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(150), tr5 varchar(20), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(150), tr6 varchar(20), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(150), tr7 varchar(20), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(150), tr8 varchar(20), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(150), tr9 varchar(20), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(150), tr10 varchar(20), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(150), tr11 varchar(20), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(150), tr12 varchar(20), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(150), tr13 varchar(20), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(150), tr14 varchar(20), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(150), tr15 varchar(20), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(150), tr16 varchar(20), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(150), tr17 varchar(20), tl17 varchar(20), tool17 varchar(50), n18 integer, ins18 varchar(150), tr18 varchar(20), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(150), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(150), tr20 varchar(20), tl20 varchar(20), tool20 varchar(50));
+create table beehive_patscript ( tname varchar(100), techniqe varchar(50), n1 integer, ins1 varchar(500), tr1 varchar(100), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(500), tr2 varchar(100), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(500), tr3 varchar(100), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(500), tr4 varchar(100), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(500), tr5 varchar(100), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(500), tr6 varchar(100), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(500), tr7 varchar(100), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(500), tr8 varchar(100), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(500), tr9 varchar(100), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(500), tr10 varchar(100), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(500), tr11 varchar(100), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(500), tr12 varchar(100), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(500), tr13 varchar(100), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(500), tr14 varchar(100), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(500), tr15 varchar(100), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(500), tr16 varchar(100), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(500), tr17 varchar(100), tl17 varchar(100), tool17 varchar(50), n18 integer, ins18 varchar(500), tr18 varchar(100), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(500), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(500), tr20 varchar(100), tl20 varchar(20), tool20 varchar(50), n21 integer, ins21 varchar(500), tr21 varchar(100), tl21 varchar(20), tool21 varchar(50), n22 integer, ins22 varchar(500), tr22 varchar(100), tl22 varchar(20), tool22 varchar(50), n23 integer, ins23 varchar(500), tr23 varchar(100), tl23 varchar(20), tool23 varchar(50), n24 integer, ins24 varchar(500), tr24 varchar(100), tl24 varchar(20), tool24 varchar(50), n25 integer, ins25 varchar(500), tr25 varchar(100), tl25 varchar(20), tool25 varchar(50));
-create table beehive_emptypatscript ( tname varchar(100), techniqe varchar(50), n1 integer, ins1 varchar(150), tr1 varchar(20), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(150), tr2 varchar(20), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(150), tr3 varchar(20), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(150), tr4 varchar(20), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(150), tr5 varchar(20), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(150), tr6 varchar(20), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(150), tr7 varchar(20), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(150), tr8 varchar(20), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(150), tr9 varchar(20), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(150), tr10 varchar(20), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(150), tr11 varchar(20), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(150), tr12 varchar(20), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(150), tr13 varchar(20), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(150), tr14 varchar(20), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(150), tr15 varchar(20), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(150), tr16 varchar(20), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(150), tr17 varchar(20), tl17 varchar(20), tool17 varchar(50), n18 integer, ins18 varchar(150), tr18 varchar(20), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(150), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(150), tr20 varchar(20), tl20 varchar(20), tool20 varchar(50));
+create table beehive_emptypatscript ( tname varchar(100), techniqe varchar(50), n1 integer, ins1 varchar(150), tr1 varchar(20), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(150), tr2 varchar(20), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(150), tr3 varchar(20), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(150), tr4 varchar(20), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(150), tr5 varchar(20), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(150), tr6 varchar(20), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(150), tr7 varchar(20), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(150), tr8 varchar(20), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(150), tr9 varchar(20), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(150), tr10 varchar(20), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(150), tr11 varchar(20), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(150), tr12 varchar(20), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(150), tr13 varchar(20), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(150), tr14 varchar(20), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(150), tr15 varchar(20), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(150), tr16 varchar(20), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(150), tr17 varchar(20), tl17 varchar(20), tool17 varchar(50), n18 integer, ins18 varchar(150), tr18 varchar(20), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(150), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(150), tr20 varchar(20), tl20 varchar(20), tool20 varchar(50), n21 integer, ins21 varchar(500), tr21 varchar(100), tl21 varchar(20), tool21 varchar(50), n22 integer, ins22 varchar(500), tr22 varchar(100), tl22 varchar(20), tool22 varchar(50), n23 integer, ins23 varchar(500), tr23 varchar(100), tl23 varchar(20), tool23 varchar(50), n24 integer, ins24 varchar(500), tr24 varchar(100), tl24 varchar(20), tool24 varchar(50), n25 integer, ins25 varchar(500), tr25 varchar(100), tl25 varchar(20), tool25 varchar(50));
-create table beehive_sesscript ( number varchar(50), n1 integer, ins1 varchar(150), tr1 varchar(20), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(150), tr2 varchar(20), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(150), tr3 varchar(20), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(150), tr4 varchar(20), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(150), tr5 varchar(20), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(150), tr6 varchar(20), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(150), tr7 varchar(20), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(150), tr8 varchar(20), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(150), tr9 varchar(20), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(150), tr10 varchar(20), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(150), tr11 varchar(20), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(150), tr12 varchar(20), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(150), tr13 varchar(20), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(150), tr14 varchar(20), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(150), tr15 varchar(20), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(150), tr16 varchar(20), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(150), tr17 varchar(20), tl17 varchar(20), tool17 varchar(50), n18 integer, ins18 varchar(150), tr18 varchar(20), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(150), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(150), tr20 varchar(20), tl20 varchar(20), tool20 varchar(50) );
+create table beehive_sesscript ( number varchar(50), n1 integer, ins1 varchar(500), tr1 varchar(100), tl1 varchar(20), tool1 varchar(50), n2 integer, ins2 varchar(500), tr2 varchar(100), tl2 varchar(20), tool2 varchar(50), n3 integer, ins3 varchar(500), tr3 varchar(100), tl3 varchar(20), tool3 varchar(50), n4 integer, ins4 varchar(500), tr4 varchar(100), tl4 varchar(20), tool4 varchar(50), n5 integer, ins5 varchar(500), tr5 varchar(100), tl5 varchar(20), tool5 varchar(50), n6 integer, ins6 varchar(500), tr6 varchar(100), tl6 varchar(20), tool6 varchar(50), n7 integer, ins7 varchar(500), tr7 varchar(100), tl7 varchar(20), tool7 varchar(50), n8 integer, ins8 varchar(500), tr8 varchar(100), tl8 varchar(20), tool8 varchar(50), n9 integer, ins9 varchar(500), tr9 varchar(100), tl9 varchar(20), tool9 varchar(50), n10 integer, ins10 varchar(500), tr10 varchar(100), tl10 varchar(20), tool10 varchar(50), n11 integer, ins11 varchar(500), tr11 varchar(100), tl11 varchar(20), tool11 varchar(50), n12 integer, ins12 varchar(500), tr12 varchar(100), tl12 varchar(20), tool12 varchar(50), n13 integer, ins13 varchar(500), tr13 varchar(100), tl13 varchar(20), tool13 varchar(50), n14 integer, ins14 varchar(500), tr14 varchar(100), tl14 varchar(20), tool14 varchar(50), n15 integer, ins15 varchar(500), tr15 varchar(100), tl15 varchar(20), tool15 varchar(50), n16 integer, ins16 varchar(500), tr16 varchar(100), tl16 varchar(20), tool16 varchar(50), n17 integer, ins17 varchar(500), tr17 varchar(100), tl17 varchar(100), tool17 varchar(50), n18 integer, ins18 varchar(500), tr18 varchar(100), tl18 varchar(20), tool18 varchar(50), n19 integer, ins19 varchar(500), tr19 varchar(20), tl19 varchar(20), tool19 varchar(50), n20 integer, ins20 varchar(500), tr20 varchar(100), tl20 varchar(20), tool20 varchar(50), n21 integer, ins21 varchar(500), tr21 varchar(100), tl21 varchar(20), tool21 varchar(50), n22 integer, ins22 varchar(500), tr22 varchar(100), tl22 varchar(20), tool22 varchar(50), n23 integer, ins23 varchar(500), tr23 varchar(100), tl23 varchar(20), tool23 varchar(50), n24 integer, ins24 varchar(500), tr24 varchar(100), tl24 varchar(20), tool24 varchar(50), n25 integer, ins25 varchar(500), tr25 varchar(100), tl25 varchar(20), tool25 varchar(50) );
insert into beehive_emptypatscript (n1) values (1);
@@ -45,11 +45,16 @@
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Defining the objective of the session/Title',11, 'How can all session students view the main objective, title, or problem statement in clear way inside and outside session stage ?','facilitator needs to write down the objective, title, or problem statement in a very clear way so students can easily recognize and understand.',' Provide a separate text box with its own heading, so facilitator can type the title statement. Learners will engage in a session by clicking on the title. ','Mandatory in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing the session Info',12, 'How can all session participants be provided with the same detailed information, explanation, and any supplementary information needed to conduct the desired collaborative activity ?','Usually when learners anticipates in a session, title or purpose might not be sufficient to understand the problem',' Provide a separate info text box to hold the information provided by facilitator in the design time. Students can view the information from the sessions information page before and during the session. ','Optional in all pedagogical techniques');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing the session Info',12, 'How can all session participants be provided with the same detailed information, explanation, and any supplementary information needed to conduct the desired collaborative activity ?','Usually when learners anticipates in a session, title or purpose might not be sufficient to understand the problem',' Provide a separate info text box to hold the information provided by facilitator in the design time. Students can view the information. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing info/tasks to a Role',13, 'How can a specific role participants be provided with certain information needed to conduct their role?','In some techniques, certain information should be passed to certain roles ' ,' Provide a separate info text box to hold the sub info provided by facilitator in the design time. The facilitator should also specify the target of each sub info. Students can only view the information that matches their roles from the sessions info page. ','Usually in the Jigsaw, Role Playing techniques ');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing info/tasks to a Role',13, 'How can a specific role participants be provided with certain information needed to conduct their role?','In some techniques, certain information should be passed to certain roles ' ,' Provide a separate info text box to hold the sub info provided by facilitator in the design time. The facilitator should also specify the target of each sub info. Students can only view the information that matches their roles. ','Usually in the Jigsaw, Role Playing techniques ');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing info/tasks to a group',4, 'How can a specific group participants be provided with certain information needed to conduct their tasks?','In some techniques, certain information should be passed to certain group ' ,' Provide a separate info text box to hold the sub info provided by facilitator in the design time. The facilitator should also specify the target of each sub info. Students can only view the information that matches theirgroup number ','Usually in the buzz group technique ');
+
+
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Side note taking',31, 'How can learners to prepare and organize their thoughts during the session before presenting them to others?','Learner are required specially at the beginning of the session to think privately about a topic, problem, etc and to write down them down in a private box which will make it easier to copy to a chat box during the session ' ,'Provide learners with a text box where they can write down their notes and ideas during the session. ','Optional in all pedagogical techniques');
+
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing the session resource file',32, 'How can session participants be provided with more information from the facilitator ?','Occasionally, more information is needed to conduct the desired session ' ,' Provide a separate info text box to hold the uploaded file provided by facilitator in the design time and to be shown to students at run time at the session info page. ','Optional in all pedagogical techniques');
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing a staged resource',33, 'How can media/animation/information be provided on a certain step during the session ?','Occasionally during the session, facilitator would like to show information after students had finished a certain step and might be followed by another activity step ' ,' Provide a separate text link to hold the links which will be shown to students on the session stage at the specific step. ','Usually in the Video viewing, Case study techniques');
@@ -64,28 +69,28 @@
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Giving a brief vocal overview',15, 'How can facilitator provide an audio overview at the beginning of the collaboration activity?','For learners who are new in using and conducting online sessions, it will help if the facilitator provide a short vocal overview of what learners need to do on that session' ,'Provide an audio tool that will be used by a facilitator to deliver his vocal overview and textfields that contain all session information and scenario. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Presenting a question',17, 'similar to face-to-face sessions, how can a facilitator ask questions?','In some techniques, teacher start the session by presents a question to students which will be followed by another step, such as sharing that answer with peers ' ,'Provide a dynamic text box to hold the facilitator question and a selection list to choose the target that will receive that question. Also an answer box for the students to send their answers. Finally a shared box to hold the answers of all the students with the ability to shows these answers to all students . ','Think-pair-share');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Presenting a question',17, 'similar to face-to-face sessions, how can a facilitator ask questions?','In some techniques, teacher start the session by presents a question to students which will be followed by another step, such as sharing that answer with peers ' ,'Provide an answer box for the students to send their answers. A shared box to hold the answers of all the students. ','Think-pair-share');
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Results Evaluation',19, 'How can a facilitator evaluate participants results?','Evaluation is an essential part at any teaching/learning process ' ,'Provide facilitators with a tool that contains: a text box to hold facilitators evaluation. All evaluation comments will be saved in a repository for any further review by the learners. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Small group discussions',22, 'How can a group of learners participate in a text/audio discussion chat ?','Many activities imply that participants collaborate by using text/audio/video communication, to allow users to engage in multimedia-messaging conference. The chat transcript is saved at a repository for further review and assessments. Some sessions need to anonymous to ease the social pressure ' ,'Provide learners with a chat box/audio/video where participants can contribute during the session. The turn for sending the contributions is defined by the facilitator during the design. ','Optional in all pedagogical techniques');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Small group discussions',22, 'How can a group of learners participate in a text/audio discussion chat ?','Many activities imply that participants collaborate by using text/audio/video communication, to allow users to engage in multimedia-messaging conference. The chat transcript is saved at a repository for further review and assessments. Some sessions need to anonymous to ease the social pressure ' ,'Provide learners with a chat box/audio where participants can contribute during the session. The turn for sending the contributions is defined by the facilitator during the design. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Entire session discussions',23, 'How can the entire learners in session participate in a text/audio discussion chat ?','Many activities imply that all participants collaborate by using text/audio/video communication to allow all users to share ideas among the entire session. ' ,'Provide learners with a chat box/audio/video where all participants can contribute during the session. ','Optional in all pedagogical techniques');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Entire session discussions',23, 'How can the entire learners in session participate in a text/audio discussion chat ?','Many activities imply that all participants collaborate by using text/audio communication to allow all users to share ideas among the entire session. ' ,'Provide learners with a chat box/audio/video where all participants can contribute during the session. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Similar roles discussions',24, 'How can learners with same roles discuss an issues between themselves ?','Some activities imply that certain roles need to discuss an issue , expert group, among themselves before sharing their knowledge with their original group' ,'Provide learners with a chat box/audio/video where only learners with similar roles can access the floor. ','Jigsaw ');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Similar roles discussions',24, 'How can learners with same roles discuss an issues between themselves ?','Some activities imply that certain roles need to discuss an issue , expert group, among themselves before sharing their knowledge with their original group' ,'Provide learners with a chat box/audio where only learners with similar roles can access the floor. ','Jigsaw ');
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Introducing each other /Ice breakering',27, 'How can learners introduce themselves to others ?','Usually, facilitator likes learners to introduce themselves before starting the activity ' ,'Provide learners with a chat box/audio/video where only learners within the same group can access . ','Optional in all pedagogical techniques ');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Individual writing /notes preparation',28, 'How can learners to prepare and organize their thoughts before presenting it to others?','Learner are required specially at the beginning of the session to think privately about a topic, problem, etc and to write down them down in a private box which will make it easier to copy to a chat box during the activity ' ,'Provide learners with a text box where they can write down their notes and ideas during that step. ','Optional in all pedagogical techniques');
+
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Submitting own resolution/conclusion to facilitator',30, 'How can learners submit the summary of their results as a group to the facilitator?','Many activities imply that groups should submit their results to the facilitator for assessments ' ,'Provide learners with a send box where they can submit their results on the end of the session. ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Silent/Private thinking',31, 'How can learners think individually about an issue ?','Many activities imply that learners should start thinking privately on a posted issue before engaging in a group activity ' ,'Provide learners with an empty page headed by the facilitator question. facilitator can post their question in a dynamic box ','Optional in all pedagogical techniques');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Silent/Private thinking',28, 'How can learners think individually about an issue ?','Many activities imply that learners should start thinking privately on a posted issue before engaging in a group activity ' ,'Provide learners with an empty page headed by the facilitator question. facilitator can post their question in a dynamic box ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Submitting own resolution/conclusion to facilitator',29, 'How can learners submit their own results to the facilitator?','Many activities imply that learners should submit their results to the facilitator for assessments ' ,'Provide learners with a send box where they can submit their own results at the end of the session. ','Optional in all pedagogical techniques');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Submitting own resolution/conclusion to others',29, 'How can learners submit their own results to other groups ?','Many activities imply that learners should submit their results to other groups for sharing the findings ' ,'Provide learners with a send box where they can submit their own results ','Optional in all pedagogical techniques');
-insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ( 'Debriefing',34, 'How can facilitators make a debriefing ?','Some activities imply that facilitator make a debriefing after learners engaged in a group discussion ' ,'Provide facilitators with a chat box where he can send his debriefing to all learners participating in that session. ','Role Playing');
+insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ( 'Debriefing',34, 'How can facilitators make a debriefing ?','Some activities imply that facilitator make a debriefing after learners engaged in a group discussion ' ,'Provide facilitators with a chat box and audio where he can send his debriefing to all learners participating in that session. ','Role Playing');
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Ideas voting',35, 'How can learners vote on posted ideas to select the best idea?','Some activities imply that participants should select a single idea to come up with the best solution. ' ,'Provide learners with a voting tool where he can assign marks with ideas scale (0-10). All member can see ideas marks. If the source of ideas is the facilitator, then he should provide these ideas during the design time, but if the ideas source is learners then ideas will be collected from the idea listing tool ','Usually in the Nomination Group Technique');
@@ -117,78 +122,95 @@
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1) values ('Group Discussion', 'default',1,'start discussion ','all','000600','SmallGroupDisscussion');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Group Discussion', 'default',1,'read related info ','all','000500','SessionInfo',2,'start discussion','all','001000','SmallGroupDisscussion');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Group Discussion','default','participant', '5','5','5','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'How to establish and encourage group knowledge sharing among students ', 'Discussing how to improve writing and speaking skills for a foreigner student ', 'Small groups with different skills and backgrounds interact to develop more knowledge among them ','Size: usually 5Structure: participants(5) ', '1- Teacher specify the discussion topic and the time.2- Student will start discussion according to their experience and may build upon others knowledge3- Teacher will guide the discussion when needed','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'Knowledge sharing','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Group Discussion','default','participant', '5','5','5','checked' ,'checked','How to establish and encourage group knowledge sharing among students ', 'Discussing how to improve writing and speaking skills for a foreigner student ', 'Small groups with different skills and backgrounds interact to develop more knowledge among them ','Size: usually 5Structure: participants(5) ', '1- Teacher specify the discussion topic and related info.2- All student will start discussion according to their experience and may build upon others knowledge','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'Knowledge sharing','checked','checked','checked');
insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5 ) values ('Round Table discussion', 'default',1,' ','participant1','000200','SmallGroupDisscussion',2,' ','participant2','000200','SmallGroupDisscussion',3,' ','participant3','000200','SmallGroupDisscussion',4,' ','participant5','000200','SmallGroupDisscussion',5,' ','participant5','000200','SmallGroupDisscussion');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin ) values ('Round Table discussion','default','participant1/participant2/participant3/participant4/participant5', '5','5','5','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ','How to motivate balance participations across all members ','Discussing the advantages of E-Learning ','Generating new abstract understanding by enabling balance knowledge-sharing ','Size: usually 5Structure: participant1, participant2, participant3, participant4, participant5', '1- Teacher specify the discussion topic and the time.2- The first student on the list will be enabled to post a response then the next student will be enabled and so on3- Teacher will guide the discussion when needed ','checked','checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Knowledge sharing with a balanced participation','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin ) values ('Round Table discussion','default','participant1/participant2/participant3/participant4/participant5', '5','5','5','checked','How to motivate balance participations across all members ','Discussing the advantages of E-Learning ','Generating new abstract understanding by enabling balance knowledge-sharing ','Size: usually 5Structure: participant1, participant2, participant3, participant4, participant5', '1- The first student on the list will be enabled to post a response 2- the next student will be enabled and so on','checked','checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Knowledge sharing with a balanced participation','checked','checked','checked');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4) values ('Group Nomination technique', 'default',1,'start brainstorming','all','001000','IdeasPosting',2,'start discussion the ideas','all','000600','IdeasDiscussion',3,'vote on ideas','all','000100','IdeasVoting',4,'submit the result based on ideas rating','chairperson','000200','Summarizing');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4) values ('Group Nomination technique', 'default',1,'start brainstorming','all','001000','IdeasPosting',2,'start discussion the ideas','all','000600','IdeasDiscussion',3,'vote on ideas','all','000100','IdeasVoting',4,'submit the result based on ideas rating','chairperson','000200','OwnResolution');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, creativethinking, analyticalskills, decisionmaking, leadership, timemanagement , oralcommunication , writtencommunicatoin
-) values ('Group Nomination technique','default','chairperson/participant', '5','5','5','checked','checked','checked',' ',' ','checked','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ','checked',' ',' ',' ',' ','checked',' ',' ','checked','checked',' ',' ','checked',' ','A certain topic or problem without a specific solution whose resolution implies not only creating ideas or solution, but also choosing the best idea ','Generating and selecting a website project title for an E business course ','Suitable for organizational decision making where different people with different skills and knowledge participating in creating, discussing, and then selecting. ','Size: usually 5Structure: chairperson, participants(4)
-time: 20 min ', '1- Teacher gives students a specific period of time for posting their ideas; no criticism or elaboration is allowed in this stage.2- The next stage is discussing each recorded idea to obtain clarification and evaluation3- Student is asked to assign a mark for each idea 4- Finally the chairperson or leader of the group will submit the result based on ideas rating to the teacher for further evaluation','checked','checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ','Creating and choosing the best ideas/solutions ','checked','checked','checked','checked','checked','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t26,t38,t35,t29,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, creativethinking, analyticalskills, decisionmaking, leadership, timemanagement , oralcommunication , writtencommunicatoin
+) values ('Group Nomination technique','default','chairperson/participant', '5','5','5','checked','checked','checked','checked','A certain topic or problem without a specific solution whose resolution implies not only creating ideas or solution, but also choosing the best idea ','Generating and selecting a website project title for an E business course ','Suitable for organizational decision making where different people with different skills and knowledge participating in creating, discussing, and then selecting. ','Size: usually 5Structure: chairperson, participants(4)
+time: 20 min ', '1- posting ideas; no criticism or elaboration is allowed in this stage.2- The next stage is discussing each recorded idea to obtain clarification and evaluation3- participant is asked to assign a mark for each idea 4- reporting the result based on ideas rating to other groups (by chairperson)','',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ','Creating and choosing the best ideas/solutions ','checked','checked','checked','checked','checked','checked','checked','checked');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1) values ('Brainstorm', 'default',1,'start brainstorming','all','001000','IdeasPosting');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Brainstorm', 'default',1,'read related info ','all','000500','SessionInfo',2,'start brainstorming','all','001000','IdeasPosting');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4, uses,creativethinking, timemanagement, writtencommunicatoin ) values ('Brainstorm','default','participant', '5','5','5','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','A certain topic or problem without a specific solution whose resolution implies generating many ideas form all members in short time ','Generating different solutions for the reduction of electrical bills ','Motivate group to generate many creative new ideas and solutions by not allowing criticism or elaboration ','Size: usually 5Structure: participants(5)
-time: 20 min ', '1- Teacher gives students a specific period of time for posting their ideas; no criticism or elaboration is allowed in this stage.',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Ideas creation in a short period','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t26,t12,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4, uses,creativethinking, timemanagement, writtencommunicatoin ) values ('Brainstorm','default','participant', '5','5','5','checked','checked','A certain topic or problem without a specific solution whose resolution implies generating many ideas form all members in short time ','Generating different solutions for the reduction of electrical bills ','Motivate group to generate many creative new ideas and solutions by not allowing criticism or elaboration ','Size: usually 5Structure: participants(5)
+time: 20 min ', '1- Teacher gives students a background info 2- participants starts posting their ideas; no criticism or elaboration is allowed in this stage.',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Ideas creation in a short period','checked','checked','checked');
-insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8 ) values ('Debate', 'default',1,'Propose the motion','proposer','000500','SmallGroupDisscussion',2,'Second the Proposer','seconder(p)','000300','SmallGroupDisscussion',3,'Oppose the motion','opposer','000500','SmallGroupDisscussion',4,'Second the Opposer','seconder(o)','000300','SmallGroupDisscussion',5,'Speak From The Floor','speakers','001000','SmallGroupDisscussion',6,'Sum up for the motion','proposer','000300','SmallGroupDisscussion',7,'Sum up for the opposition','opposer','000300','SmallGroupDisscussion',8,'Vote','all','000100','YesNo');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, decisionmaking) values ('Debate','default','proposer/seconder(p)/opposer/seconder(o)/speakers','10','10','10','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: proposer, second proposer, opposer, second opposer, speakers(6)
+
+insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8 ) values ('Debate', 'default',1,'Propose the motion','proposer','000500','SmallGroupDisscussion',2,'Second the Proposer','seconder(p)','000300','SmallGroupDisscussion',3,'Oppose the motion','opposer','000500','SmallGroupDisscussion',4,'Second the Opposer','seconder(o)','000300','SmallGroupDisscussion',5,'Speak From The Floor','speakers','001000','SmallGroupDisscussion',6,'Sum up for the motion','proposer','000300','SmallGroupDisscussion',7,'Sum up for the opposition','opposer','000300','SmallGroupDisscussion',8,'Do you support the proposor','all','000100','YesNo');
+
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,t36,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, decisionmaking) values ('Debate','default','proposer/seconder(p)/opposer/seconder(o)/speakers','10','10','10','checked','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: proposer, second proposer, opposer, second opposer, speakers(6)
time: 36min ', '1- Proposer will propose the motion2- The second proposer will second the proposer 3- The opposer will oppose the motion4- The second opposer will second the opposer5- Speakers will participate from The floor6- The proposer will sum up for the motion7- The opposer will sum up for the opposition8- Voting on a particular side',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' A controversial topic clarification or decision making','checked','checked','checked','checked' );
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Jigsaw', 'default',1,'study a particular sub problem','all','001000','IndividualWriting',2,'exchanging ideas with your expert groups ','all','001000','RolesDisscussion',3,'jigsaw group participants meet to solve the whole problem','all','001500','SmallGroupDisscussion');
+insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8 ) values ('Problem Based Learning PBL', 'default',1,'Read the problem description ','all','000500','SessionInfo',2,'Identify concept and parts of the problem that needs clarification','all','000300','SilentThinking',3,'Define the problem','all','000500','SilentThinking',4,'Brainstorm about solutions','all','000300','IdeasPosting',5,'Structure solutions or causes','all','001000','SilentThinking',6,'state learning objectives','all','000300','SilentThinking',7,'Self study directed towards learning objectives ','all','001300','InternetSearch',8,'report things learned and application to problem','all','001000','SmallGroupSharedText');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Jigsaw','default',' ', '5','5','5','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ','checked',' ',' ',' ',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','A complex problem whose resolution requires handling information that can be divided in disjoint sets and used for the resolution of independent sub problems ','Collaborative Design of a computer system, where each subsystem is assigned to an individual ','Several small groups facing the study of a large amount of information for the resolution of the same problem','Size: usually 5 ', '1- Teacher gives a specific period of time for each participant in the group (jigsaw group) to study a particular sub problem.2- The participants of different groups that study the same problem meet in Òexpert groupsÓ for exchanging ideas3- At last, jigsaw group participants meet to solve the whole problem',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Complex Problem solving','checked','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t6,t12,t26,t37,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Problem Based Learning PBL','default','participant','5','5','5','checked','checked','checked','checked', '1- Reading the problem description 2- Identifying concept and parts of the problem that needs clarification 3- Defining the problem 4- Brainstorming about solutions 5- Structuring solutions or causes 6- stating learning objectives 7- Self studying directed towards learning objectives 8- reporting things learned and application to problem',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' to actively involve with problems coming from real practice','checked','checked','checked' );
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Pro/Contra', 'default',1,'study a particular issue side ','all','001000','IndividualWriting',2,'exchanging ideas with your side group ','all','001000','RolesDisscussion',3,'the whole group participants meet to discuss and argue','all','001500','SmallGroupDisscussion');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,dtype1,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Pro/Contra','default','Pro/Contra/Pro/Contra/Pro/Contra/Pro/Contra/Pro/Contra', '10','10','10','checked','checked','checked',' ',' ',' ','checked',' ','checked','checked',' ',' ',' ',' ',' ',' ',' ','checked',' ',' checked',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ','Motivate ','Size: usually 10Structure: Pro(5), Contra(5) ', '1- Teacher gives a specific period of time for each participant in the group to study a particular side of an issue.2- Each side start their own discussion.3- When the discussion is completed the result is shared and discussed with the other side group',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked','Understanding and presenting different sides views','checked','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Jigsaw', 'default',1,'study a particular sub problem','all','001000','RoleInfo',2,'exchanging ideas with your expert groups ','all','001000','RolesDisscussion',3,'jigsaw group participants meet to solve the whole problem','all','001500','SmallGroupDisscussion');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Think Pair Share', 'default',1,'think silently about question posed ','all','001000','QA',2,'exchanging ideas with your partner','all','001000','SmallGroupDisscussion',3,'exchange ideas with the whole session','all','001500','LargeGroupDisscussion');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,t13,t24,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Jigsaw','default',' ', '5','5','5','checked','checked','checked','A complex problem whose resolution requires handling information that can be divided in disjoint sets and used for the resolution of independent sub problems ','Collaborative Design of a computer system, where each subsystem is assigned to an individual ','Several small groups facing the study of a large amount of information for the resolution of the same problem','Size: usually 5 ', '1- Teacher gives a specific period of time for each participant in the group (jigsaw group) to study a particular sub problem.2- The participants of different groups that study the same problem meet in expert groups for exchanging ideas3- At last, jigsaw group participants meet to solve the whole problem','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Complex Problem solving','checked','checked','checked','checked');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Think Pair Share', 'default','participant', '2','2','2','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ',' ',' ', 'checked',' ',' ',' ', 'checked', 'checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ',' ','Size: usually 2', '1- Each participant think silently about question posed.2- Individual pair up during the second step and exchange thoughts3- The pair share their responses with the entire group',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection, peer discussion and groups solutions sharing','checked','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Pro/Contra', 'default',1,'study a particular issue side ','all','001000','RoleInfo',2,'exchanging ideas with your side group ','all','001000','RolesDisscussion',3,'the whole group participants meet to discuss and argue','all','001500','SmallGroupDisscussion');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,t13,t24,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,dtype1,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Pro/Contra','default','Pro/Contra/Pro/Contra/Pro/Contra/Pro/Contra/Pro/Contra', '10','10','10','checked','checked','checked','Motivate ','Size: usually 10Structure: Pro(5), Contra(5) ', '1- Teacher gives a specific period of time for each participant in the group to study a particular side of an issue.2- Each side start their own discussion.3- When the discussion is completed the result is shared and discussed with the other side group','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked','Understanding and presenting different sides views','checked','checked','checked','checked');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Pyramid', 'default',1,'think silently about question posed ','all','001000','QA',2,'exchanging ideas with your partners','all','001000','SmallGroupDisscussion',3,'exchange ideas with the whole session','all','001500','LargeGroupDisscussion');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Pyramid', 'default','participant', '5','5','5','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ',' ',' ', 'checked',' ',' ',' ', 'checked', 'checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ',' ',' ', '1- Each participant think silently about question posed.2- Individual exchange thoughts with their group3- Then they shared responses with the entire session',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection and then multiple levels of group discussion and explanation','checked','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Think Pair Share', 'default',1,'think silently about this question ','all','001000','SessionInfo',2,'exchanging ideas with your partner','all','001000','SmallGroupDisscussion',3,'exchange ideas with the whole session','all','001500','LargeGroupDisscussion');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,t23,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Think Pair Share', 'default','participant', '2','2','2','checked','checked','checked','Size: usually 2', '1- Each participant think silently about question posed.2- Individual pair up during the second step and exchange thoughts3- The pair share their responses with the entire group','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection, peer discussion and groups solutions sharing','checked','checked','checked','checked');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Buzz Group', 'default',1,'exchanging ideas with your partners','all','001000','SmallGroupDisscussion',2,'submit your own resolution','chairperson','001500','Summarizing');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, leadership) values ('Buzz Group', 'default','chairperson/participant', '5','3','3','checked','checked','checked',' ',' ',' ',' ',' ','',' ',' ',' ',' ', '',' ',' ',' ', 'checked', ' ',' ',' ',' ',' ',' ','checked ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ',' ',' ', '1- Individual exchange thoughts with their group. 2- Each group should submit his own resolution',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','A topic group discussion for a short period to gather potential solutions to a problem','checked','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Pyramid', 'default',1,'think silently about question posed ','all','001000','SessionInfo',2,'exchanging ideas with your partners','all','001000','SmallGroupDisscussion',3,'exchange ideas with the whole session','all','001500','LargeGroupSharedText');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Role Playing', 'default',1,'each role should start role palying ','all','001000','SmallGroupDisscussion',2,'Debrifing','all','000300','Debriefing');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,t10,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Pyramid', 'default','participant', '5','5','5','checked','checked','checked', '1- Each participant think silently about question posed.2- Individual exchange thoughts with their group3- Then they shared responses with the entire session','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection and then multiple levels of group discussion and explanation','checked','checked','checked','checked');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills, oralcommunication) values ('Role Playing', 'default','role1/role2/audience', '5','5','5',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ', ' ',' ',' ',' ', 'checked', ' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ',' ',' ', '1- Each participant with a role start acting.2- facilitator and participants discuss the situation and various perspective of the individual characters ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Training/ Understanding the different aspects of a topic ','checked','checked','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Buzz Group', 'default',1,'reading the group info','all','001000','GroupInfo',2,'exchanging ideas with your partners','all','001000','SmallGroupDisscussion',3,'submit your own resolution','chairperson','001500','LargeGroupSharedText');
-insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Case Studes', 'default',1,'read/watch the uploaded file','all','002000','DynamicLink',2,'make a respond to a question based on the material','all','000300','QA');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t10,t4,t22,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, leadership) values ('Buzz Group', 'default','chairperson/participant', '5','3','3','checked','checked','checked', '1- Individual exchange thoughts with their group. 2- Each group should submit his own resolution','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','A topic group discussion for a short period to gather potential solutions to a problem','checked','checked','checked','checked');
+
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Role Playing', 'default',1,'each role read his info','all','001000','RoleInfo',2,'each role should start role palying ','all','001000','SmallGroupDisscussion',3,'Debrifing','all','000300','Debriefing');
+
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t13,t22,t34,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills, oralcommunication) values ('Role Playing', 'default','role1/role2/audience', '5','5','5','checked','checked','checked', '1- Each participant with a role start acting.2- facilitator and participants discuss the situation and various perspective of the individual characters ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Training/ Understanding the different aspects of a topic ','checked','checked','checked','checked','checked');
+
+
+`insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Case Studes', 'default',1,'read/watch the uploaded file','all','002000','DynamicLink',2,'question 1','all','000300','QA',3,'question 2','all','000300','QA');
+
+
+
+
insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses, timemanagement, writtencommunicatoin, analyticalskills) values ('Case Studes', 'default','participant', '5','5','5',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'checked',' ',' ',' ', ' ', ' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ','A story or situation is written for learners to read and consider. It may be presented on paper, read or seen on video ',' ', '1- Each participant read or watch the related material .2- Each participant should submit his own resolution of a proposed question',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Helping participants to develop skills in identifying concerns, analyzing problems, and considering solutions','checked','checked','checked');
insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Team Pair Solo', 'default',1,'entire session discuss the issue','all','001000','LargeGroupDisscussion',2,'exchanging ideas with your partner','all','001000','SmallGroupDisscussion',3,'submit your own resolution','all','000300','OwnResolution');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Team Pair Solo', 'default','participant', '2','2','2','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ',' ',' ', ' ',' ',' ',' ', 'checked', 'checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ','Motivate ','Size: usually 2', '1- The entire session discuss an issue2- Individuals pair up during the second step and exchange thoughts3- Each participant should submit his own resolution.',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires group discussion, peer explanation, and finally individual reflection','checked','checked','checked');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,t23,t29,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Team Pair Solo', 'default','participant', '2','2','2','checked','checked','checked','Motivate ','Size: usually 2', '1- The entire session discuss an issue2- Individuals pair up during the second step and exchange thoughts3- Each participant should submit his own resolution.','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires group discussion, peer explanation, and finally individual reflection','checked','checked','checked');
+insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Presentation', 'default',1,'entire session watch the slides','facilitator','001000','Slides',2,'discussion and questioning','all','001000','LargeGroupDisscussion');
+
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t18,t23,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Presentation', 'default','participant', '20','20','20','checked','checked','Motivate ','Size: usually 2', '1- The Facilitator present slides with his narration 2- The entire session discussion regarding the presentation ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires presentation',' ','checked','checked');
+
+
insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8,n9,ins9,tr9,tl9,tool9,n10,ins10,tr10,tl10,tool10,n11,ins11,tr11,tl11,tool11,n12,ins12,tr12,tl12,tool12,n13,ins13,tr13,tl13,tool13,n14,ins14,tr14,tl14,tool14 ) values ('Debate', ' Three Person Team Debate Format (Mount Holyoke College) ',1, 'N1 Affirmative Debater s Constructive Speech ','N1Affirmative','000400','SmallGroupDisscussion',2,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','SmallGroupDisscussion',3,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','SmallGroupDisscussion',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','SmallGroupDisscussion',5,'N3 Affirmative Debater s Constructive Speech ','N3Affirmative','000400','SmallGroupDisscussion',6,'N3 Negative Debater s Constructive Speech ','N3Negative','000400','SmallGroupDisscussion',7,'Brief preparation time ','all','000500','IndividualWriting',8, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000300','SmallGroupDisscussion',9,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000300','SmallGroupDisscussion',10,'N1 Negative Debater s Constructive Speech ',' N1Negative','000300','SmallGroupDisscussion',11,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000300','SmallGroupDisscussion',12,'N3 Negative Debater s Rebuttal Speech ','N3Negative','000300','SmallGroupDisscussion',13,'N3 Affirmative Debater s Rebuttal Speech ','N3Affirmative','000100','SmallGroupDisscussion',14,'Audience Questioning ','all','001500','SmallGroupDisscussion');
insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8,n9,ins9,tr9,tl9,tool9,n10,ins10,tr10,tl10,tool10 ) values ('Debate', ' Two Person Team Debate Format (Mount Holyoke College) ',1, 'N1 Affirmative Debater s Constructive Speech ','N1Affirmative','000400','SmallGroupDisscussion',2,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','SmallGroupDisscussion',3,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','SmallGroupDisscussion',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','SmallGroupDisscussion',5,'Brief preparation time ','all','000500','IndividualWriting',6,'N1 Negative Debater s Constructive Speech ',' N1Negative','000300','SmallGroupDisscussion',7,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000300','SmallGroupDisscussion',8, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000300','SmallGroupDisscussion',9,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000300','SmallGroupDisscussion',10,'Audience Questioning ','all','001500','SmallGroupDisscussion');
@@ -200,19 +222,19 @@
insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8,n9,ins9,tr9,tl9,tool9,n10,ins10,tr10,tl10,tool10,n11,ins11,tr11,tl11,tool11,n12,ins12,tr12,tl12,tool12 ) values ('Debate', ' A typical Cambridge format ',1, 'N1 Affirmative Debater s Constructive Speech ','N1Affirmative','000400','SmallGroupDisscussion',2,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','SmallGroupDisscussion',3,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','SmallGroupDisscussion',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','SmallGroupDisscussion',5,'N3 Affirmative Debater s Constructive Speech ', 'N3Affirmative','000400','SmallGroupDisscussion',6,'N3 Negative Debater s Constructive Speech ','N3Negative','000400','SmallGroupDisscussion',7,'N1 Negative Debater s Rebuttal Speech ',' N1Negative','000400','SmallGroupDisscussion',8,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000400','SmallGroupDisscussion',9, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000400','SmallGroupDisscussion',10,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000400','SmallGroupDisscussion',11, 'N3 Negative Debater s Rebuttal Speech ','N2Negative','000400','SmallGroupDisscussion',12,'N3 Affirmative Debater s Rebuttal Speech ', 'N3Affirmative','000400','SmallGroupDisscussion');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','Three Person Team Debate Format', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ','checked ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
-time: 60 min', '1- N1 Affirmative DebaterÕs Constructive Speech 2- N2 Affirmative DebaterÕs Constructive Speech 3- N1 Negative DebaterÕs Constructive Speech 4- N2 Negative DebaterÕs Constructive Speech 5- N3 Affirmative DebaterÕs Constructive Speech 6- N3 Negative DebaterÕs Constructive Speech 7- Brief preparation time 8- N2 Negative DebaterÕs Rebuttal Speech 9- N2 Affirmative DebaterÕs Rebuttal Speech 10- N1 Negative DebaterÕs Rebuttal Speech 11- N1 Affirmative DebaterÕs Rebuttal Speech 12- N3 Negative DebaterÕs Rebuttal Speech 13- N3 Affirmative DebaterÕs Rebuttal Speech 14- Audience Questioning ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','Three Person Team Debate Format', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
+time: 60 min', '1- N1 Affirmative Debaters Constructive Speech 2- N2 Affirmative DebaterÕs Constructive Speech 3- N1 Negative DebaterÕs Constructive Speech 4- N2 Negative DebaterÕs Constructive Speech 5- N3 Affirmative Debaters Constructive Speech 6- N3 Negative Debaters Constructive Speech 7- Brief preparation time 8- N2 Negative Debaters Rebuttal Speech 9- N2 Affirmative Debaters Rebuttal Speech 10- N1 Negative Debaters Rebuttal Speech 11- N1 Affirmative Debaters Rebuttal Speech 12- N3 Negative DebaterÕs Rebuttal Speech 13- N3 Affirmative Debaters Rebuttal Speech 14- Audience Questioning ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
-insert into beehive_pattern ( techniqe,name,roles, mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','Two Person Team Debate Format', 'N1Affirmative/N2Affirmative/N1Negative/N2Negative/Audience' ,'10','10','10','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ','checked ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: N1 Affirmative, N2 Affirmative, N1 Negative, N2 Negative, Audience (6)
-time: 48 min', '1- N1 Affirmative Debater s Constructive Speech 2- N1 Negative Debater s Constructive Speech 3- N2 Affirmative Debater s Constructive Speech4- N2 Negative Debater s Constructive Speech 5- Brief preparation time 6- N1 Negative Debater s Rebuttal Speech 7- N1 Affirmative Debater s Rebuttal Speech 8- N2 Negative Debater s Rebuttal Speech 9- N2 Affirmative Debater s Rebuttal Speech 10- Audience Questioning',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+insert into beehive_pattern ( techniqe,name,roles, mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','Two Person Team Debate Format', 'N1Affirmative/N2Affirmative/N1Negative/N2Negative/Audience' ,'10','10','10','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: N1 Affirmative, N2 Affirmative, N1 Negative, N2 Negative, Audience (6)
+time: 48 min', '1- N1 Affirmative Debater s Constructive Speech 2- N1 Negative Debater s Constructive Speech 3- N2 Affirmative Debater s Constructive Speech4- N2 Negative Debater s Constructive Speech 5- Brief preparation time 6- N1 Negative Debater s Rebuttal Speech 7- N1 Affirmative Debater s Rebuttal Speech 8- N2 Negative Debater s Rebuttal Speech 9- N2 Affirmative Debater s Rebuttal Speech 10- Audience Questioning','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
-insert into beehive_pattern (techniqe, name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','A typical Oxford format ', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
-time:28 min', '1- 1st Affirmative (constructive speech) 2- 1st Negative (constructive and rebuttal speech) 3- 2nd Affirmative (constructive and rebuttal speech) 4- 2nd Negative (constructive and rebuttal speech) 5- 3rd Affirmative (constructive and rebuttal speech) 6- 3rd Negative (constructive and rebuttal speech) 7- 1st Affirmative (rebuttal speech) ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+insert into beehive_pattern (techniqe, name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate','A typical Oxford format ', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
+time:28 min', '1- 1st Affirmative (constructive speech) 2- 1st Negative (constructive and rebuttal speech) 3- 2nd Affirmative (constructive and rebuttal speech) 4- 2nd Negative (constructive and rebuttal speech) 5- 3rd Affirmative (constructive and rebuttal speech) 6- 3rd Negative (constructive and rebuttal speech) 7- 1st Affirmative (rebuttal speech) ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate',' Modified Oxford format ', 'N1Affirmative/N2Affirmative/N1Negative/N2Negative/Audience' ,'12','12','12','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: N1 Affirmative, N2 Affirmative, N1 Negative, N2 Negative, Audience (6)
-time: 40 min', ' 1- 1st Affirmative (constructive speech) 2- Cross-examination by 2nd Negative 3- 1st Negative (constructive speech) 4- Cross-examination by 1st Affirmative) 5- 2nd Affirmative (constructive speech) 6- Cross-examination by 1st Negative) 7- 2nd Negative (constructive speech) 8- Cross Examination by 2nd Affirmative 9- 1st Negative (rebuttal-defence-summary speech) 10- 1st Affirmative (rebuttal-defence-summary speech) ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate',' Modified Oxford format ', 'N1Affirmative/N2Affirmative/N1Negative/N2Negative/Audience' ,'12','12','12','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: N1 Affirmative, N2 Affirmative, N1 Negative, N2 Negative, Audience (6)
+time: 40 min', ' 1- 1st Affirmative (constructive speech) 2- Cross-examination by 2nd Negative 3- 1st Negative (constructive speech) 4- Cross-examination by 1st Affirmative) 5- 2nd Affirmative (constructive speech) 6- Cross-examination by 1st Negative) 7- 2nd Negative (constructive speech) 8- Cross Examination by 2nd Affirmative 9- 1st Negative (rebuttal-defence-summary speech) 10- 1st Affirmative (rebuttal-defence-summary speech) ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
-insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate',' A typical Cambridge format ', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','checked','checked',' ',' ',' ','checked',' ','checked',' ',' ','checked',' ',' ',' ',' ',' ','checked',' ',' ' ,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
-time: 48 min ', ' 1- 1st Affirmative (constructive speech) 2- 1st Negative (constructive speech) 3- 2nd Affirmative (constructive speech) 4- 2nd Negative (constructive speech) 5- 3rd Affirmative (constructive speech) 6- 3rd Negative (constructive speech) 7- 1st Negative (rebuttal speech) 8- 1st Affirmative (rebuttal speech) 9- 2nd Negative (rebuttal speech) 10- 2nd Affirmative (rebuttal speech) 11- 3rd Negative (rebuttal speech) 12- 3rd Affirmative (rebuttal speech) ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses) values ('Debate',' A typical Cambridge format ', 'N1Affirmative/N2Affirmative/N3Affirmative/N1Negative/N2Negative/N3Negative/Audience' ,'12','12','12','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 12 Structure: N1 Affirmative, N2 Affirmative, N3 Affirmative, N1 Negative, N2 Negative, N3 Negative, Audience (6)
+time: 48 min ', ' 1- 1st Affirmative (constructive speech) 2- 1st Negative (constructive speech) 3- 2nd Affirmative (constructive speech) 4- 2nd Negative (constructive speech) 5- 3rd Affirmative (constructive speech) 6- 3rd Negative (constructive speech) 7- 1st Negative (rebuttal speech) 8- 1st Affirmative (rebuttal speech) 9- 2nd Negative (rebuttal speech) 10- 2nd Affirmative (rebuttal speech) 11- 3rd Negative (rebuttal speech) 12- 3rd Affirmative (rebuttal speech) ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
Index: openacs-4/packages/beehive/www/create-edit-session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -16,7 +16,7 @@
</fullquery>
<fullquery name="new_session_sql">
<querytext>
- insert into beehive_ses (number,tutor, roles,mx,mn,df,datew,titlew,classname,stype,name) values (:number,:namet,:roles,:mx,:mn,:df,:datew,:titlew,:group,:technique_name,:technique_version)
+ insert into beehive_ses (number,tutor, roles,mx,mn,df,datew,titlew,classname,stype,name,solution) values (:number,:namet,:roles,:mx,:mn,:df,:datew,:titlew,:group,:technique_name,:technique_version,:solution)
</querytext>
</fullquery>
<fullquery name="update_pattern_value">
Index: openacs-4/packages/beehive/www/create-edit-session.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -113,21 +113,22 @@
}
- {mx:text(text)
- {label "#beehive.Session_Group_maximum_size#"}
- {html {size 3}}
- {value "$mx"}
+ #{mx:text(text)
+ # {label "#beehive.Session_Group_maximum_size#"}
+ # {html {size 3}}
+ # {value "$mx"}
- }
+ #}
- {mn:text(text)
- {label "#beehive.Session_Group_minimum_size#"}
- {html {size 3}}
- {value "$mn"}
- }
+ #{mn:text(text)
+ # {label "#beehive.Session_Group_minimum_size#"}
+ # {html {size 3}}
+ # {value "$mn"}
+ #}
{df:text(text)
{label "#beehive.Session_Group_default_size#"}
{html {size 3}}
+ {help_text "[_ beehive.Session_groupsize_text]" }
{value "$df"}
}
{edit_flage:text(hidden)
@@ -138,6 +139,9 @@
{technique_name:text(hidden)
{value $technique_name}
}
+ {solution:text(hidden)
+ {value $solution}
+ }
{technique_version:text(hidden)
{value $technique_version}
}
@@ -161,12 +165,16 @@
SELECT * from beehive_ses where number = :number
} -new_data {
+ set mx $df
+ set mn $df
db_dml new_session_sql {}
if {$newtechnique_flage == 0 } {
db_dml update_pattern_value {}
}
} -edit_data {
+ set mx $df
+ set mn $df
db_dml session_update {}
Index: openacs-4/packages/beehive/www/create-edit-session2.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session2.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session2.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session2.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -24,11 +24,7 @@
return false;
}
-function deny1() {
-alert("note that if you want to select the Participating in ideas voting (LEARNERS) task, you should first select the (ideas listing) task" );
-}
-
function deny2() {
alert("to use this component properly you must have more than one role" );
@@ -48,10 +44,12 @@
<input type = "hidden" name = "roles" value = "@roles@">
<input type = "hidden" name = "newtechnique_flage" value = "@newtechnique_flage@">
+<input type = "hidden" name = "btype" value = "1">
+
<if @edit_flage@ not eq 0>
New
</if>
@@ -81,9 +79,21 @@
</td>
</tr></table>
+
+
<table cellspacing="2" cellpadding="2" border="0">
+<tr ><td BGCOLOR="#F2f1cb">
+<b>
+#beehive.agenda_Description#
+@solution@</b>
+</td>
+</tr></table>
+
+<table cellspacing="2" cellpadding="2" border="0">
+
+
<tr class="form-element"><td class="form-widget">
<br>
<b>#beehive.Administrator_Facilitator_Tasks# </b>
@@ -131,11 +141,14 @@
<input type = "checkbox" name="t11" value ="checked" checked = "true" onclick="return deny(this);"><font color="#FF0000"> #beehive._Providing_Title# | <a href= "/beehive/more-task?num=11"> #beehive.Tasks_more#</a></font>
<br>
-<input type = "checkbox" name="taskn.12" value ="checked" @t12@><font color="#333399"> #beehive.Providing_Info#| <a href= "/beehive/more-task?num=12"> #beehive.Tasks_more#</a></font>
+<input type = "checkbox" name="taskn.12" value ="checked" @t12@><font color="#306754"> #beehive.Providing_Info#| <a href= "/beehive/more-task?num=12"> #beehive.Tasks_more#</a></font>
<br>
-<input type = "checkbox" name="taskn.13" value ="checked" @t13@ onclick="return deny2(this);"><font color="#333399"> #beehive.Providing_info_Role#| <a href= "/beehive/more-task?num=13"> #beehive.Tasks_more#</a></font>
+
+<input type = "checkbox" name="taskn.4" value ="checked" @t4@><font color="#306754"> #beehive.Providing_group_Info#| <a href= "/beehive/more-task?num=4"> #beehive.Tasks_more#</a></font>
<br>
+<input type = "checkbox" name="taskn.13" value ="checked" @t13@ onclick="return deny2(this);"><font color="#306754"> #beehive.Providing_info_Role#| <a href= "/beehive/more-task?num=13"> #beehive.Tasks_more#</a></font>
+<br>
<!--
@@ -144,17 +157,10 @@
<br>
-->
-<input type = "checkbox" name="taskn.14" value ="checked" @t14@ ><font color="#333399"> #beehive.Providing_Description#| <a href= "/beehive/more-task?num=14"> #beehive.Tasks_more#</a></font>
-<br>
-<input type = "checkbox" name="taskn.32" value ="checked" @t32@><font color="#333399"> #beehive.Providing_external_links# | <a href= "/beehive/more-task?num=32"> #beehive.Tasks_more#</a></font>
-<br>
-
-
-
<u> #beehive.Staged_provision_Tasks#</u> <br>
<input type = "checkbox" name="taskn.33" value ="checked" @t33@><font color="#306754"> #beehive.Providing_staged_resource# | <a href= "/beehive/more-task?num=33"> #beehive.Tasks_more#</a></font>
@@ -168,9 +174,16 @@
<input type = "checkbox" name="taskn.17" value ="checked" @t17@> <font color="#306754"> #beehive.Presenting_question# | <a href= "/beehive/more-task?num=17"> #beehive.Tasks_more#</a></font>
<br>
+<input type = "checkbox" name="taskn.36" value ="checked" @t36@><font color="#306754"> #beehive.yes_no_voting#| <a href= "/beehive/more-task?num=36"> #beehive.Tasks_more#</a></font>
+<br>
+<input type = "checkbox" name="taskn.14" value ="checked" @t14@ ><font color="#306754"> #beehive.Providing_Survey#</font>
+<br>
+
<input type = "checkbox" name="taskn.34" value ="checked" @t34@><font color="#306754"> #beehive.Debriefing# | <a href= "/beehive/more-task?num=34"> #beehive.Tasks_more#</a></font>
<br>
+
+
<u>#beehive.Assessments#</u>
<br>
@@ -203,7 +216,7 @@
-->
<input type = "checkbox" name="anon1" value ="checked" @anon1@>#beehive.Task_Anonymous#
<input type = "checkbox" name="adda1" value ="checked" @adda1@>#beehive.Task_Audio#
-<input type = "checkbox" name="addv1" value ="checked" @addv1@>#beehive.Task_Video# | <a href= "/beehive/more-task?num=22"> #beehive.Tasks_more#</a></font>
+ | <a href= "/beehive/more-task?num=22"> #beehive.Tasks_more#</a></font>
<br>
<input type = "checkbox" name="taskn.23" value ="checked" @t23@><font color="#306754">#beehive.Entire_session_discussions#
<!--
@@ -213,56 +226,56 @@
-->
<input type = "checkbox" name="anon2" value ="checked" @anon2@>#beehive.Task_Anonymous#
<input type = "checkbox" name="adda2" value ="checked" @adda2@>#beehive.Task_Audio#
-<input type = "checkbox" name="addv2" value ="checked" @addv2@>#beehive.Task_Video# | <a href= "/beehive/more-task?num=23"> #beehive.Tasks_more#</a></font>
+</font>
<br>
<input type = "checkbox" name="taskn.24" value ="checked" @t24@> <font color="#306754">#beehive.Similar_roles_discussions#
<input type = "checkbox" name="anon3" value ="checked" @anon3@>#beehive.Task_Anonymous#
<input type = "checkbox" name="adda3" value ="checked" @adda3@>#beehive.Task_Audio#
-<input type = "checkbox" name="addv3" value ="checked" @addv3@>#beehive.Task_Video# | <a href= "/beehive/more-task?num=24"> #beehive.Tasks_more#</a></font>
+</font>
<br>
<input type = "checkbox" name="taskn.26" value ="checked" @t26@> <font color="#306754">#beehive.Ideas_listing#
-<input type="radio" name="btype" value="1" @btype1@>#beehive.each_group#
-<input type="radio" name="btype" value="2"@btype2@>#beehive.entire_session#)
-<input type = "checkbox" name="anon4" value ="checked" @anon4@>#beehive.Task_Anonymous# | <a href= "/beehive/more-task?num=26"> #beehive.Tasks_more#</a> </font>
-<br>
-<input type = "checkbox" name="taskn.38" value ="checked" @t38@><font color="#306754"> #beehive.Discussing_ideas# | <a href= "/beehive/more-task?num=38"> #beehive.Tasks_more#</a>
-</font>
-<br>
+<input type = "checkbox" name="anon4" value ="checked" @anon4@>#beehive.Task_Anonymous# |
+ <a href= "/beehive/more-task?num=26"> #beehive.Tasks_more#</a> #beehive.followed_by#
+<input type = "checkbox" name="taskn.38" value ="checked" @t38@><font color="#306754"> #beehive.Discussing_ideas# |
+ <a href= "/beehive/more-task?num=38"> #beehive.Tasks_more#</a>
+<input type = "checkbox" name="taskn.35" value ="checked" @t35@><font color="#306754">#beehive.voting_by# |
-<input type = "checkbox" name="taskn.35" value ="checked" @t35@ onclick="return deny1(this);"><font color="#306754"> #beehive.voting_by#
-<input type="radio" name="controlld" value="1" @controlld1@ > #beehive.Learners#
-<input type="radio" name="controlld" value="2" @controlld2@> #beehive.facilitator# )
<a href= "/beehive/more-task?num=35"> #beehive.Tasks_more#</a></font>
<br>
-<input type = "checkbox" name="taskn.36" value ="checked" @t36@><font color="#306754"> #beehive.yes_no_voting#| <a href= "/beehive/more-task?num=36"> #beehive.Tasks_more#</a></font>
-<br>
-<input type = "checkbox" name="taskn.37" value ="checked" @t37@><font color="#306754"> #beehive.collaborative_writing# </font>| <a href= "/beehive/more-task?num=37"> #beehive.Tasks_more#</a></font>
+
+<input type = "checkbox" name="taskn.37" value ="checked" @t37@> <font color="#306754">#beehive.smallgroup# </font> <input type = "checkbox" name="taskn.10" value ="checked" @t10@> #beehive.largegroup# #beehive.collaborative_writing# |<a href= "/beehive/more-task?num=37"> #beehive.Tasks_more#</a></font>
+
<br>
-<input type = "checkbox" name="taskn.20" value ="checked" @t20@><font color="#306754"> #beehive.Whiteboard_drawing# | <a href= "/beehive/more-task?num=20"> #beehive.Tasks_more#</a> </font>
+<input type = "checkbox" name="taskn.20" value ="checked" @t20@><font color="#306754"> #beehive.smallgroup# <input type = "checkbox" name="taskn.11" value ="checked" @t11@> #beehive.largegroup# #beehive.Whiteboard_drawing#| <a href= "/beehive/more-task?num=20"> #beehive.Tasks_more#</a> </font>
+<br>
+<input type = "checkbox" name="taskn.32" value ="checked" @t32@><font color="#306754"> #beehive.Video_conferencing# </font>
<br>
<input type = "checkbox" name="taskn.27" value ="checked" @t27@><font color="#306754"> #beehive.Icebreakering# | <a href= "/beehive/more-task?num=27"> #beehive.Tasks_more#</a> </font>
+
+<!--
<br>
<input type = "checkbox" name="taskn.30" value ="checked" @t30@><font color="#306754"> #beehive.Group_submission#| <a href= "/beehive/more-task?num=30"> #beehive.Tasks_more#</a></font>
+-->
+<br>
+<input type = "checkbox" name="taskn.29" value ="checked" @t29@><font color="#306754"> #beehive.Submitting_own_resolution# | <a href= "/beehive/more-task?num=29"> #beehive.Tasks_more#</a></font>
-
<br>
<u>#beehive.Individual_Tasks#</u>
<br>
-<input type = "checkbox" name="taskn.28" value ="checked" @t28@><font color="#306754"> #beehive.Individual_writing#| <a href= "/beehive/more-task?num=28"> #beehive.Tasks_more#</a></font>
+<input type = "checkbox" name="taskn.28" value ="checked" @t28@><font color="#306754"> #beehive.Silent_thinking#| <a href= "/beehive/more-task?num=28"> #beehive.Tasks_more#</a></font>
+
<br>
-<input type = "checkbox" name="taskn.29" value ="checked" @t29@><font color="#306754"> #beehive.Submitting_own_resolution# | <a href= "/beehive/more-task?num=29"> #beehive.Tasks_more#</a></font>
-<br>
<input type = "checkbox" name="taskn.6" value ="checked" @t6@> <font color="#306754"> #beehive.Internet_searching# | <a href= "/beehive/more-task?num=6"> #beehive.Tasks_more#</a></font>
<br>
-<input type = "checkbox" name="taskn.31" value ="checked" @t31@><font color="#306754"> #beehive.Silent_thinking# | <a href= "/beehive/more-task?num=31"> #beehive.Tasks_more#</a> </font>
+<input type = "checkbox" name="taskn.31" value ="checked" @t31@><font color="#333399"> #beehive.Note_taking# | <a href= "/beehive/more-task?num=31"> #beehive.Tasks_more#</a> </font>
<br>
<input type = "checkbox" name="taskn.8" value ="checked" @t8@><font color="#333399"> #beehive.Facilitator_Asking# | <a href= "/beehive/more-task?num=8"> #beehive.Tasks_more#</a></font>
<br>
Index: openacs-4/packages/beehive/www/create-edit-session2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session2.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session2.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session2.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -32,7 +32,7 @@
}
-
+set flag1 "false"
if {$edit_flage != 0 } {
# if it is a new session then get the session's default tasks according to the selected
# technique's number from the Beehive pattern table
@@ -44,7 +44,7 @@
set [subst {t$i}] " "
}
- set flag1 "false"
+
# to get the default tasks for the selected technique from the pattern table
db_multirow session get_info_from_pattern {}
template::multirow foreach session {
Index: openacs-4/packages/beehive/www/create-edit-session3.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session3.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session3.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session3.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -31,7 +31,6 @@
<input type = "hidden" name = "roles" value = "@roles@">
<input type = "hidden" name = "sln" value = @sln@>
<input type = "hidden" name = "ell" value = @el@>
-<input type = "hidden" name = "igg" value = @ig@>
<input type = "hidden" name = "newtechnique_flage" value = "@newtechnique_flage@">
<table cellspacing="2" cellpadding="2" border="0">
@@ -58,7 +57,7 @@
</if>
<br><br>
- <if @t20@ eq "checked" >
+ <if @t20@ eq "checked" or @t11@ eq "checked" >
<if @edit_flage@ not eq "0" >
#beehive.Whiteboard_image# <br><br>
</if>
@@ -83,34 +82,16 @@
</else>
- #beehive.File# <input type="file" name="ig" size="40" ><br>
+ #beehive.File# <input type="file" name="el" size="40" ><br>
<br><br>
</if>
- <!-- in case of selecting the providing resources file links task -->
- <if @t32@ eq "checked" >
- <if @edit_flage@ not eq "0" >
- #beehive.Resource_file# <br><br>
- </if>
- <else>
- #beehive.Resource_file_change# <br><br>
- </else>
-
- #beehive.File# <input type="file" name="el" size="40" ><br>
-
- <br><br>
- </if>
-
-
-
-
-
</table>
Index: openacs-4/packages/beehive/www/create-edit-session3.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session3.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session3.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session3.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -107,7 +107,7 @@
# set a flag if no related info for selected tasks is required
set relatedflag " "
-if { $t33 != "checked" && $t32 != "checked" && $t18 != "checked" && $t20 != "checked" } {
+if { $t33 != "checked" && $t18 != "checked" && $t20 != "checked" && $t11 != "checked"} {
# no uploading files
set url_import_var [export_vars {edit_flage technique_name technique_num session_id roles sln newtechnique_flage}]
ad_returnredirect "create-edit-session5?$url_import_var"
Index: openacs-4/packages/beehive/www/create-edit-session4-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session4-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session4-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session4-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -15,7 +15,7 @@
<fullquery name="edit_values">
<querytext>
- UPDATE beehive_ses SET ig = :ig , el = :el WHERE number = :session_id
+ UPDATE beehive_ses SET el = :el WHERE number = :session_id
</querytext>
</fullquery>
@@ -32,11 +32,6 @@
UPDATE beehive_ses SET el = :ell WHERE number = :session_id
</querytext>
</fullquery>
- <fullquery name="edit_value3">
- <querytext>
+
- UPDATE beehive_ses SET ig = :igg WHERE number = :session_id
- </querytext>
- </fullquery>
-
</queryset>
\ No newline at end of file
Index: openacs-4/packages/beehive/www/create-edit-session4.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session4.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session4.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session4.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -17,9 +17,9 @@
{ roles: " " }
-{ ig: " " }
+
{ el: " " }
-{ igg: " " }
+
{ ell: " " }
{ sln: 0 }
{ newtechnique_flage: 55 }
@@ -74,7 +74,7 @@
# to upload file for withe board drawing
- if {$t20 == "checked" } {
+ if {$t20 == "checked" || $t11 == "checked" } {
set localfilewb [ns_queryget sld]
@@ -98,48 +98,18 @@
}
}
-
-# to upload resources file
- if {$t32 == "checked" } {
-
- set localfilesf [ns_queryget el]
-
- if {$localfilesf != "" } {
- set ifpsf [open [ns_queryget [subst {el}].tmpfile] r]
-
- # open the filename for writing
-
- set pthsf [acs_root_dir]
- set filenamesf [subst {$pthsf/packages/beehive/www/slides/[subst {sess$session_id}]$el}]
-
- set ofpsf [open $filenamesf w+]
-
- fconfigure $ifpsf -translation binary
- fconfigure $ofpsf -translation binary
-
- ns_cpfp $ifpsf $ofpsf
-
- close $ifpsf
- close $ofpsf
- } else {
- # to update resources file name
- db_dml edit_value2 {}
- }
-
- }
-
# to upload staged file
if {$t33 == "checked" } {
- set localfiledf [ns_queryget ig]
+ set localfiledf [ns_queryget el]
if {$localfiledf != "" } {
- set ifpdf [open [ns_queryget [subst {ig}].tmpfile] r]
+ set ifpdf [open [ns_queryget [subst {el}].tmpfile] r]
# open the filename for writing
set pthdf [acs_root_dir]
- set filenamedf [subst {$pthdf/packages/beehive/www/slides/[subst {sess$session_id}]$ig}]
+ set filenamedf [subst {$pthdf/packages/beehive/www/slides/[subst {sess$session_id}]$el}]
set ofpdf [open $filenamedf w+]
@@ -152,7 +122,7 @@
close $ofpdf
} else {
# to update staged file name
- db_dml edit_value3 {}
+ db_dml edit_value2 {}
}
}
Index: openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -12,7 +12,7 @@
<fullquery name="do_update">
<querytext>
- UPDATE beehive_ses SET st = :st , srt = :srt , idn = :idn ,idt = :idt,ih = :ih , it = :it , ynt = :ynt WHERE number = :session_id
+ UPDATE beehive_ses SET sessioninfo = :sessioninfo , roleinfo = :roleinfo , ideasnumber = :ideasnumber ,ideastext = :ideastext,ih = :ih , largesharedtext = :largesharedtext, groupinfo = :groupinfo , smallsharedtext = :smallsharedtext WHERE number = :session_id
</querytext>
</fullquery>
Index: openacs-4/packages/beehive/www/create-edit-session5.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session5.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session5.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session5.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -29,7 +29,7 @@
set number $session_id
-set ig ""
+
set el ""
# to get the stored tasks
@@ -40,7 +40,7 @@
# set a flag if no related info for selected tasks is required
set relatedflag " "
-if { $t12 != "checked" && $t35 != "checked" && $t13 != "checked" && $t14 != "checked" && $t36 != "checked" } {
+if { $t12 != "checked" && $t13 != "checked" && $t14 != "checked" && $t4 != "checked" && $t37 != "checked" && $t10 != "checked"} {
# no related info is needed
set url_import_var [export_vars {edit_flage technique_name technique_num session_id roles sln newtechnique_flage}]
ad_returnredirect "create-edit-session6?$url_import_var"
@@ -71,6 +71,7 @@
}
{sln:text(hidden)
+ {before_html "[_ beehive.character_note]"}
{value $sln}
}
@@ -79,72 +80,93 @@
{value $newtechnique_flage}
}
+
}
+
+
+if { $t4 == "checked" } {
+ ad_form -extend -name activity_entery_form1 -form {
+
+ {groupinfo:text(textarea)
+
+ {html { cols 60 rows 8}}
+ {label "#beehive.Group_info#"}
+ {help_text "[_ beehive.group_note]" }
+
+ }
+ }
+}
+
+
if { $t12 == "checked" } {
ad_form -extend -name activity_entery_form1 -form {
- {st:text(textarea)
- {html { cols 60 rows 6}}
+ {sessioninfo:text(textarea)
+
+ {html { cols 60 rows 10}}
{label "#beehive.Session_Info#"}
+ {help_text "[_ beehive.session_note]" }
}
}
}
-if { $t35 == "checked" } {
- if { $controlld2 == "checked" } {
+if { $t14 == "checked" } {
+
ad_form -extend -name activity_entery_form1 -action "create-edit-session2.tcl" -form {
- {idn:text(text)
+ {ideasnumber:text(text)
{html {size 5}}
{label "#beehive.Ideas_number#"}
}
- {idt:text(textarea)
+ {ideastext:text(textarea)
{html { cols 60 rows 6}}
{label "#beehive.List_of_ideas#"}
}
}
+
}
-}
if { $t13 == "checked" } {
ad_form -extend -name activity_entery_form1 -form {
- {srt:text(textarea)
+ {roleinfo:text(textarea)
{html { cols 60 rows 8}}
- {label "#beehive.Subject_info# $roles"}
+ {label "#beehive.Role_info# $roles"}
{help_text "[_ beehive.Roles_note]" }
}
}
}
-if { $t14 == "checked" } {
- ad_form -extend -name activity_entery_form1 -form {
- {ih:text(text)
- {html {size 60}}
- {label "#beehive.Description_heading#"}
- {value "#beehive.Description_heading_default#"}
+
+
+if { $t37 == "checked" } {
+
+ ad_form -extend -name activity_entery_form1 -form {
+
+ {smallsharedtext:text(textarea),optional
+ {html { cols 60 rows 12}}
+ {help_text "[_ beehive.Collaboration_script_info]" }
+ {label "#beehive.Collaboration_scrip#"}
+
}
- {it:text(textarea)
- {html { cols 60 rows 6}}
- {label "#beehive.Description_text#"}
-
}
- }
+
+
}
-
-if { $t36 == "checked" } {
+if { $t10 == "checked" } {
ad_form -extend -name activity_entery_form1 -form {
- {ynt:text(textarea)
- {html { cols 60 rows 6}}
- {label "#beehive.yesNo_question#"}
+ {largesharedtext:text(textarea),optional
+ {html { cols 60 rows 12}}
+ {help_text "[_ beehive.Collaboration_script_info]" }
+ {label "#beehive.Lage_Collaboration_scrip#"}
}
}
Index: openacs-4/packages/beehive/www/create-edit-session6.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session6.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session6.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session6.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -5,29 +5,56 @@
<SCRIPT LANGUAGE="JavaScript">
<!-- Begincreate-edit-session
+function setrole(i)
+{
+// steps elements
+var iii = parseInt(i);
+tri = iii*4 + 10;
+tooli = iii*4 + 8;
+var st = eval("document.form1.elements[tooli].selectedIndex");
+var toolname = eval("document.form1.elements[tooli].options[st].text");
+if (toolname == "Slides" || toolname == "Debriefing" || toolname == "Evaluation" || toolname == "QA" || toolname == "Overview" ) {
+var fa = "facilitator";
+eval("document.form1.elements[tri].options[0].value" + "=fa" );
+eval("document.form1.elements[tri].options[0].text" + "=fa" );
+
+}
+
+if (toolname == "InternetSearch" || toolname == "IndividualWriting" || toolname == "IdeasVoting" || toolname == "YesNo" || toolname == "OwnResolution" || toolname == "SilentThinking" || toolname == "DynamicLink" || toolname == "IdeasDiscussion" || toolname == "SessionInfo" || toolname == "GroupInfo" || toolname == "RoleInfo" || toolname == "Survey") {
+var fa = "all";
+eval("document.form1.elements[tri].options[0].value" + "=fa" );
+eval("document.form1.elements[tri].options[0].text" + "=fa" );
+
+}
+
+
+}
+
+
+
function isCode(){ // check if durations has 6 digit format
-for (ii=1;ii <= 19 ;ii++){
-tli = ii*4 + 10;
+for (ii=1;ii <= 24 ;ii++){
+tli = ii*4 + 11;
eval("entry" + "=document.form1.elements[tli].value" ) ;
if (entry !="") {
strlen=entry.length;
-if (strlen!=6) {
-alert("fill the duration time in step " + ii+ " with 6 digits");
+if (strlen!=8) {
+alert("fill the duration time in step " + ii+ " with 6 digits \n Ex. 9 min and 30 sec is entered like this 00:09:30");
return false;
}
// Check for legal characters in string - note index starts at zero
-for (i=0;i < 6 ;i++){
-if ('0123456789'.indexOf(entry.charAt(i))<0) {
-alert("only digits from 0-9 are acceptable in the duration time in step " + ii);
+for (i=0;i < 8 ;i++){
+if ('0123456789:'.indexOf(entry.charAt(i))<0) {
+alert("only digits from 0-9 are acceptable in the duration time in step " + ii +"\n Ex. 1 hr 9 min and 35 sec is entered like this 01:09:35");
return false;
}
}
@@ -42,9 +69,9 @@
var noErrors1 = theMessage1
var j1 = 0
-// make sure field is not blank and within limit 1-20
-if (document.form1.dstep.value < 1 || document.form1.dstep.value >20) {
-theMessage1 = theMessage1 + "\n Enter the step number between 1 and 20";
+// make sure field is not blank and within limit 1-25
+if (document.form1.dstep.value < 1 || document.form1.dstep.value >25) {
+theMessage1 = theMessage1 + "\n Enter the step number between 1 and 25";
}
@@ -53,18 +80,18 @@
// to shift all rows up
var xx = parseInt(document.form1.dstep.value);
-for (i = xx; i <= 19; i++){
+for (i = xx; i <= 24; i++){
ii = i + 1;
// steps elements
-insi = i*4 + 8;
-tri = i*4 + 9;
-tli = i*4 + 10;
-tooli = i*4 + 11;
+insi = i*4 + 9;
+tri = i*4 + 10;
+tli = i*4 + 11;
+tooli = i*4 + 8;
// next steps elements
-insf = ii*4 + 8;
-trf = ii*4 + 9;
-tlf = ii*4 + 10;
-toolf = ii*4 + 11;
+insf = ii*4 + 9;
+trf = ii*4 + 10;
+tlf = ii*4 + 11;
+toolf = ii*4 + 8;
var mm2 = eval("document.form1.elements[trf].selectedIndex")
@@ -83,21 +110,21 @@
// to make empty the last row
-eval("document.form1.elements[88].value" + "= '' " ) ; //ins20
-eval("document.form1.elements[90].value" + "= '' " ) ; //tl20
+eval("document.form1.elements[109].value" + "= '' " ) ; //ins25
+eval("document.form1.elements[111].value" + "= '' " ) ; //tl25
var newOpt2 = document.createElement("OPTION");
-eval("newOpt2.text" + "= document.form1.elements[89].options[0].text" ) //tr20
-eval("newOpt2.value" + "= document.form1.elements[89].options[0].value" )
-eval("document.form1.elements[89].add(newOpt2)");
-eval("document.form1.elements[89].options[0].value" + "= '' " )
-eval("document.form1.elements[89].options[0].text" + "= '' " )
+eval("newOpt2.text" + "= document.form1.elements[110].options[0].text" ) //tr25
+eval("newOpt2.value" + "= document.form1.elements[110].options[0].value" )
+eval("document.form1.elements[110].add(newOpt2)");
+eval("document.form1.elements[110].options[0].value" + "= '' " )
+eval("document.form1.elements[110].options[0].text" + "= '' " )
var newOpt3 = document.createElement("OPTION");
-eval("newOpt3.text" + "= document.form1.elements[91].options[0].text" ) //tool20
-eval("newOpt3.value" + "= document.form1.elements[91].options[0].value" )
-eval("document.form1.elements[91].add(newOpt3)");
-eval("document.form1.elements[91].options[0].value" + "= '' " )
-eval("document.form1.elements[91].options[0].text" + "= '' " )
+eval("newOpt3.text" + "= document.form1.elements[108].options[0].text" ) //tool25
+eval("newOpt3.value" + "= document.form1.elements[108].options[0].value" )
+eval("document.form1.elements[108].add(newOpt3)");
+eval("document.form1.elements[108].options[0].value" + "= '' " )
+eval("document.form1.elements[108].options[0].text" + "= '' " )
return true;
@@ -120,8 +147,8 @@
var j = 0
// make sure field is not blank
-if (document.form1.istep.value < 1 || document.form1.istep.value >19) {
-theMessage = theMessage + "\n Enter the step number between 1 and 19";
+if (document.form1.istep.value < 1 || document.form1.istep.value >24) {
+theMessage = theMessage + "\n Enter the step number between 1 and 24";
}
@@ -140,15 +167,15 @@
ii =i +1;
// steps elements
-insi = i*4 + 8;
-tri = i*4 + 9;
-tli = i*4 + 10;
-tooli = i*4 + 11;
+insi = i*4 + 9;
+tri = i*4 + 10;
+tli = i*4 + 11;
+tooli = i*4 + 8;
// next steps elements
-insf = ii*4 + 8;
-trf = ii*4 + 9;
-tlf = ii*4 + 10;
-toolf = ii*4 + 11;
+insf = ii*4 + 9;
+trf = ii*4 + 10;
+tlf = ii*4 + 11;
+toolf = ii*4 + 8;
var mm22 = eval("document.form1.elements[tri].selectedIndex")
@@ -167,21 +194,21 @@
}
// make the insert row empty
-eval("document.form1.elements[4* document.form1.istep.value +8].value" + "= '' " ) ;
-eval("document.form1.elements[4* document.form1.istep.value +10].value" + "= '' " ) ;
+eval("document.form1.elements[4* document.form1.istep.value +9].value" + "= '' " ) ;
+eval("document.form1.elements[4* document.form1.istep.value +11].value" + "= '' " ) ;
var newOpt2 = document.createElement("OPTION");
-eval("newOpt2.text" + "= document.form1.elements[4* document.form1.istep.value +9].options[0].text" )
-eval("newOpt2.value" + "= document.form1.elements[4* document.form1.istep.value +9].options[0].value" )
-eval("document.form1.elements[4* document.form1.istep.value +9].add(newOpt2)");
-eval("document.form1.elements[4* document.form1.istep.value +9].options[0].value" + "= '' " )
-eval("document.form1.elements[4* document.form1.istep.value +9].options[0].text" + "= '' " )
+eval("newOpt2.text" + "= document.form1.elements[4* document.form1.istep.value +10].options[0].text" )
+eval("newOpt2.value" + "= document.form1.elements[4* document.form1.istep.value +10].options[0].value" )
+eval("document.form1.elements[4* document.form1.istep.value +10].add(newOpt2)");
+eval("document.form1.elements[4* document.form1.istep.value +10].options[0].value" + "= '' " )
+eval("document.form1.elements[4* document.form1.istep.value +10].options[0].text" + "= '' " )
var newOpt3 = document.createElement("OPTION");
-eval("newOpt3.text" + "= document.form1.elements[4* document.form1.istep.value +11].options[0].text" )
-eval("newOpt3.value" + "= document.form1.elements[4* document.form1.istep.value +11].options[0].value" )
-eval("document.form1.elements[4* document.form1.istep.value +11].add(newOpt3)");
-eval("document.form1.elements[4* document.form1.istep.value +11].options[0].value" + "= '' " )
-eval("document.form1.elements[4* document.form1.istep.value +11].options[0].text" + "= '' " )
+eval("newOpt3.text" + "= document.form1.elements[4* document.form1.istep.value +8].options[0].text" )
+eval("newOpt3.value" + "= document.form1.elements[4* document.form1.istep.value +8].options[0].value" )
+eval("document.form1.elements[4* document.form1.istep.value +8].add(newOpt3)");
+eval("document.form1.elements[4* document.form1.istep.value +8].options[0].value" + "= '' " )
+eval("document.form1.elements[4* document.form1.istep.value +8].options[0].text" + "= '' " )
return true;
@@ -219,11 +246,20 @@
</tr>
</table>
+<table cellspacing="2" cellpadding="2" border="0">
+<tr ><td BGCOLOR="#F2f1cb">
+<b>
+#beehive.agenda_Description#
+@solution@</b><br>
+#beehive.agenda_note#
+</td>
+</tr></table>
- <div style="overflow: auto; width: 750px; height: 320px; border-left: 3px gray solid; border-bottom: 3px gray solid; ; border-right: 3px gray solid; border-top: 3px gray solid;padding:3px; margin: 0px">
+ <div style="overflow: auto; width: 850px; height: 400px; border-left: 3px gray solid; border-bottom: 3px gray solid; ; border-right: 3px gray solid; border-top: 3px gray solid;padding:3px; margin: 0px">
+
<table cellspacing="5" cellpadding="1" border="0">
<tr> <td BGCOLOR="#F2f1cb" >
#beehive.script_instruction#
@@ -237,14 +273,14 @@
</tr>
</table>
<table cellspacing="2" cellpadding="2" border="0">
-<tr class="form-element"><td class="header-text">#beehive.Step# </td> <td class="header-text">#beehive.Instruction# </td> <td class="header-text">#beehive.Turn# </td> <td class="header-text">#beehive.duration# </td><td class="header-text"><font color="#306754">#beehive.Tool# </font></td>
+<tr class="form-element"> <td class="header-text">#beehive.Step# </td><td class="header-text"><font color="#306754">#beehive.Tool# </font></td> <td class="header-text">#beehive.Instruction# </td> <td class="header-text">#beehive.Turn# </td> <td class="header-text">#beehive.duration# </td>
</tr>
<%
- for {set i 1} {$i <= 20} {incr i} {
+ for {set i 1} {$i <= 25} {incr i} {
set ins [subst {insa.$i}]
eval set inss $[subst {ins$i}]
set tr [subst {tra.$i}]
@@ -256,9 +292,27 @@
%>
<tr class="form-element"><td>@i@ </td>
-<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1"> <input type = "text" name="@ins@" size="40" MAXLENGTH=140 value = "@inss@" > </font> </td>
+
+
<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1">
+<select name="@tool@" onChange="setrole(@i@);">
+<option value= "@tooll@"> @tooll@</option>
+<list name=tools>
+<if @tooll@ not eq @tools:item@>
+<option value= "@tools:item@">@tools:item@</option>
+</if>
+</list>
+
+</select>
+</td>
+
+<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1">
+
+<textarea name="@ins@" cols="40" rows="2">@inss@</textarea> </font> </td>
+
+<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1">
+
<select name="@tr@">
<option value= "@trr@">@trr@</option>
<if @trr@ not eq "all">
@@ -272,27 +326,32 @@
</select>
</font> </td>
-<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1"> <input type = "text" name = "@tl@" size="10" value = "@tll@"> </font> </td>
-<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1">
-<select name="@tool@">
-<option value= "@tooll@"> @tooll@</option>
-<list name=tools>
-<if @tooll@ not eq @tools:item@>
-<option value= "@tools:item@">@tools:item@</option>
-</if>
-</list>
+<%
+
+if {$tll != "" } {
+
+
+
+# to fix the time format
+set dates $tll
+set dates [subst {[string range $dates 0 1]:[string range $dates 2 3]:[string range $dates 4 5]}]
+set tll $dates
+}
+%>
+
+
+<td class="form-widget"> <font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1"> <input type = "text" name = "@tl@" size="10" value = "@tll@"> </font> </td>
+</tr>
+
<%
}
%>
-</select>
-</tr>
-
</table>
</div>
Index: openacs-4/packages/beehive/www/create-edit-session6.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session6.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session6.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session6.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -15,9 +15,7 @@
{ technique_num: 11 }
{ technique_name: " " }
{ roles: " " }
-{ ig: " " }
{ el: " " }
-{ igg: " " }
{ ell: " " }
{ sln: 0 }
@@ -37,7 +35,7 @@
db_multirow sessions get_session_info {}
template::multirow foreach sessions {
- }
+ }
set technique_version $name
if {$edit_flage == 0 } {
@@ -82,67 +80,92 @@
if {$t24 == "checked" } {
set tools [linsert $tools end "RolesDisscussion"]
}
- if {$t6 == "checked" } {
- set tools [linsert $tools end "InternetSearch"]
- }
+
if {$t26 == "checked" } {
set tools [linsert $tools end "IdeasPosting"]
}
+ if {$t38 == "checked" } {
+ set tools [linsert $tools end "IdeasDiscussion"]
+ }
+ if {$t35 == "checked" } {
+ set tools [linsert $tools end "IdeasVoting"]
+ }
if {$t27 == "checked" } {
set tools [linsert $tools end "IceBreaking"]
}
+ if {$t37 == "checked" } {
+ set tools [linsert $tools end "SmallGroupSharedText"]
+ }
+ if {$t10 == "checked" } {
+ set tools [linsert $tools end "LargeGroupSharedText"]
+ }
+
+ if {$t20 == "checked" } {
+ set tools [linsert $tools end "SmallGroupWhiteboard"]
+ }
+ if {$t11 == "checked" } {
+ set tools [linsert $tools end "LargeGroupWhiteboard"]
+ }
+ if {$t32 == "checked" } {
+ set tools [linsert $tools end "Conferencing"]
+ }
+
if {$t34 == "checked" } {
set tools [linsert $tools end "Debriefing"]
}
- if {$t28 == "checked" } {
- set tools [linsert $tools end "IndividualWriting"]
- }
+
if {$t19 == "checked" } {
set tools [linsert $tools end "Evaluation"]
}
if {$t30 == "checked" } {
set tools [linsert $tools end "Summarizing"]
}
- if {$t35 == "checked" } {
- set tools [linsert $tools end "IdeasVoting"]
- }
+
if {$t36 == "checked" } {
set tools [linsert $tools end "YesNo"]
}
- if {$t29 == "checked" } {
- set tools [linsert $tools end "OwnResolution"]
- }
+
if {$t17 == "checked" } {
set tools [linsert $tools end "QA"]
}
- if {$t31 == "checked" } {
- set tools [linsert $tools end "SilentThinking"]
- }
+ if {$t14 == "checked" } {
+ set tools [linsert $tools end "Survey"]
+ }
+ if {$t12 == "checked" } {
+ set tools [linsert $tools end "SessionInfo"]
+ }
+ if {$t4 == "checked" } {
+ set tools [linsert $tools end "GroupInfo"]
+ }
+ if {$t13 == "checked" } {
+ set tools [linsert $tools end "RoleInfo"]
+ }
if {$t15 == "checked" } {
set tools [linsert $tools end "Overview"]
}
if {$t33 == "checked" } {
- set tools [linsert $tools end "DynamicLink"]
+ set tools [linsert $tools end "DownloadFile"]
}
- if {$t37 == "checked" } {
- set tools [linsert $tools end "SharedText"]
+
+ if {$t29 == "checked" } {
+ set tools [linsert $tools end "OwnResolution"]
+ }
+ if {$t28 == "checked" } {
+ set tools [linsert $tools end "SilentThinking"]
}
- if {$t38 == "checked" } {
- set tools [linsert $tools end "IdeasDiscussion"]
+ if {$t6 == "checked" } {
+ set tools [linsert $tools end "InternetSearch"]
}
- if {$t20 == "checked" } {
- set tools [linsert $tools end "Whiteboard"]
- }
-
+
}
# to fill the roles
set rolesl [split $roles "/"]
-set rolesl [linsert $rolesl end "teacher"]
+# set rolesl [linsert $rolesl end "facilitator"]
ad_return_template
Index: openacs-4/packages/beehive/www/create-edit-session7-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session7-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session7-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session7-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -5,20 +5,20 @@
<fullquery name="insert_pattern_values">
<querytext>
- insert into beehive_patscript (techniqe,tname,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20 ) values (:technique_name,:technique_version,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20)
+ insert into beehive_patscript (techniqe,tname,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20,ins21,tr21,tl21,tool21,ins22,tr22,tl22,tool22,ins23,tr23,tl23,tool23,ins24,tr24,tl24,tool24,ins25,tr25,tl25,tool25 ) values (:technique_name,:technique_version,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20,:ins21,:tr21,:tl21,:tool21,:ins22,:tr22,:tl22,:tool22,:ins23,:tr23,:tl23,:tool23,:ins24,:tr24,:tl24,:tool24,:ins25,:tr25,:tl25,:tool25)
</querytext>
</fullquery>
<fullquery name="insert_session_script">
<querytext>
- insert into beehive_sesscript (number,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20 ) values (:number1,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20)
+ insert into beehive_sesscript (number,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20,ins21,tr21,tl21,tool21,ins22,tr22,tl22,tool22,ins23,tr23,tl23,tool23,ins24,tr24,tl24,tool24,ins25,tr25,tl25,tool25 ) values (:number1,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20,:ins21,:tr21,:tl21,:tool21,:ins22,:tr22,:tl22,:tool22,:ins23,:tr23,:tl23,:tool23,:ins24,:tr24,:tl24,:tool24,:ins25,:tr25,:tl25,:tool25)
</querytext>
</fullquery>
<fullquery name="update_session_script">
<querytext>
- UPDATE beehive_sesscript SET ins1 = :ins1 ,tr1 = :tr1,tl1 = :tl1,tool1 = :tool1, ins2 = :ins2 ,tr2 = :tr2,tl2 = :tl2,tool2 = :tool2,ins3 = :ins3 ,tr3 = :tr3,tl3 = :tl3,tool3 = :tool3,ins4 = :ins4 ,tr4 = :tr4,tl4 = :tl4,tool4 = :tool4,ins5 = :ins5 ,tr5 = :tr5,tl5 = :tl5,tool5 = :tool5,ins6 = :ins6 ,tr6 = :tr6,tl6 = :tl6,tool6 = :tool6,ins7 = :ins7 ,tr7 = :tr7,tl7 = :tl7,tool7 = :tool7,ins8 = :ins8 ,tr8 = :tr8,tl8 = :tl8,tool8 = :tool8,ins9 = :ins9 ,tr9 = :tr9,tl9 = :tl9,tool9 = :tool9,ins10 = :ins10 ,tr10 = :tr10,tl10 = :tl10,tool10 = :tool10,ins11 = :ins11 ,tr11 = :tr11,tl11 = :tl11,tool11 = :tool11, ins12 = :ins12 ,tr12 = :tr12,tl12 = :tl12,tool12 = :tool12,ins13 = :ins13 ,tr13 = :tr13,tl13 = :tl13,tool13 = :tool13,ins14 = :ins14 ,tr14 = :tr14,tl14 = :tl14,tool14 = :tool14,ins15 = :ins15 ,tr15 = :tr15,tl15 = :tl15,tool15 = :tool15,ins16 = :ins16 ,tr16 = :tr16,tl16 = :tl16,tool16 = :tool16,ins17 = :ins17 ,tr17 = :tr17,tl17 = :tl17,tool17 = :tool17,ins18 = :ins18 ,tr18 = :tr18,tl18 = :tl18,tool18 = :tool18,ins19 = :ins19 ,tr19 = :tr19,tl19 = :tl19,tool19 = :tool19,ins20 = :ins20 ,tr20 = :tr20,tl20 = :tl20,tool20 = :tool20 WHERE number =:number1
+ UPDATE beehive_sesscript SET ins1 = :ins1 ,tr1 = :tr1,tl1 = :tl1,tool1 = :tool1, ins2 = :ins2 ,tr2 = :tr2,tl2 = :tl2,tool2 = :tool2,ins3 = :ins3 ,tr3 = :tr3,tl3 = :tl3,tool3 = :tool3,ins4 = :ins4 ,tr4 = :tr4,tl4 = :tl4,tool4 = :tool4,ins5 = :ins5 ,tr5 = :tr5,tl5 = :tl5,tool5 = :tool5,ins6 = :ins6 ,tr6 = :tr6,tl6 = :tl6,tool6 = :tool6,ins7 = :ins7 ,tr7 = :tr7,tl7 = :tl7,tool7 = :tool7,ins8 = :ins8 ,tr8 = :tr8,tl8 = :tl8,tool8 = :tool8,ins9 = :ins9 ,tr9 = :tr9,tl9 = :tl9,tool9 = :tool9,ins10 = :ins10 ,tr10 = :tr10,tl10 = :tl10,tool10 = :tool10,ins11 = :ins11 ,tr11 = :tr11,tl11 = :tl11,tool11 = :tool11, ins12 = :ins12 ,tr12 = :tr12,tl12 = :tl12,tool12 = :tool12,ins13 = :ins13 ,tr13 = :tr13,tl13 = :tl13,tool13 = :tool13,ins14 = :ins14 ,tr14 = :tr14,tl14 = :tl14,tool14 = :tool14,ins15 = :ins15 ,tr15 = :tr15,tl15 = :tl15,tool15 = :tool15,ins16 = :ins16 ,tr16 = :tr16,tl16 = :tl16,tool16 = :tool16,ins17 = :ins17 ,tr17 = :tr17,tl17 = :tl17,tool17 = :tool17,ins18 = :ins18 ,tr18 = :tr18,tl18 = :tl18,tool18 = :tool18,ins19 = :ins19 ,tr19 = :tr19,tl19 = :tl19,tool19 = :tool19,ins20 = :ins20 ,tr20 = :tr20,tl20 = :tl20,tool20 = :tool20,ins21 = :ins21 ,tr21 = :tr21,tl21 = :tl21,tool21 = :tool21, ins22 = :ins22 ,tr22 = :tr22,tl22 = :tl22,tool22 = :tool22,ins23 = :ins23 ,tr23 = :tr23,tl23 = :tl23,tool23 = :tool23,ins24 = :ins24 ,tr24 = :tr24,tl24 = :tl24,tool24 = :tool24,ins25 = :ins25 ,tr25 = :tr25,tl25 = :tl25,tool25 = :tool25 WHERE number =:number1
</querytext>
</fullquery>
Index: openacs-4/packages/beehive/www/create-edit-session7.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session7.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/create-edit-session7.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/create-edit-session7.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -67,6 +67,14 @@
helping:onelist
tracking:onelist
dynamiclink:onelist
+ smallgroupsharedtext:onelist
+ largegroupsharedtext:onelist
+ SessionInfo:onelist
+ GroupInfo:onelist
+ RoleInfo:onelist
+ noteTaking:onelist
+ Survey:onelist
+
}
@@ -75,7 +83,7 @@
# initialization of the script's variables
-for {set i 1} {$i <= 20} {incr i} {
+for {set i 1} {$i <= 25} {incr i} {
set [subst {ins$i}] " "
set [subst {tr$i}] " "
set [subst {tl$i}] " "
@@ -87,9 +95,22 @@
eval set [subst {ins$name}] $[subst {insa($name)}]
eval set [subst {tr$name}] $[subst {tra($name)}]
+
+
+
+
+
eval set [subst {tl$name}] $[subst {tla($name)}]
eval set [subst {tool$name}] $[subst {toola($name)}]
+# to fix the timelimit format remove : symbol
+eval set dates $[subst {tla($name)}]
+
+set dates [subst {[string range $dates 0 1][string range $dates 3 4][string range $dates 6 7]}]
+eval set [subst {tl$name}] $dates
+
+
+
}
@@ -141,6 +162,7 @@
set helping " "
set tracking " "
set timing " "
+set noteTaking " "
set tools [linsert $tools end "timing"]
if {$t5 == "checked" } {
set timing [linsert $timing end "teacher"]
@@ -166,6 +188,11 @@
set tracking [linsert $tracking end "teacher"]
incr toolc
}
+if {$t31 == "checked" } {
+ set tools [linsert $tools end "noteTaking"]
+ set noteTaking [linsert $noteTaking end "all"]
+ incr toolc
+ }
# start filling the tools array from the static infoboxs (title, description,etc)
@@ -177,57 +204,15 @@
incr toolc
-if {$t12 == "checked" } {
-
-
- set tools [linsert $tools end "staticinfo"]
- set staticinfo [linsert $staticinfo end "Session Info"]
- set staticinfo [linsert $staticinfo end $st]
- set staticinfo [linsert $staticinfo end "all"]
- set staticinfo [linsert $staticinfo end "4"]
- incr toolc
- }
-if {$t13 == "checked" } {
- # fill the role text array
- set roleText [split $srt "/"]
- for {set i 0} {$i < [llength $roleText]} {incr i} {
- set tools [linsert $tools end "staticinfo"]
- set staticinfo [linsert $staticinfo end "Your Role Info"]
- set staticinfo [linsert $staticinfo end [lindex $roleText $i]]
- set staticinfo [linsert $staticinfo end [lindex $rolesl $i]]
- set staticinfo [linsert $staticinfo end "3"]
- incr toolc
- }
- }
-if {$t32 == "checked" } {
- set tools [linsert $tools end "staticinfo"]
- set staticinfo [linsert $staticinfo end "External links"]
- set staticinfo [linsert $staticinfo end $el]
- set staticinfo [linsert $staticinfo end "all"]
- set staticinfo [linsert $staticinfo end "6"]
- incr toolc
- }
-if {$t14 == "checked" } {
- set tools [linsert $tools end "staticinfo"]
- set staticinfo [linsert $staticinfo end $ih]
- set staticinfo [linsert $staticinfo end $it]
- set staticinfo [linsert $staticinfo end "all"]
- set staticinfo [linsert $staticinfo end "2"]
- incr toolc
- }
-
-
-
-
# reading the script and filling (instructions/turns/timelimits/ staged toolsl)
set ins "no"
set tr "none"
@@ -309,13 +294,17 @@
set vote " "
set monitoring " "
set floorcontrol " "
-
+set smallgroupsharedtext " "
+set largegroupsharedtext " "
set dynamiclink " "
set internetsearch " "
+set SessionInfo " "
+set GroupInfo " "
+set RoleInfo " "
+set Conferencing " "
+set Survey " "
-
-
for {set i 0} {$i < [llength $toolsl]} {incr i} {
set envt [linsert $envt end "1"]
if {[lindex $toolsl $i] == "IdeasPosting" } {
@@ -427,13 +416,8 @@
set chat [linsert $chat end "no"]
}
if {[lindex $toolsl $i] == "IceBreaking" } {
- set tools [linsert $tools end "chat"]
- set chat [linsert $chat end "text-and-audio-and-video"]
- set chat [linsert $chat end "turn"]
- set chat [linsert $chat end "group"]
- set chat [linsert $chat end "Ice Breaking"]
- set chat [linsert $chat end "no"]
- set chat [linsert $chat end "no"]
+ set tools [linsert $tools end "icebreaking"]
+
}
if {[lindex $toolsl $i] == "Evaluation" } {
set tools [linsert $tools end "chat"]
@@ -446,33 +430,31 @@
}
if {[lindex $toolsl $i] == "Debriefing" } {
set tools [linsert $tools end "chat"]
- set chat [linsert $chat end "text"]
+ set chat [linsert $chat end "text-and-audio"]
set chat [linsert $chat end "turn"]
set chat [linsert $chat end "all"]
set chat [linsert $chat end "Debriefing"]
set chat [linsert $chat end "no"]
set chat [linsert $chat end "no"]
}
-
+
if {[lindex $toolsl $i] == "IdeasVoting" } {
set tools [linsert $tools end "vote"]
set vote [linsert $vote end "idea"]
set vote [linsert $vote end "idea Voting"]
- if {$controlld2 == "checked" } {
- set vote [linsert $vote end "teacher"]
- set vote [linsert $vote end $idn]
- set vote [linsert $vote end $idt]
- } else {
set vote [linsert $vote end "learners"]
set vote [linsert $vote end "none"]
set vote [linsert $vote end "none"]
- }
}
if {[lindex $toolsl $i] == "InternetSearch" } {
set tools [linsert $tools end "internetsearch"]
}
+ if {[lindex $toolsl $i] == "Conferencing" } {
+ set tools [linsert $tools end "Conferencing"]
+
+ }
if {[lindex $toolsl $i] == "OwnResolution" } {
set tools [linsert $tools end "ownresolution"]
@@ -481,23 +463,49 @@
if {[lindex $toolsl $i] == "QA" } {
set tools [linsert $tools end "qa"]
}
- if {[lindex $toolsl $i] == "SharedText" } {
- set tools [linsert $tools end "sharedtext"]
+ if {[lindex $toolsl $i] == "SmallGroupSharedText" } {
+ set tools [linsert $tools end "smallgroupsharedtext"]
+ set smallgroupsharedtext [linsert $smallgroupsharedtext end $smallsharedtext]
}
+ if {[lindex $toolsl $i] == "LargeGroupSharedText" } {
+ set tools [linsert $tools end "largegroupsharedtext"]
+ set largegroupsharedtext [linsert $largegroupsharedtext end $largesharedtext]
+ }
+ if {[lindex $toolsl $i] == "SessionInfo" } {
+ set tools [linsert $tools end "SessionInfo"]
+ set SessionInfo [linsert $SessionInfo end $sessioninfo]
+ }
+ if {[lindex $toolsl $i] == "GroupInfo" } {
+ set tools [linsert $tools end "GroupInfo"]
+ set GroupInfo [linsert $GroupInfo end $groupinfo]
+ }
+ if {[lindex $toolsl $i] == "RoleInfo" } {
+ set tools [linsert $tools end "RoleInfo"]
+ set RoleInfo [linsert $RoleInfo end $roleinfo]
+ }
+ if {[lindex $toolsl $i] == "Survey" } {
+ set tools [linsert $tools end "Survey"]
+ set Survey [linsert $Survey end $ideasnumber]
+ set Survey [linsert $Survey end $ideastext]
+ }
+
if {[lindex $toolsl $i] == "IdeasDiscussion" } {
set tools [linsert $tools end "ideasdiscussion"]
}
- if {[lindex $toolsl $i] == "DynamicLink" } {
+ if {[lindex $toolsl $i] == "DownloadFile" } {
set tools [linsert $tools end "dynamiclink"]
- set dynamiclink [linsert $dynamiclink end $ig]
+ set dynamiclink [linsert $dynamiclink end $el]
}
if {[lindex $toolsl $i] == "SilentThinking" } {
set tools [linsert $tools end "silentthinking"]
}
- if {[lindex $toolsl $i] == "Whiteboard" } {
- set tools [linsert $tools end "whiteboard"]
+ if {[lindex $toolsl $i] == "SmallGroupWhiteboard" } {
+ set tools [linsert $tools end "smallgroupwhiteboard"]
}
+ if {[lindex $toolsl $i] == "LargeGroupWhiteboard" } {
+ set tools [linsert $tools end "largegroupwhiteboard"]
+ }
if {[lindex $toolsl $i] == "Overview" } {
set tools [linsert $tools end "overview"]
}
@@ -507,7 +515,7 @@
if {[lindex $toolsl $i] == "YesNo" } {
set tools [linsert $tools end "vote"]
set vote [linsert $vote end "yesno"]
- set vote [linsert $vote end $ynt]
+ set vote [linsert $vote end "Answer the above question by clicking on the yes/no buttons below"]
set vote [linsert $vote end "none"]
set vote [linsert $vote end "none"]
set vote [linsert $vote end "none"]
@@ -608,7 +616,7 @@
}
# to define all tools that can be used in this system
-set alltools { "staticinfo" "timing" "chat" "vote" "individualwriting" "floorcontrol" "guiding" "monitoring" "internetsearch" "ownresolution" "qa" "silentthinking" "overview" "helping" "dynamiclink" "sharedtext" "ideasdiscussion" "slides" "tracking" "whiteboard" }
+set alltools { "staticinfo" "timing" "chat" "vote" "individualwriting" "floorcontrol" "guiding" "monitoring" "internetsearch" "ownresolution" "qa" "silentthinking" "overview" "helping" "dynamiclink" "smallgroupsharedtext" "ideasdiscussion" "slides" "tracking" "smallgroupwhiteboard" "SessionInfo" "noteTaking" "Conferencing" "Survey" "largegroupsharedtext" "largegroupwhiteboard" "GroupInfo" "RoleInfo" "icebreaking" }
# to publish the xml schema according to this simple structure
@@ -704,27 +712,12 @@
# to add tools inside collaboration service
set kkk 0
-set k1 0
-set k2 0
-set k3 0
-set k4 0
-set k5 0
-set k6 0
-set k7 0
-set k8 0
-set k9 0
-set k10 0
-set k11 0
-set k12 0
-set k13 0
-set k14 0
-set k15 0
-set k16 0
-set k17 0
-set k18 0
-set k19 0
-set k20 0
-set k21 0
+
+for {set i 1} {$i < 31} {incr i} {
+eval set [subst {k$i}] 0
+}
+
+
# when publishing the environment section it will look at the toolsl array
# and skip the repeated tools so for the pervious example
# it pass the toolsll[0] which is the chat, toolsll[2] which is the vote and toolsll[5] which is the summary
@@ -871,8 +864,9 @@
incr k16
}
if {[lindex $alltools 15] == [lindex $tools $kkk] } {
- $node appendXML "<imsld:sharedtext />"
-
+ $node appendXML "<imsld:smallgroupsharedtext />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:text>[lindex $smallgroupsharedtext $k17]</imsld:text>"
incr k17
}
if {[lindex $alltools 16] == [lindex $tools $kkk] } {
@@ -892,14 +886,66 @@
if {[lindex $alltools 18] == [lindex $tools $kkk] } {
$node appendXML "<imsld:tracking />"
set node [$node lastChild]
- $node appendXML "<imsld:owner>[lindex $tracking $k15]</imsld:owner>"
+ $node appendXML "<imsld:owner>[lindex $tracking $k20]</imsld:owner>"
incr k20
}
if {[lindex $alltools 19] == [lindex $tools $kkk] } {
- $node appendXML "<imsld:whiteboard />"
+ $node appendXML "<imsld:smallgroupwhiteboard />"
incr k21
}
+ if {[lindex $alltools 20] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:Sessioninfo />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:text>[lindex $SessionInfo $k22]</imsld:text>"
+ incr k22
+ }
+ if {[lindex $alltools 21] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:notetaking />"
+
+ incr k23
+ }
+ if {[lindex $alltools 22] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:conferencing />"
+ incr k24
+ }
+ if {[lindex $alltools 23] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:survey />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:questions-number>[lindex $Survey $k25]</imsld:questions-number>"
+ incr k25
+ $node appendXML "<imsld:questions-text>[lindex $Survey $k25]</imsld:questions-text>"
+ incr k25
+ }
+ if {[lindex $alltools 24] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:largegroupsharedtext />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:text>[lindex $largegroupsharedtext $k26]</imsld:text>"
+ incr k26
+ }
+ if {[lindex $alltools 25] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:largegroupwhiteboard />"
+ incr k27
+ }
+ if {[lindex $alltools 26] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:groupinfo />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:text>[lindex $GroupInfo $k28]</imsld:text>"
+ incr k28
+ }
+ if {[lindex $alltools 27] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:roleinfo />"
+ set node [$node lastChild]
+ $node appendXML "<imsld:text>[lindex $RoleInfo $k29]</imsld:text>"
+ incr k29
+ }
+ # check for individual writing tool
+ if {[lindex $alltools 28] == [lindex $tools $kkk] } {
+ $node appendXML "<imsld:icebreaking />"
+ incr k30
+ }
+
+
incr kkk
set node [$node parentNode]
}
@@ -935,7 +981,7 @@
close $fileId
-# to generate the graduate attribute
+# to generate the collaboration attribute
# initialize attributes
set timemanagement "checked"
@@ -958,7 +1004,7 @@
# if IdeasPosting
set creativethinking "checked"
}
-if {$t13 == "checked" || $t12 == "checked" || $t32 == "checked" || $t33 == "checked" || $t17 == "checked" } {
+if {$t13 == "checked" || $t12 == "checked" || $t33 == "checked" || $t17 == "checked" } {
# if IdeasPosting
set analyticalskills "checked"
}
Index: openacs-4/packages/beehive/www/duplicate2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/duplicate2-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/duplicate2-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/duplicate2-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -12,7 +12,7 @@
<fullquery name="insert_value1">
<querytext>
- insert into beehive_ses (number,tutor,roles,mx,mn,df,datew,titlew,classname,stype,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,adda1,addv1,adda2,addv2,adda3,addv3,anon1,anon2,anon3,anon4,btype1,btype2,dtype1,sln,st, srt,ig,idn,idt,el,ih, it,ynt,timemanagement, writtencommunicatoin , criticalthinking, creativethinking , analyticalskills , decisionmaking , leadership , oralcommunication , searchingskills , knowledgesharing , reflecting ) values (acs_object_id_seq.nextval,:tutor,:roles,:mx,:mn,:df,:dated,:titlew,:classname,:stype,:t2,:t4,:t5,:t6,:t7,:t8,:t9,:t10,:t11,:t12,:t13,:t14,:t15,:t17,:t18,:t19,:t20,:t22,:t23,:t24,:t26,:t27,:t28,:t29,:t30,:t31,:t32,:t33,:t34,:t35,:t36,:t37,:t38,:ctype1,:ctype2,:ctype3,:controlld1,:controlld2,:adda1,:addv1,:adda2,:addv2,:adda3,:addv3,:anon1,:anon2,:anon3,:anon4,:btype1,:btype2,:dtype1,:sln,:st,:srt,:ig ,:idn ,:idt,:el, :ih ,:it ,:ynt, :timemanagement, :writtencommunicatoin , :criticalthinking, :creativethinking , :analyticalskills , :decisionmaking , :leadership , :oralcommunication , :searchingskills , :knowledgesharing , :reflecting )
+ insert into beehive_ses (number,tutor,roles,mx,mn,df,datew,titlew,classname,stype,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,adda1,addv1,adda2,addv2,adda3,addv3,anon1,anon2,anon3,anon4,btype1,btype2,dtype1,sln,sessioninfo, roleinfo,groupinfo,ideasnumber,ideastext,el,ih, largesharedtext,smallsharedtext,timemanagement, writtencommunicatoin , criticalthinking, creativethinking , analyticalskills , decisionmaking , leadership , oralcommunication , searchingskills , knowledgesharing , reflecting,solution ) values (acs_object_id_seq.nextval,:tutor,:roles,:mx,:mn,:df,:dated,:titlew,:classname,:stype,:t2,:t4,:t5,:t6,:t7,:t8,:t9,:t10,:t11,:t12,:t13,:t14,:t15,:t17,:t18,:t19,:t20,:t22,:t23,:t24,:t26,:t27,:t28,:t29,:t30,:t31,:t32,:t33,:t34,:t35,:t36,:t37,:t38,:ctype1,:ctype2,:ctype3,:controlld1,:controlld2,:adda1,:addv1,:adda2,:addv2,:adda3,:addv3,:anon1,:anon2,:anon3,:anon4,:btype1,:btype2,:dtype1,:sln,:sessioninfo,:roleinfo,:groupinfo ,:ideasnumber ,:ideastext,:el, :ih ,:largesharedtext, :smallsharedtext, :timemanagement, :writtencommunicatoin , :criticalthinking, :creativethinking , :analyticalskills , :decisionmaking , :leadership , :oralcommunication , :searchingskills , :knowledgesharing , :reflecting, :solution )
</querytext>
@@ -43,7 +43,7 @@
<fullquery name="insert_value3">
<querytext>
- insert into beehive_sesscript (number,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20 ) values (:number1,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20)
+ insert into beehive_sesscript (number,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20,ins21,tr21,tl21,tool21,ins22,tr22,tl22,tool22,ins23,tr23,tl23,tool23,ins24,tr24,tl24,tool24,ins25,tr25,tl25,tool25 ) values (:number1,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20,:ins21,:tr21,:tl21,:tool21,:ins22,:tr22,:tl22,:tool22,:ins23,:tr23,:tl23,:tool23,:ins24,:tr24,:tl24,:tool24,:ins25,:tr25,:tl25,:tool25)
</querytext>
Index: openacs-4/packages/beehive/www/duplicate2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/duplicate2.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/duplicate2.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/duplicate2.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -107,33 +107,12 @@
}
-# to upload resources file
- if {$t32 == "checked" } {
-
-
- set filename1 [subst {$pth/packages/beehive/www/slides/[subst {sess$number}]$el}]
- set filename2 [subst {$pth/packages/beehive/www/slides/[subst {sess$number1}]$el}]
- set ifp [open $filename1 r+]
- set ofp [open $filename2 w+]
- fconfigure $ifp -translation binary
- fconfigure $ofp -translation binary
-
-
- ns_cpfp $ifp $ofp
-
- close $ifp
- close $ofp
-
-
-
- }
-
# to upload staged file
if {$t33 == "checked" } {
- set filename1 [subst {$pth/packages/beehive/www/slides/[subst {sess$number}]$ig}]
- set filename2 [subst {$pth/packages/beehive/www/slides/[subst {sess$number1}]$ig}]
+ set filename1 [subst {$pth/packages/beehive/www/slides/[subst {sess$number}]$el}]
+ set filename2 [subst {$pth/packages/beehive/www/slides/[subst {sess$number1}]$el}]
set ifp [open $filename1 r+]
set ofp [open $filename2 w+]
fconfigure $ifp -translation binary
Index: openacs-4/packages/beehive/www/groupset.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/groupset.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/groupset.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/groupset.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -19,7 +19,7 @@
#beehive.Select_group_number#: <input type = "text" name ="gr" value= @gr@ size="3">
-<input type = "submit" value ="#beehive.Continue#">
+<input type = "submit" value ="#beehive.select#">
<br>
<if @gr@ not eq 0 >
<if @sflage@ eq "true">
@@ -56,7 +56,7 @@
</list>
</select>
- <input type = "submit" value ="#beehive.Continue#">
+ <input type = "submit" value ="#beehive.select#">
<if @sflage2@ not eq "false" or @sflage3@ eq "true" >
<br> <br>
@@ -67,9 +67,10 @@
</if>
</if>
<else>
- <a href="@url@/beehive/flash/collaboration.html?user_id1=@user_id1@&hurl=@hurl@&se1=@se1@&flashservera=@flashservera@" >
-<br>
-<h1>#beehive.Enter#</h1></a>
+<br>
+<a href="@url@/beehive/flash/collaboration.html?user_id1=@user_id1@&hurl=@hurl@&se1=@se1@&flashservera=@flashservera@" >
+
+#beehive.Enter#</a>
</else>
</master>
Index: openacs-4/packages/beehive/www/import.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/import.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/import.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/import.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -6,19 +6,19 @@
<u1>
<table cellspacing="2" cellpadding="2" border="1">
<tr class="form-element">
-<td> <b>Pattern information </b></td> <td><b>Uses</b></td><td> </td></tr>
+<td> <b>Pattern information </b></td> <td></td><td><b>Uses</b></td></tr>
<multiple name="pattern">
<tr>
<td><a href="@url@more-pattern?technique_num=@pattern.num@ "> @pattern.techniqe@ <if @pattern.name@ not eq "default">
-@pattern.name@
</if></a>
</td>
+
+<td> <a href="@url@create-edit-session?technique_num=@pattern.num@&group=@group@"> Create session </a> </td>
<td>
@pattern.uses@
</td>
-<td> <a href="@url@create-edit-session?technique_num=@pattern.num@&group=@group@"> Create session </a> </td>
-
</tr>
</multiple>
Index: openacs-4/packages/beehive/www/new_technique.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/new_technique.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/new_technique.tcl 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/new_technique.tcl 15 Jun 2006 05:51:20 -0000 1.2
@@ -50,32 +50,33 @@
{label "#beehive.Session_Technique_Version_name# "}
{html {size 101}}
}
- {uses:text(text),optional
- {label "#beehive.Session_Technique_uses# "}
- {html {size 101}}
- }
- {problem:text(text),optional
- {label "#beehive.Session_Technique_Problem# "}
- {html { cols 100 rows 2 }}
- }
+ #{uses:text(text),optional
+ # {label "#beehive.Session_Technique_uses# "}
+ # {html {size 101}}
+ #}
+ #{problem:text(text),optional
+ # {label "#beehive.Session_Technique_Problem# "}
+ # {html { cols 100 rows 2 }}
+ #}
- {example:text(textarea),optional
- {label "#beehive.Session_Technique_Example# "}
- {html { cols 100 rows 2}}
- }
+ #{example:text(textarea),optional
+ # {label "#beehive.Session_Technique_Example# "}
+ # {html { cols 100 rows 2}}
+ #}
- {context:text(textarea),optional
- {label "#beehive.Session_Technique_Context# "}
- {html { cols 100 rows 2}}
- }
+ #{context:text(textarea),optional
+ # {label "#beehive.Session_Technique_Context# "}
+ # {html { cols 100 rows 2}}
+ #}
- {gstructure:text(textarea),optional
- {label "#beehive.Session_Technique_Groups_structure# "}
- {html { cols 100 rows 2}}
- }
- {solution:text(textarea),optional
- {label "#beehive.Session_Technique_Solution# "}
- {html { cols 100 rows 3}}
+ #{gstructure:text(textarea),optional
+ # {label "#beehive.Session_Technique_Groups_structure# "}
+ # {html { cols 100 rows 2}}
+ #}
+ {solution:text(textarea)
+ {label "#beehive.Session_Technique_Solution# "}
+ {help_text "[_ beehive.Session_agenda_text]" }
+ {html { cols 90 rows 8}}
}
{group:text(hidden)
{value $group}
@@ -89,8 +90,9 @@
} -new_data {
- db_dml new_session_sql {insert into beehive_pattern (num,techniqe,name,problem,example,context,gstructure,solution,uses) values (:num, :techniqe,:name,:problem,:example,:context,:gstructure,:solution,:uses)}
-
+ db_dml new_session_sql {insert into beehive_pattern (num,techniqe,name,solution) values (:num, :techniqe,:name,:solution)}
+
+
} -after_submit {
Index: openacs-4/packages/beehive/www/viewIneractions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/viewIneractions-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/viewIneractions-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/viewIneractions-postgresql.xql 15 Jun 2006 05:51:20 -0000 1.2
@@ -11,7 +11,7 @@
<fullquery name="get_infoall">
<querytext>
- SELECT * from beehive_sessionIntraction where se = :se and gr = 0 order by Type_Interaction
+ SELECT * from beehive_sessionIntraction where se = :se and gr = 0 order by Type_Interaction
</querytext>
</fullquery>
Index: openacs-4/packages/beehive/www/viewIneractions.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/viewIneractions.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive/www/viewIneractions.adp 10 May 2006 05:38:46 -0000 1.1
+++ openacs-4/packages/beehive/www/viewIneractions.adp 15 Jun 2006 05:51:20 -0000 1.2
@@ -55,7 +55,7 @@
<tr class="form-element">
<td class="form-label">
- <b>#beehive.Subject_info# </b>
+ <b>#beehive.Session_Info# </b>
</td>
<td class="form-widget">
<font face="tahoma,verdana,arial,helvetica,sans-serif" size="-1">
Index: openacs-4/packages/beehive/www/flash/collaboration.fla
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/flash/collaboration.fla,v
diff -u -r1.1 -r1.2
Binary files differ
Index: openacs-4/packages/beehive/www/flash/collaboration.swf
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/flash/collaboration.swf,v
diff -u -r1.1 -r1.2
Binary files differ
Index: openacs-4/packages/beehive/www/images/12.jpg
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/images/12.jpg,v
diff -u -r1.1 -r1.2
Binary files differ
Index: openacs-4/packages/beehive/www/images/13.jpg
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/images/13.jpg,v
diff -u
Binary files differ
Index: openacs-4/packages/beehive/www/images/17.jpg
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/images/17.jpg,v
diff -u -r1.1 -r1.2
Binary files differ
Index: openacs-4/packages/beehive/www/images/22.jpg
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/images/22.jpg,v
diff -u -r1.1 -r1.2
Binary files differ
Index: openacs-4/packages/beehive/www/images/4.jpg
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/images/4.jpg,v
diff -u
Binary files differ
Index: openacs-4/packages/beehive-portlet/www/beehive-admin-portlet.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive-portlet/www/beehive-admin-portlet.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/beehive-portlet/www/beehive-admin-portlet.adp 10 May 2006 05:55:03 -0000 1.1
+++ openacs-4/packages/beehive-portlet/www/beehive-admin-portlet.adp 15 Jun 2006 05:52:56 -0000 1.2
@@ -1,3 +1,16 @@
+<script LANGUAGE="JavaScript">
+<!--
+// Nannette Thacker http://www.shiningstar.net
+function confirmSubmit()
+{
+var agree=confirm("Are you sure you wish to Delete?");
+if (agree)
+ return true ;
+else
+ return false ;
+}
+// -->
+</script>
<if @flag@ eq 0>
<a href="@url@configure"><font color="#FF0000"><b>#beehive.Edit_configuration_info# </B> </a></font>
@@ -9,15 +22,15 @@
<li>
<%
+
-
# to fix the date format
set dates $sess(datew)
set dates [subst {[string range $dates 0 3]/[string range $dates 5 6]/[string range $dates 8 9] - [string range $dates 11 12]:[string range $dates 14 15]}]
%>
- @sess.titlew@ (@sess.stype@) @dates@ |<a href="@url@create-edit-session?number=@sess.number@&edit_flage=0">#beehive.session_edit# </a> |<a href="@url@delete?numberw=@sess.number@&titlew=@sess.titlew@">#beehive.session_delete# </a> |<a href="@url@duplicate1?numberw=@sess.number@&titlew=@sess.titlew@">#beehive.session_duplicate# </a> |<a href="@url@viewIneractions?se=@sess.number@&titlew=@sess.titlew@">#beehive.session_view_transcript# </a>
+ @sess.titlew@ (@sess.stype@) @dates@ |<a href="@url@create-edit-session?number=@sess.number@&edit_flage=0">#beehive.session_edit# </a> |<a href="@url@delete?numberw=@sess.number@&titlew=@sess.titlew@" onClick="return confirmSubmit()">#beehive.session_delete# </a> |<a href="@url@duplicate1?numberw=@sess.number@&titlew=@sess.titlew@">#beehive.session_duplicate# </a> |<a href="@url@viewIneractions?se=@sess.number@&titlew=@sess.titlew@">#beehive.session_view_transcript# </a>
</multiple>