What were the best things about the 2007 conference?
\n
Which presentations did you get the most out of?
',1,0,1,NULL,3,0,0,NULL,5);
/*!40000 ALTER TABLE `tl_lafrum11_message` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lafrum11_message_seq`
--
DROP TABLE IF EXISTS `tl_lafrum11_message_seq`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lafrum11_message_seq` (
`uid` bigint(20) NOT NULL auto_increment,
`root_message_uid` bigint(20) default NULL,
`message_uid` bigint(20) default NULL,
`message_level` smallint(6) default NULL,
PRIMARY KEY (`uid`),
KEY `FKD2C71F88FE939F2A` (`message_uid`),
KEY `FKD2C71F8845213B4D` (`root_message_uid`),
CONSTRAINT `FKD2C71F8845213B4D` FOREIGN KEY (`root_message_uid`) REFERENCES `tl_lafrum11_message` (`uid`),
CONSTRAINT `FKD2C71F88FE939F2A` FOREIGN KEY (`message_uid`) REFERENCES `tl_lafrum11_message` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lafrum11_message_seq`
--
LOCK TABLES `tl_lafrum11_message_seq` WRITE;
/*!40000 ALTER TABLE `tl_lafrum11_message_seq` DISABLE KEYS */;
INSERT INTO `tl_lafrum11_message_seq` VALUES (1,2,2,0),(2,3,3,0),(3,4,4,0),(4,5,5,0),(5,6,6,0),(6,7,7,0);
/*!40000 ALTER TABLE `tl_lafrum11_message_seq` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lafrum11_report`
--
DROP TABLE IF EXISTS `tl_lafrum11_report`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lafrum11_report` (
`uid` bigint(20) NOT NULL auto_increment,
`comment` text,
`release_date` datetime default NULL,
`mark` float default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lafrum11_report`
--
LOCK TABLES `tl_lafrum11_report` WRITE;
/*!40000 ALTER TABLE `tl_lafrum11_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lafrum11_report` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lafrum11_timestamp`
--
DROP TABLE IF EXISTS `tl_lafrum11_timestamp`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lafrum11_timestamp` (
`uid` bigint(20) NOT NULL auto_increment,
`message_uid` bigint(20) NOT NULL,
`timestamp_date` datetime NOT NULL,
`forum_user_uid` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `uid` (`uid`),
KEY `message_uid` (`message_uid`),
KEY `forum_user_uid` (`forum_user_uid`),
KEY `ForumUserFK` (`forum_user_uid`),
KEY `MessageFK` (`message_uid`),
CONSTRAINT `MessageFK` FOREIGN KEY (`message_uid`) REFERENCES `tl_lafrum11_message` (`uid`),
CONSTRAINT `ForumUserFK` FOREIGN KEY (`forum_user_uid`) REFERENCES `tl_lafrum11_forum_user` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lafrum11_timestamp`
--
LOCK TABLES `tl_lafrum11_timestamp` WRITE;
/*!40000 ALTER TABLE `tl_lafrum11_timestamp` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lafrum11_timestamp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lafrum11_tool_session`
--
DROP TABLE IF EXISTS `tl_lafrum11_tool_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lafrum11_tool_session` (
`uid` bigint(20) NOT NULL auto_increment,
`version` int(11) NOT NULL,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`mark_released` smallint(6) default NULL,
`forum_uid` bigint(20) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
PRIMARY KEY (`uid`),
KEY `FK5A04D7AE131CE31E` (`forum_uid`),
CONSTRAINT `FK5A04D7AE131CE31E` FOREIGN KEY (`forum_uid`) REFERENCES `tl_lafrum11_forum` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lafrum11_tool_session`
--
LOCK TABLES `tl_lafrum11_tool_session` WRITE;
/*!40000 ALTER TABLE `tl_lafrum11_tool_session` DISABLE KEYS */;
INSERT INTO `tl_lafrum11_tool_session` VALUES (1,0,NULL,NULL,1,0,3,23,'Everybody learners');
/*!40000 ALTER TABLE `tl_lafrum11_tool_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lagmap10_attachment`
--
DROP TABLE IF EXISTS `tl_lagmap10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lagmap10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`gmap_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKBA2ECCB274028C80` (`gmap_uid`),
CONSTRAINT `FKBA2ECCB274028C80` FOREIGN KEY (`gmap_uid`) REFERENCES `tl_lagmap10_gmap` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lagmap10_attachment`
--
LOCK TABLES `tl_lagmap10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lagmap10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lagmap10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lagmap10_configuration`
--
DROP TABLE IF EXISTS `tl_lagmap10_configuration`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lagmap10_configuration` (
`uid` bigint(20) NOT NULL auto_increment,
`config_key` varchar(30) default NULL,
`config_value` varchar(255) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `config_key` (`config_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lagmap10_configuration`
--
LOCK TABLES `tl_lagmap10_configuration` WRITE;
/*!40000 ALTER TABLE `tl_lagmap10_configuration` DISABLE KEYS */;
INSERT INTO `tl_lagmap10_configuration` VALUES (1,'GmapKey','ABQIAAAAvPAE96y1iioFQOnrP1RCBxQ3ZLSPwrKlL-Fn7FdXNTuNedFYMRT30phEMjEwUhQPccHtJ9JNU1mknQ');
/*!40000 ALTER TABLE `tl_lagmap10_configuration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lagmap10_gmap`
--
DROP TABLE IF EXISTS `tl_lagmap10_gmap`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lagmap10_gmap` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`allow_edit_markers` bit(1) default NULL,
`show_all_markers` bit(1) default NULL,
`limit_markers` bit(1) default NULL,
`max_markers` int(11) default NULL,
`allow_zoom` bit(1) default NULL,
`allow_terrain` bit(1) default NULL,
`allow_satellite` bit(1) default NULL,
`allow_hybrid` bit(1) default NULL,
`map_center_latitude` double default NULL,
`map_center_longitude` double default NULL,
`map_zoom` int(11) default NULL,
`map_type` varchar(20) default NULL,
`reflect_on_activity` bit(1) default NULL,
`reflect_instructions` text,
`default_geocoder_address` varchar(255) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lagmap10_gmap`
--
LOCK TABLES `tl_lagmap10_gmap` WRITE;
/*!40000 ALTER TABLE `tl_lagmap10_gmap` DISABLE KEYS */;
INSERT INTO `tl_lagmap10_gmap` VALUES (1,NULL,NULL,NULL,'Gmap','Instructions',0x00,0x00,'','',0x00,0x00,12,0x01,0x01,0x00,1,0x01,0x00,0x01,0x01,-33.774322,151.111988,13,'G_NORMAL_MAP',0x00,'','Macquarie University, Sydney NSW'),(2,'2008-11-14 14:32:00','2008-11-10 12:52:48',1,'Google Maps Demonstration','
\n
Google Maps
\n
New to LAMS 2.2!
\n
The Google Maps Activity allows sequence Authors to create maps or satellite images with annotated place markers. \nDuring the running of the activity, Learners can add their own markers to the map and view markers placed by other learners.
',0x00,0x00,'','',0x00,0x00,51,0x01,0x01,0x00,0,0x01,0x00,0x01,0x01,-33.7746794632346,151.11565053463,17,'G_SATELLITE_MAP',0x00,'','Macquarie University, Sydney NSW'),(3,'2009-05-21 17:39:12','2008-11-10 12:52:48',1,'Google Maps Demonstration','
\n
Google Maps
\n
New to LAMS 2.2!
\n
The Google Maps Activity allows sequence Authors to create maps or satellite images with annotated place markers. \nDuring the running of the activity, Learners can add their own markers to the map and view markers placed by other learners.
The new Image Gallery activity allows authors, monitors and learners to view and upload images to the LAMS server, then review or rate them with their peers. \n
\n
Have a go at uploading an Image in this activity (select Add New Image on the bottom-right). \nYou can also view, rate and comment on the images already uploaded.
\n
All of these images are sourced from flickr under CC-by-nc-sa. \n
\n\n
\nWhen you are finished, click \'Next Activity.\' \n
The new Image Gallery activity allows authors, monitors and learners to view and upload images to the LAMS server, then review or rate them with their peers. \n
\n
Have a go at uploading an Image in this activity (select Add New Image on the bottom-right). \nYou can also view, rate and comment on the images already uploaded.
\n
All of these images are sourced from flickr under CC-by-nc-sa. \n
\n\n
\nWhen you are finished, click \'Next Activity.\' \n
','\"Tangled Technology\"',2,'2009-05-14 20:25:57',1,3,0,3,NULL,1,500,266,2,500,266,3,1,'image/jpeg','tangled.jpg');
/*!40000 ALTER TABLE `tl_laimag10_imageGallery_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_image_comment`
--
DROP TABLE IF EXISTS `tl_laimag10_image_comment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_image_comment` (
`uid` bigint(20) NOT NULL auto_increment,
`comment` text,
`imageGallery_item_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
`create_date` datetime default NULL,
PRIMARY KEY (`uid`),
KEY `FK_tl_laimag10_image_comment_3` (`imageGallery_item_uid`),
KEY `FK_tl_laimag10_image_comment_2` (`create_by`),
CONSTRAINT `FK_tl_laimag10_image_comment_2` FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`),
CONSTRAINT `FK_tl_laimag10_image_comment_3` FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imageGallery_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_image_comment`
--
LOCK TABLES `tl_laimag10_image_comment` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_image_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laimag10_image_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_image_rating`
--
DROP TABLE IF EXISTS `tl_laimag10_image_rating`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_image_rating` (
`uid` bigint(20) NOT NULL auto_increment,
`rating` int(11) default NULL,
`imageGallery_item_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_tl_laimag10_image_rating_3` (`imageGallery_item_uid`),
KEY `FK_tl_laimag10_image_rating_2` (`create_by`),
CONSTRAINT `FK_tl_laimag10_image_rating_2` FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`),
CONSTRAINT `FK_tl_laimag10_image_rating_3` FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imageGallery_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_image_rating`
--
LOCK TABLES `tl_laimag10_image_rating` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_image_rating` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laimag10_image_rating` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_image_vote`
--
DROP TABLE IF EXISTS `tl_laimag10_image_vote`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_image_vote` (
`uid` bigint(20) NOT NULL auto_increment,
`is_voted` tinyint(4) default NULL,
`imageGallery_item_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_tl_laimag10_image_vote_3` (`imageGallery_item_uid`),
KEY `FK_tl_laimag10_image_vote_2` (`create_by`),
CONSTRAINT `FK_tl_laimag10_image_vote_2` FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`),
CONSTRAINT `FK_tl_laimag10_image_vote_3` FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imageGallery_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_image_vote`
--
LOCK TABLES `tl_laimag10_image_vote` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_image_vote` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laimag10_image_vote` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_item_log`
--
DROP TABLE IF EXISTS `tl_laimag10_item_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_item_log` (
`uid` bigint(20) NOT NULL auto_increment,
`access_date` datetime default NULL,
`imageGallery_item_uid` bigint(20) default NULL,
`user_uid` bigint(20) default NULL,
`complete` tinyint(4) default NULL,
`session_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_1821149711_693580A438BF8DFE` (`imageGallery_item_uid`),
KEY `FK_NEW_1821149711_693580A441F9365D` (`user_uid`),
CONSTRAINT `FK_NEW_1821149711_693580A441F9365D` FOREIGN KEY (`user_uid`) REFERENCES `tl_laimag10_user` (`uid`),
CONSTRAINT `FK_NEW_1821149711_693580A438BF8DFE` FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imageGallery_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_item_log`
--
LOCK TABLES `tl_laimag10_item_log` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_item_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laimag10_item_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_session`
--
DROP TABLE IF EXISTS `tl_laimag10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`imageGallery_uid` bigint(20) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_1821149711_24AA78C530E79035` (`imageGallery_uid`),
CONSTRAINT `FK_NEW_1821149711_24AA78C530E79035` FOREIGN KEY (`imageGallery_uid`) REFERENCES `tl_laimag10_imageGallery` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_session`
--
LOCK TABLES `tl_laimag10_session` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_session` DISABLE KEYS */;
INSERT INTO `tl_laimag10_session` VALUES (1,NULL,NULL,0,3,3,'Everybody learners');
/*!40000 ALTER TABLE `tl_laimag10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laimag10_user`
--
DROP TABLE IF EXISTS `tl_laimag10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laimag10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`session_finished` smallint(6) default NULL,
`session_uid` bigint(20) default NULL,
`imageGallery_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_1821149711_30113BFCEC0D3147` (`session_uid`),
KEY `FK_NEW_1821149711_30113BFC309ED320` (`imageGallery_uid`),
CONSTRAINT `FK_NEW_1821149711_30113BFC309ED320` FOREIGN KEY (`imageGallery_uid`) REFERENCES `tl_laimag10_imageGallery` (`uid`),
CONSTRAINT `FK_NEW_1821149711_30113BFCEC0D3147` FOREIGN KEY (`session_uid`) REFERENCES `tl_laimag10_session` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laimag10_user`
--
LOCK TABLES `tl_laimag10_user` WRITE;
/*!40000 ALTER TABLE `tl_laimag10_user` DISABLE KEYS */;
INSERT INTO `tl_laimag10_user` VALUES (1,5,'Test','One','test1',0,NULL,2),(2,5,'Test','One','test1',0,NULL,3);
/*!40000 ALTER TABLE `tl_laimag10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_content`
--
DROP TABLE IF EXISTS `tl_lamc11_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_content` (
`uid` bigint(20) NOT NULL auto_increment,
`content_id` bigint(20) NOT NULL,
`title` text,
`instructions` text,
`creation_date` datetime default NULL,
`update_date` datetime default NULL,
`reflect` tinyint(1) NOT NULL default '0',
`questions_sequenced` tinyint(1) NOT NULL default '0',
`created_by` bigint(20) NOT NULL default '0',
`run_offline` tinyint(1) NOT NULL default '0',
`define_later` tinyint(1) NOT NULL default '0',
`offline_instructions` text,
`online_instructions` text,
`content_in_use` tinyint(1) NOT NULL default '0',
`retries` tinyint(1) NOT NULL default '0',
`pass_mark` int(11) default NULL,
`show_report` tinyint(1) NOT NULL default '0',
`reflectionSubject` text,
`showMarks` tinyint(1) NOT NULL default '0',
`randomize` tinyint(1) NOT NULL default '0',
`displayAnswers` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`uid`),
UNIQUE KEY `UQ_tl_lamc11_content_1` (`content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_content`
--
LOCK TABLES `tl_lamc11_content` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_content` DISABLE KEYS */;
INSERT INTO `tl_lamc11_content` VALUES (1,22,'MCQ','Instructions','2009-05-21 17:34:53',NULL,0,0,1,0,0,'','',0,0,0,0,NULL,0,0,1),(2,42,'My Lost Beach Ball','
This is a demonstration Multiple Choice Quiz.
\n
As you can see, LAMS provides a space for Instructions and Comments (here) \nand lists all the questions and choices for the activity below.
\n
\n\n
\n
Read the short story below and answer the three questions:
\n
\n
\n
One day my Dad bought me a new red beach ball. \n
\n
My brother and I took it down to the beach to play with. \n
\n
We were playing Soccer when he kicked the ball into the water, accidentally. \n
\n
The ball floated out to sea before we could rescue it.
\n
\n\n
\n
HINT: The correct answers are marked with an asterisk!
',NULL,'2008-04-11 15:37:41',0,0,5,0,0,'','',0,1,3,0,'',1,1,1),(3,91,'My Lost Beach Ball','
This is a demonstration Multiple Choice Quiz.
\n
As you can see, LAMS provides a space for Instructions and Comments (here) \nand lists all the questions and choices for the activity below.
\n
\n\n
\n
Read the short story below and answer the three questions:
\n
\n
\n
One day my Dad bought me a new red beach ball. \n
\n
My brother and I took it down to the beach to play with. \n
\n
We were playing Soccer when he kicked the ball into the water, accidentally. \n
\n
The ball floated out to sea before we could rescue it.
\n
\n\n
\n
HINT: The correct answers are marked with an asterisk!
',NULL,'2008-04-11 15:37:41',0,0,5,0,0,'','',0,1,3,0,'',1,1,1);
/*!40000 ALTER TABLE `tl_lamc11_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_options_content`
--
DROP TABLE IF EXISTS `tl_lamc11_options_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_options_content` (
`uid` bigint(20) NOT NULL auto_increment,
`correct_option` tinyint(1) NOT NULL default '0',
`mc_que_content_id` bigint(20) NOT NULL,
`mc_que_option_text` varchar(250) default NULL,
`displayOrder` int(5) default NULL,
PRIMARY KEY (`uid`),
KEY `mc_que_content_id` (`mc_que_content_id`),
CONSTRAINT `FK_tl_lamc11_options_content_1` FOREIGN KEY (`mc_que_content_id`) REFERENCES `tl_lamc11_que_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_options_content`
--
LOCK TABLES `tl_lamc11_options_content` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_options_content` DISABLE KEYS */;
INSERT INTO `tl_lamc11_options_content` VALUES (1,0,1,'Answer 1',1),(2,1,1,'Answer 2',2),(3,1,2,'Dad *',3),(4,0,2,'Mum',2),(5,0,2,'Santa Claus',1),(6,0,3,'Yellow',1),(7,1,3,'Red *',2),(8,0,3,'Green',3),(9,0,4,'Rugby',3),(10,1,4,'Soccer *',2),(11,0,4,'Cricket',1),(12,0,5,'Santa Claus',1),(13,0,5,'Mum',2),(14,1,5,'Dad *',3),(15,0,6,'Yellow',1),(16,1,6,'Red *',2),(17,0,6,'Green',3),(18,0,7,'Cricket',1),(19,1,7,'Soccer *',2),(20,0,7,'Rugby',3);
/*!40000 ALTER TABLE `tl_lamc11_options_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_que_content`
--
DROP TABLE IF EXISTS `tl_lamc11_que_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_que_content` (
`uid` bigint(20) NOT NULL auto_increment,
`question` text,
`mark` int(5) NOT NULL default '1',
`display_order` int(5) default NULL,
`mc_content_id` bigint(20) NOT NULL,
`feedback` text,
PRIMARY KEY (`uid`),
KEY `mc_content_id` (`mc_content_id`),
CONSTRAINT `FK_tl_lamc11_que_content_1` FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_que_content`
--
LOCK TABLES `tl_lamc11_que_content` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_que_content` DISABLE KEYS */;
INSERT INTO `tl_lamc11_que_content` VALUES (1,'A Sample question?',1,1,1,NULL),(2,'
Who bought the ball?
',1,1,2,''),(3,'
What colour was the ball?
',1,2,2,''),(4,'
What game was being played on the beach?
',1,3,2,''),(5,'
Who bought the ball?
',1,1,3,''),(6,'
What colour was the ball?
',1,2,3,''),(7,'
What game was being played on the beach?
',1,3,3,'');
/*!40000 ALTER TABLE `tl_lamc11_que_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_que_usr`
--
DROP TABLE IF EXISTS `tl_lamc11_que_usr`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_que_usr` (
`uid` bigint(20) NOT NULL auto_increment,
`que_usr_id` bigint(20) NOT NULL,
`mc_session_id` bigint(20) NOT NULL,
`username` varchar(255) default NULL,
`fullname` varchar(255) default NULL,
`responseFinalised` tinyint(1) NOT NULL default '0',
`viewSummaryRequested` tinyint(1) NOT NULL default '0',
`last_attempt_order` int(11) default NULL,
`last_attempt_total_mark` int(11) default NULL,
PRIMARY KEY (`uid`),
KEY `mc_session_id` (`mc_session_id`),
CONSTRAINT `FK_tl_lamc11_que_usr_1` FOREIGN KEY (`mc_session_id`) REFERENCES `tl_lamc11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_que_usr`
--
LOCK TABLES `tl_lamc11_que_usr` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_que_usr` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamc11_que_usr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_session`
--
DROP TABLE IF EXISTS `tl_lamc11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`mc_session_id` bigint(20) NOT NULL,
`session_start_date` datetime default NULL,
`session_end_date` datetime default NULL,
`session_name` varchar(100) default NULL,
`session_status` varchar(100) default NULL,
`mc_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `UQ_tl_lamc11_session_1` (`mc_session_id`),
KEY `mc_content_id` (`mc_content_id`),
CONSTRAINT `FK_tl_lamc_session_1` FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_session`
--
LOCK TABLES `tl_lamc11_session` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_session` DISABLE KEYS */;
INSERT INTO `tl_lamc11_session` VALUES (1,22,'2009-05-21 17:39:13',NULL,'Everybody learners','INCOMPLETE',3);
/*!40000 ALTER TABLE `tl_lamc11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_uploadedfile`
--
DROP TABLE IF EXISTS `tl_lamc11_uploadedfile`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_uploadedfile` (
`submissionId` bigint(20) NOT NULL auto_increment,
`uuid` varchar(255) NOT NULL,
`mc_content_id` bigint(20) NOT NULL,
`isOnline_File` tinyint(1) NOT NULL,
`filename` varchar(255) NOT NULL,
PRIMARY KEY (`submissionId`),
KEY `mc_content_id` (`mc_content_id`),
CONSTRAINT `FK_tl_lamc11_uploadedFile` FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_uploadedfile`
--
LOCK TABLES `tl_lamc11_uploadedfile` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_uploadedfile` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamc11_uploadedfile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamc11_usr_attempt`
--
DROP TABLE IF EXISTS `tl_lamc11_usr_attempt`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamc11_usr_attempt` (
`uid` bigint(20) NOT NULL auto_increment,
`que_usr_id` bigint(20) NOT NULL,
`mc_que_content_id` bigint(20) NOT NULL,
`mc_que_option_id` bigint(20) NOT NULL,
`attempt_time` datetime default NULL,
`isAttemptCorrect` tinyint(1) NOT NULL default '0',
`mark` varchar(255) default NULL,
`passed` tinyint(1) NOT NULL default '0',
`attemptOrder` int(11) NOT NULL default '1',
`finished` tinyint(1) default '0',
PRIMARY KEY (`uid`),
KEY `mc_que_content_id` (`mc_que_content_id`),
KEY `mc_que_option_id` (`mc_que_option_id`),
KEY `que_usr_id` (`que_usr_id`),
CONSTRAINT `FK_tl_lamc11_usr_attempt_2` FOREIGN KEY (`mc_que_content_id`) REFERENCES `tl_lamc11_que_content` (`uid`),
CONSTRAINT `FK_tl_lamc11_usr_attempt_3` FOREIGN KEY (`mc_que_option_id`) REFERENCES `tl_lamc11_options_content` (`uid`),
CONSTRAINT `FK_tl_lamc11_usr_attempt_4` FOREIGN KEY (`que_usr_id`) REFERENCES `tl_lamc11_que_usr` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamc11_usr_attempt`
--
LOCK TABLES `tl_lamc11_usr_attempt` WRITE;
/*!40000 ALTER TABLE `tl_lamc11_usr_attempt` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamc11_usr_attempt` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_attachment`
--
DROP TABLE IF EXISTS `tl_lamind10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`mindmap_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_972920762_12090F57FC940906` (`mindmap_uid`),
CONSTRAINT `FK_NEW_972920762_12090F57FC940906` FOREIGN KEY (`mindmap_uid`) REFERENCES `tl_lamind10_mindmap` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_attachment`
--
LOCK TABLES `tl_lamind10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamind10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_mindmap`
--
DROP TABLE IF EXISTS `tl_lamind10_mindmap`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_mindmap` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`multiuser_mode` bit(1) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`export_content` text,
`reflect_on_activity` bit(1) default NULL,
`reflect_instructions` text,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_mindmap`
--
LOCK TABLES `tl_lamind10_mindmap` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_mindmap` DISABLE KEYS */;
INSERT INTO `tl_lamind10_mindmap` VALUES (1,NULL,NULL,NULL,'Mindmap','Instructions',0x00,0x00,0x00,'','',0x00,0x00,19,NULL,0x00,NULL),(2,'2009-05-21 12:22:42','2009-05-14 20:58:02',NULL,'Mindmap','
The Mindmap Activity
\n
The new Mindmap activity allows Teachers and Learners to create, edit and view mindmaps in the LAMS environment. \nMindmaps allow for the organising of concepts and ideas, and exploring how these interact.
\n
\n
The mindmap feature in LAMS the author to set up the initial framework for concept mapping. \nOn the mindmap, learners can then add or remove thoughts (nodes), move existing nodes and change the colour of nodes.
\n
\n\n
\n
Add some thoughts and ideas to the Mindmap below.
\n
\n
To add new thoughts, click the arrow on the parent node of where you want the new thought to appear.
\n
To move thoughts around, click the hand button, then select a target for the move.
\n
To change colours, click the colour wheel on the thought bubble you want to edit.
The new Mindmap activity allows Teachers and Learners to create, edit and view mindmaps in the LAMS environment. \nMindmaps allow for the organising of concepts and ideas, and exploring how these interact.
\n
\n
The mindmap feature in LAMS the author to set up the initial framework for concept mapping. \nOn the mindmap, learners can then add or remove thoughts (nodes), move existing nodes and change the colour of nodes.
\n
\n\n
\n
Add some thoughts and ideas to the Mindmap below.
\n
\n
To add new thoughts, click the arrow on the parent node of where you want the new thought to appear.
\n
To move thoughts around, click the hand button, then select a target for the move.
\n
To change colours, click the colour wheel on the thought bubble you want to edit.
\n
\n
\n
\n\n
When you are finished, click \'Next Activity.\'
',0x00,0x00,0x00,'','',0x00,0x00,72,'\n \n 1\n Mind Maps!\n 6633bb\n Teacher\n 1\n \n \n \n \n 2\n Exploring Concepts\n eeee09\n Teacher\n 1\n \n \n \n \n \n 3\n Arranging Thoughts\n ee6609\n Teacher\n 1\n \n \n \n \n \n 4\n Developing New Ideas\n 9ee09\n Teacher\n 1\n \n \n \n \n \n 5\n Having Fun!\n 9eeee\n Teacher\n 1\n \n \n \n \n',0x00,'');
/*!40000 ALTER TABLE `tl_lamind10_mindmap` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_node`
--
DROP TABLE IF EXISTS `tl_lamind10_node`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_node` (
`node_id` bigint(20) NOT NULL auto_increment,
`unique_id` bigint(20) default NULL,
`parent_id` bigint(20) default NULL,
`node_text` varchar(100) default NULL,
`node_color` varchar(6) default NULL,
`session_id` bigint(20) default NULL,
`user_id` bigint(20) default NULL,
`mindmap_id` bigint(20) default NULL,
PRIMARY KEY (`node_id`),
KEY `MindmapNode_Parent_FK` (`parent_id`),
KEY `MindmapNode_User_FK` (`user_id`),
KEY `MindmapNode_Mindmap_FK` (`mindmap_id`),
CONSTRAINT `MindmapNode_Mindmap_FK` FOREIGN KEY (`mindmap_id`) REFERENCES `tl_lamind10_mindmap` (`uid`),
CONSTRAINT `MindmapNode_Parent_FK` FOREIGN KEY (`parent_id`) REFERENCES `tl_lamind10_node` (`node_id`),
CONSTRAINT `MindmapNode_User_FK` FOREIGN KEY (`user_id`) REFERENCES `tl_lamind10_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_node`
--
LOCK TABLES `tl_lamind10_node` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_node` DISABLE KEYS */;
INSERT INTO `tl_lamind10_node` VALUES (1,1,NULL,'Mind Maps!','6633bb',NULL,NULL,2),(2,2,1,'Exploring Concepts','eeee09',NULL,NULL,2),(3,3,1,'Arranging Thoughts','ee6609',NULL,NULL,2),(4,4,1,'Developing New Ideas','9ee09',NULL,NULL,2),(5,5,1,'Having Fun!','9eeee',NULL,NULL,2),(6,1,NULL,'Mind Maps!','6633bb',NULL,NULL,3),(7,2,6,'Exploring Concepts','eeee09',NULL,NULL,3),(8,3,6,'Arranging Thoughts','ee6609',NULL,NULL,3),(9,4,6,'Developing New Ideas','9ee09',NULL,NULL,3),(10,5,6,'Having Fun!','9eeee',NULL,NULL,3);
/*!40000 ALTER TABLE `tl_lamind10_node` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_request`
--
DROP TABLE IF EXISTS `tl_lamind10_request`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_request` (
`uid` bigint(20) NOT NULL auto_increment,
`unique_id` bigint(20) default NULL,
`global_id` bigint(20) default NULL,
`request_type` tinyint(4) default NULL,
`node_id` bigint(20) default NULL,
`node_child_id` bigint(20) default NULL,
`user_id` bigint(20) default NULL,
`mindmap_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `mindmap_id` (`mindmap_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `tl_lamind10_request_fk` FOREIGN KEY (`mindmap_id`) REFERENCES `tl_lamind10_mindmap` (`uid`),
CONSTRAINT `tl_lamind10_request_fk1` FOREIGN KEY (`user_id`) REFERENCES `tl_lamind10_user` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_request`
--
LOCK TABLES `tl_lamind10_request` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamind10_request` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_session`
--
DROP TABLE IF EXISTS `tl_lamind10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`mindmap_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_972920762_B7C198E2FC940906` (`mindmap_uid`),
CONSTRAINT `FK_NEW_972920762_B7C198E2FC940906` FOREIGN KEY (`mindmap_uid`) REFERENCES `tl_lamind10_mindmap` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_session`
--
LOCK TABLES `tl_lamind10_session` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_session` DISABLE KEYS */;
INSERT INTO `tl_lamind10_session` VALUES (1,NULL,NULL,NULL,6,'Everybody learners',3);
/*!40000 ALTER TABLE `tl_lamind10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lamind10_user`
--
DROP TABLE IF EXISTS `tl_lamind10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lamind10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`mindmap_session_uid` bigint(20) default NULL,
`entry_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_972920762_CB8A58FFA3B0FADF` (`mindmap_session_uid`),
CONSTRAINT `FK_NEW_972920762_CB8A58FFA3B0FADF` FOREIGN KEY (`mindmap_session_uid`) REFERENCES `tl_lamind10_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lamind10_user`
--
LOCK TABLES `tl_lamind10_user` WRITE;
/*!40000 ALTER TABLE `tl_lamind10_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lamind10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lanb11_attachment`
--
DROP TABLE IF EXISTS `tl_lanb11_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lanb11_attachment` (
`attachment_id` bigint(20) NOT NULL auto_increment,
`nb_content_uid` bigint(20) NOT NULL,
`filename` varchar(255) NOT NULL,
`uuid` bigint(20) NOT NULL,
`version_id` bigint(20) default NULL,
`online_file` tinyint(1) NOT NULL,
PRIMARY KEY (`attachment_id`),
KEY `nb_content_uid` (`nb_content_uid`),
CONSTRAINT `FK_tl_lanb11_attachment_1` FOREIGN KEY (`nb_content_uid`) REFERENCES `tl_lanb11_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lanb11_attachment`
--
LOCK TABLES `tl_lanb11_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lanb11_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lanb11_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lanb11_content`
--
DROP TABLE IF EXISTS `tl_lanb11_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lanb11_content` (
`uid` bigint(20) NOT NULL auto_increment,
`nb_content_id` bigint(20) NOT NULL,
`title` text,
`content` text,
`online_instructions` text,
`offline_instructions` text,
`define_later` tinyint(1) default NULL,
`force_offline` tinyint(1) default NULL,
`reflect_on_activity` tinyint(1) default NULL,
`reflect_instructions` text,
`content_in_use` tinyint(1) default NULL,
`creator_user_id` bigint(20) default NULL,
`date_created` datetime default NULL,
`date_updated` datetime default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `nb_content_id` (`nb_content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lanb11_content`
--
LOCK TABLES `tl_lanb11_content` WRITE;
/*!40000 ALTER TABLE `tl_lanb11_content` DISABLE KEYS */;
INSERT INTO `tl_lanb11_content` VALUES (1,2,'Noticeboard','Content','','',0,0,0,'Reflect on noticeboard',0,NULL,'2009-05-21 17:32:55',NULL),(2,23,'LAMS 2.3','
\n
\n
What\'s New in LAMS 2.3
\n
You\'ve mastered the authoring environment, created a sequence and seen how to monitor learners while they work through your creation.
\n
\n
But what\'s next?
\n
The LAMS v2.3 release introduces new features and activities that can make your sequences even more powerful.
The new FCKEditor has some neat new features that make including external content and multimedia in LAMS sequences even easier.
\n
\n
For starters, there is a new Media Player function (more info here) that automatically inserts audio and video into LAMS activities - this means that you no longer have to work with HTML code to embed multimedia into LAMS.
\n
Media Player Examples
\n
\n
\n \n
\n
\n
YouTube Videos
\n \n
\n
\n
\n
\n
\n
MP3 Files
\n
\n
LAMS PODCAST with ALAN CARRINGTON (CLPD Adelaide Uni) \n and JAMES DALZIEL (MELCOE, Macquarie Uni)
\n
\n
\n
\n \n
\n
Drawing Plugin
\n
There is also a Drawing plugin for fckEditor which works much the same way as a standard painting program.
\n
\n
Authors and Learners can create images like this...
\n
\n
\n
\n
...all from within LAMS!
\n
\n\n
Other FCK Plugins
\n
You can now also include a whole raft of plugins into the fckEditor, such as
\n
\n
\n
Skype Instant Messaging
\n
\n
\n
Google Maps
\n
\n
\n
LaTeX Equation Editor
\n
\n
\n
and more.
\n
\n
\n
For more information about the FCK Editor plugins, click here.
\n
\n
\n\n
\n
Click \'Next Activity\' to move on. \n
\n
','','',0,0,0,'',0,5,'2008-04-10 13:35:26','2009-05-14 20:14:42'),(4,27,'Assessment and Gradebook','
The New Assessment Activity
\n
The new Assessment activity makes it easier than ever to create complex assessment tasks inside a LAMS sequence. The new tool can also export the results from an assessment task into a Gradebook, which can then be recorded in LAMS, or exported for use in another program.
\n
\n
The Assessment tool is highly configurable, and supports a range of question types which may or may not be attempted within a time limit. Learner feedback is also highly customisable, and sequence Authors/Monitors have the option of allowing Learners to re-attempt the assessment, with the option of reducing their final grade by penalty marks with each attempt.
\n
\n
For more detailed information about creating and using Assessment activities, view the LAMS online help, here.
\n
\n\n
Using the Gradebook
\n
The New Gradebook interface allows Monitoring teachers to gain a comprehensive overview of Learners performance through a lesson.
\n
\n
Not only the Assessment Activity but any LAMS activity that creates outputs can be used as part of a Gradebook.
That wraps it up for all the new activities included as part of LAMS 2.3
\n
Why not have a go now at creating your own sequence using some of the new activities we\'ve discovered?
\n
\n\n
Click \'Next Activity\' to finish this lesson.
','','',0,0,0,'Reflect on noticeboard',0,5,'2009-05-14 02:00:41','2009-05-14 20:32:41'),(6,30,'Video Recorder Tool','
The Video Recorder
\n
\n
As part of LAMS 2.3, we\'re very excited to announce the release of the Video Recorder tool, which adds two new major features to LAMS.
\n
\n
\n
Firstly,
\nsequence authors can now add video messages to any instructions field in LAMS. This means that the Author can \'teach\' the lesson from a Q&A, Submit Files, &c, anywhere where instructions are given to learners.
\n
\n
\n
Secondly,
\n
the Video Recorder adds a new activity to LAMS, which allows Learners to upload and comment on their own videos during the sequence.
\n
\n
For more details and a demo of the Video recorder, see the LAMS Wiki, here.
The rest of this sequence will let you view demonstrations of each of the LAMS activities, and briefly discuss how they might be best used in a lesson.
The Informative tools in LAMS allow Authors and Monitors to share information with Learners, and (in the case of Share Resources) allow Learners to share information with each other.
\n
\n
Informative tools display on the Authoring Canvas with an orange icon.
\n
\n\n
Noticeboard
\n
The Noticeboard provides a simple way of providing information and content to the learners. The activity can display text, images, audio, video, links and other HTML content.
\n
\n
Example: The activity you’re looking at right now is a Noticeboard!
\n
\n\n
Share Resources
\n
Resource Sharing allows Authors to create lists of resources such as:
\n
\n
\n
URL hyperlinks
\n
Complete websites - created and uploaded to LAMS as a .zip file
\n
Individual files, such as documents, PDF’s, Audio and Video files
\n
and even IMS content packages.
\n
\n
\n
The tool can also be set-up so that Learners can add their own resources for other learners to see.
\n
\n
Example: The animations in these ’Getting Started’ were added to LAMS by creating a zipped website and uploading the file into a Share Resources activity.
The Assessment tools in LAMS provide a vehicle for sequence monitors to collect Learner responses to a topic.
\n
\n\n
Multiple Choice
\n
The Multiple Choice Quiz delivers a series of Multiple Choice questions to learners, and the advanced features of this tool provide a high level of customisation for Authors as to how the quiz is administered.
\n
\n
When the Quiz is complete, LAMS will automatically tally the marks from each learner and display the statistics to sequence monitors.
\n
\n
Authors can also choose to release Learner marks directly after they have completed the quiz, as a type of formative assessment or delay releasing the marks until a Sequence Monitor chooses to release them, for Summative Assessment. The Activity also allows learners to view the top, bottom and average marks from the quiz.
\n
\n\n
Submit Files
\n
The Submit Files Activity provides a vehicle for Authors to collect Student responses which are created in software outside of LAMS.
\n
\n
This could be an essay in .DOC or .PDF format, a digital presentation, or some sort of multimedia file.
\n
\n
Learners log in to LAMS, and are able to upload their file to the LAMS server as an attachment. Sequence Monitors can view these files, comment on them and give each individual file a mark, which is in turn accessible by Learners.
\n
\n
Like the MCQ, sequence authors can choose to allow learners several attempts at submission, allowing for feedback and creating a formative assessment style, or alternatively, lock the activity after submission, which creates a summative assessment style.
\n
\n\n
\n
The next activity is a demonstration Multiple Choice quiz, \nfollowed by a demonstration Submit Files activity.
','','',0,0,0,'',0,8,'2008-04-10 14:39:45','2008-11-14 13:14:54'),(12,38,'DimDim Web Conferencing','
Also available for use in LAMS 2.2 is the DimDim Web Conferencing Activity.
\n
\n
The documentation is included below (You will need internet access to view this page.)
Reflective tools ask learners to analyse their own learning throughout a sequence, \nor alternatively, collects responses from students and asks them to consider trends in the resulting data.
\n
\n\n
\n
Question and Answer
\n
This activity creates a series of Questions and Short-Answer responses for Learners.
\n
\n
The sequence Author can pen their own responses to each question, which are displayed to learners after they have submitted their own answers.
\n
The activity can also be configured to display answers collected from all learners in the sequence or group.
\n
The Question and Answer Activity allows teachers to pose a question or questions to learners individually, and after they have entered their response, to see the responses of all their peers presented on a single answer screen.
\n
\n
\n\n
\n
\n
Survey
\n
\n
The Survey Tool is similar to Multiple Choice, in that it presents learners with a number of questions and collects their responses. However, unlike Multiple Choice there are no right or wrong answers - the system just collates all answers for analysis by the teacher in the monitoring area.
\n
Question types include single response, multiple response and open text entry, and questions can be mandatory or optional. For multiple choice questions, Learners can also be provided with the option of adding their own answer to a list.
\n
\n
\n\n
\n
\n
Voting
\n
\n
The Voting Activity allows teachers to provide learners with a list of options to "Vote" on. It is similar to the Q&A Activity in that Voting shows first one screen with all the available voting options, then a screen showing the individual learner’s selection, then a screen showing "progressive" voting results (i.e., a non-editable screen where learners can see results from themselves and other learners over time). Finally, there is Summary Screen of group results.
\n
\n
\n\n
\n
The next three activities demonstrate the Q&A, Survey and Voting activities.
The Collaborative tools in LAMS allow Learners to team up and solve problems, discuss ideas or share solutions together.
\n
\n\n
Chat Activity
\n
\n
The Chat Activity runs a live (synchronous) discussion for learners. \nThis is similar to Instant Messaging (IM) software that most learners will be familiar with.
\n
\n
\n\n
\n
Forum Activity
\n
\n
The Forum Activity provides an asynchronous discussion environment for learners, with discussion threads initially created by the teacher.\n
Forums can be ’locked’ as an activity which is only available for the period of the specific activity (i.e.: no more contributions can be made once the learner clicks ’Finish’, or they can be ’unlocked’, in that learners can add to the Forum throughout the life of the whole sequence.
\n
\n
\n\n
\n
Scribe Activity
\n
The Scribe Activity is, by default, not enabled as a stand-alone activity. \n
It allows a group of Learners to collaborate and create a written report with one Learner as the ’Scribe,’ or Writer for the report. The activity is most effective when paired with another collaborative activity. In the current release of LAMS (2.2) Scribe is available to be paired with either Chat or Forum.
\n
Using the Scribe Activity
\n
The Scribe Activity should always used in conjunction with another activity that gives it context. For instance, if used with Chat, then the Scribe (one particular learner) is expected to collect or summarize the output of the Chat discussion into a succinct set of sentences. Once the scribe has done this, they publish the summary to the rest of the learners who vote whether they agree with the summary as proposed by the scribe. If not, they can ask the scribe to modify the report until all learners agree on the report.
\n
Once the Scribe submits the report, the other learners in the group or class can agree or disagree with the summary. The scribe can finished the scribe task at any time regardless of the number of learners that have agreed with the proposed summaries. The Scribe task can also be finished through the monitoring environment by a teacher or instructor.
\n
Once the scribe task is finished a report of the statements and summary is presented to all learners.
There are Several Split-Screen activities available to authors \nthat combine several activities on the same screen.
\n\n
\n
\n
Chat and Scribe
\n
This activity is great for collecting Group Reports.
\n
\n
\n
It combines a Chat Activity with a Scribe Activity for collating the chat group\'s view on questions created by the teacher. When used in small group mode, the tool creates parallel Chat and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\n
\n
\n
\n
\n
\n
\n
\n
\n\n
\n
\n\n
Forum and Scribe
\n
The activity ombines a Forum Activity with a Scribe Activity for collating Forum Postings into a written report, which then must be approved by the entire group.
\n
\n
When used in small group mode, the tool creates parallel Forum and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\n
\n
\n
\n
\n
\n
\n\n
Resource Sharing and Forum
\n
This activity allows Learners to submit files and/or URLS to a page viewable by their class or group.
\n
\n
The group then discuss the resources in the Forum.
\n
\n
This is a great way to get Learner\'s evaluating each other\'s work, or to foster some collaborative online research.
\n
\n
\n
\n
\n
\n
\n\n
\n
\n
The next activity is a demonstration Resource Sharing and Forum activity.
The Google Maps tool allows sequence Authors to create maps or satellite images with annotated place markers. During the running of the activity, Learners can add their own markers to the map and view markers placed by other learners.
\n
\n
A demonstration Gmap activity is coming up.
\n
\n\n
\n
Wiki Activity
\n
\n
The Wiki Tool allows for authors to create content pages that can link to each other and, optionally, allow Learners to make collaborative edits to the content provided.
\n
Wiki activities allow authors and learners to create sub pages, which can contain more refined content on the topic.
\n
A Wiki Demonstration activity is coming up, which you can explore and edit.
The next LAMS activity to look at is the Notebook activity.
\n
\n
This activity is a bit special because it can be attached to any LAMS activity at any point in the lesson. \nEach LAMS activity has an option in Advanced Properties called "attach Notebook with text..."
\n
\n
Basically, this allows sequences authors to get Learners to reflect on their knowledge at any point in the sequence - and it’s also really easy for monitors to add a notebook to any activity in a sequence without mucking around with transition lines or changing the shape of the sequence.
\n
\n
Of course, the notebook can also be included in sequences as a standalone tool.
The Data Collection tool allows Authors to create database style lists for Learners to populate. \nEach record list is highly flexible, and the activity can be configured to allow multiple records to exist for each learner.
\n
The next Activity demonstrates the use of Data Collection.
This is what Learners will see when they log in to LAMS and start participating in a sequence.
\n
The Learning Environment displays the sequences that are created in Authoring.
\n
\n\n
The Authoring Environment
\n
The Authoring Environment is where sequences are put together, modified and shared.
\n
It contains all of the LAMS activities, and is where authors create their lesson designs.
\n
\n
\n
The Monitoring Environment
\n
Monitorsare not necessarily the people who Authored the sequence in the first place - they simply run the lesson for learners, and supervise each learner’s progress through the lesson. In practice, Teachers are often both Authors and Monitors for their class(es) of students.
\n
\n
\n
The System Administration Environment
\n
System Administration is for Technical Management of a LAMS server.
\n
\n
From here, users with Administration rights can change nearly every aspect of the LAMS software.
You’re Using the Learning Environment Right Now! \n
\n
\n
... but if you want to check out more of the features, \nview the following animations!
\n
\n\n
\nThe First Animation demonstrates a Learner moving through a sequence.
\n
\n
The Second Animation deals with the new "no-flash" interfacefor the Learning Environment
','','',0,0,0,'',0,11,'2008-04-11 17:34:57','2008-05-29 17:16:33'),(21,58,'Are You Sure?','
You’ve reached the end of this sequence... but are you sure you want to leave?
\n
\n
\n \n
\n
\n
\n
. .
\n
\n
You may have clicked the Next Activity button on the last screen,which would bring you here.
\n
\n
If so, and you want to go back and view more of this sequence, double-click the Icon for the Optional Activity in your Progress Bar (see the graphic at right.)
\n
\n
Once there, select an option, and click the Choose button.
\n
\n
\n
\n
If you really have finished, and want to leave the sequence, click Next Activity below. \n
\n
\n
\n \n
\n
\n
\n
\n
','','',0,0,0,'',0,1,'2008-05-02 11:42:23','2008-05-02 12:05:42'),(22,63,'The Structure of LAMS','
LAMS is arranged hierarchically, with sequences organised into Groups and Subgroups.
\n
What does this mean?
\n
Think of it like this:
\n
\n
\n \n
\n
\n
In Real Life
\n
\n
\n
In Lams
\n
\n
\n
\n
\n
\n
A Professor teaches a Course, and organises smaller classes.
\n
Individual Tutors teaches a smaller Class taken from the whole course.
\n
A Course has at least one lesson plan, that is applied to all students in the course.
\n
The smaller classes can have at least one specific lesson plan for those students.
\n
\n
\n
\n
\n
A Course Manager creates a main Group, and can create several SubGroups.
\n
Author/Monitors are assigned to one or many Subgroups.
\n
The Group contains one or more Sequences for all Learners in the Group.
\n
Likewise, the Subgroup can contain one or many Sequences for those Learners.
\n
\n
\n
\n \n
\n
\n
\n
There is also the role of Course Administrator. This role allows the user to modify Groups, Subgroups and Learners inside a course. In practice, this is a secretarial role designed to assist the educator running the course.
\n
\n\n
A Working Example
\n
This image shows the different sections that make up a Group in LAMS.
Congratulations - if you can see this sequence, LAMS is up and running on your server. You’ve also figured out how to log in, and participate in a "sequence" - that’s what we call a collection of LAMS activities.
\n
\n
In a word, that’s what LAMS does - it is a System that Manages sequences of Learning Activities. A Sequence is an online digital lesson that simulates the classroom environment in a virtual space.
\n
Sequences are first created by Authors, and are then run for different groups of Learners while a Monitor supervises. We’ll look more at these Roles in LAMS in Lesson Two of LAMS101.
\n
Sequences are made up of activities - each of which has a particular function, either:
\n\n
Informative Collaborative Assessment Reflective
\n\n
Sequences can include a range of individual tasks, small group work and whole class activities based on both content and collaboration.
\n
When you use LAMS, not only are you creating online activities for your learners, you also create a structured lesson plan at the same time. We’ll talk about this Visual Authoring Environment in a few moments.
\n
... and what’s with the Sheep?
\n\n
\n
Dolly is our LAMS mascot. Back when LAMS was being redesigned for version 2.0, it was the "next-generation" of LAMS. Dolly the sheep was the first mammal to have been successfully cloned from an adult cell, therefore, she was the next generation LAMB (see what we did there?).
\n
Our marvelous designer Shelly is the official mother of Dolly and also our front page model. So all kudos to her!
\n\n
\n
To progress to the next activity in this sequence, click the button down here.
','','',0,0,0,'Reflect on noticeboard',0,1,'2008-03-12 16:38:33','2008-06-05 09:52:50'),(24,66,'Creating Your Own Sequences','
LAMS Authoring
\n
LAMS provides you with a visual authoring environment for creating, storing and re-using activity sequences. The drag-and-drop interface is central to the LAMS authoring environment. Teachers drag-and-drop activities into the authoring area and then join the activities together by drawing "Transitions" to produce a learning sequence. This workflow model is what principally distinguishes LAMS from other more content based online learning platforms. LAMS has a wide range of tools designed for use in a range of educational contexts by teachers and students with varying levels of technical expertise.
\n
Benefits of LAMS
\n
Creating a lesson in LAMS means that:
\n
\n
\n
You can plan all aspects of the lesson.
\n
You can preview the lesson from the perspective of your learners.
\n
You create a visual overview of the lesson, and can easily identify the learning styles addressed.
\n
You can create a standardised set of learning templates that can easily be modified for later use.
\n
\n
\n\n
\n
\n
The next animation will demonstrate creating a lesson in LAMS.
','','',0,0,0,'',0,11,'2008-04-03 16:11:54','2008-05-29 16:55:57'),(25,68,'The tip of the iceberg...','
LAMS has many, many more functions that you can explore.
\n
The new release of version 2.1 includes increased functionality in many areas, some of which are explored in the rest of this Getting Started course.
The new FCKEditor has some neat new features that make including external content and multimedia in LAMS sequences even easier.
\n
\n
For starters, there is a new Media Player function (more info here) that automatically inserts audio and video into LAMS activities - this means that you no longer have to work with HTML code to embed multimedia into LAMS.
\n
Media Player Examples
\n
\n
\n \n
\n
\n
YouTube Videos
\n \n
\n
\n
\n
\n
\n
MP3 Files
\n
\n
LAMS PODCAST with ALAN CARRINGTON (CLPD Adelaide Uni) \n and JAMES DALZIEL (MELCOE, Macquarie Uni)
\n
\n
\n
\n \n
\n
Drawing Plugin
\n
There is also a Drawing plugin for fckEditor which works much the same way as a standard painting program.
\n
\n
Authors and Learners can create images like this...
\n
\n
\n
\n
...all from within LAMS!
\n
\n\n
Other FCK Plugins
\n
You can now also include a whole raft of plugins into the fckEditor, such as
\n
\n
\n
Skype Instant Messaging
\n
\n
\n
Google Maps
\n
\n
\n
LaTeX Equation Editor
\n
\n
\n
and more.
\n
\n
\n
For more information about the FCK Editor plugins, click here.
That wraps it up for all the new activities included as part of LAMS 2.3
\n
Why not have a go now at creating your own sequence using some of the new activities we\'ve discovered?
\n
\n\n
Click \'Next Activity\' to finish this lesson.
','','',0,0,0,'Reflect on noticeboard',0,5,'2009-05-14 02:00:41','2009-05-14 20:32:41'),(28,74,'Video Recorder Tool','
The Video Recorder
\n
\n
As part of LAMS 2.3, we\'re very excited to announce the release of the Video Recorder tool, which adds two new major features to LAMS.
\n
\n
\n
Firstly,
\nsequence authors can now add video messages to any instructions field in LAMS. This means that the Author can \'teach\' the lesson from a Q&A, Submit Files, &c, anywhere where instructions are given to learners.
\n
\n
\n
Secondly,
\n
the Video Recorder adds a new activity to LAMS, which allows Learners to upload and comment on their own videos during the sequence.
\n
\n
For more details and a demo of the Video recorder, see the LAMS Wiki, here.
You\'ve mastered the authoring environment, created a sequence and seen how to monitor learners while they work through your creation.
\n
\n
But what\'s next?
\n
The LAMS v2.3 release introduces new features and activities that can make your sequences even more powerful.
\n
\n
Click \'Next Activity\' to learn more.
\n
\n
','','',0,0,0,'',0,5,'2008-04-10 11:56:54','2009-05-14 20:14:08'),(30,76,'Assessment and Gradebook','
The New Assessment Activity
\n
The new Assessment activity makes it easier than ever to create complex assessment tasks inside a LAMS sequence. The new tool can also export the results from an assessment task into a Gradebook, which can then be recorded in LAMS, or exported for use in another program.
\n
\n
The Assessment tool is highly configurable, and supports a range of question types which may or may not be attempted within a time limit. Learner feedback is also highly customisable, and sequence Authors/Monitors have the option of allowing Learners to re-attempt the assessment, with the option of reducing their final grade by penalty marks with each attempt.
\n
\n
For more detailed information about creating and using Assessment activities, view the LAMS online help, here.
\n
\n\n
Using the Gradebook
\n
The New Gradebook interface allows Monitoring teachers to gain a comprehensive overview of Learners performance through a lesson.
\n
\n
Not only the Assessment Activity but any LAMS activity that creates outputs can be used as part of a Gradebook.
The Informative tools in LAMS allow Authors and Monitors to share information with Learners, and (in the case of Share Resources) allow Learners to share information with each other.
\n
\n
Informative tools display on the Authoring Canvas with an orange icon.
\n
\n\n
Noticeboard
\n
The Noticeboard provides a simple way of providing information and content to the learners. The activity can display text, images, audio, video, links and other HTML content.
\n
\n
Example: The activity you’re looking at right now is a Noticeboard!
\n
\n\n
Share Resources
\n
Resource Sharing allows Authors to create lists of resources such as:
\n
\n
\n
URL hyperlinks
\n
Complete websites - created and uploaded to LAMS as a .zip file
\n
Individual files, such as documents, PDF’s, Audio and Video files
\n
and even IMS content packages.
\n
\n
\n
The tool can also be set-up so that Learners can add their own resources for other learners to see.
\n
\n
Example: The animations in these ’Getting Started’ were added to LAMS by creating a zipped website and uploading the file into a Share Resources activity.
The rest of this sequence will let you view demonstrations of each of the LAMS activities, and briefly discuss how they might be best used in a lesson.
The Collaborative tools in LAMS allow Learners to team up and solve problems, discuss ideas or share solutions together.
\n
\n\n
Chat Activity
\n
\n
The Chat Activity runs a live (synchronous) discussion for learners. \nThis is similar to Instant Messaging (IM) software that most learners will be familiar with.
\n
\n
\n\n
\n
Forum Activity
\n
\n
The Forum Activity provides an asynchronous discussion environment for learners, with discussion threads initially created by the teacher.\n
Forums can be ’locked’ as an activity which is only available for the period of the specific activity (i.e.: no more contributions can be made once the learner clicks ’Finish’, or they can be ’unlocked’, in that learners can add to the Forum throughout the life of the whole sequence.
\n
\n
\n\n
\n
Scribe Activity
\n
The Scribe Activity is, by default, not enabled as a stand-alone activity. \n
It allows a group of Learners to collaborate and create a written report with one Learner as the ’Scribe,’ or Writer for the report. The activity is most effective when paired with another collaborative activity. In the current release of LAMS (2.2) Scribe is available to be paired with either Chat or Forum.
\n
Using the Scribe Activity
\n
The Scribe Activity should always used in conjunction with another activity that gives it context. For instance, if used with Chat, then the Scribe (one particular learner) is expected to collect or summarize the output of the Chat discussion into a succinct set of sentences. Once the scribe has done this, they publish the summary to the rest of the learners who vote whether they agree with the summary as proposed by the scribe. If not, they can ask the scribe to modify the report until all learners agree on the report.
\n
Once the Scribe submits the report, the other learners in the group or class can agree or disagree with the summary. The scribe can finished the scribe task at any time regardless of the number of learners that have agreed with the proposed summaries. The Scribe task can also be finished through the monitoring environment by a teacher or instructor.
\n
Once the scribe task is finished a report of the statements and summary is presented to all learners.
There are Several Split-Screen activities available to authors \nthat combine several activities on the same screen.
\n\n
\n
\n
Chat and Scribe
\n
This activity is great for collecting Group Reports.
\n
\n
\n
It combines a Chat Activity with a Scribe Activity for collating the chat group\'s view on questions created by the teacher. When used in small group mode, the tool creates parallel Chat and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\n
\n
\n
\n
\n
\n
\n
\n
\n\n
\n
\n\n
Forum and Scribe
\n
The activity ombines a Forum Activity with a Scribe Activity for collating Forum Postings into a written report, which then must be approved by the entire group.
\n
\n
When used in small group mode, the tool creates parallel Forum and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\n
\n
\n
\n
\n
\n
\n\n
Resource Sharing and Forum
\n
This activity allows Learners to submit files and/or URLS to a page viewable by their class or group.
\n
\n
The group then discuss the resources in the Forum.
\n
\n
This is a great way to get Learner\'s evaluating each other\'s work, or to foster some collaborative online research.
\n
\n
\n
\n
\n
\n
\n\n
\n
\n
The next activity is a demonstration Resource Sharing and Forum activity.
The Google Maps tool allows sequence Authors to create maps or satellite images with annotated place markers. During the running of the activity, Learners can add their own markers to the map and view markers placed by other learners.
\n
\n
A demonstration Gmap activity is coming up.
\n
\n\n
\n
Wiki Activity
\n
\n
The Wiki Tool allows for authors to create content pages that can link to each other and, optionally, allow Learners to make collaborative edits to the content provided.
\n
Wiki activities allow authors and learners to create sub pages, which can contain more refined content on the topic.
\n
A Wiki Demonstration activity is coming up, which you can explore and edit.
The Assessment tools in LAMS provide a vehicle for sequence monitors to collect Learner responses to a topic.
\n
\n\n
Multiple Choice
\n
The Multiple Choice Quiz delivers a series of Multiple Choice questions to learners, and the advanced features of this tool provide a high level of customisation for Authors as to how the quiz is administered.
\n
\n
When the Quiz is complete, LAMS will automatically tally the marks from each learner and display the statistics to sequence monitors.
\n
\n
Authors can also choose to release Learner marks directly after they have completed the quiz, as a type of formative assessment or delay releasing the marks until a Sequence Monitor chooses to release them, for Summative Assessment. The Activity also allows learners to view the top, bottom and average marks from the quiz.
\n
\n\n
Submit Files
\n
The Submit Files Activity provides a vehicle for Authors to collect Student responses which are created in software outside of LAMS.
\n
\n
This could be an essay in .DOC or .PDF format, a digital presentation, or some sort of multimedia file.
\n
\n
Learners log in to LAMS, and are able to upload their file to the LAMS server as an attachment. Sequence Monitors can view these files, comment on them and give each individual file a mark, which is in turn accessible by Learners.
\n
\n
Like the MCQ, sequence authors can choose to allow learners several attempts at submission, allowing for feedback and creating a formative assessment style, or alternatively, lock the activity after submission, which creates a summative assessment style.
\n
\n\n
\n
The next activity is a demonstration Multiple Choice quiz, \nfollowed by a demonstration Submit Files activity.
Reflective tools ask learners to analyse their own learning throughout a sequence, \nor alternatively, collects responses from students and asks them to consider trends in the resulting data.
\n
\n\n
\n
Question and Answer
\n
This activity creates a series of Questions and Short-Answer responses for Learners.
\n
\n
The sequence Author can pen their own responses to each question, which are displayed to learners after they have submitted their own answers.
\n
The activity can also be configured to display answers collected from all learners in the sequence or group.
\n
The Question and Answer Activity allows teachers to pose a question or questions to learners individually, and after they have entered their response, to see the responses of all their peers presented on a single answer screen.
\n
\n
\n\n
\n
\n
Survey
\n
\n
The Survey Tool is similar to Multiple Choice, in that it presents learners with a number of questions and collects their responses. However, unlike Multiple Choice there are no right or wrong answers - the system just collates all answers for analysis by the teacher in the monitoring area.
\n
Question types include single response, multiple response and open text entry, and questions can be mandatory or optional. For multiple choice questions, Learners can also be provided with the option of adding their own answer to a list.
\n
\n
\n\n
\n
\n
Voting
\n
\n
The Voting Activity allows teachers to provide learners with a list of options to "Vote" on. It is similar to the Q&A Activity in that Voting shows first one screen with all the available voting options, then a screen showing the individual learner’s selection, then a screen showing "progressive" voting results (i.e., a non-editable screen where learners can see results from themselves and other learners over time). Finally, there is Summary Screen of group results.
\n
\n
\n\n
\n
The next three activities demonstrate the Q&A, Survey and Voting activities.
The next LAMS activity to look at is the Notebook activity.
\n
\n
This activity is a bit special because it can be attached to any LAMS activity at any point in the lesson. \nEach LAMS activity has an option in Advanced Properties called "attach Notebook with text..."
\n
\n
Basically, this allows sequences authors to get Learners to reflect on their knowledge at any point in the sequence - and it’s also really easy for monitors to add a notebook to any activity in a sequence without mucking around with transition lines or changing the shape of the sequence.
\n
\n
Of course, the notebook can also be included in sequences as a standalone tool.
The Data Collection tool allows Authors to create database style lists for Learners to populate. \nEach record list is highly flexible, and the activity can be configured to allow multiple records to exist for each learner.
\n
The next Activity demonstrates the use of Data Collection.
This is what Learners will see when they log in to LAMS and start participating in a sequence.
\n
The Learning Environment displays the sequences that are created in Authoring.
\n
\n\n
The Authoring Environment
\n
The Authoring Environment is where sequences are put together, modified and shared.
\n
It contains all of the LAMS activities, and is where authors create their lesson designs.
\n
\n
\n
The Monitoring Environment
\n
Monitorsare not necessarily the people who Authored the sequence in the first place - they simply run the lesson for learners, and supervise each learner’s progress through the lesson. In practice, Teachers are often both Authors and Monitors for their class(es) of students.
\n
\n
\n
The System Administration Environment
\n
System Administration is for Technical Management of a LAMS server.
\n
\n
From here, users with Administration rights can change nearly every aspect of the LAMS software.
The next activity will allow you to choose from animated tutorials on each three environments.
','','',0,0,0,'',0,1,'2008-03-27 15:12:18','2008-06-05 11:47:45'),(44,104,'Are You Sure?','
You’ve reached the end of this sequence... but are you sure you want to leave?
\n
\n
\n \n
\n
\n
\n
. .
\n
\n
You may have clicked the Next Activity button on the last screen,which would bring you here.
\n
\n
If so, and you want to go back and view more of this sequence, double-click the Icon for the Optional Activity in your Progress Bar (see the graphic at right.)
\n
\n
Once there, select an option, and click the Choose button.
\n
\n
\n
\n
If you really have finished, and want to leave the sequence, click Next Activity below. \n
\n
\n
\n \n
\n
\n
\n
\n
','','',0,0,0,'',0,1,'2008-05-02 11:42:23','2008-05-02 12:05:42'),(45,107,'The Structure of LAMS','
LAMS is arranged hierarchically, with sequences organised into Groups and Subgroups.
\n
What does this mean?
\n
Think of it like this:
\n
\n
\n \n
\n
\n
In Real Life
\n
\n
\n
In Lams
\n
\n
\n
\n
\n
\n
A Professor teaches a Course, and organises smaller classes.
\n
Individual Tutors teaches a smaller Class taken from the whole course.
\n
A Course has at least one lesson plan, that is applied to all students in the course.
\n
The smaller classes can have at least one specific lesson plan for those students.
\n
\n
\n
\n
\n
A Course Manager creates a main Group, and can create several SubGroups.
\n
Author/Monitors are assigned to one or many Subgroups.
\n
The Group contains one or more Sequences for all Learners in the Group.
\n
Likewise, the Subgroup can contain one or many Sequences for those Learners.
\n
\n
\n
\n \n
\n
\n
\n
There is also the role of Course Administrator. This role allows the user to modify Groups, Subgroups and Learners inside a course. In practice, this is a secretarial role designed to assist the educator running the course.
\n
\n\n
A Working Example
\n
This image shows the different sections that make up a Group in LAMS.
You’re Using the Learning Environment Right Now! \n
\n
\n
... but if you want to check out more of the features, \nview the following animations!
\n
\n\n
\nThe First Animation demonstrates a Learner moving through a sequence.
\n
\n
The Second Animation deals with the new "no-flash" interfacefor the Learning Environment
','','',0,0,0,'',0,11,'2008-04-11 17:34:57','2008-05-29 17:16:33'),(47,112,'Creating Your Own Sequences','
LAMS Authoring
\n
LAMS provides you with a visual authoring environment for creating, storing and re-using activity sequences. The drag-and-drop interface is central to the LAMS authoring environment. Teachers drag-and-drop activities into the authoring area and then join the activities together by drawing "Transitions" to produce a learning sequence. This workflow model is what principally distinguishes LAMS from other more content based online learning platforms. LAMS has a wide range of tools designed for use in a range of educational contexts by teachers and students with varying levels of technical expertise.
\n
Benefits of LAMS
\n
Creating a lesson in LAMS means that:
\n
\n
\n
You can plan all aspects of the lesson.
\n
You can preview the lesson from the perspective of your learners.
\n
You create a visual overview of the lesson, and can easily identify the learning styles addressed.
\n
You can create a standardised set of learning templates that can easily be modified for later use.
\n
\n
\n\n
\n
\n
The next animation will demonstrate creating a lesson in LAMS.
Congratulations - if you can see this sequence, LAMS is up and running on your server. You’ve also figured out how to log in, and participate in a "sequence" - that’s what we call a collection of LAMS activities.
\n
\n
In a word, that’s what LAMS does - it is a System that Manages sequences of Learning Activities. A Sequence is an online digital lesson that simulates the classroom environment in a virtual space.
\n
Sequences are first created by Authors, and are then run for different groups of Learners while a Monitor supervises. We’ll look more at these Roles in LAMS in Lesson Two of LAMS101.
\n
Sequences are made up of activities - each of which has a particular function, either:
\n\n
Informative Collaborative Assessment Reflective
\n\n
Sequences can include a range of individual tasks, small group work and whole class activities based on both content and collaboration.
\n
When you use LAMS, not only are you creating online activities for your learners, you also create a structured lesson plan at the same time. We’ll talk about this Visual Authoring Environment in a few moments.
\n
... and what’s with the Sheep?
\n\n
\n
Dolly is our LAMS mascot. Back when LAMS was being redesigned for version 2.0, it was the "next-generation" of LAMS. Dolly the sheep was the first mammal to have been successfully cloned from an adult cell, therefore, she was the next generation LAMB (see what we did there?).
\n
Our marvelous designer Shelly is the official mother of Dolly and also our front page model. So all kudos to her!
\n\n
\n
To progress to the next activity in this sequence, click the button down here.
','','',0,0,0,'Reflect on noticeboard',0,1,'2008-03-12 16:38:33','2008-06-05 09:52:50'),(49,116,'The tip of the iceberg...','
LAMS has many, many more functions that you can explore.
\n
The new release of version 2.1 includes increased functionality in many areas, some of which are explored in the rest of this Getting Started course.
\n
We Hope You Enjoy Exploring LAMS!
\n
\n
','','',0,0,0,'',0,1,'2008-04-04 11:30:06','2008-06-05 11:45:40');
/*!40000 ALTER TABLE `tl_lanb11_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lanb11_session`
--
DROP TABLE IF EXISTS `tl_lanb11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lanb11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`nb_session_id` bigint(20) NOT NULL,
`nb_session_name` varchar(255) NOT NULL,
`nb_content_uid` bigint(20) NOT NULL,
`session_start_date` datetime default NULL,
`session_end_date` datetime default NULL,
`session_status` varchar(100) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `nb_session_id` (`nb_session_id`),
KEY `nb_content_uid` (`nb_content_uid`),
CONSTRAINT `FK_tl_lanb11_session_1` FOREIGN KEY (`nb_content_uid`) REFERENCES `tl_lanb11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lanb11_session`
--
LOCK TABLES `tl_lanb11_session` WRITE;
/*!40000 ALTER TABLE `tl_lanb11_session` DISABLE KEYS */;
INSERT INTO `tl_lanb11_session` VALUES (1,1,'Everybody learners',27,'2009-05-21 17:38:28',NULL,'NOT_ATTEMPTED'),(2,2,'Everybody learners',30,'2009-05-21 17:38:28',NULL,'NOT_ATTEMPTED'),(3,5,'Everybody learners',28,'2009-05-21 17:38:28',NULL,'NOT_ATTEMPTED'),(4,7,'Everybody learners',26,'2009-05-21 17:38:28',NULL,'NOT_ATTEMPTED'),(5,8,'Everybody learners',29,'2009-05-21 17:38:28',NULL,'NOT_ATTEMPTED'),(6,13,'Everybody learners',34,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(7,14,'Everybody learners',32,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(8,15,'Everybody learners',33,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(9,16,'Everybody learners',35,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(10,17,'Everybody learners',38,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(11,18,'Everybody learners',39,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(12,20,'Everybody learners',36,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(13,27,'Everybody learners',37,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(14,28,'Everybody learners',40,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(15,30,'Everybody learners',41,'2009-05-21 17:39:13',NULL,'NOT_ATTEMPTED'),(16,32,'Everybody learners',42,'2009-05-21 17:39:14',NULL,'NOT_ATTEMPTED'),(17,33,'Everybody learners',31,'2009-05-21 17:39:14',NULL,'NOT_ATTEMPTED'),(18,35,'Everybody learners',46,'2009-05-21 17:39:20',NULL,'NOT_ATTEMPTED'),(19,39,'Everybody learners',45,'2009-05-21 17:39:20',NULL,'NOT_ATTEMPTED'),(20,41,'Everybody learners',44,'2009-05-21 17:39:20',NULL,'NOT_ATTEMPTED'),(21,42,'Everybody learners',43,'2009-05-21 17:39:20',NULL,'NOT_ATTEMPTED'),(22,43,'Everybody learners',49,'2009-05-21 17:39:29',NULL,'NOT_ATTEMPTED'),(23,45,'Everybody learners',47,'2009-05-21 17:39:29',NULL,'NOT_ATTEMPTED'),(24,47,'Everybody learners',48,'2009-05-21 17:39:29',NULL,'NOT_ATTEMPTED');
/*!40000 ALTER TABLE `tl_lanb11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lanb11_user`
--
DROP TABLE IF EXISTS `tl_lanb11_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lanb11_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL,
`nb_session_uid` bigint(20) NOT NULL,
`username` varchar(255) default NULL,
`fullname` varchar(255) default NULL,
`user_status` varchar(50) default NULL,
PRIMARY KEY (`uid`),
KEY `nb_session_uid` (`nb_session_uid`),
CONSTRAINT `FK_tl_lanb11_user_1` FOREIGN KEY (`nb_session_uid`) REFERENCES `tl_lanb11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lanb11_user`
--
LOCK TABLES `tl_lanb11_user` WRITE;
/*!40000 ALTER TABLE `tl_lanb11_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lanb11_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lantbk11_attachment`
--
DROP TABLE IF EXISTS `tl_lantbk11_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lantbk11_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`notebook_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK12090F57FC940906` (`notebook_uid`),
CONSTRAINT `FK12090F57FC940906` FOREIGN KEY (`notebook_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lantbk11_attachment`
--
LOCK TABLES `tl_lantbk11_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lantbk11_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lantbk11_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lantbk11_conditions`
--
DROP TABLE IF EXISTS `tl_lantbk11_conditions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lantbk11_conditions` (
`condition_id` bigint(20) NOT NULL,
`content_uid` bigint(20) default NULL,
PRIMARY KEY (`condition_id`),
KEY `NotebookConditionToNotebook` (`content_uid`),
CONSTRAINT `NotebookConditionInheritance` FOREIGN KEY (`condition_id`) REFERENCES `lams_branch_condition` (`condition_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `NotebookConditionToNotebook` FOREIGN KEY (`content_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lantbk11_conditions`
--
LOCK TABLES `tl_lantbk11_conditions` WRITE;
/*!40000 ALTER TABLE `tl_lantbk11_conditions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lantbk11_conditions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lantbk11_notebook`
--
DROP TABLE IF EXISTS `tl_lantbk11_notebook`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lantbk11_notebook` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`allow_rich_editor` bit(1) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lantbk11_notebook`
--
LOCK TABLES `tl_lantbk11_notebook` WRITE;
/*!40000 ALTER TABLE `tl_lantbk11_notebook` DISABLE KEYS */;
INSERT INTO `tl_lantbk11_notebook` VALUES (1,NULL,NULL,NULL,'Notebook','Instructions',0x00,0x00,0x00,'','',0x00,0x00,8),(2,'2008-11-14 14:32:00','2008-11-10 12:44:29',5,'Notebook Demonstration','
Although this looks like a simple text entry box, when a notebook is placed in the right spot, it can really get learners to think about what they’ve just learnt.
\n
\n
All notebook entries are private between each individual learner and the sequence monitors.
Although this looks like a simple text entry box, when a notebook is placed in the right spot, it can really get learners to think about what they’ve just learnt.
\n
\n
All notebook entries are private between each individual learner and the sequence monitors.
',0x00,0x00,0x00,'','',0x00,0x00,96);
/*!40000 ALTER TABLE `tl_lantbk11_notebook` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lantbk11_session`
--
DROP TABLE IF EXISTS `tl_lantbk11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lantbk11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`notebook_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKB7C198E2FC940906` (`notebook_uid`),
CONSTRAINT `FKB7C198E2FC940906` FOREIGN KEY (`notebook_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lantbk11_session`
--
LOCK TABLES `tl_lantbk11_session` WRITE;
/*!40000 ALTER TABLE `tl_lantbk11_session` DISABLE KEYS */;
INSERT INTO `tl_lantbk11_session` VALUES (1,NULL,NULL,NULL,29,'Everybody learners',3);
/*!40000 ALTER TABLE `tl_lantbk11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lantbk11_user`
--
DROP TABLE IF EXISTS `tl_lantbk11_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lantbk11_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`notebook_session_uid` bigint(20) default NULL,
`entry_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKCB8A58FFA3B0FADF` (`notebook_session_uid`),
CONSTRAINT `FKCB8A58FFA3B0FADF` FOREIGN KEY (`notebook_session_uid`) REFERENCES `tl_lantbk11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lantbk11_user`
--
LOCK TABLES `tl_lantbk11_user` WRITE;
/*!40000 ALTER TABLE `tl_lantbk11_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lantbk11_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lapixl10_attachment`
--
DROP TABLE IF EXISTS `tl_lapixl10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lapixl10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`pixlr_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK951F889ACB8ADA74` (`pixlr_uid`),
CONSTRAINT `FK951F889ACB8ADA74` FOREIGN KEY (`pixlr_uid`) REFERENCES `tl_lapixl10_pixlr` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lapixl10_attachment`
--
LOCK TABLES `tl_lapixl10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lapixl10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lapixl10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lapixl10_configuration`
--
DROP TABLE IF EXISTS `tl_lapixl10_configuration`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lapixl10_configuration` (
`uid` bigint(20) NOT NULL auto_increment,
`config_key` varchar(30) default NULL,
`config_value` text,
PRIMARY KEY (`uid`),
UNIQUE KEY `config_key` (`config_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lapixl10_configuration`
--
LOCK TABLES `tl_lapixl10_configuration` WRITE;
/*!40000 ALTER TABLE `tl_lapixl10_configuration` DISABLE KEYS */;
INSERT INTO `tl_lapixl10_configuration` VALUES (1,'LanguageCSV','en,es,fr,de,it,ru,ro,zh-cn,pt-br,sv,pl,th');
/*!40000 ALTER TABLE `tl_lapixl10_configuration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lapixl10_pixlr`
--
DROP TABLE IF EXISTS `tl_lapixl10_pixlr`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lapixl10_pixlr` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`reflect_on_activity` bit(1) default NULL,
`allow_view_others_images` bit(1) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`image_file_name` text,
`image_width` bigint(20) default NULL,
`image_height` bigint(20) default NULL,
`reflect_instructions` text,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lapixl10_pixlr`
--
LOCK TABLES `tl_lapixl10_pixlr` WRITE;
/*!40000 ALTER TABLE `tl_lapixl10_pixlr` DISABLE KEYS */;
INSERT INTO `tl_lapixl10_pixlr` VALUES (1,NULL,NULL,NULL,'Pixlr','Instructions',0x00,0x00,0x00,0x01,'','',0x00,0x00,21,'blank.jpg',400,450,NULL),(2,'2009-05-21 12:22:42','2009-05-14 20:34:59',5,'Pixlr','
\n
Pixlr Online Image Editor
\n
Pixlr is a powerful online flash-based image editor that can be included as a LAMS activity. The editor has powerful image creation and editing features, and the interface will be familiar to anyone who has used Paint, or more advanced editors like Photoshop or GIMP.
\n
\n
We thought it was so cool, we\'ve created a LAMS activity especially for it.
\n
\n\n
\n
You can edit the image below by clicking on "Edit Image in Pixlr"
\n
\n
\n
The Pixlr web application will load in a new window, and you can play with the image to your hearts content!
\n
\n
\n
Once you\'re finished, click File -> Save and Select Save Back to LAMS
\n
\n\n
\n
(Pixlr has some great online help, available here, which describes how to use all the drawing tools.)
Pixlr is a powerful online flash-based image editor that can be included as a LAMS activity. The editor has powerful image creation and editing features, and the interface will be familiar to anyone who has used Paint, or more advanced editors like Photoshop or GIMP.
\n
\n
We thought it was so cool, we\'ve created a LAMS activity especially for it.
\n
\n\n
\n
You can edit the image below by clicking on "Edit Image in Pixlr"
\n
\n
\n
The Pixlr web application will load in a new window, and you can play with the image to your hearts content!
\n
\n
\n
Once you\'re finished, click File -> Save and Select Save Back to LAMS
\n
\n\n
\n
(Pixlr has some great online help, available here, which describes how to use all the drawing tools.)
',0x00,0x00,0x00,0x00,'','',0x00,0x00,77,'2c94e451216218b80121621b5b1a000e.jpg',455,500,'');
/*!40000 ALTER TABLE `tl_lapixl10_pixlr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lapixl10_session`
--
DROP TABLE IF EXISTS `tl_lapixl10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lapixl10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`pixlr_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKE5C05E7FCB8ADA74` (`pixlr_uid`),
CONSTRAINT `FKE5C05E7FCB8ADA74` FOREIGN KEY (`pixlr_uid`) REFERENCES `tl_lapixl10_pixlr` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lapixl10_session`
--
LOCK TABLES `tl_lapixl10_session` WRITE;
/*!40000 ALTER TABLE `tl_lapixl10_session` DISABLE KEYS */;
INSERT INTO `tl_lapixl10_session` VALUES (1,NULL,NULL,NULL,4,'Everybody learners',3);
/*!40000 ALTER TABLE `tl_lapixl10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lapixl10_user`
--
DROP TABLE IF EXISTS `tl_lapixl10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lapixl10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`pixlr_session_uid` bigint(20) default NULL,
`entry_uid` bigint(20) default NULL,
`image_file_name` text,
`imageHeight` bigint(20) default NULL,
`imageWidth` bigint(20) default NULL,
`imageHidden` bit(1) default NULL,
PRIMARY KEY (`uid`),
KEY `FK9A39C08236E23005` (`pixlr_session_uid`),
CONSTRAINT `FK9A39C08236E23005` FOREIGN KEY (`pixlr_session_uid`) REFERENCES `tl_lapixl10_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lapixl10_user`
--
LOCK TABLES `tl_lapixl10_user` WRITE;
/*!40000 ALTER TABLE `tl_lapixl10_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lapixl10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_condition_questions`
--
DROP TABLE IF EXISTS `tl_laqa11_condition_questions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_condition_questions` (
`condition_id` bigint(20) NOT NULL default '0',
`question_uid` bigint(20) NOT NULL default '0',
PRIMARY KEY (`condition_id`,`question_uid`),
KEY `QaConditionQuestionToQaQuestion` (`question_uid`),
CONSTRAINT `QaConditionQuestionToQaCondition` FOREIGN KEY (`condition_id`) REFERENCES `tl_laqa11_conditions` (`condition_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `QaConditionQuestionToQaQuestion` FOREIGN KEY (`question_uid`) REFERENCES `tl_laqa11_que_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_condition_questions`
--
LOCK TABLES `tl_laqa11_condition_questions` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_condition_questions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laqa11_condition_questions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_conditions`
--
DROP TABLE IF EXISTS `tl_laqa11_conditions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_conditions` (
`condition_id` bigint(20) NOT NULL,
`content_uid` bigint(20) default NULL,
PRIMARY KEY (`condition_id`),
KEY `QaConditionToQaContent` (`content_uid`),
CONSTRAINT `QaConditionInheritance` FOREIGN KEY (`condition_id`) REFERENCES `lams_branch_condition` (`condition_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `QaConditionToQaContent` FOREIGN KEY (`content_uid`) REFERENCES `tl_laqa11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_conditions`
--
LOCK TABLES `tl_laqa11_conditions` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_conditions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laqa11_conditions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_configuration`
--
DROP TABLE IF EXISTS `tl_laqa11_configuration`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_configuration` (
`uid` bigint(20) NOT NULL auto_increment,
`config_key` varchar(30) default NULL,
`config_value` varchar(255) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `config_key` (`config_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_configuration`
--
LOCK TABLES `tl_laqa11_configuration` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_configuration` DISABLE KEYS */;
INSERT INTO `tl_laqa11_configuration` VALUES (1,'enableQaWizard','false');
/*!40000 ALTER TABLE `tl_laqa11_configuration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_content`
--
DROP TABLE IF EXISTS `tl_laqa11_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_content` (
`uid` bigint(20) NOT NULL auto_increment,
`qa_content_id` bigint(20) NOT NULL,
`title` text,
`instructions` text,
`creation_date` datetime default NULL,
`update_date` datetime default NULL,
`reflect` tinyint(1) NOT NULL default '0',
`questions_sequenced` tinyint(1) NOT NULL default '0',
`username_visible` tinyint(1) NOT NULL default '0',
`created_by` bigint(20) NOT NULL default '0',
`run_offline` tinyint(1) default '0',
`define_later` tinyint(1) NOT NULL default '0',
`synch_in_monitor` tinyint(1) NOT NULL default '0',
`offline_instructions` text,
`online_instructions` text,
`content_inUse` tinyint(1) default '0',
`reflectionSubject` text,
`lockWhenFinished` tinyint(1) NOT NULL default '1',
`showOtherAnswers` tinyint(1) NOT NULL default '1',
`allow_rich_editor` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_content`
--
LOCK TABLES `tl_laqa11_content` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_content` DISABLE KEYS */;
INSERT INTO `tl_laqa11_content` VALUES (1,3,'Q&A','Instructions','2009-05-21 17:32:58',NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,0,1,0),(2,44,'Question and Answer Demonstration','
This is the Q&A Activity
\n
\n
Up here is a space for Author instructions for Learners, and below is the list of Questions.
\n
\n
Have a crack at answering them, and then watch what happens over the following screens.
',NULL,'2008-11-14 14:30:09',0,0,0,5,0,0,0,'','',0,'',0,1,0),(3,98,'Question and Answer Demonstration','
This is the Q&A Activity
\n
\n
Up here is a space for Author instructions for Learners, and below is the list of Questions.
\n
\n
Have a crack at answering them, and then watch what happens over the following screens.
',NULL,'2008-11-14 14:30:09',0,0,0,5,0,0,0,'','',0,'',0,1,0);
/*!40000 ALTER TABLE `tl_laqa11_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_que_content`
--
DROP TABLE IF EXISTS `tl_laqa11_que_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_que_content` (
`uid` bigint(20) NOT NULL auto_increment,
`question` text,
`feedback` text,
`display_order` int(5) default '1',
`qa_content_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `qa_content_id` (`qa_content_id`),
CONSTRAINT `FK_tl_laqa11_que_content_1` FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_que_content`
--
LOCK TABLES `tl_laqa11_que_content` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_que_content` DISABLE KEYS */;
INSERT INTO `tl_laqa11_que_content` VALUES (1,'Sample Question 1?',NULL,1,1),(2,'
What do you like best so far about LAMS?
\n
\n
','This is the feedback section - it allows Authors and Monitors to give a short response to each question. This is incredibly useful for formative assessment and learning techniques.',1,2),(3,'
Do you think you can apply LAMS to your own teaching styles?
','',2,2),(4,'
What do you like best so far about LAMS?
\n
\n
','This is the feedback section - it allows Authors and Monitors to give a short response to each question. This is incredibly useful for formative assessment and learning techniques.',1,3),(5,'
Do you think you can apply LAMS to your own teaching styles?
','',2,3);
/*!40000 ALTER TABLE `tl_laqa11_que_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_que_usr`
--
DROP TABLE IF EXISTS `tl_laqa11_que_usr`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_que_usr` (
`uid` bigint(20) NOT NULL auto_increment,
`que_usr_id` bigint(20) NOT NULL,
`username` varchar(255) default NULL,
`responseFinalized` tinyint(1) NOT NULL default '0',
`qa_session_id` bigint(20) NOT NULL,
`fullname` varchar(255) default NULL,
`learnerFinished` tinyint(1) NOT NULL,
PRIMARY KEY (`uid`),
KEY `qa_session_id` (`qa_session_id`),
CONSTRAINT `FK_tl_laqa11_que_usr_1` FOREIGN KEY (`qa_session_id`) REFERENCES `tl_laqa11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_que_usr`
--
LOCK TABLES `tl_laqa11_que_usr` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_que_usr` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laqa11_que_usr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_session`
--
DROP TABLE IF EXISTS `tl_laqa11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`qa_session_id` bigint(20) NOT NULL,
`session_start_date` datetime default NULL,
`session_end_date` datetime default NULL,
`session_name` varchar(100) default NULL,
`session_status` varchar(100) default NULL,
`qa_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
KEY `qa_content_id` (`qa_content_id`),
CONSTRAINT `FK_tl_laqa11_session_1` FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_session`
--
LOCK TABLES `tl_laqa11_session` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_session` DISABLE KEYS */;
INSERT INTO `tl_laqa11_session` VALUES (1,21,'2009-05-21 17:39:13',NULL,'Everybody learners','INCOMPLETE',3);
/*!40000 ALTER TABLE `tl_laqa11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_uploadedfile`
--
DROP TABLE IF EXISTS `tl_laqa11_uploadedfile`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_uploadedfile` (
`submissionId` bigint(20) NOT NULL auto_increment,
`uuid` varchar(255) NOT NULL,
`isOnline_File` tinyint(1) NOT NULL,
`filename` varchar(255) NOT NULL,
`qa_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`submissionId`),
KEY `qa_content_id` (`qa_content_id`),
CONSTRAINT `FK_tl_laqa11_uploadedfile_1` FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_uploadedfile`
--
LOCK TABLES `tl_laqa11_uploadedfile` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_uploadedfile` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laqa11_uploadedfile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_usr_resp`
--
DROP TABLE IF EXISTS `tl_laqa11_usr_resp`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_usr_resp` (
`response_id` bigint(20) NOT NULL auto_increment,
`hidden` tinyint(1) default '0',
`answer` text,
`time_zone` varchar(255) default NULL,
`attempt_time` datetime default NULL,
`que_usr_id` bigint(20) NOT NULL,
`qa_que_content_id` bigint(20) NOT NULL,
`visible` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`response_id`),
KEY `que_usr_id` (`que_usr_id`),
KEY `qa_que_content_id` (`qa_que_content_id`),
CONSTRAINT `FK_tl_laqa11_usr_resp_3` FOREIGN KEY (`que_usr_id`) REFERENCES `tl_laqa11_que_usr` (`uid`),
CONSTRAINT `FK_tl_laqa11_usr_resp_2` FOREIGN KEY (`qa_que_content_id`) REFERENCES `tl_laqa11_que_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_usr_resp`
--
LOCK TABLES `tl_laqa11_usr_resp` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_usr_resp` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_laqa11_usr_resp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_wizard_category`
--
DROP TABLE IF EXISTS `tl_laqa11_wizard_category`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_wizard_category` (
`uid` bigint(20) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_wizard_category`
--
LOCK TABLES `tl_laqa11_wizard_category` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_wizard_category` DISABLE KEYS */;
INSERT INTO `tl_laqa11_wizard_category` VALUES (1,'Data%20Collection'),(2,'Data%20Organization'),(3,'Data%20Analysis'),(4,'Data%20Transcendence');
/*!40000 ALTER TABLE `tl_laqa11_wizard_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_wizard_cognitive_skill`
--
DROP TABLE IF EXISTS `tl_laqa11_wizard_cognitive_skill`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_wizard_cognitive_skill` (
`uid` bigint(20) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`category_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK3BA4132BCBB0DC8D` (`category_uid`),
CONSTRAINT `FK3BA4132BCBB0DC8D` FOREIGN KEY (`category_uid`) REFERENCES `tl_laqa11_wizard_category` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_wizard_cognitive_skill`
--
LOCK TABLES `tl_laqa11_wizard_cognitive_skill` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_wizard_cognitive_skill` DISABLE KEYS */;
INSERT INTO `tl_laqa11_wizard_cognitive_skill` VALUES (1,'2.%20Recognition',1),(2,'1.%20Observation',1),(3,'3.%20Recall',1),(4,'Ordering',2),(5,'Comparison',2),(6,'Hierarchy',2),(7,'Classification',2),(8,'Distinction%20between%20facts%20%26%20opinions/judgments',3),(9,'Analysis%20of%20basic%20parts',3),(10,'Clarification',3),(11,'Flush%20out%20relationships',3),(12,'Pattern%20recognition',3),(13,'Error%20and%20conflict%20detection',4),(14,'Summary',4),(15,'Reflection',4),(16,'Hypothesis',4),(17,'Prediction',4),(18,'Explanation',4),(19,'Empathy',4),(20,'Knowledge%20Organization',4),(21,'Application%20and%20Improvement',4),(22,'Assessment/Evaluation',4),(23,'Verification',4),(24,'Conclusion',4);
/*!40000 ALTER TABLE `tl_laqa11_wizard_cognitive_skill` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_laqa11_wizard_question`
--
DROP TABLE IF EXISTS `tl_laqa11_wizard_question`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_laqa11_wizard_question` (
`uid` bigint(20) NOT NULL auto_increment,
`cognitive_skill_uid` bigint(20) default NULL,
`title` text NOT NULL,
PRIMARY KEY (`uid`),
KEY `FKAF08A0C7EFF77FD4` (`cognitive_skill_uid`),
CONSTRAINT `FKAF08A0C7EFF77FD4` FOREIGN KEY (`cognitive_skill_uid`) REFERENCES `tl_laqa11_wizard_cognitive_skill` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_laqa11_wizard_question`
--
LOCK TABLES `tl_laqa11_wizard_question` WRITE;
/*!40000 ALTER TABLE `tl_laqa11_wizard_question` DISABLE KEYS */;
INSERT INTO `tl_laqa11_wizard_question` VALUES (1,1,'Please%20identify%u2026'),(2,2,'What%20do%20you%20observe%20...'),(3,2,'What%20do%20you%20see%u2026%3F'),(4,3,'Give%20the%20definition%20of%u2026'),(5,3,'What%20is%20the%20meaning%20of%u2026%3F'),(6,3,'What%20has%20been%20said%20by%u2026%20about%u2026%3F'),(7,4,'Find%20a%20criterion%20to%20order%20these%u2026'),(8,4,'Order%20these%u2026'),(9,4,'Find%20the%205%20biggest/smallest%20%u2026'),(10,5,'Compare%20these%u2026%20using%20the%20following%20criteria%u2026'),(11,5,'Find%20the%20pros%20and%20cons%20of%u2026'),(12,5,'Find%20both%20the%20similarities%20and%20the%20differences%20between..%20and%u2026'),(13,6,'Arrange%20these%u2026by%20the%20following%20criterion%u2026'),(14,6,'Sort%20these%u2026%20by%20the%20following%20criterion%u2026'),(15,6,'Put%20these%u2026in%20an%20ascending/descending%20sequence%u2026'),(16,7,'Group%20these%20elements%20using%20the%20following%20criteria%u2026'),(17,7,'Find%20the%20pros%20and%20cons%20of%20these%u2026solutions'),(18,7,'Find%205%20%20advantages%20and%203%20disadvantages%20%20of%20%u2026'),(19,8,'Clarify%20whether%20this%20%u2026describes%20a%20fact%20or%20if%20it%20is%20a%20personal%20opinion'),(20,8,'Provide%20more%20than%20one%20view%20about%20the%20following%u2026'),(21,8,'Provide%20logical%20arguments%20to%20support%20the%20following%20statement'),(22,9,'Identify%20the%20parts/units/characteristics%20of%u2026'),(23,9,'Define%20the%20data%20given%20and%20the%20objectives%20of%u2026.'),(24,9,'Refer%20to%20the%20appropriate%20phases%20of%20the%20solution%20plan%20for%u2026'),(25,10,'What%20do%20we%20mean%20by%u2026%3F'),(26,10,'Provide%20an%20example%20to%20clarify%u2026'),(27,10,'When%20does%20this%u2026have%20a%20meaning%u2026%3F'),(28,11,'Distinguish%20possible%20relationships%20among%20the%20data%u2026'),(29,11,'Is%20there%20any%20reason%20that%20affects%20this%20phenomenon%u2026%3F'),(30,11,'Is%20there%20any%20structure%20within%u2026%3F'),(31,12,'Is%20there%20any%20pattern%20that%20is%20repeated%20in%u2026%3F'),(32,12,'Find%20out%20what%20is%20common%20in%u2026'),(33,12,'Find%20out%20what%20is%20similar%20in%u2026'),(34,13,'Point%20out%20the%20mistakes%20of/in%u2026'),(35,13,'Are%20there%20any%20contradictions%20in%u2026%3F'),(36,13,'What%20is%20missing%20in%u2026%3F'),(37,14,'Form%20an%20abstract%20of%20%u2026%28number%29%20words%20to%20describe%u2026'),(38,14,'Which%20are%20the%20main%20points%20of%20%u2026'),(39,14,'Which%20are%20the%20top%205%20essential%20points%20of%20%u2026'),(40,15,'What%20have%20you%20learnt%20about%u2026%3F'),(41,15,'Are%20there%20any%20points%20that%20you%u2026%3F'),(42,16,'If%20%u2026%20then%u2026'),(43,17,'Could%20you%20make%20any%20predictions%20about%u2026%3F'),(44,17,'If%20we%20do%u2026then%20what%20will%20happen%3F'),(45,17,'In%20the%20case%20of%u2026find%20out%u2026'),(46,18,'Please%20explain%20how%20the%20meaning%20of%u2026'),(47,18,'Please%20explain%20why%20the%20meaning%20of/%u2026'),(48,18,'Please%20explain%20what%20the%20meaning%20of%20%u2026'),(49,18,'Please%20explain%20in%20your%20own%20words%u2026'),(50,18,'Please%20explain%20in%20your%20own%20words%u2026'),(51,19,'Could%20you%20accept%20the%20role%20of%u2026%3F'),(52,19,'What%20are%20the%20possible%20arguments%20of%20others%20for%u2026%3F'),(53,19,'What%20would%20be%20your%20answer%20if%20you%20were%20in%20the%20position%20of%u2026%3F'),(54,20,'Make%20a%20hierarchical%20tree%20to%20describe%u2026'),(55,20,'Can%20you%20form%20a%20sequential%20structure%20of%u2026%3F'),(56,20,'Characterize%20it%20according%20to%20the%20following%20criteria%u2026'),(57,21,'How%20can%20you%20improve%20this%u2026in%20order%20to%u2026%3F'),(58,21,'How%20can%20you%20apply%20this%u2026in%20order%20to%u2026%3F'),(59,22,'Assess%20this%u2026'),(60,22,'Evaluate%20the%u2026'),(61,22,'What%20kind%20of%20criteria%20can%20you%20use%20to%20evaluate%20the%u2026%3F'),(62,23,'Please%20verify%20that%u2026'),(63,23,'Please%20confirm%20that%u2026'),(64,24,'Based%20on%20this%u2026what%20do%20you%20conclude%3F'),(65,24,'Based%20on%20these%u2026what%20do%20you%20conclude%3F'),(66,24,'Are%20there%20any%20exceptions%20to%u2026%3F'),(67,24,'Are%20there%20any%20weak%20points%20in%u2026%3F');
/*!40000 ALTER TABLE `tl_laqa11_wizard_question` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_larsrc11_attachment`
--
DROP TABLE IF EXISTS `tl_larsrc11_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_larsrc11_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`resource_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK1E7009430E79035` (`resource_uid`),
CONSTRAINT `FK1E7009430E79035` FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_larsrc11_attachment`
--
LOCK TABLES `tl_larsrc11_attachment` WRITE;
/*!40000 ALTER TABLE `tl_larsrc11_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_larsrc11_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_larsrc11_item_instruction`
--
DROP TABLE IF EXISTS `tl_larsrc11_item_instruction`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_larsrc11_item_instruction` (
`uid` bigint(20) NOT NULL auto_increment,
`description` varchar(255) default NULL,
`sequence_id` int(11) default NULL,
`item_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKA5665013980570ED` (`item_uid`),
CONSTRAINT `FKA5665013980570ED` FOREIGN KEY (`item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_larsrc11_item_instruction`
--
LOCK TABLES `tl_larsrc11_item_instruction` WRITE;
/*!40000 ALTER TABLE `tl_larsrc11_item_instruction` DISABLE KEYS */;
INSERT INTO `tl_larsrc11_item_instruction` VALUES (1,'Use Google to search the web',0,1),(2,'In this animation, you will learn how to use the features of the Noticeboard Activity.',0,2),(3,'This animation explains how to create and use a Resource Sharing activity.',0,3),(4,'This is our online documentation website. Here you can find the specifications for what kind of files can be added to a Resource Sharing activity.',0,4),(5,'This animation describes the basics of the Monitoring environment.',0,8),(6,'You will need an active internet connection to view this web page.',0,9),(7,'You might need to resize your browser to see the whole animation.',0,10),(8,'When the animation has completed, click Finished to move to the next activity.',1,10),(9,'When the animation has stopped, click Finished to go to the next activity. ',1,11),(10,'This animation will demonstrate the Learner\'s Experience when using LAMS. You might need to resize your browser to see the whole animation.',0,11),(11,'When the animation has stopped, click ',1,12),(12,'LAMS 2.1 lets you disable FLASH for the Learning Environment - this is useful if you want to use LAMS on devices that do not support flash.',0,12),(13,'You might need to resize your internet browser to see the whole animation.',0,13),(14,'When the animation is complete, click Finished to go to the next activity.',1,13),(15,'When the animation has stopped, click Finished to go to the next activity.',1,14),(16,'This animation gives a brief overview of LAMS.',0,14),(17,'This animation explains how to create and use a Resource Sharing activity.',0,15),(18,'This is our online documentation website. Here you can find the specifications for what kind of files can be added to a Resource Sharing activity.',0,16),(19,'In this animation, you will learn how to use the features of the Noticeboard Activity.',0,17),(20,'You will need an active internet connection to view this web page.',0,21),(21,'This animation describes the basics of the Monitoring environment.',0,22),(22,'When the animation has stopped, click ',1,23),(23,'LAMS 2.1 lets you disable FLASH for the Learning Environment - this is useful if you want to use LAMS on devices that do not support flash.',0,23),(24,'This animation will demonstrate the Learner\'s Experience when using LAMS. You might need to resize your browser to see the whole animation.',0,24),(25,'When the animation has stopped, click Finished to go to the next activity. ',1,24),(26,'You might need to resize your browser to see the whole animation.',0,25),(27,'When the animation has completed, click Finished to move to the next activity.',1,25),(28,'When the animation is complete, click Finished to go to the next activity.',1,26),(29,'You might need to resize your internet browser to see the whole animation.',0,26),(30,'When the animation has stopped, click Finished to go to the next activity.',1,27),(31,'This animation gives a brief overview of LAMS.',0,27);
/*!40000 ALTER TABLE `tl_larsrc11_item_instruction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_larsrc11_item_log`
--
DROP TABLE IF EXISTS `tl_larsrc11_item_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_larsrc11_item_log` (
`uid` bigint(20) NOT NULL auto_increment,
`access_date` datetime default NULL,
`resource_item_uid` bigint(20) default NULL,
`user_uid` bigint(20) default NULL,
`complete` tinyint(4) default NULL,
`session_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK693580A438BF8DFE` (`resource_item_uid`),
KEY `FK693580A441F9365D` (`user_uid`),
CONSTRAINT `FK693580A441F9365D` FOREIGN KEY (`user_uid`) REFERENCES `tl_larsrc11_user` (`uid`),
CONSTRAINT `FK693580A438BF8DFE` FOREIGN KEY (`resource_item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_larsrc11_item_log`
--
LOCK TABLES `tl_larsrc11_item_log` WRITE;
/*!40000 ALTER TABLE `tl_larsrc11_item_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_larsrc11_item_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_larsrc11_resource`
--
DROP TABLE IF EXISTS `tl_larsrc11_resource`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_larsrc11_resource` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`run_offline` tinyint(4) default NULL,
`lock_on_finished` tinyint(4) default NULL,
`instructions` text,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` tinyint(4) default NULL,
`define_later` tinyint(4) default NULL,
`content_id` bigint(20) default NULL,
`allow_add_files` tinyint(4) default NULL,
`allow_add_urls` tinyint(4) default NULL,
`mini_view_resource_number` int(11) default NULL,
`allow_auto_run` tinyint(4) default NULL,
`reflect_instructions` varchar(255) default NULL,
`reflect_on_activity` smallint(6) default NULL,
`assigment_submit_notify` tinyint(4) default '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `content_id` (`content_id`),
KEY `FK89093BF758092FB` (`create_by`),
CONSTRAINT `FK89093BF758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_larsrc11_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_larsrc11_resource`
--
LOCK TABLES `tl_larsrc11_resource` WRITE;
/*!40000 ALTER TABLE `tl_larsrc11_resource` DISABLE KEYS */;
INSERT INTO `tl_larsrc11_resource` VALUES (1,NULL,NULL,NULL,'Resources',0,0,'Instructions ',NULL,NULL,0,0,6,0,0,0,0,NULL,0,0),(2,NULL,'2008-04-11 15:35:40',1,'Resource Sharing',0,0,'
This is a Resource Sharing Activity.
\n
You can see that the list below contains a URL, and several Zipped Websites.
\n
\n
Explore the resources below, and then try adding your own URL to the list - \nsimply fill in the fields below, marked "Suggest a new URL" \nand then click the Add button.
\n
','','',0,0,34,0,1,0,0,'',0,0),(3,'2008-04-11 16:01:40','2008-04-11 16:01:40',2,'Resources on LAMS',0,0,'
You can see that the list below contains a URL, and several Zipped Websites.
\n
\n
Explore the resources below, and then try adding your own URL to the list - \nsimply fill in the fields below, marked "Suggest a new URL" \nand then click the Add button.
\n
','','',0,0,81,0,1,0,0,'',0,0),(12,'2008-04-11 16:01:40','2008-04-11 16:01:40',11,'Resources on LAMS',0,0,'
Again, LAMS provides a space for Authors to write Instructions for Learners:
\n
\n\n
\n
Use this activity to submit your essay for Marking.
\n
\n
Please remember that your attachments should be Word Documents (.doc), Adobe Documents (.pdf), or Text Files (.txt) so that I can read them on my computer. \n
\n\n
\n
You have the option of uploading a file here if you would like - have a play with the activity and see what you can do.
Again, LAMS provides a space for Authors to write Instructions for Learners:
\n
\n\n
\n
Use this activity to submit your essay for Marking.
\n
\n
Please remember that your attachments should be Word Documents (.doc), Adobe Documents (.pdf), or Text Files (.txt) so that I can read them on my computer. \n
\n\n
\n
You have the option of uploading a file here if you would like - have a play with the activity and see what you can do.
\n
\n\n
',0,0,'','',0,0,'',0,0,0,'2009-05-21 17:38:09',1,'2009-05-21 17:38:09',0,0);
/*!40000 ALTER TABLE `tl_lasbmt11_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasbmt11_instruction_files`
--
DROP TABLE IF EXISTS `tl_lasbmt11_instruction_files`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasbmt11_instruction_files` (
`uid` bigint(20) NOT NULL auto_increment,
`uuid` bigint(20) default NULL,
`version_id` bigint(20) default NULL,
`type` varchar(20) default NULL,
`name` varchar(255) default NULL,
`content_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKA75538F9785A173A` (`content_id`),
CONSTRAINT `FKA75538F9785A173A` FOREIGN KEY (`content_id`) REFERENCES `tl_lasbmt11_content` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasbmt11_instruction_files`
--
LOCK TABLES `tl_lasbmt11_instruction_files` WRITE;
/*!40000 ALTER TABLE `tl_lasbmt11_instruction_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lasbmt11_instruction_files` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasbmt11_report`
--
DROP TABLE IF EXISTS `tl_lasbmt11_report`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasbmt11_report` (
`report_id` bigint(20) NOT NULL auto_increment,
`comments` varchar(250) default NULL,
`marks` float default NULL,
`date_marks_released` datetime default NULL,
PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasbmt11_report`
--
LOCK TABLES `tl_lasbmt11_report` WRITE;
/*!40000 ALTER TABLE `tl_lasbmt11_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lasbmt11_report` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasbmt11_session`
--
DROP TABLE IF EXISTS `tl_lasbmt11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasbmt11_session` (
`session_id` bigint(20) NOT NULL,
`status` int(11) NOT NULL,
`content_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
PRIMARY KEY (`session_id`),
KEY `FKEC8C77C9785A173A` (`content_id`),
CONSTRAINT `FKEC8C77C9785A173A` FOREIGN KEY (`content_id`) REFERENCES `tl_lasbmt11_content` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasbmt11_session`
--
LOCK TABLES `tl_lasbmt11_session` WRITE;
/*!40000 ALTER TABLE `tl_lasbmt11_session` DISABLE KEYS */;
INSERT INTO `tl_lasbmt11_session` VALUES (25,0,93,'Everybody learners');
/*!40000 ALTER TABLE `tl_lasbmt11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasbmt11_submission_details`
--
DROP TABLE IF EXISTS `tl_lasbmt11_submission_details`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasbmt11_submission_details` (
`submission_id` bigint(20) NOT NULL auto_increment,
`filePath` varchar(250) default NULL,
`fileDescription` varchar(250) default NULL,
`date_of_submission` datetime default NULL,
`uuid` bigint(20) default NULL,
`version_id` bigint(20) default NULL,
`session_id` bigint(20) default NULL,
`learner_id` bigint(20) default NULL,
PRIMARY KEY (`submission_id`),
KEY `FK1411A53CFFD5A38B` (`learner_id`),
KEY `FK1411A53C93C861A` (`session_id`),
CONSTRAINT `FK1411A53C93C861A` FOREIGN KEY (`session_id`) REFERENCES `tl_lasbmt11_session` (`session_id`),
CONSTRAINT `FK1411A53CFFD5A38B` FOREIGN KEY (`learner_id`) REFERENCES `tl_lasbmt11_user` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasbmt11_submission_details`
--
LOCK TABLES `tl_lasbmt11_submission_details` WRITE;
/*!40000 ALTER TABLE `tl_lasbmt11_submission_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lasbmt11_submission_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasbmt11_user`
--
DROP TABLE IF EXISTS `tl_lasbmt11_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasbmt11_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` int(11) default NULL,
`finished` bit(1) default NULL,
`session_id` bigint(20) default NULL,
`first_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`last_name` varchar(255) default NULL,
`content_id` bigint(20) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasbmt11_user`
--
LOCK TABLES `tl_lasbmt11_user` WRITE;
/*!40000 ALTER TABLE `tl_lasbmt11_user` DISABLE KEYS */;
INSERT INTO `tl_lasbmt11_user` VALUES (1,5,0x00,NULL,'One','test1','Test',47);
/*!40000 ALTER TABLE `tl_lasbmt11_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_attachment`
--
DROP TABLE IF EXISTS `tl_lascrb11_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`scribe_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK57953706B3FA1495` (`scribe_uid`),
CONSTRAINT `FK57953706B3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_attachment`
--
LOCK TABLES `tl_lascrb11_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lascrb11_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_heading`
--
DROP TABLE IF EXISTS `tl_lascrb11_heading`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_heading` (
`uid` bigint(20) NOT NULL auto_increment,
`heading` text,
`scribe_uid` bigint(20) default NULL,
`display_order` int(11) default NULL,
PRIMARY KEY (`uid`),
KEY `FK428A22FFB3FA1495` (`scribe_uid`),
CONSTRAINT `FK428A22FFB3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_heading`
--
LOCK TABLES `tl_lascrb11_heading` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_heading` DISABLE KEYS */;
INSERT INTO `tl_lascrb11_heading` VALUES (1,'Scribe Heading',1,0);
/*!40000 ALTER TABLE `tl_lascrb11_heading` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_report_entry`
--
DROP TABLE IF EXISTS `tl_lascrb11_report_entry`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_report_entry` (
`uid` bigint(20) NOT NULL auto_increment,
`entry_text` text,
`scribe_heading_uid` bigint(20) default NULL,
`scribe_session_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK5439FACAEA50D086` (`scribe_heading_uid`),
KEY `FK5439FACA1C266FAE` (`scribe_session_uid`),
CONSTRAINT `FK5439FACA1C266FAE` FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`),
CONSTRAINT `FK5439FACAEA50D086` FOREIGN KEY (`scribe_heading_uid`) REFERENCES `tl_lascrb11_heading` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_report_entry`
--
LOCK TABLES `tl_lascrb11_report_entry` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_report_entry` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lascrb11_report_entry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_scribe`
--
DROP TABLE IF EXISTS `tl_lascrb11_scribe`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_scribe` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`auto_select_scribe` bit(1) default NULL,
`reflect_on_activity` bit(1) default NULL,
`reflect_instructions` text,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`aggregated_reports` bit(1) default '\0',
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_scribe`
--
LOCK TABLES `tl_lascrb11_scribe` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_scribe` DISABLE KEYS */;
INSERT INTO `tl_lascrb11_scribe` VALUES (1,NULL,NULL,NULL,'Scribe','Instructions',0x00,0x01,0x01,0x00,NULL,'','',0x00,0x00,10,0x00);
/*!40000 ALTER TABLE `tl_lascrb11_scribe` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_session`
--
DROP TABLE IF EXISTS `tl_lascrb11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`version` int(11) NOT NULL,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`scribe_uid` bigint(20) default NULL,
`appointed_scribe_uid` bigint(20) default NULL,
`force_complete` bit(1) default NULL,
`report_submitted` bit(1) default NULL,
PRIMARY KEY (`uid`),
KEY `FK89732793B3FA1495` (`scribe_uid`),
KEY `FK89732793E46919FF` (`appointed_scribe_uid`),
CONSTRAINT `FK89732793E46919FF` FOREIGN KEY (`appointed_scribe_uid`) REFERENCES `tl_lascrb11_user` (`uid`),
CONSTRAINT `FK89732793B3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_session`
--
LOCK TABLES `tl_lascrb11_session` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lascrb11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lascrb11_user`
--
DROP TABLE IF EXISTS `tl_lascrb11_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lascrb11_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`scribe_session_uid` bigint(20) default NULL,
`report_approved` bit(1) default NULL,
`started_activity` bit(1) default NULL,
PRIMARY KEY (`uid`),
KEY `FK187DAFEE1C266FAE` (`scribe_session_uid`),
CONSTRAINT `FK187DAFEE1C266FAE` FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lascrb11_user`
--
LOCK TABLES `tl_lascrb11_user` WRITE;
/*!40000 ALTER TABLE `tl_lascrb11_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lascrb11_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasprd10_attachment`
--
DROP TABLE IF EXISTS `tl_lasprd10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasprd10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`spreadsheet_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_2065267438_1E7009430E79035` (`spreadsheet_uid`),
CONSTRAINT `FK_NEW_2065267438_1E7009430E79035` FOREIGN KEY (`spreadsheet_uid`) REFERENCES `tl_lasprd10_spreadsheet` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasprd10_attachment`
--
LOCK TABLES `tl_lasprd10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lasprd10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lasprd10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasprd10_session`
--
DROP TABLE IF EXISTS `tl_lasprd10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasprd10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`spreadsheet_uid` bigint(20) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_2065267438_24AA78C530E79035` (`spreadsheet_uid`),
CONSTRAINT `FK_NEW_2065267438_24AA78C530E79035` FOREIGN KEY (`spreadsheet_uid`) REFERENCES `tl_lasprd10_spreadsheet` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasprd10_session`
--
LOCK TABLES `tl_lasprd10_session` WRITE;
/*!40000 ALTER TABLE `tl_lasprd10_session` DISABLE KEYS */;
INSERT INTO `tl_lasprd10_session` VALUES (1,NULL,NULL,0,3,11,'Everybody learners');
/*!40000 ALTER TABLE `tl_lasprd10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasprd10_spreadsheet`
--
DROP TABLE IF EXISTS `tl_lasprd10_spreadsheet`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasprd10_spreadsheet` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`run_offline` tinyint(4) default NULL,
`is_learner_allowed_to_save` tinyint(4) default NULL,
`is_marking_enabled` tinyint(4) default NULL,
`lock_on_finished` tinyint(4) default NULL,
`instructions` text,
`code` text,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` tinyint(4) default NULL,
`define_later` tinyint(4) default NULL,
`content_id` bigint(20) default NULL,
`reflect_instructions` varchar(255) default NULL,
`reflect_on_activity` smallint(6) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `content_id` (`content_id`),
KEY `FK_NEW_2065267438_89093BF758092FB` (`create_by`),
CONSTRAINT `FK_NEW_2065267438_89093BF758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_lasprd10_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasprd10_spreadsheet`
--
LOCK TABLES `tl_lasprd10_spreadsheet` WRITE;
/*!40000 ALTER TABLE `tl_lasprd10_spreadsheet` DISABLE KEYS */;
INSERT INTO `tl_lasprd10_spreadsheet` VALUES (1,NULL,NULL,NULL,'Spreadsheet',0,1,0,0,'Instructions ','',NULL,NULL,0,0,13,NULL,0),(2,NULL,'2008-11-14 14:29:02',1,'Spreadsheet Demonstration',0,1,0,0,'
\n
Spreadsheet
\n
New to LAMS 2.2!
\n
\n
The Spreadsheet Activity allows a sequence author to provide data in a spreadsheet format to Learners. \nLearners can then perform their own calculations on and manipulations of the data.
\n
By default, the Spreadsheet tool allows each learner to save their own individual copy of the spreadsheet. The activity can be configured to allow Monitors to mark each Learners spreadsheet.
\n
Spreadsheet Functions
\n
The Spreadsheet can be viewed in one of several modes. These are changed by clicking the labels in the top-right corner of the applet.
\n
\n
Values: shows all the calculated values on the screen (default mode)\n
The Spreadsheet Activity allows a sequence author to provide data in a spreadsheet format to Learners. \nLearners can then perform their own calculations on and manipulations of the data.
\n
By default, the Spreadsheet tool allows each learner to save their own individual copy of the spreadsheet. The activity can be configured to allow Monitors to mark each Learners spreadsheet.
\n
Spreadsheet Functions
\n
The Spreadsheet can be viewed in one of several modes. These are changed by clicking the labels in the top-right corner of the applet.
\n
\n
Values: shows all the calculated values on the screen (default mode)\n
Like all activities, this is the space for Learner Instructions.
\n
\n
\n
\n
\n
Below, you’ll see several different types of Survey questions:
\n
\n
Single Response Multiple Choice
\n
Multiple Choice Multiple Choice
\n
Free Text Questions
\n
\n
','','',0,0,95,'',0,1,NULL,'2008-04-18 15:51:31',2,0);
/*!40000 ALTER TABLE `tl_lasurv11_survey` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lasurv11_user`
--
DROP TABLE IF EXISTS `tl_lasurv11_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lasurv11_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`session_uid` bigint(20) default NULL,
`survey_uid` bigint(20) default NULL,
`session_finished` smallint(6) default NULL,
PRIMARY KEY (`uid`),
KEY `FK633F25884F803F63` (`session_uid`),
KEY `FK633F2588D14146E5` (`survey_uid`),
CONSTRAINT `FK633F2588D14146E5` FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`),
CONSTRAINT `FK633F25884F803F63` FOREIGN KEY (`session_uid`) REFERENCES `tl_lasurv11_session` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lasurv11_user`
--
LOCK TABLES `tl_lasurv11_user` WRITE;
/*!40000 ALTER TABLE `tl_lasurv11_user` DISABLE KEYS */;
INSERT INTO `tl_lasurv11_user` VALUES (1,5,'Test','One','test1',NULL,2,0),(2,5,'Test','One','test1',NULL,3,0);
/*!40000 ALTER TABLE `tl_lasurv11_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_attachment`
--
DROP TABLE IF EXISTS `tl_latask10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`taskList_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_174079138_1E7009430E79035` (`taskList_uid`),
CONSTRAINT `FK_NEW_174079138_1E7009430E79035` FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_taskList` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_attachment`
--
LOCK TABLES `tl_latask10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_latask10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_condition`
--
DROP TABLE IF EXISTS `tl_latask10_condition`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_condition` (
`condition_uid` bigint(20) NOT NULL auto_increment,
`sequence_id` int(11) default NULL,
`taskList_uid` bigint(20) default NULL,
`name` varchar(255) default NULL,
PRIMARY KEY (`condition_uid`),
KEY `FK_tl_latask10_condition_1` (`taskList_uid`),
CONSTRAINT `FK_tl_latask10_condition_1` FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_taskList` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_condition`
--
LOCK TABLES `tl_latask10_condition` WRITE;
/*!40000 ALTER TABLE `tl_latask10_condition` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_condition` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_condition_tl_item`
--
DROP TABLE IF EXISTS `tl_latask10_condition_tl_item`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_condition_tl_item` (
`uid` bigint(20) NOT NULL,
`condition_uid` bigint(20) NOT NULL,
PRIMARY KEY (`uid`,`condition_uid`),
KEY `FK_tl_latask10_taskList_item_condition_1` (`condition_uid`),
KEY `FK_tl_latask10_taskList_item_condition_2` (`uid`),
CONSTRAINT `FK_tl_latask10_taskList_item_condition_2` FOREIGN KEY (`uid`) REFERENCES `tl_latask10_taskList_item` (`uid`),
CONSTRAINT `FK_tl_latask10_taskList_item_condition_1` FOREIGN KEY (`condition_uid`) REFERENCES `tl_latask10_condition` (`condition_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_condition_tl_item`
--
LOCK TABLES `tl_latask10_condition_tl_item` WRITE;
/*!40000 ALTER TABLE `tl_latask10_condition_tl_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_condition_tl_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_item_attachment`
--
DROP TABLE IF EXISTS `tl_latask10_item_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_item_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`taskList_item_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_tl_latask10_item_attachment_1` (`taskList_item_uid`),
KEY `FK_tl_latask10_item_attachment_2` (`create_by`),
CONSTRAINT `FK_tl_latask10_item_attachment_2` FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`),
CONSTRAINT `FK_tl_latask10_item_attachment_1` FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_taskList_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_item_attachment`
--
LOCK TABLES `tl_latask10_item_attachment` WRITE;
/*!40000 ALTER TABLE `tl_latask10_item_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_item_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_item_comment`
--
DROP TABLE IF EXISTS `tl_latask10_item_comment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_item_comment` (
`uid` bigint(20) NOT NULL auto_increment,
`comment` text,
`taskList_item_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
`create_date` datetime default NULL,
PRIMARY KEY (`uid`),
KEY `FK_tl_latask10_item_comment_3` (`taskList_item_uid`),
KEY `FK_tl_latask10_item_comment_2` (`create_by`),
CONSTRAINT `FK_tl_latask10_item_comment_2` FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`),
CONSTRAINT `FK_tl_latask10_item_comment_3` FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_taskList_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_item_comment`
--
LOCK TABLES `tl_latask10_item_comment` WRITE;
/*!40000 ALTER TABLE `tl_latask10_item_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_item_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_item_log`
--
DROP TABLE IF EXISTS `tl_latask10_item_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_item_log` (
`uid` bigint(20) NOT NULL auto_increment,
`access_date` datetime default NULL,
`taskList_item_uid` bigint(20) default NULL,
`user_uid` bigint(20) default NULL,
`complete` tinyint(4) default NULL,
`session_id` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_174079138_693580A438BF8DFE` (`taskList_item_uid`),
KEY `FK_NEW_174079138_693580A441F9365D` (`user_uid`),
CONSTRAINT `FK_NEW_174079138_693580A441F9365D` FOREIGN KEY (`user_uid`) REFERENCES `tl_latask10_user` (`uid`),
CONSTRAINT `FK_NEW_174079138_693580A438BF8DFE` FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_taskList_item` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_item_log`
--
LOCK TABLES `tl_latask10_item_log` WRITE;
/*!40000 ALTER TABLE `tl_latask10_item_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_item_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_session`
--
DROP TABLE IF EXISTS `tl_latask10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`taskList_uid` bigint(20) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_174079138_24AA78C530E79035` (`taskList_uid`),
CONSTRAINT `FK_NEW_174079138_24AA78C530E79035` FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_taskList` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_session`
--
LOCK TABLES `tl_latask10_session` WRITE;
/*!40000 ALTER TABLE `tl_latask10_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_taskList`
--
DROP TABLE IF EXISTS `tl_latask10_taskList`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_taskList` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`run_offline` tinyint(4) default NULL,
`instructions` text,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` tinyint(4) default NULL,
`define_later` tinyint(4) default NULL,
`content_id` bigint(20) default NULL,
`lock_when_finished` tinyint(4) default NULL,
`is_sequential_order` tinyint(4) default NULL,
`minimum_number_tasks` int(11) default NULL,
`allow_contribute_tasks` tinyint(4) default NULL,
`is_monitor_verification_required` tinyint(4) default NULL,
`reflect_instructions` varchar(255) default NULL,
`reflect_on_activity` smallint(6) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `content_id` (`content_id`),
KEY `FK_NEW_174079138_89093BF758092FB` (`create_by`),
CONSTRAINT `FK_NEW_174079138_89093BF758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_taskList`
--
LOCK TABLES `tl_latask10_taskList` WRITE;
/*!40000 ALTER TABLE `tl_latask10_taskList` DISABLE KEYS */;
INSERT INTO `tl_latask10_taskList` VALUES (1,NULL,NULL,NULL,'Task List',0,'Instructions ',NULL,NULL,0,0,11,0,0,0,0,0,NULL,0);
/*!40000 ALTER TABLE `tl_latask10_taskList` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_taskList_item`
--
DROP TABLE IF EXISTS `tl_latask10_taskList_item`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_taskList_item` (
`uid` bigint(20) NOT NULL auto_increment,
`sequence_id` int(11) default NULL,
`description` text,
`init_item` varchar(255) default NULL,
`organization_xml` text,
`title` varchar(255) default NULL,
`create_by` bigint(20) default NULL,
`create_date` datetime default NULL,
`create_by_author` tinyint(4) default NULL,
`is_required` tinyint(4) default NULL,
`is_comments_allowed` tinyint(4) default NULL,
`is_comments_required` tinyint(4) default NULL,
`is_files_allowed` tinyint(4) default NULL,
`is_files_required` tinyint(4) default NULL,
`is_comments_files_allowed` tinyint(4) default NULL,
`show_comments_to_all` tinyint(4) default NULL,
`is_child_task` tinyint(4) default NULL,
`parent_task_name` varchar(255) default NULL,
`taskList_uid` bigint(20) default NULL,
`session_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_174079138_F52D1F93758092FB` (`create_by`),
KEY `FK_NEW_174079138_F52D1F9330E79035` (`taskList_uid`),
KEY `FK_NEW_174079138_F52D1F93EC0D3147` (`session_uid`),
CONSTRAINT `FK_NEW_174079138_F52D1F93EC0D3147` FOREIGN KEY (`session_uid`) REFERENCES `tl_latask10_session` (`uid`),
CONSTRAINT `FK_NEW_174079138_F52D1F9330E79035` FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_taskList` (`uid`),
CONSTRAINT `FK_NEW_174079138_F52D1F93758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_taskList_item`
--
LOCK TABLES `tl_latask10_taskList_item` WRITE;
/*!40000 ALTER TABLE `tl_latask10_taskList_item` DISABLE KEYS */;
INSERT INTO `tl_latask10_taskList_item` VALUES (1,1,NULL,NULL,NULL,'Task number 1',NULL,'2009-05-21 17:33:47',1,0,0,0,0,0,0,1,0,NULL,1,NULL);
/*!40000 ALTER TABLE `tl_latask10_taskList_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_latask10_user`
--
DROP TABLE IF EXISTS `tl_latask10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_latask10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`session_finished` smallint(6) default NULL,
`session_uid` bigint(20) default NULL,
`taskList_uid` bigint(20) default NULL,
`is_verified_by_monitor` tinyint(4) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_174079138_30113BFCEC0D3147` (`session_uid`),
KEY `FK_NEW_174079138_30113BFC309ED320` (`taskList_uid`),
CONSTRAINT `FK_NEW_174079138_30113BFC309ED320` FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_taskList` (`uid`),
CONSTRAINT `FK_NEW_174079138_30113BFCEC0D3147` FOREIGN KEY (`session_uid`) REFERENCES `tl_latask10_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_latask10_user`
--
LOCK TABLES `tl_latask10_user` WRITE;
/*!40000 ALTER TABLE `tl_latask10_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_latask10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_attachment`
--
DROP TABLE IF EXISTS `tl_lavidr10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`videoRecorder_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_75587508_12090F57FC940906` (`videoRecorder_uid`),
CONSTRAINT `FK_NEW_75587508_12090F57FC940906` FOREIGN KEY (`videoRecorder_uid`) REFERENCES `tl_lavidr10_videoRecorder` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_attachment`
--
LOCK TABLES `tl_lavidr10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_comment`
--
DROP TABLE IF EXISTS `tl_lavidr10_comment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_comment` (
`uid` bigint(20) NOT NULL auto_increment,
`comment` text,
`videoRecorder_recording_uid` bigint(20) default NULL,
`videoRecorder_session_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
`create_date` datetime default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_comment`
--
LOCK TABLES `tl_lavidr10_comment` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_conditions`
--
DROP TABLE IF EXISTS `tl_lavidr10_conditions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_conditions` (
`condition_id` bigint(20) NOT NULL,
`content_uid` bigint(20) default NULL,
PRIMARY KEY (`condition_id`),
KEY `VideoRecorderConditionToVideoRecorder` (`content_uid`),
CONSTRAINT `VideoRecorderConditionInheritance` FOREIGN KEY (`condition_id`) REFERENCES `lams_branch_condition` (`condition_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `VideoRecorderConditionToVideoRecorder` FOREIGN KEY (`content_uid`) REFERENCES `tl_lavidr10_videoRecorder` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_conditions`
--
LOCK TABLES `tl_lavidr10_conditions` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_conditions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_conditions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_rating`
--
DROP TABLE IF EXISTS `tl_lavidr10_rating`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_rating` (
`uid` bigint(20) NOT NULL auto_increment,
`rating` float default NULL,
`videoRecorder_recording_uid` bigint(20) default NULL,
`videoRecorder_session_uid` bigint(20) default NULL,
`create_by` bigint(20) default NULL,
`create_date` datetime default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_rating`
--
LOCK TABLES `tl_lavidr10_rating` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_rating` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_rating` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_recording`
--
DROP TABLE IF EXISTS `tl_lavidr10_recording`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_recording` (
`uid` bigint(20) NOT NULL auto_increment,
`tool_content_id` bigint(20) default NULL,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`description` varchar(1027) default NULL,
`rating` float default NULL,
`filename` varchar(255) default NULL,
`is_local` bit(1) default NULL,
`is_just_sound` bit(1) default NULL,
`videoRecorder_session_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_recording`
--
LOCK TABLES `tl_lavidr10_recording` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_recording` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_recording` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_session`
--
DROP TABLE IF EXISTS `tl_lavidr10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`videoRecorder_uid` bigint(20) default NULL,
`content_folder_id` varchar(32) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_75587508_B7C198E2FC940906` (`videoRecorder_uid`),
CONSTRAINT `FK_NEW_75587508_B7C198E2FC940906` FOREIGN KEY (`videoRecorder_uid`) REFERENCES `tl_lavidr10_videoRecorder` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_session`
--
LOCK TABLES `tl_lavidr10_session` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_user`
--
DROP TABLE IF EXISTS `tl_lavidr10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`videoRecorder_session_uid` bigint(20) default NULL,
`entry_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK_NEW_75587508_CB8A58FFA3B0FADF` (`videoRecorder_session_uid`),
CONSTRAINT `FK_NEW_75587508_CB8A58FFA3B0FADF` FOREIGN KEY (`videoRecorder_session_uid`) REFERENCES `tl_lavidr10_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_user`
--
LOCK TABLES `tl_lavidr10_user` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavidr10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavidr10_videoRecorder`
--
DROP TABLE IF EXISTS `tl_lavidr10_videoRecorder`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavidr10_videoRecorder` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`reflect_on_activity` bit(1) default NULL,
`reflect_instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`author_recording_id` bigint(20) default NULL,
`allow_use_voice` bit(1) default NULL,
`allow_use_camera` bit(1) default NULL,
`allow_learner_video_visibility` bit(1) default NULL,
`allow_learner_video_export` bit(1) default NULL,
`allow_comments` bit(1) default NULL,
`allow_ratings` bit(1) default NULL,
`export_offline` bit(1) default NULL,
`export_all` bit(1) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavidr10_videoRecorder`
--
LOCK TABLES `tl_lavidr10_videoRecorder` WRITE;
/*!40000 ALTER TABLE `tl_lavidr10_videoRecorder` DISABLE KEYS */;
INSERT INTO `tl_lavidr10_videoRecorder` VALUES (1,NULL,NULL,NULL,'VideoRecorder','Instructions',0x00,'',0x00,0x00,'','',0x00,0x00,18,NULL,0x01,0x01,0x01,0x01,0x01,0x01,0x01,0x01);
/*!40000 ALTER TABLE `tl_lavidr10_videoRecorder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_content`
--
DROP TABLE IF EXISTS `tl_lavote11_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_content` (
`uid` bigint(20) NOT NULL auto_increment,
`content_id` bigint(20) NOT NULL,
`title` text,
`instructions` text,
`creation_date` datetime default NULL,
`update_date` datetime default NULL,
`maxNominationCount` varchar(20) NOT NULL default '1',
`allowText` tinyint(1) NOT NULL default '0',
`reflect` tinyint(1) NOT NULL default '0',
`created_by` bigint(20) NOT NULL default '0',
`run_offline` tinyint(1) NOT NULL default '0',
`define_later` tinyint(1) NOT NULL default '0',
`offline_instructions` text,
`online_instructions` text,
`content_in_use` tinyint(1) NOT NULL default '0',
`lock_on_finish` tinyint(1) NOT NULL default '1',
`retries` tinyint(1) NOT NULL default '0',
`reflectionSubject` text,
`show_results` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_content`
--
LOCK TABLES `tl_lavote11_content` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_content` DISABLE KEYS */;
INSERT INTO `tl_lavote11_content` VALUES (1,7,'Voting','Instructions','2009-05-21 17:33:20',NULL,'1',0,0,1,0,0,'','',0,0,0,NULL,1),(2,48,'Voting Demonstration','
\n
Here’s a demonstration Voting activity.
\n
\n
While this particular activity is a little bit... trivial... there’s no reason why you can’t have a very large nomination form and collate responses from as many learners are on your server.
While this particular activity is a little bit... trivial... there’s no reason why you can’t have a very large nomination form and collate responses from as many learners are on your server.
\n
\n
\n
What’s your favourite flavour for ice-cream?
',NULL,'2008-04-11 16:39:37','1',1,0,5,0,0,'','',0,0,0,'',1);
/*!40000 ALTER TABLE `tl_lavote11_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_nomination_content`
--
DROP TABLE IF EXISTS `tl_lavote11_nomination_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_nomination_content` (
`uid` bigint(20) NOT NULL auto_increment,
`nomination` text,
`display_order` int(5) default NULL,
`vote_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
KEY `vote_content_id` (`vote_content_id`),
CONSTRAINT `FK_tl_lavote11_nomination_content_1` FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_nomination_content`
--
LOCK TABLES `tl_lavote11_nomination_content` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_nomination_content` DISABLE KEYS */;
INSERT INTO `tl_lavote11_nomination_content` VALUES (1,'Sample Nomination 1',1,1),(2,'Sample Nomination 2',2,1),(3,'
Strawberry!
',1,2),(4,'
\n
Chocolate!
\n
\n
',2,2),(5,'
Vanilla!
\n\n',3,2),(6,'
Strawberry!
',1,3),(7,'
\n
Chocolate!
\n
\n
',2,3),(8,'
Vanilla!
\n\n',3,3);
/*!40000 ALTER TABLE `tl_lavote11_nomination_content` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_session`
--
DROP TABLE IF EXISTS `tl_lavote11_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_session` (
`uid` bigint(20) NOT NULL auto_increment,
`vote_session_id` bigint(20) NOT NULL,
`session_start_date` datetime default NULL,
`session_end_date` datetime default NULL,
`session_name` varchar(100) default NULL,
`session_status` varchar(100) default NULL,
`vote_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `UQ_tl_lamc11_session_1` (`vote_session_id`),
KEY `vote_content_id` (`vote_content_id`),
CONSTRAINT `FK_tl_lavote11_session_1` FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_session`
--
LOCK TABLES `tl_lavote11_session` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_session` DISABLE KEYS */;
INSERT INTO `tl_lavote11_session` VALUES (1,26,'2009-05-21 17:39:13',NULL,'Everybody learners','INCOMPLETE',3);
/*!40000 ALTER TABLE `tl_lavote11_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_uploadedfile`
--
DROP TABLE IF EXISTS `tl_lavote11_uploadedfile`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_uploadedfile` (
`submissionId` bigint(20) NOT NULL auto_increment,
`uuid` varchar(255) NOT NULL,
`isOnline_File` tinyint(1) NOT NULL,
`filename` varchar(255) NOT NULL,
`vote_content_id` bigint(20) NOT NULL,
PRIMARY KEY (`submissionId`),
KEY `vote_content_id` (`vote_content_id`),
CONSTRAINT `FK_tablex_111` FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_uploadedfile`
--
LOCK TABLES `tl_lavote11_uploadedfile` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_uploadedfile` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavote11_uploadedfile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_usr`
--
DROP TABLE IF EXISTS `tl_lavote11_usr`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_usr` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL,
`vote_session_id` bigint(20) NOT NULL,
`username` varchar(255) default NULL,
`fullname` varchar(255) default NULL,
`responseFinalised` tinyint(1) NOT NULL default '0',
`finalScreenRequested` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `vote_session_id` (`vote_session_id`),
CONSTRAINT `FK_tl_lavote11_usr_1` FOREIGN KEY (`vote_session_id`) REFERENCES `tl_lavote11_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_usr`
--
LOCK TABLES `tl_lavote11_usr` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_usr` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavote11_usr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lavote11_usr_attempt`
--
DROP TABLE IF EXISTS `tl_lavote11_usr_attempt`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lavote11_usr_attempt` (
`uid` bigint(20) NOT NULL auto_increment,
`que_usr_id` bigint(20) NOT NULL,
`vote_nomination_content_id` bigint(20) NOT NULL,
`attempt_time` datetime default NULL,
`time_zone` varchar(255) default NULL,
`userEntry` varchar(255) default NULL,
`singleUserEntry` tinyint(1) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `que_usr_id` (`que_usr_id`),
KEY `vote_nomination_content_id` (`vote_nomination_content_id`),
CONSTRAINT `FK_tl_lavote11_usr_attempt_2` FOREIGN KEY (`que_usr_id`) REFERENCES `tl_lavote11_usr` (`uid`),
CONSTRAINT `FK_tl_lavote11_usr_attempt_3` FOREIGN KEY (`vote_nomination_content_id`) REFERENCES `tl_lavote11_nomination_content` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lavote11_usr_attempt`
--
LOCK TABLES `tl_lavote11_usr_attempt` WRITE;
/*!40000 ALTER TABLE `tl_lavote11_usr_attempt` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lavote11_usr_attempt` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_attachment`
--
DROP TABLE IF EXISTS `tl_lawiki10_attachment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_attachment` (
`uid` bigint(20) NOT NULL auto_increment,
`file_version_id` bigint(20) default NULL,
`file_type` varchar(255) default NULL,
`file_name` varchar(255) default NULL,
`file_uuid` bigint(20) default NULL,
`create_date` datetime default NULL,
`wiki_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK9406D87760B3B03B` (`wiki_uid`),
CONSTRAINT `FK9406D87760B3B03B` FOREIGN KEY (`wiki_uid`) REFERENCES `tl_lawiki10_wiki` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_attachment`
--
LOCK TABLES `tl_lawiki10_attachment` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lawiki10_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_session`
--
DROP TABLE IF EXISTS `tl_lawiki10_session`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_session` (
`uid` bigint(20) NOT NULL auto_increment,
`session_end_date` datetime default NULL,
`session_start_date` datetime default NULL,
`status` int(11) default NULL,
`session_id` bigint(20) default NULL,
`session_name` varchar(250) default NULL,
`wiki_uid` bigint(20) default NULL,
`wiki_main_page_uid` bigint(20) default NULL,
`content_folder_id` varchar(255) default NULL,
PRIMARY KEY (`uid`),
KEY `FKF01D63C260B3B03B` (`wiki_uid`),
KEY `FKF01D63C2A3FF7EC0` (`wiki_main_page_uid`),
CONSTRAINT `FKF01D63C2A3FF7EC0` FOREIGN KEY (`wiki_main_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`),
CONSTRAINT `FKF01D63C260B3B03B` FOREIGN KEY (`wiki_uid`) REFERENCES `tl_lawiki10_wiki` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_session`
--
LOCK TABLES `tl_lawiki10_session` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_session` DISABLE KEYS */;
INSERT INTO `tl_lawiki10_session` VALUES (1,NULL,NULL,NULL,10,'Everybody learners',3,7,'2c94e451216218b80121621c0b010011');
/*!40000 ALTER TABLE `tl_lawiki10_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_user`
--
DROP TABLE IF EXISTS `tl_lawiki10_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_user` (
`uid` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) default NULL,
`last_name` varchar(255) default NULL,
`login_name` varchar(255) default NULL,
`first_name` varchar(255) default NULL,
`finishedActivity` bit(1) default NULL,
`wiki_session_uid` bigint(20) default NULL,
`entry_uid` bigint(20) default NULL,
`wiki_edits` int(11) default NULL,
PRIMARY KEY (`uid`),
KEY `FKED5D7A1FD8004954` (`wiki_session_uid`),
CONSTRAINT `FKED5D7A1FD8004954` FOREIGN KEY (`wiki_session_uid`) REFERENCES `tl_lawiki10_session` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_user`
--
LOCK TABLES `tl_lawiki10_user` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `tl_lawiki10_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_wiki`
--
DROP TABLE IF EXISTS `tl_lawiki10_wiki`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_wiki` (
`uid` bigint(20) NOT NULL auto_increment,
`create_date` datetime default NULL,
`update_date` datetime default NULL,
`create_by` bigint(20) default NULL,
`title` varchar(255) default NULL,
`instructions` text,
`run_offline` bit(1) default NULL,
`lock_on_finished` bit(1) default NULL,
`allow_learner_create_pages` bit(1) default NULL,
`allow_learner_insert_links` bit(1) default NULL,
`allow_learner_attach_images` bit(1) default NULL,
`notify_updates` bit(1) default NULL,
`reflect_on_activity` bit(1) default NULL,
`reflect_instructions` text,
`minimum_edits` int(11) default NULL,
`maximum_edits` int(11) default NULL,
`online_instructions` text,
`offline_instructions` text,
`content_in_use` bit(1) default NULL,
`define_later` bit(1) default NULL,
`tool_content_id` bigint(20) default NULL,
`wiki_main_page_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FKED5E3E04A3FF7EC0` (`wiki_main_page_uid`),
CONSTRAINT `FKED5E3E04A3FF7EC0` FOREIGN KEY (`wiki_main_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_wiki`
--
LOCK TABLES `tl_lawiki10_wiki` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_wiki` DISABLE KEYS */;
INSERT INTO `tl_lawiki10_wiki` VALUES (1,NULL,NULL,NULL,'Wiki','Instructions',0x00,0x00,0x01,0x01,0x01,0x00,0x00,'',0,0,'','',0x00,0x00,15,1),(2,'2008-11-14 14:32:00','2008-11-10 12:53:27',5,'Wiki','Instructions',0x00,0x00,0x01,0x01,0x01,0x00,0x00,'',0,0,'','',0x00,0x00,53,3),(3,'2009-05-21 17:39:12','2008-11-10 12:53:27',5,'Wiki','Instructions',0x00,0x00,0x01,0x01,0x01,0x00,0x00,'',0,0,'','',0x00,0x00,85,5);
/*!40000 ALTER TABLE `tl_lawiki10_wiki` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_wiki_page`
--
DROP TABLE IF EXISTS `tl_lawiki10_wiki_page`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_wiki_page` (
`uid` bigint(20) NOT NULL auto_increment,
`wiki_uid` bigint(20) default NULL,
`title` varchar(255) default NULL,
`editable` bit(1) default NULL,
`wiki_current_content` bigint(20) default NULL,
`added_by` bigint(20) default NULL,
`wiki_session_uid` bigint(20) default NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `wiki_unique_key` (`wiki_uid`,`title`,`wiki_session_uid`),
KEY `wiki_page_index_1` (`wiki_session_uid`),
KEY `wiki_page_index_2` (`wiki_uid`),
KEY `wiki_page_index_3` (`added_by`),
KEY `wiki_page_index_4` (`wiki_current_content`),
CONSTRAINT `wiki_page_fk_4` FOREIGN KEY (`wiki_current_content`) REFERENCES `tl_lawiki10_wiki_page_content` (`uid`),
CONSTRAINT `wiki_page_fk_1` FOREIGN KEY (`wiki_session_uid`) REFERENCES `tl_lawiki10_session` (`uid`),
CONSTRAINT `wiki_page_fk_2` FOREIGN KEY (`wiki_uid`) REFERENCES `tl_lawiki10_wiki` (`uid`),
CONSTRAINT `wiki_page_fk_3` FOREIGN KEY (`added_by`) REFERENCES `tl_lawiki10_user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_wiki_page`
--
LOCK TABLES `tl_lawiki10_wiki_page` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_wiki_page` DISABLE KEYS */;
INSERT INTO `tl_lawiki10_wiki_page` VALUES (1,1,'Wiki Main Page',0x01,1,NULL,NULL),(2,2,'Important Things to Know',0x01,2,NULL,NULL),(3,2,'Wiki Main Page',0x00,3,NULL,NULL),(4,3,'Important Things to Know',0x01,4,NULL,NULL),(5,3,'Wiki Main Page',0x00,5,NULL,NULL),(6,3,'Important Things to Know',0x01,6,NULL,1),(7,3,'Wiki Main Page',0x00,7,NULL,1);
/*!40000 ALTER TABLE `tl_lawiki10_wiki_page` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tl_lawiki10_wiki_page_content`
--
DROP TABLE IF EXISTS `tl_lawiki10_wiki_page_content`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tl_lawiki10_wiki_page_content` (
`uid` bigint(20) NOT NULL auto_increment,
`wiki_page_uid` bigint(20) default NULL,
`body` text,
`editor` bigint(20) default NULL,
`edit_date` datetime default NULL,
`version` bigint(20) default NULL,
PRIMARY KEY (`uid`),
KEY `FK528051242D44CCF8` (`wiki_page_uid`),
KEY `FK528051243233D952` (`editor`),
CONSTRAINT `FK528051243233D952` FOREIGN KEY (`editor`) REFERENCES `tl_lawiki10_user` (`uid`),
CONSTRAINT `FK528051242D44CCF8` FOREIGN KEY (`wiki_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `tl_lawiki10_wiki_page_content`
--
LOCK TABLES `tl_lawiki10_wiki_page_content` WRITE;
/*!40000 ALTER TABLE `tl_lawiki10_wiki_page_content` DISABLE KEYS */;
INSERT INTO `tl_lawiki10_wiki_page_content` VALUES (1,1,'
Wiki Body
',NULL,NULL,0),(2,2,'
\n
There are some important things you should know about Wiki\'s:
\n
\n
They are not static. In LAMS, authors can allow Learners to edit existing Wiki content. They can add or remove text and images, etc, but the important thing to note is that
\n
Nothing on a wiki is ever \'lost\'. The LAMS Wiki tool allows monitors (and learners if permitted) to view the history of a page. This shows all of the changes that have been made to the page; who made them and when; and, for monitors, a link to revert the page to a previous state.
\n
\n
\n
\n
\n
You can edit this page by using the Edit link at the top right of your screen.
\n
',NULL,'2009-05-21 17:38:09',1),(3,3,'
\n
\n
New to LAMS 2.2!
\n
Wiki Activity
\n
The Wiki Tool allows for authors to create content pages that can link to each other and, optionally, allow Learners to make collaborative edits to the content provided.
\n
Wiki activities allow authors and learners to create sub pages, which can contain more refined content on the topic.
\n
Here are some links to other pages in this wiki activity:
If you want to explore this activity further, you should read the Wiki Learner’s guide, available online.
\n
\n
',NULL,'2009-05-21 17:38:09',3),(4,4,'
\n
There are some important things you should know about Wiki\'s:
\n
\n
They are not static. In LAMS, authors can allow Learners to edit existing Wiki content. They can add or remove text and images, etc, but the important thing to note is that
\n
Nothing on a wiki is ever \'lost\'. The LAMS Wiki tool allows monitors (and learners if permitted) to view the history of a page. This shows all of the changes that have been made to the page; who made them and when; and, for monitors, a link to revert the page to a previous state.
\n
\n
\n
\n
\n
You can edit this page by using the Edit link at the top right of your screen.
\n
',NULL,'2009-05-21 17:39:12',1),(5,5,'
\n
\n
New to LAMS 2.2!
\n
Wiki Activity
\n
The Wiki Tool allows for authors to create content pages that can link to each other and, optionally, allow Learners to make collaborative edits to the content provided.
\n
Wiki activities allow authors and learners to create sub pages, which can contain more refined content on the topic.
\n
Here are some links to other pages in this wiki activity:
If you want to explore this activity further, you should read the Wiki Learner’s guide, available online.
\n
\n
',NULL,'2009-05-21 17:39:12',3),(6,6,'
\n
There are some important things you should know about Wiki\'s:
\n
\n
They are not static. In LAMS, authors can allow Learners to edit existing Wiki content. They can add or remove text and images, etc, but the important thing to note is that
\n
Nothing on a wiki is ever \'lost\'. The LAMS Wiki tool allows monitors (and learners if permitted) to view the history of a page. This shows all of the changes that have been made to the page; who made them and when; and, for monitors, a link to revert the page to a previous state.
\n
\n
\n
\n
\n
You can edit this page by using the Edit link at the top right of your screen.
\n
',NULL,'2009-05-21 17:39:13',1),(7,7,'
\n
\n
New to LAMS 2.2!
\n
Wiki Activity
\n
The Wiki Tool allows for authors to create content pages that can link to each other and, optionally, allow Learners to make collaborative edits to the content provided.
\n
Wiki activities allow authors and learners to create sub pages, which can contain more refined content on the topic.
\n
Here are some links to other pages in this wiki activity:
If you want to explore this activity further, you should read the Wiki Learner’s guide, available online.
\n
\n
',NULL,'2009-05-21 17:39:13',3);
/*!40000 ALTER TABLE `tl_lawiki10_wiki_page_content` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2009-05-21 7:43:24
![\"\"](\"http://wiki.lamsfoundation.org/download/attachments/5570965/dacoIcon.png\")
Data Collection![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/gmap.png\")
Google Maps ![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//imagIcon.png\")
The new Image Gallery activity allows authors, monitors and learners to view and upload images to the LAMS server, then review or rate them with their peers.![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//dolly_sml.gif\")
![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/8_1242347950592.png\")
![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//assessIcon.png\")
The new Assessment activity makes it easier than ever to create complex assessment tasks inside a LAMS sequence. The new tool can also export the results from an assessment task into a Gradebook, which can then be recorded in LAMS, or exported for use in another program.![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//gradebook.png\")
The New Gradebook interface allows Monitoring teachers to gain a comprehensive overview of Learners performance through a lesson.![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/vidRcIcon.PNG\")
![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lanb11.PNG\")
Noticeboard![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//larsrc11.PNG\")
Share Resources![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/diploma.jpeg\")
!!! CONGRATULATIONS !!!![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lamc11.PNG\")
Multiple Choice![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lasbmt11.PNG\")
Submit Files ![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//laqa11.PNG\")
Question and Answer![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lasurv11.PNG\")
Survey![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lavote11.PNG\")
Voting![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lachat11.PNG\")
Chat Activity![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lafrum11.PNG\")
Forum Activity![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lascrb11.PNG\")
Scribe Activity![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//chatScribe.png\")
Chat and Scribe![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//forumScribe.png\")
\n![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//shareForum.png\")
Resource Sharing and Forum![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/gmapIcon.png\")
Google Maps![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/wikiIcon.png\")
Wiki Activity![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//lantbk11.PNG\")
Notebook Activity![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image/dacoIcon.png\")
Data Collection![\"\"](\"/lams//www/secure/4028efbb18edfbb70118ee6bacc700d2/Image/dolly_lrg.gif\")
![\"\"](\"/lams//www/secure/4028efbb18edfbb70118ee6bacc700d2/Image//progbar.png\")
![\"\"](\"/lams//www/secure/4028efbb18edfbb70118ee3b3b6d00b8/Image//annotated.png\")
![\"dolly](\"/lams//www/secure/4028efbb18edfbb70118ee3b3b6d00b8/Image/dolly_sml.gif\")
![\"\"](\"/lams//www/secure/4028efbb18edfbb70118ee3b3b6d00b8/Image//dolly_sml.gif\")
![\"\"](\"/lams//www/secure/4028efbb1935b8d301193606f5000051/Image//pixl10.PNG\")
Pixlr is a powerful online flash-based image editor that can be included as a LAMS activity. The editor has powerful image creation and editing features, and the interface will be familiar to anyone who has used Paint, or more advanced editors like Photoshop or GIMP.![\"\"](\"http://wiki.lamsfoundation.org/download/attachments/6750276/wikiIcon.PNG\")
Wiki Activity![front page model](\"http://demo.lamscommunity.org/lams/images/css/lams_login_bar.jpg\"){kind=link}