Index: openacs-4/packages/beehive/beehive.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/beehive.info,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/beehive.info 10 May 2006 05:38:45 -0000 1.1
@@ -0,0 +1,33 @@
+
+
+
+
+ beehive
+ beehives
+ f
+ f
+
+
+ Aiman Turani
+ Provides an authoring environment to create synchronous collaborative activities that run on the FlashComm server. (needs an installed FlashComm server)
+ 2006-04-27
+ sydney university
+ Beehive's framework enables teachers to develop effective, flexible, customizable and reusable pedagogical tools. It also enables teachers to define the collaboration script, which describes how members would collaborate within each activity session.
+ 0
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/beehive/catalog/beehive.en_US.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/catalog/beehive.en_US.ISO-8859-1.xml,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/catalog/beehive.en_US.ISO-8859-1.xml 10 May 2006 05:38:45 -0000 1.1
@@ -0,0 +1,34 @@
+
+
+
+ Continue
+ by learners
+ Controlling the session (activating/terminating)
+ Controlling the timer
+ Date
+ This is when the live session will start
+ Day
+ Group default size
+ Group formation
+ Group maximum size
+ Group minimum size
+ Hour
+ Month
+ Providing the session date
+
+ Providing the collaboration script
+ Session Randomly by system
+ Specific Roles
+ You may want every group member to have the same role (participant) or you may want to include special roles (moderator, secretary, judge, etc.). To include more than one role, separate them with forward slash /.
+If the size of the group is greater than the number of roles, the last role that you list will be the default for the rest.
+ Context
+ Example
+ Groups structure
+ Technique name
+ Problem
+ Solution <br>Flow of Events
+ Version name
+ Title
+ This is the session title your students will see
+ Year
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/sql/postgresql/beehive-create.sql 10 May 2006 05:38:45 -0000 1.1
@@ -0,0 +1,218 @@
+--
+-- packages/beehive/sql/beehive-create.sql
+--
+-- @author turani
+-- @creation-date 2000-10-22
+-- @cvs-id $Id: beehive-create.sql,v 1.1 2006/05/10 05:38:45 ncarroll 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(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_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_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_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_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) );
+
+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(5000), 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 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 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 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 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 ('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 ('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 ('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 ('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 ('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 ( '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 ('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) values ('Group Discussion', 'default',1,'start discussion ','all','000600','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_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_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_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_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1) values ('Brainstorm', 'default',1,'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_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)
+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_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_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 ('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,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 ('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) 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) 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,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) 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,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_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');
+
+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','SmallGroupDisscussion',2,'1st Negative (constructive and rebuttal speech)', 'N1Negative','000400','SmallGroupDisscussion',3,'2nd Affirmative (constructive and rebuttal speech)','N2Affirmative','000400','SmallGroupDisscussion',4,' 4- 2nd Negative (constructive and rebuttal speech)','N2Negative','000400','SmallGroupDisscussion',5,'3rd Affirmative (constructive and rebuttal speech)','N3Affirmative','000400','SmallGroupDisscussion',6,'3rd Negative (constructive and rebuttal speech) ','N3Negative','000400','SmallGroupDisscussion',7,'N1 Affirmative Rebuttal Speech ','N1Affirmative','000300','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', ' Modified Oxford format ',1, ' 1- 1st Affirmative (constructive speech)','N1Affirmative','000400','SmallGroupDisscussion',2,'Cross-examination by 2nd Negative', 'N2Negative','000400','SmallGroupDisscussion',3,'1st Negative (constructive speech)','N1Negative','000400','SmallGroupDisscussion',4,'Cross-examination by 1st Affirmative)','N1Affirmative','000400','SmallGroupDisscussion',5,'2nd Affirmative (constructive speech)','N2Affirmative','000400','SmallGroupDisscussion',6,'Cross-examination by 1st Negative)','N1Negative','000400','SmallGroupDisscussion',7,'2nd Negative (constructive speech) ', 'N2Affirmative','000300','SmallGroupDisscussion',8,'Cross Examination by 2nd Affirmative',' N2Affirmative','000300','SmallGroupDisscussion',9,'1st Negative (rebuttal-defence-summary speech)','N1Negative','000300','SmallGroupDisscussion',10,'1st Affirmative (rebuttal-defence-summary speech)','N1Affirmative','000300','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,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,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,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,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,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) ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ');
+
+
Index: openacs-4/packages/beehive/sql/postgresql/beehive-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/sql/postgresql/beehive-drop.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/sql/postgresql/beehive-drop.sql 10 May 2006 05:38:45 -0000 1.1
@@ -0,0 +1,10 @@
+drop table beehive_tasks;
+drop table beehive_sesf;
+drop table beehive_sesstudents;
+drop table beehive_pattern;
+drop table beehive_ses;
+drop table beehive_sesscript;
+drop table beehive_patscript;
+drop table beehive_emptypatscript;
+drop table beehive_sessionIntraction;
+
Index: openacs-4/packages/beehive/www/communication.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/communication.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/communication.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,68 @@
+ad_page_contract {
+
+ to get info from .lrn back to flash server
+
+ @author aiman turani (aimant@ee.usyd.edu.au)
+
+} {
+
+{ command: "PutParamI" }
+{ se: 1 }
+{ user_id: 496 }
+{ group: 0 }
+{ textdate: "test" }
+{ Type_Interaction: " " }
+{ student_response: " " }
+{ instruction_number: 1 }
+
+
+} -properties {
+ tit:onelist
+ des:onelist
+ dur:onelist
+ cla:onelist
+ tut:onelist
+ sty:onelist
+ teacherid:onelist
+ flashserver:onelist
+
+}
+
+# get the user name
+set name [acs_user::get_element -user_id $user_id -element name]
+
+set package_id [ad_conn package_id]
+
+
+# get the locale language name
+#set locale [lang::user::locale]
+#set filepath [lang::catalog::get_catalog_file_path -locale $locale -package_key $package_id]
+#set filename_start [string first $locale $filepath ]
+#set filename_end [string last l $filepath ]
+#set file_label [string range $filepath $filename_start $filename_end]
+
+
+
+
+
+
+# when the flash application is requiring session information from database
+if { $command == "getparameter" } {
+ set teacherid [db_list get_t {SELECT teacherid FROM beehive_sesf where snumber = :se}]
+ set cla [db_list get_classsname {SELECT classname FROM beehive_ses where number = :se}]
+
+ ns_return 200 text/html "teacherid=[lindex $teacherid 0]&classn=[lindex $cla 0]&na=$name "
+
+
+# when the flash application requires storing interaction information in the database
+ } elseif {$command == "PutParamI"} {
+
+
+ db_dml insert_interaction { insert into beehive_sessionIntraction (sname,textdate,Type_Interaction,student_response,se,gr,instruction_number) values (:name,:textdate,:Type_Interaction,:student_response,:se,:group,:instruction_number ) }
+
+ns_return 200 text/html "title=inserted "
+ } else {
+ ns_return 200 text/html "title=wrong command"
+ }
+
+
Index: openacs-4/packages/beehive/www/configure-end.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/configure-end.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/configure-end.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,76 @@
+
+
+
#beehive.addresses_updated#
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/beehive/www/configure-end.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/configure-end.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/configure-end.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,21 @@
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman
+ @creation-date 2004-04-10
+ @cvs-id $Id: configure-end.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+
+} {
+
+{ flashs: " " }
+{ surl: " " }
+
+}
+
+set flashss [parameter::set_value -parameter "FlashComServer" -value $flashs]
+set surll [parameter::set_value -parameter "systemURL" -value $surl]
+ad_return_template
+
+
Index: openacs-4/packages/beehive/www/configure.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/configure.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/configure.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,94 @@
+
+
+configuration
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/beehive/www/configure.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/configure.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/configure.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,21 @@
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman
+ @creation-date 2004-04-10
+ @cvs-id $Id: configure.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+ This page allow user to change the system url and the flash comm server address
+
+}
+
+
+
+
+set testflag [parameter::set_value -parameter "firstTimeFlage" -value 1]
+set flashs [parameter::get -parameter "FlashComServer"]
+set surl [parameter::get -parameter "systemURL"]
+
+ad_return_template
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,34 @@
+
+
+ postgresql7.3
+
+
+
+
+ SELECT * from beehive_pattern where num = :technique_num
+
+
+
+
+
+ SELECT * from beehive_ses where number = :number
+
+
+
+
+ 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)
+
+
+
+
+ UPDATE beehive_pattern SET roles= :roles,mx= :mx,mn= :mn,df= :df WHERE num = :technique_num
+
+
+
+
+ UPDATE beehive_ses SET roles = :roles,mx = :mx ,mn = :mn,df= :df,datew= :datew,titlew= :titlew,stype =:technique_name WHERE number =:number
+
+
+
+
+
Index: openacs-4/packages/beehive/www/create-edit-session.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,19 @@
+
+
+
+New
+
+#beehive.Stored_Session_Title#
+ "@technique_name@"
+)
+
+
+
+
+@page_title@
+@context;noquote@
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,185 @@
+
+ad_page_contract {
+
+ The logic for the beehive.
+
+ @author aiman (aimant@ee.usyd.edu.au)
+ @creation-date 2005-01-10
+ @cvs-id $Id: create-edit-session.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ This is the first page for creating/editing a session which includes the defining of the:
+ title, date, and the groups structures
+ @parameter
+} {
+
+ number:optional
+{ edit_flage: 11 }
+{ group: " " }
+{ technique_num: 55 }
+{ technique_name "" }
+{ technique_version ""}
+{ newtechnique_flage: 55 }
+{redirect_url {[ns_set iget [ns_conn headers] referer]}}
+
+
+
+} -properties {
+ session:multirow
+ context:onevalue
+}
+
+
+
+if {$edit_flage != 0 } {
+# if it is a new session then get the session's default groups structure
+# technique's number from the Beehive pattern table
+
+ #initilize variables
+ set titlew ""
+ set datew ""
+ # initilze value incase of new pattern
+ set roles ""
+ set mx ""
+ set mn ""
+ set df ""
+ set techniqe $technique_name
+ set name $technique_version
+
+ # to get the default roles and group size for the selected technique from the pattern table
+ db_multirow session get_info_from_pattern {}
+ template::multirow foreach session {
+
+ }
+ set technique_name $techniqe
+ set technique_version $name
+
+ # Customize the page title to reflect the fact that this form is used to
+ # create a new session.
+ set page_title "New Session"
+
+ # get the user name to store it as the creator of this session
+ set user_id [ad_conn user_id]
+ set namet [acs_user::get_element -user_id $user_id -element name]
+
+
+
+
+} else {
+
+# in case of updating an existing session, get the title, and date
+
+ db_multirow session get_info_from_stored_session {}
+
+ template::multirow foreach session {
+ }
+
+ # Customize the page title to reflect the fact that this form is used to
+ # edit session.
+ set page_title "Edit Session"
+ set technique_name $stype
+ set technique_version $name
+
+}
+
+# Add the page title to the breadcrumb context bar.
+set context [list $page_title]
+
+
+
+ad_form -name activity_entery_form -cancel_url $redirect_url -form {
+ number:key(acs_object_id_seq)
+
+
+
+ {titlew:text(text)
+ {label "#beehive.Session_Title# "}
+ {html {size 51}}
+ {value "$titlew"}
+ }
+
+ {roles:text(text)
+ {label "#beehive.Session_Specific_Roles#"}
+ {html {size 50}}
+ {help_text "[_ beehive.Session_Specific_Roles_text]" }
+ {value "$roles"}
+
+ }
+
+ {datew:date(date),to_sql(linear_date),from_sql(sql_date)
+ {label "#beehive.Session_Date#"}
+ {help}
+ {value "$datew"}
+ {format "YYYY MONTH DD HH24 MI"}
+
+ }
+
+ {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"}
+ }
+ {df:text(text)
+ {label "#beehive.Session_Group_default_size#"}
+ {html {size 3}}
+ {value "$df"}
+ }
+ {edit_flage:text(hidden)
+ {value $edit_flage}
+ }
+
+
+ {technique_name:text(hidden)
+ {value $technique_name}
+ }
+ {technique_version:text(hidden)
+ {value $technique_version}
+ }
+ {technique_num:text(hidden)
+ {value $technique_num}
+ }
+
+ {group:text(hidden)
+ {value $group}
+ }
+ {newtechnique_flage:text(hidden)
+ {value $newtechnique_flage}
+ }
+ {redirect_url:text(hidden)
+ {value $redirect_url}
+ }
+
+
+
+} -select_query {
+ SELECT * from beehive_ses where number = :number
+
+} -new_data {
+ db_dml new_session_sql {}
+ if {$newtechnique_flage == 0 } {
+ db_dml update_pattern_value {}
+ }
+
+} -edit_data {
+ db_dml session_update {}
+
+
+} -after_submit {
+ set session_id $number
+ set url_import_var [export_vars {edit_flage technique_name technique_num session_id roles newtechnique_flage redirect_url}]
+ ad_returnredirect "create-edit-session2?$url_import_var"
+
+
+ ad_script_abort
+}
+
+
+ad_return_template
+
+
Index: openacs-4/packages/beehive/www/create-edit-session1-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session1-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session1-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,61 @@
+
+
+ postgresql7.3
+
+
+
+
+ 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,dtype1,anon1,anon2,anon3,anon4) values (:techniqes,:names,: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,:dtype1,:anon1,:anon2,:anon3,:anon4)
+
+
+
+
+
+
+
+
+ insert into beehive_ses (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) values (:namet,:roles,:mx,:mn,:df,:datew,:titlew,:comm_namew,:stypew,: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)
+
+
+
+
+
+
+
+ SELECT * from beehive_pattern where num = :numberp
+
+
+
+
+
+ SELECT * from beehive_ses WHERE tutor = :namet AND stype= :stypew AND datew= :datew AND titlew= :titlew
+
+
+
+
+
+
+ insert into beehive_sesf (snumber,teacherid) values (:number,:user_id)
+
+
+
+
+
+
+
+
+
+ UPDATE beehive_ses SET roles = :roles,mx = :mx ,mn = :mn,df= :df,datew= :datew,titlew= :titlew,stype =:stypew,t2= :t2,t4= :t4,t5= :t5,t6= :t6,t7= :t7,t8= :t8,t9= :t9,t10= :t10,t11= :t11,t12= :t12,t13= :t13,t14= :t14,t15= :t15,t17= :t17,t18 =:t18,t19 =:t19,t20 =:t20,t22 =:t22,t23 =:t23,t24 =:t24,t26 =:t26,t27 =:t27,t28 =:t28,t29 =:t29,t30 =:t30,t31 =:t31,t32 =:t32,t33 =:t33,t34 =:t34,t35 =:t35,t36 =:t36 ,t37 =:t37,t38 =:t38,ctype1 =:ctype1,ctype2 =:ctype2,ctype3 =:ctype3,controlld1 =:controlld1,controlld2 =:controlld2,adda1 =:adda1,addv1 =:addv1,adda2 =:adda2,addv2 =:addv2,adda3 =:adda3,addv3 =:addv3,anon1 =:anon1,anon2 =:anon2,anon3 =:anon3,anon4 =:anon4,btype1 =:btype1,btype2 =:btype2, dtype1 =:dtype1,sln =:sln WHERE number =:session_id0
+
+
+
+
+
+
+
+
+ SELECT * from beehive_ses WHERE number = :session_id0
+
+
+
+
Index: openacs-4/packages/beehive/www/create-edit-session1.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session1.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session1.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,248 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/beehive/www/create-edit-session1.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session1.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session1.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,169 @@
+
+
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman turani
+ @creation-date 2005-04-10
+ @cvs-id $Id: create-edit-session1.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ This page is responsible of filling/updating all related field needed by chosen tasks
+ and it check if the user didn't change the default dynamic task to present the default
+ script for these tasks
+
+} {
+
+
+{ edit0: " " }
+{ session_id0: " " }
+{ techniqes: " " }
+{ names: " " }
+{ name0: " " }
+{ stypew: " " }
+{ number: 1 }
+{ numberp: 1 }
+{ comm_namew: " " }
+{ roles: " " }
+{ mx: " " }
+{ mn: " " }
+{ df: " " }
+{ hour: " " }
+{ day: " " }
+{ month: " " }
+{ year: " " }
+{ sln: 0 }
+{ titlew: " " }
+{ task:array }
+{ ctype: "1" }
+{ btype: " " }
+{ dtype1: " " }
+{ controlld: " " }
+{ adda1: " " }
+{ addv1: " " }
+{ adda2: " " }
+{ addv2: " " }
+{ adda3: " " }
+{ addv3: " " }
+{ anon1: " " }
+{ anon2: " " }
+{ anon3: " " }
+{ anon4: " " }
+{ problem: " " }
+{ example: " " }
+{ context: " " }
+{ gstructure: " " }
+{ solution: " " }
+
+
+} -properties {
+ rolesl:onelist
+ session:multirow
+ info:multirow
+
+}
+
+# initialization tasks variables
+
+for {set i 2} {$i <= 38} {incr i} {
+ set [subst {t$i}] " "
+}
+# mandatory task
+set t5 "checked"
+
+# assigning tasks variables to the task array t
+foreach name [array names task] {
+
+eval set [subst {t$name}] $[subst {task($name)}]
+
+}
+
+
+
+# set a flag if no related info for selected tasks is required
+set relatedflag " "
+if { $t12 != "checked" && $t33 != "checked" && $t35 != "checked" && $t32 != "checked" && $t13 != "checked" && $t14 != "checked" && $t36 != "checked" && $t18 != "checked" && $t20 != "checked" } {
+ set relatedflag "false"
+}
+
+
+
+
+# get the user name to make it the creator of this session
+set user_id [ad_conn user_id]
+set namet [acs_user::get_element -user_id $user_id -element name]
+
+# set the date
+set datew [subst {$hour:00-$day/$month/$year}]
+
+
+# btype contains the level parameter (group/all) for the idea listing task's combo-box ,
+# and needs to be processed before storing in the database
+set btype1 " "
+set btype2 " "
+ if {$btype == "1" } {
+ set btype1 "checked"
+
+ } elseif {$btype == "2" } {
+ set btype2 "checked"
+ }
+
+
+# controlld contains the ideas source parameter (teacher/learners) for the idea voting task's combo-box ,
+# and needs to be processed before storing in the database
+set controlld1 " "
+set controlld2 " "
+ if {$controlld == "1" } {
+ set controlld1 "checked"
+
+ } elseif {$controlld == "2" } {
+ set controlld2 "checked"
+ }
+
+
+# other types of parameters for combo-boxes currently not used but they exist in the database
+set ctype1 " "
+set ctype2 " "
+set ctype3 " "
+
+
+
+# to split roles according to / char
+set rolesl [split $roles "/"]
+
+
+
+# it is a new pattern save it in the repository
+if {$numberp == 0 } {
+ db_dml insert_pattern_value {}
+ set stypew $techniqes
+}
+
+# it is a new session save the session values and
+if {$edit0 != 0 } {
+ db_dml insert_session_values {}
+
+
+ # get the info for this session and save the user id in the info table
+ db_multirow session get_session_info {}
+ template::multirow foreach session {
+ }
+ set instructionText $solution
+ db_dml save_session_creator_info {}
+
+
+# else it is not a new session so update the session
+} else {
+
+ db_dml update_values_of_session {}
+ # get all its information in the session variable to match
+ # the above case to avoid naming conflict
+ db_multirow session get_info {}
+ template::multirow foreach session {
+ }
+
+ set name $names
+ set instructionText $it
+}
+
+ad_return_template
\ No newline at end of file
Index: openacs-4/packages/beehive/www/create-edit-session2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session2-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session2-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,28 @@
+
+
+ postgresql7.3
+
+
+
+
+ SELECT * from beehive_pattern where num = :technique_num
+
+
+
+
+
+ SELECT * from beehive_ses where number = :session_id
+
+
+
+
+
+
+
+ insert into beehive_sesf (snumber,teacherid) values (:session_id,:user_id)
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session2.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,282 @@
+
+
+@page_title@
+@context;noquote@
+
+
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session2.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,95 @@
+
+ad_page_contract {
+
+ The logic for the beehive.
+
+ @author aiman (aimant@ee.usyd.edu.au)
+ @creation-date 2005-01-10
+ @cvs-id $Id: create-edit-session2.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ This page for creating/editing a session which includes the defining of the technique's tasks
+
+} {
+
+{ edit_flage: 11 }
+{ session_id: 11 }
+{ group: " " }
+{ technique_num: -1 }
+{ technique_name "" }
+{ roles "" }
+{ newtechnique_flage: 55 }
+
+
+
+
+
+
+
+} -properties {
+ session:multirow
+ context:onevalue
+
+
+}
+
+
+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
+
+
+ # initialization tasks variables
+
+ for {set i 2} {$i <= 38} {incr i} {
+ 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 {
+ set flag1 "true"
+ }
+
+ if {$flag1 == "false" } {
+ # initialize other input fields of the new created technique
+ set ctype1 " " ;set ctype2 " " ;set ctype3 " " ;set btype1 " " ;set btype2 " " ;set btype3 " " ;set dtype1 " " ;set controlld1 " ";set controlld2 " " ;set adda1 " " ;set addv1 " " ;set adda2 " " ;set addv2 " " ;set adda3 " ";set addv3 " " ;set anon1 " " ;set anon2 " " ;set anon3 " " ;set anon4 " "
+
+ }
+ set sln 1
+ # Customize the page title to reflect the fact that this form is used to
+ # create a new session.
+ set page_title "New Session"
+
+ # get the user name to make it the creator of this session
+ set user_id [ad_conn user_id]
+ # save the creator name
+ db_dml save_session_creator_info {}
+
+
+# in case of updating an existing session, get the tasks
+} else {
+ # get the default tasks for the selected technique from the stored sessions table
+ db_multirow session get_info_from_stored_session {}
+
+ # get the title, date, type, and session id form the stored technique and set them to new
+
+ template::multirow foreach session {
+ }
+
+
+ # Customize the page title to reflect the fact that this form is used to
+ # edit session.
+ set page_title "Edit Session"
+
+}
+
+
+
+# Add the page title to the breadcrumb context bar.
+set context [list $page_title]
+
+
+ad_return_template
+
+
Index: openacs-4/packages/beehive/www/create-edit-session3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session3-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session3-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,41 @@
+
+
+ postgresql7.3
+
+
+
+
+
+
+ SELECT * from beehive_pattern where num = :technique_num
+
+
+
+
+
+
+
+ UPDATE beehive_pattern SET t2= :t2,t4= :t4,t5= :t5,t6= :t6,t7= :t7,t8= :t8,t9= :t9,t10= :t10,t11= :t11,t12= :t12,t13= :t13,t14= :t14,t15= :t15,t17= :t17,t18 =:t18,t19 =:t19,t20 =:t20,t22 =:t22,t23 =:t23,t24 =:t24,t26 =:t26,t27 =:t27,t28 =:t28,t29 =:t29,t30 =:t30,t31 =:t31,t32 =:t32,t33 =:t33,t34 =:t34,t35 =:t35,t36 =:t36 ,t37 =:t37,t38 =:t38,ctype1 =:ctype1,ctype2 =:ctype2,ctype3 =:ctype3,controlld1 =:controlld1,controlld2 =:controlld2,adda1 =:adda1,addv1 =:addv1,adda2 =:adda2,addv2 =:addv2,adda3 =:adda3,addv3 =:addv3,anon1 =:anon1,anon2 =:anon2,anon3 =:anon3,anon4 =:anon4,btype1 =:btype1,btype2 =:btype2, dtype1 =:dtype1 WHERE num =:technique_num
+
+
+
+
+
+
+
+
+
+ UPDATE beehive_ses SET t2= :t2,t4= :t4,t5= :t5,t6= :t6,t7= :t7,t8= :t8,t9= :t9,t10= :t10,t11= :t11,t12= :t12,t13= :t13,t14= :t14,t15= :t15,t17= :t17,t18 =:t18,t19 =:t19,t20 =:t20,t22 =:t22,t23 =:t23,t24 =:t24,t26 =:t26,t27 =:t27,t28 =:t28,t29 =:t29,t30 =:t30,t31 =:t31,t32 =:t32,t33 =:t33,t34 =:t34,t35 =:t35,t36 =:t36 ,t37 =:t37,t38 =:t38,ctype1 =:ctype1,ctype2 =:ctype2,ctype3 =:ctype3,controlld1 =:controlld1,controlld2 =:controlld2,adda1 =:adda1,addv1 =:addv1,adda2 =:adda2,addv2 =:addv2,adda3 =:adda3,addv3 =:addv3,anon1 =:anon1,anon2 =:anon2,anon3 =:anon3,anon4 =:anon4,btype1 =:btype1,btype2 =:btype2, dtype1 =:dtype1,sln =:sln WHERE number =:session_id
+
+
+
+
+
+
+
+
+ SELECT * from beehive_ses WHERE number = :session_id
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session3.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,126 @@
+
+
+
+
+
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session3.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,119 @@
+
+
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman turani
+ @creation-date 2005-04-10
+ @cvs-id $Id: create-edit-session3.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ This page is responsible of saving selected tasks for the created session
+
+} {
+
+
+{ edit_flage: " " }
+{ session_id: 11 }
+{ technique_name: " " }
+{ technique_num: 11 }
+{ taskn:array }
+{ ctype: "1" }
+{ btype: " " }
+{ dtype1: " " }
+{ controlld: " " }
+{ adda1: " " }
+{ addv1: " " }
+{ adda2: " " }
+{ addv2: " " }
+{ adda3: " " }
+{ addv3: " " }
+{ anon1: " " }
+{ anon2: " " }
+{ anon3: " " }
+{ anon4: " " }
+{ sln: 0 }
+{ roles: " " }
+{ newtechnique_flage: 55 }
+
+} -properties {
+
+ session:multirow
+
+}
+
+
+
+# initialization tasks variables
+
+for {set i 2} {$i <= 38} {incr i} {
+ set [subst {t$i}] " "
+}
+# mandatory task
+set t5 "checked"
+
+# assigning tasks variables to the task array t
+foreach name [array names taskn] {
+
+eval set [subst {t$name}] $[subst {taskn($name)}]
+
+}
+
+
+
+# btype contains the level parameter (group/all) for the idea listing task's combo-box ,
+# and needs to be processed before storing in the database
+set btype1 " "
+set btype2 " "
+ if {$btype == "1" } {
+ set btype1 "checked"
+
+ } elseif {$btype == "2" } {
+ set btype2 "checked"
+ }
+
+
+# controlld contains the ideas source parameter (teacher/learners) for the idea voting task's combo-box ,
+# and needs to be processed before storing in the database
+set controlld1 " "
+set controlld2 " "
+ if {$controlld == "1" } {
+ set controlld1 "checked"
+
+ } elseif {$controlld == "2" } {
+ set controlld2 "checked"
+ }
+
+
+# other types of parameters for combo-boxes currently not used but they exist in the database
+set ctype1 " "
+set ctype2 " "
+set ctype3 " "
+
+if {$newtechnique_flage == 0 } {
+# it is a new pattern. Save tasks in the pattern's repository
+db_dml update_pattern_value {}
+
+}
+
+# save the session's tasks
+db_dml update_values_of_session {}
+
+#get session complete info to be used in adp page
+ db_multirow session get_info {}
+ template::multirow foreach session {
+ }
+
+
+# set a flag if no related info for selected tasks is required
+set relatedflag " "
+if { $t33 != "checked" && $t32 != "checked" && $t18 != "checked" && $t20 != "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"
+
+
+}
+
+
+ad_return_template
\ No newline at end of file
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session4-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,42 @@
+
+
+ postgresql7.3
+
+
+
+
+
+
+ SELECT * from beehive_pattern where num = :technique_num
+
+
+
+
+
+
+
+ UPDATE beehive_ses SET ig = :ig , el = :el WHERE number = :session_id
+
+
+
+
+
+
+
+ SELECT * from beehive_ses where number = :session_id
+
+
+
+
+
+ UPDATE beehive_ses SET el = :ell WHERE number = :session_id
+
+
+
+
+
+ UPDATE beehive_ses SET ig = :igg WHERE number = :session_id
+
+
+
+
\ 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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session4.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,163 @@
+
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman turani
+ @creation-date 2005-04-10
+ @cvs-id $Id: create-edit-session4.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+ This page is responsible of uploading/updating files needed by chosen tasks
+
+} {
+
+{ session_id: 1 }
+{ edit_flage: 11 }
+{ technique_num: 11 }
+{ technique_name: " " }
+{ roles: " " }
+
+
+{ ig: " " }
+{ el: " " }
+{ igg: " " }
+{ ell: " " }
+{ sln: 0 }
+{ newtechnique_flage: 55 }
+
+
+} -properties {
+ session:multirow
+
+}
+
+
+set tools " "
+
+
+
+# to update/save uploaded files names
+db_dml edit_values {}
+
+
+# get the session's tasks
+db_multirow session get_info_from_session_script {}
+template::multirow foreach session {
+ }
+
+
+
+# to upload files if slides option was selected
+ if {$t18 == "checked" } {
+ for {set i 1} {$i <= $sln} {incr i} {
+ set localfile [ns_queryget [subst {slide$i}]]
+
+ if {$localfile != "" } {
+ set ifp [open [ns_queryget [subst {slide$i}].tmpfile] r]
+
+ # open the filename for writing
+
+ set pth [acs_root_dir]
+ set filename [subst {$pth/packages/beehive/www/slides/[subst {sess$session_id}]Slide$i.jpg}]
+
+ set ofp [open $filename w+]
+
+ fconfigure $ifp -translation binary
+ fconfigure $ofp -translation binary
+
+ ns_cpfp $ifp $ofp
+
+ close $ifp
+ close $ofp
+ }
+ }
+ }
+
+
+# to upload file for withe board drawing
+ if {$t20 == "checked" } {
+
+ set localfilewb [ns_queryget sld]
+
+ if {$localfilewb != "" } {
+ set ifpwb [open [ns_queryget [subst {sld}].tmpfile] r]
+
+ # open the filename for writing
+
+ set pthwb [acs_root_dir]
+ set filenamewb [subst {$pthwb/packages/beehive/www/slides/[subst {sess$session_id}]Slide.jpg}]
+
+ set ofpwb [open $filenamewb w+]
+
+ fconfigure $ifpwb -translation binary
+ fconfigure $ofpwb -translation binary
+
+ ns_cpfp $ifpwb $ofpwb
+
+ close $ifpwb
+ close $ofpwb
+ }
+
+ }
+
+# 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]
+
+ if {$localfiledf != "" } {
+ set ifpdf [open [ns_queryget [subst {ig}].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 ofpdf [open $filenamedf w+]
+
+ fconfigure $ifpdf -translation binary
+ fconfigure $ofpdf -translation binary
+
+ ns_cpfp $ifpdf $ofpdf
+
+ close $ifpdf
+ close $ofpdf
+ } else {
+ # to update staged file name
+ db_dml edit_value3 {}
+ }
+
+ }
+
+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-session5-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session5-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,19 @@
+
+
+ postgresql7.3
+
+
+
+ SELECT * from beehive_ses WHERE number = :session_id
+
+
+
+
+
+
+
+ UPDATE beehive_ses SET st = :st , srt = :srt , idn = :idn ,idt = :idt,ih = :ih , it = :it , ynt = :ynt WHERE number = :session_id
+
+
+
+
Index: openacs-4/packages/beehive/www/create-edit-session5.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session5.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session5.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,6 @@
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session5.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,199 @@
+
+
+ad_page_contract {
+
+ The logic for the beehive.
+
+ @author aiman (aimant@ee.usyd.edu.au)
+ @creation-date 2005-01-10
+ @cvs-id $Id: create-edit-session5.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ To store/update information related to selected tasks
+ @parameter
+} {
+
+ number:optional
+{ edit_flage: 11 }
+{ technique_num: 55 }
+{ technique_name "" }
+{ newtechnique_flage: 55 }
+{ session_id: 55 }
+{ sln: 0 }
+{ roles: " " }
+
+
+} -properties {
+ session:multirow
+
+}
+
+set number $session_id
+
+set ig ""
+set el ""
+
+# to get the stored tasks
+db_multirow session get_session_info {}
+ template::multirow foreach session {
+ }
+
+
+# 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" } {
+ # 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"
+ad_script_abort
+}
+
+
+ad_form -name activity_entery_form1 -form {
+ number:key(acs_object_id_seq)
+
+
+ {edit_flage:text(hidden)
+ {value $edit_flage}
+ }
+ {technique_name:text(hidden)
+ {value $technique_name}
+ }
+ {session_id:text(hidden)
+ {value $session_id}
+ }
+ {technique_num:text(hidden)
+ {value $technique_num}
+ }
+
+
+ {roles:text(hidden)
+ {value $roles}
+ }
+
+ {sln:text(hidden)
+ {value $sln}
+ }
+
+
+ {newtechnique_flage:text(hidden)
+ {value $newtechnique_flage}
+
+ }
+
+ }
+
+if { $t12 == "checked" } {
+ ad_form -extend -name activity_entery_form1 -form {
+ {st:text(textarea)
+ {html { cols 60 rows 6}}
+ {label "#beehive.Session_Info#"}
+
+ }
+ }
+}
+if { $t35 == "checked" } {
+ if { $controlld2 == "checked" } {
+ ad_form -extend -name activity_entery_form1 -action "create-edit-session2.tcl" -form {
+ {idn:text(text)
+ {html {size 5}}
+ {label "#beehive.Ideas_number#"}
+
+ }
+ {idt: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)
+ {html { cols 60 rows 8}}
+ {label "#beehive.Subject_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#"}
+ }
+ {it:text(textarea)
+ {html { cols 60 rows 6}}
+ {label "#beehive.Description_text#"}
+
+ }
+ }
+}
+
+
+if { $t36 == "checked" } {
+
+ ad_form -extend -name activity_entery_form1 -form {
+
+ {ynt:text(textarea)
+ {html { cols 60 rows 6}}
+ {label "#beehive.yesNo_question#"}
+
+ }
+ }
+
+
+}
+
+
+
+if { $relatedflag == "false" } {
+
+ ad_form -extend -name activity_entery_form1 -form {
+
+ {com:text(inform)
+ {label "#beehive.No_Info_needed#"}
+ }
+ }
+
+
+}
+
+
+ad_form -extend -name activity_entery_form1 -form {
+ {com0:text(inform)
+ {label " "}
+ }
+
+
+
+
+
+
+} -select_query {
+
+ SELECT * from beehive_ses WHERE number = :session_id
+
+} -edit_data {
+ db_dml do_update {}
+
+} -after_submit {
+
+ 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"
+ ad_script_abort
+}
+
+
+
+
+
+ad_return_template
+
Index: openacs-4/packages/beehive/www/create-edit-session6-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session6-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session6-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,36 @@
+
+
+ postgresql7.3
+
+
+
+
+
+ SELECT * from beehive_sesscript WHERE number = :session_id
+
+
+
+
+
+SELECT * from beehive_patscript WHERE techniqe = :technique_name AND tname = :technique_version
+
+
+
+
+
+
+
+ SELECT * from beehive_emptypatscript
+
+
+
+
+
+
+
+
+ SELECT * from beehive_ses WHERE number = :session_id
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session6.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,317 @@
+
+
+
+
+
+
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session6.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,149 @@
+
+ad_page_contract {
+
+ The logic for the aiman.
+
+ @author aiman turani
+ @creation-date 2005-04-10
+ @cvs-id $Id: create-edit-session6.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+ This page is to fill up the collaboration script
+
+} {
+
+{ session_id: 1 }
+{ edit_flage: 11 }
+{ technique_num: 11 }
+{ technique_name: " " }
+{ roles: " " }
+{ ig: " " }
+{ el: " " }
+{ igg: " " }
+{ ell: " " }
+
+{ sln: 0 }
+{ newtechnique_flage: 55 }
+
+
+} -properties {
+ session:multirow
+ info:multirow
+ rolesl:onelist
+ tools:onelist
+}
+
+
+set tools " "
+#get the session version name
+db_multirow sessions get_session_info {}
+
+template::multirow foreach sessions {
+ }
+set technique_version $name
+
+if {$edit_flage == 0 } {
+ # it is a stored techniques so retrieve data for updating
+ db_multirow session get_info_from_session_script {}
+
+
+} else {
+
+ if { $newtechnique_flage != 0} {
+
+
+ # it is a new technique so get the stored pattern script for that technique to be as a default script
+ db_multirow session get_info_from_pattern_script {}
+
+
+ } else {
+ # itis a new created pattern so start by filling an empty script
+ db_multirow session get_empty {}
+
+ }
+
+}
+template::multirow foreach session {
+ }
+
+
+# fill the tool box with tools according to the tasks selected
+db_multirow info get_session_info {}
+
+template::multirow foreach info {
+
+ if {$t18 == "checked" } {
+ set tools [linsert $tools end "Slides"]
+ }
+ if {$t22 == "checked" } {
+ set tools [linsert $tools end "SmallGroupDisscussion"]
+ }
+ if {$t23 == "checked" } {
+ set tools [linsert $tools end "LargeGroupDisscussion"]
+ }
+ 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 {$t27 == "checked" } {
+ set tools [linsert $tools end "IceBreaking"]
+ }
+ 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 {$t15 == "checked" } {
+ set tools [linsert $tools end "Overview"]
+ }
+ if {$t33 == "checked" } {
+ set tools [linsert $tools end "DynamicLink"]
+ }
+ if {$t37 == "checked" } {
+ set tools [linsert $tools end "SharedText"]
+ }
+ if {$t38 == "checked" } {
+ set tools [linsert $tools end "IdeasDiscussion"]
+ }
+ if {$t20 == "checked" } {
+ set tools [linsert $tools end "Whiteboard"]
+ }
+
+
+}
+
+
+
+# to fill the roles
+set rolesl [split $roles "/"]
+set rolesl [linsert $rolesl end "teacher"]
+
+
+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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session7-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,46 @@
+
+
+ postgresql7.3
+
+
+
+
+ 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_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)
+
+
+
+
+
+ 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
+
+
+
+
+
+ SELECT * from beehive_ses WHERE number = :number1
+
+
+
+
+
+
+ UPDATE beehive_ses SET timemanagement = :timemanagement , writtencommunicatoin = :writtencommunicatoin, criticalthinking = :criticalthinking , creativethinking = :creativethinking, analyticalskills = :analyticalskills , decisionmaking = :decisionmaking, leadership = :leadership , oralcommunication = :oralcommunication, searchingskills = :searchingskills , knowledgesharing = :knowledgesharing , reflecting = :reflecting WHERE number = :session_id0
+
+
+
+
+
+
+ UPDATE beehive_pattern SET timemanagement = :timemanagement , writtencommunicatoin = :writtencommunicatoin, criticalthinking = :criticalthinking , creativethinking = :creativethinking, analyticalskills = :analyticalskills , decisionmaking = :decisionmaking, leadership = :leadership , oralcommunication = :oralcommunication, searchingskills = :searchingskills , knowledgesharing = :knowledgesharing , reflecting = :reflecting WHERE num = :technique_num
+
+
+
+
+
Index: openacs-4/packages/beehive/www/create-edit-session7.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/create-edit-session7.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/create-edit-session7.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,17 @@
+
+
+
Beehives are the structures where bees live, and thrive in collaboration. Beehives have recognizable patterns, that bees have developed over generations of 'good practice'.
+
+The educational research literature now shows the value of collaborative learning. Something bees have known for centuries!
+
+WEG's Beehive is an application that supports teachers and instructional designers create multimedia collaborative learning activities using best educational practices. It uses a the concept of educational design patterns
+
+
Beehive's framework enables teachers to develop effective, flexible, customizable and reusable pedagogical tools. It also enables teachers to define the collaboration script, which describes how members would collaborate within each activity session.
+
+
+Beehive aims to be standards compliant. It uses the IMS Learner Design specification along with its own extensions. Beehive is developed by integrating .LRN learning management system and Macromedia�s Flash communication server
+
+
Beehive in Higher Education & Corporations
+
+
+Beehive's pedagogical models are used at all educcational levels. Behive will support the following pedagogical models:
+
+
+
1-some-to-some : Brainstorming, Group discussion, Round Table discussion, Jigsaw, Pro/Contra, Group Nomination, Buzz group discussion, Think Pair Shair, and Case studies
+
2-some-to-many: Debate, Role playing, Panels
+
+
+
+
+
Resources
+
+
A. Turani, R.A. Calvo, and P. Goodyear. "An Application Framework for Collaborative Learning". in ICWE 2005, D. Lowe and M. Gaedke (Eds.), LNCS 3579, pp. 243-251, 2005. Springer-Verlag Berlin, 2005
+ [Download Paper]
+For using Beehive properly, you need first to install the flash Comm server(it is called now flash media server):
+1- You may download a trial version form: http://www.adobe.com/cfusion/tdrc/index.cfm?product=flashmediaserver
+2- You also need to create a beehive application on the Flash Comm Server and copy inside it the main.asc file found in the flash folder within the beehive package
+3- make sure that you enable writing permissions for the beehive application on the Flash Comm Server
+
+
+* Contact Dr. Rafael Calvo for more information (rafa@ee.usyd.edu.au).
Index: openacs-4/packages/beehive/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/index.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/index.tcl 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,13 @@
+# index page for beehive
+
+ad_page_contract {
+
+ @author aiman
+ @creation-date 2005-01-01
+ @cvs-id $Id: index.tcl,v 1.1 2006/05/10 05:38:46 ncarroll Exp $
+
+ more information about beehive
+}
+
+
+ad_return_template
Index: openacs-4/packages/beehive/www/more-pattern-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/more-pattern-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/more-pattern-postgresql.xql 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,15 @@
+
+
+ postgresql7.3
+
+
+
+
+ SELECT * from beehive_pattern where num = :technique_num
+
+
+
+
+
+
+
Index: openacs-4/packages/beehive/www/more-pattern.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/beehive/www/more-pattern.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/beehive/www/more-pattern.adp 10 May 2006 05:38:46 -0000 1.1
@@ -0,0 +1,125 @@
+
+
+Techniqe's Pattern
+
+
+
