--
-- packages/beehive/sql/beehive-create.sql
--
-- @author turani
-- @creation-date 2000-10-22
-- @cvs-id $Id: beehive-create.sql,v 1.6 2007/03/20 22:54:42 aimant Exp $

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(300),    mx  varchar(10),    mn  varchar(10),    df  varchar(10),    t2  varchar(10),  t3  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(300),    mx  varchar(10),    mn  varchar(10),    df  varchar(10), timew varchar(10), datew varchar(30),    titlew varchar(200),    t2  varchar(10), t3  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), individualtext    varchar(5000),smallannotatedtext    varchar(5000),largeannotatedtext    varchar(5000),sln    varchar(10),fln    varchar(10), slnw    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(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),     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(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);


create table beehive_sessionIntraction (    sei      serial,    sname   varchar(100),    textdate   varchar(100),    type_Interaction varchar(100),    se     int,    student_response varchar(25000),   gr     int,      instruction_number  int  );





create table beehive_sesf ( snumber integer,     teacherid   integer);

create table beehive_sesstudents ( sesnumber integer,     stid   integer,  role  varchar(20), gr  integer,  sname  varchar(25) );

insert into beehive_pattern (num) values (0);

 
insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Ideas listing',26, 'How can learners posts their ideas on a posting chart?','Some pedagogical techniques require generating and posting ideas','To provide learners with a tool which holds the posted ideas from the group participants. Each idea is assigned with a sequential number for referencing. Ideas can be anonymous to ease the social pressure','Brainstorming Technique, Group nomination technique');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Controlling the timer',5, 'How can a facilitator time an activity? ','Most activity techniques require timing.  The timer is controlled  during the session by the facilitator in order for him to extend, or shorten the time of a certain step ',' To provide facilitators with a tool which that displays the duration on the top and show the time passed on the bottom. It should contain three buttons, start, pause ( to allow more time in that activity), and forward (to jump to the next activity) .','Optional in all pedagogical techniques');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Monitoring groups and providing guidance',9, 'How can a facilitator guide learners during the session?','Usually , learners need facilitators guidance to proceed smoothly in the session ',' facilitator can select the target that he would like to guide from a list box(group, role, or student). Then the facilitator will type the guiding text in a text box and sent it to the selected target. Also he can select which group to monitor form a list box which contain all active groups .','Optional in all pedagogical techniques');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Asking facilitator for help',8, 'How can learners ask for the facilitator help to clarify an issu, similar to face-to-face sessions?', 'Occasionally, learners would be able  to post their questions regarding  clarification of  unclear issues during the session',' Provide learners with a chat box where learners and facilitators can post their questions and answers during the session.  A buzz sound with every posting will help in  attracting the participants attention to that posting.','Optional in all pedagogical techniques');

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. ','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. ','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');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('White board drawing',20, 'How can a group of learners participate in a shared white board drawing ?','Some  activities imply that participants collaborate by using graphical communication with the ability to add a background image to annotate on  ' ,'Provide learners with a shared whitewboared  where  participants can draw lines or insert text during the session and an audio tool to communicate vocally while drawing. The whiteboard can be cleaned at any time by a clear button. ','Optional in all pedagogical techniques');


insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing the session description/rules/instructions',14, 'How can all session participants be provided with the same description/rules/instructions on how to conduct the desired collaboration activity?','Usually, pedagogical techniques need to be clearly explained  to learner  in order to perform the activity in a proper way  ' ,'Provide a separate info text box to hold the description/rules/instructions provided by facilitator. Student can view the information from the session info page ','Optional in all pedagogical techniques');



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  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 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 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  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 ('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',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 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 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');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('yes/no voting',36, 'How can learners participate into a side voting?','Many debating activities imply that participants should vote on which side of the controversial issue they support. It provides some kind of feedback mechanism needed by the debater or the facilitator  ' ,'Provide participants with voting tool that contains: a controversial question where the answer is yes or no, a yes/no button to choose from, and a percentage bars to reflect the voting results. ','Usually in the Debate, Pro/Contra Technique');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Writing a collaborative text',37, 'How can learners participate in writing a common text?','Some activities imply that participants should write a common text. It is their responsibility to organize among themselves to avoid writings collisions  ' ,'Provide participants with a shared text box and a led which will turn to red  when one participant start writing. All group members will see simultanly  the typed text    ','Optional in all pedagogical techniques');










insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ( 'Tracking participants interactions',7, 'How can facilitators and learners track participants  interactions ?','Usually, facilitator would like to monitor the participants interactions levels to provide guiding or assessments. While learners can compare their interaction levels with others for more encouragement  ' ,' Provide facilitators with a radar circle which represents all participants as dots trying to reach the center. User can retrieve user info by placing  the mouse over the desired dot. The user related dot will be flashing with -you- label  and with each contribution his dot will move  one step to the center. ','Optional in all pedagogical techniques');

insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Providing a vocal slides show',18, 'How can  facilitator provide a slides audio overview  at the beginning of the collaboration activity?','In sessions which require an introductory presentation' ,'Provide an audio tool that will be used by  facilitators to deliver their vocal overview, facilitator shared mouse to point to certain part of the slides, the slides which are power-point based images, and a chat box for asking questions. ','Optional in all pedagogical techniques');


insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Discussing the listed ideas',38, 'How can learners discuss posted ideas ?','Some   activities imply that participants should discuss ideas to come up with the best solution. ' ,'Provide learners with a chat tool for group discussion. a text box that hold the ideas  collected from the idea listing tool ','Usually in the Nomination Group Technique');


insert into beehive_tasks (name,num,problem,forces,solution,rpt) values ('Searching the internet',6, 'How can learners search the net for information needed in the session?', 'Occasionally during the session, facilitator would like learners to search for a specific information needed in the following steps of the session. ' ,' Provide a separate internet search page at the specific session step. ','Optional in all pedagogical techniques');






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','textInfo-EntireSession',2,'start discussion','all','001000','Disscussion-SmallGroup');

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','Disscussion-SmallGroup',2,' ','participant2','000200','Disscussion-SmallGroup',3,' ','participant3','000200','Disscussion-SmallGroup',4,' ','participant5','000200','Disscussion-SmallGroup',5,' ','participant5','000200','Disscussion-SmallGroup');

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','[REDACTED]', '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-SmallGroup',2,'start discussion the ideas','all','000600','IdeasDiscussion-SmallGroup',3,'vote on ideas','all','000100','IdeasVoting-SmallGroup',4,'submit the result based on ideas rating','chairperson','000200','OwnResolution-EntireSession');

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,n2,ins2,tr2,tl2,tool2) values ('Brainstorm', 'default',1,'read related info ','all','000500','textInfo-EntireSession',2,'start brainstorming','all','001000','IdeasPosting-SmallGroup');



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',' ',' ',' ',' ',' ', 'Idea 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','Disscussion-SmallGroup',2,'Second the Proposer','seconder(p)','000300','Disscussion-SmallGroup',3,'Oppose the motion','opposer','000500','Disscussion-SmallGroup',4,'Second the Opposer','seconder(o)','000300','Disscussion-SmallGroup',5,'Speak From The Floor','speakers','001000','Disscussion-SmallGroup',6,'Sum up for the motion','proposer','000300','Disscussion-SmallGroup',7,'Sum up for the opposition','opposer','000300','Disscussion-SmallGroup',8,'Do you support the proposor','all','000100','YesNo-EntireSession');

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,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','textInfo-EntireSession',2,'Identify concept and parts of the problem that needs clarification','all','000300','IndividualTextWriting-None',3,'Define the problem','all','000500','IndividualTextWriting-None',4,'Brainstorm  about solutions','all','000300','IdeasPosting-SmallGroup',5,'Structure solutions or causes','all','001000','IndividualTextWriting-None',6,'state learning objectives','all','000300','IndividualTextWriting-None',7,'Self study directed towards learning objectives ','all','001300','InternetSearch-None',8,'report things learned and application to problem','all','001000','SharedText-SmallGroup');

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 ('Jigsaw', 'default',1,'study a particular sub problem','all','001000','textInfo-Role',2,'exchanging ideas with your expert groups ','all','001000','Disscussion-Roles',3,'jigsaw group participants meet to solve the whole problem','all','001500','Disscussion-SmallGroup');

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_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','textInfo-Role',2,'exchanging ideas with your side group ','all','001000','Disscussion-Roles',3,'the whole group participants meet to discuss and argue','all','001500','Disscussion-SmallGroup');

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 ('Think Pair Share', 'default',1,'think silently about this question  ','all','001000','textInfo-EntireSession',2,'exchanging ideas with your partner','all','001000','Disscussion-SmallGroup',3,'exchange ideas with the whole session','all','001500','Disscussion-EntireSession');

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 solution-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 ('Pyramid', 'default',1,'think silently about question posed ','all','001000','textInfo-EntireSession',2,'exchanging ideas with your partners','all','001000','Disscussion-SmallGroup',3,'exchange ideas with the whole session','all','001500','SharedText-EntireSession');

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_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','textInfo-SmallGroup',2,'exchanging ideas with your partners','all','001000','Disscussion-SmallGroup',3,'submit your own resolution','chairperson','001500','SharedText-EntireSession');

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','textInfo-Role',2,'each role should start role palying ','all','001000','Disscussion-SmallGroup',3,'Debrifing','all','000300','Debriefing-EntireSession');

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','DownloadFile-EntireSession',2,'question 1','all','000300','QA-EntireSession',3,'question 2','all','000300','QA-EntireSession');




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, analysing 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','Disscussion-EntireSession',2,'exchanging ideas with your partner','all','001000','Disscussion-SmallGroup',3,'submit your own resolution','all','000300','OwnResolution-EntireSession');

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-EntireSession',2,'discussion and questioning','all','001000','Disscussion-EntireSession');

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','Disscussion-SmallGroup',2,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','Disscussion-SmallGroup',3,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','Disscussion-SmallGroup',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','Disscussion-SmallGroup',5,'N3 Affirmative Debater s Constructive Speech ','N3Affirmative','000400','Disscussion-SmallGroup',6,'N3 Negative Debater s Constructive Speech ','N3Negative','000400','Disscussion-SmallGroup',7,'Brief preparation time ','all','000500','IndividualWriting',8, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000300','Disscussion-SmallGroup',9,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000300','Disscussion-SmallGroup',10,'N1 Negative Debater s Constructive Speech ',' N1Negative','000300','Disscussion-SmallGroup',11,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000300','Disscussion-SmallGroup',12,'N3 Negative Debater s Rebuttal Speech ','N3Negative','000300','Disscussion-SmallGroup',13,'N3 Affirmative Debater s Rebuttal Speech ','N3Affirmative','000100','Disscussion-SmallGroup',14,'Audience Questioning ','all','001500','Disscussion-SmallGroup');

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','Disscussion-SmallGroup',2,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','Disscussion-SmallGroup',3,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','Disscussion-SmallGroup',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','Disscussion-SmallGroup',5,'Brief preparation time ','all','000500','IndividualWriting',6,'N1 Negative Debater s Constructive Speech ',' N1Negative','000300','Disscussion-SmallGroup',7,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000300','Disscussion-SmallGroup',8, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000300','Disscussion-SmallGroup',9,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000300','Disscussion-SmallGroup',10,'Audience Questioning ','all','001500','Disscussion-SmallGroup');

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 ) values ('Debate', ' A typical Oxford format ',1, '1st Negative (constructive and rebuttal speech) ','N1Affirmative','000400','Disscussion-SmallGroup',2,'1st Negative (constructive and rebuttal speech)', 'N1Negative','000400','Disscussion-SmallGroup',3,'2nd Affirmative (constructive and rebuttal speech)','N2Affirmative','000400','Disscussion-SmallGroup',4,' 4- 2nd Negative (constructive and rebuttal speech)','N2Negative','000400','Disscussion-SmallGroup',5,'3rd Affirmative (constructive and rebuttal speech)','N3Affirmative','000400','Disscussion-SmallGroup',6,'3rd Negative (constructive and rebuttal speech) ','N3Negative','000400','Disscussion-SmallGroup',7,'N1 Affirmative  Rebuttal Speech ','N1Affirmative','000300','Disscussion-SmallGroup');

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', ' Modified Oxford format ',1, ' 1-  1st Affirmative (constructive speech)','N1Affirmative','000400','Disscussion-SmallGroup',2,'Cross-examination by 2nd Negative', 'N2Negative','000400','Disscussion-SmallGroup',3,'1st Negative (constructive speech)','N1Negative','000400','Disscussion-SmallGroup',4,'Cross-examination by 1st Affirmative)','N1Affirmative','000400','Disscussion-SmallGroup',5,'2nd Affirmative (constructive speech)','N2Affirmative','000400','Disscussion-SmallGroup',6,'Cross-examination by 1st Negative)','N1Negative','000400','Disscussion-SmallGroup',7,'2nd Negative (constructive speech) ', 'N2Affirmative','000300','Disscussion-SmallGroup',8,'Cross Examination by 2nd Affirmative',' N2Affirmative','000300','Disscussion-SmallGroup',9,'1st Negative (rebuttal-defence-summary speech)','N1Negative','000300','Disscussion-SmallGroup',10,'1st Affirmative (rebuttal-defence-summary speech)','N1Affirmative','000300','Disscussion-SmallGroup');

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','Disscussion-SmallGroup',2,'N1 Negative Debater s Constructive Speech ','N1Negative','000400','Disscussion-SmallGroup',3,'N2 Affirmative Debater s Constructive Speech ', 'N2Affirmative','000400','Disscussion-SmallGroup',4,'N2 Negative Debater s Constructive Speech ','N2Negative','000400','Disscussion-SmallGroup',5,'N3 Affirmative Debater s Constructive Speech ', 'N3Affirmative','000400','Disscussion-SmallGroup',6,'N3 Negative Debater s Constructive Speech ','N3Negative','000400','Disscussion-SmallGroup',7,'N1 Negative Debater s Rebuttal Speech ',' N1Negative','000400','Disscussion-SmallGroup',8,'N1 Affirmative Debater s Rebuttal Speech ','N1Affirmative','000400','Disscussion-SmallGroup',9, 'N2 Negative Debater s Rebuttal Speech ','N2Negative','000400','Disscussion-SmallGroup',10,'N2 Affirmative Debater s Rebuttal Speech ', 'N2Affirmative','000400','Disscussion-SmallGroup',11, 'N3 Negative Debater s Rebuttal Speech ','N2Negative','000400','Disscussion-SmallGroup',12,'N3 Affirmative Debater s Rebuttal Speech ', 'N3Affirmative','000400','Disscussion-SmallGroup');


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,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,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,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,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',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');


