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

論　文
şĹǹæ(:¦óćÐ¥ţ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=çžǿ'8Ǿ£Ɣ
6¦ŇƁ)ćÐ=ƢżǾĤƛ(ÿž#:4)¼9Ə2
°(XzT)ƒÁ$:7(Ĥµǥǔ)ćÐ¥ţ=
īôŮ(ƣ<;#ǿ1ǾLjö$*Kx_ozT)
9<#(5ǥ<8Ǿãǩ(ǗŦ#2:%ÀG
śƃƝ±%ćÐďƤ)Ä|=Ɯı(;8)ćÐ*Kx_
nx^P$é"ƪŏǘǾNPWk)ġ—Ăƪ%
ozT|)XzTdzP(Ƣż;Ǿ79…Ǥ¬Ŧ6
'!ǿ)4Ǿ†āĩ'NPWk=£çž:Ǿ
7(ćÐ¥ţ=;:%{ƟŮ%'!#:ǿ
†:NPWk)£ġ—“Ǵ=:Ăƪ9Ǿ;(
;8)NPWk=ãŢ#:S`YAB?*ÀÞľ$
#5ØÙ'KPYŬť:¾Ɲą:ǿ)ƒ‘)
Þ¢)ĤȏČ5)6ǾŒŀ)ǀÕ#:5)Ǿ
7(<ȀǹæǤ$5Â{)NPWk=¬Ŧ:%
1*ǣŬS`YAB?=ǂž¬Ŧ:%{Ɵ
*Ǯô(Ǭ%<!ǿ
Ů$:ǿ'8ĤÈǣŬ)NPWk$;+NP
;8)Éǵ*ǾŒŀ(7:NPWk)ÑÁHvzQZ
Wk)ƬŃÙ':0&ǗŦ#:ĤÈ)ƿĔÔ
SzP$:4(è'Öij$!#5Þľš$*$
²9ǾnjƚƁ(79•ß$'':%ǾŒŀ)
'%6ǾNPWk¢ǜ$)ćÐ¥ţ&)7('
ƨÇ$;+KPY9:%'&Éǵ%'!
;#:~Ǐĭ$:Ŝ(ǃË:ǿ"19ǾNPWk
#:ǿ
ġ—$)XzTdzPŁǓ)Ö¶ƪĶ)İŜ$‚ř$
õČ 21 öø(şĹǭœǹæ% ‰ǹæǹø¶£ƔǾ
'%(:ǿ1ǾNPWkǗŦ(Ğ<:ĤƚÈ)ƿ
şĹGnx^P% ‰Gnx^P%#{ǹæy„Gnx
ĔÔ5EzbxSzP$ǣŬ;Ǿ$(àâ#:5
)=ŕŦ:)$;+Ǿ:źøèđ
:%$
ǽ
şĹǹƁæǡÞľ şĹGnx^P
ćÐǑ–CuHYv[HPîÞŸ
861-1102 şĹŲÁăñDzê 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)ǿ
'8Ǿ;8*Ŗ×$)¬Ŧ=€(Ĉâ;#:
4īĹƸŤÓ$)¬Ŧ(~àŌ:ǿ
$ǾĤƛǥǔćÐ=ƒÁƄţ:4)NPWkǣ
Ŭ=ǾSzP*/#¡ǣ:‚â%#ǣÛǿ)
熊本高等専門学校　研究紀要　第 4 号（2012）
－1－
¦óćÐƄţNPWkǻĩƾŔ…Ǽ
ƀ{Ŋ%#Ǿ¦óƈNPWkǜ§(Š}ǾRoll System)á
ČǾãǗŦ=ǣÛǿ
Þť)¦óćÐ¥ţ*ǾĹľ$*;1$½ƼƙsPY
=ÀĤÈęŀ(ė
dž2Ǿ¦ó=¼9Ǿ;=HrP
%(Ŧĉ¦óƈ(DŽƲǾƒµƚÈ(7:{īŇó
#:Þť)ŶƷƣ'<;#ǿ1ǾƵǸķǤ%
(;1$)Ňƹĥ8¡Ň%¡)ĥ=ĤÈ£øú
ƃǾŢÏ)ĤµĠĝNPWk(ž±:%ĎDZ%'
!#ǿ$Ǿ…Ǥ'¥ţ=$:Ƈũ
¶:4(ęŀ({øž±='$¦ó
(ǥ:/#)¥ţƎ:NPWk%:%%
ǿ¦ó(ǥ:¥ţ*ęŀ){Ê$ƎǾ%
*Kx_ozTš$ƞ´Ů(ǥǔ:¥ţ=ƣ%$Ǿ
ĤȺ,ĤµƚÈ)ŀµ)ŽŗķĀ;:ǿ 8(ǾN
PWk|$)ćÐ¥ţƞ´¶;:%(79Ǿ
Î 1 fzkzezO8)sxHǥ”
y ŇóƙĥÔ²)LJǒ"Ŷã'ĐĜ(7:¸ņƄţ
y ƒƱ¥ţ(7:ÞťĠĝ
y ¦Ň)Ņ(7:ŶƷǻĤÈ)jP)ƧʼnǼ
y ŇƹǾŇóİĥ%Čƕ%)ǥǔƺĽŦ)XzTě’
y ƌżŇƹĥ)Ņ.)ǑŴ%ƽÅ
y ƒµŀ)Džŗ
'&Ǿ11'¬ŜƘ
8;:ǿĹƻħ$*ǣŬ
Roll System )ƶƍ%ĄŦƅÍ("#NJ/:ǿ
\. /:<4.G"
2.1
"CQ
†ÊǣŬ Roll System *Hr@?xYyLz]mXt
%Æ+;:ýċ=%!#:ǿÀŻćÐ¥ţ*Lz]š$
{œƄţ;ǾHr@?xY* Web arAM=Ɛŧ#Ǿ
XzTdzP(?HRP:ǿƄţƙ*Lz]=€%#
Ƅţ:$Ơ)$ƿĔDžŗ%':%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 =ęŀ(ė
dž>$NPWk=\VYwz
HƐŧ$Ŧ:%$:ǿ
2.2
"NG<4
ƥ 1 ƄţćÐ{Ư
Î 2 ¦ó=%:1$)ŕ;
Research Reports of Kumamoto-NCT. Vol. 4（2012）
－2－
ƥ 1 (NPWk$Ƅţ:ćÐ=ŷǿXzTdzP*
ĹNPWk*ÞťćÐ="ąǁ|ǾHr@?xY
ÀƪƋ$˜«)Wzat=!#:ǿ§Ƕ#•Ý:
%Lz]Ǥ)IJ¿¶Ǒ–%%5(ǾÞ¢æŦ LAN |8)
%$ǾXzT)Nj²'&)Öij!ÑÁ)þǰƅÍ
¬Ŧ$'7(Ƴâ#:ǿ1ǾpzMƷƴ
=đ
:%%5(Ǿ•ßąyĕûą=Ŷ•#:ǿ
* PHP $*ƣ<Ǿž±; ID %^PwzZ= PHP Ɛ
2.3
*
H5
ŧ$XzTdzP(ŘǾarAM8űĚ¹Ş$'
NPWk*ǾŠ}(ŷ;:Kx_ozT|(ŁƆ;
#:ǿ
7(ŶƷ:%$×ǜ8*pzMćÐƮ'Ƴ
Ʊ%'!#:ǿƷƴÚģÑÁ(*atzY`Dz
y CPU: Intel i5 3.00GHz ylms: 16GB
P?TVH.)åƂ%#&)pzM$Úģ)*Ŵ
y OS: FreeBSD 9.0-RELEASE
8Ǿ·(ƷƴÚģ%)ćÐ)2=lj7('
y DBMS: MySQL 5.1.61
y Web Lz]: Apache/2.2.2 + PHP/5.3.10
!#:ǿ8(ǾÀpzMō(Ǚ¨'?HRPń=Ƴâ
Ǿž¦±:ćÐ)ůƭ5'!#:ǿ
OS *Ƅţ)6%àâą8 FreeBSD %ǿWeb
]. %)0I?D
Lz]% DBMS ´;+74 Windows $)¬Ŧ5
¾Ɲ$:ǾXzT)]VH?Vb'&{ǜ)ņƝ*
/:2=-
Unix )KixZ=¬ŦPHsbY=¬Ŧ#:
Î 49 (vI@xŨǯ8¦ó=¼9Ǝ
:1$)NP
4ǾŤÓ(Ą#Øé)ÖijĂƪ%':ǿ
Wk)´Ũǯ=ŷǿvI@xň)ezO*ŸŰƁ
2.4
ǛĒezOǻÎ 5Ǽ%':ǿ$ŸŰǾīˆǾİǨǾǔƓ
%)H5
ĹNPWk* Web arAM´:ſĸ8$;+
ęŀĥ=ǛĒǾŐâ=ē%$ŶƷŨǯ(Ź:ǿīˆǾ
¬Ŧ¾Ɲ$:ǾpzM)ğ(Ą#ǮÂķ(Lz]
İǨ*vI@xİǤ8ǎƃ;ƞ´Ů(ž±;#
%Ǒ–=ƣ'8ŨǯǚŹ='4( Ajax ďƤ=
:šċ$:4ǾpzM*Ǒô$;+ŸŰ%ǔƓİ
¬Ŧ#:ǿ)4arAM* JavaScript )´:5
Ǥĥ=Ǜ-$7ǿŶƷŨǯ$*Ǿ$(¦óćÐ
)$:Ăƪ:ǿ
ÝÏ:ÑÁ(*|Ĵ#1%=Ǧ4ǾǣÛ
2.5
gTxǺơ(Ö¶:ǿǣÛ=ē%$Ǿ¤ųˆ)
!'%"SR
NPWk)fzkezO8)sxHǥ”=Î 1 (ŷǿ
¦óƈŨǯǻÞť{ƯŨǯǾÎ 7Ǽ(ǚŹ:ǿ¦óƈŨǯ
fzkezO8*Ǿ¦ó=¼: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－
¦óćÐƄţNPWkǻĩƾŔ…Ǽ
Î 8 ŸŰ«¦óšő{Ư
Î 5 ŸŰƁǛĒezOŨǯ
Î 6 ŶƷŨǯ
Î 9 ǕǤ¦óšő
Î 7 Þť{Ư
Î 10 fzkŨǯ
Research Reports of Kumamoto-NCT. Vol. 4（2012）
－4－
Ũǯ}ǜ)ŐâgTx=ē$¦Ň=%:ŀ*Ǝ
1$(+8İǤ!#1'&ÉǵŜ5Øǿ
%':ǿ¦ó=¼:%(ǥ:XzTdzP)ćÐÖij
ưŐƂ%#*Ǿ\VYwzH)ŝŤÓ$ž±Ǿ)
*)ŐâgTx=ēǩ)2'<;:)$ǐ$
ā1%4#Ǎ–:4)?bsJzNqx)«ǐǣŬ
Web arAM=Ǣ#5XzTdzP(Öij*'ǿŐâ
6ǾćÐ¥ţņŁ=ƫűǾǑ–Ǟ=¯ŗ:%'&
āƥŷ;:¦óšő)ezO$*ęŀ=ƣ!İǨ%Þ
Ƙ
8;:ǿ
ť)ðgTx('!#9Ǿ8¦óƈ)Ũǯ(
ŢİŜ$ãƦ=‚â#:ņƝ*Ǿ
č9XzT=Öij:%$:ǿ
y ĤÈ(7:ǛĒŸŰ½ƼÞť)ǛĒņƝ
y XzT) csv ýù$)@xhzYyCHPhzYņƝ
$*S8
/:<46@
ŸŰƁǛĒezO)ï|) Home gTx8Î 10 (ŷǾ
y ¦ŇXzT)īˆ%İǤ)ÖijņƝ
ÀŻņƝ.)sxHezO=¹Ş:%$:ǿ¦ó
y ęŀƧ³)4)ƇĮlmņƝ
ƈņƝ)sxH8*ǾŸŰƁǛĒezO%¦óšő{Ư
y Þť(7:ƞðƄţņƝ
.Ƿ-%$:ǿ1Ǿ?FAxYƄţ8*ÀŻņ
y pzMbvIrkãƣmzZ
Ɲ)Ƴâ=ƣ%$:ǻÎ Ǽǿ$*Ǿ¦ó=%
'&:ǿ½ƼÞťǛĒņƝ)ãƦ$*Ǿ)Ñ$½Ƽ
!%$Ǿlzt$)ćÐ=Ǎ:4)lzt?Zu
Þť=ƺĦ$:4Ǿë—ŸŰÖijİ'&(ƒµŀ)
P%Ǿ)dzø=Ő4:%€'ņƝ%':ǿ1Ǿ
ŽŗķĀ;:ǿ1Ǿ˜…)ĤÈ$ćÐ=Ƅţ
$ōÊǍ–)Ƴâ(#%$Ǿ)lzt)¢ä
ĤÈÄ(XzT)ž¦±= csv ýù%:%$Ǿ
=XzT)]VH?Vb%#¬Ŧ:%$:ǿ
Microsoft Excel %)ǔĞü¶=*:%%:ǿpzM)
,<4.G
bvIrkãƣmzZ*ǾXzT)¦±)Ăƪ'ǾLz
Roll System $*Ǿ¡Ň6™ÞǾnjÞ)ćÐ=Î (ŷ
]|$ưĻŦ)bvIrk=ãƣ:mzZ$:ǿÎ 13
ƒ°ž±ezO79ž±:%$:ǿ)ezO*
(ŷ7(ǾRoll System )XzT?HRPĪŒ(®!#Ǿ
ǑôĤÈ*¬Ŧ:%*'ǾÞť8ě¦;ć
àŸ(XzTdzP.)?HRP=ƣ'8ǾNPWk
Ð=œ()ķǤ=ž±#%$¦óƈŨǯ(»į
|$ćÐ¥ţ=ƣ%$:ǿ1ǾĹNPWk=ĕ
;:%%5(Ǿ¦óćÐ)ezO$*ƞ´Ů(Ʊƃ;
ûǾČƕž±%ÀŻÞľŀµǥǔĴǶ)¦±ņƝ=²
ƥŷ;:ǿÞöǾHrPǾÞŸǾÞƉŪ¿=ž±:
:%$ÞťćÐǥǔ)NPWk$áƑ;:5
%$ÞťÃƈƥŷ;Ǿð)Ņ(*UBVHgVHP
)%':‚â$:ǿĹƻħ$NJ/¦óƈNPWkǜ§
ƥŷ;:4ǾÂţŧ$ęŀ=3Þť={Ė#
$*Ǿ$(ÞťćÐǾĤÈćÐǾŸŰćÐŭǟ;#
ŭǟ:%¾Ɲ%':ǿ
:4ǾXzTdzPŁǓ%#*ņƝ=Ś#:
1 Roll System * 1 ǨŰǣÛā 40 §İŜ$)HrP%
ǾĴǶ)ýù(Ħý:ņƝĂƪ'4†āČ#
)¦ŇćÐ=ƞ´Ů(Ĕ‹%Ĥµ€ƒ(å#lztǍ–
ǿ1ǾƚÈ)ŀµƧ³$'ǾĹľ6‡)ǹæ
:ņƝ='
#:ǿ)ņƝ(79ǾūŎ)ǪÌĊ
ļ'&(7:ÞƊǢǠƁ)ªĨ=LJǒ(ƣ%$:
7(':ǿŇóÔ
Þť)ćÐ5ƞ´Ǎ–:ņƝ
='
#9ǾÞťĘç(ÿž"%ķĀ;:ǿ
^. +;TW
Ĺ Roll System *ǾõČ 24 öøāķ79ĹľyşĹGnx
^P$ǗŦ=ǣÛǿãǩ)ǗŦ(ǩ#÷")]I
Ŭƫ;ǾSzPKzZϜ(:4X]VH
¾Ɲ$:ǿ'8Ǿ\VYwzHĚƓ~àâ
'ŤÓ}$*¬Ŧ$'%6ǾÞť{ƯezO)ƥŷ
Î 12 ƒ°ž±ezO
Î 11 ?FAxYƄţŨǯ
Î 13 pzMbvIrkãƣmzZ
熊本高等専門学校　研究紀要　第 4 号（2012）
－5－
¦óćÐƄţ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－