TRI^CING DAI HOC AN GIANG
KHOA KY THILVT - CONG NGHE - MOITRI/6NG

NGUYEN MEVH HUONG - DTH082048
KHOA LUAN TOT NGHIEP DAI HOC NGANH CU" NHAN TIN HOC

XAY DJTNGITNG DUNG WEB HO TRO
SINH VIEN XAY DUNG VA THEO DOIKE
HOACH HOC TAP TOAN KHOA HOC
TRLf^^NG DAI HOC
AN GIANG

THl/VIEN

Giang vien hirong dan:

ThS. Ho Nha Phong

An Giang, 05/2012


LOI CAM ON

Tru&c tien em xin giii loi cam on den tat ca Thay Co Khoa Ky thuat - Cong nghe Moi truang, Truang Dai hoc An Giang. Nhung nguai da tan tinh giang day va truygn dat
nhung kien thuc bo ich cho em trong suot nhung nam hoc qua, giup em co dtrqc nhung
kien thiic can thiet cho chuyen di thuc tap tot nghiep Ian nay cung nhu nhung tri thiic lam
hanh trang cho em vao doi sau nay.

Xin gui loi cam cm chan thanh den thay Ho Nha Phong, ngubi da tan tinh hudng
dan va giup do em trong suot thai gian lam luan van tot nghiep.

Toi xin giri lai cam an tdi nhSng nguai ban cua toi, cac ban da giup da toi rat
nhieu de toi co the hoan thanh bao cao cua minh.
Cuoi cung con xin cam on ba me, da sinh ra con, nuoi nang va day do con nen

nguai, da tao diu kien t6t nhdt de con co thl cap sach tdi trudng, dS con co the hoc tap,
lo lang va khuyen.khich dong vien moi khi con chan nan.
Xin chan thanh cam an tdt ca!
An Giang, ngay 18 thing 05 nam 2012
Sinh vien thuc hien

Nguyen Minh Huong


MUC LUC
CHUONG I. TONG QUAN1
I.Datvdnde1
II.Lich sii giai quylt vdn de1
III.Ly do chon de tai2

CHITONGII. NOl DUNG VA KET QUA3
I.. Mo ta he thong3

1.Mo ta nghiep vu3
2.Pham vi cua de tai4
2.1.Phat bilu vdn d84
2.2.Muc tieu cua he thong4
2.3.Chuc nang chinh cua he thong5

3.Danh gia kha thi6
3.1.Kha thi v6 kinh t86

3.2.Khathivekythuat6
II. Co sd ly thuydt:7
1.Ngon ngu PHP,7
2.jQuery8
2.1.Gidithieu8
2.2.Cach thuc lam viec,8

2.3.Cach sudungjQuery9
3.He quan tri co sd du lieu MySQL9
HI. Phan tlch he thdng10
1.Phan tich hien trang10
1.1.Mo ta hien trang10
1.2.Danh gia hien trang10
2.Phan tich yeu ciu10
2.1.Yeu cdu chuc nang10
2.2.Yeucauphi chiicnang12

li


3.Phan tfch chinh^13
3.1.So do use case13

3.2.So do lop50
3.3.Sa do tain tir56
4.Rang buoc toan ven60

IV. Thigtkg64
1.Thigt kg ca sa dir lieu64
1.1.Mo hinhquanhe64

1.2.So do qua'n he66
1.3.Mo ta cac bang67

2.ThiSt kS giao dien75
2.1.Giao dien trang chu75
2.2.Giao dien trang admin76

KET LUAN VA HII6NG PHAT TRIEN77
I.K8t qua dat duqc77
1.Lythuygt77
2.Thuchanh77
II.Han dig78
III.Huong giai quyet78

TAI LIEU THAM KHAO79
I.Tai lieu tham khao79
II.Website tham khao79


DANH SACH CAC HINH VE
Hinh 1. Mo hinh use casemiic 013
Hinh 2. Phan ra use case quan ly chuong trinh dao tao14
Hinh 3. Phan ra use case thong ke mo lop day trong hoc ky14
Hinli 4. Phan ra use case quan ly sinh vien15
Hinh 5. Phan ra use case quan ly thai gian va thong bao15
Hinh 6. Phan ra use case lam c6 van hoc tap16
Hinh 7. Phan ra use case binh luan mon hoc16
Hinh 8. Phan ra use case quan ly ke hoach hoc tap17
Hinh 9. Phan ra use case quan ly binh luan mon hoc17
Hinh 10. So do lap50

Hinh 11. Thupc tinh va phuang thiic ciia doi tuang Khoa51
Hinh 12. Thupc tinh va phuang thiic ciia doi tuang Bp mon51
Hinh 13. Thupc tinh va phuang thiic ciia doi tuang Nganh51
Hinh 14. Thupc tinh va phuang thiic ciia doi tuang Lop51
Hinh 15. Thupc tinh va phuang thiic ciia doi tuang Can b6 dao tao52
Hinh 16. Thupc tinh va phuang thiic ciia doi tuang Canb6 quan ly52
Hinh 17. Thupc tinh va phuang thiic ciia doi tuang Giang vien52
Hinh 18. Thupc tinh va phuang thiic cua doi tuang Sinh vien52
Hinh 19. Thupc tinh va phuang thiic ciia doi tuang Co van hoc tap53
Hinh 20. Thupc tinh va phuang thiic ciia doi tuang Nhom53
Hinh 21. Thupc tinh va phuang thiic ciia d6i tuang Thong bao53
Hinh 22. Phuang thiic va thupc tinh ciia d6i tuang Thai gian53
Hinh 23. Thupc tinh va phuang thiic ciia d6i tuang Chuang trinh dao tao54
Hinh 24. Thupc tinh va phuang thiic ciia doi tuang Ke ho^ch hoc tap54
Hinh 25. Thupc tinh va phuang thiic cua doi tuang Hoc ky54
Hinh 26. Thupc tinh va phuang thiic ciia doi tuang Khoa hoc54
Hinh 27. Thupc tinh va phuang thiic ciia doi tuorng Nam hoc54
Hinh 28. Thupc tinh va phuang thiic cua doi tuang Sinh vien - Chuang trinh dao tao....55
Hinh 29. Thupc tinh va phuang thiic ciia doi tuang Mon hoc55
Hinh 30. Thupc tinh va phuang thiic ciia doi tuang Khoi kien thiic dao tao55
Hinh 31. Thupc tinh va phuang thiic ciia doi tuang Loai mon55
Hinh 32. Thupc tinh va phuang thiic cua doi tuang Quy dinh binh luan55
Hinh 33. Thupc tinh va phuang thiic ciia doi tuang Binh luan56
Hinh 34. So d6 tuln tu them mai chuang trinh dao tao56
Hinh 35. So do tuan tu siia thong tin mon hoc57
Hinh 36. Sa do tuan tu xoa chuang trinh dao tao:.57
iv


Hinh 37. So do tuan tu them mon vao chirong trinh dao tao58

Hinh 38. So do tuan ^i lap ke hoach hoc tap58
Hinh 39. So do tuan tir phe duyet ke hoach hoc tap59
Hinh 40. So do tuan tir cap nhat hudng dan chung59
Hinh 41. So d6 quan he66
Hinh 42. Giao dien trang chii75
Hinh 43. Giao dien trang admin76


DANH SACH CAC BANG BIEU
Bang 1. Mo ta use case them mdi chuong trinh dao tao18
Bang 2. Mo ta use case them mdn mdi vao chuomg trinh dao tao19
Bang 3. Mo ta use case xda mon hoc khdi chuong trinh dao tao20
Bang 4. Mo ta use case dang xuat21
Bang 5. Mo ta use case cap nhat chuong trinh dao tao22

Bang 6. Mo tause case cap nhat danh sach sinh vien23
Bang 7. Mo ta use case tim kiem mon hoc trong chuomg trinh dao tao24
Bang 8. Mo ta use case xoa danh sach sinh vien...25

Bang 9. Mo ta use case cap nhat danh sach mon hoc se md ldp day trong hoc ky26
Bang 10. Mo ta use case xda chucrng trinh dao tao27

Bang 11. Mo tause case cap nhat thbi gian phe duyet ke hoach hoc tap28
Bang 12. Mo ta use case cap nhat thdi gian xay dung ke hoach hoc tap29
Bang 13. Md tause case phe duyet ke hoach hoc tap30
Bang 14. Md tause case cap nhat ke hoach hoc tap31
Bang 15. Md tause case them mdi danh sach sinh vien32
Bang 16. Md ta use case xda chuomg trinh dao tao33
Bang 17. Md tause case xdabinh luan34
Bang 18. Md tause case Lap ke hoach hoc tap35

Bang 19. Md ta use case them mdi binh luan36
Bang 20. Md ta use case thdng ke sd luomg sinh vien lap ke hoach hoc tap theo mdn37
Bang 21. Md tause case them mdi thdng bao37
Bang 22. Md ta use case dang nhap38
Bang 23. Md ta use case tim kiem chuong trinh dao tao39
Bang 24. Md ta use case xda thdng bao40
Bang 25. Md ta use case xem danh sach sinh vien se hudng dan41
Bang 26. Md ta use case phe duyet binh luan mdn hoc42
Bang 27. Md ta use case cap nhat hudng dan chung43
Bang 28. Md ta use case in chuomg trinh dao tao43
Bang 29. Md ta use case cap nhat thdng bao44
Bang 30. Md ta use case them mdi thdng bao45
Bang 31. Md ta use case cap nhat thdi gian chinh sua ke hoach hoc tap46
Bang 32. Md ta use case xem ke hoach hoc tap cua sinh vien..-47

Bang 33. Md ta use case xda binh luan va thdng bao vi pham48
Bang 34. Md ta use case cap nhat hudng din rieng49
Bang 35. Md ta RBTV160
Bang 36. Md ta RBTV260


Bang 37. Mo ta RBTV360
Bang 38. Mo ta RBTV461
Bang 39. Mo ta RBTV5:....:61

Bang 40. Mo ta RBTV661
B4ng 41. Mo ta RBTV762
Bang 42. Mo ta RBTV862
Bang 43. Mo ta RBTV9-.62
Bang 44. Mo ta RBTV1063

Bang 45. Mo ta RBTV11:63
Bang 46. Mo ta RBTV1263
Bang 47. Mo ta RBTV1364

vu


DANH SACH CAC KY HlEU VIET TAT
- Danh sach cac ky hieu:

Mot ngudi hoac mot
nhdm nguai tac dong
hoac thao tac den he

Actor

(Tac nhan)

thdng.

Use-case

(Trudng hap su dung)

Class

Attribute

(Lap)


^ Operation 0

Mot chuoi cac hanh dong
ma he thong thuc hien
mang lai ket qua quan sat
dugc doi vdi Actor.
La su trim tuang cua
cac doi tuang trong the
giai thuc.
The hien mot trinh tu xir
ly cua he thong trong
mot hay nhieu usecase.

Control class

:Contmller

(Lap dieu khien)

La tang dieu khien tuang
tie cua nguai ditng, lam
viec hyc ti^p vai Model
va cuoi cimg truy6n du

lieu cho ting View dl
hiln thi.
Nai luu tru du lieu.

Database


(Ca sd du lieu)
Tang truy xuat va lam

Model

viec vdi ca sd du lieu.
Bieu mau tra cuu thong

Form

tin trong he thong.

(Bieu mau)
,

Procedure

(Phucrng thtic)

ThemmonhocQ^ ,

0 ^

La phuang thiic cua doi
tuang ben phai thuc
hien yeu cau cua doi
tuang ben trai.

Tang hien thi ket qua xu
View


(Thd hien)

ly mot yeu cau cua actor
len trang web.


— Danh sach cac tvr viet tat:

i
2
3
4
5
6
7
8

CTDT
KHHT
SV
CVHT
CBQL
CBDT
QDBL
PHP

Chuong trinh dao tao
Ke hoach hoc tap
Sinhvien

Co van hoc tap
Can bp quan ly
Can bp dao tao

Quy dinh binh luan
Hypertext Preprocessor

IX


CHlTONG I. TONG QUAN
I. Bat van dl
Ngay nay, cong nghe thong tin tren the gidi noi chung va Viet Nam noi rieng dang
phat trien manli me. Cac to chuc va doanh nghiep cung khong ngirng tin hoc hoa, ung
dung cong nghe thong tin vao cac hoat dpng tac nghiep de giam bdt ton kem ve thai gian,
chi phi va nguon nhan lire. Va tat nhien, trudng Bai hoc An Giang cung khong ngoai le.
Be nang cao hieu qua quan ly hoat dpng dao tao, thong qua do nang cao chat lupng
dao tao nham tao ra nguon nhan lire cd chat lupng cao, ngay tir khi thanh lap Nha trudng da
chu truang ling dung cac phuang phap quan ly tien tien, trong do cd viec day manh ling
dung cong nghe thong tin vao hoat dpng quan ly. Nam hoc 2009-2010, trudng chuyen toan
bp he chinh quy tir dao tao nien che sang dao tao theo hoc che tin chi, danh dau budc phat
trien mdi sau mudi nam thanh lap. Cong tac quan li dao tao, cong tac giang day, hoc tap
truyen thong nhu trudc kia ton nhieu tai nguyen va hieu qua khdng cao. Mat khac, dao tao
theo hoc che tin chi lam cho viec hoc tap cua sinh vien thay doi theo. Be cd ket qua hoc tap
tot, tich Iuy nhieu kien thiic cho ban than, doi hoi sinh vien phai cd trach nhiem han, phai
nang cao y thiic tir hoc, phai cd phuang phap hoc tap hieu qua va chu dpng xay dung cho
minh mot ke hoach hoc tap khoa hoc, hop ly de khai thac cac uu diem ciia phuang thiic dao
tao mdi nhu cd the nit ngan thai gian hoc tap tai trudng, hoc them van bang thii hai.... Tren
ca sd do, viec xay dung cac he thong thong tin phuc vu cho sinh vien hoc tap theo hoc che
tin chi la rat can thidt va cSp bach.


II. Lich sii giai quyet van de
Hien tai, d Viet Nam so trudng dai hoc dao tao theo hoc che tin chi cho phep sinh
vien xay dung ke hoach hoc tap true tuyen va dang ky hoc phan theo ke hoach hoc tap do
la chua nhieu. Trudng Bai hoc An Giang chua cd mot he thong nao ho tra sinh vien xay
dung va theo doi kd hoach hoc tap toan khoa hoc. Trudng Bai hoc Can Tha cd he thdng
ho tra sinh vien xay dung ke hoach hoc tap dau moi khoa hoc va chinh sira ke hoach hoc
tap dau moi hoc ki tiep theo:
- Bau moi khoa hoc hay moi hoc ki trang web xay dung ke hoach lai dupe md
cho sinh vien xay dung ke hoach hoc tap va chinh sua, qua thai gian do trang web se
dupe ddng lai, sinh vien khong dupe cap nhat k6 hoach hoc tap cua minh.

rt-^

^i*


-Sinh vien xay dung ke hoach hoc tap thong qua hudng din cua co van hoc tap bang each
gap mat true tiep sinh vien chii khong co chuc nang hudng din thong qua he thong.
-Khong co chiic nang binh luan mon hoc nhlm giiip sinh vien mdi nhap hoc co
day dii thong tin de xay dung cho minh mot ke hoach hoc tap that tot.

III. Ly do chon dl tai
Cong nghe thong tin phat tri^n nhanh, ngudi dung duac hudng lai tu cac ling dung
Internet vdi cac dich vu nhu thu dien hi, tim kiSm tai nguyen, tin tiic, quang cao, lap lich
bieu va nhieu loai hinh khac. So vdi nhung phan mem khach chii (client/server) khac dang
co tren thi truong, ling dung Web du^e xem nhu ling dung ma trinh khach co the chay
tren nhieu loai thiet bi khac nhau tir may tinh de ban, may tinh xach tay, thiet bi di dpng
Ian cac thiet bi so khac, ngubi dung cd the sur dung chiing nhu mot tien ich de co the truy
cap noi dung cua nha cung cap dich vu a bat ki thai gian nao va bat ki dau tren the gidi.

Ben canh do, nhieu sinh vien cho rang chi can co gang that nhieu cho viec hoc tap
la se co ket qua tot ma khong can chon cho minh mot phuang phap hoc, xay dvmg cho
minh mot kg hoach hoc tap vai muc tieu duac xac dinh sin. Sir that khong phai vay, moi
trubng giao due dai hoc va cao dang da khac xa mpi trudng giao due pho thong lai them
dao tao theo hoc che tin chi, neu xay dung cho ban than mot ke hoach hoc tap khong tot
hoac khong lam gi ca, khong xac dinh chinh xac muc tieu can dat duac se dan den ton
nhieu thai gian va tiln bac ciia trudng, cua ban than dg hoc lai; ket qua hoc tap kem va thi
rot nhieu Ian dam ra chan nan, that vong, bat man vdi ban than, suy nghT tieu cue... lam

giam chat luong dao dao ciia trudng. Vao duac dai hoc, cao dang da la chuyen khd nhung
tich luy duac gi d moi trudng nay de lam nen tang cho cong viec sau nay lai cang khd
han. Kien thiic va thai gian la vo cung quy gia, khong duac phep lang phi. Do do, bat
buoc sinh vien phai xay dung cho minh mot ke hoach hoc tap that hieu qua, theo doi no
dudi su hudng dan va quan ly ciia Nha trudng.
Vi vay, viec xay dung mot ling dung web ho tra sinh vien xay dung va theo doi ke
hoach hoc tap toan khda hoc la rat can thiet.


CHlTOfNG II. NOI DUNG VA KET QUA
I. Mo ta he thong
1. Mo ta nghiep vu
Dau moi khda hoc, can bp dao tao cung la can bp quan 11 he thong se lap ra mot

khung chuong trinh dao tao cung la ke hoach hoc tap mau hrong ling vdi tung chuyen
nganh cua moi bp mon/khoa chira cac hoc ph^n dupe s5p xep theo thii tu dam bao cac
rang bupc (hoc phan bat bupc, hoc phan tu chpn, hoc phan tien quyet, hoc phan trudc, hoc
phan dieu kien, hoc phan tuang duong, cac rang bupc ve so tin chi toi da va toi thieu
trong hoc ki). Hoc ki dau tien ciia khoa hoc sinh vien tien hanh xay dung ke hoach hoc tap
va chinh sua no cr cac hoc ki ke tiep theo, qua trinh xay dung ke hoach hoc tap.nhu sau:
-Hoc ki dau tien, sinh vien dang ky hoc phan theo ke hoach hoc tap cua truong

(cac hoc phan can tich luy a hoc ki nay se dupe truong liet ke san vao ke hoach hoc tap
cua sinh vien) va sinh vien khong dupe phep chinh siia a hoc ki nay.
-Cac hoc ki tiep theo sinh vien xay dung bang each liet ke cac hoc phan con lai
theo y minh (nhung phai dam bao cac rang bupc) trong khung chuong trinh dao tao hoac
import thang chucrng trinh dao tao vao ke hoach hoc tap ciia minh.
D^u m6i hoc ki can bp dao tao se quy dinh thai gian xay dung kg hoach hoc tap
neu la hoc ki dau tien ciia khoa hoc, thai gian chinh sua ke hoach hoc tap, thai gian co
van hoc tap phe duyet ke hoach hoc tap. Sau do can bp dao tao dua vao nhu cau tich luy
mon hoc cua sinh vien ma dua ra cac hoc phan se dupe ma lap day trong hoc ki, thai gian
dang ky hoc phSn.
Chuang trinh dao tao, so hoc phan se dupe ma lap day trong hoc ki dupe nhap vao
he thong hoac dupe import vao tu tap tin excel theo cau tnic dirpc quy dinh san boi can
bp dao tao. Can bp dao tao dupe phep cap nhat chuang trinh dao tao.
Trong ke hoach hoc tap ciia sinh vien, cac hoc phan ma sinh vien chua tich luy chi
dupe xuat hien mot Ian, cac hoc phan a hoc ki bat ki phai dupe ma lop day trong hoc ki
do va t6ng s6 tin chi khong vi pham quy dinh s6 tin chi trong hoc ki (cac hoc phln khong
dupe ma lap day se tu dpng chuyen vao hoc ki tiep theo). Trudc khi sinh vien xay dung
hay chinh sua ke hoach hoc tap phai dupe sir hudng dan ciia co van hoc tap. Co van hoc
tap gap mat true tiSp sinh vien de hudmg dan hoac thong qua he thdng dua ra hudng dan


chung va hudng dan rieng cho tirng sinli vien ma minh chiu trach nhiem hudng dan. Sau
khi hoan thanh ke hoach hoc tap, sinh vien chd co van hoc tap phe duyet de dugc dang ki
hoc phan theo ke hoach hoc tap do. Co van hoc tap co the xem danh sach va thong tin hoc
tap cua sinh vien ma minh hudng dan.
Sinh vien co thd thu thap thong tin ciin thidt vd cac mdn s^p hoc bang each xem cac
binh Iuan mon hoc cua giang vien, sinh vien cac khda trudc. Giang vien va sinh vien dugc
phep vidt binh Iuan cho mon hoc va phai dugc can bo quan If bo mdn/khoa duyet, vdi
didu kidn: Giang vien chi dugc vidt binh Iuan cho nhung hoc phan thudc chuyen nganh
cua minh; sinh vien chi dugc phep binh Iuan hoc phan ma minh da tich luy.

2. Pham vi cua di tai

2.1.Phat biiu van &h
Hien nay qui mo trudng Dai hgc An Giang dang mo rong, so lugng sinh
vien he chinh quy cung tang len, lai them dao tao theo he thong tin chi nen sinh
vien tu hoc la chinh lam cho cong tac kidm soat viec hoc tap cua sinh vien trg nen
khd khan hern. Kho bidt dugc sinh vien co xay dung cho minh mot phucmg phap,
mot ke hoach hgc tap hay khong.
Sinh vien khd thu thap nhung thong tin cin thiet ve chucmg trinh dao tao de chon
cho minh mot phucmg phap hoc tap that tot, xay dung cho minh mot hud^g di dung d^n
va ngan nhat de ra trudng.

Cong tac ho trg sinh vien cua co van hgc tap chua that sir hieu qua khi so lugng
sinh vien ngay cang tang, ton thdi gian va chi phi.
2.2.Muc tieu ciia he thong
Giup sinh vien cd ki nang lam vide khoa hoc hem, lap ke hoach hoc tap de hoc tot hon,
khi cd ke hoach hgc tap sinh vien se chii dgng hgc tap va nghien cuu de tich luy kien thuc. Thu
thap dugc nhidu thong tin hudng dan hon ve cac mon hgc. Sinh vien cd the theo doi qua trinh
hgc tap cua minh de dua ra hudng di diing nhlt, chu dgng tich luy hgc phan cn thidt dd du didu
kien ra trudng. Cd van hgc tap cd them phucmg tidn de hudng dan sinh vien.
Giam but chi phi ve tidn bac, nhan su va thdi gian trong cong tac hd trg sinh vien
hgc tap. Nang cao ch^t lugng giao due cua trudng.


2.3. CIiuc nang chinh cua he thong
-Can bo dao tao:

+ Quan ly chircrng trinh dao tao: xem danh sach chuong trinh dao tao, xem chi
tiet chuomg trinh dao tao, them chuong trinh dao tao, cap nhat chuong trinh dao tao, tim


kiem chucrng trinh dao tao, in chuong trinh dao tao.
+ Quan ly thai gian va thong bao: thai gian xay dung va chinh sua ke hoach hoc
tap, thai gian phe duyet cua co van hoc tap, thai gian dang ky hoc phan theo ke hoach hoc
tap; them mdi thong bao, cap nhat thong bao.
+ Quan ly sinh vien: them mdi danh sach sinh vien; cap nhat danh sach sinh
vien; tim kiem danh sach sinh vien, xem thong tin sinh vien.

+ Thong ke mo lop: thuc hien thong ke so lupng sinh vien lap ke hoach hoc tap
theo mon; md lop day trong hoc ki.
-Can bp quan li bp mon/khoa:
+ Quan li binh luan: phe duyet binh luan cua giang vien va sinh vien; xoa binh
luan cua giang vien va sinh vien; thong bao vi pham quy dinh binh luan.
+ Cap nhat quy dinh binh luan cho giang vien va sinh vien.
-Co van hoc tap: phe duyet ke hoach hoc tap; cap nhat hudng dan chung cho sinh
vien; cap nhat hudng dan cho tirng sinh vien; xem thong tin hoc tap cua sinh vien; chinh
sua ke hoach hoc tap cua sinh vien.

-Giang vien: xem binh luan mon hoc; viet binh luan cho mon chuyen nganh; xoa
binh luan cua minh.
-Sinh vien:

+ Xem'chuang trinh dao tao; xem thong bao va thai gian, hudng din chung,
hudng din rieng.
+ Ke hoach hoc tap: lap kd hoach hoc tap (import kg hoach hoc tap mlu),
cap nhat ke hoach hoc tap.
+ Binh luan mon hoc da tich luy: xem binh luan mon hoc, viet binh luan mon
da tich luy, xoa binh luan cua minh.


3. Danh gia kha thi

3.1.Kha thi vg kinh ti
Khi chua co he thong, kho kiem soat dupe sinh vien co xay dung cho minh mot ke
hoach hoc tap hay khong. Sinh vien lap ke hoach thu cong, kho cap nhat thong tin, ton cong
sue va thai gian chinh sua. Nha tnrdng dua ra cac mon hoc du kien mo trong hoc ky theo ke

hoach dao tao dupe dinh sin chii chua hoan toan dua theo nhu cau chinh dang cua sinh vien,
rat kho cho sinh vien muon hoc vuert va hoc hai chuyen nganh. Sinh vien khong biet duac co
bao nhieu hoc phan duac ma ma phai tim kiem thong qua bo loc cua trang dang ky hoc phan
dan dSn cham trl trong viec hoc cai thien, hoc lai. Chua the hien duac vai tro cua co van hoc

tap doi vdi sinh vien. Sinh vien khong biet nen lam gi va se chuan bi nhung gi cho cac hoc
phan sap hoc. Sinh vien thieu chu dong dan den ket qua hoc tap khong tot, ton kem thai gian,
tien bac cua ban than va lam giam chat luang dao tao cua truong.

Khi co he thdng mdi, tao diSu kien cho sinh vien xac djnh duqc nen lam the nao de dSn dich
nhanh nhat ma chi phi thap nhat va tich luy duac nhieu kien thuc. Sinh vien chu dong xay dung cho
minh mot ke hoach hoc tap, chu dong chuan bi cho mon hoc, tich luy kien thiic can thiet nen ket qua
hoc tap se tot hern din den chat lupng dao tao dupe nang cao. The hien dupe vai tro cua ngucri co van

hoc tap, huong din cho sinh vien thuc hien ke hoach cua minh. He thong phan quyen ro rang nen cong
viec cua nguai quan li dao too citog giam bat, ton it thoi gian han.
3.2.Kha thi ve ky thuat
-Dp Ian cua du an:

+ Do he thong co nhieu nguai dung vdi vai tro khac nhau nen can phai phan quyen chat che.
+ He thong cho phep xay ke hoach hoc tap cho sinh vien he chinh quy, binh luan
mon hoc,... nen ca sd du lieu ldn.
-Cau tnic cua du an: Ca cau nhan su cua trudng rat it co kha nang thay doi.
-Cong cu phat trien:


+ He didu hanh: Window 7, Window XP.
+ Cong cu lap trinh: Notepad++ 5.9.3, Macromedia Dreamweaver 8, Vertrigo 2.2.

+ Cong cu phan tich thiSt kg: Software Ideas Modeler 3.0.
+ Congcuviet bao cao: Microsoft Word 2010, Microsoft PowerPoint 2010.


II. Ca s& ly thuy6t
1. Ngon ngfr PHP
PHP (Hypertext Preprocessor) li mot ngdn ngu lap trlnh kich bin hay mot loai ma
lenh chu yeu dupe dung de phit trien cic ling dung viet cho miy chu, ma ngudn md, dung
cho muc dich tdng quit. No rit thich hop vdi web vi cd thi di ding nhiing vio trang
HTML. Do dupe tdi uu hda cho cic ling dung web, tdc dp nhanh, nhd gon, cii phip gidng
C va Java, de hoc va thai gian xay dung sin pham tuong ddi ngan hon so vdi cic ngdn
ngu khac nen PHP da nhanh chdng trd thanh mot ngdn ngii lap trinh web phd bien nhat
the gidi.
Ngdn ngu PHP ra ddi nam 1994 bdi Rasmus Lerdorf (1968, GreenLand) sau do
dupe phit trien bdi nhieu ngudi trii qua nhieu phien bin. Phien bin dang phd bien li PHP
5.0 da dupe cdng bo 7/2004. Phien bin mdi nhit la 5.3.8.
Doan ma sau minh hpa giiip cich viet PHP long vio cic trang HTML de dang nhu
thd nio:
<html>
<head>
<title>Ma mlu</title>
</head>

<body>
<?php echo "Chao thd gidi PHP!"; ?>
</body>
</html>

The <?php va the ?> se dinh diu sir bit dau va su kdt thuc cua phin ma PHP qua
do miy chii biet de xu ly va dich ma cho dung. Day la mot diem khi tien lpi cua PHP
giup cho viec viet ma PHP trd nen khi true quan va de dang trong viec xay dung phan
giao dien ling dung HTTP.


2. jQuery
2.1.Gidithieu
jQuery la mot thu vien cua JavaScript nMm giiip do^ gian hoa each viet JavaScript
va tang t6c dp xu ly cac su kien tren trang web. Ngoai ra, vdi jQuery ban co the them
tuang tac Ajax, cac hieu ling,... vao trong trang web —> jQuery dupe thiet ke de thay doi
each viet Javascript cua ban.

2.2.Cach thuc lam viec
Thu vien jQuery cung cap mot lap trim tupng hoa, da dung dupe su dung chung
cho tat ca ma web do nguai dimg tao ra, tuy nhien do chi la nhung dac tinh cot loi, cai
chinh la d each tuy chinh cua ngudi dung (bang each viet them cac plugin de nhung vao
trang web cua minh).

Be bat dau vai jQuery, cong viec trudc tien la ban phai download thu vien jQuery
ve may tinh. Chung ta co the tai ban mai nhat tu dia chi />Sau do "nhung" thu vien vua tai ve vao tap tin HTML theo each sau (d day chung
ta xem thu vien jQuery co ten la jquery-1.2.3.js va dupe dat cung cap vdi tap tin HTML):

<html>
<head>

<script type="text/javascript" src="jquery-l.2.3.js"x/script>

<script type="text/javascript">
//Doan code jQuery cua ban dat d day

</script>

</head>

<body>
<a href="http ://j query .cofn/">j Query</a>

<Vbody>
</html>


2.3. Cach sir dung jQuery
Cac lap trinh vien JavaScript sau khi vigt xong ma thuc thi, neu ho rnuon cac ma
nay se dupe thuc thi khi trang dupe tai xong, dong lenh sau se dupe them vao:
window.onload = function(){ ... }

Khong con gi phai ban, tuy nhien, ma JavaScript khong chay cho den khi tat ca cac
hinh anh trong trang dupe tai xong (kg ca banner quang cao). Ly do cho viec su dung
window.onload la dg chSc chin ring HTML "document" phai duoc tai xuong hgt, sau do
mdi chay ma kia.
Dg giai quygt, jQuery co cau lenh don gian, tuong duong, dupe biet nhu la su kien
san sang (ready event):
$(document).ready(functionO
{//Doan code jQuery cua ban dat 6' day

});

Ma nay kigm tra document ya dpi cho dgn khi no san sang dg su dung. Hay lay
doan ma mlu d tren va cho vao tai lieu HTML cua ban. Cac vi du con lai cua jQuery se
dupe dat bgn trong phan callback cua ham nay, chung se dupe thuc thi khi tai lieu san

sang.

3. He quan tri eff s^^ dfr lieu MySQL
MySQL la he quan tri CSDL ma nguon mo pho bign nhat thg gidi va dupe cac nha
phat trign web rat ua chupng trong qua trinh ling dung. VI MySQL la CSDL toe dp cao,
6n dinh va dg sir dung, co tinh kha chuygn, hoat dong trgn nliigu he digu hanh cung cip
mot he thong ldn cac ham tien ich rat manh. Vdi toe dp va tinh bao mat cao, MySQL rat
thich hop cho cac ling dung co truy cap CSDL trgn Internet. MySQL mign phi hoan toan
cho ngn co thg tai vg tir trang chu. No co nhigu phign ban cho cac he digu hanh khac nhau:
phign ban Win 32 cho cac he digu hanh dong Window, Linux, Mac OSX, Unix, FreeBSD,
NetBSD, Novell NetWare,...

MySQL la mot trong nhirng vi du ca ban vg he quan tri ca sd du lieu quan he sii
dung ngon ngu truy van co cau tnic (SQL). MySQL dupe sd dung cho viec bo trp PHP,
Perl va nhigu ngon ngu khac, no la nai luu tru nhung thong tin trgn cac trang web vigt
bang PHP hay Perl,...


ffl. Phan tich he thong
1.Phan tich hien trang
1.1.Mo ta hien trang
Hien tai sinh vien xay dung ke hoach hoc tap chi thu cong va chua thu thap du
thong tin can thiSt v8 mon hoc cung nhu hudng din tir co van hoc tap, chua co phan mem
hay ling dung nao de ho tro cho cong tac nay.
Viec phd bidn cac thong tin v chuong trinh dao tao den sinh vien thudng thong
qua van ban hoac cac tap tin dinh kem word hay excel. Sinh vien dang ky hoc theo k
hoach hoc tap cua trudng chu khong theo mot ke hoach rieng nao ciia ban than.
1.2.Danh gia hi^n trang
Do chua co he thong nao nen sinh vien thuong co tam ly cha doi hoc phan duqc
mcr lop day mdi dang ky va bat dau hoc, chii khong chu dong xay dung cho minh mot ke

hoach hoc tap va dang ky hoc theo k^ hoach do.
Kho kiem soat viec sinh vien co chu dpng xay dung cho minh mot ke hoach hoc
tap hay khong. Sinh vien khong chu dong thu thap thong tin nen lam gi va nghien cuu
trudc cac mon hoc nen ket qua hoc tap chua cao.

2.Phan tich yeu cau
2.1. Yeu cau chirc nang

- Yeu clu ve luu trii
+ Luu tru ngudi dirag: He thong gom nhieu doi tuong tham gia nhung co th8
phan lam 4 loai sau: Can bo dao tao, Can bo quan li bo mon/khoa, Giang vien, Sinh vien.
+ Luu tru chuong trinh dao tao va k hoach hoc tap mlu: Chuong trinh dao tao
cua tirng chuyen nganh va ke hoach mau theo chuong trinh dao tao do.
+ Luu tru lap, bo mon, khoa, nganh: Luu tru thong tin lop, bp mon, khoa, nganh.
+ Luu tru mon hoc: Luu tru danh sach cac mon hoc cua toan trudng.
+ Luu tru khoa hoc, hoc ki, nam hoc: Luu thong tin khoa hoc, hoc ki, nam hoc.
+ Luu tru kg hoach hoc tap cua sinh vien.


+ Lvru tru cac binh luan mon hoc cua giang vien va sinh vien, hudng din cua co
van hoc tap cho sinh vien.
- Yeu cau ve nghiep vu

+ Module Can bo dao tao:
•Dang nhap va dang xuat he thong.

•Quan ly chuong trinh dao tao: them mdi chirong trinh dao tao; cap nhat
chuong trinh dao tao (them mon mdi vao chuang trinh dao tao, xda mon trong chucmg
trinh dao tao, tim kiem mon hoc trong chuong trinh dao tao); tim kiem chuong trinh dao
tao; in chuong trinh dao tao.

•Quan ly thai gian va thong bao: them mdi thdng bao, cap nhat thong bao, cap
nhat thbi gian xay dung ke hoach hoc tap, thai gian chinh sua ke hoach hoc tap, thai gian
phe duyet k^ hoach hoc tap, thai gian dang ky hoc phan.
•Quan ly sinh vien: them mai danh sach sinh vien, cap nhat danh sach sinh
vien lap, tim ki&n danh sach sinh vien lap, them mdi sinh vien vao danh sach, xoa sinh
vien trong danh sach.

•Thong ke md lap: thuc hien va thong ke so luang sinh vien xay dung ke
hoach hoc tap theo mon, liet ke so mon hoc se duac md lap day trong hoc ki.
+ Module Can bp quan ly bp mon khoa:
•Dang nhap va dang xuat he thong
•Quan 11 binh luan: xem binh luan, phe.duyet binh luan, xoa binh luan va
thong bao vi pham.
+ Module Giang vien:
•Dang nhap va dang xuat he thong.
•Xem thong bao.
•Co van hoc tap: xem danh sach sinh vien, xem ket qua hoc tap cua sinh vien,

phe duyet ke hoach hoc tap, cap nhat hudng dan chung cho sinh vien, cap nhat hudng dan
rieng cho tung sinh vien.


•Binh luan mon hoc thupc chuyen nganh: xem quy dinh binh luan, xem thong
bao vi pham quy dinh, xem binh luan mon hoc, them mdi binh luan mon hpc chuyen
nganh, xda binh luan cua minh.

+ Module Sinh vien:
•Dang nhap va dang xuat he thong
•Xem thong bao.


•K8 hoach hpc tap: xem hudng din chung cua co van, xem hudng dan rieng
cua co van, xay dung va xem ke hoach hpc tap (import ke hoach hpc tap mau), cap nhat
ke hoach hpc tap.
•Binh luan mon hpc da tich luy: xem quy dinh binh luan mon hpc, xem thong
bao vi pham quy dinh binh luan, xem binh luan mon hpc, them mdi binh luan mon hpc da
tich luy, xoa binh luan cua minh.

2.2. Yeu cau phi chuc nang
-He thong mdi phai hoat dpng chinh xac, nhanh chong va de nang cap (rang tuong lai.
-Giao dien than thien de sir dung.
-Dam bao cac yeu cau ve bao mat, an toan he thong: cac chuc nang tren he thong

phai dupe truy xuat bdi ngudi dung cd quyen han tuong ling.
-Chay tot tren cac trinh duyet thong thudng: Firefox, Internet Explorer, Chrome.


3. Phan tich chinh
3.1. So1 do use case
- Mu-cO:

HE THONG WEBSITE HO TRO SINH VIEN XAY DUNG VA THEO DOIKE HOACH HOC TAP TOAN KHOA

SlnhVien

Hinh 1. Mo hinh use case nine 0


- Muc 1:

+ Phan ra use case quan ly chuang trinh dao tao

QUAN LY CHUONG TRINH DAO TAO

Hinh 2. PhSn ra use case quan ly chuong trinh Sao tao

+ Phan ra use case th6ng ke ma lap day trong hoc ky
LOP DAY TRONG HOC KY

^ ttinclude*/

-.. aex

Hinh 3. Phan ra use case thong ke mot 16p day trong hoc ky


+ Phan ra use case quan Iy sinh vien
QUAN LY SINH VIEN

Hinh 4. Phan ra use case quan Iy sinh vien

+ Phan ra use case quan ly thai gian va thong bao

Hinh 5. Phan ra use case quan Iy thai gian va thong bao