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 -N -r1.5 -r1.6 --- openacs-4/packages/beehive/sql/postgresql/beehive-create.sql 28 Dec 2006 05:38:44 -0000 1.5 +++ openacs-4/packages/beehive/sql/postgresql/beehive-create.sql 20 Mar 2007 22:54:42 -0000 1.6 @@ -124,36 +124,36 @@ insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Group Discussion', 'default',1,'read related info ','all','000500','textInfo-EntireSession',2,'start discussion','all','001000','Disscussion-SmallGroup'); -insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Group Discussion','default','participant', '5','5','5','checked' ,'checked','How to establish and encourage group knowledge sharing among students ', 'Discussing how to improve writing and speaking skills for a foreigner student ', 'Small groups with different skills and backgrounds interact to develop more knowledge among them ','Size: usually 5Structure: participants(5) ', '1- Teacher specify the discussion topic and related info.2- All student will start discussion according to their experience and may build upon others knowledge','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'Knowledge sharing','checked','checked','checked'); +insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin) values ('Group Discussion','default','participant', '5','5','5','checked' ,'checked','How to establish and encourage group knowledge-sharing among students ', 'Discussing how to improve writing and speaking skills for a foreigner student ', 'Small groups with different skills and backgrounds interact to develop more knowledge among them ','Size: usually 5Structure: participants(5) ', '1- Teacher specify the discussion topic and related info.2- All student will start discussion according to their experience and may build upon others knowledge','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'Knowledge-sharing','checked','checked','checked'); insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5 ) values ('Round Table discussion', 'default',1,' ','participant1','000200','Disscussion-SmallGroup',2,' ','participant2','000200','Disscussion-SmallGroup',3,' ','participant3','000200','Disscussion-SmallGroup',4,' ','participant5','000200','Disscussion-SmallGroup',5,' ','participant5','000200','Disscussion-SmallGroup'); -insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin ) values ('Round Table discussion','default','participant1/participant2/participant3/participant4/participant5', '5','5','5','checked','How to motivate balance participations across all members ','Discussing the advantages of E-Learning ','Generating new abstract understanding by enabling balance knowledge-sharing ','Size: usually 5Structure: participant1, participant2, participant3, participant4, participant5', '1- The first student on the list will be enabled to post a response 2- the next student will be enabled and so on','checked','checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Knowledge sharing with a balanced participation','checked','checked','checked'); +insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin ) values ('Round Table discussion','default','participant1/participant2/participant3/participant4/participant5', '5','5','5','checked','How to motivate balance participations across all members ','Discussing the advantages of E-Learning ','Generating new abstract understanding by enabling balance knowledge-sharing ','Size: usually 5Structure: participant1, participant2, participant3, participant4, participant5', '1- The first student on the list will be enabled to post a response 2- the next student will be enabled and so on','checked','checked',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Knowledge-sharing with a balanced participation','checked','checked','checked'); insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4) values ('Group Nomination technique', 'default',1,'start brainstorming','all','001000','IdeasPosting-SmallGroup',2,'start discussion the ideas','all','000600','IdeasDiscussion-SmallGroup',3,'vote on ideas','all','000100','IdeasVoting-SmallGroup',4,'submit the result based on ideas rating','chairperson','000200','OwnResolution-EntireSession'); insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t26,t38,t35,t29,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, creativethinking, analyticalskills, decisionmaking, leadership, timemanagement , oralcommunication , writtencommunicatoin -) values ('Group Nomination technique','default','chairperson/participant', '5','5','5','checked','checked','checked','checked','A certain topic or problem without a specific solution whose resolution implies not only creating ideas or solution, but also choosing the best idea ','Generating and selecting a website project title for an E business course ','Suitable for organizational decision making where different people with different skills and knowledge participating in creating, discussing, and then selecting. ','Size: usually 5Structure: chairperson, participants(4) +) values ('Group Nomination technique','default','chairperson/participant', '5','5','5','checked','checked','checked','checked','A certain topic or problem without a specific solution whose resolution implies not only creating ideas or solution, but also choosing the best idea ','Generating and selecting a website project title for an E business course ','Suitable for organizational decision-making where different people with different skills and knowledge participating in creating, discussing, and then selecting. ','Size: usually 5Structure: chairperson, participants(4) time: 20 min ', '1- posting ideas; no criticism or elaboration is allowed in this stage.2- The next stage is discussing each recorded idea to obtain clarification and evaluation3- participant is asked to assign a mark for each idea 4- reporting the result based on ideas rating to other groups (by chairperson)','',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ','Creating and choosing the best ideas/solutions ','checked','checked','checked','checked','checked','checked','checked','checked'); insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2) values ('Brainstorm', 'default',1,'read related info ','all','000500','textInfo-EntireSession',2,'start brainstorming','all','001000','IdeasPosting-SmallGroup'); insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t26,t12,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4, uses,creativethinking, timemanagement, writtencommunicatoin ) values ('Brainstorm','default','participant', '5','5','5','checked','checked','A certain topic or problem without a specific solution whose resolution implies generating many ideas form all members in short time ','Generating different solutions for the reduction of electrical bills ','Motivate group to generate many creative new ideas and solutions by not allowing criticism or elaboration ','Size: usually 5Structure: participants(5) -time: 20 min ', '1- Teacher gives students a background info 2- participants starts posting their ideas; no criticism or elaboration is allowed in this stage.',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Ideas creation in a short period','checked','checked','checked'); +time: 20 min ', '1- Teacher gives students a background info 2- participants starts posting their ideas; no criticism or elaboration is allowed in this stage.',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ', 'Idea creation in a short period','checked','checked','checked'); insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8 ) values ('Debate', 'default',1,'Propose the motion','proposer','000500','Disscussion-SmallGroup',2,'Second the Proposer','seconder(p)','000300','Disscussion-SmallGroup',3,'Oppose the motion','opposer','000500','Disscussion-SmallGroup',4,'Second the Opposer','seconder(o)','000300','Disscussion-SmallGroup',5,'Speak From The Floor','speakers','001000','Disscussion-SmallGroup',6,'Sum up for the motion','proposer','000300','Disscussion-SmallGroup',7,'Sum up for the opposition','opposer','000300','Disscussion-SmallGroup',8,'Do you support the proposor','all','000100','YesNo-EntireSession'); insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t22,t36,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, decisionmaking) values ('Debate','default','proposer/seconder(p)/opposer/seconder(o)/speakers','10','10','10','checked','checked','How to clarify a controversial topic by presenting the best argument for or against the proposal ','Discussing the issue of illegal workers in the USA and their impact on the USA economy in a business class ','Interaction strategy used to help student developing critical thinking and listening skills to make important decisions ','Size: usually 10 Structure: proposer, second proposer, opposer, second opposer, speakers(6) -time: 36min ', '1- Proposer will propose the motion2- The second proposer will second the proposer 3- The opposer will oppose the motion4- The second opposer will second the opposer5- Speakers will participate from The floor6- The proposer will sum up for the motion7- The opposer will sum up for the opposition8- Voting on a particular side',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' A controversial topic clarification or decision making','checked','checked','checked','checked' ); +time: 36min ', '1- Proposer will propose the motion2- The second proposer will second the proposer 3- The opposer will oppose the motion4- The second opposer will second the opposer5- Speakers will participate from The floor6- The proposer will sum up for the motion7- The opposer will sum up for the opposition8- Voting on a particular side',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' A controversial topic clarification or decision-making','checked','checked','checked','checked' ); insert into beehive_patscript (techniqe,tname ,n1,ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3,n4,ins4,tr4,tl4,tool4,n5,ins5,tr5,tl5,tool5,n6,ins6,tr6,tl6,tool6,n7,ins7,tr7,tl7,tool7,n8,ins8,tr8,tl8,tool8 ) values ('Problem Based Learning PBL', 'default',1,'Read the problem description ','all','000500','textInfo-EntireSession',2,'Identify concept and parts of the problem that needs clarification','all','000300','IndividualTextWriting-None',3,'Define the problem','all','000500','IndividualTextWriting-None',4,'Brainstorm about solutions','all','000300','IdeasPosting-SmallGroup',5,'Structure solutions or causes','all','001000','IndividualTextWriting-None',6,'state learning objectives','all','000300','IndividualTextWriting-None',7,'Self study directed towards learning objectives ','all','001300','InternetSearch-None',8,'report things learned and application to problem','all','001000','SharedText-SmallGroup'); @@ -175,7 +175,7 @@ insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Think Pair Share', 'default',1,'think silently about this question ','all','001000','textInfo-EntireSession',2,'exchanging ideas with your partner','all','001000','Disscussion-SmallGroup',3,'exchange ideas with the whole session','all','001500','Disscussion-EntireSession'); -insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,t23,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Think Pair Share', 'default','participant', '2','2','2','checked','checked','checked','Size: usually 2', '1- Each participant think silently about question posed.2- Individual pair up during the second step and exchange thoughts3- The pair share their responses with the entire group','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection, peer discussion and groups solutions sharing','checked','checked','checked','checked'); +insert into beehive_pattern ( techniqe,name,roles,mx,mn,df,t12,t22,t23,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses,criticalthinking, timemanagement, writtencommunicatoin, analyticalskills) values ('Think Pair Share', 'default','participant', '2','2','2','checked','checked','checked','Size: usually 2', '1- Each participant think silently about question posed.2- Individual pair up during the second step and exchange thoughts3- The pair share their responses with the entire group','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Content that requires individual reflection, peer discussion and groups solution-sharing','checked','checked','checked','checked'); @@ -199,7 +199,7 @@ -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_pattern ( techniqe,name,roles,mx,mn,df,t2,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t17,t18,t19,t20,t22,t23,t24,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,ctype1,ctype2,ctype3,controlld1,controlld2,problem,example,context,gstructure,solution,adda1,addv1,adda2,addv2,adda3,addv3,btype1,btype2,anon1,anon2,anon3,anon4,uses, timemanagement, writtencommunicatoin, analyticalskills) values ('Case Studes', 'default','participant', '5','5','5',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', 'checked',' ',' ',' ', ' ', ' ',' ',' ',' ',' ',' ',' ',' ',' ','checked',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ','A story or situation is written for learners to read and consider. It may be presented on paper, read or seen on video ',' ', '1- Each participant read or watch the related material .2- Each participant should submit his own resolution of a proposed question',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','Helping participants to develop skills in identifying concerns, analysing problems, and considering solutions','checked','checked','checked'); insert into beehive_patscript (techniqe,tname,n1, ins1,tr1,tl1,tool1,n2,ins2,tr2,tl2,tool2,n3,ins3,tr3,tl3,tool3) values ('Team Pair Solo', 'default',1,'entire session discuss the issue','all','001000','Disscussion-EntireSession',2,'exchanging ideas with your partner','all','001000','Disscussion-SmallGroup',3,'submit your own resolution','all','000300','OwnResolution-EntireSession');