Date:       user_id:22
Call  sp_students_promote ('','','','22')
Date:       user_id:22
Call  sp_students_promote ('','','','22')
Date:2022-07-31 23:26:47       user_id:22
Call  sp_students_promote ('','41','42','22')
Date:2022-07-31 23:27:27       user_id:22
Call  sp_students_promote ('','41','42','22')
Date:2022-07-31 23:33:35       user_id:22
Call  sp_students_promote ('MOA-750','41','42','22')
Call  sp_student_changestatus ('MOA-751','','','2022-08-01','22')
Call  sp_student_changestatus ('MOA-751','','','2022-08-01','22')
Call  sp_student_changestatus ('MOA-756','5','waaa','2022-08-01','22')
Call  sp_student_graduation ('MOA-752','22')
Call  sp_student_graduation ('MOA-752','22')
Call  sp_student_changestatus ('MOA-752','2','galad','2022-08-01','22')
Call sp_add_class('0','Grade 1's','2','Crash Course','English','Galab','1','1','22')
Call sp_add_class('0','Grade 1','2','Crash Course','Arabic','Galab','1','1','22')
Call sp_add_class('1','Grade 8','17','Normal','English','Subax','1,2,3','1','22')
Call sp_add_class('1','Grade 8','17','Normal','English','Subax','1,2,3,4','1','22')
Call sp_add_class('1','Grade 8','17','Normal','English','Subax','1,2,3','1','22')
Call sp_add_class('1','Grade 8','17','Normal','English','Subax','1,2,3,4','1','22')
Call sp_add_subject_group('0','ABIAWAL','','9,10','2','16','59')
Call sp_add_subject_group('0','ABIAWAL','','10,11,12','1','16','30')
Call sp_add_subject_group('9','ABIAWAL','','10,11,12','1','16','30')
Call sp_add_subject_group('9','ABIAWAL','','10,11,12','1,2','16','30')
call sp_add_lesson('9','1','0','Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,3','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','3','0','Lesson 1','33','22','30')
call sp_add_lesson('9','3','4','Lesson 1','33','22','30')
call sp_add_lesson('9','3','4','Lesson 1','33','22','30')
call sp_add_lesson('9','3','4','Lesson 1','33','22','30')
call sp_add_lesson('9','3','4','Lesson 1','33','22','30')
call sp_add_lesson('9','3','4','Lesson 1','33','22','30')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','3',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','3',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','3',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
CALL sp_import_topics  ('30','9','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','22')
call sp_add_lesson('9','1','1,2,0','Lesson 1,Lesson 2,Lesson 1','17','22','30')
call sp_add_lesson('9','1','1,2,0','Lesson 1,Lesson 2,Lesson 3','17','22','30')
call sp_add_lesson('9','1','0','Lesson 1','17','22','30')
call sp_add_lesson('9','1','0','Lesson 2','','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17,33','22','30')
call sp_add_lesson('9','1','1,2','Lesson 1,Lesson 2','17','22','60')
call sp_add_lesson('9','1','0','Lesson 1','17','22','60')
CALL sp_import_topics  ('60','10','1',
         'Lesson 1','Introduction','define ition','','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','81')
CALL sp_import_topics  ('60','2','9',
         'Unit one: never forget','Reading comprehension\nVocabulary study poem\n','Discuss the subject matter in a poem\nDescribe the rhyme scheme of the poem\nIdentify other sound patterns in the poem\n','\n\n\nEnglish bk4\n','N/A','Audio ',
        ' N/A',
         '','2022-08-01','2022-08-13','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit one: never forget','Essay writing \nGrammar  (practice exercise)\n','Write a descriptive essay.\nDemonstrate the ability to use correct tense and verb forms\nUse vocabulary appropriately.\n','\n\n\nEnglish bk4\n','Assignment one','',
        ' ',
         '','2022-08-13','2022-08-20','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit two: oral presentation','Listening and speaking (pronunciation)\n\nOral presentation\n','Identify different speech sounds\nWrite another word that is pronounced the same way.\nDefine oral presentation\nPrepare and present\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-08-20','2022-08-31','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit two: oral presentation','Reading comprehension passage\nvocabulary\n\n','� Answer comprehension questions\n� Explain the meaning of lexical words used in the text\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2023-08-20','2023-08-31','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit two: oral presentation','Grammar \nListening and speaking\n','Practice exercise\nCorrect tense of the verbs\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-09-01','2022-09-08','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit two: oral presentation','Writing \n\nsynopsis\n','� Define synopsis\n� Write synopsis\n','\n\n\nEnglish bk4\n','Assignment two','',
        ' ',
         '','2022-09-10','2022-09-15','','114')
CALL sp_import_topics  ('60','2','9',
         'Monthly one exam','Monthly one exam','','','','',
        ' ',
         '','2022-09-17','2022-09-22','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit three: a colossal house','Listening and speaking (turn taking)\n\nReading comprehension (colossal house)\nGrammar \n(Subordinating conjunctions)\nVocabulary\n','','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-09-24','2022-09-29','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit three: a colossal house','Proverbs\nWriting\n','� Define proverb\n� Explain the me\n','\n\n\nEnglish bk4\n','Assignment three','',
        ' ',
         '','2022-10-01','2022-10-06','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit four: poetry guide','Poetry terms\nStructure of a poem\nRhythm in poetry\nAssonance in poetry\nFigurative language in a poem\n','Define poetry terms\nIdentify structure, subject and subject matter of a poem\n Define rhythm\n \n\nDefine assonance\nDescribe assonance in the poem\ndefine figurative languages\nidentify styles used as figurative in a poem\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-10-08','2022-10-13','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit four: poetry guide','Adjectives for tone in poetry\nMood, attitude and tone in poetry\nGlossary terms\n',' Identify examples of adjective words as tone in poetry\n Differentiate mood, tone and attitude\nDefine all the terms used in a poem\n','\n\n\nEnglish bk4\n','Assignment four','',
        ' ',
         '','2022-10-15','2022-10-20','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit five: The lion with a thorn in his paw','Listening and speaking (proverbs)\nPoetry about society\nReading (the lion with a thorn in his paw)\n','Participate in discussions\nIdentify the subject matter of the poem\nMood of the poem\nDescribe the tone of the persona\nExplain the meaning of words used in the poem\nAnswer comprehensio\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-10-22','2022-10-27','','114')
CALL sp_import_topics  ('60','2','9',
         'Monthly two exam','Monthly two exam','','','','',
        ' ',
         '','2022-10-29','2022-11-03','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit five: The lion with a thorn in his paw','Vocabulary \nGrammar (gerund)\nWriting. summary of a passage.\n\n','Explain the meaning of words used\nDifferentiate gerund and infinitive verb\nApply correct gerund or infinitive\nOrganize ideas in a logical sequence\nSummarize a story read\n','\n\n\nEnglish bk4\n','Assignment five','',
        ' ',
         '','2022-11-05','2022-11-10','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit six: oral literature','Listening and speaking (silent letters)\nReading (why the hen scratches the ground)\n\nVocabulary\n\n','Identify silent letters\nPronounce selected words with silent letters correctly\nAnswer comprehension questions\nExplain the meaning of words \nCorrect sentences with logical meaning\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-11-12','2022-11-17','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit six: oral literature','Narratives (hare and hyena ','Identify and illustrate features of oral narratives used in the narrative ','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-11-19','2022-11-24','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit six: oral literature','Grammar. ArticlesPlural form of nouns\nWriting aletter\n','Use appropriate articles\nFill in the blanks with the correct plural form of nouns\nWrite a formal letter\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2022-11-26','2022-12-01','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit seven: the father and his son','Listening and speaking (minute talk preparation)\nReading comprehension\nWords and phrases\nPractice exercise \n','i. Identify the factor that hinder effective listening\nii. Prepare and a present a speech\nDemonstrate use of courteous language\nAnswer comprehension questions\nMatch words and phrases with correct definitions\nWrite expository essay\n','\n\n\nEnglish bk4\n','Assignment seven','',
        ' ',
         '','2022-12-03','2022-12-08','','114')
CALL sp_import_topics  ('60','2','9',
         'Mid-term exam','Mid-term exam','','','','',
        ' ',
         '','2022-12-10','2022-12-15','','114')
CALL sp_import_topics  ('60','2','9',
         'Holidays','Holidays','','','','',
        ' ',
         '','2022-12-16','2022-12-31','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit 8\nEdible soda\n','� Listening speaking(dialogue)\n� Pronunciation (silent letters)\n','� Conduct telephone conversation\n� Demonstrative use of nonverbal cues that enhance speaking\n� Identify silent letters in given words and pronounce them correctly\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','2023-01-01','2023-01-05','','114')
CALL sp_import_topics  ('60','2','9',
         'Unit 8\nEdible soda\n','� Comprehension passage (edible soda)\n\n� Word stress\n� Oral poetry\n� letter writing (apology ) \n','*Answer the comprehension question\n*Demonstrate good use of stress\n*Read a poem and answer questions\n*Use correct format  in letter writing\n','\n\n\nEnglish bk4\n','','',
        ' ',
         '','1969-12-31','1969-12-31','','114')
call sp_add_lesson('2','9','1,2,3,4,5,6,7,8,9,10,11,12','Unit one: never forget,Unit two: oral presentation,Monthly one exam,Unit three: a colossal house,Unit four: poetry guide,Unit five: The lion with a thorn in his paw,Monthly two exam,Unit six: oral literature,Unit seven: the father and his son,Mid-term exam,Holidays,Unit 8Edible soda','27','69','60')
CALL sp_import_topics  ('60','1','3',
         'Chapter one: Numbers','1) Reading numbers to hundred million\n2) Reading numbers to one hundred million\n','By the end of this week the students should be able to:\n1) By the end of this week the students should be able to: Recognize the place value of numbers to one hundred million\n2)  Read the whole numbers to 0ne hundred million\n','C4 Moasser','','',
        ' ',
         '','2022-08-06','2022-08-11','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter one: Numbers','Writing numbers to one hundred million in fugures or in words','1) Write the whole numbers to one hundred million in figures\nWrite numbers in words\n','C4 Moasser','','',
        ' ',
         '','2022-08-13','2022-08-18','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','Total value \nAddition and subtraction \n','1) Recognize the total value of numbers to one hundred million\n2) Add 8-digit numbers to 8-digit numbers with carrying\nSubtract  8-digit numbers from 8-digit numbers with borrowing\n','C4 Moasser','','',
        ' ',
         '','2022-08-20','2022-08-25','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','1)Multiplication table\n2)Multiplying numbers to 4 digit numbers\n3) Dividing by 2-digit numbers\n','1) Memorize multiplication table up to 10\n2) Multiplying numbers up to 4-digit numbers by 4-digit numbers\n3) Dividing numbers by 1-digit number\n4) Dividing numbers by a 2-digit numbers\n','C4 Moasser','Assingment one','',
        ' ',
         '','2022-08-27','2022-09-01','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','1) Natural numbers\n2) Even numbers\n3) Odd numbers\n4) prime numbers\n5) composite numbers\n6) divisibility test by two \n7) Divisibility test by 3\n8) divisibility test by 4\n','1) Recognize natural numbers\n2) Recognize even numbers \n3) Recognize odd numbers\n4) recognize the prime numbers\n5) Recognize composite numbers\n6) Identify the divisibility test by 2\n7) Identify divisibility test by 3\n8) Identify the divisibility test by 4\n','C4 Moasser','Assingment one group discussion','',
        ' ',
         '','2022-09-03','2022-09-08','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         '','1) divisibility test by 5 \n2) Divisibility test by 6\n3) divisibility test by 8\n4) divisibility test by 9\n5) Divisibility test by 10\n','1) Identify the divisibility test by 5\n2) Identify the divisibility test by 6\n3) Identify divisibility test by  8\n4) Identify divisibility test by  9\n5)  Identify divisibility test by 10\n','','','',
        ' ',
         '','2022-09-10','2022-09-15','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly one exam','','','','','',
        ' ',
         '','2022-09-17','2022-09-22','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter four: G.C.D and L.C.M','1) Factors\n2) Common factors\n3) LCM\n','1) Factorize the a given number\n2) Find greatest common divisor\n3) Find the multiples\n4) Find the least common multiple of two given numbers\n5) Find the least common multiple of three given numbers\n\n','','Assigment two','',
        ' ',
         '','2022-09-24','2022-09-29','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Meaning of fraction\n2) types of fractions\n3) conversion of fractions \n4) Equivalent fractions\n','1) Identify fractions using shaded and unshaded part\n2) Recognize types of fractions\n3) Convert mixed number into improper fraction\n4) Convert improper fraction into mixed number \n5) Recognize two equivalent fractions\n','','Assigment one and two test','',
        ' ',
         '','2022-10-01','2022-10-06','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Comparing fractions\n2) simplifying fractions\n','1) Compare two fractions(Comparing and ordering fractions)\n2) simplify fractions\n','','','',
        ' ',
         '','2022-10-08','2022-10-13','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Adding two fractions\n2) Subtracting two fractions\n','1) Add two fractions\n2) subtract two fractions\n','','Assingment three','',
        ' ',
         '','2022-10-15','2022-10-20','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Multiplying two fractions\n2) Reciprocal of fractions\n3) Dividing fractions\n','1) Multiply two fractions\n2) Find the reciprocal of a fraction\n3) Divide two fractions\n','','Assingment three group discussion','',
        ' ',
         '','2022-10-22','2022-10-27','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly two exam','','','','','',
        ' ',
         '','2022-10-29','2022-11-03','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Six: sets','1) What is a set?\n2)Mathematical expression of a set-3) representing sets by venn diagram\n','1) Describe the meaning of a set\n2) express mathematically a given set\n3) represent given sets by venn diagram\n','','','',
        ' ',
         '','2022-11-05','2022-11-10','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Six: sets','1) Intersection of two sets\n2) Union of two sets\n3) The universal set � the complement of a set \n','1) Find the intersection of two given sets\n2) Find the union of two given sets\n3) describe universal set\n4) Find complement of a given set\n','','Assingment four','',
        ' ',
         '','2022-11-12','2022-11-17','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','2) 1) decimal number\n2) Conversion of  fraction into decimal\n3) Conversion of decimals into fraction\n','\n3) 1) Identify decimal number\n2) Convert fraction into decimal\n\n3) Convert decimal into fraction\n','','Assingment 3 and 4 test','',
        ' ',
         '','2022-11-19','2022-11-24','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','1) Adding and subtracting  two decimals numbers','1) Add two numbers with decimal point\n2) Subtract two decimal numbers\n','','','',
        ' ',
         '','2022-11-26','2022-12-01','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Contigence and revision week','','','','','',
        ' ',
         '','2022-12-03','2022-12-08','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Midterm exam','','','','','',
        ' ',
         '','2022-11-10','2022-11-15','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam marking and Midterm holidays','','','','','',
        ' ',
         '','2022-11-17','2022-11-22','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Midterm holidays','','','','','',
        ' ',
         '','2022-12-24','2022-12-29','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','1) Multiplying two decimals','1) Multiply two decimals','1) Multiply two decimals','','',
        ' ',
         '','2023-01-01','2023-01-05','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1) Multiply decimals by 10, 100 and 1000\nDivide by a decimal number\n','4) Multiplying decimals by 10, 100 and 1000\n5) Dividing by a decimal number\n\n','','',
        ' ',
         '','2023-01-07','2023-01-12','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1) Infinite division ','1) divide an infinite number  ','','',
        ' ',
         '','2023-01-14','2023-01-19','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1)Approximating to the nearest hundredth and thousandth','1)Approximate to the nearest hundredth and thousandth','Assingment five','',
        ' ',
         '','2023-01-21','2023-01-26','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Saami','Casharka 1aad: Fahamka saamiga ','Qeexi karaa macnaha uu saamig a leeyahay','Assingment 5 group discussion','',
        ' ',
         '','2023-01-25','2023-02-02','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Casharka 2aad: Fududeynta saamiga ','Fududayn karaa saami','Casharka 2aad: Fududeynta saamiga ','','',
        ' ',
         '','2023-02-04','2023-02-09','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly three','','','','','',
        ' ',
         '','2023-02-11','2023-02-16','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Casharka 2aad: Fududeynta saamiga ','','Casharka 2aad: Fududeynta saamiga ','Assingment six','',
        ' ',
         '','2023-02-18','2023-02-23','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) The set of natural numbers','1) recognize the set of natural numbers','','Assingment 5 and 6 test','',
        ' ',
         '','2023-02-25','2023-03-02','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) Some subsets of N\n2) Ordering and comparing natural numbers\n\n1) Operations on natural numbers\n2) Numerical pattern \n','1)identify Some subsets of N\n2) Order and compare natural numbers\n\n1) Do the operations of natural numbers\n2) recognize numerical pattern\n','','','',
        ' ',
         '','2023-03-04','2023-03-09','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) Operations on natural numbers\n2) Numerical pattern \n','1) Do the operations of natural numbers\n2) recognize numerical pattern\n','','Assingment seven','',
        ' ',
         '','2023-03-11','2023-03-16','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1)Mathematical expressions','1) recognize the mathematical expressions ','','Assingment seven group discussion','',
        ' ',
         '','2023-03-18','2023-03-23','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly four exam','','','','','',
        ' ',
         '','2023-03-25','2023-03-30','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1) The constant and the variable ','1) identify and use the constant and variable numbers','','Assingment eight','',
        ' ',
         '','2023-04-01','2023-04-06','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1) Equations','1) solve simple equations','','Assingment 7 and 8 test','',
        ' ',
         '','2023-04-08','2023-04-13','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Tobanka dambe Ramadan iyo ciidul-Fidri','','Geometry','','','',
        ' ',
         '','2023-04-15','2023-04-20','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Tobanka dambe Ramadan iyo ciidul-Fidri','','','','','',
        ' ',
         '','2023-04-22','2023-04-27','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Contigence','','','','','',
        ' ',
         '','2023-04-29','2023-05-04','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Revion week','','','','','',
        ' ',
         '','2023-05-06','2023-05-11','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam','','','','','',
        ' ',
         '','2023-05-13','2023-05-18','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam Marking','','','','','',
        ' ',
         '','2023-05-20','2023-05-25','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Scheme of work 2023/2024','','','','','',
        ' ',
         '','2023-05-27','2023-05-31','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter one: Numbers','1) Reading numbers to hundred million\n2) Reading numbers to one hundred million\n','By the end of this week the students should be able to:\n1) By the end of this week the students should be able to: Recognize the place value of numbers to one hundred million\n2)  Read the whole numbers to 0ne hundred million\n','C4 Moasser','','',
        ' ',
         '','2022-08-06','2022-08-11','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter one: Numbers','Writing numbers to one hundred million in fugures or in words','1) Write the whole numbers to one hundred million in figures\nWrite numbers in words\n','C4 Moasser','','',
        ' ',
         '','2022-08-13','2022-08-18','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','Total value \nAddition and subtraction \n','1) Recognize the total value of numbers to one hundred million\n2) Add 8-digit numbers to 8-digit numbers with carrying\nSubtract  8-digit numbers from 8-digit numbers with borrowing\n','C4 Moasser','','',
        ' ',
         '','2022-08-20','2022-08-25','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','1)Multiplication table\n2)Multiplying numbers to 4 digit numbers\n3) Dividing by 2-digit numbers\n','1) Memorize multiplication table up to 10\n2) Multiplying numbers up to 4-digit numbers by 4-digit numbers\n3) Dividing numbers by 1-digit number\n4) Dividing numbers by a 2-digit numbers\n','C4 Moasser','Assingment one','',
        ' ',
         '','2022-08-27','2022-09-01','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter two: Operations of numbers','1) Natural numbers\n2) Even numbers\n3) Odd numbers\n4) prime numbers\n5) composite numbers\n6) divisibility test by two \n7) Divisibility test by 3\n8) divisibility test by 4\n','1) Recognize natural numbers\n2) Recognize even numbers \n3) Recognize odd numbers\n4) recognize the prime numbers\n5) Recognize composite numbers\n6) Identify the divisibility test by 2\n7) Identify divisibility test by 3\n8) Identify the divisibility test by 4\n','C4 Moasser','Assingment one group discussion','',
        ' ',
         '','2022-09-03','2022-09-08','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         '','1) divisibility test by 5 \n2) Divisibility test by 6\n3) divisibility test by 8\n4) divisibility test by 9\n5) Divisibility test by 10\n','1) Identify the divisibility test by 5\n2) Identify the divisibility test by 6\n3) Identify divisibility test by  8\n4) Identify divisibility test by  9\n5)  Identify divisibility test by 10\n','','','',
        ' ',
         '','2022-09-10','2022-09-15','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly one exam','','','','','',
        ' ',
         '','2022-09-17','2022-09-22','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter four: G.C.D and L.C.M','1) Factors\n2) Common factors\n3) LCM\n','1) Factorize the a given number\n2) Find greatest common divisor\n3) Find the multiples\n4) Find the least common multiple of two given numbers\n5) Find the least common multiple of three given numbers\n\n','','Assigment two','',
        ' ',
         '','2022-09-24','2022-09-29','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Meaning of fraction\n2) types of fractions\n3) conversion of fractions \n4) Equivalent fractions\n','1) Identify fractions using shaded and unshaded part\n2) Recognize types of fractions\n3) Convert mixed number into improper fraction\n4) Convert improper fraction into mixed number \n5) Recognize two equivalent fractions\n','','Assigment one and two test','',
        ' ',
         '','2022-10-01','2022-10-06','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Comparing fractions\n2) simplifying fractions\n','1) Compare two fractions(Comparing and ordering fractions)\n2) simplify fractions\n','','','',
        ' ',
         '','2022-10-08','2022-10-13','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Adding two fractions\n2) Subtracting two fractions\n','1) Add two fractions\n2) subtract two fractions\n','','Assingment three','',
        ' ',
         '','2022-10-15','2022-10-20','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Five: Fractions','1) Multiplying two fractions\n2) Reciprocal of fractions\n3) Dividing fractions\n','1) Multiply two fractions\n2) Find the reciprocal of a fraction\n3) Divide two fractions\n','','Assingment three group discussion','',
        ' ',
         '','2022-10-22','2022-10-27','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly two exam','','','','','',
        ' ',
         '','2022-10-29','2022-11-03','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Six: sets','1) What is a set?\n2)Mathematical expression of a set-3) representing sets by venn diagram\n','1) Describe the meaning of a set\n2) express mathematically a given set\n3) represent given sets by venn diagram\n','','','',
        ' ',
         '','2022-11-05','2022-11-10','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter Six: sets','1) Intersection of two sets\n2) Union of two sets\n3) The universal set � the complement of a set \n','1) Find the intersection of two given sets\n2) Find the union of two given sets\n3) describe universal set\n4) Find complement of a given set\n','','Assingment four','',
        ' ',
         '','2022-11-12','2022-11-17','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','2) 1) decimal number\n2) Conversion of  fraction into decimal\n3) Conversion of decimals into fraction\n','\n3) 1) Identify decimal number\n2) Convert fraction into decimal\n\n3) Convert decimal into fraction\n','','Assingment 3 and 4 test','',
        ' ',
         '','2022-11-19','2022-11-24','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','1) Adding and subtracting  two decimals numbers','1) Add two numbers with decimal point\n2) Subtract two decimal numbers\n','','','',
        ' ',
         '','2022-11-26','2022-12-01','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Contigence and revision week','','','','','',
        ' ',
         '','2022-12-03','2022-12-08','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Midterm exam','','','','','',
        ' ',
         '','2022-11-10','2022-11-15','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam marking and Midterm holidays','','','','','',
        ' ',
         '','2022-11-17','2022-11-22','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Midterm holidays','','','','','',
        ' ',
         '','2022-12-24','2022-12-29','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','1) Multiplying two decimals','1) Multiply two decimals','1) Multiply two decimals','','',
        ' ',
         '','2023-01-01','2023-01-05','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1) Multiply decimals by 10, 100 and 1000\nDivide by a decimal number\n','4) Multiplying decimals by 10, 100 and 1000\n5) Dividing by a decimal number\n\n','','',
        ' ',
         '','2023-01-07','2023-01-12','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1) Infinite division ','1) divide an infinite number  ','','',
        ' ',
         '','2023-01-14','2023-01-19','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter seven: decimals','','1)Approximating to the nearest hundredth and thousandth','1)Approximate to the nearest hundredth and thousandth','Assingment five','',
        ' ',
         '','2023-01-21','2023-01-26','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Saami','Casharka 1aad: Fahamka saamiga ','Qeexi karaa macnaha uu saamig a leeyahay','Assingment 5 group discussion','',
        ' ',
         '','2023-01-25','2023-02-02','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Casharka 2aad: Fududeynta saamiga ','Fududayn karaa saami','Casharka 2aad: Fududeynta saamiga ','','',
        ' ',
         '','2023-02-04','2023-02-09','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly three','','','','','',
        ' ',
         '','2023-02-11','2023-02-16','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Saami','Casharka 2aad: Fududeynta saamiga ','','Casharka 2aad: Fududeynta saamiga ','Assingment six','',
        ' ',
         '','2023-02-18','2023-02-23','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) The set of natural numbers','1) recognize the set of natural numbers','','Assingment 5 and 6 test','',
        ' ',
         '','2023-02-25','2023-03-02','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) Some subsets of N\n2) Ordering and comparing natural numbers\n\n1) Operations on natural numbers\n2) Numerical pattern \n','1)identify Some subsets of N\n2) Order and compare natural numbers\n\n1) Do the operations of natural numbers\n2) recognize numerical pattern\n','','','',
        ' ',
         '','2023-03-04','2023-03-09','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Chapter eight:  natural numbers','1) Operations on natural numbers\n2) Numerical pattern \n','1) Do the operations of natural numbers\n2) recognize numerical pattern\n','','Assingment seven','',
        ' ',
         '','2023-03-11','2023-03-16','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1)Mathematical expressions','1) recognize the mathematical expressions ','','Assingment seven group discussion','',
        ' ',
         '','2023-03-18','2023-03-23','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Monthly four exam','','','','','',
        ' ',
         '','2023-03-25','2023-03-30','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1) The constant and the variable ','1) identify and use the constant and variable numbers','','Assingment eight','',
        ' ',
         '','2023-04-01','2023-04-06','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Chapter nine: equations','1) Equations','1) solve simple equations','','Assingment 7 and 8 test','',
        ' ',
         '','2023-04-08','2023-04-13','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Tobanka dambe Ramadan iyo ciidul-Fidri','','Geometry','','','',
        ' ',
         '','2023-04-15','2023-04-20','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Tobanka dambe Ramadan iyo ciidul-Fidri','','','','','',
        ' ',
         '','2023-04-22','2023-04-27','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Contigence','','','','','',
        ' ',
         '','2023-04-29','2023-05-04','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         ' Revion week','','','','','',
        ' ',
         '','2023-05-06','2023-05-11','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam','','','','','',
        ' ',
         '','2023-05-13','2023-05-18','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Exam Marking','','','','','',
        ' ',
         '','2023-05-20','2023-05-25','','36,26','69')
CALL sp_import_topics  ('60','1','3',
         'Scheme of work 2023/2024','','','','','',
        ' ',
         '','2023-05-27','2023-05-31','','36,26','69')
call sp_add_lesson('1','3','13,14,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36','Chapter one: Numbers,Chapter two: Operations of numbers,Monthly one exam,Chapter four: G.C.D and L.C.M,Chapter Five: Fractions,Monthly two exam,Chapter Six: sets,Chapter seven: decimals,Contigence and revision week,Midterm exam,Exam marking and Midterm holidays,Midterm holidays,Saami,Monthly three, Chapter eight:  natural numbers,Chapter nine: equations,Monthly four exam,Tobanka dambe Ramadan iyo ciidul-Fidri,Contigence, Revion week,Exam,Exam Marking,Scheme of work 2023/2024','','22','60')
call sp_add_lesson('','','','','','','')
call sp_add_lesson('1','3','13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36','Chapter one: Numbers,Chapter two: Operations of numbers,,Monthly one exam,Chapter four: G.C.D and L.C.M,Chapter Five: Fractions,Monthly two exam,Chapter Six: sets,Chapter seven: decimals,Contigence and revision week,Midterm exam,Exam marking and Midterm holidays,Midterm holidays,Saami,Monthly three, Chapter eight:  natural numbers,Chapter nine: equations,Monthly four exam,Tobanka dambe Ramadan iyo ciidul-Fidri,Contigence, Revion week,Exam,Exam Marking,Scheme of work 2023/2024','33','22','60')
call sp_add_lesson('1','3','13,14,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36','Chapter one: Numbers,Chapter two: Operations of numbers,Monthly one exam,Chapter four: G.C.D and L.C.M,Chapter Five: Fractions,Monthly two exam,Chapter Six: sets,Chapter seven: decimals,Contigence and revision week,Midterm exam,Exam marking and Midterm holidays,Midterm holidays,Saami,Monthly three, Chapter eight:  natural numbers,Chapter nine: equations,Monthly four exam,Tobanka dambe Ramadan iyo ciidul-Fidri,Contigence, Revion week,Exam,Exam Marking,Scheme of work 2023/2024','33','22','60')
call sp_add_lesson('23','13','0,0','fdasfdsafdsafdsa,N/Afffffffff','25','138','61')
call sp_add_lesson('31','2','0,0,0,0','الحركات الثلاثة,الفتحة,الكسرة,الضمة','37','171','61')
call sp_add_lesson('','','','','','','')
call sp_add_lesson('31','2','0,0,0,0','الحركات الثلاثة,الفتحة,الكسرة,الضمة','37','171','61')
call sp_add_lesson('31','2','0,0,0,0','الحركات الثلاثة,الفتحة,الكسرة,الضمة','37','171','61')
call sp_add_lesson('20','1','0,0,0,0','القرآن الكريم: سورة الفاتحة ,القيم : قيمة الصدق,أسماء الله الحسنى: اسم الخالق ,الأذكار: أذكار الصباح ','38','172','61')
call sp_add_lesson('20','1','0,0,0,0','القرآن الكريم: سورة الفاتحة ,القيم : قيمة الصدق,أسماء الله الحسنى: اسم الخالق ,الأذكار: أذكار الصباح ','38','172','61')
call sp_add_lesson('20','1','0','القرآن الكريم','38','172','61')
call sp_add_lesson('20','1','0','أصول التوحيد','38','172','61')
call sp_add_lesson('20','1','0','القيم الإسلامية','38','172','61')
call sp_add_lesson('20','1','0','الأذكار','38','172','61')
call sp_add_lesson('20','1','0','أسماء الله الحسنى','38','172','61')
call sp_add_lesson('20','1','0','القرآن الكريم','38','172','61')
call sp_add_lesson('22','11','0','1.2 modern periodic table','47','181','61')
call sp_add_lesson('32','10','0','1.3 organic compounds ','47','181','61')
call sp_add_lesson('23','10','0','Lesson 5 ; Characteristics of living things','47','181','61')
call sp_add_lesson('23','10','0','Lesson 5 ; Characteristics of living things','47','181','61')
call sp_add_lesson('23','10','0','Lesson 5 ; Characteristics of living things','47','181','61')
call sp_add_lesson('32','10','0','1 .3, 2. Disaccharides','47','181','61')
call sp_add_lesson('22','10','0','3 classification of Fungi','47','181','61')
call sp_add_lesson('22','10','0','3 classification of Fungi','47','181','61')
call sp_add_lesson('23','1','0','4. Chemistry laboratory','47','181','61')
call sp_add_lesson('23','1','0','4. Chemistry laboratory','47','181','61')
call sp_add_lesson('32','1','0','1.3 Lewis Acid and Bases','47','181','61')
call sp_add_lesson('22','10','0,0','1.5 Harmful and useful of Fungi,N/A','47','181','61')
call sp_add_lesson('23','11','0,0','Safety rules in the chemistry laboratory ,N/A','47','181','61')
call sp_add_lesson('22','11','0','1.4 Electron configuration and periodic table ','47','181','61')
call sp_add_lesson('32','10','0','3. Polysaccharides','47','181','61')
call sp_add_lesson('32','10','0,0','A.3. Polysaccharides,B. Lipids','47','181','61')
call sp_add_lesson('23','10','0,0','Chapter 2 ; the cell structure and functions ,2.2 Size and shape of cell','47','181','61')
call sp_add_lesson('25','7','0','Casharka 2aad; a) Daaweynta cudurka shubanka','47','181','61')
call sp_add_lesson('27','1','0','Casharka 2aad ; siyaabaha looga hortago fiesta cudurrada','47','181','61')
call sp_add_lesson('32','12','0','Chapter one Sets','27','161','61')
call sp_add_lesson('32','12','0','Chapter one Sets','27','161','61')
call sp_add_lesson('32','14','0','N/A','48','182','61')
call sp_add_lesson('23','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('23','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('22','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('22','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('22','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('23','12','0,0','Chapter one Real numbers ,Chapter two Approximation and Estimation ','27','161','61')
call sp_add_lesson('23','12','0,0','Chapter one Real numbers ,Chapter two Approximation and Estimation ','27','161','61')
call sp_add_lesson('22','1','0,0','Chapter one Real numbers ,Chapter two Approximation and Estimation ','27','161','61')
call sp_add_lesson('22','12','0,0','Chapter one Real numbers ,Chapter two Approximation and Estimation ','27','161','61')
call sp_add_lesson('22','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('23','1','0','1.8 Highest Common Factor (H','27','161','61')
call sp_add_lesson('23','1','0','1.8 Highest Common Factor (HC','27','161','61')
call sp_add_lesson('23','1','0','1.8 Highest Common Factor (H.C.F)','27','161','61')
call sp_add_lesson('32','12','0','Chapter 1 properties of light ','27','161','61')
call sp_add_lesson('32','9','0','Chapter 1 properties of light ','27','161','61')
call sp_add_lesson('22','12','0','Chapter one Real numbers ','27','161','61')
call sp_add_lesson('23','12','0','Chapterone.8 Highest Common Factor (H.C.F)','27','161','61')
call sp_add_lesson('23','12','0,0','Chapter one 1.8  Highest Common Factor (H.C.F),N/A','27','161','61')
call sp_add_lesson('23','12','68','Chapter one ','27','161','61')
call sp_add_lesson('22','11','0','1.4 b sub shell notation ','47','181','61')
call sp_add_lesson('32','1','0','1.2 naming of Acids and bases','47','181','61')
call sp_add_lesson('24','7','0','Cutubka 2aad Biyaahy; 1. 1 Baahsanaanta Biyaha Dhulka','47','181','61')
call sp_add_lesson('27','7','0','Gunaanud','47','181','61')
call sp_add_lesson('25','1','0','2. Xundhurta','47','181','61')
call sp_add_lesson('26','1','0','Hababka uu dulinku u saameeyo dadka','47','181','61')
call sp_add_lesson('27','8','0,0','cutubka 1aad ,cutubka 2aad ','40','138','61')
call sp_add_lesson('','','','','','','')
call sp_add_lesson('32','9','0','Chapter 8 - Electrostatics II','27','161','61')
call sp_add_lesson('23','12','0','Chapter 5 - Cartesian Coordinates and Linear Graphs','27','161','61')
call sp_add_lesson('28','1','0',' أهمية التربة والصخور','32','166','61')
call sp_add_lesson('','','','','','','')
call sp_add_lesson('32','12','0','Chapter 8 - Relations and Functions ','27','161','61')
call sp_add_lesson('','','','','','','')
Call sp_add_class('','','','','','','','','')
call sp_add_lesson('','','','','','','')
Call sp_add_class('','','','','','','','','')
call sp_add_lesson('','','','','','','')
Call sp_add_class('','','','','','','','','')
call sp_add_lesson('','','','','','','')