cs?NG HOA XA iigx cHU NGHiA VIET NAit{ Dic lfp - Tqt do - H4ah phtic

uv eaNl.tHAI.{ oAhl TI{ANH PHo r'to cni prnvn so ci.{,o Dlc

ET

DAo rdo

vn

KV THI NGHT PHO THONG B,A.^C TRUNG HQC CO SO Ktr6a ngiy l0 thdng 6 ndm 2009

1

HANH TIN HQC - Thoi gian lim bdi :60 phlt

tuI6n thi : THTIC

1 Kh&i

dQng

Wi.u\Yorrl, t3o vin bin gi6ng miu drrrii diy theo cdc y6u ciu sau: (2.0d)

a) Gd nQi dung b) Chia 2 cQt c) DiopCap d) Tpo lVordArt e) Luu vdn bdn hoan chinh vdi t€n DE0I.DOC

'

L TtrOm tin tdc niy da thi6t lip duqc l\l rn0, *ung luoi uotn.t ttong i6 J. \ t tnaniz nam ir I rrl v6i ct rrat

.'semer

td

cdn

mPt

Microsoft

-

lu6i

]

, I

CO1Q chen tron g

mpt mpg

tran-e rveb "bEyl'.

cAi

mdt

n,i,

ri6

Pc ui'

rrSng crii bdi nrr6m na!

tOin 1xtt l tin]1'"""" Ii & Mi'. N{6t r} l9 deng

llflffietfi|iOng Chflm[V

khic duoc ghi nh4n o.{nh, Cariada, Dirc vir Phdp. t|6v Y tr-APt nnn kC

Excel.

D

B

ij

(0.5d) (1.0d) (0.5d)

mA ma-.1tan

i$t tgi Ukroine. Theo htrng bio m4t Finjan.6 hacker n6i tr€n di cdi phdn m6m d6c hai vito t!-L -^- -!.at^)--- ^r.^t- ..t.. t-^ uildu udiiLj Ldur! ut) uv t;tay -:., u n n4fi

2. Khdri tl$ng

(r.0d)

F

(J

B.L\GTEEO D6r !,fuA \'-L\ PEorrc ,STT

T?o

trrrtl

llii

l Irir E

.|

LE E6ng Plorg

T6a hiag 56 lagas

sd

rl2A

2o0J

02c

s5ol 2sol 60ol ssol 3sol

0lB Th! Siu

6

4 V6

I

fguyEo Gia ThiAu 6 Lf Thalng KiQt

Y€u ciu: a)

Nhip dt liQu theo m5u di

03c 04c 02D

Eal

Cih

ci:i; stl

thi

(0.5d)

vio kf tr5 thri 3 cria Mn s6 nhu sau: Ndu in "A" thi ghi vio "Lich bd rti". I.l€u la "B" thi ghi vio'Lich de ban,. ghivdo "Llchtreo (1.5d) rye"]L'C':thi cJ Don gid, voi "Lich treo tusng" thi don gid m6t td li 2000" bi6r riag lich treo hrong c6 SOi ,5 tJ. Col ri6i vtri "Lich bo rui" vi "Lich dd ban" thi dm gidgiong nlau la (L0d) d) .Giam gi6 = Don gi6 * Ti l€ giAm. Bi6t ring ti le giam dUa vAo 2 ky tr; tliu c&a Mi sii nlru sau: N€u.li "0l" thi giim 7%,,n1uli "02" hoic "03" thi gi6.m 5Yo,cinlaigifun0%. (i.0d) e) Sip xiip dt 1i6u t\eo.T€n hang tang din vi theo S1 luong giam iO Say f) Ltru bni h.m hoan tAt voi t6n (0.5d) b) T6n hdng: dga

tucmg"

5000.

DE01.XLS

dil

FiET I-id

thrle hinh tin hgc

DA1

uY BAN xHAN

oAx

EQc

prno THoI{G BAc TRUi.{G i{QC co I(h6a ngAy 10 thdng 6 ndm2009 lul6n thi: THUC Hirl{H TIN IIQC - Thdi gian ittm bdi : 60 phut

Ky rHr NGirE

DE2 1.

cgu ivcgir VIET li.,.rrI lip - ?r do - HSnh phfic

CQNG L{OA KA" HQI

rnaNn pu6 go cHi trnqg so crio Dpc va pAo r4.o

Kho'i d6ng \YinlVord, tao vin bin gii5ng m6u cl u6d diy lheo cdc y6u cAu sau, a) Gd ngi dung. .^ 'l r'^ .: .. ..: ' gita, chri ddm. c6'chi 22. canh vdn bin deu b) Canh' tiSu d6 vdo cd hai 16 c) Chia vd;r brin thinh ba c6t theo miu d) Chin hinh vio vi;r bin theo miu tr€n (Hinh trcng nh6m Animats hav dung hinh khic tha''. int)

(2.0d) (u. )

ol

(0 5d) (0 5d)

(r 0,i)

e) DropCap 1)

s#

Luu vin bin hoirn chinh vcri t€n DEOZ.DOC

(0

_i.1)

Ftrfr.EBAtr,T-., uoc si., drme tr€n

neii

ta

l. -i

I'

o

FireB:illii!ci su lunq :ri:h,,in: didt tLi :ao il. Kho'i

cdp cung voi .i:hiiu kiiu ddns LhiEt k€ rnoi nhim dat duo; d6 tin cdv vi hida ndng va -gi6 ) tranh. Voi Uch thu6c

.-,:,':."'.

iiing I Iici'osoft Excel. c

l\/',r

6

I

i?,t, i it ta -ih

=r:ri

:l

iChi:r-:

Vilr

;m nn

:ll

tT

tl

I 5,0 cn

Phuonq Eich luinn

T'ni n

i

ilJri

C

Eqlr.; Dl t,l T NGK T OAIJ l-ioA. !TB

l,ici.:.,'En'3u6c irtnh

tr r

F

D

.:T? rLiul F.irfr

csrl

ir,ches. thi-i ,ria! iiie kiim nhari-h. t6c cio cutnr truv€n 2i7}lt1gri',. toc ,ir qua',' j-i00 vone. lirrir.

i.-i

lPht ra'rro lt-v

a.c

s! t 4oT 7.0 I aol 9,0

I

to

7_O

vinh

on

l
5.0

ilai

6.0

1

|

;

3.C

JU

0.0

10.01

4.0

5.0

EI)

7.0

I

l

i I

i',

miu di

i .i.rj

so 8.0 s.0

o

:
3.0 7.0

thi vi diin s6 thu {0 id) (i.0c) br cir Dl.B = Truls bin-h cring cria T,IAN. Li'. Ho.'' I:n: rron ! so (i.0d) c) ThLic iii€n x6p h4ng ciua vdo cQt d) Tini, cgt XEP LOg,i.: NBu ETB 7 .i€n cdn 9 I.i loai 9 tni len ld ioai GIOi ndu DTB (1 5d) KH.t. niu D'lB rir -5 d€n cdn 7 ln loai TBIflH, dudi 5 :, ,- e.) l.u-u brii la,-,r hodn rat vci rcn [0.5ri) fj Tri':h :a danh s6ch n-hring hoc sinh dat lc,ai GIOI. L,-n-i tip tin vsi ten DE02-G.XLS (0. jd) a)

\ihip dt

iiEu theo

'l-iiuh

DTB tt

DE0?.xl,s

Ii.

lA'rTU.

tt

HET

']A thrc hanh tin hoc

Eiz

,:|,, -

v-

Xi

H81 CHU NGHIA VIET DQc lip - Tg do - Hpnh phtc

UY BAN NFIT\N DAN THANH PHO HO CHi Mh{H .: y\ ) a z. t ^ t- it t-t i n Frr.r

CQNG }TOA

NA}I

-:..--

THr NGHt pHO THONG BAc rRUNG Hgc co Kh6a ngiy l0 thang 6 ndni 2009 ivl6n thi : THt/. C HANH TI[l HQC - Thoi Sian ldm bdi : 60 phrit

Ki

oEs l. Kh&i

dQng

lYin\Yord,

dung ' b) Chia 2 cet

t4o

vin bdn gi6ng miu

dur5d

tliy

theo cic y6u cAu sau:

a) G6 ngi

Ai (2i -

c) Dinh dpng: kA6 gidy

so

29.7cm); i€ tr€n, duqi

li

2cm: l€ tr6i.

phii

(2.0d) (0.5d) lA 1.5 crn. (0.-5d)

da

d) Ti€u e) Word t) Lrru vdn ban hoin chinh vsi t€n

Art

(1.0d) (0.5d) (0.5d)

DE03.DOC

J. 'BACH DANG GIANG Gi Di1'Bph Ding Giang cria nc\i gi6ng

Tiin

s6ng hilng

chip rAn\ thoi li€t oanh cria bao nguoi rua mrng chinh vll I:I uoc non r.li ldng hiOn thin t eusm bae. la1 a durii trcn quang dang o o iarl u suons art.h hunq du co n lvl61' nu6c thi€ng li3ng c6n ghi

ding

R6ng.

Gi6ne anh htne. Gidng L+c Ht,ng Nanr 'Irdn trci :ranh mu6n sd d DLiri di'. ,Jor-,g nurlc ii

rung

sam set Dao Dung. mua nang

-L',-

Hing civ cao Soi bong gi6 cu6n mu,in ngan Ding G.iang vin sdng de cho ndi ei6ne soi chune l:lr liin ri Jl:; pirang phit tron-z gi6 cam xi€t bao I 7. Kh cri t16ng r\Iicrosoft Excel. B

rai-

l

Th61- Ph

Trrlrg Si Dlr.ds Tt, ThiT

i

I

6 _7 3

9

!0: tl I

t2.

D

C

!E lli

IIg l6t

:TT

J

rE

EoiaE fnrnDg r-curla1-LaDh 9 Trir -fLi Ngqc I \hl Eoiras 6 vE 7 LA

hgc

lrB

s6

siat thq.rat

T591

Lni.E

]31I

Tria Tl73 DE'

Tt19 ?hotrrr Dt57 LoEg Tl75 3l.!

KEO-{ -\-GAY :.0,'612.009 r-)' T!gc s5 uio Tru|tg G

T27? :\-? 1,4

lpolao I Dl63 Irt Dl64

4.5

m

a

3.5

ffi

!i.h

drLh

a t-T ll5lll

9

5

-

xip x6s

L+"9

b:.!h

-l

I

t--r-

ffi e.sl al I -i ---[----r------

I

1.5 a I YOu c au a) Nhdp dft li6u theo mdu di b) 56 b6o danh: 3 ky tg cu6i cta m6 s6 hoc. c) Tinh di€m truns binl voi Lf thuydt hQ s6 l, Thgc hnnh h€ so 2, lim trdn 1 s6

thi.

sinh.

(C.5,j)

ld

(0.5d)

(L0d)

TinI cQt XEP LOAI ; N€u DTB ttr 9 tro l€n li lo4i GIOI, n€u DTB ru 7 d6n cin 9 Ii loai KHA, n6u ETB tu 5
DE03.XLS

YEU.

HET E6 thuc hirnh

tin hoc

Ea3

coi-{c i{oA >i{ HeI cE{u NGHIA VIET NA&I

UY BA},I NHAN DAN THANH P}IO Hd CHi MNH SO GI.{O DUC vir BAO TAO

EQc IAp -

Tr

do - Hgnh phric

r-{Gx{E prro rHONG BAc rR.Lit{G HQC co Kh6a ngiy 10 thdng 6 ni'm 2AA9 .\l6n thi : THLI. C IIANH TIN HQ C - Thdi gian ldm bdi : 60 phtt

KV

EE4

rur

L Khcri d6ng lYinlYorrl, tqo vdn bin gi5ng miu du6i

dAy theo eic y6u

ciu

sau:

a) Gd n6i dung

b) Chia 2 cpt c) Dinh dang: kho

ss

(2.0d) (0.5d)

gid\ A-l (21 - ?93cm): ii rrin. duoi ld 2cm;

li

li

rr6i, phdi

1.5 cm,

(u.)dJ

d)Ti€u ii8

(l 0d) (0.5d) (0.5d)

e) DropCap

fl Ltnr vin bin

hoirn chinh r,oi tdn

DE0i.DOC

7*d

z?40 8A7

a, ..i A, "6

---l-rdtr i6n c:iv brJdi h:iiht,r t, l-. Blrctc ruong vucrn cr hii ntr tdra xuin

!-d

itlicrosoft Ercel. E

-_-_-_]*L 2'

BA.NG

1

3 . N4A HAI.IG

5

D,\

7

D,A NH X,A

e

I

_1n

gi

g

_e-ri_{i

_c.o_c_h6,:

_e

ya

r\rU r'b!rn- S_16!3_l o U-c-ri. q i I _c_i-r.l La cnn cau Dtet oau me 90 Chim vAo l6ns bi6t thuo n3c ra. Ireo len ca] buol hal hoa BL:oc rudnr vucm cd hii nu ii;:r:i,-rin

liu tin ndn nit ra xanh biA'c Em cd chdng anh tii'c liinr tlruy B: d,lng m6t mrl rriu crr' .: -'t.'rrh chlrr,: hri nh,lri n:1, ciin l-h3ns 2. Hhcri dQng

r

PH6

D

-

E

Li U

TEN HANG SO LLTC'NG EO'N GIA

THUE,

I

IEN

T

HI\

100 I

100 50 100 ao

DA

Y6u ciu

a)Nhdpdrili€utheomiu
lA Xang, n6u md hdng ld

Diu, c6n lai ln Nhot. c) Don gi6: n6u h Xang thi rlon giri li 4500, con iai lir 3500. d) TioJr thuti: bing20% c[a Dor giri .. e) Tinh ti€n tra: Ti6n tre: 56 luqng + Don gi5 + Thug. : .. 1) LLru bai ldm hoin tdt voi tdn DE04.XLS

D.{

(0.5d) thi t€n hing lir (0.5d) (l 0d) (1.0d) (l 5d) (0 5d)

IIET

$6 thuc hinh tin hrc

=.1

,r

rirnrNcsE

56 GIAO DUC vA EAo TAo ruAmr pnb no cnl rvrnur

PrIo IHOI{G cAPTHCS xn6lrHrNGAY ro/o6t2ofi M6n thi: THIIC HANH TIN HgC

DEU

Thli gian: 60 phrit (kh1ng ki thdi gian phat ai1

Ceu 1 : Khdi dQng WinWord, cdc em tao vin bln gidng m5u drrdi tt6y theo cdc y6u cdu sau : (2.0d) a. T4o bing theo

m6u

b. Xoay ch8 c. ChEn Bullet d. Td miu ndn

(0.5d) (0.5d) (0.5d)

e. ChinhlnhvhobAog

f.

Lrtu ven b6n

(1.0d)

hoin chinh vdi r6n

THI-0I.DOC

(0.5d)

sANc)!Gp HANG i,;V,4iiSlG$

.3. Philippines

':3.

*

:Thdi

114

lan

86

82 ..r.tlt,

7l

Vigt Nam ,.-:i. lrlelaysla

*

1ii+jiB[B.'#

'

Indonesia

r.'.i..tl,ilr

66

':

.61

48

.1"4.d[:;H]

"qf,

77

CAu 2 : Khdi d6ng Microsoft Excel

trrun BANG HoC PHi TH]NG oaaool

6

C

1

D

2 I

3

.i

NsurYdn 1

6 7

4

ri;

Ngd Qudc 6 Vti

1

i'!r

N16

Tdu Thu Lar L. V& Tl,jrlh fda \'aa Tuih

Hurs

lbi Iioa

Niala

250

N'r.'

2m

li',im !1ol

Nara

.{"flfc'.Tffi

Ir I

lr

5000001 sSOoOOl lS,IOOO I

620000

li:a

|

665000

.lloI

Nd

8r0ooo I Ong cQIg

10

a. Nh{p dfr ligu theo m6u tt€ ttu b. Tinh Lo4.i theo nguy€n tdc sau

ffi.tr! ei(,sj4

:

(0;5d) (1,5d)

:

Ndu Eidm Thi >=500 ttrl "A" Ndu Didm Thi >=400 thl "B " COn lai li "C "

c.

Tinh Hgc Bdng theo nguy€n tdc sau Ndu li loai A thi thudng 50000 N6'u le loai B thi rh'Jdns 20000 Cdn lai li 0

d. e.

Hoc phi d6ng thuc = hoc phi - hoc bdng Thdng kB theo yeu cdu 6 cudi bing

f.

Ltru bdng tinh

:

hoin chinh vdi t6n Id THI_0I.XLS

(

l.5d)

(0.sd) (0.54) (0.5d)

SO

GIA0 D{JC vA EAo TAo FI{b i{O CHT }4IhIT"

IHAJ'T+

EE6 I

CAU

I{G}{E Fi{CI THONG CAF TECS KI-T8.4 TE{I I\iGAY LArc6N&1* ]VI6M thi: TE{LT, C HANE{ T'IIV E{QC TFrdi gian: 60 phdt {kh6ng ki tttdi ginn phtit tti) KN THN

: Klrdi d6ng WinVr'ord, cdc em tao vin bdn gidng mdu dttdi diy rheo cec yCu cdu sau : Gd n6i dung (2.Od)

a, b. Tao Tab c. Einh dangTab d. Chdn Symbol e. Ldu vin b6n hoin chinh vdi t6n TFitr_0Z.DOC

tsGC ?FIAE,g T'RLING

(1.0d) (1.0d) (0.5d)

(0.Id)

g'ESEIGF{G

(sEe)

56

siii

0i l-aptop Pentium IV 0l b0 PC Pentium IV ..... .... 0l b0 PC Pentium IV . ........ .

.

5 giAi nhAt

l0 gi6i nhi . 70 gidiba 150 gini khuy6n khich .....

laujl

rql€ih

Gi6i 6hu&ng

i gi6idac bi€t

01 mdy h4P4 .. .................. .. 01 the cdo

VinaCard

..

20.00a.004 ......... fi,400.000 ..."..... M.000.000 ..... "..... s.000.000 .".300.000

d d d d

it

: Khdi ct6ng Microsofi Excel

!

D

I

FGE

r.

B.{:{G EIEI,N XET C.{F EOC BONG

.J

+i*io,' ..1

I

.i\grJ:feE Le

fr{L,

2

Ld Thar*

r-&r.r

trfai Vel

5

.t Cao

liuln

: EA Thi o

c.riii t-b_'.d$ '!A..f,t ila\f o CO:\- LS 6 CON LS 5l sl sl 6l

TIULI GLI.NG CONTE

IILE

6 i!gEl,en rl)! I{LE

.f,tb;i

Eiib-r.B-d-,.Ic

,l

\{i(il I,i:(E

sil il el 3l ?l il

51 21 61

sl 4l 7l

6l sl el rl

a.

Nhdp dtr li€u rheo mau de thi

(0 5d)

b" c"

Tinh didm trung binh

(0.5d)

XCp loai dda

vio di6m trung binh nhtl sau

(r.5d)

:

Ndu ETB >=8.0 thi "Gi6i" Ndu ETB >=6.5 thi "Khd " Ndu DTB >=5.0 thi "T.Binh " "Ydu" Cbn lai

li

d.

X6t hoc bdng nhrr siu : udu csACH = "coN LS " ho4c csAcH = 'CoN TB " rhi 150000 Ndu CSACH = "MNUI" rhi 100000 Cbn lai ld 0

e.

Sipxdp c6t DTB tt ldn ddn nh6 t.ru b6ng rinh hoin chinh vdi rcn la THI_0z.XLS

f.

(1.0d)

(

r.0d)

(0.sd)

so GIAo DUC vA oAo rao rnAxu pst! uo csi urNu

rci

rnr NGHE Pr{o rHONG cAP TErcs rg6a rHI NGAY tolo6t2oto

M6n thi: THI/CHANH TIN HQC Thoi gian: 60 phrit (khbng ki thdi gian phtil

DE7

I r Khdi dQng WinWord, cdc em tao vin bdn gidng m6u drrdi ddy theo c{c y6u cdu sau a. G6 ndi dung b. Chia vIn bin lim 2 cQt c. Tgo chil ldn tr6n 3 ddng d. Tao vi tlhh dang ch8 kidu e. Ldu veo bin hodn chinh vdi ten THI-O3.DOC

Cdu

dt cd

trl em tren thd gidi c6

nhtng nhu cdu gidng nhau : ngudi ldn dd che chd vA nu6i ndhg chring, .. cha ms tld y€u .g thrldng, tnldng hqc dd hgc, cdc tlia didm dd vui choi... Cdc tr6 em c6 thd ttoin kdt lai vi tldi h6i moi nudc trdn thd gidi phdi kf kei

N4Oo

:

(2.0d) (1.0d) (0.5d) (1.0d) (0.5d)

nhilng cdng tldc vd quydn em

vi

l{i

cfia tr6 t6n trgng chring. Lim thd nho ? ^ Blne ci{ch h6i c6.c td lEI .nnJ nhdn d4o, bing c6ch n6i trong cdc ldp

q*y€

x@€,f,@ em

dfu@

de)

T:,J,1?""i:l

cdc EE em tr€n thd gidi hay crla mQt nrrdc l6ng gi6ng, blng cdch vui dDa vdi

nh0ng tre em khdc

C6u 3 : I..hdi C0ng Microsoft Fxce! .l

,.:

t:,"E-,.

G

1

2.

HANG TEN HANG SO Ll.-rqNG EC'N GIA 't oo 4 XA I 5 )A 150 3

6 7

l14A

NH

DA N a ^ii.

100 50

(A

10 DA

T-lt-

I

e.

Tinh tidn tri=Sd ltrgng * Don gid + Thud

f.

Ltru bang tinh ho)n chinh vdi t€n

inh thue = 5Yo cia ddn gil,

IIEN TRA

--l

-E-

a. Nhgp li6u theo miu ct€ thi b. Cdn crl vio mi hing,dr)ng him didn dfl ligu vio cQt t6n hing -Ndu li )G thi t€n hang la Xeng -N6'u H DA thi t€n hing ti Ddu, cbn lai ld Nhdt c. DrIa vio cOt ten hang , dilng him di6n dir tiQu vao cot ddn gi6 -Ndu li Xeng thi tlon gid h 18000, cbn lai li 17500

d.

THUE

(0.5d)

(r.5d)

(1.5d) (0.sd.)

li

THI_03.XLS

(0.5d) (0.sd)

nhau...

}L,, T,IALi DUC VA

8.46 T4O

K{

T'}[X NGI{E PHC TEIONG CAPTHCS KHOA THT NGAY \il1A6/2OLA M6M thi: THUC HANH TIN TIOC Thdi gian: 60 phiit (kh6,rg kA tl,oi gian'phrit di)

TI{ANH PII6 FI6 CHf MINTI

DEg udu

1

a"

: ICidi

WinWord, cdc enl tao vIn bdn gi6ng miu drJdi ddy tl.ieo cdc y6u

dOng

c6'u sau

m6u

Tao bring theo

(2.0d)

chfr c. ChEn Bullet d. Td miu ndn e. Tao WordArt Lr. Xoay

f.

(0.5d) (0.5d) (0.5d)

w

Lr,tr van brin hoin chinh vdi t6n

T[XI-O4.DOC

(1.0 ) (0.5d)

E)

,

TP" EIC

c

I I I f I

*

09h30

j

t

Kh6ch s?n Sofitel Metropole

-

16h30 ngiry 0910912009

l

I

-

d" KI6ch

s4r.r

*

,? 56 Li Th6i T6, Ha NOi

I

".'. I0h30

17h30 ngdy 10/9/2009

Sofitel Plaza

17 LC DuAn,

Quflnl, TP.HCM

:Au 2 r Khdi ti6ng Microsoft Excel

A

-C

D-{N-E[ S-{CE EQC SE{II r.dP

1

.,.'r:, E.4,..-ij';I,..-dj :t -'-,'t-j.,:3: ,fiESni NGtNtN DT\T{ TRO.\-G lrdu :

1-r

i .)

.1

.l

10

rvC'OC

I

DTE.

--\.6'p,ga4s

:::._

-}.ep!Qar

lei

\EN

2-
1al

:

*: j .-1

Iro r- -__-r-__-_r_-

5-jl ;l

a. Nhdp dt li€u theo miu dd thi b. Tinh TBinh trong d6 DLT he sd l, DTH hc sd 2 c. Xdp loai theo nguyen tdc sau

G

TRt''dNG BCD

TH-U1'

Pi{-!\IInIlLi.\E NGLTYINil.'l !IL\]\E fTRr.G

5 r

Prz"E:

16---fE T]{IN' 9i

I E IR.TNG BL\TEqET].N.i{

: 7

D.E: F

6l 6l (0.5d) (

1.0d)

(1.5d)

TB = 10 th) Xual Sdc TB >= 8.0 thi Gi6i TB >= 6.5 thi

Iftd

TB >= 5.9 thi Tbinh cdn lai

d, e. f-

li

H6ng

Xdp hqng dua vio didm trung binh Sdp xdp

lai bing tinh theo x6p hqng

Lrru bdng tinh

hoin chinh vdi tCn la THI-04-XLS

(0.5d) (1.0d) (0.sd)

sd GiAo

rii Ti{I NGIII

DUC VA DAO TSC

THANEPHO HO CH( I,IINI{

PHO THONG CAP T.[[CS K}IOA THI T.IGA}: O7N6/20L1 thr: TI{16 ,qiNH TIN !{QC gian: 60 phrit (kh6ng ki thdi gian phrit dil

l{t;

Dii,9

Thli

-lVin\Yorrt, tgo vir ./ Kh&i ttQng a) G6 nQi dung b) Chia 2 cQt c) DJopCap d) Chin hinh e) Luu bAi voi t6n ii baithi0l.doc f

gi6ng nniu thco y6u ciu srrr:

bin

(2.0 d) (0.5 d) (1.0 d)

(r.0

d)

tr-,. J

(l,r

GIA RE BAT NGO TIi PIIIEU MT]A HANG ONLINE 5 li m$t hinh thrlc hirng quin do, nir lrang, phi6u nn u5ng, du lich. hoc n*el'rai ngri. . ..i,

xem phim, n6i chung dri c6c lo4i hinh rui choi giai tri. . . 'v0i gia

mua ptueu hang o cdc trang rve.h vrii gia rc hcm gi6 ti thiit ni .^^. -! +U'i''o Oen 6[,i'o luv OlCn vU vi dang drroc r;l.t nh!0u cu
rit

I]TF]T

4

deal.zing.vn.

fliqin clugc

ban "ch4y" ',rong rl:cri h.u,5i ban kho khen rua qudng i:i

vtra bu6n

5a phim cin minh ,J6n nguoi. ti6u cltrng ma t6n ir chi phi. Driy cdn-e [i mQt hinh thuc kich cdu tidu dirng irr'rng ih.ri hr'i.o sia. duq'rc

CD5

F

DoI BAN naUC rr6p XAv OIINC rErq rr\mc 56 I.TJQNG DO}I GIA fltanur:'6x

IL)ri'IG

i50 i40

I

TCTiO

f-

20ol i6ol leol 13ol

5

:TV10 : 6 m1.1 I 'l 1'C8

B lrr,r14 Y0E cirr: a) }.Ihqp d'ir_liiu. theo

nh'.r:

hoiieal..,,n.

iiiirgir]ua.Com . . . ruv, nhirng trang web niy.dalg n€n li"n ra, nggoi ti€u d.ng thi st dung sin phtm hoic dlch- vu gie ttil cdn r,guoi bdn hang thi

5l

7 dAno _'1/ I{hii _-'"' 1_i:'a l\'Iic rosoft Excel A B THF,O l 2

tu cic rvebsite

rd

?ooo 6500 75ool soool 45Qol

5oocl

.(05rl)

miu trin

b) Dien MA HANG ln 2 kr' tq,Jiu cdra KY HIEU '- --. .. ,: ,-! - -: cJ t Ei',t Fiairi(r: iriu ir'[-.r. .,-l.r.:.iG ia T',: iiri irri,,r 'i haog ld Thip Curin, con lai ld }ii'p rrcm :

iil

d)THAliH TIEN=-SO LUONG + Li.,N e) THUE bittg 20% cria DfJN {;l,i l) Lrm bdi larn vtii tan li baithi0l.xls

Gl..\.

J"-ll;ip','in. niir I,

(0.5 di rr "r/'. i tr; {

l.-; dj

( I.0 d)

tt) (0 5 ,j) { 1.0

rrn-r'

ti_.r

i'i

so GI.{O i}uc }]AU 1..!O Ti{Ai$Ei PHb HEt CHi R,III'{EI

frh

i;i ]'IiI i{GiiE PHo TrdoNG

CAP TFICS

r
ilD

Th&'i gian: 60 phrit (kh6,tg ki thdi gian phiti di)

1./Kn6i dQngWinWord, tao vErr brin gi6ug a) G6 nQi dung b) T4c WordArt c) l)rawing d) Tap bang (Table) e) LLru bii v6i i6n li i_raithi02.doc

iliu

theo1,0u c6u sau'

(i.o

d)

(r.5d) (1.) d) 1.5 o)

(

BFHGS KEflCABHEEJ

@

,c(.t

nra- -Lf rr ltfult

ts

F{

EF-

' r,f , 'rr AY rM

t-r

Ax

GI IIHIFU IVTTET

2

MS WFIDO\I'S

r"

4

l'{S EXCEi,

.|

i'+-Iiei

I

Iv'lS 1VORD

E\o t_-

tt,n

sif

ro "E F*

F

/.\

.l

raiie;.

f4ffir

'

i

/;1

-\

'i

4

4

2.i Kh&i iigng Microsoft Excel c

a

:

SIT

t a l:E

!1

:,I .r"l_

+

e

i:: Cr

5:=i:1='.r,s.

3

6

1

:.. ,?-r af q 't_:r: c

i,

56 l(r

N 5

SX

,:3 : {;

?.

l

he

i\r

,_,.r

,-., | 1

--1

.-t

SrEtr'1=,\S

9l=r!tE:.rt

:_i

;i.: t,

r.;

11 2t: E?

:::.i::

-'

:

r-

Th$ o,r tiE,l

sr

';:

r':/ r :.: -:,_r a:i

:I .;I

-!er':!:/.:CCs

:\

ii5i:.: rr: r::r.': L,

.,rl

a 9

-tc

ryt- l)erlE

f3

c39C g3d5 T7: C

15

55

:11

1-l

;i 15 CD OGD

::oc

o

a:r-)

c

::cDCr)ii :coDDD..j

YOU cAu:

a) NhAp dft li6u theo m6u rren. c{i€n sd thu '...: b) Di6n cOtdcm

giri

tu

I

l.u dr

(0

): ci)

* Doar gil va n6u S0 lur.rng vucrt quii.-s thi

Tfnh cOt ThAnh Ti6n, bi€t ring'l'hirnh f ien = Sir lr-rcrng giim ?% Don gi6. d)Di6nc6ngthricc6tGhi Chu: N€u jvldiringldE.365hay\,I5,5thi ghi i) LLru bai ldm vrii tdn ii c.r

ctuoc

baithiO2.ris

[r'i--,'

(i "tangqudKr\l" (i

-5

d)

5d)

('0.5 C)

DA() lAtr THANHPHO HO CTii MINH

ri rrir IqGIIE nia Tliet'la cAp rgrs

Dit !!l

Thd'i giaa: 60 pht'rt (khbng ki thdi gian phir di)

SO GI-AO DUC VA

i./ Kh6ti

ttQng

K}IO.{ THINCAY 07rc62Afi M6n ttri: TI{u. C I1ANII TIN H9C

WinWord, t4o vin bin giiing rndu thco y€u ciu sau: (2.0 d) (1.0 d) (0.5 d)

a) G6 n6i dung b) Chia vnn bin ii,m 2 cQt c) DropCap d) Tao vi diiih dang ti0u tl6 e) Liru bAi vrii t€n ld traithio3.doc

(r.0 d) (0.5 d)

S0rue Nudc PHUoNG NAM -f !

chdu tho I':anr bg, diu nguin ci6ng lr'{6 K0ng, lLrng i nriCn .- ..-.: -

I I Jchiy qru. tu.

a drl.v

ih;ii

S L;,n

mh nh0ng noi kkhric kh,Srig thd. nio. sAnh kip...Durxrg Th6t IJ6t, ci tra pl:5n9, la vuung quoc mam. mu! ca Linh vA b6ng Di€n f)!dn iri

ltiin5 r'i, c6 hai dong s6ng Ti€n. sring Hdu

.\n Lrian.q,:5 nhi6.tr r;hire, n0i (16rr c6chr)a Var; Linh, Phit l6n,rti Senr co nriiri Bi tlhia X(r, Tiy A.n Cd 1'u. Ldng Thoai Nggc Hiu. Cdn chu-ven v€.hai Cring s6ng Ti€n, sdng Fl$u cung chiy qua dit i\n Ci::n{ thi -etrn h6n ''di rnu:r nu6c nii, chu;r'6n chd '.,i blit br,, phi sa. t,'y.n ci J0 ..\n Ciang hom nay co thd tu hEo gici thiQu cr)ng dr I-hiclr r'6 rninh - niQt virig dit tri phu co nhi€u sAn vit d6c d.io 2.i Khdi flgng I'licrosoft [rcel

nhftug c6u

chLr.,',Qn

diri thl.'i::g

v6 citnq thir vi.

D

< Lr.A.

lll;: .-'eft

i'iA-l.

TE:-r -,;:-,5 \ n i Lr'ryi)

f!'l AY

Tlr\H

,ai-,

r,i

li-rr-lE

I ren

lra

1

;

i-,;

aj

:;

i'.'i(: 7

-\=

ct

__

3 ill al a) Nhip IiQu theo miu rlt thi b) Cdn cu vio rni hing, dr)ng haur di6n dir liQu vio cQr. r3l hdng -Ndu li KE. thi ten hing li KeyboarC -N€u lir M0 thi t6n hing ld lv{ouse, con lai ki CPU i) Dira vio cit r3l hrlng. (ung him di(\ dC. li6u vio c6t drm gia - l\ii.u i:r r-f,Li thi don gii l.i 350; con iai ti 80 d) iinh tnire - N€u mii liang li CP vd s6 luu-ng > = 5C thi 20. con iai thu6 e)'iinh tien tri, = 56 luo-ng " Eton gi6 + 1'hud l) t-r-ru ba; iirrr voi tin lir baithiflS.xls rIET

(0.5

'3)

(r.s d)

(r.5d) (0.5

li

di

0

(0.5 c) (0.5 d)

;{J S{AO DLjC 1'.q oAO rao fFiai'{H PI{C FiO Cfii Ii{iNEI {:-}

}l

l2

TgI NGI{E PF{o T}Ioi"{G CAP T.F{CS ffiOa TEII I'.{GAY Gil06ZAfi iTJ

thi:

THTI. C EIAT".TI TIN HOC Thtri gian: 60 phit (khbng t'i thdi gian phdt a'i) NI6N

_,)

Kh&i dQng lf inlYcril, tgo vEn Tao ) bing theo nrAu

..1

bin gi6ng m6u theo yEu ciu

sau: (2.0 d)

,) Xoay chE

(i.0 d)

) romau nen ) Chin irinh vio bing ) LLiu bdi vu'i ten lii b:ri;hi04.Ccc

(0,s d) (1.0 d) 0.5 ii

ifoN r{oc

TIN IIOC VAN PHONG

9ren toan can

I

?HGI LIJqNG

Dan

I

Ai

i

I

rt

:

E

1

:

I

IVIS \,Vord 200:J

I

I

bo

J+ tlet

V/i:rdoirys XP

hc

I

5.'i

rii.i -ti

ffiffi llilgl

II-S

A

1

48 ri6r

IlS

Access 2

42 t.i{t

ccess

I

I I

./'ii:h+i

ddD g

l i I

I

]Iicrr;:roft E.tccl ii

s-j--.

lvi;i

1-r'[rarr.r

:,.:: :

Ter) HS

D-Llt(lJt)

T i La
I

Tr_1'--':l E:

=r+y

c

5

x€t cltrd

'!71

iH.iD

-:)

9:ArlTttri Oi6nr

f:

r-i i :,

--t -'n

isl

,:l

2s

I

2ri cau: i Nhip dt ii€u rheo nr:iu tr€n ; Cin cri var-r lr.{i Truong. dirr,g harn didn dir li6u vac cOt Tdn Truuing - N6u Ii DHSP r.l'ri teu iruoxg ii DH Su Fh4nr. - i'idu Li OHKT rlri t8n trLrdn! ld DFI Kiuh T6, cdn lai_ld DH Y Duoc I t.li.in cir la.: i!'li '[ ruong, r.lu.ng har-c diin Cti iigLr vio c6t DiSrn chLrin - NtLt li DFISP thi diinr chuSn liL 2l . - ir;6Lr li DFilil-tlii diim chuin la 21, ion lai li 17. r Cin cu vdo i0n Truoirg, dirng him tiidn tlir lifu viir c'31 Di€ni cirng - Niu li Dl{ Str pham rhi dirim c6ng id i - Ctin c'i.c trrriug khtic thi didm cQng Ii 0. t Ding hiim d€ tiaii h.lr qLr2r theo cdch sau: -li€u (Di€;n thi + Eidm cQng);'= Di€m chLrin thi ghi Ket quri li DiLt (lon ngLr',;c lai thi ghi k6r.qun In R,.ri. l..tr;.r b:)i linr,,,-ri te;': ld baithi0.l.xl:; II

il-r

((.,,j dl

(r.)0) {

i.0

d)

1l.tt d) (0.5 d)

( L'l.a

(l)

'' '

I i

soctAoouc vA pnorao rH,q,NHpsbHd cdrrmvs

xt rnr NGHt PHO rH0NG c,EP THCs

.

ran6A TtrrNGiY 7/6t2012 M6n thi: TIII/C nAUs TIN HQC T!:t! gia',: 60 ohrit lkhAns kithbisianphdtdi)

@

Ciu

1 : Khoi clQng WinWord, t4o

'

a.

vin bin

c6 n6i dung

vi hini thric nhu sau : (1 .0d) (1 .0d)

NOidungvd ktung

b. K6 khung c. Chti xoay vi n€n

0 .0d) (r .0d) (r .0d)

d. ChCn Bullet e. Chdn hinh vn dinh @ng hinh f. Lw vdn bdn voi tdn W 0L,DOC

Chffu

*

lodonesia

*

Philippioes

Jakarta { Kualar Ltrmp

1.. Malaysia

Manila I Banekok

€-. Thdil,an

-a Vi0tNan

?i

Microsoft Excel -r-:

mtelr

s"EGil ffi ,t tl ilECIIi!-'f rr6E C'

flu ? !?_t

fli:d tr rt

l

u

t'C

Thanh Phan lhi T}enh An .

Ghu

m5u

Ahri

fu'

5 7 5

iBinh

7

!cdnq

5

Hdnq

thi

c. X6p hsng theo di6m Tdng.gidn

11

I

18

10

15

10

r9

5 E

12 18

6 1 o

11 17

e. Xudt radanh s6ch thl sinl.c6 k6t qul f. Luu bdng tinh vtftOz EX_0lJil,S

"tlgu"

d

II IE rI

IT II rI t6 II III

din

d..Ghi k6t qu& Ndu di6m Tdng l6n hon hay bing 25 vd

E6ng

T6ng

tYl3

7

I 5 I

L5lha'

Trtnffiq

I

M1

EffiH 'i)-'

ffiffi

5

M$p liQu theo b. TInh t6ng cfla cdc m6n

a.

Xll

Thu

lt;-l Nrirty*ilhu ffi c01@ 06ThIo VO ]hahh ffi c01m9

c

lttnl

cfittr/

irfil

-:ffiffiffi.ffi

T€n I

GflE

IINNOi

Ml vi

I

lGl quil

Henq

E

-

(1.0d) (1.0d) (1.0d) M2 l6n hoa 5.5 thi "EQu" cdn kh6ng b6 (1.0d) (1.0.1)

1

SO

ri

GIAO tsUC VA DAO TAC

rnr I{G}Ili

FE{o rrd&Nc c,{p rr{cs KH6A TI{i I.{GAV 116/2012 Irf,6n thi: IIIUC EIAHEI T'S{ EqC Tlrori gian: 60 phrrit (kh6ng ki thdi gian phdl di)

rsAmnprlbndcrrf nmsIl DE

eiu-! : Khdi

tlQng WiuWord, tgo vin bin gi;5ng iniu dr&i dly thec c6cy6u clu sau: a. G6 nQi dung. (r.0d) b. Canh ti€u dE vdo giila, chii dAm , cO chit 22, canl vdn ban drlu cd rrai 16 (1.0d) c. Chia vEn bdn thir:h ba cQt theo miu (r.od) d. Chdn hinh vio vin baa tireo miu tdn (r.0d) (Illnh trong nh6m Animals hay dDng hinh kh6c thay th6)

e. DropCap

f . Ltu vdn

(l.ooJ

bdn hadn chinh vdi ien W_62.DCC

FIREEALL u.qc

n6n Ioai

xiy dpng tr0n ting cta 6

FireBaltfi lct st {rng

hQ

th5ng di6n tt}

.

-l

,.

,.1

cao cap cun2 vol nnreu ' ki6u d6ng thi6t kii mdi nhem da. t duqc tfr tin cdv vd hi€u ndnz v1i ga cgnh tra::h. r/5'i kich

thudc 3.5 inches. thoi cian

tirn ti6m ntunt-E!-?O ttucrng truyAn 257ttIb/ giey,

t6c cl6 quay 5400 rpm.

Kh&i d n Microsoft Excel.

T

NowEn Qu6c Bii Kim Trin Thi V6 Yen

[TEN Airh IPrruqng BIch

L reEl g:0 5,0 4.O

T NG H( 8.0 6.0 3.0 6.0 10.0

Linh

7.O

Phuonq

s.0

E0i Thi CEm

LY

Ghii,Vdn

Vinh

s.0 i 10.0 5.0 4.0

lran lruc

K,len Hd Nsqc:' Nsiwgn Tuv6t Mai

l?u ciu:

7.O

6.0

'

8.ol 6.0

8.0 7.O

€r,-J:&r.::-.l8tI.-:'

ffi;-f rfi

I

3.0 5.0 8.0

xEP r-tANG

F-]

s.ol 10.0 5-0 7.O

-

(1.0d) mau tla thi vn di€n s6 thri tu fung.$lnh,cQng cria TOAN, L'1, HOA, lam hdn I s6 le. (1.0.f)

a. Nhap dtr iieu theo

b. Tinh cot DTB :

DTB

(1,0d) c. Thrrc hiQn x€p heng dtra vdo cOt d. tintr c0i rcp roAi : f.r6u DTb nr 9 trd l€n Id loai GIOI, nilu DTB tr-r z adn can g'ta toai (1.0d) KHA, n6u ETB hr 5 d6n dudi 7 li loai TB, dudi 5 ld (1.0d) e, Trich ra cianh s6ch nhDng hgc sinh dat Ioai

f.

LnbAi hmv&i tEnEX 02.XLS

YEU. CIOI.

IMT

rirrn

NGHt PHo rIrONccAPTHCs ICI6ATHI Nd\Y 71612012 Mdn thi: fiI.tIC ffl,f'nf fnV ffQC r ir,ii gi"^.. JC yLi: (:.:.:,.6 !::::Y ;!11 ;!1! ,#.1

EAo T4o TEANEPHOHdcnf nmr'a

SO GITIO DUC VA

@

Ciu

l,: Ift0i rlQng Winword, thyc hiQn theo m6u sau : a. Tgo b6ng theo m6u

(l .0d)

b. Xoay cht vi n€n c. Ch&r bullet d. ICrung e. Wordart f, Luu vdn bdn vai tdr

(l .0d)

(l .0d) (r .0d) (r 0d)

W

03.DOC

;:.

09h00 - 11h30 ngAy

Sofitel Metopole

*

Kh6ch s4n Sotrtel Plaz,a

T6, HANOi

* fl LepuAn, Qufnl, TP-IICM

,.. 09h00 - l lEl0

.t

Kh6ch

qn

.:. 56Lt rh6i C0u2:

ngAy

l0ll0l20l0

tlQng Microsoft Excel

'iE

snI

H9

Trtn

vln

diuygnrhi Phan Xudn

L}

liQu

TB

10

l0

t)tulr.r

I

2

iMt

4

5

i*,

7'1

lAi

6

BE

5

I

toel

il

10 5

vi

trang td theo m[u - D6nh STT b. Tinh TB v6i LT ne s6 t, fH nQ s5 2 vi lAm trdn c. Logi thm qui t'ic sau : TB >= 8.0 thi Gi6i TB >= 6.5 tlt Kh6 TB >= 5.0 ttt Trung binh.c0n tqi Bbd tr6ng

Nhfp

TH

Thufn

ufta

Ph?qrrfi

fi.t

i

NguyEnThanh

a.

lUl0l20l0

s6 thsp phno

(1.0d) (1.0d) (1.0d)

(t od) e. S{p xdp

f.

Lw

l4i bdng tinh theo

x6p hgng

bdng tinh hobn chlnh vdi t€n la E_03.XLS

(1.0d)

crao ouc vA oAo rac rnarurputtr sd csinmvs

so

l
EE{ Ciu

T'hli giau:

I : Kh&i dQng WinWord,

dung c6t dC' d. DropCap d. Chdn hang tri

pHo rrrOnc cAP THCs KH6A TrnI NGAY 7/6/2012 M6N thi: TTIIJ. C I{ANI{ ?IN &QC

rnr Ncnn

tpo

vin

bAn gi6ug

60 phfit (kh1ng kd thdi sian phdt di)

miu duoi tliy theo

cdc y6u

ciu sau:

n6i

(i.0d)

b. Chia 2 E.^ -l c. Ticu

(1.0d)

a. Gd

f. Lau vdn bdn hodn chinh

(i.0d) (1.0d) (1.0d)

vri ftn W 04.DOC

Ghti bd tim ban Pham Hd (oa Q6! .'A 16,

lVlBm"$ru;i#l;*,,

}. Tudc tlans nim nhin m6v Ngr,r bd-cubi to6t miQng rl\ \ B6ng bd chqt ran biiin

Th6y b6ng minh ngd ai Bd ctrAo: "Kia anh b4n!

E6 hrong b4n di ddu Cf ngo6i trudc nhin sau

A lf

et

Lrsi gflp an]r

troi nic bui tre

d dAy!"

Ciu 2 : Kh&i tlQug Microsoft

"4.m O" tim goi mEi...'

Erel. Li

i'S6.;aeNe. .-*er+,ry*Eq, ,S. O-L! #-tltFl ..D,€TN GIA ioo I XA l=1

EIA

THUE

fiENJIEEIA

200, rl

.NEI

;1fl'o

.DA:

5o

NtsI.

'100

nca

ao

r-)./\

Y€u cAu:

m6u

(1.0d) Nhfp dft liQu vi hang trf theo b.T€n hang: n6u md hdng ld XA thi ten hang lA Xeng ni5u mi hang la DA thi t6n hing (1.0d) DAu, cdn lai c. Don gi6: ni5u ld Xdng thl don gi6lit23.400tl, Diu dsn giefi.500d cdn lai h 45000. (l.0d) (1.0.d) d. Tinh th.ui5: bing.l5% ctia Don * + (1.0d) e. Tinh ti6n trn: TiAn trd = Sii luqng Don giii f. Luu bdi ldm voi ftn EX 01.XLS a.

li

lnMdt.

gi6

Thu6.

ufr

T4O THANIT PH6 Hd CHi MINH

Ki THI NGHE PHO THONG CAP THCS

SO GIAO DUC VA DAO

KHOA THI NGAY 7/6i2013 M6n tbi: Tlf .UC HANHTIN HQC Thli gian: 60 phrit (kh|ng ke thdi gian phtit

BE 17 CAU

I

a.

: Khdi tl0ng WinWord, tao vin ban c6 nQi dun Tpo bing vA nh{p nQi dung Khung viin vi Md'u nAn

b. c. ChB xoay vi font ch0 d. Chdn s5 thri t.u e. Ch€n hinh vi ttinh v! tri hinh Luu vdn bdn vdi tin SBD_|L.DOC

vd hinh

thtc nhu

sau

- e,l"h .,lhlt . U

r)

K" wru.i

;-

#c-,

( 0d) ( 0d) ( 0.r)

't -)/ l,t" Y.

( 0d) ( 0d)

(v0i SBD ".1tiu4 ld sO brio tlanh thi sinh)

tn Suffolk,

b0nh" Belanci Barn - "ltl i nhl 2. Akk6y Evleri Ceve - "Hang
ngoq i 6 nu6c Anh.

rtrd Ntrixi Bolivia tnuy D A

itE)

.MEL

rHEffi!@M

ustralia

Ciu 2 : Khdi d6ns Microsoft Excel c

s

E

D

2

I 5

82-t[3

I

t-

5 7

9 10

I

-.i

reffiI II

A1 00 V6ib6ho D1-060 X ming c2-303 Gach A2-0s V6i lua B1-010 Bla A3-068 Vdi Jean I o ng

r

r

t:

t.I

,011

G

1

3

F

1@

200

5 10

300 120 400 50

20

195

12

I

15 : '15

10

thinh ti

vdtOnintheomiu a*-.-t ra^ #l b) Thdi gian luu kho: ln gi6 tri s6 tuong ung voi 3 kj tu cu6i "ou

a)NhipdeliQu.tgos6thritu,!6khung

(1.0d) (I

.od)

c) Nhin x6t: Nilu th&i gian lru kho duoi 30 thl ghi Brin chay; n6u tu 30 ngiy d6n 90 ngdy thi ghi "Brin duo. c"

cdn lai thi ghi "Brin

chflm".

(,l.0d)

+ Q Thnnh tiAn: 56 luong Giri nhAp vd tinh t6ng thdnh

e) Trich nhiing

hing h6a

brin

tidn

chay.

(1.0d)

(1.0d)

Lrlu bing tinh hodn chinh yd i ten la SBD-03.XLS (vdi SBD ld s6 bdo danh thi sinh)

HET

ml rrEr NcHr Pr{o ruOtqc cAp rucs r.s6a rm mcAv 1t6/zor3 M6n thi: ruu3 uAnmr TIN Hqc Thli gian: 60 phi t (kh\ns ki thai giyn phat ai1

Sd GIAO DUC VA EAO TAO THANH PHO Ho CxfI ivIINH

Dfr,Ig

Kh&i d6ng WinWord, Qo vdn bin gi6ng m6u duoi rliy theo c:ic y6u ciu sau: a) NhAp ndi dung. 4 ":1 FV,Cr b) Dinh dang tieu dd ?--.v"' c-) c) Chia v6n bdn thdnh ba c6t theo m6u d) DropCap vi canh l3 frp e) Chdn hinh vd dinh vi tri Luu vdn ban hodn chinh vdi rcn SBD-02.DOC(udi SBD td si bdo danh tht sinh) 1.

( r.0d)

d

fuf;l

lt

Cu6i tuAn qua tai thi hAn Sandwich, thu6c hat Kent d Ddng Nam 'nudc Anh di di6n ra 16 hoi ki ni€m 250 nem ngey m6n an nhanh ptr6 biiin todn cdu sandwich

c6

ra cl&i.

diy clng

IE

I

li

!it5

ngiy crlng t6

cia b6nh mi Vi6tNam.-

( l.od) ( i.0d) ( l.0d) ( l.0d)

nem

v€

\Vdc d4c bi€t y€u ciu chii

truoc,

khi

m6n en nhu th6, .dri-6ng c6 th€-vra_ 6n- vira C[qi bAf vd c6c ban cria 6ng ciing d6 nghi "dn gi6ng m6n nhu cria Sandwjch". Chi chCp tl6u ti€n v€ bdnh mi sandwich ndy ld vio tim 1762.

2s0

biiSn

Da IUOC 00r

thf

tu. cta virng Sardwich John Montagu dd nghi phqc vu m6n thlt bd kgp gitra Iaj l6t b.inh mi, 6ng kh6ng th6 ng,5 ring y6u cdu cta minh sau ndy tro thinh thric .6n

ahanh n6i . ti6ng toin cAu. ChuySn kE rnng ngii bri

(Trich SCTT 2.

Kh&i

E

E

D

,l

F

BANG

2 1

A001 lvan AOO2

d

8001 c001

5 6

Einh

Khdnh

ls lsl

11

12

Y0u

H

ir

oEM THITUYEN SNH

I

4

7

7I

6

8

8

I

8l

9I 8.5

3

I

D001

Lan

6

55

a

T

c002

Thu

5

4

9

BOO2

QuZncl

I

dii li€u,

I

65

10

3

5

7

8

10

I

t6 n6n theo

m6u

6

tao s6 thri tu, kC khung

b) Chuy6n: Dua vdo

kj-4r diu

't0

I

ciu:

a) Nhap

51)

cria SBD;

vd.

7

J

I

Doanh

D002 Thanh A003 Lam D003 Linh

10

si

Microsoft Excel.

I I

A liTo6n -Li,BlA H6a-Sinh,CliVen,

Ngoai ngir. y?+1:'hfr;f i-rl ' / [ Z- c) DTB: trut{g biitr c6ng iric cot di6m voi di6m mon chuydn hi sti 2. Lam trdn

(1.0d)

Dli (1.0d)

1 s6 le.(i.0d) >7 vi <8 thi ghi "I-op chqn", d) qui: K6t Niiu tir trd thi ghi 8.0 l6n N6u "Dat"; DTB DTB . ^.-rL (1.0d) - :\ cdn lai ghi "R61". / tt | .(1.0d) e)S6pxilpb?rngdiamtheoDTBtircaoddnld;,.ap([;sy I-uu bii IAm vdi tdn SBD_02.XLS (vdi SBD td sA dann'ii stnt l

ili

nfr

.{/

so GrAo DUC vA DAO r4O THANH PH6 I{O CI{i MTNH

xiTTTT NGHE PHO THONG CAF THCS

KH6A THI NGAY 71612013 M6n thi: Tnt/c HANH TINHQC

DE Ciu

,. .n .-V 1+ /t., . -- t i,r-)-'-:r tlur B,iatl. wv Pirot l^i.vt.E ^. ,'v.5.-,.

1 : Khdi ddng Winword, thuc hi€n theo m6u sau

a) Nhip vin bin vi Tao bing

c) d) e)

f)

Canh li viin ChCn Bullet

t/\ J.^-

:

. ..,-t.;)\;J/l rt.6.

.{ ( 0d)

.

,'

bdLn

( 0d) '

( 0d) ( 0d)

(

Wordart Luu vin bdn v6i tan SBD-o3.DOC (voi SBD la s6 b6o danh thi sinh)

0d)

1

Giai hi trons dip h e DV ki6n se co hon 50 phim Hollywood ra r3p trong mira hd 201 3. Trong tl6, Hollyrvood lu6n nim bit cg hQi tung ra nhffng bQ. phim hAi, hoat hinh'ffnh vdo khrin gii li c6c ban hgc sinh, sinh vi6n vd gia tfinh hong ki nghi dni ngAy.

p

U"tt

t -JS

curii hdi The

'/

Robert Dc Nim, Amanda Johnn Armie Hammer

lone

Turbo

Ctu 2 : IGdi dOng Microsofi Excel

I

,.:

A

D

EI-F

L

TOAX. 2

ISlr

29 01- 1995

1

Blh

6

lve" finh

21-O&1995 Ntl 21j 1l- 1995 NA

1

I

Dqanh

I

Ira!, i

0

16-0& 1995

or

llea Naa

AEi

2*O+1995 Na.o

Thu Kb6oh

o

1-o51995 Nr?

lE."-

12

7

9

10

9

6

L

t2-L9 Nagr 18-O91995 NN

z50z 1995 [iv"r2-ot 1995 Nil a) Nhfp dt liQu, t+o s6 thri 4r, ki khung vi 11

-6fs 4 8f,

---l ----

7 10

--lt-

t6 n6n theo mlu v6i Tinh Trung.binh di6m b) To:ia hQ s6 2.(kh6ng ldm trdn) c) X6p thrfr: Xtip thr? h4ng theo Di6rn trung binh d) Xdp bgi: theb quy tic sau; TB >= 8.0 thi Gi6i; TB tu 6.5 d6n du6i 8 thi Khri: TB thi Trung binh; cdn lai dti tr6ng e) Hgc b6ng: Ntiu Di6m TB trr 9.0 tr& I€n thi ghi C6 nguos lai d6 r6ng. Lrn: bing tinh hoin chinh

vdi t6n

li

SBD-(B.XLS (vhi SBD ld s6 bdo danh thi sinhl

lli cxXt,'-7"

Fl .fr-;{ ,t j\; ,

lo srr -T

HEr

r(r.0d) (1.0d)

tt

i

5:0 d6n

(1.0o dudi 6.5 (r.0d) ( l.0d)

si

SGGIAO RLIC'r'A I)AO TAO TI]ANI{ PHO FIO CFi; N,'rII{ii

EETO

THr NGriE PHO THot{G cAF TFrcs KHOA rnrrucAv 7/6t2ot3 M6n thi: THIIC HANEI TiN HQC

Thli gian: 50 phtit

(khbng

ki thdi gian phdt di)

Kh&i ilQng WiuVy'ord, tqo vIn bAn giiSng mAu du&i diy theo c6c y6u ciu sau: a) NhAp n6i dung (r .0d) 6) Chia2 !-c6t rhu nr5u (r.0d) c.) uhen so thu tu (r.0d) d) Canh ld vi dinh dang iont (r.0d) e) Word Art (r.0d) Ltru vdn bdn hodn chinh voi t€n SBD_04.DOC(vI i SBD ld si| b(io danh thi sinh) ,e

ffi# I.

F:i r,{Y THE Dt€ff,

E6i mdt io tru6c khi niro g0 th6 laE qud lanh: Mqi --.-

2.

i.--;:

nguql aeu cam Inay rung mrnn

khi troi se lanh. Theo BS mit Rupe l{ansra (Mi), d6i m6t li cria s6 bd,o hi€u su lanh gi5, bdi vi khi chuy€n khoa

b4n dem theo di tru6c khi ra ngodi. ydu: ru blt 3, 'Ddne bau atans -7- mi -ta- Theo BS HansIzL --- .:- ;-; ; ; : -;-IJri ban mudn gi0 bi m6t tiirh y6u cta minh drinh cho ngudi 6y, n6n d trong enh sring md. io I':hi ngudi dy gin b6n. M khi ban ttang y6u, d6ng tt? gidn ra, bit mihet tinh yeu cta ban.

nhi€t dQ xu5ng cuc th6p, mach m6u d rnlt co l4i d6. biLo tdn

ning luqng, vd tam tbdi.

cr5

ar Eau k} b:io thtri ti€t: T heo c6c bic si (BS) phuyin khoa chinh hinh, khi srip c6 mua b6o, rip suit kh6ng khi gidm, thAn kinh k6l thric cfun ung ctia c6c cs chinh lim tang [rong tmg 6p lgc ch6t nhon d khop, din d6n dau khop teng. Eau kJrcrp thdt kh6 chiq nhrnrg diu sao c0ng Ii tin hiqu nhic

th6 d5n d5n

mi

i

2.

l(Ioi

dQog

lvlicrosoft Excel. D

i_f

E

BANq THONG KE TINH HINH KINH DOANH 3

1

4i

N 1-1

N6p cdi hoa

N2-1

ruep Pnri 1an

t.l

e: 7l G4-s G5-3

,ts

1i

,)

(Jo-f G7-5 I

Gao Gao Gao Gao

vencJ

32.000 2s,00d

I

73.700

c6 dudi

44t000 63.000 148,600 98.900 105.500 98.500

l(?c dd

timlnan cO trano

Gao Nooc 96ng Gao lvliss Cin Tho Gao tai nouyen

I

10

f14l 17

l15l 5l '

301 *-roT----T----_l I

15

Y6u c au [.-4 Nlap ar ii€u, tao s6 th[r tu, kd khung vi to ndn theo b) SA kglg6i: ky tu cu6i cDa Ma c) Thanh tidn: SL i Gia/g6i nhung gi6m 5% cho nhiing mi hing c6 s6 ltrong d) Phdi tri: Thdnh ti6n + so6thrc vAT. C d) Trich nhtng Mi hdng c6 56 luong tr€n 20. t /D t^^ t"u bA lam vhi tin SBD 04.XLS (vdi SBD td sd bdo dinh thi sirih)

\ / ,!, j i

I

I

miu

hdng

(] .0d)

>=15

{ @ !&-, e"-8>c{(i^ t; il+ :S-

HET

(l .0d) (l .0d) (l .0d) (

I

.0d)

ri:i 'i'xir r{(;Hli

5{l GI:\(i Dtrir \',\ i)A{)'l Ao '1'lir\Nti Plr{) rI{) (rr I i ty-ilN]il

Klld')A'l'l {i N(ir\Y 021 612A fi llJ0il thi: 'i'nlii'il iiANtrl 'll'll'i liiJi

f

i|-,il

['htri gian: 60 phrit (khLng kA ilii

(lliu I : Khoi c16ng WinWortl, t.Io varl blin co n0i ilung

a.

'lacr

l'ilo 1'}l0NC cAP'l'Fi{'s

va hinh thuc nlrLr

giun t)hrii tlO)

saLr

r0d)

bing.vir nhip niri dung

b. KJiung vi6rr vi) lV[Au nen c. Chir xoay vz\ lbnt chlL d. Chen s6 th,1 t,, vii din cicJr dong.

r O.li

e.

r0d)

Chdn hinh vd dinh vi l.m.r vdn bitn voi t|n SBD

1.0.t)

tri hinh

||.DOC

(voi SBD n sit htio danh thi sinh)

Cric hang dQng n6i ti6ng th6 gi6'i .I'EN -l

Ciu

QUOC GtA

. Hang Son Doong

Qudng Bin h, Vi6t Nam

2. Hang Marble Cathedral

Patagonia, Chile

3. Hang Waitomo Glowworm

dio Bic,

4. H9 th5ng d6ng Batu

Malaysia

5. i.iang d6ng Algarve

86 Deo

New Zealand

rurra

2 : Khdi d6ng Microsoft Excel

.

BANG OIEM MON TOAN . TIN

IT I 1

2

TCn

Vin 'Iuin Th;lrth

Th6ng sinh Nim s inh 4

1995

i'.lam LO

11

19:15

HLrvnh

nq Httng Hu

Lr

Lic

12

I

I 2

I

r.lai,

Trung binh X6p

Tin

To6 n

19.q5 Nam

I

Son

Phai

Qui ting

/

I

3

4

I

Nri 1995 l'lam

10

1995 l.lam

4

I

1995 1995 1995 1995 1995

8

4

l.lu' l.lam

7

1

r.ifi,

s

5

i'Jam

ha ng

__-_j

10 9

l,J r1,

rj

S0 hoc sinh mdn Todn:.=S a) Nh6p d11 li6u. tao s6 thri tu, ke khurrg vi t6 n6n rheo miu b) Tinh Trung hinh vdi tlirirn'l'orin hd sA 2 Iirr. tron I s,5 la. c) XGp hang: X€p hang rheo Di6ur tnurg birri d) DFnr s6 hoc sinh co di6rn Toiin tir 3 lru l0ti. e) Qui tirng: N6u thi sinh sinh trong Qui 2 (tir tiring 4 d6n thrirrg 6) ghi C6 ngLroc f r; Ae r,ang l1 ir

bing tirih ','oi t6n SBD-01 .XLS (vii SBD id sd bio danh tlu sinh) vdo O clia girinr thi qui dinli

tlt,i

0.1) 0.1) t)rJ)

0d)

5() (,j1.1{.) tr)lIt' Vr\ I)A(}'1

I iiAr!jj i Pili') II()

r.

l}0i\u (:,,\J'', f t,i,,\ jili(,,A j r!1 .ti;.\\ tizttlufi\1

[ii liiI-t\,(;lil],

.,\{ )

ili t\ltNtf

D ii2l 'I"

ii/16rr

1,1{,i}'t

thi: I'[[U[]

FIAI"JIX

'f'lFl 11(](l

I/.hi'i dgng \,VinWord, [ao vr'irr ]riin gi6rrg nrit, rlu6'i ttAl' t!reo qic y0u ciu a) Nhiip nOi dung.

sau

! 0rir (1()d) (

b) Dinh dang ti6Lr dO c) C'hia cdr van hin tlreo rniu d) DropCap vi canh i6 e) Chdn hinh va dinh vi tri Ltnt vdn bitn hodn chinh v6i ftn SBD-02.DOC(vd'i SBD ld sd bdo rtanh tlti sinh) l,il;i

-f

! inrg yrr'rj piy f rng ffi Ui ngtroi _dzin chat { \ciy liy 96, boi dat Lim

(

l

0(r)

(i0d)

1:1.

Ildn Trc lir mdt u ong nhirng tinl,

bit con sim clit, dio

rr"4ng

, ,t t)ren. l\1o1 naln l'rrng piloirP h6 noi ni1, vuon ra bi6n hon 20m.

2100.

BANG THdNG KL. oANG

tTt -t

I

I

r,,,la

ot(

641

TEN

Phit

sAcH

nrinh - Khdm

Ki

Gid

SACH WHY?

1b

:

I xroitop

phi

26.00C

i2

64:l

Bi€n

15

8A4

V[r tftr

7 AE,

Pih0nq t0nct

26 30

TALJ

Rtrnct

Son n ol Danh nhan Ki quan

i(.MAr

2D

lliii riit

7A7 8A8

TH. TIEN

SL.

aA2

8A!i

I

30

ll 10

D€m sri lop c6 so irong rnlra >=25

Y0u ciu

a)Nh{pdiili$u,. tao s6 thri' t9, li6 khung vi t6 niii thcomiu t)) Kh6i lnp: rirra vdo !:j, tu dir.r cta ir.4e D9K: 6 ) KhOi 6, 7 ) ICi6j c) Tlihnh tidn: SL - Gia I b9. rt) I(huy6n

o

DBSCL chiu anh hrrirng ni:rr Irf cri.r .,a .1.,,,, ^ llteo tar IIC c.lr virn blen do1 KI)r hau. phdng Chuong .trinh rnuc ti€u <1u6c g.ia irng ph6 v6i bi0n dfii khi h6u tirrh [lt]n 'fre, khi nLr(rc biert cl;rtg r:rr-, lri: :i' khoing 50,19.'i, t6ng di€n tir-,h iLr ulrii;i ().131km2) cia tinh t'l5n Tit sE bi nglip n-liin. Ciic t;hi i..lti,'r, hoc drr doiin Vi€t Nam l,r mdt tlong nhiing qutrc gi;i stl c;lrli . . .: jnh humrg niutg tr6l cira bi6n t16i khi hALr. Troi:g.li) tldlrt rlrri.. ir ViQt mgc nuoc bi6n Nam da tdng ldn 5cm, du do/ur se tirrrg l€n 33cm vdo nim 2050. 45cm veo ninr 2070 vi lm \/2io rrarrl

_nu6i, t6m... Na)' tluirc diin bi0n khi hAu. crr dln ,l tlrirc drro-c loi ich c[ra rtLr:g ydu qui rtmg, tr6ng rndi rirng ciie chdn song v

,

( r .0d)

rnii: N6u s6 lLrerg

trdn

l0 thj tinh ,<9/,,;iiaTll. flliJ, iii

l9i, ctra TII. TiEN. d) Diim s5 l6p r;6 sr) iuong dit mua tu 2-5 tro l6n i.uLr hrii lanr voi t€n SRI). 02.XLS (vtii SBD ld si hdo danh

i{fT

thi tiirtr,l

7, S

)

(i.0ci) I(hoi

S

(

I

0.1)

(r.0d) 25

iliii

-:0 tiiJr

(r

0d)

/1

fl,t\

5(l 'ti li\,() i)ti't l Vr\ trli\i) '{ At n lrAt\H i, [ [',il) {r.{) d]t Ij j\,r ih'i

DE,3 Ciiu I ; Khr.vi

Iii'!'rif, i\GHti 1'll{)'i'!iOhi{; {-lAl"'i'tr{ill'i

)

+ii-{(),4'l I I i r,] ( i i Y 1t?,/612$n :", l\/[6il rhi; '{ tIt] i] rii,ii..,i{l ilfi! }110c T'{rc'i gian: 6{) phrit (tltirg ki thtii gion phit rti)

ir

i

c16ng Winwortl, lhLlc hiOn thco t't.tiitr satt

a) ir)

0c) i).i) ( od) ( 0d) ( 0d) ( (

Nhap v5n bdn v'ir 1'ao bring . Dinh KirLrng vi6n vr'r iviiur r6n ! Car r le vin ban Ll Chcn I] u llet c Woldart vi dinh vi tri L,uu vdn bi[r voi t6n SIJD 03.DOC (vcri SI]D ld sO brio clanh thi siDh)

@ cuoc rr{r AN}'I

kt@ritg bdn sde Vi@t

--F@n

tir

*

-h*I.II

.:

cilifuuYilN KHiaFr Cdu 2 : Ktrdi

dQng

^,.: . .

.

.^

SL

Gi5 r:hflp

., "':'..{tl:-sii]) gihi l5 tri6u tl6ng + Phi6u du lich tri gii 5 trie u dong cira Cong I,. m6i Dich vu Lt hinh Sai ontouriBt * 04 lal Irtol iei 10 triCu ddn 7 tri6u d6ng cho tdc phAm dq thi dgp nhdt thring (1 giiLi/thring trong li tha nc)

Gllrl BA GIAI TH I-HANG

23/6/2014 don h€r ngiry 2\l2l2l)15

'." (01 gini) 40 tri€u tl6ng + Phi6u rlu liclr tri gii 20 tr iiu tit\ng sira f ing ly l-ri,ilr vu L0 hanlr Sai or rtoun s( (02 gini) m6i giai 25 rri6u d6ng + Phi6Lr du lich tr! giri l0 t|iou dong cira Oirirgr' Dich vu l,ir hiurh Sai 0ntoLlnst

GIAI NHAT

GIAI

ngity-

G

Microsoft Excel 2003 LilJI

TT 'I

hl

c2-300 A't-100 lD l rJro 82-0 15 it.Z.2i_t0

B

1

-150

T6n I'lh

6

Y6i

Tri

hing

rn h6n (r

Cd

ph6

Vii

lua

Vii

83.0J0

Ednh h6p

T1-500

T--

Hhqn x6t

I

l,

Jean

ll

lsri,a b6t

20n

lr-l

300

2D

12ti

1a

-l0r:l

15

50

10

195

12

j -_

7A

Thd p

Tdng thirnh

Thinh ii it

100

leia

,c3-250

S1-030

Ltsu kho

.

120

1'1

120

35

tiin:

l.lhip cl[ Iieu. tao s6 thr? ty, kG khung v.] td ndn theo m6u b) Thiri gian lrru. kho: ld gi6 tri s6 tumrg rlng vrii 3 kj' tu cuiii stu 1\,15 }la;-r-l- .c) Nhin x6t: l.Jdu thoi gian luu kho clu6i 30 thi ghi Thgc phAnr; n€u ttr'30 ngiy dtn ng,ny thi ghi.Vni cdn lai thi ghi Sit-Th6p d) Tbirnl ti€rr. Sti ir:oug * Ciil rrIip. Tirrir T0lg tfuirnh ti€n

I

a)

.^L.--- l. l - ^ l. i. ^'rt.. -^ -t. :..- r'f r r.-i^L r\ rr lurullB^ rraltB l,Ur1 r lrr:l( l,lr.ull. L,,

T

{l

.t,.'lt

(r

.0d)

ii

0d)

2t10

;i{) (ii.,\ ( ) tr)U(l Vr\ lrA{}'l A(} x UANII I'frd I{0 r'iii Iiil\lr DiLr

K

i't'i I i

l\-{; I I ti: t,I l{,,'t-i i()N{;{.',i1,'1'1 [ {..t,i l,; I loA'1.Ii { rr-{l ;\1' fi7/6/1,$l 5

ivl0rr rrri: l llu'L' [Ii]\ill'l'lN Ilgc 'I'lrr)'i gian: 68 phii t (lihAng ki thi'i gltn phit

14

rtil

i- iiirrii ti6ng WinlVort!, liro',.;iln brirr gi6ng nriiu tlLlri'i ilf,y theo cric 1,6u cAu sau:

a) lr) c) d) c)

l .0d) (l .od) ( r .0d)

Nh6p n6i clung Lhla I col nllLr ntiru

(

F.rirLir BLriiet

Lrit

Canh l0 vzi dinh dang lbnt chrr doan Word Arl vii vi tri \,VoftlArt vtin bdn hoin chinh vrti ten SBD T4.DOC(t'rii SBD 0

t

A

li

(r.0d; ( L0d) sii

bio tlauh thi sinh) s

alr

6!

a

\\

i8lr ngAyi3l5 (gioFIiiNrii),chutmgtrinhGip'iiMtitriiijgiirio?fitip'u,tr;(tir8lirrrc li6p clrrr;ng trinh v0 hlirig S.&Ii:'DF;t, vdi niirng thudc phinr s6Lrg d6ngq v.l nrd,t th6 girii L.r nrr \,;rlrrr

;t:

icrn nlriit tir6 gioi cr Quirng Binir. I)oin phi.rrg r,i3n r,r\ I
116119

,

2. I(:h(ii dr-'rnu lvl:,.-roso

{1

Excel. BANG DIEI,I THI TUYEN SiI,II.i

't'i'

HO VA TEI.I

SBD L.:ua

l\ai?

f-lintr Arrti

J

lj()(l

l

4

CCO

I

5i

L)001

T n

i'

Clt-l2

t/

U

Btjt)? D002

I

,4003

10

00c 3

C h

uydri 6-i

-f

iftoa

Plruor;

I.l

Khirlr Oiic rlai

I

i)ron

Lrru oc Ci l.i H:rirnq Ydn ilhr

-.i

0

t--

0

l.ia rn

Yen Phi

r

5,

.f.,1

I :.ol

Tren Tan Oat

l.t

To6 n

Tti

A0a'

s Dl

0

5D

t0

s0

(

(:l

9

:0

s.ol

9.ol la.cl

(,i

jl :.01 r.'01

3.

1

6Al 60[

9i

s

9l

i I

thisinh 16l

a) Nhi,p dir lif u. f 1o sd thil, tu, k€ lihung vir t6 niu tlicti mi,.r ('lruyin: l;.) Diiii vio ky trr ilirr c'ua SBD; lr ia'toin - i,y, B ii i{,a - Sinh. C

Y0u c6u:

Ngoai

ngir.

r:r O-l'.lJ: trrt:rg

Viirr,

i) ,.

binh r-'6ng r:ic

r!)Kdtqu:i: N6uDTBtr8.0 cii'7i:", cun iai ghi "R6r' . e) Tlrdrig li0 s0 TS rri't.

!:rit

i I .cd)

li

ia i . (i,l)

di8nr v6i tlidm m6n chuye n he :f' l. i ,ijru t;r):r I ii li.l : i,rtir lroi6nthi gbi "L,opChuy€r:";N6ui)'ii-l > 'ivi,.:tiiri glii 'r;.rrp ii .i)il i c,i,r

{

bei liiiii i,,';i i.1,, -i i,) 0;..:ii,,l (t'ti,i SED li.r:t h;in;tii;;l: LI

E''t'

it;

-t;,tt,)

I

{iaii

ri rm NGHi PHo rHONG cAPTHCS

SO GIAO DUC VA DAO TAO

THANH PHO HO CHI MINH

KH6A THI NGAY ?3I5I2LI7 M6n thi: THUC HANH TIN HQC

DEI I

CAu

Thdi gian: 60 phrit (*hdng ki thdi gian phdt ili)

: Khoi dQng WinWord, tao

vIn bdn c6 nQi dung vi hinh thuc nhu sau : (i.0d)

a. T4o bingvd nhrip nQi dung b. Khung.vi0n c. Miu n6n d, Chdn si5 thf tu va dan crich ddng. e. Chdn hinh vi dinh vi tri hinh Luu vdn bdn vdi tan SBD

|I.DqCX

Copenhagen Oan M?ch

London

3

-

-

Anh

Seoul - Hin Qu6c

4

Ciu 2 : Khdi

(

(vtin

d6n'g Microsoft Excel

c.,t

F

IT

H9

Ten

2

I ran Nquyen

5

3

LC

6

4

Li

lruanr

7

5

IQUOC

6

l.lqo Than

3

1

l.0d)

SBD td sd brio danh thi sinh)

BANG 2

l.0d)

(1.0d)

TP alugc dit tCn l: tht

Barcelona Tiy Ban Nha

2

(

oiinh gii - DU iin d6 d6i moi crla ch6u Au vio nim 2014 bdi EU va d:ng cai td chOc mot cuoc hqp thd gidi v6 tridn lem thanh ph6 th6ng minh hing nim. DLrdc xem le thilnh phd xanh bic nhdt tr6n thd gidi, Copenhagen l) trung tam ddi mdi c6ng nghQ sach vi cam k6t sE dtra cacbon vE trun tinh vio nim 2025. London li trung t6m toirn cbu vE viec kinh doanh vi duroC bidt d6n nhu li ngudi di dbu trong viOc s0 dung dO li€u md dd tao nhDng giii phdp d6i mdi v) giai quydt nhfng thir thSch tr6n mit ddt cia thirnh ph6 niry. Tht d6 hidu bidt vb c6ng nghQ Nam Han dLrdc bi6t d6n vb vi€c td chtrc cdc c6ng nghd ti6n tidn trong moi khia canh ct'ra cuoc 5d g d thanh ph6..

Thinh phd - Qu6c gia

I

(1.0d)

7

V6

10

B

o6

9

i2

10

Pham Huinh

Thing rinh Ndm tinh

Vdn

1

Tt]

B

Tnfi Scrn Hir

Nem D6

DrE iroN

I

I

Cu

Phii

J(

H

ToAN . nN Toan

lin

Trung binh

2001 Nam 2000 NT

4

2002 N0

8

s

2001 Nam

t)

4

12

2000 Nam 2002 Nam

1

2 3

11

I

al 5

2 5

zoot

NO

2000 Nam 2001 Nam 2000 Nam

B

7 7

5 5

I

Ghi ch u

H?ng

5

I

7

I

5 10

6

13,

S6 hoc sinh mon Tin>=5

Nh{p dft IiQu. tao sii thi'tlt, khung vd nin theo mdu Trung binh vdi di6rn Torin hQ s6 2 lirm trdn 2 s6 16. c) H4ng: Xdp h4ng theo Di6rn trung binh tt cao xu6ng thdp a)

b) Tinh

d) Thdng kO theo y6u cdu. e) Ghi chri: Ndu thi sinh sinh

nim 2001 hay 2002 ghi "T16"

nguo. c lqi

<16

tr6ng

(1.0d) ( l .0d) (1.0c) (1.0d) ( l .0c)

Lrru bing tinh voi t6n SBD_Ol.xtSx (vtiri SBD ld s6 btio danh thi sinh) vdo 6 dia giarn ihi qur tlinh.

HET

so crAo Dr.lc v.A DAo T4o

Ki THI NGHf, PHO THONG CAP THCS

TIIANH PHO HO CHI MINH

KHOA THI NGAY 23I5I2OI7 M6n thi: THUC HANH TIN HQC

DE2 1.

Thli gian: 60 phrit (kh1ng ki thoi gian phdt di)

Kh0i ilQng WinWord, t4o vtrn bin giiing miu dudri ilAy theo cdc y6u ciu saut (1.0d) (1.0d) ( r .0d) ( l .0d) (1.0d)

a) NhQp nQi dung..

b) WordArt ti6u cl6 c) Khung theo rnAu d) DropCap vd canh 16 e) Dinh dang cdc chir vir ndn I;ru vdn bdn hodn chinh vdi ftn SBD_L2.DOCX (vdi SBD

ldt

sd bdo danh th{ sinh)

T{,t€ eo - hdng, ehi sd er&a srire klaoi Th.o Es[i& c'iu ilDsc cli$e bii a€" chinh

&&S!i$9SIAIS& c]li 15 dinh sii dt va bA[ bco phi li ti 16 eo - h6ng. Cic Dld l:ioe hqc liIl &i sd riy c6 thi ilint gii rp phin b6 rn0 trin co tli

tu it6 nhin biit vi rinh apg suc thde.

T

O

thucns ltuvin aghi d.iLtrs chi kh6i ca rhi nU (*.,!,.^" '6 bing cin nrng ftg) chia cho bin} phuong crir chiL cao (ner) da din[ sii rinl dutng cu nguoi tnxiag rhinh.

.rIi. V ra ttt6 s,ia t\UO)

urdex) tiah rr;.ng diD.h

Tuy nhi€r, BMI c6 tha chua loin toil c[inh xic Trong trudng h,rp cria m,$t var dfng ri€r]. BMl kh6og phii ti co so hcrp li ili dilli gie bao phi vi rrorg llrotrg co bip oia aguoi uiy ning hon

Dd.

Cic

ali ltoa

hgc

2. Khrii rlQng Microsoft Excel.

n Gie

2

:, srr t L

1

,2

6 7

4

B

9 10

7

s

OK

Khiii lop

TEI'I SACH

642

PhAt minh - Khem phii Trii' dat

6A3

Bi6n

BA4

V0 kU

7A'5 7A6

Khinq lonq

641

741 BAB

11 12

MA

BA9

I bO:

I

sr-

K-I'AI

lnr. nEH

32

I----1il= 26 40

1a

Runq Sonq nqoi Danh nhen K,i quan

I

30 301

1:l

tl{,

200,000

ocm s6 top c6 s6 luqng mua

,:l f-

l

I

cu cau: a) Nh4p dt liQu. tao sii thi tq, khung vA n6n theo m6u b) Khiii ldp: dya vAo kli tu dAu cria Mi DK: 6 Kh6i 6, 7 Kh6i 7, S Kh6i 8 c) Th. tiin: SL.* G.id I bq. ' d) Kh. m6i: N6u s6^luong tr€n l5 thi tinh ljYo cia TH. TIEN, tri 10 rl6n du6i 15 tinh 5% cira TH. TIEN. d) ThSng kG theo y6u cAu Luu bdi ldm voi t6n SBD_02.XLSX (vdi SAD h sii btio danh thi sinh) Y

)

.

HET

)

)

(1.0d) (

l.0d) l.0d)

(

l .0d)

(

l .0d)

(

ri rur NGHt PHO rHONG cAP THCS

so crAo nuc vA oAo r+o ruAxu ps6 uO cni urxn

KHOA THI NGAY 23I5I2OI7 M6n thi: THu. C HANH TIN HQC Thoi gian: 60 phrit (khilns kA fidi sian phit tti)

oBs Ciu I : Khoi dQng Winword,

thgc hi€n theo m6u sau

a)

( 0d) ( 0d) ( 0d) ( 0d)

Nhap vdn ban vd T4o b6ng b) Dinh Khung viAn, mdu ndn vir hu6ng cht c) Canh 16 vdn ban d) Chdn s6 thu tu e) Wordart vd dinh vi tri. Lrru vin bAn voi tdn SBD 03.DOCX (voi SBD la s6 brio danh thi sinh)

( 0,1)

*#we*uSuSb (I )

Nli tB chirh tir

(2)

E{.c

Sii Gin

\hi hir Thirh

(-1)

Dir chi S6 2. C6ng

I

Bi .r-

EO

Bir

NgrryEt -

Sio

xi

dlt

Clr Arh

C6ag lrinh kian

tiEu bi6u cue TP tlClvl tn.agpharg ca:Ir clquAu k& hqp loi lla tang

ti

Pans,

tni.

chlu A

C6ng llinh ituoc rn6 phong r*ri rh{l Di,c Bi Peru, Ptrip- I\iguyin liEu xi] dyng duoc r rip ho,n toir lli Ph:

Nimdcu6itusrrg Nhi trit dusc xi]{ d-rEg vio ni.r{r 189; theo plrong cich lriia trtc tin c,6 ili€n. Ij l-di Sd 86 itutng La C6ngtrinhduioc iiv d1 letltnii'_ t 893 l9O9 do kian ttrir 31r Cardai thi;t ki ro6 ph&rg lhco kiiu Thirrh T6n nhfrrrE llu chudn8 6 miin Bit rruric Plrip. c6ng riin 30,4 Tei di_,- b3n si nhit1 r{ rft 56 9 vui trroi, r re nhing cta nguci din rninh dit niy

Ci phl bir

(6 )

C6ng

P.BanNEha

TP ECXI

(: )

Ghi cht

tnrttrg

C6ngxi Parrr

Ph6

Trn rii UY brr NLir

(1)

Ciu

Eil

Ilie it6m Bt'lr iliin furg tt!! Sii Gir

Qu$r 7

2 : Khoi dQng Microsoft Excel

CD

A

B

2

TT

3

lue +-

1

tc2-300

ii

2

l41-1oo

5

3

Trd

6

4

D1-020 B2-015

7

5

p2-200

Vii

6

B1-150

Bia

43-250 83-030

Vii Jean

1

I

Cd ph€ lua

Lrru kho

ndm 2o1r llh6n x€t

II

11

lsr-o3o

S?a

1?

10

T1-500

Th6p

10

hinq

Nh6m Vii b6nq

I I I

9

HiHc eri I

KHO

T6n

Binh hdp

6J

i-

SL 200

Thinh ti6n

189

200 300 129

181

400

66

50

92

'195

7 64

70 120 250

--

Glt nhap 68 137

f-------l

103

224

13-

14

mAu

Nhfp dft lieu. tao s5 thri tg, khung vi ndn theo (1.0d) b) Thoi gian luu kho: ld giri tri s6 tuong ring vrfi 3 ky tg cu6i cta (1.0d) c) Nhin x6t: N6u thdi gian lm kho du6i 30 thi ghi Thgc phim; n6u tii 30 ngdy ddn 200 (1.0d) ngiy thi ghi Vii c6n lai thi ghi * (1.0d) d) Thirnh tidn: Si5 luqng Giri nhip. Tirr} T6ng thirnh ( I .0d) e) Trich nlrtng hang h6a Thuc Lrru bing tinh voi t€n SBD_o3.XLSX (vrfi SBD ld sd bdo danh thi sinh) tai 6 dia gidm thi qui
Sit-Th6p.

aidn

phAm.

HET

Ma

so crAo ouc vA oAo rAo ruAxs pu6 ud cni rurnn

Ki THI NGHE PHo THONG

CAP THCS KHOA THI NGAY ?JBI2OIT M6n thi: TH\IC HANH TIN HQC Thoi gian: 60 phrit (khing ki rhdi gian phdt di)

DE4 1.

Khii

ilQng WinWord, t4o vIn bin gi6ng miu drnii iliy theo cric y6u cA, a) Nh4p nOi dung b) Bdng c) Khung n€n bdng d) Canh 16 ve dinh dang font cho
s"rt (1.0d) ( l .0d) (1.0d)

(r.0d) (r.0d) thi sittlt)

Tuabin giti ltim nhit th5 gi6i

T\eo tb Daill,rnail, trubin di$l gi6 Hr6ng ld nriy bao plli cdrh quan 220 m v
tlt nlng

luqog cung cip hing trinr ngdi

Dhii hong mot lhiDg-

MOt sti

bi lac ca:

G10X

Gamesa Tly Ban Nha

128 m

F.nercon E- 126

Blercon CmB Dtc

126 nr

4,5 r,lw 7,58 N,IW

2. Khoi dQng Microsoft Excel c

D

IT

Chr

I I

noor

3

I

4

I

coot iAnTAn oal

5

tDool

1

{

q

soor

7

laooz

cooz D002

I t Aoo3

't1

D003

10

=

Nsuy6n Y6n Phi Nquyan HoirE Khdnh Ngn4rdn

Oic ltdi Duorq

Luu Ngqc OuarE

5nfi{l

9.0

K6t qud

I 2

t0 0l

sofafl Eol 7oj 601 4ol

t ?of 8nf {ol I sol ;ol nol I tol I eol

DTB

eol too 601 7ol

1 3 1

3

3l

I

i i

dat:

ciu:

ar teu.

HSGTP

LC Hoeng Y6n Nhi

s6 thi sinh

a) Ntrap

n Vtrn

6 4.0 1.0

TrAn Nguy6n Phucng Nam

I

H

sNH

5l e ol r.ol

V0 QuarE Tri Dinh Anh Khoa Tru ory Nhat Hu'ng

aooz lvu A002

6

I

YGu

G]

E

BANG DIEM TT,YEN

I

s6

th,i tg, khung

vdr ndn theo

mdu

b) Chuy6n: Dga viro ky tU ddu crlra SBDI A ld Torln -

Li.

(l .0d) B ld H6a - Sinh, C ld Vin, D

li

Ngoai (1.0d) c)DTB:trungbinhcQngc6ccQtdi6mvidi6mHSGTPgidil:2t1,2:1.5,3:l,ctrnlai klr6ngc6. Lim trdn 2 s6 (1.0d) d) K6t qui: N6u DTB tu 8 tro l6n thi ghi "Lop Chuydn"; N6u ETB >=6.5 vri <8 thi glri "Lop thuong", cdn lai ghi "Kh6ng (I.0d) e) Th6ng k0 theo y€u (1.0d)

nsr.

l€.

tl4t". cdu.

Lttu bdi hm voi ftn SBD-\I,XLSX (vtii SBDld sd bdo danh thtsinlt) HTT