1 # sql file for gradebook module
\r
3 CREATE TABLE `grade_scales` (
\r
4 `grade_scale_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
\r
5 `member_id` mediumint(8) unsigned NOT NULL default '0',
\r
6 `scale_name` VARCHAR(255) NOT NULL ,
\r
7 `created_date` datetime NOT NULL default '0000-00-00 00:00:00',
\r
8 PRIMARY KEY ( `grade_scale_id` )
\r
11 CREATE TABLE `grade_scales_detail` (
\r
12 `grade_scale_id` mediumint(8) unsigned NOT NULL,
\r
13 `scale_value` VARCHAR(50) NOT NULL ,
\r
14 `percentage_from` MEDIUMINT NOT NULL default '0',
\r
15 `percentage_to` MEDIUMINT NOT NULL default '0',
\r
16 PRIMARY KEY (`grade_scale_id`, `scale_value`)
\r
19 CREATE TABLE `gradebook_tests` (
\r
20 `gradebook_test_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
\r
21 `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Values: 0, tests.test_id or assignments.assignment_id. 0 for external tests/assignments. tests.test_id for ATutor tests, assignments.assignment_id for ATutor assignments.',
\r
22 `type` VARCHAR(50) NOT NULL default '' COMMENT 'Values: ATutor Test, ATutor Assignment, External',
\r
23 `course_id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Values: 0 or courses.course_id. Only has value for external tests/assignments. When ATutor internal assignments/tests/surveys, always 0.',
\r
24 `title` VARCHAR(255) NOT NULL COMMENT 'Values: Null or test name. Always null if ATutor internal assignments/tests/surveys.',
\r
25 `due_date` datetime NOT NULL default '0000-00-00 00:00:00',
\r
26 `grade_scale_id` mediumint(8) unsigned NOT NULL default '0',
\r
27 PRIMARY KEY ( `gradebook_test_id` )
\r
30 CREATE TABLE `gradebook_detail` (
\r
31 `gradebook_test_id` mediumint(8) unsigned NOT NULL,
\r
32 `member_id` mediumint(8) unsigned NOT NULL default '0',
\r
33 `grade` VARCHAR(255) NOT NULL,
\r
34 PRIMARY KEY (`gradebook_test_id`, `member_id`)
\r
37 INSERT INTO `grade_scales` (grade_scale_id, member_id, scale_name, created_date) values (1, 0, 'Letter Grade', now());
\r
38 INSERT INTO `grade_scales` (grade_scale_id, member_id, scale_name, created_date) values (2, 0, 'Competency 1', now());
\r
39 INSERT INTO `grade_scales` (grade_scale_id, member_id, scale_name, created_date) values (3, 0, 'Competency 2', now());
\r
41 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'A+', 90, 100);
\r
42 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'A', 80, 89);
\r
43 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'B', 70, 79);
\r
44 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'C', 60, 69);
\r
45 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'D', 50, 59);
\r
46 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (1, 'E', 0, 49);
\r
48 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (2, 'Pass', 75, 100);
\r
49 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (2, 'Fail', 0, 74);
\r
51 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (3, 'Excellent', 80, 100);
\r
52 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (3, 'Good', 70, 79);
\r
53 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (3, 'Adequate', 60, 69);
\r
54 INSERT INTO `grade_scales_detail` (grade_scale_id, scale_value, percentage_from, percentage_to) values (3, 'Inadequate', 0, 59);
\r
57 INSERT INTO `language_text` VALUES ('en', '_module','gradebook','Gradebook',NOW(),'gradebook');
\r
58 INSERT INTO `language_text` VALUES ('en', '_template','grade_scale','Grade Scale',NOW(),'gradebook');
\r
59 INSERT INTO `language_text` VALUES ('en', '_template','add_grade_scale','Add Grade Scale',NOW(),'gradebook');
\r
60 INSERT INTO `language_text` VALUES ('en', '_template','edit_grade_scale','Edit Grade Scale',NOW(),'gradebook');
\r
61 INSERT INTO `language_text` VALUES ('en', '_template','delete_grade_scale','Delete Grade Scale',NOW(),'gradebook');
\r
62 INSERT INTO `language_text` VALUES ('en', '_template','custom_grade_scale','Custom Grade Scale',NOW(),'gradebook');
\r
63 INSERT INTO `language_text` VALUES ('en', '_template','preset_grade_scale','Preset Grade Scale',NOW(),'gradebook');
\r
64 INSERT INTO `language_text` VALUES ('en', '_template','custom','Custom',NOW(),'gradebook');
\r
65 INSERT INTO `language_text` VALUES ('en', '_template','scale','Scale',NOW(),'gradebook');
\r
66 INSERT INTO `language_text` VALUES ('en', '_template','scale_value','Scale Value',NOW(),'gradebook');
\r
67 INSERT INTO `language_text` VALUES ('en', '_template','percentage_from','Percentage From',NOW(),'gradebook');
\r
68 INSERT INTO `language_text` VALUES ('en', '_template','percentage_to','Percentage To',NOW(),'gradebook');
\r
69 INSERT INTO `language_text` VALUES ('en', '_template','scale','Scale',NOW(),'gradebook');
\r
70 INSERT INTO `language_text` VALUES ('en', '_template','grade','Grade',NOW(),'gradebook');
\r
71 INSERT INTO `language_text` VALUES ('en', '_template','edit_marks','Edit Marks',NOW(),'gradebook');
\r
72 INSERT INTO `language_text` VALUES ('en', '_template','add_tests','Add Tests/Assignments',NOW(),'gradebook');
\r
73 INSERT INTO `language_text` VALUES ('en', '_template','edit_tests','Edit Tests/Assignments',NOW(),'gradebook');
\r
74 INSERT INTO `language_text` VALUES ('en', '_template','add_atutor_test','Add ATutor Assignments/Test/Surveys',NOW(),'gradebook');
\r
75 INSERT INTO `language_text` VALUES ('en', '_template','add_external_test','Add External Assignments/Tests',NOW(),'gradebook');
\r
76 INSERT INTO `language_text` VALUES ('en', '_template','all_atutor_tests','All Applicable ATutor Tests & Surveys',NOW(),'gradebook');
\r
77 INSERT INTO `language_text` VALUES ('en', '_template','all_atutor_assignments','All ATutor Assignments',NOW(),'gradebook');
\r
78 INSERT INTO `language_text` VALUES ('en', '_template','add_atutor_test_info','Select from the available test and assignment titles, then optionally choose a "Grade Scale", to add a test or assignment to the gradebook. . If "Grade Scale" is set to none, the raw final score will be used in place of a grade scale. Only tests with the test property "Attempts Allowed" set to 1 can be added to the Gradebook. Create tests using the ATutor Tests & Surveys Manager',NOW(),'gradebook');
\r
79 INSERT INTO `language_text` VALUES ('en', '_template','raw_final_score','Raw Final Score',NOW(),'gradebook');
\r
80 INSERT INTO `language_text` VALUES ('en', '_template','update_gradebook','Update ATutor Marks',NOW(),'gradebook');
\r
81 INSERT INTO `language_text` VALUES ('en', '_template','import_export_external_marks','External Marks',NOW(),'gradebook');
\r
82 INSERT INTO `language_text` VALUES ('en', '_template','export_marks_info','To simplify the import process, you can export an empty csv file on the test you want to import, fill in the marks, import back into ATutor.',NOW(),'gradebook');
\r
83 INSERT INTO `language_text` VALUES ('en', '_template','import_marks_info','A mark list may be imported into ATutor. Create the mark list in a comma separated values (CSV) format as follows: "firstname", "lastname", "email", "mark" with one student per line. Please leave the first line as title. The mark in CSV file can be grade or percentage like 50%%. To simplify the process, you can export the CSV file with export functionality, update the marks into exported file and import back into ATutor.',NOW(),'gradebook');
\r
84 INSERT INTO `language_text` VALUES ('en', '_template','student_not_exists','Student not exists',NOW(),'gradebook');
\r
85 INSERT INTO `language_text` VALUES ('en', '_template','empty_gradebook','Gradebook is empty.',NOW(),'gradebook');
\r
86 INSERT INTO `language_text` VALUES ('en', '_template','completed_date','Completed Date',NOW(),'gradebook');
\r
87 INSERT INTO `language_text` VALUES ('en', '_template','your_mark','Your Mark',NOW(),'gradebook');
\r
88 INSERT INTO `language_text` VALUES ('en', '_template','class_avg','Class Avg',NOW(),'gradebook');
\r
89 INSERT INTO `language_text` VALUES ('en', '_template','completed','Completed',NOW(),'gradebook');
\r
90 INSERT INTO `language_text` VALUES ('en', '_template','external_tests','External Tests',NOW(),'gradebook');
\r
91 INSERT INTO `language_text` VALUES ('en', '_template','grade_already_exists','Conflict: Grade already exists - %s',NOW(),'gradebook');
\r
92 INSERT INTO `language_text` VALUES ('en', '_template','how_to_solve_conflict','How to solve conflict',NOW(),'gradebook');
\r
93 INSERT INTO `language_text` VALUES ('en', '_template','use_higher_grade','Use higher grade',NOW(),'gradebook');
\r
94 INSERT INTO `language_text` VALUES ('en', '_template','use_lower_grade','Use lower grade',NOW(),'gradebook');
\r
95 INSERT INTO `language_text` VALUES ('en', '_template','not_overwrite','Not overwrite',NOW(),'gradebook');
\r
96 INSERT INTO `language_text` VALUES ('en', '_template','grades_uncomparable','Grades are uncomparable. Choose another way to solve conflict',NOW(),'gradebook');
\r
97 INSERT INTO `language_text` VALUES ('en', '_template','combine_tests','Combine ATutor Tests',NOW(),'gradebook');
\r
98 INSERT INTO `language_text` VALUES ('en', '_template','combine','Combine',NOW(),'gradebook');
\r
99 INSERT INTO `language_text` VALUES ('en', '_template','combine_into','Combine Into',NOW(),'gradebook');
\r
100 INSERT INTO `language_text` VALUES ('en', '_template','combine_from','Combine From',NOW(),'gradebook');
\r
101 INSERT INTO `language_text` VALUES ('en', '_template','combine_tests_info','Before combining tests, please run section above to update marks of "Combine Into Test/Survey."',NOW(),'gradebook');
\r
102 INSERT INTO `language_text` VALUES ('en', '_template','grade_info','Note: "Grade" field can be grade defined in "Grade Scale" or percentage like 50%%.',NOW(),'gradebook');
\r
103 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_CONFIRM_DELETE_GRADE_SCALE','Are you sure you want to <strong>delete</strong> grade scale <strong>%s</strong>?',NOW(),'gradebook');
\r
104 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_CONFIRM_DELETE_TEST_FROM_GRADEBOOK','Are you sure you want to <strong>delete</strong> test <strong>%s</strong> from gradebook?',NOW(),'gradebook');
\r
105 INSERT INTO `language_text` VALUES ('en', '_msgs', 'AT_FEEDBACK_ADD_TEST_INTO_GRADEBOOK', '"<strong>%1$s</strong>" cannot be added into gradebook because the following students have taken it more than once:<br />\r\n%2$s.',NOW(),'gradebook');
\r
106 INSERT INTO `language_text` VALUES ('en', '_msgs', 'AT_ERROR_COMBINE_TESTS', '"<strong>%1$s</strong>" cannot be combined because the following students have taken it more than once:<br />\r\n%2$s.',NOW(),'gradebook');
\r
107 INSERT INTO `language_text` VALUES ('en', '_msgs', 'AT_FEEDBACK_UPDATE_GRADEBOOK', '"<strong>%1$s</strong>" cannot be updated into gradebook because the following students have taken it more than once:<br />\r\n%2$s.',NOW(),'gradebook');
\r
108 INSERT INTO `language_text` VALUES ('en', '_msgs', 'AT_FEEDBACK_GRADEBOOK_UPDATED', 'The following grades have been successfully updated into gradebook: <ul> %s </ul>',NOW(),'gradebook');
\r
projects / atutor.git / blob