· 'TRUONG D~I HOC GTVT TP. HCMKHOA CONG NGHt THONG TIN

CQNG HOA xA HQI cnuNGHiA vrsr NAMDQcl~p- TVdo- H~lDhphuc

DE CUONG CHI TIET HQC PHANTin hoc CO' ban

(Ban hann kem theo quyet dinh s6A.to4IQD-DHGTVI', ngay:1A11212019cua Hieu trueing Truong Dai hoc Giao thong vdn tid Thanhph6 H6 Chi Minh)

1. TAng quat v~ hoc phAn

Ten hoc ph§n Tin hoc CO' ban

Mff s5 h9C phan: 124012r's6t~chi------T2ti~~hi-(i:i~2)------.... ---- ..--·T------·- --..---·--- ·····-·····..· ,, . -,- - ..-;- ..- -..-.---------- .....----.- .... --- .-..-- -1'- - - c--.. ·- -- .- --- -- ---I .--------- -.- ·r-------------~! .------------ ------, . II So tiet 45 LT 15 I BT/TL 0 TN/TH I 30 BTL 0 TKMHI i 0 I! (ThlJc h9C) I I ' DAMH! !1- S5 ti~t----- i 30 LT IS STlli!ol TNIW-tisinto!TKMH!-~O- i,(T~_n!'.:ie~(ruL_1 L_ J I _! __j____k~ .. 1. __ 1

! Thuc tdp ben ngoai: buoi. If ·- -·-- ·-·-- - ..- ·- ·- ..··-·-- \.- - - -- --..... .. - -....... ..- - ..Qua trinh:Danh gia(Thang diem 10) BAi t?P 100:

Thi cu5i IcY:

..........................._

CNTTcaban) !f-----.------------- ..----.-f----.-.---..-.-----------·-- ..J.. .. .____ -.--------------r------- - -- - - ---.I

Mon tien quyet - I MS: I

:M==0=n=h~9::C::~=tru==6~C~~~~~~-~_.~_.-~_:~::~~-._._.~:~~~-.::~~~::::_.-~:_._.~=:~~~_.:~~:_.~=~_.:-.~=~~:~:~~~~_.~_.~~--.~==~-.:~~===~~==:~M.---S.--:.-.--.--..-.·..---..-.~~-.........-_~Mon song hanh MS:CTDTnganh eli cdc kh6i ngimh

Trinh dQKh5i ki~n thirc

h(JcThu9Ckh6i kiin thuc: Can ban

Ghi chu khac Sinh vien khong dircc vang qua 20% s5 ti~t h9CGhi chu:- Nhiing chft vih ttit: LT; If; thuyet, BT: bai tdp, TL: thdo ludn, TN: thi nghiem, TH thuc hanh,BTL: bai tdp Ion, TKMH: thiit ki mon hoc, DAMH: D6 em man hoc

- Bai tdp Ion: m6i tin chi co khong qua 1BTL, m6i hoc phdn co khong qua 3BTL- TKMH, DAMH: la cac a6 an ho(j.cthtit ki mon h(Jcco ma h(Jcphc1nrieng

- Gie}Lf; thuyit: 1 tin chi = 15ttit- Gie}BT, TL, TN, TH: 1tin chi =30 tiit.

1

2. M1}ctieu cua hoc phin

Sinh vien diroc trang bi cac kien tlnrc co ban va dao tao ley nang thirc hanh theo quy dinhchuan ky nang co ban su dung Cong nghe thong tin theo thong tu s6 03/20 14/TT-BTTTT ngay11 thang 3 nam 2014 cua B<)Thong tin va Truyen thong quy dinh chuan ley nang sir dung Congnghe Thong tin va phuang phap giai toan bang may tinh.

3. Mo ta tom tit hec phin

3.1 Phin thuc hoc

Bao g6m phan ly thuyet va thirc hanh, theo cac mo dun co ban trong phu luc cua quy dinhchuan kY nang su dung Cong nghe thong tin co ban (Ban hanh kern thea Thong tu s6 03120141TT­BTTTTngay 111312014cua B(Jtruong B(JThong tin va Truyen thong); diroc chia lam 2 phan va6 chuang nhu sau:

Phin A. Ki~n thtrc v~may tinh va mang internet

Chuang 1.Module 1: Hi~u bi€t v~ CNTT co ban

Chuang 2. Module 2: SUdung may tinh co ban

Chuang 3. Module 6: SUdung Internet co ban

Phin B. Ky nang sir dung cac tfng dung van phong

Chuang 4. Module 3: Xu ly van ban co ban

Chuang 5. Module 4: Su dung bang tinh co ban

Chuang 6. Module 5: SUdung trinh chieu co ban

3.2 Phin tl}' nghien ciru

Bao g6m ph§n ly thuy€t va th\1Chanh:

- Xu ly van ban

- Su dl,lilgbang tinh

- SUdl,lilgtrinh chi€u.

4. NQidung hQcphin

4.1NQidung kh1ii quat

1 Phin A. 5 0 5 10

Ki~nthuc v~may tinh va m\}nginternet

Chuang 1.Module 1:Hi~u bi€t v~ CNTT co ban 2 2 4

Chuang 2. Module 2: SUdl,lilgmay tinh co ban 2 2 4

2

I

Chuong 3. Module 6: Sir dung Internet co ban 1 1 2

2 Phdn B.

Ky nang sir dung cac .mg dung van phong

10 30 25 65

Chuong 4. Module 3: Xir ly van ban co ban 4 12 10 26

Clnrong 5. Module 4: Sir dung bang tinh co ban 4 12 10 26

Chuong 6. Module 5: Sir dung trinh chieu co banATong 15 30 30 75

2 6 5 13

(TH: thuc hanh; BT: bed tdp; TL: thdo ludn; TKMH: thiit ki man hoc; BTL: bai tdp IOn;DA:a6 an man hoc)

4.2 NQidung chi ti~t va phirong phap giang day, danh gia

Phdn A. Ki~n thtrc v~ may tinh va mang internet

Chtrong 1. Module 1: Hi~u bi~t v~ CNTT cooban

Hi~u bi~t v~ Giang ly K~t quaCNTT co thuyet, dua thao luan

va lam bait~p

ban cau hoi1.1 Ki~n thrrc cooban v~ may tinh va mang maytinh Sir dung may thao luan

tinh co ban va bai t~p1.1.1 Phk cimg: May vi tinh va thi~t bi d.m taythong minh; cac thanh phan phan cirng; thiet bi trung Sir dungtam; thi~t bi nhap, xuAt, luu tnr; c6ng Internet co

ban1.1.2 Phk mem: Phan loai phan rnem; l~p trinh; ph§nrn~rnthuang m~i va phdn rn~rnngu6n rna

1.1.3 Hi~u nang may tinh

1.1.4 M~g may tinh va truy~n thong

1.2 Cac Ung d1}ngciia cong ngh~ thong tin - truy~nthong (CNTT-TT)

1.2.1 MQt s6 Ung d\lI1gcong va Ung d\lng trong kinhdoanh

1.2.2 MQt s6 Ung d\lng ph6 bi~n d~ lien l~c, truy~nthong

1.3 An toan lao dQng va bao v~ moi trU'img trongsir d1}ngCNTT -TT

1.3.1 An toan lao dQng

3

,ve t~p2.3.4 Quan ly thu mvc va t~p: ChQn, sao chep, dichuy~n t~p va thu mvc

2.3.5 Quan ly thu mvc va t~p: X6a, khoi phvc t~p vathu mvc

2.3.6 Quan ly thu mvc va t~p: Tim ki~m t~p va thufiVC

2.4 MQt sa phin m~m ti~n ich

TRIf)~

THeHAl501...._

1.3.2 Bao v~moi tnrong

1.4 Cac vin d~ an toan thong tin co ban khi lamvi~c vOimay tinh

1.4.1 Ki~m soat truy nhap, bao dam an toan cho duli~u1.4.2 Ph§n mem dQchai (malware)

1.5 MQt sa yin d~ co ban lien quan d~n phap lu,ttrong sir dung CNTT

1.5.1 Ban quyen

1.5.2 Bao v~du li~u

Chuang 2. Module 2: Sir dung may tinh cooban

2.1 Cac hi~u bi~t cooban d~ bAt diu lam vi~e vOimay tinh

2.1.1 Trinh tv va cac luu y thirc hien cong viec dungcach,antoan

2.1.2 M6 may, dang nhap va su dung ban phim, chuot

2.2 Lam vi~c vOi H~ di~u hanh

2.2.1 Man hinh lam viec

2.2.2 Bi~u nrong va cira s6

2.3 Quan Iy thir muc va t~p

2.3.1 Thu muc va t~p2.3.2 Quan ly thu muc va tep: xem thong tin, dichuyen d~n noi luu giu, tao duong t~t d~n noi luu giuthu muc, t~p2.3.3 Quan ly thu muc va tep: Tao, d~t ten, d6i ten t~pva thu fiVC, thay d6i tn,mg thai va hi~n thi thong tin

.::::;:

4

2.4.1 Nen va giai nen t~p

2.4.2 PhfuI mem diet virus, phan mem an ninh mang

2.4.3 Chuyen d6i dinh dang t~p

2.4.4 Da phuong ti~n

2.5 Sfrdung ti~ngVi~t2.5.1 Cac khai niem lien quan

2.5.2 L\1'achon va cai d{ltcac tien Ich su dung tiengVi~t

2.5.3 Chuyen d6i phong chtr Vi~t

2.5.4 SUdung nhieu ngon ngu trong mot tai lieu

2.6 Sfrdung may in

2.6.1 L\1'achon may in

2.6.2 In

Chirong 3. Module 6: Sfrdung Internet cooban

3.1 Ki~n thrrc cooban v~Internet

3.1.1 Cac khai niem/thuat ngu thuong g{lp

3.1.2 Bao m~t khi lam viec voi Internet

3.2 Sfrdung trinh duy~t web3.2.1 Thao tac duyet web co ban

3.2.2 Thi~t d{lt(setting)

3.2.3 Chuyen huang tir nguon nQi dung Internet nayqua nguon khac

3.2.4 Danh dAu

3.3 Sfrdung Web3.3.1 Bieu m~u va su dung mot s6 dich vu cong

3.3.2 Tim kiem, bQtim kiem (may tim kiem)

3.3.3 Luu nQidung

3.3.4 Chuan bi in va in

3.4 Sfrd1}ngthtr di~n tfr

3.4.1 Khai ni~m va nguy co khi sir dVngthu di~n tir

3.4.2 Vi~t va gui thu di~n tir

3.4.3 Nh~ va tn'llai thu di~n tir

5

Ph§n B. Ky nang sir dung cac fulg dung van phong Cac thao tac, Lam vi du K~t quaIcy nang can mau, dua thuc hanh

3.4.4 Quan ly va nang cao hieu qua su dung thu di~nill

3.5 MQt s6 dang truy~n thong s6 thong dyng

3.5.1 Dich vu nhan tin tire thai (1M)

3.5.2 Cong d6ng tnrc tuyen

3.5.3 Thuong mai dien tu va ngan hang dien tu

Tham khao: tai lieu [1], chuong 1,2,3 tai lieu [2],modun 1,2,6 tai lieu [3]

Chirong 4. Module 3: Xir Iy van ban CO' ban

4.1 Ki~n thrrc CO' ban v~ van ban, soan thao va xirIyvan ban

4.1.1 Khai niem van ban

4.1.2 Soan thao van ban va xu 1yvan ban

4.2 Sir dung mQt ph§n m~m xir Iy van ban cy th~

4.2.1 M6, dong phan mem xu 1yvan ban

4.2.2 M6 van ban co sfut, tao van ban moi, hru, xoavan ban

4.2.3 Bien t~p nQidung van ban

4.2.4 Xu 1y16ihi~n thi tieng Vi~t

4.3 Djnh d~ng van ban

4.3.1 Dinh dl;lllgvan ban (text)

4.3.2 Dinh dl;lllgdOI;lllvan

4.3.3 Ki~u dang (style)

4.4 Nhung (embed) cac <f6itU'Q11gkhac nhau vaovan ban

4.4.1 Bang

4.4.2 Hinh minh hQa (d5i tu<;mgd6 hQa)

4.4.3 HQPvan ban

4.4.4 Tham chi~u (reference)

4.4.5 Hoan tAtvan ban

4.5 K~t xuit va ph an ph6i van ban

4.5.1 In van ban

ban d~ sudung cac irngd\lllg vanphong

yeu d.u bait~p va thuchanh

G

6

----------------------

4.5.2 Phan ph6i van ban

4.6 Soan thong di~pva van ban hanh chinh

4.6.1 Soan thao mot thong diep

4.6.2 Soan va xu ly mQtvan ban hanh chinh m~u

Chuong 5. Module 4: 8ft dung bang tinh CO' ban

5.1 Ki~n thirc CO' ban v~bang tinh

5.1.1 Khai niem bang tinh

5.1.2 Phfutmem bang tinh

5.2 8ft dung phin m~m bang tinh

5.2.1 Lam viec voi phan mem bang tinh

5.2.2 Lam viec voi bang tinh

5.3 Thao tic d8i vo; 0 (0 tinh)

5.3.1 Nhap dfr lieu vao 0

5.3.2 Bien t~p nQidung, s~p xep thir tv cac 0

5.3.3 Sao chep, di chuyen nQidung cua 0

5.4 Thao tic tren trang tinh

5.4.1 Dong va CQt

5.4.2 Trang tinh

5.5 Djnh dang m9t 0, m9t day 05.5.1 Kieu s6, ngay thang, ti€n t~

5.5.2 Van ban

5.5.3 Can chinh, tao hieu irng vi€n

5.6 Bi~uthrrc va ham

5.6.1 Bieu thirc s6 hoc

5.6.2 Ham:

5.6.2.1 Ham s6 hoc

5.6.2.2 Ham chu6i

5.6.2.3 Ham logic

5.6.2.4 Ham thai gian

5.6.2.5 Ham di€u kien

5.6.2.6 Ham tim kiem Vlookup/Hlookup

5.7 Bi~udA

7

------- -------------------

5.7.1 Tao bieu d65.7.2 Chinh sua, ciit, dan, di chuyen, x6a bieu d65.8 K~t xu§t va phan ph6i trang tinh, bang tinh5.8.1 Trinh bay trang tinh d~ in ra

5.8.2 Ki~m tra va in

5.8.3 Phan ph6i trang tinh

Chirong 6.

Module 5: Sir dung trinh chi~u CO' ban

6.1 Ki~n thirc CO'ban v~bal thuy~t trinh va trinhh·1.c leu

6.1.1 Bai thuyet trinh

6.1.2 PhfuImem trinh chieu

6.2 Sir dung phin m~m trinh chi~u

6.2.1 Lam viec voi phan mem

6.2.2 Lam viec voi bai thuyet trinh

6.2.3 Lam viec voi trang thuyet trinh

6.3 Xay dung nQidung bai thuyst trinh

6.3.1 Tao va dinh dang van ban

6.3.2 Danh sach

6.3.3 Bang

6.4 Dira bi~u d6, SO' d6 tAclnrc vao trong trangthuy~t trinh6.4.1 Bi~ud66.4.2 Sa d6 t6 clnrc

6.5 Dna cac d6i nrong d6 hoa vao trong trangthuy~t trinh6.5.1 Chen va thao tac voi d6i nrong d6 hoa da co6.5.2 vs hinh

6.6 Chu§n b], trinh chi~uva in bai thuy~t trinh

6.6.1 Chuan hi trinh chieu

6.6.2 Ki~m tra, in, trinh di€n

8

Tham khao: Uti li~u [1], chuang 4, 5, 6 tai li~u [2],modun 3, 4,5 tai lieu [3], tai lieu [4], [5]

4.3 Phfin bA thM gian chi ti~t

Phan bA sA ti~t cho hinh tlnre day - hoc

NQidungLenl6p

Thvc hanh,Tv TAng

Ly Bai Thao nghienthi nghiem

thuyet t~p lu~ cUu

Ph§n A. Ki~n thrrc v~ may tinh va5 5 10

mang internet

Chuang 1.Module 1Hi€u bi~t v~2 2 4

CNTTcoban

Chuang 2. Module 2 Sir dung may tinh2 2 4

co ban

Chuang 3. Module 6 Sir dung Internet1 1 2

co ban

Ph§n B. Ky nang sir dung cac Ung10 30 25 65

dung van phong

Chuang 4. Module 3 Xir ly van ban co4 12 10 26

ban

Chuang 5. Module 4 Sir dung bang tinh4 12 10 26

co ban

Chuang 6. Module 5 Sir dung trinh2 6 5 13

chieu co ban

TAng 15 30 30 75

4.4 NQidung tv nghien cuu

4.4.1 Xir ly van ban

1.Thi~t d~t moi truong lam vi~c tAi tru

1.1.Lira chon ch~ dQva thi~t d~t phil hQ'P1.2.Ap dung m§u

2. Djnh dang nang cao

2.1. Van ban

Cac thao tac, kY Sinh vien tv Thao luan,nang d€ xu ly nghien ciru trao d6ivan ban chuyennghiep han

9

2.2. Doan

2.3. CQt

2.4. Bang

3. Tham chi~u va lien k~t

3.1. Tieu d~, chan trang, chan bai

3.2. Muc luc va chi muc

3.3. Drum d~u, tham chieu

3.4. K€t n6i, nhung dfr lieu

4. Truong va bi~u miu

4.1. Truong van ban

4.2. Bi~u mau van ban

4.3. Ph6i thu (Merge)

5. Bien t~p van ban trong ch~ dQc(}ngtac

5.1. L§n v€t va ra soar5.2. Tai lieu chu

5.3. Bao v~ tai li~u

4.4.2 Sir dung bang tlnh

1. Thi~t l~p moi truong lam vi~c tBi U'U Cac thao tac, kY Sinh vien W Thao luan,1.1. Thi€t l~p bang tinh, cac thuoc tinh cua bang nang d~ sir nghien ciru trao d6itinh dung bang tinh

1.2. Sir dung mau

1.3. Bao m~t dfr lieu

2. Thao tac bang tinh

2.1. 6 va vung 0

2.2. Trang tinh

2.3. Ham va cong thirc

2.3.1. Bi€t sir dung them cac ham toan hoc, thongke, thai gian, tai chinh, van ban, CCY sa dfr lieu

2.3.2. Bi€t each sir dung mang trong ham

2.4. Bi~u d6

2.5. Lien k€t, nhung va n~p dfr li~u til ngoai

chuyen nghiephon

10

2.6. Phan tich dii li~u

2.7. sip x€p va loc dii lieu

2.8. Ki~m tra S\l hop thirc cua dii lieu

3 B·A tA 'I>' I.t. len ~p va an ve

3.1. Ghi chu, nhan xet, thay d6i (sua, x6a) n9idung trang tinh

3.2. LfuJv€t cac thay d6i d6i voi bang tinh

4.4.3 8ft dung trinh chi~u

1.L~p k~ hoach cho vi~c trinh chi~u Ole thao tac, Icy Sinh vien tv Thao luan,trao d6i1.1. Tim hieu v~ b6i canh trinh chieu nang d~ su

1.2. Thi€t k€ n9i dung va hinh thirc bai trinh bay dung trinhchieu chuyennghiep han

hieu qua

2. Trang thuy~t trinh chu va cac m§u

2.1. Trang thuyet trinh chu (trang chu)

2.2. Mfru

3. Cac d6i ttrQ1lgd6 hoa

3.1. Dinh dang cac d6i nrong d6 hoa, tranh anh

3.2. Xu ly cac d6i tuong d6 hoa

3.3. SU dung d6 thi, sa d6

3.4. Da phuong ti~n trong trang chi~u: fun thanh,do~ phim, ho~t hinh

4. Lien k~t, nhung, nh~p/xu§t cac trang chi~u,ban trinh chi~u

4.1. Lien k€t, nhung

4.2. Nh~p, xuftt

5. Quan Iy cac ban trinh chi~u

5.1. Trinh chi6u thea yeu cAu

5.2. Thi€t l?p cach thuc trinh bay

5.3. Ki~m soat vi~c chi€u cac trang

nghien ciru

\,...;2

5. Tai li~uhQc t~p

11

[1] Thong tu sb 03/20 14/TT-BTTTT ngay 1113/2014cua Be)tnrong Be)Thong tin va Truyenthong v~ quy dinh chuan Icy nang su dung Cong nghe thong tin.

[2]Bai giang Tin hoc co ban cua Khoa Cong nghe thong tin, Truong Dai h9CGTVT.

[3] Be)Ne)ivu, Chudn kjJ nang sir dung cting ngh¢ thong tin, NXB Lao de)ng- Xa hoi, 2016.[4] r.eDuc Long (Chu bien), T~ Quang Thanh, re Thi Huyen, Gido trinh hidu biit vJ Cong

ngh¢ thong tin co ban, NXB D~i h9CSu Ph~ TP H6 Chi Minh, 2016.

[5] Joyce Cox, Joan Lambert, and Curtis Frye, Step by Step Microsoft Office Professional2010. published by Microsoft Press, 2011.

6. Cac hi~u bi~t, cac ky nang cin d~t dUQ'csau khi hoc mdn hoc

Hi~u bi€t can ban v~may tinh, h~ di~u hanh va su dung thanh thao cac thao tac co ban voicac phfuImem tin hoc van phong (word, excel, power point), Internet.

7. HUOng d§n each danh gia hoc phin

- Di~m qua trinh: Xet di~u kien du thi.

- Thi k€t thuc h9Cphan: thi sat hach chuan CNTT co ban.

8. Danh sach giang vien d1}'ki~n

TS. To Ba Lam

ThS. Phan Chanh Minh

ThS. Nguy~n Van Huy

ThS. TrfuIAnh Tufu1

ThS. Nguy~n NgQcTh~ch

Cac giang vien khac do Be)mon ph§.ncongo

)

TP. H6 Chi Minh, ngayMthang 12 nam 2019

¥TS. To Ba Lam

Nguiri l~p d~ cuong

~

TruOng Khoa TruOng BQmon

TS. Le Van QuAc Anh ThS. Nguy~n NgQcTh~ch

~:::::::;;~H6 HI~UTRVONGPGS.Ts.uf~ ~,~

12