FINALLY! Surveys are now translatable! :-)

diff --git a/lang/en/survey.php b/lang/en/survey.php
index 9793b6c..287326a 100644 (file)
--- a/lang/en/survey.php
+++ b/lang/en/survey.php
@@ -6,12 +6,164 @@ $string['modulenameplural'] = "Surveys";
 #------------------------------------------------------------
 
 $string['actual'] = "Actual";
+$string['actualclass'] = "Class actual";
+$string['actualstudent'] = "Student actual";
 $string['allquestions'] = "All questions in order, all students";
 $string['allscales'] = "All scales, all students";
 $string['alreadysubmitted'] = "You have already submitted this survey";
 $string['analysisof'] = "Analysis of \$a";
-$string['ipreferthat'] = "I prefer that";
-$string['ifoundthat'] = "I found that";
+
+$string['attlsname'] = "ATTLS (20 item version)";
+$string['attlsintro'] = "The purpose of this questionnaire is to help us evaluate your attitudes towards thinking and learning.
+
+There are no 'right' or 'wrong' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.";
+
+$string['attls1'] = "In evaluating what someone says, I focus on the quality of their argument, not on the person who's presenting it.";
+$string['attls1short'] = "focus quality of argument";
+$string['attls2'] = "I like playing devil's advocate - arguing the opposite of what someone is saying.";
+$string['attls2short'] = "play devil's advocate";
+$string['attls3'] = "I like to understand where other people are 'coming from', what experiences have led them to feel the way they do.";
+$string['attls3short'] = "where people come from";
+$string['attls4'] = "The most important part of my education has been learning to understand people who are very different to me.";
+$string['attls4short'] = "understand different people";
+$string['attls5'] = "I feel that the best way for me to achieve my own identity is to interact with a variety of other people.";
+$string['attls5short'] = "interact with variety";
+$string['attls6'] = "I enjoy hearing the opinions of people who come from backgrounds different to mine - it helps me to understand how the same things can be seen in such different ways.";
+$string['attls6short'] = "enjoy hearing opinions";
+$string['attls7'] = "I find that I can strengthen my own position through arguing with someone who disagrees with me.";
+$string['attls7short'] = "strengthen by argue";
+$string['attls8'] = "I am always interested in knowing why people say and believe the things they do.";
+$string['attls8short'] = "know why people do";
+$string['attls9'] = "I often find myself arguing with the authors of books that I read, trying to logically figure out why they're wrong.";
+$string['attls9short'] = "argue with authors";
+$string['attls10'] = "It's important for me to remain as objective as possible when I analyze something.";
+$string['attls10short'] = "remain objective";
+$string['attls11'] = "I try to think with people instead of against them.";
+$string['attls11short'] = "think WITH people";
+$string['attls12'] = "I have certain criteria I use in evaluating arguments.";
+$string['attls12short'] = "use criteria to evaluate";
+$string['attls13'] = "I'm more likely to try to understand someone else's opinion that to try to evaluate it.";
+$string['attls13short'] = "try to understand";
+$string['attls14'] = "I try to point out weaknesses in other people's thinking to help them clarify their arguments.";
+$string['attls14short'] = "point out weaknesses";
+$string['attls15'] = "I tend to put myself in other people's shoes when discussing controversial issues, to see why they think the way they do.";
+$string['attls15short'] = "put myself in their shoes";
+$string['attls16'] = "One could call my way of analysing things 'putting them on trial' because I am careful to consider all the evidence.";
+$string['attls16short'] = "putting on trial";
+$string['attls17'] = "I value the use of logic and reason over the incorporation of my own concerns when solving problems.";
+$string['attls17short'] = "i value logic most";
+$string['attls18'] = "I can obtain insight into opinions that differ from mine through empathy.";
+$string['attls18short'] = "insight from empathy";
+$string['attls19'] = "When I encounter people whose opinions seem alien to me, I make a deliberate effort to 'extend' myself into that person, to try to see how they could have those opinions.";
+$string['attls19short'] = "make effort to extend";
+$string['attls20'] = "I spend time figuring out what's 'wrong' with things. For example, I'll look for something in a literary interpretation that isn't argued well enough.";
+$string['attls20short'] = "what's wrong?";
+
+$string['attlsmintro'] = "In discussion ...";
+$string['attlsm1'] = "Attitudes Towards Thinking and Learning";
+$string['attlsm2'] = "Connected Learning";
+$string['attlsm3'] = "Separate Learning";
+$string['clicktocontinue'] = "Click here to continue";
+$string['clicktocontinuecheck'] = "Click here to check and continue";
+
+$string['colles1'] = "my learning focuses on issues that interest me.";
+$string['colles1short'] = "focus on interesting issues";
+$string['colles2'] = "what I learn is important for my professional practice.";
+$string['colles2short'] = "important to my practice";
+$string['colles3'] = "I learn how to improve my professional practice.";
+$string['colles3short'] = "improve my practice";
+$string['colles4'] = "what I learn connects well with my professional practice.";
+$string['colles4short'] = "connects with my practice";
+$string['colles5'] = "I think critically about how I learn.";
+$string['colles5short'] = "I'm critical of my learning";
+$string['colles6'] = "I think critically about my own ideas.";
+$string['colles6short'] = "I'm critical of my own ideas";
+$string['colles7'] = "I think critically about other students' ideas.";
+$string['colles7short'] = "I'm critical of other students";
+$string['colles8'] = "I think critically about ideas in the readings.";
+$string['colles8short'] = "I'm critical of readings";
+$string['colles9'] = "I explain my ideas to other students.";
+$string['colles9short'] = "I explain my ideas";
+$string['colles10'] = "I ask other students to explain their ideas.";
+$string['colles10short'] = "I ask for explanations";
+$string['colles11'] = "other students ask me to explain my ideas.";
+$string['colles11short'] = "I'm asked to explain";
+$string['colles12'] = "other students respond to my ideas.";
+$string['colles12short'] = "students respond to me";
+$string['colles13'] = "the tutor stimulates my thinking.";
+$string['colles13short'] = "tutor stimulates thinking";
+$string['colles14'] = "the tutor encourages me to participate.";
+$string['colles14short'] = "tutor encourages me";
+$string['colles15'] = "the tutor models good discourse.";
+$string['colles15short'] = "tutor models discourse";
+$string['colles16'] = "the tutor models critical self-reflection.";
+$string['colles16short'] = "tutor models self-reflection";
+$string['colles17'] = "other students encourage my participation.";
+$string['colles17short'] = "students encourage me";
+$string['colles18'] = "other students praise my contribution.";
+$string['colles18hort'] = "students praise me";
+$string['colles19'] = "other students value my contribution.";
+$string['colles19short'] = "students value me";
+$string['colles20'] = "other students empathise with my struggle to learn.";
+$string['colles20short'] = "students empathise";
+$string['colles21'] = "I make good sense of other students' messages.";
+$string['colles21short'] = "I understand other students";
+$string['colles22'] = "other students make good sense of my messages.";
+$string['colles22short'] = "students understand me";
+$string['colles23'] = "I make good sense of the tutor's messages.";
+$string['colles23short'] = "I understand the tutor";
+$string['colles24'] = "the tutor makes good sense of my messages.";
+$string['colles24short'] = "tutor understands me";
+
+$string['collesaname'] = "COLLES (Actual)";
+$string['collesaintro'] = "The purpose of this survey is to help us understand how well the online delivery of this unit enabled you to learn.
+
+Each one of the 24 statements below asks about your experience in this unit.
+
+There are no 'right' or 'wrong' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.
+
+Your carefully considered responses will help us improve the way this unit is presented online in the future.
+
+Thanks very much.";
+
+$string['collesapname'] = "COLLES (Preferred and Actual)";
+$string['collesapintro'] = "The purpose of this questionnaire is to help us understand how well the online delivery of this unit enabled you to learn. 
+
+Each one of the 24 statements below asks you to compare your <B>preferred</B> (ideal) and <B>actual</B> experience in this unit.
+
+There are no 'right' or 'wrong' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.
+
+Your carefully considered responses will help us improve the way this unit is presented online in the future.
+
+Thanks very much.";
+
+$string['collespname'] = "COLLES (Preferred)";
+$string['collespintro'] = "The purpose of this survey is to help us understand what you value in an online learning experience.
+
+Each one of the 24 statements below asks about your <B>preferred</B> (ideal) experience in this unit.
+
+There are no 'right' or 'wrong' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.
+
+Your carefully considered responses will help us improve the way this unit is presented online in the future.
+
+Thanks very much.";
+
+
+$string['collesm1']      = "Relevance";
+$string['collesm1short'] = "Relevance";
+$string['collesm2']      = "Reflective Thinking";
+$string['collesm2short'] = "Reflective Thinking";
+$string['collesm3']      = "Interactivity";
+$string['collesm3short'] = "Interactivity";
+$string['collesm4']      = "Tutor Support";
+$string['collesm4short'] = "Tutor Support";
+$string['collesm5']      = "Peer Support";
+$string['collesm5short'] = "Peer Support";
+$string['collesm6']      = "Interpretation";
+$string['collesm6short'] = "Interpretation";
+
+$string['collesmintro'] = "In this online unit...";
+
 $string['done'] = "Done";
 $string['download'] = "Download";
 $string['downloadexcel'] = "Download data as Excel spreadsheet";
@@ -19,19 +171,29 @@ $string['downloadinfo'] = "You can download the complete raw data for this surve
 $string['downloadtext'] = "Download data as a plain text file";
 $string['editingasurvey'] = "Editing a survey";
 $string['helpsurveys'] = "Help on the different types of surveys";
+$string['howlong'] = "How long did this survey take you to complete?";
+$string['howlongoptions'] = "under 1 min,1-2 min,2-3 min,3-4 min,4-5-min,5-10 min,more than 10";
+$string['ifoundthat'] = "I found that";
 $string['introtext'] = "Introduction text";
+$string['ipreferthat'] = "I prefer that";
 $string['name'] = "Name";
 $string['newsurveyresponses'] = "New survey responses";
 $string['nobodyyet'] = "Nobody has yet completed this survey";
 $string['notdone'] = "Not done yet";
 $string['notes'] = "Your private analysis and notes";
+$string['othercomments'] = "Do you have any other comments?";
 $string['peoplecompleted'] = "\$a people have completed this survey so far";
 $string['preferred'] = "Preferred";
-$string['questions'] = "Questions";
+$string['preferredclass'] = "Class preferred";
+$string['preferredstudent'] = "Student preferred";
 $string['question'] = "Question";
+$string['questions'] = "Questions";
+$string['questionsnotanswered'] = "Some of the multiple choice questions have not been answered.";
 $string['report'] = "Survey report";
 $string['scales'] = "Scales";
 $string['savednotes'] = "Your notes were saved";
+$string['scaleagree5'] = "Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree";
+$string['scaletimes5'] = "Almost Never,Seldom,Sometimes,Often,Almost Always";
 $string['seemoredetail'] = "Click here to see more detail";
 $string['selectedquestions'] = "Selected questions from a scale, all students";
 $string['summary'] = "Summary";

diff --git a/mod/survey/db/mysql.php b/mod/survey/db/mysql.php
index f47b8c8..fe9a932 100644 (file)
--- a/mod/survey/db/mysql.php
+++ b/mod/survey/db/mysql.php
@@ -81,6 +81,77 @@ function survey_upgrade($oldversion) {
 
     }
 
+    if ($oldversion < 2002110903) {
+        if (! execute_sql("ALTER TABLE `survey_questions` ADD `shorttext` VARCHAR(30) NOT NULL AFTER `text` ")) {
+            notice("If you get an error above, don't worry, just ignore it.  Everything is OK.");
+        }
+
+        execute_sql("UPDATE `survey` SET `name` = 'collesaname', `intro` = 'collesaintro' WHERE name = 'COLLES (Actual)' AND template = 0 ");
+        execute_sql("UPDATE `survey` SET `name` = 'collespname', `intro` = 'collespintro' WHERE name = 'COLLES (Preferred)' AND template = 0");
+        execute_sql("UPDATE `survey` SET `name` = 'collesapname', `intro` = 'collesapintro' WHERE name = 'COLLES (Preferred and Actual)' AND template = 0");
+        execute_sql("UPDATE `survey` SET `name` = 'attlsname', `intro` = 'attlsintro' WHERE name = 'ATTLS (20 item version)' AND template = 0");
+
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles1', `shorttext` = 'colles1short', `options` = 'scaletimes5' WHERE `shorttext` = 'focus on interesting issues'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles2', `shorttext` = 'colles2short', `options` = 'scaletimes5' WHERE `shorttext` = 'important to my practice'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles3', `shorttext` = 'colles3short', `options` = 'scaletimes5' WHERE `shorttext` = 'improve my practice'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles4', `shorttext` = 'colles4short', `options` = 'scaletimes5' WHERE `shorttext` = 'connects with my practice'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles5', `shorttext` = 'colles5short', `options` = 'scaletimes5' WHERE `shorttext` = 'I\'m critical of my learning'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles6', `shorttext` = 'colles6short', `options` = 'scaletimes5' WHERE `shorttext` = 'I\'m critical of my own ideas'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles7', `shorttext` = 'colles7short', `options` = 'scaletimes5' WHERE `shorttext` = 'I\'m critical of other students'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles8', `shorttext` = 'colles8short', `options` = 'scaletimes5' WHERE `shorttext` = 'I\'m critical of readings'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles9', `shorttext` = 'colles9short', `options` = 'scaletimes5' WHERE `shorttext` = 'I explain my ideas'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles10', `shorttext` = 'colles10short', `options` = 'scaletimes5' WHERE `shorttext` = 'I ask for explanations'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles11', `shorttext` = 'colles11short', `options` = 'scaletimes5' WHERE `shorttext` = 'I\'m asked to explain'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles12', `shorttext` = 'colles12short', `options` = 'scaletimes5' WHERE `shorttext` = 'students respond to me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles13', `shorttext` = 'colles13short', `options` = 'scaletimes5' WHERE `shorttext` = 'tutor stimulates thinking'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles14', `shorttext` = 'colles14short', `options` = 'scaletimes5' WHERE `shorttext` = 'tutor encourages me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles15', `shorttext` = 'colles15short', `options` = 'scaletimes5' WHERE `shorttext` = 'tutor models discourse'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles16', `shorttext` = 'colles16short', `options` = 'scaletimes5' WHERE `shorttext` = 'tutor models self-reflection'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles17', `shorttext` = 'colles17short', `options` = 'scaletimes5' WHERE `shorttext` = 'students encourage me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles18', `shorttext` = 'colles18short', `options` = 'scaletimes5' WHERE `shorttext` = 'students praise me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles19', `shorttext` = 'colles19short', `options` = 'scaletimes5' WHERE `shorttext` = 'students value me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles20', `shorttext` = 'colles20short', `options` = 'scaletimes5' WHERE `shorttext` = 'student empathise'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles21', `shorttext` = 'colles21short', `options` = 'scaletimes5' WHERE `shorttext` = 'I understand other students'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles22', `shorttext` = 'colles22short', `options` = 'scaletimes5' WHERE `shorttext` = 'students understand me'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles23', `shorttext` = 'colles23short', `options` = 'scaletimes5' WHERE `shorttext` = 'I understand the tutor'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'colles24', `shorttext` = 'colles24short', `options` = 'scaletimes5' WHERE `shorttext` = 'tutor understands me'");
+
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm1', `shorttext` = 'collesm1short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Relevance'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm2', `shorttext` = 'collesm2short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Reflective Thinking'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm3', `shorttext` = 'collesm3short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Interactivity'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm4', `shorttext` = 'collesm4short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Tutor Support'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm5', `shorttext` = 'collesm5short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Peer Support'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'collesm6', `shorttext` = 'collesm6short', `intro` = 'collesmintro', `options` = 'scaletimes5' WHERE `text` = 'Interpretation'");
+
+        execute_sql("UPDATE `survey_questions` SET `text` = 'howlong', `options` = 'howlongoptions' WHERE `text` = 'How long did this survey take you to complete\?'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'othercomments' WHERE `text` = 'Do you have any other comments\?'");
+
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls1', `shorttext` = 'attls1short', `options` = 'scaleagree5' WHERE `shorttext` = 'focus quality of argument'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls2', `shorttext` = 'attls2short', `options` = 'scaleagree5' WHERE `shorttext` = 'play devil\'s advocate'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls3', `shorttext` = 'attls3short', `options` = 'scaleagree5' WHERE `shorttext` = 'where people come from'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls4', `shorttext` = 'attls4short', `options` = 'scaleagree5' WHERE `shorttext` = 'understand different people'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls5', `shorttext` = 'attls5short', `options` = 'scaleagree5' WHERE `shorttext` = 'interact with variety'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls6', `shorttext` = 'attls6short', `options` = 'scaleagree5' WHERE `shorttext` = 'enjoy hearing opinions'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls7', `shorttext` = 'attls7short', `options` = 'scaleagree5' WHERE `shorttext` = 'strengthen by argue'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls8', `shorttext` = 'attls8short', `options` = 'scaleagree5' WHERE `shorttext` = 'know why people do'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls9', `shorttext` = 'attls9short', `options` = 'scaleagree5' WHERE `shorttext` = 'argue with authors'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls10', `shorttext` = 'attls10short', `options` = 'scaleagree5' WHERE `shorttext` = 'remain objective'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls11', `shorttext` = 'attls11short', `options` = 'scaleagree5' WHERE `shorttext` = 'think WITH people'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls12', `shorttext` = 'attls12short', `options` = 'scaleagree5' WHERE `shorttext` = 'use criteria to evaluate'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls13', `shorttext` = 'attls13short', `options` = 'scaleagree5' WHERE `shorttext` = 'try to understand'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls14', `shorttext` = 'attls14short', `options` = 'scaleagree5' WHERE `shorttext` = 'point out weaknesses'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls15', `shorttext` = 'attls15short', `options` = 'scaleagree5' WHERE `shorttext` = 'put myself in their shoes'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls16', `shorttext` = 'attls16short', `options` = 'scaleagree5' WHERE `shorttext` = 'putting on trial'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls17', `shorttext` = 'attls17short', `options` = 'scaleagree5' WHERE `shorttext` = 'i value logic most'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls18', `shorttext` = 'attls18short', `options` = 'scaleagree5' WHERE `shorttext` = 'insight from empathy'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls19', `shorttext` = 'attls19short', `options` = 'scaleagree5' WHERE `shorttext` = 'make effort to extend'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attls20', `shorttext` = 'attls20short', `options` = 'scaleagree5' WHERE `shorttext` = 'what\'s wrong\?'");
+
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attlsm1', `shorttext` = 'attlsm1', `options` = 'scaleagree5', `intro` = 'attlsmintro' WHERE `text` = 'Attitudes Towards Thinking and Learning'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attlsm2', `shorttext` = 'attlsm2', `options` = 'scaleagree5', `intro` = 'attlsmintro' WHERE `text` = 'Connected Learning'");
+        execute_sql("UPDATE `survey_questions` SET `text` = 'attlsm3', `shorttext` = 'attlsm3', `options` = 'scaleagree5', `intro` = 'attlsmintro' WHERE `text` = 'Separate Learning'");
+    }
+
     return true;
 }
 

diff --git a/mod/survey/db/mysql.sql b/mod/survey/db/mysql.sql
index 42f8084..7e96b28 100755 (executable)
--- a/mod/survey/db/mysql.sql
+++ b/mod/survey/db/mysql.sql
@@ -31,11 +31,12 @@ CREATE TABLE survey (
 # Dumping data for table `survey`\r
 #\r
 \r
-INSERT INTO survey VALUES (1, 0, 0, 0, 985017600, 985017600, 'COLLES (Actual)', 'The purpose of this questionnaire is to help us understand how well the online delivery of this unit enabled you to learn. \r\n\r\nEach one of the 24 statements below asks about your experience in this unit.\r\n\r\nThere are no \'right\' or \'wrong\' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.\r\n\r\nYour carefully considered responses will help us improve the way this unit is presented online in the future.\r\n\r\nThanks very much.\r\n', '25,26,27,28,29,30,43,44');\r
-INSERT INTO survey VALUES (2, 0, 0, 0, 985017600, 985017600, 'COLLES (Preferred)', 'The purpose of this questionnaire is to help us understand what you value in an online learning experience.\r\n\r\nEach one of the 24 statements below asks about your <B>preferred</B> (ideal) experience in this unit.\r\n\r\nThere are no \'right\' or \'wrong\' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.\r\n\r\nYour carefully considered responses will help us improve the way this unit is presented online in the future.\r\n\r\nThanks very much.\r\n', '31,32,33,34,35,36,43,44');\r
-INSERT INTO survey VALUES (3, 0, 0, 0, 985017600, 985017600, 'COLLES (Preferred and Actual)', 'The purpose of this questionnaire is to help us understand how well the online delivery of this unit enabled you to learn. \r\n\r\nEach one of the 24 statements below asks you to compare your <B>preferred</B> (ideal) and <B>actual</B> experience in this unit.\r\n\r\nThere are no \'right\' or \'wrong\' answers; we are interested only in your opinion. Please be assured that your responses will be treated with a high degree of confidentiality, and will not affect your assessment.\r\n\r\nYour carefully considered responses will help us improve the way this unit is presented online in the future.\r\n\r\nThanks very much.\r\n', '37,38,39,40,41,42,43,44');\r
-INSERT INTO survey VALUES (4, 0, 0, 0, 985017600, 985017600, 'ATTLS (20 item version)', 'The purpose of this questionnaire is to help \r\nus evaluate your attitudes towards thinking and learning.\r\n', '65,67,68');\r
-# --------------------------------------------------------\r
+INSERT INTO `survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (1, 0, 0, 0, 985017600, 985017600, 'collesaname', 'collesaintro', '25,26,27,28,29,30,43,44');\r
+INSERT INTO `survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (2, 0, 0, 0, 985017600, 985017600, 'collespname', 'collespintro', '31,32,33,34,35,36,43,44');\r
+INSERT INTO `survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (3, 0, 0, 0, 985017600, 985017600, 'collesapname', 'collesapintro', '37,38,39,40,41,42,43,44');\r
+INSERT INTO `survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `questions`) VALUES (4, 0, 0, 0, 985017600, 985017600, 'attlsname', 'attlsintro', '65,67,68');\r
+\r
+\r
 \r
 #\r
 # Table structure for table `survey_analysis`\r
@@ -97,75 +98,73 @@ CREATE TABLE `survey_questions` (
 # Dumping data for table `survey_questions`\r
 #\r
 \r
-INSERT INTO `survey_questions` VALUES (1, 'my learning focuses on issues that interest me.', 'focus on interesting issues', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (2, 'what I learn is important for my professional practice.', 'important to my practice', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (3, 'I learn how to improve my professional practice.', 'improve my practice', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (4, 'what I learn connects well with my professional practice.', 'connects with my practice', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (5, 'I think critically about how I learn.', 'I\'m critical of my learning', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (6, 'I think critically about my own ideas.', 'I\'m critical of my own ideas', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (7, 'I think critically about other students\' ideas.', 'I\'m critical of other students', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (8, 'I think critically about ideas in the readings.', 'I\'m critical of readings', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (9, 'I explain my ideas to other students.', 'I explain my ideas', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (10, 'I ask other students to explain their ideas.', 'I ask for explanations', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (11, 'other students ask me to explain my ideas.', 'I\'m asked to explain', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (12, 'other students respond to my ideas.', 'students respond to me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (13, 'the tutor stimulates my thinking.', 'tutor stimulates thinking', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (14, 'the tutor encourages me to participate.', 'tutor encourages me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (15, 'the tutor models good discourse.', 'tutor models discourse', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (16, 'the tutor models critical self-reflection.', 'tutor models self-reflection', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (17, 'other students encourage my participation.', 'students encourage me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (18, 'other students praise my contribution.', 'students praise me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (19, 'other students value my contribution.', 'students value me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (20, 'other students empathise with my struggle to learn.', 'student empathise', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (21, 'I make good sense of other students\' messages.', 'I understand other students', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (22, 'other students make good sense of my messages.', 'students understand me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (23, 'I make good sense of the tutor\'s messages.', 'I understand the tutor', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (24, 'the tutor makes good sense of my messages.', 'tutor understands me', '', '', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r\n');\r
-INSERT INTO `survey_questions` VALUES (25, 'Relevance', 'Relevance', '1,2,3,4', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (26, 'Reflective Thinking', 'Reflective Thinking', '5,6,7,8', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (27, 'Interactivity', 'Interactivity', '9,10,11,12', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (28, 'Tutor Support', 'Tutor Support', '13,14,15,16', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (29, 'Peer Support', 'Peer Support', '17,18,19,20', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (30, 'Interpretation', 'Interpretation', '21,22,23,24', 'In this online unit...', 1, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (31, 'Relevance', 'Relevance', '1,2,3,4', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (32, 'Reflective Thinking', 'Reflective Thinking', '5,6,7,8', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (33, 'Interactivity', 'Interactivity', '9,10,11,12', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (34, 'Tutor Support', 'Tutor Support', '13,14,15,16', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (35, 'Peer Support', '', '17,18,19,20', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (36, 'Interpretation', '', '21,22,23,24', 'In this online unit, I prefer that...', 2, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (37, 'Relevance', '', '1,2,3,4', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (38, 'Reflective Thinking', '', '5,6,7,8', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (39, 'Interactivity', '', '9,10,11,12', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (40, 'Tutor Support', '', '13,14,15,16', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (41, 'Peer Support', '', '17,18,19,20', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (42, 'Interpretation', '', '21,22,23,24', 'In this online unit...', 3, 'Almost Never,Seldom,Sometimes,Often,Almost Always\r');\r
-INSERT INTO `survey_questions` VALUES (43, 'How long did this survey take you to complete?', '', '', '', 1, 'under 1 min,1-2 min,2-3 min,3-4 min,4-5-min,5-10 min,more than 10\r');\r
-INSERT INTO `survey_questions` VALUES (44, 'Do you have any other comments?', '', '', '', 0, '\r');\r
-INSERT INTO `survey_questions` VALUES (64, 'I spend time figuring out what\'s "wrong" with things. For example, I\'ll look for something in a literary interpretation that isn\'t argued well enough.', 'what\'s wrong?', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (58, 'I try to point out weaknesses in other people\'s thinking to help them clarify their arguments.', 'point out weaknesses', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (59, 'I tend to put myself in other people\'s shoes when discussing controversial issues, to see why they think the way they do.', 'put myself in their shoes', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (60, 'One could call my way of analysing things "putting them on trial" because I am careful to consider all the evidence.', 'putting on trial', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (61, 'I value the use of logic and reason over the incorporation of my own concerns when solving problems.', 'i value logic most', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (62, 'I can obtain insight into opinions that differ from mine through empathy.', 'insight from empathy', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (63, 'When I encounter people whose opinions seem alien to me, I make a deliberate effort to "extend" myself into that person, to try to see how they could have those opinions.', 'make effort to extend', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (56, 'I have certain criteria I use in evaluating arguments.', 'use criteria to evaluate', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (57, 'I\'m more likely to try to understand someone else\'s opinion that to try to evaluate it.', 'try to understand', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (55, 'I try to think with people instead of against them.', 'think WITH people', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (54, 'It\'s important for me to remain as objective as possible when I analyze something.', 'remain objective', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (53, 'I often find myself arguing with the authors of books that I read, trying to logically figure out why they\'re wrong.', 'argue with authors', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (52, 'I am always interested in knowing why people say and believe the things they do.', 'know why people do', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (51, 'I find that I can strengthen my own position through arguing with someone who disagrees with me.', 'strengthen by argue', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (50, 'I enjoy hearing the opinions of people who come from backgrounds different to mine - it helps me to understand how the same things can be seen in such different ways.', 'enjoy hearing opinions', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (49, 'I feel that the best way for me to achieve my own identity is to interact with a variety of other people.', 'interact with variety', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (48, 'The most important part of my education has been learning to understand people who are very different to me.', 'understand different people', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (47, 'I like to understand where other people are "coming from", what experiences have led them to feel the way they do.', 'where people come from', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (45, 'In evaluating what someone says, I focus on the quality of their argument, not on the person who\'s presenting it.', 'focus quality of argument', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (46, 'I like playing devil\'s advocate - arguing the opposite of what someone is saying.', 'play devil\'s advocate', '', '', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (65, 'Attitudes Towards Thinking and Learning', '', '45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64', 'In discussion ...', 1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (67, 'Connected Learning', '', '63,62,59,57,55,49,52,50,48,47', 'Connected knowers...', -1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-INSERT INTO `survey_questions` VALUES (68, 'Separate Learning', '', '46,54,45,51,60,53,56,58,61,64', 'Separate knowers...', -1, 'Strongly disagree,Somewhat disagree,Neither agree nor disagree,Somewhat agree,Strongly agree');\r
-\r
-    \r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (1, 'colles1', 'colles1short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (2, 'colles2', 'colles2short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (3, 'colles3', 'colles3short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (4, 'colles4', 'colles4short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (5, 'colles5', 'colles5short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (6, 'colles6', 'colles6short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (7, 'colles7', 'colles7short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (8, 'colles8', 'colles8short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (9, 'colles9', 'colles9short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (10, 'colles10', 'colles10short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (11, 'colles11', 'colles11short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (12, 'colles12', 'colles12short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (13, 'colles13', 'colles13short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (14, 'colles14', 'colles14short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (15, 'colles15', 'colles15short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (16, 'colles16', 'colles16short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (17, 'colles17', 'colles17short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (18, 'colles18', 'colles18short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (19, 'colles19', 'colles19short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (20, 'colles20', 'colles20short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (21, 'colles21', 'colles21short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (22, 'colles22', 'colles22short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (23, 'colles23', 'colles23short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (24, 'colles24', 'colles24short', '', '', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (25, 'collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (26, 'collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (27, 'collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (28, 'collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (29, 'collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (30, 'collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', 1, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (31, 'collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (32, 'collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (33, 'collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (34, 'collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (35, 'collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (36, 'collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', 2, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (37, 'collesm1', 'collesm1short', '1,2,3,4', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (38, 'collesm2', 'collesm2short', '5,6,7,8', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (39, 'collesm3', 'collesm3short', '9,10,11,12', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (40, 'collesm4', 'collesm4short', '13,14,15,16', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (41, 'collesm5', 'collesm5short', '17,18,19,20', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (42, 'collesm6', 'collesm6short', '21,22,23,24', 'collesmintro', 3, 'scaletimes5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (43, 'howlong', '', '', '', 1, 'howlongoptions');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (44, 'othercomments', '', '', '', 0, '');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (64, 'attls20', 'attls20short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (58, 'attls14', 'attls14short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (59, 'attls15', 'attls15short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (60, 'attls16', 'attls16short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (61, 'attls17', 'attls17short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (62, 'attls18', 'attls18short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (63, 'attls19', 'attls19short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (56, 'attls12', 'attls12short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (57, 'attls13', 'attls13short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (55, 'attls11', 'attls11short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (54, 'attls10', 'attls10short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (53, 'attls9', 'attls9short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (52, 'attls8', 'attls8short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (51, 'attls7', 'attls7short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (50, 'attls6', 'attls6short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (49, 'attls5', 'attls5short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (48, 'attls4', 'attls4short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (47, 'attls3', 'attls3short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (45, 'attls1', 'attls1short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (46, 'attls2', 'attls2short', '', '', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (65, 'attlsm1', 'attlsm1', '45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64', 'attlsmintro', 1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (67, 'attlsm2', 'attlsm2', '63,62,59,57,55,49,52,50,48,47', 'attlsmintro', -1, 'scaleagree5');\r
+INSERT INTO `survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (68, 'attlsm3', 'attlsm3', '46,54,45,51,60,53,56,58,61,64', 'attlsmintro', -1, 'scaleagree5');\r
 \r
 \r
 \r

diff --git a/mod/survey/details.php b/mod/survey/details.php
index 5f5dfb2..cd22066 100644 (file)
--- a/mod/survey/details.php
+++ b/mod/survey/details.php
@@ -42,7 +42,9 @@
                 if ($form->intro) {
                     p($form->intro);
                 } else {
-                    p(get_field("survey", "intro", "id", $form->template));
+                    $form->intro = get_field("survey", "intro", "id", $form->template);
+                    $form->intro = get_string($form->intro, "survey");
+                    p($form->intro);
                 }
                 ?></TEXTAREA>
             </TD>

diff --git a/mod/survey/download.php b/mod/survey/download.php
index dd8d6dd..8c90bdf 100644 (file)
--- a/mod/survey/download.php
+++ b/mod/survey/download.php
@@ -80,6 +80,12 @@
     $order     = explode(",", $fullorderlist);
     $questions = $fullquestions;
 
+//  Translate all the question texts
+
+    foreach ($questions as $key => $question) {
+        $questions[$key]->text = get_string($question->text, "survey");
+    }
+
 
 // Get and collate all the results in one big array
 

diff --git a/mod/survey/graph.php b/mod/survey/graph.php
index 254bcb9..b870408 100644 (file)
--- a/mod/survey/graph.php
+++ b/mod/survey/graph.php
@@ -28,11 +28,21 @@
         error("Survey ID was incorrect");
     }
 
+    $stractual = get_string("actual", "survey");
+    $stractualclass = get_string("actualclass", "survey");
+    $stractualstudent = get_string("actualstudent", "survey");
+
+    $strpreferred = get_string("preferred", "survey");
+    $strpreferredclass = get_string("preferredclass", "survey");
+    $strpreferredstudent = get_string("preferredstudent", "survey");
+
     switch ($type) {
 
      case "question.png":
 
        $question = get_record("survey_questions", "id", $qid);
+       $question->text = get_string($question->text, "survey");
+       $question->options = get_string($question->options, "survey");
   
        $options = explode(",",$question->options);
 
@@ -64,9 +74,9 @@
        $graph->x_data               = $options;
 
        $graph->y_data['answers1']   = $buckets1;
-       $graph->y_format['answers1'] = array('colour' => 'ltblue','bar' => 'fill','legend' =>'actual','bar_size' => 0.4);
+       $graph->y_format['answers1'] = array('colour' => 'ltblue','bar' => 'fill','legend' =>$stractual,'bar_size' => 0.4);
        $graph->y_data['answers2']   = $buckets2;
-       $graph->y_format['answers2'] = array('colour' =>'ltorange','bar' => 'fill','legend' =>'preferred','bar_size' => 0.2);
+       $graph->y_format['answers2'] = array('colour' =>'ltorange','bar' => 'fill','legend' =>$strpreferred,'bar_size' => 0.2);
 
        $graph->parameter['legend']        = 'outside-top';
        $graph->parameter['legend_border'] = 'black';
@@ -95,6 +105,8 @@
      case "multiquestion.png":
 
        $question  = get_record("survey_questions", "id", $qid);
+       $question->text = get_string($question->text, "survey");
+       $question->options = get_string($question->options, "survey");
 
        $options = explode(",",$question->options);
        $questionorder = explode( ",", $question->multi);
@@ -102,7 +114,7 @@
        $qqq = get_records_sql("SELECT * FROM survey_questions WHERE id in ($question->multi)");
 
        foreach ($questionorder as $i => $val) {
-           $names[$i] = $qqq["$val"]->shorttext;
+           $names[$i] = get_string($qqq["$val"]->shorttext, "survey");
            $buckets1[$i] = 0;
            $buckets2[$i] = 0;
            $count1[$i] = 0;
@@ -168,10 +180,10 @@
        $graph->x_data               = $names;
        $graph->y_data['answers1']   = $buckets1;
        $graph->y_format['answers1'] = array('colour' => 'ltblue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 4, 'legend' => 'actual');
+                                            'shadow_offset' => 4, 'legend' => $stractual);
        $graph->y_data['answers2']   = $buckets2;
        $graph->y_format['answers2'] = array('colour' => 'ltorange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 4, 'legend' => 'preferred');
+                                                'shadow_offset' => 4, 'legend' => $strpreferred);
        $graph->y_data['stdev1']   = $stdev1;
        $graph->y_format['stdev1'] = array('colour' => 'ltltblue', 'bar' => 'fill', 
                                             'shadow_offset' => '4', 'legend' => 'none', 'bar_size' => 0.3);
@@ -213,7 +225,9 @@
 
        $qqq = get_records_sql("SELECT * FROM survey_questions WHERE id in ($survey->questions) AND multi <> ''");
 
-       foreach ($qqq as $qq) {
+       foreach ($qqq as $key => $qq) {
+           $qqq[$key]->text = get_string($qq->text, "survey");
+           $qqq[$key]->options = get_string($qq->options, "survey");
            if ($qq->type < 0) {
                $virtualscales = true;
            }
@@ -294,10 +308,10 @@
 
        $graph->y_data['answers1']   = $buckets1;
        $graph->y_format['answers1'] = array('colour' => 'ltblue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 4, 'legend' => 'actual');
+                                            'shadow_offset' => 4, 'legend' => $stractual);
        $graph->y_data['answers2']   = $buckets2;
        $graph->y_format['answers2'] = array('colour' => 'ltorange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 4, 'legend' => 'preferred');
+                                                'shadow_offset' => 4, 'legend' => $strpreferred);
 
        $graph->y_data['stdev1']   = $stdev1;
        $graph->y_format['stdev1'] = array('colour' => 'ltltblue', 'bar' => 'fill', 
@@ -338,7 +352,9 @@
 
        $qqq = get_records_sql("SELECT * FROM survey_questions WHERE id in ($survey->questions) AND multi <> ''");
 
-       foreach ($qqq as $qq) {
+       foreach ($qqq as $key => $qq) {
+           $qqq[$key]->text = get_string($qq->text, "survey");
+           $qqq[$key]->options = get_string($qq->options, "survey");
            if ($qq->type < 0) {
                $virtualscales = true;
            }
@@ -439,16 +455,16 @@
 
        $graph->y_data['answers1']   = $buckets1;
        $graph->y_format['answers1'] = array('colour' => 'ltblue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 0.1, 'legend' => 'class actual');
+                                            'shadow_offset' => 0.1, 'legend' => $stractualclass);
        $graph->y_data['answers2']   = $buckets2;
        $graph->y_format['answers2'] = array('colour' => 'ltorange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 0.1, 'legend' => 'class preferred');
+                                                'shadow_offset' => 0.1, 'legend' => $strpreferredclass);
        $graph->y_data['studanswers1']   = $studbuckets1;
        $graph->y_format['studanswers1'] = array('colour' => 'blue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 4, 'legend' => 'student actual');
+                                            'shadow_offset' => 4, 'legend' => $stractualstudent);
        $graph->y_data['studanswers2']   = $studbuckets2;
        $graph->y_format['studanswers2'] = array('colour' => 'orange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 4, 'legend' => 'student preferred');
+                                                'shadow_offset' => 4, 'legend' => $strpreferredstudent);
        $graph->y_data['stdev1']   = $stdev1;
        $graph->y_format['stdev1'] = array('colour' => 'ltltblue', 'bar' => 'fill', 
                                             'shadow_offset' => 0.1, 'legend' => 'none', 'bar_size' => 0.3);
@@ -488,6 +504,8 @@
      case "studentmultiquestion.png":
 
        $question  = get_record("survey_questions", "id", $qid);
+       $question->text = get_string($question->text, "survey");
+       $question->options = get_string($question->options, "survey");
 
        $options = explode(",",$question->options);
        $questionorder = explode( ",", $question->multi);
@@ -495,7 +513,7 @@
        $qqq = get_records_sql("SELECT * FROM survey_questions WHERE id in ($question->multi)");
 
        foreach ($questionorder as $i => $val) {
-           $names[$i] = $qqq[$val]->shorttext;
+           $names[$i] = get_string($qqq[$val]->shorttext, "survey");
            $buckets1[$i] = 0;
            $buckets2[$i] = 0;
            $count1[$i] = 0;
@@ -583,16 +601,16 @@
        $graph->x_data               = $names;
        $graph->y_data['answers1']   = $buckets1;
        $graph->y_format['answers1'] = array('colour' => 'ltblue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 0.1, 'legend' => 'class actual');
+                                            'shadow_offset' => 0.1, 'legend' => $stractualclass);
        $graph->y_data['answers2']   = $buckets2;
        $graph->y_format['answers2'] = array('colour' => 'ltorange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 0.1, 'legend' => 'class preferred');
+                                                'shadow_offset' => 0.1, 'legend' => $strpreferredclass);
        $graph->y_data['studanswers1']   = $studbuckets1;
        $graph->y_format['studanswers1'] = array('colour' => 'blue', 'line' => 'line',  'point' => 'square', 
-                                            'shadow_offset' => 4, 'legend' => 'student actual');
+                                            'shadow_offset' => 4, 'legend' => $stractualstudent);
        $graph->y_data['studanswers2']   = $studbuckets2;
        $graph->y_format['studanswers2'] = array('colour' => 'orange', 'line' => 'line', 'point' => 'square', 
-                                                'shadow_offset' => 4, 'legend' => 'student preferred');
+                                                'shadow_offset' => 4, 'legend' => $strpreferredstudent);
        $graph->y_data['stdev1']   = $stdev1;
        $graph->y_format['stdev1'] = array('colour' => 'ltltblue', 'bar' => 'fill', 
                                             'shadow_offset' => 0.1, 'legend' => 'none', 'bar_size' => 0.3);

diff --git a/mod/survey/lib.php b/mod/survey/lib.php
index b14c218..d166b4e 100644 (file)
--- a/mod/survey/lib.php
+++ b/mod/survey/lib.php
@@ -255,6 +255,10 @@ function survey_print_multi($question) {
         $qnum++;
         $bgcolor = survey_question_color($qnum);
 
+        if ($q->text) {
+            $q->text = get_string($q->text, "survey");
+        }
+
         echo "<TR BGCOLOR=$bgcolor>";
         if ($oneanswer) {
             echo "<TD WIDTH=10 VALIGN=top><P><B>$qnum</B></P></TD>";
@@ -322,7 +326,7 @@ function survey_print_single($question) {
 
     } else if ($question->type < 0) {     // Choose several of a number
         $options = explode( ",", $question->options);
-        echo "<P>THIS TYPE OF QUESTION NOT SUPPORTED YET</P>";
+        notify("This question type not supported yet");
     }
 
     echo "</FONT></TD></TR></TABLE>";

diff --git a/mod/survey/mod.html b/mod/survey/mod.html
index c5b6a30..f61014f 100644 (file)
--- a/mod/survey/mod.html
+++ b/mod/survey/mod.html
@@ -11,6 +11,9 @@
     <td>
     <?
         if ($options = get_records_sql_menu("SELECT id, name FROM survey WHERE template='0'")) {
+            foreach ($options as $id => $name) {
+                $options[$id] = get_string($name, "survey");
+            }
             choose_from_menu($options, "template", $form->template);
             helpbutton("surveys", get_string("helpsurveys", "survey"));
         } else {

diff --git a/mod/survey/report.php b/mod/survey/report.php
index 8032566..00cb98b 100644 (file)
--- a/mod/survey/report.php
+++ b/mod/survey/report.php
@@ -201,7 +201,7 @@
             error("Question doesn't exist");
         }
 
-        $answers =  explode(",", $question->options);
+        $answers =  explode(",", get_string($question->options, "survey"));
 
         print_header("$survey->name: $strquestion", "$strquestion: $question->text");
 

diff --git a/mod/survey/version.php b/mod/survey/version.php
index 82e3d40..9a764ed 100644 (file)
--- a/mod/survey/version.php
+++ b/mod/survey/version.php
@@ -5,7 +5,7 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->version  = 2002082000;
+$module->version  = 2002110903;
 $module->cron     = 0;
 
 ?>

diff --git a/mod/survey/view.php b/mod/survey/view.php
index 16a9aed..6c019c1 100644 (file)
--- a/mod/survey/view.php
+++ b/mod/survey/view.php
@@ -73,6 +73,19 @@
         $question->id = $val;
         
         if ($question->type > 0) {
+            if ($question->text) {
+                $question->text = get_string($question->text, "survey");
+            }
+            if ($question->shorttext) {
+                $question->shorttext = get_string($question->shorttext, "survey");
+            }
+            if ($question->intro) {
+                $question->intro = get_string($question->intro, "survey");
+            }
+            if ($question->options) {
+                $question->options = get_string($question->options, "survey");
+            }
+
             if ($question->multi) {
                 survey_print_multi($question);
             } else {
@@ -81,16 +94,10 @@
         }
     }
 
-
-// End the survey page
-   echo "<CENTER><P>&nbsp;</P><P>";
-   if ($ownerpreview) {
-       echo "(Because this is only a preview, the button below will not send data)<BR>\n";
-       echo "<FONT SIZE=+1><INPUT TYPE=submit VALUE=\"Click here to go back\"></FONT>";
-   } else {
-       echo "\n";
 ?>
 
+<CENTER>
+<BR>
 <SCRIPT>
 <!-- // BEGIN
 function checkform() {
@@ -104,24 +111,25 @@ function checkform() {
     }
 
     if (error) {
-        alert("Some of the multiple choice questions have not been answered.");
+        alert("<?PHP print_string("questionsnotanswered", "survey") ?>");
     } else {
         document.form.submit();
     }
 }
 
-document.write('<INPUT TYPE="button" VALUE="Click here to check and continue" onClick="checkform()">');
+<?PHP echo "document.write('<INPUT TYPE=button VALUE=\"".get_string("clicktocontinuecheck", "survey")."\" onClick=\"checkform()\">');";  ?>
 
 // END -->
 </SCRIPT>
 
 <NOSCRIPT>
     <!-- Without Javascript, no checking is done -->
-    <INPUT TYPE="submit" VALUE="Click here to continue">
+    <INPUT TYPE="submit" VALUE="<? get_string("clicktocontinue", "survey") ?>">
 </NOSCRIPT>
-<?
 
-   }
+</CENTER>
+
+<?
    echo "</FORM>";
 
    print_footer($course);