การพัฒนาระบบสารสนเทศ เพื่อการบริหารจัดการแผนจัดการเรียนรู้ ระดับการศึกษาขั้นพื้นฐาน

Abstract

This paper was aimed at (1) analyzing lesson plans based on  the Basic Education Core Curriculum B.E. 2551 (A.D. 2008), (2) designing a lesson plan database, and (3) putting forward a new approach to storing lesson plans. In the analysis of lesson plans, literature review covered the Basic Education Core Curriculum, a manual of Technology and Occupation lesson plan management, Technology and Occupation lesson plans for the 2^nd benchmark (grade 5) of the 1^st semester, and educational information technology documents. The curriculum’s harmony with and relevance to the lesson plans were also taken into account. To design a lesson plan database, the system development life cycle was analyzed, mainly focusing data development. The information and technology development was carried out through three stages: database design, logical database design, implementation and loading. The sample for the third stage was the second lesson plan on Fertilizer of the second unit on Advanced Agriculture in the Technology and Occupation course. Finally, it resulted in Entity data covering a course assigning form, responsible teachers, lesson plans, and disciplines. They were then applied to designing E-R diagrams: conceptual, logical, physical.

            It is recommended for further development that results of designing conceptual and logical E-R diagrams should be applied to design of a physical E-R diagram on other database programs, in addition to Microsoft Access and MySQL Posgress.