熊本高専における出席情報処理システムの開発

全文

(1)論文. şĹǹæ( :¦óćÐ¥ţNPWk)ǣŬ ĩƾ Ŕ ǽ Ŀ ĆČǽǽ }Ò Ɨħǽǽǽ ìí Þǽǽǽǽ ĺ Ĭòǽǽ Development of an educational information processing system in Kumamoto-NCT Hirohito Shintaniǽ, Kosei Moriǽǽ, Yoshifumi Shimoshioǽǽǽ, Manabu Shimakawaǽǽǽǽ Saki Nakamuraǽǽ A student information system is a software application for education establishments to manage student data. Many company's products can be scaled to different levels of functionality by purchasing add-on modules. However, their modules are very expensive. Besides, there are lots of teachers that want to student information for education. An information system makes it easier for someone to access the information. This paper describes the development of a roll book system (Roll-System) based on a concept of the client-server model and the open source. The Roll-System is written in the PHP programming language and uses the MySQL database system to store information. *(*ȁĤƛćÐǾ¦óƈǾSzP¡ǣ Keywordsȁeducational information, roll system, source code openness. ^P%#PTzYşĹǹƁæǡÞľǻ}ǾĹľǼ. [. . $*Ǿǧ)ÞťćÐ)ƒÁ=ƣ 4(Ǿŀ(Ǵ. ÀǹæyÙÞ'&)ǹƁĤƛņǥ( #ǾÞť)Čƕ. ĩĤµĠĝNPWk=çǿ

(2) ' 8Ǿ£Ɣ. 6¦ŇƁ)ćÐ=ƢżǾĤƛ(ÿž#:4)¼9Ə2. °(XzT)ƒÁ $:7 (Ĥµǥǔ)ćÐ¥ţ=. īôŮ(ƣ<;#ǿ1Ǿǈö$*Kx_ozT). 9<#(5ǥ<8Ǿãǩ(ǗŦ#2:%ÀG. śƃƝ±%ćÐďƤ)Ä|=Ɯı(;8)ćÐ*Kx_. nx^P$é"ƪŏ ǘǾNPWk)ġ Ăƪ%. ozT|)XzTdzP(Ƣż;Ǿ79 Ǥ ¬Ŧ6. '!ǿ)4Ǿāĩ'NPWk=£ç:

(3) Ǿ. 7 (ćÐ¥ţ=;:% {ƟŮ%'!#:ǿ. :NPWk)£ġǴ=:Ăƪ 9Ǿ;(. ;8)NPWk=ãŢ#:S`YAB?*ÀÞľ$. #5ØÙ'KPY Ŭť:¾Ɲą :ǿ)). Þ¢)ĤÈ Č5)6Ǿŀ)ǀÕ#:5)Ǿ. 7 (<

(4) ȀǹæǤ$5Â{)NPWk=¬Ŧ:%. 1*ǣŬS`YAB?=ǂ¬Ŧ:% {Ɵ. *Ǯô(Ǭ% <

(5) !ǿ. Ů$:ǿ

(6) ' 8ĤÈǣŬ)NPWk$;+NP. ;8)Éǵ*Ǿŀ(7:NPWk)ÑÁHvzQZ. Wk)ƬŃ Ù':0&ǗŦ#:ĤÈ)ƿĔ Ô. SzP$:4(è'Öĳ$!#5Þľ$*$. ²9ǾǌƚƁ(79ß $'':%Ǿŀ). '%6ǾNPWk¢ǜ$)ćÐ¥ţ &)7 ('. ƨÇ$;+KPY

(7)

(8) 9:%'& Éǵ%'!. ;#:

(9) ~Ǐĭ$:Ŝ(ǃË:ǿ"19ǾNPWk. #:ǿ. ġ$)XzTdzPŁǓ)Ö¶ ƪĶ)İŜ$ř$. õČ 21 öø(şĹǭœǹæ% ǹæ ǹø¶£ƔǾ. '%(:ǿ1ǾNPWkǗŦ(Ğ<:ĤƚÈ)ƿ. şĹGnx^P% Gnx^P%#{ǹæyGnx. ĔÔ5EzbxSzP$ǣŬ;Ǿ$(àâ#:5 )=ŕŦ:)$;+Ǿ:źøèđ :% $. ǽ. şĹǹƁæǡÞľ şĹGnx^P ćÐǑCuHYv[HPîÞŸ 861-1102 şĹŲÁăñǲê 2659-2 Dept. of Control and Information Systems Engineering, 2659-2 Suya, Koshi-shi, Kumamoto, Japan 861-1102 ǽǽ æĢŸ ǭÜćÐNPWkîÞæĢ Dept. of Advanced Engineering Course ǽǽǽ æĢŸ Dept. of Advanced Courses ǽǽǽǽ ǤćÐNPWkîÞŸ Dept. of Human-Oriented information Systems Engineering. :%Ƙ 8;:ǿEzbxSzP$¡ǣ;#:Ĥƛ ņǥÄNPWk%#*ǾOpenSIS(1)Ǿ6 SchoolTool(2)' &ł'5) 9ŵŽƁ.)ĄŦ5';#:(3)ǿ

(10) ' 8Ǿ;8*Ŗ×$)¬Ŧ=(Ĉâ;#: 4īĹƸŤÓ$)¬Ŧ(~à Ō:ǿ $ǾĤƛǥǔćÐ=ƒÁƄţ:4)NPWkǣ Ŭ=ǾSzP*/#¡ǣ:â%#ǣÛǿ). 熊本高等専門学校研究紀要第 4 号（2012）. －1－.

(11) ¦óćÐƄţNPWkǻĩƾŔ Ǽ. ƀ{Ŋ%#Ǿ¦óƈNPWkǜ§(}ǾRoll System) á ČǾãǗŦ=ǣÛǿ Þť)¦óćÐ¥ţ*ǾĹľ$*;1$½ƼƙsPY =ÀĤÈ ęŀ(ė. ǆ2Ǿ¦ó=¼9Ǿ;=HrP. %(Ŧĉ¦óƈ(ǄƲǾµƚÈ(7:{īŇó #:Þť)ŶƷ ƣ'<;#ǿ1ǾƵǸķǤ% (;1$)Ňƹĥ

(12) 8¡Ň%¡)ĥ=ĤÈ £øú ƃǾŢÏ)ĤµĠĝNPWk(±:% ĎǱ%' !#ǿ$Ǿ Ǥ ' ¥ţ=$:Ƈũ ¶:4(ęŀ({ø±= ' $¦ó (ǥ:/#)¥ţ Ǝ:NPWk%:%% ǿ¦ó(ǥ:¥ţ*ęŀ){Ê$ƎǾ% *Kx_ozT$ƞ´Ů(ǥǔ:¥ţ=ƣ %$Ǿ ĤÈº,ĤµƚÈ)ŀµ)ŗ ķĀ;:ǿ 8(ǾN PWk|$)ćÐ¥ţ ƞ´¶;:%(79Ǿ. Î 1 fzkzezO

(13) 8)sxHǥ. y ŇóƙĥÔ²)Ǉǒ

(14) "Ŷã'ĐĜ(7:¸ņƄţ y ƒƱ¥ţ(7:ÞťĠĝ y ¦Ň)Ĺ (7:ŶƷǻĤÈ)jP)ƧŉǼ y ŇƹǾŇóİĥ%Čƕ%)ǥǔƺĽŦ)XzTě y ƌżŇƹĥ)Ĺ .)ǑŴ%ƽÅ y µŀ)ǅŗ '&Ǿ11'¬Ŝ Ƙ 8;:ǿĹƻħ$*ǣŬ Roll System )ƶƍ%ĄŦƅÍ("#Ǌ/:ǿ. \. /:<4.G" 2.1. "

(15) CQ. ÊǣŬ Roll System *Hr@?xYyLz]mXt %Æ+;:ýċ=%!#:ǿÀŻćÐ¥ţ*Lz]$ {Ƅţ;ǾHr@?xY* Web arAM=Ɛŧ#Ǿ XzTdzP(?HRP:ǿƄţƙ*Lz]=%# Ƅţ:$Ơ)$ƿĔǅŗ%':%6ǾHr@? xY*Ʃǫ'¥ţ=ƣ % '4ąƝ)ſĸ )¬Ŧ ¾Ɲ$:%ǾLz](XzT=Ǫ4:%$ XzT)ĦÁą ¼96':%'&)lsVY :ǿ1ǾĹNPWk*Šŋ'S`YAB?=¬ŦǾ PHP 6 MySQL '&)`szAB?=¬ŦŤÓ|$Ł Ɔ;# 9ǾćÐ=±:4)ſĸ$*ǾWeb a rAM=¬Ŧ:5)%#:%$ǾiPad 6 Android TauVY PC =ęŀ(ė. ǆ>$NPWk=\VYwz. HƐŧ$Ŧ:% $:ǿ 2.2. " NG<4 ƥ 1 ƄţćÐ{Ư. Î 2 ¦ó=%:1$)ŕ;. Research Reports of Kumamoto-NCT. Vol. 4（2012）. －2－.

(16) ƥ 1 (NPWk$Ƅţ:ćÐ=ŷǿXzTdzP*. ĹNPWk*ÞťćÐ="

(17) ąǁ|ǾHr@?xY. ÀƪƋ$«)Wzat=!#:ǿ§Ƕ#Ý:. %Lz]Ǥ)Ĳ¿¶Ǒ%%5(ǾÞ¢æŦ LAN |

(18) 8). %$ǾXzT)ǋ²'&)Öĳ !ÑÁ)þǰƅÍ. ¬Ŧ

(19) $'7 (Ƴâ#:ǿ1ǾpzMƷƴ. =đ :%%5(Ǿßąyĕûą=Ŷ#:ǿ. * PHP $*ƣ<Ǿ±; ID %^PwzZ= PHP Ɛ. 2.3. *. H5. ŧ$XzTdzP(ŘǾarAM

(20) 8űĚ¹Ş$'. NPWk*Ǿ}(ŷ;:Kx_ozT|(ŁƆ; #:ǿ. 7 (ŶƷ:%$×ǜ

(21) 8*pzMćÐ Ʈ'Ƴ Ʊ%'!#:ǿƷƴ ÚģÑÁ(*atzY`Dz. y CPU: Intel i5 3.00GHz ylms: 16GB. P?TVH.)åƂ%#&)pzM$Úģ)

(22) *Ŵ. y OS: FreeBSD 9.0-RELEASE. 8Ǿ·(Ʒƴ Úģ%)ćÐ)2=ǉ7 ('. y DBMS: MySQL 5.1.61 y Web Lz]: Apache/2.2.2 + PHP/5.3.10. !#:ǿ8(ǾÀpzMō(Ǚ¨'?HRPń=Ƴâ Ǿ¦±:ćÐ)ůƭ5 '!#:ǿ. OS *Ƅţ)6%àâą

(23) 8 FreeBSD %ǿWeb. ]. %)

(24) 0I?D. Lz]% DBMS ´;+74 Windows $)¬Ŧ5. . ¾Ɲ$: ǾXzT)]VH?Vb'&{ǜ)ņƝ*. /:2

(25) =-. Unix )KixZ=¬ŦPHsbY=¬Ŧ#:. Î 49 (vI@xŨǯ

(26) 8¦ó=¼9Ǝ :1$)NP. 4ǾŤÓ(Ą#Øé)Öĳ Ăƪ%':ǿ. Wk)´Ũǯ=ŷǿvI@xň)ezO*ŸŰƁ. 2.4. ǛĒezOǻÎ 5Ǽ%':ǿ$ŸŰǾīǾİǨǾǔƓ. %)H5. ĹNPWk* Web arAM ´:ſĸ

(27) 8$;+. ęŀĥ=ǛĒǾŐâ=ē%$ŶƷŨǯ(Ź:ǿīǾ. ¬Ŧ¾Ɲ$: ǾpzM)ğ(Ą#ǮÂķ(Lz]. İǨ*vI@xİǤ

(28) 8ǎƃ;ƞ´Ů(±;#. %Ǒ=ƣ' 8ŨǯǚŹ= ' 4( Ajax ďƤ=. :šċ$:4ǾpzM*Ǒô$;+ŸŰ%ǔƓİ. ¬Ŧ#:ǿ)4arAM* JavaScript )´:5. Ǥĥ=Ǜ-$7ǿŶƷŨǯ$*Ǿ$(¦óćÐ. )$:Ăƪ :ǿ. ÝÏ:ÑÁ(*|Ĵ#1 %=Ǧ4ǾǣÛ. 2.5. gTx Ǻơ(Ö¶:ǿǣÛ=ē%$Ǿ¤ų). !'%"SR. NPWk)fzkezO

(29) 8)sxHǥ=Î 1 (ŷǿ. ¦óƈŨǯǻÞť{ƯŨǯǾÎ 7Ǽ(ǚŹ:ǿ¦óƈŨǯ. fzkezO

(30) 8*Ǿ¦ó=¼:ezOc5sxH;#. $*Ǿ©ķšċ$Þť ¦ó('!#:)$Ǿǖ1. 9ǾÎ 2 (ŷ;:ŕ;Î( !#Ǿ¥ţ ƣ<;. *Ňó)Þť)2UBVH:ǿUBVH Ǝ. :ǿ1ǾÎ 3 (vI@x¥ţ)ƶƍ'`vzUnzY=. %$Ũǯ){Ū}(ǝƖ#:ŐâgTx=ē%Ǿ. ŷǿ. )ŸŰ( :¦óšő)ezO(Ź´:ǿǔƓęŀĥ. 2.6. <4#&. =Ȁ|(Ƴâ#ÑÁ*Ǿň)İǤ)¦óƈŨǯ( Ź:ǿŹ!)Ũǯ$*Ňó%UBVH#Þť) 2ŇóǾ))Þť*¦ó('!#:)$Ǿ)11. Î 3 vI@x`vzUnzY. Î 4 vI@xŨǯ. 熊本高等専門学校研究紀要第 4 号（2012）. －3－.

(31) ¦óćÐƄţNPWkǻĩƾŔ Ǽ. Î 8 ŸŰ«¦óšő{Ư. Î 5 ŸŰƁǛĒezOŨǯ. Î 6 ŶƷŨǯ. Î 9 ǕǤ¦óšő. Î 7 Þť{Ư. Î 10 fzkŨǯ. Research Reports of Kumamoto-NCT. Vol. 4（2012）. －4－.

(32) Ũǯ}ǜ)ŐâgTx=ē$¦Ň=%:ŀ*Ǝ. 1$(+8İǤ

(33)

(34) !#1 '&ÉǵŜ5Øǿ. %':ǿ¦ó=¼:%(ǥ:XzTdzP)ćÐÖĳ. ưŐƂ%#*Ǿ\VYwzH)ŝŤÓ$±Ǿ). *)ŐâgTx=ēǩ)2 '<;:)$ǐ$. ā1%4#Ǎ:4)?bsJzNqx)«ǐǣŬ. Web arAM=Ǣ#5XzTdzP(Öĳ*'ǿŐâ. 6ǾćÐ¥ţņŁ=ƫűǾǑǞ=¯ŗ:%'&. āƥŷ;:¦óšő)ezO$*ęŀ=ƣ!İǨ%Þ. Ƙ 8;:ǿ. ť)Ã° gTx('!# 9Ǿ

(35) 8¦óƈ)Ũǯ(. ŢİŜ$ãƦ=â#:ņƝ*Ǿ. č9XzT=Öĳ:% $:ǿ. y ĤÈ(7:ǛĒŸŰ½ƼÞť)ǛĒņƝ. . y XzT) csv ýù$)@xhzYyCHPhzYņƝ. $*S8 /:<4

(36) 6@. ŸŰƁǛĒezO)ï|) Home gTx

(37) 8Î 10 (ŷǾ. y ¦ŇXzT)ī%İǤ)ÖĳņƝ. ÀŻņƝ.)sxHezO=¹Ş:% $:ǿ¦ó. y ęŀƧ³)4)ƇĮlmņƝ. ƈņƝ)sxH

(38) 8*ǾŸŰƁǛĒezO%¦óšő{Ư. y Þť(7:ƞðƄţņƝ. .Ƿ-% $:ǿ1Ǿ?FAxYƄţ

(39) 8*ÀŻņ. y pzMbvIrkãƣmzZ. Ɲ)Ƴâ=ƣ % $:ǻÎ Ǽǿ$*Ǿ¦ó=%. '& :ǿ½ƼÞťǛĒņƝ)ãƦ$*Ǿ)Ñ$½Ƽ. !%$Ǿlzt$)ćÐ=Ǎ:4)lzt?Zu. Þť=ƺĦ$:4ǾëŸŰÖĳİ'&(µŀ). P%Ǿ)ǳø=Ő4:% 'ņƝ%':ǿ1Ǿ. ŗ ķĀ;:ǿ1Ǿ )ĤÈ$ćÐ=Ƅţ. $ōÊǍ)Ƴâ(# %$Ǿ)lzt)¢ä. ĤÈÄ(XzT)¦±= csv ýù%:%$Ǿ. =XzT)]VH?Vb%#¬Ŧ:% $:ǿ. Microsoft Excel %)ǔĞü¶=*

(40) :%%:ǿpzM). .

(41) ,

(42) <4.G. bvIrkãƣmzZ*ǾXzT)¦±)Ăƪ'ǾLz. Roll System $*Ǿ¡Ň6ÞǾǌÞ)ćÐ=Î (ŷ. ]|$ưĻŦ)bvIrk=ãƣ:mzZ$:ǿÎ 13. °±ezO79±:% $:ǿ)ezO*. (ŷ7 (ǾRoll System )XzT?HRPĪŒ(®!#Ǿ. ǑôĤÈ*¬Ŧ:%*' ǾÞť

(43) 8ě¦;ć. à(XzTdzP.)?HRP=ƣ' 8ǾNPWk. Ð=()ķǤ=±# %$¦óƈŨǯ(»į. |$ćÐ¥ţ=ƣ % $:ǿ1ǾĹNPWk=ĕ. ;:%%5(Ǿ¦óćÐ)ezO$*ƞ´Ů(Ʊƃ;. ûǾČƕ±%ÀŻÞľŀµǥǔĴǶ)¦±ņƝ=². ƥŷ;:ǿÞöǾHrPǾÞŸǾÞƉŪ¿=±:. :%$ÞťćÐǥǔ )NPWk$áƑ;:5. %$ÞťÃƈ ƥŷ;ǾÃ°)Ņ(*UBVHgVHP. )%':â$:ǿĹƻħ$Ǌ/¦óƈNPWkǜ§. ƥŷ;:4ǾÂţŧ$ęŀ=3Þť={Ė#. $*Ǿ$(ÞťćÐǾĤÈćÐǾŸŰćÐ ŭǟ;#. ŭǟ:% ¾Ɲ%':ǿ. :4ǾXzTdzPŁǓ%#*ņƝ=Ś#:. 1 Roll System * 1 ǨŰǣÛā 40 §İŜ$)HrP%. ǾĴǶ)ýù(Ħý:ņƝ Ăƪ'4āČ#. )¦ŇćÐ=ƞ´Ů(Ĕ%Ĥµ(å#lztǍ. ǿ1ǾƚÈ)ŀµƧ³$'ǾĹľ6)ǹæ. :ņƝ=' #:ǿ)ņƝ(79ǾūŎ)ǪÌĊ ļ'&(7:ÞƊǢǠƁ)ªĨ=Ǉǒ(ƣ % $: 7 (':ǿŇó Ô Þť)ćÐ5ƞ´Ǎ:ņƝ =' # 9ǾÞťĘç(ÿž"% ķĀ;:ǿ. ^. +;

(44) TW Ĺ Roll System *ǾõČ 24 öøāķ79ĹľyşĹGnx ^P$ǗŦ=ǣÛǿãǩ)ǗŦ(ǩ#÷"

(45) )]I Ŭƫ; ǾSzPKzZ Ď(:4X]VH ¾Ɲ$:ǿ

(46) ' 8Ǿ\VYwzHĚƓ ~àâ 'ŤÓ}$*¬Ŧ$'%6ǾÞť{ƯezO)ƥŷ Î 12 °±ezO. Î 11 ?FAxYƄţŨǯ. Î 13 pzMbvIrkãƣmzZ. 熊本高等専門学校研究紀要第 4 号（2012）. －5－.

(47) ¦óćÐƄţNPWkǻĩƾŔ Ǽ. $)ÞťćÐ)Ä=§Ļ:%$ā)Ĥƛ("' :%6ǾNr]PćÐ%)ǔĞ5 'ǾÞť)Čƕy Ɲ±Ä|)4(ÿž"NPWk=ŁƆ#ǿ ǻõČ 24 ö 9 ĵ 25 ī½Ǽ ǻõČ 24 ö 10 ĵ 15 ī½ţǼ. 1P>F (1) "OpenSiS" ,http://www.OpenSIS.org, (2012)ǿ (2) "SchoolTool: the Global Student Information System", http://www.schooltool.org/, (2012). (3) Per M. Gustavsson and Anna Persson:"Experiences from the annual 24-hour software engineering competition at University of Skövde: how to use simulation for detecting good software engineers",WSC '05 Proceedings of the 37th conference on Winter simulation, Article No. 25, (2005).. Research Reports of Kumamoto-NCT. Vol. 4（2012）. －6－.

(48)