TRlTCKVG DAI HOC AN GIANG
..

KHOA KY THUAT - CONG NGHE - MOI TRI/cnVG

NGUYfiN THAI THJ NGQC TRAN
LOfPDH3TH2
KHOA LUAN TOT NGHIEP CU" NHAN TIN HOC

CHlTOfNGTRINH
QUAN LY THITRAC NGHIEM TREN WEB

^l HQC

AN GIANG

THl/VIEN

GV. Huang din:
Ks. Dang Thi Nhung

AnGiang, 05/2006


Bao Cao Khoa Limn Tot NgbicpHe thing quan ly Ilii trie ngliifm

LO^ CAM ON
Em xin chan thanh cam an Ban Giam Hieu, quy thiy co Khoa Ky thuat - Cong ngh$ - Moi
truang va Trung tarn tin hoc truang Bai hoc An Giang da luon quan tarn, tao dieu kien hoc tap va

nhiet tinh chi b^o giiip chung em co di^u kien hoan thanh t6t luan van.

Em cung kinh giiri lai cam cm den quy thiy co trucmg Bai hpc Khoa hoc T^ Nhien va tnrang
Bai hoc Can Tha da truyen dat nhttng kien thuc quy bau cho tap the sinh vien Bai hQC An Giang
trong nhOng nam qua.
Bac bi?t, em xin chan thanh c^m an co Bang Thi Nhung - ngirai true tiep hudmg din, dong
vien va diu dat cho em trong suot thori gian hoan thanh laun van, va tSp the lap DH3TH2 da luon
quan tarn, giup d5 va tao dilu kien cho toi vuat qua nhumg kho khan trong hoc tap cung nhu trong
cuoc s6ng suot bon nam qua.

Mot lln ntta em kinh mong Ban Giam Hieu, qui thiy co tnrang Bai hoc An Giang khoa Ky
thuat - Cong nghe - Moi trucmg va Trung tarn tin hQC nhan nai em lcri cam an chan thanh va sau
sac nhat. Em xin kinh chuc qui thay co doi dao sxec khde, va luon gat hai dugc nhieu thanh cong
trong cuoc song.

Tran trpng kinh chao!

Long Xuyen, ngay 15/04/2006
Sinh vien: Nguyin Thai Th'iNgoc Tran


Bao Cao Khda Llian Tit Nghi ^p.Hf tltottg quail ly tlli Irac ughifin

TOM TAT
Ten de tai: "Chuang trinh quan ly tin trac nghiem trin web"

Giang vien hirdng din: KS. Dang Thj Nhung
Sinh vien thuc hien

: Nguyen Thai Thi Ngoc Tran

Noi dune: Xay dung hf thing qu^n ^^ thi trie nghiem hS trq cho gi^ng vi6n trong cong tac soan

ngan hang cau hoi va ra dl thi cho sinh vien. He thong duqc chia thanh hai thanh phan chinh:
1.Chdc nang qu^n ly ngan hang cau h6i: ho tru cho giang vien quan ^^ (them, xoa, sura) cau
hoi, dap an cda mon thi.
2.Chuc nang quan ly thi: vdi chtic nang nay, sinh vien sS chon mon dS thi, sau khoing thai

gian qui djnh cua giao vien chuang trinh tu dqng tinh diem va luu ket qua thi cua timg
sinh vien vao ca sd dQ lieu.
Yeu cau:

Chuang trinh phai tif n dung va dam bao tinh b^o mat
Phai ho tra cho giang vien nhilu loai cau hoi trong qua trinh soan ngan hang cau hoi
Cac cau hoi phai duqc tron ngiu nhien trudc khi cho sinh vien thi (khong co bai thi nao giong

nhau)

Cac bu&c thirc hien:

Tim hilu mot s6 hf th6ng thi trie nghiem
Lfp ki hoach phan tich va thiit ki hf thing
Tien hanh phan tich va thiit ke he thing
Cai dat chuang trinh
Thur nghif m

Mm tntcme cai dat:
-Ngon ngu lap trinh Web : PHP5

-Hf qu^n tri ca sd du Iifu MySQL5
-Trinh duyet Web : Internet Explorer

Ung dung may chii Web : Apache2



Bao Cao Kh6a Luan Tot Nghi?pHf th$ng quin ly tin trie ngliipn

MUC LUC
phAnmOdAu1
I.Ly do chgn dl tai:1
II.Boi tugng va pham vi ling dung:I

III.Muc dich va phiromg phap thuc hien:I
1.Muc dich:1

2.Co su ly thuylt:2

PHANN0IDUNG5
I.GI0ITHIfiU:5
1.Tong quan he thing:5
2.Mo t& pham vi he thong:6
3.Rang buoc tdng quan he thong:7

II.PHANTiCH:8
1.Phan tich h| th6ng :8
1.1.So d6 phan cap ngudi dung:8
1.2.Mo t^ hoat dong cOa he thdng8

2.Phan tich ySu c^u h6 th6ng:10
2.1.Cac yeu cau chiic n5ng v^ ySu cau phi chiic n^ng10

2.2.Mo hinh xii ly (DFD) quan niem :12
3.Phan tich dt lieu:18

5.7.

Mo hinh dur lieu miic quan niem (mo hinh thuc the k^t hop - ER):18

3.2.Mo ta cac thirc the va cac thuoc tinh cua thuc the:18

3.3.Thupc tinh mo t4 cho cc m6i kit hgp md rong18
3.4.Ciich qui djnh dat thuoc tinh tham gia lam djnh danh cho cac thuc thl18
III.THIET KE :20
1.Thiltkl he thong20
1.1.Thilt kl xii ly20
1.2.Thilt kl chuc nang phan mem24

2.Thilt kl du lieu:25
3.Mo ta cac rang buoc toan ven31


Bao Cap Khoa Lufin Tot Nghi^pHe th^ng quail ly till trie ngliifm

4.

Thiet ke giao dien35

Caidat:38
KETLILJlN39
I.Danhgiachung39
II.Hudmg dong gop cua lun van39
III.Huong phat trien40

TAI LIfiU THAM KHAO41


DANH SACH CAC BANG, HINH VE
Hinh II-3: Mo hinh xur ly hoat dong cua he thong quan ^^ thi trie nghiem12
Hinh II-4: Mo hinh xu ly mure 2 cua he thong quan ^^ thi trac nghiem13
Hinh II-5: M6 hinh phan ra 6 xii ly "Qu^n ly mon thi"14
Hinh II-6: Mo hinh phan ra 6 xur ly "Qu^n ly cau h6i"14
Hinh II-7: Mo hinh phan ra 6 xu ly "Qu^n ly dap an"15
Hinh II-8: Mo hinh phan ra 6 xcr ly "Qu4n ly thong tin ngudi dung"15

Hinh II-9: Mo hinh phan ra 6 xii ly "Qu^n ly dg thi"16
Hinh 11-10: Mo hinh phan ra 6 xti ly "Qu&n ly thi"16
Hinh II-l 1: Mo hinh phan ra 6 xil ly "Qu^n ly kit qu^ thi"17
Hinh 11-12: Mo hinh thuc the - ket h^p cila he thing quan ly thi trie nghiem18
Hinh III-l: So do tuan tu cho xir ly "Them cau hoi"20
Hinh III-2: So do tuan tu cho xCr ly "SOra cau hoi"20
Hinh III-3: So do tuan tu cho xur ^^ "Xoa cau hoi"21
Hinh III-4: So d6 tuin tu cho xii ly "Them dap an"21

Hinh III-5: So d6 tuin tu cho xii 1^ "SOra dap an"22
Hinh III-6: So do tuin tu cho xur ly "X6a dap an"22
Hinh III-7: So do tuin tu cho xir ly them sinh vien23

Hinh II1-9: Man hinh dang nhap h? thong35
Hinh 111-10: Man hinh quan ly mon thi36
Hinh III-l 1: Man hinh them mon thi37


Bao Cao Kh6a Luan Tot Nghi^pUS thong quan ly thi trie nghi$m

Danh sach cac ky hieu va cac tir viSt t;1t

KT-DG : Kiem tra - danh gia
DFD: Data Flow Diagram
ER: Entity-relationship modeling

ID: identify


Bflo do Khoa Luan T6t NgliiepH( til^ng quan ly thi trie nghifm

phAnmodAu
I.Ly do chon de tai:
Giao due dao tao dugc xem la qu8c sdeh hang dim trong giai doan hi$n nay. Trong do,

kidm tra - ddnh gia (KT-DG) kdt qua hoc tap la mgt khau quan trong trong qua trinh day hoc
trong nha tru8ng, la ca so &^ xdc nhan nhOng kdt qua dat ^ugc trong qtto trinh hoc tap cba
hoc sinh - sinh vien. Dua vao do, giao vien se co nhung quydt dinh mod d dieu chinh phuong
phap, ndi dung day hoc sao cho phil hgp nhim giiip hoc sinh - sinh vien dat dugc ket qua hoc

tap a giai doan sau dugc t6t hon, ddng then ket qua dat dugc trong KT-DG se giup cho hoc
sinh - sinh vien nh^n thly dugc nhung uu diem cda minh de phat huy, nhung mat yeu kem de
bo sung hay sua ddi. Nhung didu d6 to co so cho su tidn bd cua mi hoc sinh - sinh vien va
la co so nang cao chat lugng day hpc.

Co nhi^u hinh thiic KT-DG nhu ki8m tra viit, kilm tra thuc hanh... Tuy nhien, con tuy
vao muc dich, ngi dung hoc tap, doi tugng ma gjao vien se dua ra hinh thiic KT-DG phu hgp.

MiSt khac, theo m6t s6 pghi8n curu cho thdy, dl viec KT-DG dung vdi y nghTa cua no phai
dam bao cac yeu cau ve tinh muc dich, tinh thucmg xuyen, tinh he thong, tinh dien hinh va
tinh khach quan. Trong s6 cac yeu ciu tren thi yeu cau bao dam tinh khach quan to quan trong


nMt. Thuc to cho thdy, viec KT-DG phu thuoc v^o ygu to chu quan cua gtoo vign se khong
phan anh diing nang luc, ki6n thile dat dugc cua hgc sinh - sinh vien. Tinh khdeh quan doi hoi
phai co nhung tieu chi danh gia ro rang doi vdi tung doi tugng hoc sinh - sinh viSn d tung
giai doan hoc tap nhSt dinh, nhd dd co th6 h^n ch^ dn muc th^p nh^t yeu t6 chu quan co the
co cua giao vien trong qua trinh kiem tra, danh gto. Hien nay, mot so nha nghien cuu phuong

phap day hoc d nhiSu nude khac nhau tren the gicd da thira nhan KT-DG ket qua hoc tap cua
hoc sinh - sinh vien bang phuong phap thi trac nghiem cd kha n3ng dam bao tinh khach quan
cao.

Thi trie nghiem to mot hinh thuc mdi vua dugc ap dung trong nhiJng nam gan day vdi
nhiSu loai hinh khdc nhau. Tuy nhien, hinh thiic thi nay cung chi dugc tiin hanh thi tren giay,
cac thu tuc, cung nhu khau ra dl thi con gap nhieu khd khan va phiic tap. Do do, viec xay
dung mdt he th^ng thing thdng tin nhim tin hoc hda hoat dong day hoc trong nha trudng,
giup giao vien tiet kiem dugc thai gian, va giam bdt mgt so thao tac rudm to, phiic tap khi
chuan bi cac hinh thiic KT-DG la mot diiu cin thiet.
Xuit phat tir nhiing ly do tren ndn toi da chon di toi la viet
"Chitomg trinh quan ly thi trac nghiem tren Web " .
II.Doi tuong va pham vi ling dung:
Dii tugng sii dung: giao vien va sinh vien to hai doi tugng chinh, ngoai ra con can mot nha
quan tri de qudn ly nhung thong tin lien quan he thdng.
Pham vi ling dung: cd the ap dung tren pham vi trudng hoc

HI. Muc dich va phmmg phap thnc hien:
1. Muc dich:
Mp hinh thi trie nghiem hidn nay dang dugc dp dung rong rai trong nhidu linh vuc
vdi nhieu muc dich su dung khdc nhau nhu: tuyen dtm^ nhan su, trac nghiem tam ly, ...

dac biet trong Giao Due va Dao Tao vai tro cua thi trac nghiem ngay cang dugc khang
dinh.


Trang1


B^o Cao Kh6a Lu3n Tot NghiepH$ thong, quail ly tin trie ng/iifm
Ben canh do, cimg vdi sir phat triln cua cong ngh6 thong tin, tin hpc h6a he th6ng

thong tin quan ly la mdt hoat dong khong th thi^u trong thdi dai ngay nay. Vi vay, he
thdng quan \y thi trSc nghiem tren Web nhlm hudng d6n muc dich h trp cho giao vien va
hoc sinh - sinh vien trong Nha trubng co dugc cong cu de lam viec t6t horn, tiSt kiem dugc

thoi gian va chi phi.
2. Cff sd ly thuylt:
Hien nay, vdi sir phat tri^n cua Internet, nhitag ling dung Web tinh khong con dii kha
nang dap ling nhu ciiu cua thuc xk Cung vdi su h trg cua cac loai ca sd du: lieu, co thS kit
hop chiing vdi mot ngon ngii lap trinh Web tren server nhu: ASP, JSP, Perl, PHP... ngudi

ta co the xay dvmg nhfing trang Web dong va triin khai ling dung Web vdi nhi^u muc dich
khac nhau, phong phii hon, dap ling dugc nhu cau ciia ngudi dung.Tuy nhien, con tuy vao
miic do phiic tap, quy mo cua ling dung va nhung dieu kien khach quan khac ma ta chgn

mot ngon ngO lap trinh Web ket hop vdi ca sd dii lidu phii hop. Vi vay, vdi d6 tai nay, toi
chon ngon PHP kdt hop vdi hg qu^n tri co sd dii lieu MYSQL d6 h trg trong qua trinh
xay dung he thong. Day la hai cong nghe pho bien nhat dugc dimg de tao cac Website

dong hien nay, sau day la mot so dac diim ndi bat ciia cua PHP va MySQL :
2.1.Ngon ngir lap trinh web PHP5
PHP: la vidt tat cda "Personal Home Page" do Rasmus Lerdorf t^o ra nam 1994 d6

theo doi ngudi dung truy cap ly lich true tuyen cua ong. Vi tinh kha dung va kha nang

phat trien nen PHP da bat dau dugc sii ditng trong moi trudng chuyen nghiep va no trd
thanh "PHP:Hypertext Preprocessor". PHP la cong nghe phia may chu (server-side) khong
phu thugc moi trudng (cross-platform), va cd kha nang nhiing vao HTML.

Mot s6 tinh nang cua PHP:
Tuong thich vdi nhieu loai he didu hanh thong d^mg hien nay nhu: Linux, Unix,
Microsoft Windows, Mac OS X, RISC OS, ... Va h trg cho nhi^u web servers
nhu: Apache, Microsoft Internet Information Server, Personal Web Server,
Netscape and iPlanet servers, Oreilly Website Pro server, Caudium, Xitami,
OmniHTTPd,...

Mot trong nhftng dac tinh manh me cua PHP la kha nang thuc hien va tich hop
chat che vdi hau het co sd du ligu cd san, va vi la ma nguon md nen tinh linh

dong va kha nang phat trien cua PHP la khong gidi hgn.
PHP con hd trg nhi^u thu vien ham dugc thiet ke san va ling dung ldn dugc viet
theo hudng ddi tugng (nhu PEAR)
Ngoai ra, PHP con cd kha nang xuat ra web cac tap tin anh, tap tin PDF, phim flash...

va dac biet, tir PHP5 mo hinh hudng d6i tugng da dugc dua vao ling dung. Day cung la
diem manh cua ngon ngu lap trinh web PHP (cd the tham Ichao dia chinh thiic ciia PHP
tai dia chi />2.2.He quan tri eff sd dir lieu MYSQL:
Giong nhu PHP, h^ qu^n tri ca sd dii lieu MySQL la mot ling dung ma nguon md va
cd kha nang thuc thi hoan hao, r^t linh dong, nhd gon, it tdn chi phi nhung vln cd the xd
ly nhung co sd du lieu kha ldn.
MySQL la mot trong nhiing he quan tri co sd dii lieu nguon md pho bi6n nhat hien
nay, dimg pho bien cho cac doanh nghiep vda va nhd, MySQL dugc phat trien va ho trg
bdi cong ty MySQL AB. (dia chi web site cua MySQL: />
Trang 2



B:io C^io Kli6a Luan Tot Nghi^p

Hf thing quan ly thi trie nghi(m

MySQL server co the quan ly nhieu cor sa dft lieu cho hhiiu ling dung va moi ca sir
du IiSu co the luu trir dii HSu khac nhau vai nhiing each khac nhau.

MySQL thuQc loai ca s6r dii H6u quan he v^ co nhiiu tlnh nang kh6ng thua kem SQL
Server. Sau day la mot s6 dac tinh cua MySQL :
Cung cap transactional and non-transactional storage engines.

Cung dp nhieu kieu dtr lieu: signed/unsigned integers 1, 2, 3, 4, va 8 bytes,

FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME,
DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types
- MySQL co thS cai dat tren nhi6u he diSu hanh: Digital Unix 4.x, SunOS 4.x,
Windows 9x, Me, NT, 2000, XP, va 2003 ciia Microsoft... Tuy nhien, MySQL

mcri phat triln nen chi h trgr tren nhiing he di^u hanh gdn ddy.
Ho trgr nhi^u loai cau lenh va ham thong dimg cua ng6n ngu SQL
Bao mat: trong MySQL he thOng privilege va password cho phep mS hoa an toan
tit ca mat khiu khi kit nii vao server.
Ca sa dii lieu cua MySQL co thS chila khoang 50 trieu miu tin (record), mi
bang (table) c6 the chiia tren 64 chi muc (index).
Ngoai ra, trong cac phien ban mai ciia MySQL (MySQL 4.1, 5.0, 5.1) cho phep
khai bao cac chi muc nham tang tinh ndng tmy cap tlm kiem dii lieu va co ho trg
Unicode
2.3. Cac mo hinh dung trong phan tich va thiet ke:


^- M6 hinh thuc thi - kit hgp ER
Khai niem

^ nghia

Kyhieu

Thuc thi

Mpt doi tupng thong qua tim hiiu bai toan

Moi ket hop

Biiu diin mii quan he giiia cac thuc thi

o

Thuoc tinh

Bieu dien cac dac trung ca ban ciia thuc the
•

hay moi kit hpp.

Trang 3


Biio Cdo Kh6a Luan Tot Nghi^p

Hi thong quin ly thi trie iigliifm


• Mo hinh lubng dtt lieu DFD (Data Flow )
Khai niem
Oxuly

Ky hieu

Y nghia

o

MQt trong ede hoat dpng bSn trong cua

Dong dft lieu

?

HTTT, mi 6 xii ly duoc danh m6t s6 de
biet duoc n6 Id 6 xii ly thii may va a cap
nao.

Su chuyen doi thong tin gifta cac thanh phdn

Kho dtt lieu

Vung chtia dtt lieu, thbng tin trong h^ thong

Dau cu6i

Mot tac nhan ben ngoai he thbng

" So d6 tuan ttr (sequence diagram)

Khai niem

Ky hieu

Actor(tdc nhan)

Y nghia
Mpt thdnh phdn tuong tac vdi he thbng

Actor

Object(d6i tu^ng)

:Name

D
"1
1
1

Message(thong

diep)

Message

Bieu dien su chuyen giao cac thong diep
gitta cac d6i tuong


Trang 4


Bio cao Khda Luan T6t NghiepHS thong quan If tin trie nghifm

PHAN NOI DUNG
I. GIOH THIEU :
1. T6ng quan he thong:
Trubc day, viec soan va ra de thi a cac truang deu dugc thuc hid n bang phircmg phap
thu cong, moi giao vien khi lap de thi ludn phai can nhac ky luang trong viec xac dinh doi
tupng, noi dung thi dd co the d&nh gia diing nang lire hoc tap cua sinh vien. De co dugc de

thi phu hgp vdi yeu cau va diing chat luang, giao vien phai mat mgt khoang thai gian de
soan ngan hang cau hoi, xac dinh thang diem danh gia cho timg cau hoi. Khi sinh vien da

hoan tat bai kiem tra, day chinh la giai do^n doi hoi giao vien phai co tinh than trach nhiem
va su chinh xac rSt cao, dong thai khi cham bai phai nghiem tiic, khach quan va sang suot
sua chiia ngay nhQng 16i m^c phai cua sinh vien trong bai kiem tra.
Tren ca scr ket qua thu dugc, giao vien phai tien hanh phan tich toan bg de xac dinh gia
tri tong the dat dugc, sau do phan tich ky han a nhung doi tugng dac Met can dugc luu y,
tir do giao vien se rut ra nhung mat manh de phat huy dong thai tim each khac phuc nhung
mat y^u. Nhu vay d^ co dugc ket qua danh gia dung nang lgc cua sinh vien, giao vien phai
trai qua nhieu buac va phai dam bao tinh khach quan trong suot qua trinh thuc Men.
Vdi he thong Quan ly thi trac nghiem dugc xay dung tren moi truang mang Internet,
cac khau quan ly viec soan va ra d^ thi co th^ dugc dan gian hda m6t phan nao. He thong
la cong cu ho trg cho giao vien cd the quan ly cac cau hoi va de thi mot each dan gian, tiet
kiem dugc thai gian va chi phi. Giao vien hoan toan cd the chinh sira ngah hang cau hoi
cua minh cho phii hop vdi nhu cau, nhung phai tuan thu mot so rang huge cua he thong.
Viec soan de thi cua giao vien se dugc thuc Men mgt each nhanh chdng, giao vien chi can

nhap mot so thong tin lien quan nhu: so lugng cau hoi trong de thi, thai gian lam bai, ti le
cau hoi cho timg loai(dl, trung binh, khd)... Khi tien hanh thi, he thong se tu dong lay
ngau nhien cac cau hoi trong ngan hang cau hoi cua giao vien, hie nay, mac du ciing mon
thi nhung moi sinh vien se cd mot de thi rieng.
Ngoai ra, hg thdng con cd kha nang quan ly thai gian lam bai cua sinh vien, neu het gid
he thong se t\r dong luu bai thi va tinh dilm mot each khach quan theo so cau ma sinh vien
da lam. Kdt qua thi cua sinh vien se dugc luu lai de giao vien thdng ke, tong hop va danh
gia ket qua dat dugc sau dgt kiem tra.

Trang 5


He IhSng quan ly tlii trie nghiem

hio Cao Kh6a Luan Tot Nghiep

2. Mo ta pham vi he thong:

Hinh 1.1: Mo hinh mo ta pham vi he thong

Dai hoc An Giang

Nguoi lap: Nguyen Thai Thi Ngoc Tran

Ngay02/02/2006
Ten dw an: Chuong trinh quan ty thi trac nghiem tren Web
Quan ly dy an: Nguyin Thai Thi Ngoc Tran
Phat bieu van de:
o Co nhieu phuong phap kiem tra, danh gia ki^n th^c, namg lire hoc tap cua. Thi
trac nghiem la mot hinh thiic thi dang duqc xa hoi dat biet quan tam va duqc xem


la phuong phap ki^m tra d^nh gia nang luc hpc tap, trinh do hieu biit cua sinh
vien mot each khach quan nhat hien nay.

o Mac du thi bing phuong phap trie nghiem han chi duqc thoi gian va chi phi cho
giao vien so voi cac hinh thiic thi khac, nhung qua trinh so^n va ra de thi van con

gap nhieu khd khan, phiic tap do thuc hien bang phuong phap thu cong. Vi vay,
tin hoc hoa khau quan ly thi trie nghiem la mot nhu ciu cin thiet.
o Voi he thdng quan ly thi trac nghiem duqc xay dung se la cong cu ho trq dac luc
cho giao vien trong viec soan va ra de thi.
o Ngoai ra, he thong con co kha nang quan ly thai gian va tinh diem mot each
khach quan dtra ten ket qua ma sinh vien da lam. Sau dot kiem tra, giao vien co
the thong ke, tong hop va danh gia ket qua dat duqc.

Trang 6


Bao CSo Khiia Lu^n Tot Nghijp

He thing qumi ly till trie

1) Muc tieu
o Cho phep giao vien lira trft, truy xuat, cap nhat thong tin ve mon thi, cau hoi, dap
an

o Cho phep giao vien quan ly dtt lieu mot each ah toan
o Cho phep tir dong hoa khau chSm diem va tao d^ thi co cac cau hoi dugc tron
ngau nhien
o Quan ly duoc thai gian lam bai, thong bao k^t qu^ sau khi sinh vien hoan thanh


bai thi.
o Th6ng ke k^t qua thi cua sinh vien

2) Mo ta
o He thong se lira trO tat ca thong tin ve mon thi, cau hoi, dap an, de thi va ket qua
thi cua sinh vien

o Quan ly khau ra d, tinh di6m thi cho sinh vien dirdi hinh thurc tr^c nghiem tren
giao dien Web

3) Loi ich mang Iai
o Giiip giao vien quan ly ngan hang cau hoi mot each de dang va hieu qua
o Bao dam tinh khach quan trong viec cham diem thi cho sinh viSn
o Co the md rong nhieu loai cau hoi khac nhau trong tuong Iai
o He thfing c6 kha nang ket hap vdi mot so h^ thong khac ph\ic vu cho cong tac

qu^n ly trudc va sau khi thi
4) Cach budc thuc hien de hoan thanh du- an
o Lap ke hoach phat trien he thong .

o Phan tich he thong

o Thi^t k6
o Lap trinh
o Kiem tra

5) Thoi gian thuc hien:
o 4 th^ng (ke tit ngay lp ke hoach he thong)


Trang 7


Bao Cio Khiia Luan Tot Nghiep

He thong quart i^ thi trie nghiem

3. Rang buoc tong quan he thdng:
He thong phai diroc ket n6i mang Internet
Khong ^nh htrong den co cau to chiic va cac he thong khac cua Nhh trtrong

He thong sau khi trien khai phai dap ling nhu cau far dpng hoa hon 50% s6 lupng
cong viec lien quan

H. PHAN TICH:
1. Phan tich he thong :
1.1. So- dii phan cap ngvoi dung:

Quan tri he thong.-,
(admin)." .

Giao vien

' Sinh vien

Hinh III: So (to phan cap ngirol dung h| thSng

So- do tuffng tic thong tin:

H^ thong quan ii thi true

nghiem

Hinh II-2: So do tirong ^e thong tin he thdng quan ly thi trie nghifm

1.2. Mo ta hoat dong cua he thong
He thong quan Iy- thi trac nghiem duoc thuc hien hoan toan qua giao dien web, va

chia thanh hai phan chinh :
> Quan ly ngan hang cau hoi: Giao vien dang nhap he thong se vao trang quan tri
de them, xoa, stra thong tin sinh vien, mon thi, cau hoi, dap an, de thi va danh sach thi.

Trang 8


Biio Cao Kh6a LuSn Tot NghicpHf thong quan 1$ thi trie nghiein

> Quan ly thi : Sinh vien khi dang nhap, he th6ng se kilm tra sinh vien do co thuoc
danh sach thi khong, nlu cd, m6t man hinh giao dien se hien thi cho sinh vien chpn
mon de thi. Sau khi het thai gian lam bai, neu sinh vien van chtra lam xong hp thong se

dga tren s6 cau sinh vien da lam dirge de tinh diem. Kit qud se dirge hien thi ngay khi
sinh vien ket thiic phdn lam bai cua mlnh
Chi tilt cac chiic nang danh cho giao vien:
-Dane nhap he thorn: khi giao vien muon co tai khodn trong he thong, ho phdi
dang ky va cung cap mot so thong tin can thiet vdi nha quan tri. Khi tai khoan da

dirge tao, he thong se tir d^ng gui thong tin tai khoan din dia chi mail ciia giao
vien. Luc nay, giao vien co th^ dang nhap vao he thing vdi tai khoan tren.
-Oudn Iv mon thi: th6m, xoa, sua thong tin mon thi. M6i giao vi6n cd quyen
them mot hoac nhieu mon thi va chi c6 quyen thao tac tren nhttng thong tin lien


quan dn m6n thi nay. Chi dugc xoa mon thi khi mon thi do chira co dl thi nao
da thi
-Oudn ^ cau hoi: them, x6a, stira cau hoi. Ngan hang cau hoi lira trft nhilu Ioai
cau hoi theo timg mon thi, giao vien co quyen thao tac hen m6n thi nao thi he

thong se tir dong lift ke danh sach cac cau h6i lien quan den mon thi do
-Oudn Iv day an: tuang tu nhir quan ly cau hoi, giao vien chi dirge quyen them,
xoa, sura vdi nhiing dap an lien quan cac cau hoi cho phep.

-Oudn Iv dk thi: viec them, xoa, s^a de thi chi dugc thuc hign khi m6n thi da ton
tai va da co cau hoi, dap an hgp le.

-Oudn Iv danh sdeh thi: khi da l^p de thi, giao vien se tim trong ca so du lieu
danh sach cac sinh vien phu hgp d dua vao danh s^ch thi.
-Xem kit qua thi: Sau khi sinh vien da thi xong, kit qua thi se dugc luu lai, giao
vien co nhu cau xem kSt qua thi se nhaip mot so thong tin lien quan, he thong se

lift k^ danh sach cac sinh viSn thoa dilu kien tim kiem cua gido vien.
Chi tilt cac chiic nang danh cho sinh vien:
-Dans nhap he thong: khi sinh vien nhap thong tin tai khoan, he thong se kiem

tra sinh vien co ten trong danh sdeh thi khong, nSu co (dang nhap thanh c6ng) he
thong cho phep sinh vi^n chgn mon dl thi.
-Chon mon vd tiin hdnh thi: sau khi chgn mon, he thotig se tron cac cau hoi

theo dl thi md sinh vien da chgn va hiln thi ngi dung de thi cho sinh vien lam
bai.

-Xem kit qua thi: Khi sinh vien hoan tdt baj thi, hoac da hit thoi gian lam bai,

he thing se tinh dilm va hiln thi kit qua, ding then he thing se luu kit qua thi
vao ca scr du lieu

Chi tilt cac chuc nang danh cho nha quan tri he thong:
-Dans nhap he thdne
-Oudn Iv thons tin nsuai duns: them, xoa, sira thong tin va tai khoan nguoi

dung (giao viSn, sinh vien)
-Backup du HSu : de de phong nhirng su cl dnh hu6ng den dft li^u, nha quan tri
phdi thuong xuyen backup va restore dii lieu khi can thilt.

Trang 9


Bsio do Kh6a Luan Tfit Nghi^p

H^ thong quail 1$ thi trie nghiem

2. Phan tich yen caii he thong:
2.1. Cac yen cau chiic nang va yeu cau phi clnic nang
a. Cdcyen cau chi'cc nang nghiep vu
Yl: Quan ly lira trtt, truy xuit va cap nhat thong tin mon thi
Y2: Quan ly lira trtt, truy xuat va cap nhat thong tin ngan hang c^u hoi
Y3: Quan ly lira trtt, truy xuSt va cap nhat thong tin ly dap ^n
Y4: Quan ly lira trtt, truy xu^t va cap nhat dg thi
Y5: Quan ly lira trtt, truy xuat va cap nhat thgng tin giao vign
Y6: Quan ly lira trft, truy xuSt va cap nhat thong tin sinh vien

Y7: Lap danh sach thi
Y8: Tra ciiu kit qua thi

Y9: Thgng kg kgt qua thi cua sinh vien
Zs. Bang track nhiemyeu c3u nghiep vu

STT
1.

2.

3.

4.

5.

Nghicpvu
Them mon thi

Them cau hoi

Them dap an

Lap de thi

Tigp nhan giao
vien

6.

Tiep nhan sinh
vien


7.

Lap danh sach

thi

Nguoi dimg

Phan mem

Ghi chu

Cung cap thong

Kigm.tra qui dinh
v^ tigp nhan

Cho phep xoa, cap nhat

tin ve mon thi

Cung cap thong
tin vg cau hoi

Kigm tra qui dinh
va ghi nhan

Cung cap thong
tin vg dap an


Kiim tra qui dinh
va ghi nMn

lai dap an

Cung cSp thong
tin vg dg thi

Kigm tra qui dinh
va ghi nhan

lai dg thi

Cung cap thong
tin giao vien

Kigm tra qui dinh
va ghi nhan

Cho phep xoa, cap nhat

Cung cap thong Kigm tra qui dinh
tin sinh vign
va ghi nh^n

Cho phep xoa, cap nhgt
lai thgng tin sinh vign

Cung cdp thong

tin vg danh sach

Cho phep cap nhat lai
danh sach thi

lai mgn thi
Cho phep xoa, cap nhat

lai cau hoi
Cho phep xoa, cap nhat

Cho phep xoa, cap nhat

lai thgng tin giao vign

thi
8.

Tra

ciiu ket

qug thi
9.

Cung cap thgng
tin din tra ciiu

Tim va xuat thong


tin lign quan

Th6ng ke kgt Chqn dg thi din Xuat bao cao
th6ng kg
qua thi
thgng kg theo
BM9

Trang 10

!


Bao Clio Kh6a Luan Tot Nghifp

Hf thong quin I^ thi trie ngltiem

b. Cdc yeu cSu chicc namg he IhSng:
2s. Yeu ciu bao mat:

Nghicp vu

, Quan tri he. thong

1.

Phan quyen

2.


Them mon thi

3.

Them cau hoi

4.

Th6m d^p ^i

5.

Up de thi

6.

Ti^p nhan giao vien

X

7.

Tiep nhtin sinh vien

X

8.

Traciiu


X

9.

Bao cao th6ng ke

10.

Dang nhap

Sinh vien

X
X
X
X

X

X
X

X

X

X

Trangll



Bio Cao Khiia Lufin T6I Nghiep

Hf thong quin ly thi trie nghiem

is Bang Udell nhiem yen can bao mat:

1.

Ngtroi dung

Traeh nhiem

Phanmem

Quan tri he th6ng

Cho bigt cac

Ghi nhan va thuc

ngirai dung mai

hien dung

va quyen han
Giao vien

2.


Sinh vien

3.

Co th^ huy,
hoac thay d6i
quyen

Cung cap ten va

Ghi nhan va thtrc

mat khau

hien dung

Cung cap ten va

Ghi nhan va thuc

mat khau

hien diing

Co thS thay
d6i mat khdu

c. Cac yeu edit phi chwc nang

Yl : Giao dien than thien, dl su dung

Y2 : Dam bao toe do truy xuat dO lieu khong

Y3 : Du lieu phai duqc bao m|t
Y4 : Cho phep ttr dong hoa cac cong viec tinh diem, tinh thai gian lam bai, bao
cao, thong ke kt qua thi cua sinh vien

Y5 : Co chtic nang trg gitip nguoi dung
2.2. Mo hinh xti ly (DFD) quan idem :

Mo hinh xti ly miic 1: (t6ng quat)

Thong tin de thi
Thong tin nguoi dung-"""""""^
^^^^ Thong tin dap an

Admin

^^^
Thong tin khong hop Ie^

•"""""""^

Thong tin cau hoi
^7 He Thong V
1 Quan Ly Thi

Giao vien
--^

Thong tin mon thi


^_.^~~^\

/
Thong tin chonde thi

^^ Thong ti tra cuu ket qua thK^
Ket qua thi
Sinh Vien
Ket qua thi

Hinh II-3: M6 hinh xfl- ly in lie 1 (t6ng quit) cua h^ thong quan ly thi trie nghif m

Trang 12


Dao Cap Kh6a Luan Tot Ngliiep

He thong quan I^ thi trie nghifin

Mo hinh xfr ly mire 2: (chi tiet)

Thong bao dap an khong hop le

Hlnh II-4: M8 hi nil sir ly mile 2 cua h^ tilling quan ly thi tr^c nghi^in

Trang 13


B^o Cap Kh6a Lu^n Tot Nghifp


IIf thhng quail ly tin trie nghifm

Mo hinh xw ly mire 3:
Phan ra 6 xu-1^ 1.2: "Quan ly mon thi"

[Thong tin m

[Thong bao mon th

^^

Hinh II-5: Mo hinh phan rh 8 xtr ly "Quin ly mon thi"

Phan ra 6 xfr If "1.3 Quan ly cau hoi"

Hinh II-6: Mo hinh phan ra 6 xir ly "Qmin ly cau hoi"

Trang 14


H$ thong quin I^ Ihi trie nghiem

Bao Cao Khiia Lu8n Tot Nghi^p
Phan ra 6 xxt ly "1.4 Quan Iy dap an"

Olao
vien

y [Thong tin da


[Thong bao dap an

p an

Glao
vien

Hinh II-7: Mo hlnh phan ra 6 xfr ly "Quan ly clap an"

Phan ra 6 xii' Iy 1.5: "Quan ly thong tin ngirM dung"

[Thong tin nguoi dung]/
in hop le

Hlnh II-8: M6 hlnh phan ra 6 xir ly "Quan ly thong tin nguoi diing"

Trang 15


Bo C^o Kh6a Luan Tot Nghi^p

He thong quan Iy thi trSc nghi^^n

Phan ra 6 xir ly 1.6: "Quan ly d thi"

[Thong tin

[Thong bao de thi


Hinh II-9: M6 hinh phan ra 8 \ir ly "Quan ly 86 thi"

Phan ra 6 xir Iy 1.7: "Quan ly thi "

Quan ly thong tin nguoi dung,Quan '" de thi

Quan ly dang nhap

I/

[Thong tin sinh vien]

Quan lyket qua thi

rj)e ^j]

Hinh 11-10: Mo hinh phan ra o xir ly "Quan ly thi"

Trang 16


Bio Cao Khfia Lnan Tot Nghi^p

H^ thong quail ly thi trie ngliifm

Phan ra o x^^ ly 1.8: "Quan ly kit qua thi"

Quan lythi

[Ketq


thi]

[Ket qua thi]
cuu ket qua thi]
Ct_bai

qua thi]

Hinh 11-11: MS hinli phan ra S xu ly "Quan ly kit qua thi"

.TRUC5NGB^IHQC
:
AN GIANG

THl/VIEN

Trang 17


H^ thSng quan ly thi trite nghi^m

lo Cao Kh6a Luan To I Nghiep

3. Phan tich dfi'lieu:
3.1. Mo hinh du lieu miic quan niem (mo hinh thuc the kit lnj'p - ER):
TaiKlo^ IDTK

Enwil ^


TAIKHOAN

ngTlri

g.yThi

5HirfiAnli

.1)

Hinh 11-12: M6 hinh Ihuc the - kit hgp ciia h^ thong quan ly thi trfic nghi|m

3.2.MS ta cac time the va cac thuoc tinh cua thuc the:

oThuc thi GIAOVIEN: IDGV, MSGV, HoTen, DonVi.
oThuc thi SINHVIEN: IDSV, MSSV, HoTen, Lop.
oThuc thi TAIKHOAN: IDTK, TaiKhoan, MatKhau, Email, NhomND.

oThuc thi MONTHI: IDMT, MaMonThi, TenMonThi.
oThuc thi CAUHOI: IDCH, HinhAnh, MucDoKho, NoiDung.
oThuc thi DAPAN: IDDA, HinhAnh, NoiDung, KetQua.
oThuc thi LOAICAUHOI: IDLCH, TenLoaiCH.
o Thuc thi DETHI: IDDT, MaDeThi, NgayLap, SoLuongCauHoi, ThoiGianLamBai,
TiLeCHDe, TiLeCHTB, TiLeCHKho .
o Thuc thi BAITHI: IDBT, NgayThi, Diem.
o Thuc thi CTBAITHI: LDCTBT, CauHoi, DapAnChon.
3.3.Thuoc tinh mo ta cho cac moi kit hop mo' rong

o M6i kit hop DANHSACHTHI: TinhTrangThi.


Trang 18


Hf Ih6ng quail ly thi trie nghifm

Bao C^o Khda Luan Tot Nghiep

3.4. Cach qui dinh dat thuoc tinh tham gia lam dinh danh cho cac thuc the

Thuc thS GIAOVIEN

: co IDGV la djnh danh

Thirc thi SINHVIEN

: co IDSV la djnh danh

oThuc thi TAIKHOAN

:co IDTK la djnh danh

oThuc thi MONTHI

: co IDMT la djnh danh

oThuc thi CAUHOI

: co IDCH la djnh danh

oThuc thi DAPAN


: co IDDA la djnh danh

o Thirc thi LOAICAUHOI: co IDLCH la djnh danh
o Thuc thi DETECT: co IDDT la djnh danh
o Thuc thi BAITHI:co IDBT la djnh danh
o Thuc thi BAITHI:co IDCTBT la dinh danh

Trang 19