In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
DOI : 10.5121/ijdms.2017.9603 37
T
OBRUK
U
NIVERSITY
G
RADING
S
YSTEM FOR
C
OLLEGE OF
N
URSING
V
ERSION
2
IN
T
OBRUK
,
L
IBYA
James Neil B. Mendoza
1
, Do o hy G. Buha -Mendoza
2
and
C isola G. Tan
3
1
Lec u e – Compu e Subjec s, College o Nu sing, Tob uk Uni e si y, Libya
2
Lec u e – Nu sing Subjec s, College o Nu sing, Tob uk Uni e si y, Libya
3
Assis an Lec u e – Compu e Subjec s, College o A s and Sciences, Tob uk
Uni e si y, Libya
ABSTRACT
G ading is he p ocess o applying s anda dized measu emen s o a ying le els o achie emen in a
cou se. G ading measu es he s uden s’ academic capabili y. Da abase Managemen Sys em plays a i al
ole in eco ding in o ma ion o any kind. G ades o s uden s ma k can be eco ded in a eposi o y. As
he s uden pe o ms, all academic measu es we e eco ded in o he da abase sys em, o e he yea s i
accumula ed o a la ge amoun . Reco ded da a we e use ul in educa ional da a mining as unknown and
hidden da a pa e ns o all cou ses, da abase g ading sys em o Tob uk Uni e si y College o Nu sing
known as TUCON-GS 2 a successo o OMUCON-GS 1 can be used o ex ac and analyze his da a.
Da abase managemen sys em me hods and implemen a ions like eco ding o da a in ables, que ies and
epo , using Visual Basic as on end o he sys em and Mic oso excel as epo , he sys em and he
esea ch pe o ms acco ding o wha is needed and gene a ed aluable indings. O e all he TUCON-
GS 2 can p oduce help ul and meaning ul da a as i p omo ed simple educa ional da a mining. The
sys em se es as a i al elemen in he imp o emen o quali y educa ion o he College. The main
pu pose o his s udy is o documen and p esen he pe o mance and ope a ion o he sys em om
incep ion up o i s p esen o m, sol e he epo gene a ion challenge o e aining he old o ma
in eg a ed in he new sys em and o he p omo ion o DBMS, Compu e Science and Nu sing Educa ion
in Tob uk, Libya.
KEYWORDS
Da a Mining, DBMS, compu e science, academic pe o mance, Nu sing In o ma ics
1. INTRODUCTION
G ading is de ined in educa ion as he p ocess o applying s anda dized measu emen s o
a ying le els o achie emen in a cou se[1].In mos coun ies, all g ades om all cu en
classes a e a e aged o c ea e a g ade poin a e age (GPA) o he ma king pe iod o a semes e
o Colleges and Uni e si ies. The GPA is calcula ed by aking he numbe o g ade poin s a
s uden ea ned in a gi en pe iod o ime [2].Academic pe o mance sugges s how well a s uden
accomplished asks and s udies [3]. S uden e en ion and pe o mance a e deemed as impo an
issues o bo h educa o s and s uden s [4].
Academic pe o mance can be measu ed by di e en assessmen s like class es ma ks, lab
pe o mance, assignmen , quiz and a endance [5]. The accumula ed ma ks will hen be
a e aged. The GPA was hen e alua ed in he ollowing adjec i al a ing in Libya, 85-100%
Pe ec o Excellen , 75-84% Ve y Good, 65-74% Good, 50-64% Accep ed and 0-49 as
Failed/Unsa is ac o y [6]. In Tob uk Uni e si y College o Nu sing ( o me ly Oma Al Mukh a
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
38
Uni e si y), assessmen pe class we e manually eco ded by he acul y membe s in wha hey
called a ma k lis . The ma k lis is hen gi en o he egis a ’s o ice o encoding, p e iously in
Mic oso Excel wo kshee ha se es as hei educa ional da abase. E en ually i was
ans o med in o OMUCON-GS 1c ea ed by he au ho , i u ilizes s uden da abase g ading
sys em c ea ed wi h Visual Basic as on end and wi h MS-Access as i s back end suppo , s o e
s uden s’ pe sonal in o ma ion, educa ional pe o mance o e e y subjec wi h semes e s and
school yea di ided in o se e al que ies [7].Implemen ed since academic yea o 2010-2011,
da a s o age and e ie al we e made easy. I has unde gone se e al changes in e ms o
ope a ional aspec s. In 2014 he au ho uses he sys em o a da a mining esea ch [7].
Da abase managemen sys em is a sui e o compu e so wa e p o iding in e ace be ween use s
and da abases [8]. Da abase has been explo ed and pe o med o many yea s, known as a
collec ion o s uc u ed in o ma ion abou a subjec o o a pa icula pu pose [9]. The amoun
o da a s o ed in educa ional da abase inc eases apidly o e he yea s [10]and so is he amoun
o da a main ained in any elec onic o ma inc eased no iceably, as he amoun o in o ma ion
doubles so was he da abase a a g ea e pace[11]. Da a was eco ded as i was belie ed o be a
sou ce o po en ially use ul in o ma ion [12]. Da a in e e y bi has a lo o concealed
in o ma ion [13], as Collegia e educa ion e ol es so is he need o execu e da abase
managemen . Da a mining on he o he hand is a echnology used o ex ac meaning ul
in o ma ion and o de elop signi ican ela ionship among a iables s o ed in a da a se [10, 11].
Cu en ly Tob uk Uni e si y College o Nu sing G ading Sys em e sion 2 o TUCON-GS 2 is
he da abase sys em being used by he college. A successo o he OMUCON-GS 2 a e he
Tob uk b anch o Oma Al Mukh a Uni e si y sepa a ed om he main campus in A.Y. 2015-
2016 [14]. In his esea ch, he p oponen p esen ed a G ading Sys em cus om buil o he use
o he College o Nu sing. Explo ing he uses and bene i s o he sys em he s udy aimed o
p o ide wo hy educa ional da a o he Ins i u ion in aide o imp o ing educa ional compe ence
and academic pe o mance as a whole. The s udy also p omo es he use o Da abase
Managemen Sys em o handle educa ional eco ds.
2. MATERIALS AND METHODS
2.1 Sys em and Da a P esen a ion
The sys em will be p esen ed using exis ing da a se s o Academic pe o mance by he s uden s
in he academic semes e and he whole school yea as well. Simple da abase managemen
elemen app oach and implemen a ion was used o ex ac , analyze and p esen he da a in
use ul o ma . The s uden da abase g ading sys em TUCON-GS 2 was used o pe o m
da abase managemen and s a is ical ea men o da a. Collec ed da a and sys em ope a ion
we e o ganized in o igu es o pe mi ease o analysis. All da a measu es and i s p esen a ion
we e pe o med and gene a ed by he so wa e applica ion TUCON-GS 2. Repo gene a ion
codes o he ac ual sys em was also used.
2.2 S udy Popula ion
The s udy popula ion consis ed o 7 ba ches o s uden s we e all eco ds a e in he cu en
sys em. Ba ch 2011, his o ically he 4
h
ba ch o s uden s who en e ed he College o Nu sing on
Academic Yea (AY) 2010-2011, and he pionee ing ba ch o be en e ed in he sys em as 1
s
yea s uden s’ in he College. Respec i ely Ba ch 2012 up o Ba ch 2017was s uden s’ who
en e ed he college in AY 2011-2012 un il AY 2016-2017. Popula ion was selec ed based on
hei s uden numbe hence named Ba ch numbe . Addi ionally olde ba ches 2008, 2009 and
2010 we e also in he sys em albei wi h pa ial eco ds in he old and in he new sys em.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
39
2.3 P og amming Technique
The p oponen u ilized he 4
h
gene a ion echnique (4GT) in he de elopmen o he G ading
Sys em based on NPL o Non- P ocedu al Language echniques. Depending on he
speci ica ions, he 4GT employ a ious ools o he au oma ic gene a ion o sou ce codes [15].
I is he i al ool which uses he non-p ocedu al language o epo gene a ion, da abase que y,
da a manipula ion, use in e ace, code gene a ion, sp ead shee capabili ies and mo e.
2.4 So wa e Applica ion
Tob uk Uni e si y College o Nu sing G ading Sys em Ve sion 2 o TUCON-GS 2 is a
so wa e applica ion ha s o es s uden in o ma ion, subjec s o e ed and academic eco ds. The
sys em was u ilized o pe o m da a measu emen and p esen a ion. The sys em was c ea ed
using Visual Basic e sion 6 as on end, Mic oso Access o back end and Mic oso Excel
o epo gene a ion.
2.5 Clinical Ins uc o
A clinical ins uc o co-au ho ed he esea ch o p o e he in eg i y o he cou ses o e ed,
ope a ional aspec o he Nu sing College and e alua ion o da a. Compu a ional p ocess o
majo nu sing subjec s especially he ma ks o Rela ed Nu sing Educa ion (nu sing labo a o y)
and In ensi e Nu sing P ac icum (hospi al base). The sys em is in ended o bene i he Nu sing
College o Tob uk Uni e si y, clinical ins uc o and acul y membe , and nu sing s uden s.
3. The G ading Sys em
S uden epo we e eco ded and ex ac ed in TUCON-GS 2, igu es will be used o p esen he
ac ual sc een sho o he sys em du ing i s ope a ion. His o ical ope a ion o he old sys em un il
he la es e sion will also be p esen ed.
3.1 The old sys em
P io o he OMUCON-GS 1, he College o Nu sing uses Mic oso Excel o eco d and epo
he esul o he academic pe o mance o he s uden s. Se e al wo kshee s’ was used o
ep esen e e y subjec o cou se o a gi en semes e o school yea ( he College s a ed a
yea ly p og am o nu sing ins ead o a semes e ). Ano he wo kshee was used o p esen he
esul o all cou ses, GPA and a ing, all wo kshee combined will compose he wo kbook o 1
yea le el. Reco ds and ields we e mos ly w i en in A abic Language.
Figu e 1: Wo kshee o one cou se
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
40
Lis No, Name, S uden Numbe , Class Pe o mance, P ac ical Exam, Majo Exam, Final Resul
As shown in Figu e 1, he encode will use his Excel wo kshee o inpu he academic
pe o mance o he s uden s a e ge ing he manually w i en ma k lis om he acul y
membe . E e y cou se uses a s anda d sco ing al hough some acul y chooses o add o combine
some c i e ia. Basically he e a e wo possible cou se o subjec , one wi h labo a o y and one
wi hou labo a o y. Lec u e subjec s wi hou labo a o y consis o class pe o mance and majo
exam (mid e m and inal). Subjec s wi h labo a o y composed o class pe o mance, labo a o y
exam and majo exam. Passing ma k is 50 and abo e o all subjec s, al hough when he
p og am shi om yea ly o semes e , majo nu sing subjec s passing ma k was se o 60 o
highe .
Figu e 2: 1
s
Assessmen Repo : Final Resul , To al, GPA and Ra ing
A e encoding in o indi idual cou se wo kshee , ano he wo kshee will p esen he
accumula ed ma ks o all s uden s o e e y cou se, he agg ega ion o he ma k as To al, he
a e age as Pe cen equi alen o GPA and academic posi ion as e alua ion a ing. Academic
posi ion is di ided in o wo, esul and a ing. Resul is ei he he s uden s passed i hey passed
all hei subjec s o ake 2
nd
assessmen equi alen o a emo al exam a a la e ime. Ra ing is
when GPA was e alua ed using Libya’s s anda d a ing, 85-100% Pe ec o Excellen , 75-84%
Ve y Good, 65-74% Good, 50-64% Accep ed and 0-49 as Failed/Unsa is ac o y. Subjec s and
he es o he column ields we e ansla ed o English language o e e ence only.
Figu e 3: 2
nd
Assessmen Repo : Final Resul , To al, GPA and Ra ing
The e a e wo epo s ha he egis a p in s a e he exam pe iod (Figu e 1, Figu e 2). The 1
s
assessmen epo was p oduced a e he inal exam and he 2
nd
assessmen epo o he esul
a e he s uden s ha e aken he emo al exam. The di e ence be ween he wo epo s was ha
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
41
in 2
nd
assessmen he e will be 6 possible esul s, Passed i hey passed all hei cou ses, Passed
wi h 1 ca ie subjec , Passed wi h 2 ca ie subjec s, Repea he School le el, Failed/ change
p og am, Repo ed absen /no a ending classes/exam. Those who passed all subjec s in he 1
s
assessmen epo will no be included in he 2
nd
assessmen epo . The s uden can be p omo ed
o he nex yea le el e en i hey ail 1 o 2 cou ses, he ailed cou ses will be loaded o he lis
o subjec s he ollowing school yea . I hey ail 3 o mo e cou ses hen hey ha e o epea he
school le el un il hey passed all he emaining subjec s hey ailed. I he GPA o s uden s is
less han 35%, hey will be ad ice o change p og am and will no be accep ed in he college
again.
3.2 OMUCON-GS 1
In 2009, he College o Nu sing changes hei p og am om yea ly o semes e pe iod. The
cou se ou line was imp o ed, mo e subjec s we e added, and passing ma k o nu sing subjec s
was inc eased om 50 o 60. As he need o an o ganized da abase inc eased in 2010 he
managemen o CON sugges ed he c ea ion o a G ading Sys em. The au ho c ea ed he
da abase in Mic oso Access, using Visual Basic o Use In e ace. E en ually a e a se ies o
es o epo , he au ho decided o use Mic oso Excel o epo gene a ion called by a
p ocedu e in Visual Basic.
Figu e 4: Modi ied Splash Sc een o OMUCON-GS 1 (Ve sion 2)
Figu e 4 shows he splash sc een o OMUCON-GS 1, he las and la es design while he
College o Nu sing is s ill unde Oma Al-Mukh a Uni e si y. Ve sion 1 and e sion 2 o
OMUCON-GS is p e y much he same albei di e en logo and some upda e in he da abase
we e in oduced.
Figu e 5: Login Module o OMUCON-GS 1
In igu e 5, he use name and passwo d login was displayed. Only he egis a , exam supe iso
and encode we e en us ed he secu i y login o p e en unau ho ized access.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
42
Figu e 6: School Yea and Semes e Selec ion o OMUCON-GS 1
Since he incep ion o he semes e p og am, he G ading sys em was designed o i he school
yea and semes e di ision (Figu e 6). Fi s he ope a o mus choose he school yea o gene a e
hen choose which semes e , hen click Ok bu on o p oceed o he nex module.
Figu e 7: Main Module o OMUCON-GS 1
The main module o OMUCON-GS 1 as shown in igu e 7 le s he use o choose he school
yea and he depa men i necessa y in he combo box abo e. A sea ch bu on o cou se and
s uden eco ds il e ed by hei s uden numbe o accu a e pos ing is also included. The
Gene a e Repo bu on will be used o gene a ing he esul in a sp eadshee . Change bu on o
choose ano he school yea and semes e . Exi bu on o close he p og am.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
43
Figu e 8: Ope a ing he Main Module o OMUCON-GS 1
In o de o he epo o be gene a ed, he yea le el mus be selec ed and he depa men i he
yea le el is 3
d
o 4
h
yea le el. P e ious depa men includes Anes hesia, In ensi e and
Eme gency, Midwi e y and Public Heal h nu sing. Gene a e Repo bu on is disabled by de aul
and can only be ac i a ed when p ope yea le el is selec ed.
Figu e 9: Repo Gene a ed by OMUCON-GS 1
The esul will be gene a ed in a sp eadshee as shown in igu e 9, he wo kshee we e
au oma ically locked o p e en al e a ion.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
44
Figu e 10: Repo Gene a ed by OMUCON-GS 1 (imp o ed colo coding)
Ea ly design o he epo was a li le bi plain in e ms o appea ance, he exam supe iso
sugges ed changes in he colo coding we e passing ma ks will appea in black ex and whi e
backg ound cell, ailing ma k will be displayed in ed ex and blue shaded backg ound as
shown in Figu e 10. Unlike he o iginal wo kshee o he College’s g ading sys em, he
e alua ion a ing will only be gi en i he s uden passed all hei subjec s. Ca ie subjec s we e
placed a e he gene al a e age o GPA hus sugges ing i ’s no included in he compu a ion o
To al and Gene al A e age bu coun ed as a cou se. Since he College is an A abic ins i u ion,
epo s we e pos ed in a igh o le o ma . The name and e alua ion emained w i en in
A abic language.
Figu e 11: Repo Gene a ed by OMUCON-GS 1 (Ve sion 2)
A e a couple o yea s o so wa e implemen a ion, he Uni e si y changes i s o icial logo and
cou ses o e ed, hus mino changes in design we e added o he sys em (Figu e 11). Simila
wi h he i s g ading sys em, he epo o be submi ed by he egis a included he esul o
he 1
s
inal exam and 2
nd
inal exam. S uden s who passed all subjec s on 1
s
assessmen will no
be included in he epo o he 2
nd
assessmen .
3.3 TUCON-GS 2
In he middle o school yea 2015-2016 he Colleges in he Tob uk B anch o Oma Al-Mukh a
Uni e si y sepa a ed om he main campus hus hey es ablish Tob uk Uni e si y. Changes in
he logo, school and sys em ope a ion p omp ed he au ho o edesign he sys em albei wi h
minimal con igu a ion.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
45
Figu e 12: Folde o Repo Gene a ed by OMUCON-GS 1 and TUCON-GS 2
TUCON-GS 2 is an upda e o OMUCON-GS 1 and he eco ds and epo p oduced by he
la e we e in eg a ed o he new sys em. The same da abase we e s ill being used o he new
sys em, he epo we e sa ed as a wo kshee ile and so ed acco ding o school yea and
semes e as seen in igu e 12.
Figu e 13: Repo Gene a ed by TUCON-GS 2
Repo gene a ed by TUCON-GS 2 lis he s uden s name, con ol numbe , subjec s aken, o al,
Gen. a e age o GPA, e alua ion a ing i hey passed all subjec s, Ca ie o loading subjec s
e aken i p esen and gene al esul o s a us.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
52
Selec s a emen was used o choose he ields o be displayed in he epo . Compu a ion o
[G ade], [2nd] and Final G ade and de e mining i he subjec is a majo o mino cou se is also
included.
Inne Join s a emen was used o combine he app op ia e ables and was a ange by an O de
By clause based on s uden s [le el], [subjec ] and [Lis No] o so in ascending o de .
5. CONCLUSION
Tob uk Uni e si y College o Nu sing G ading Sys em e sion 2 pe o med gene ally well as a
Da abase Sys em o he College. Ha ing he sys em eases up encoding, collec ing o eco ds,
o ganizing and so ing o da a e ie al, and epo gene a ion. The sys em is unique in i s
design as he epo s we e e ained om he old sys em bu eco ding was in he new da abase
sys em ins ead. The s udy p esen ed he ope a ional aspec s o he College o Nu sing in Tob uk
Uni e si y in e ms o g ading o nu sing s uden s oge he wi h he use o TUCON-GS 2 and
his o y o i s p edecesso s using ac ual a chi ed epo s. Po ion o he ac ual sou ce code was
also p esen ed o add ess he epo gene a ion equi emen o he College. The sys em p omo es
no only he use o Da abase Managemen sys em and da a mining bu p omo es he whole
Nu sing p og am in Tob uk Uni e si y as well, being one o he ew Colleges using a sys ema ic
eco d handling o da a in Libyan Uni e si ies. The TUCON-GS 2 can also gene a e use ul da a
and u n i o a meaning ul one o p omo e educa ional da a mining and imp o ing quali y
educa ion.
REFERENCES
[1] In a aia S, "Il liceale con la media del 9,93 "Sonoilpiù b a o d'I alia"", epubblica.i (in I alian),
No embe 2009.
[2] h p://dic iona y. e e ence.com/b owse/g ade poin a e age, G ade Poin A e age. (n.d.)., Oc obe
2011
[3] Dela-C uz RA, Guido RM. Fac o s A ec ing Pe o mance o BS As onmy Technology S uden s.
In e na ional Jou nal o Enginee ing Resea ch & Technology 2013; 2(12):84-94.
[4] F iedman BA, Mandel RG. The P edic ion o College S uden Academic Pe o mance &
Re en ion: Applica ion o Expec ancy & Goal Se ing Theo ies. Jou nal o College S uden
Re en ion: Resea ch, Theo y & P ac ice 2009-2010; 11(2):227-246.
[5] Sho on HI, Haque M. P edic ion o S uden Academic Pe o mance by an Applica ion o K-Means
Clus e ing Algo i hm. In e na ional Jou nal o Ad ance Resea ch in Compu e Science & So wa e
Enginee ing 2012; 2(7):353-5.
[6] G ading Sys ems by Coun y,Libya,h ps://en.wikipedia.o g/wiki/G ading_sys ems_by_coun y
[7] Mendoza JNB, Buha -Mendoza DG, Libyan S uden s’ Academic Pe o mance and Ranking in
Nu sing In o ma ics –Da a Mining o S a e ’s, In e na ional Jou nal o Da abase Managemen
Sys ems ( IJDMS ) Vol.6, No.5, Oc obe 2014
[8] Robinson G, Use Access 2007 o ge S a ed in Da a Mining, www.da abasejou nal.com, 2009.
[9] P asadi GNR, Babu AV. Mining P e ious Ma ks Da a o P edic S uden s Pe o mance in hei
Final Yea Examina ions. In e na ional Jou nal o Enginee ing Resea ch & Technology 2013;
2(2):1-4.
[10] Roge AE, Ghislain AA, Joel SM. Mig a ion o Legacy In o ma ion Sys em based on Business
P ocess Theo y. In e na ional Jou nal o Compu e Applica ions 2011; 33(2):27-34.
[11] E dogan SZ, Timo M. A Da a Mining Applica ion in a S uden Da abase. Jou nal o Ae onau ics
& Space Technologies 2005; 2(2):53-7.
[12] Singh SP, Sha ma NK, Sha ma BK. Use o Clus e ing o Imp o e he S anda d o Educa ion
Sys em. In e na ional Jou nal o Applied In o ma ion Sys ems 2012; 1(5):16-20.
[13] Pandey UK, Bha dwaj BK, Pal S, Rajas han PBJ. Da a Mining as a To ch Bea e in Educa ion
Sec o . Technical Jau nal o LBSIMDS; 115-125.
[14] Es ablishmen o he Uni e si y o Tob uk,h ps://www. heuo .com/را/ةذ-ن-ا/, (in
A abic)
[15] Gup a S, 4GT in So wa e Enginee ing h p://shi gblog.blogspo .com/2015/03/4 h-gene a ion-
echniques-in-so wa e.h ml, Ma ch 2015.
In e na ional Jou nal o Da abase Managemen Sys ems ( IJDMS ) Vol.9, No.6, Decembe 2017
53
ACKNOWLEDGEMENT / SOURCE OF SUPPORT
The au ho s would like o hank i s and o emos God Almigh y o he g ace and glo y o His
name, gi ing us he gi o wisdom and inspi a ion o w i e his s udy. We acknowledge ou
amily specially ou mo he s and also ou iends, o hei unwa e ing suppo . And o he
publishe o he insigh in p omo ing esea ch de elopmen , hank you and God bless us all.
