tech3 sec1 computer s

8/13/2019 Tech3 Sec1 Computer s

1/143

!" #$%&" "# $%

'()*+% ',-.*/

01#23#

)45/ 6#-+7 8*9.(

PDF created with FinePrint pdfFactory Pro trial version www.pdffactory.com
http://www.pdffactory.com/http://www.pdffactory.com/


2/143

!" #$%&" '()%*+," '-./%0," 12"34%5 678" 9+," ':;0," ?".*@," A%B/( !""$&() *+-/

'$3*CD #-3," 3EF 3(@," G%HI

#$%&" A%) JKLD 'D%M," N2"OP"Q(;MR;,S)%*+,"

13*CD T(LU" 3(@," O.EF J7KMD

A%) VW.D Q(;MR;, 'D%M," N2"OP"S)%*+,"

'MW"KD 13*CD

VWKM," X735 3(@," Q(Y"K5I A%) VW.D

Z)%*+," Q(;MR;, 'D%M," N2"OP"

O"3)I



3/143

"#

!"#$%&'( )*+$,- .!$/ 0+$1 2$34 5+&6 #7 89:'( ;:(9 ?"!@,'( *A(#3B' ?C":D( ;#BE'(F GH( I$J+D( 2$K* :


4/143

!""""""#!$%&'()*%

"# $%&'#!"#$%&'()*+) ,)-./0'123)4)"13) / !) 56.78 9:)Mother board ;)7'#?) @)7?#0'# +),-@#A' B'#. %'

C%D'# $%&'#:E#0F'# G6#4H I#JAK)Windows XP(%LM6 N6%MO'# +APAQ.%"

NARSO'# T%UF'

+AV%OOE"#

+W%S'#

I%X0Y6

Z;[

\4W

Windows XP%(

G6%X]'# < ZY^O'# 4_%F*)G6#4H `:V +E%8ac4M'# +W%W d %9# I#>#B*a < ZY^O'#(!A*4P'# I#B)e# BVfH g)6 hPV iH +A*4E I#B)j k8 B)j Nl* +APAQ"

)9# G6#]'# mMH ()* I%nA& ND6 %LM6 N6%MO'# +APAQ +n^)=4YP9#%-4'#-+&-%q# T#BrO-#(''P'Q5) R'L5) S8@ 68T&) ')),-[6+A' B'# +234'#ICDL !$

s'%D'# $%&'#6KUKN"5) VN)7J5) WH IH'#X5)/ YH'


5/143

$%!""""""#! &'()*%cKUOX5)Ade. / Mf) ;7< `Ka$ gh785)(&$

'EJKUO$ / Bi7j 4)i2k 6K^KCb&)VKl"X5)/ 6]^_5) ,)i'\k Id@ / 6KN'H 6HF@ Id@ / 6]^_5) IK!m$/ n)i o"p"''E8!-#$ B2'@)/ AKH7&"5) ,'ON'q5) 6r'sk t V&"5) M!"p 9)-uX&)."! @-X&)/ 8?) v^. 6K^KCw'K


6/143

!"#$ %&'($

!! !"#$%&'(#)*+,-.+/ "#$&'()+)Definition )-./'123)4)"13) /Devices))I nput&Output

.67)9)Mother board)6;)/ SLOT !"$%)ISA - AGPPCI(

'#=) :)6;>/Processors

"@)A7) RAM BC)6;)/)-DDRAMSDRAMDDR3-SRAM-DDR2(

)6;)DE'@,'F6G#=) HI;/,';'JK7)PARALLE)SATA- IDE( M'&67)GE'I7)HING7)O"=) P"I7)R6STF HSUFVDW

?X'Y7)ZM6T7) [&'=)-5#E'\7) (

G]&>F5J7/-7) 5_1"7)ICDL

4`6ab ?2X)67) 5G]&c)5_1"7) ^F :6d6=) )AeJ7/-7).



7/143

,-0+ (#)*+

"$# &()* +##(- ./12* 3'()* 45678

!"#$$%&' (#$$!)*+,' -$$!. /'012$$" 34$$56 780$$9:,' ;#$$?' @$$A#&' 8B 0C4$$!D*:,' EF$G2" #E &@'('* ,(@CD7; 3'()*


8/143

!

,-0+ (#)*+

kSTL8 q#%G WFG8. WFG8I:\9,'. !%!n0,' W0H'r,' WFG8. K6Qc9,' ('FG8!s#tu'

,(J6KH*:(#L4)+U' [5P !)*M `=[n#A8 EFG' `)M #


9/143

"

,-0+ (#)*+

8B @A#&' [*M - I:\9C8 @A#" )b9U' Wx4vTU' WQ


10/143

#

,-0+ (#)*+

\%]A6/ Q02# Kb%A` c7O dK7eG$ (f/#(System Unit)gW! %Bh: g5I%+6/ >#0Ai6/(Case):

[ /28 [g'F,' KL 3 x#s 7F+L w8FT 4 4=8 x#lu'" 1x# 5' (#P4:U' # )g'F" -t46 6 !G " )g'F,' @A#&' (#P4:L 7 X& # *),' 8B

!%!l#TVU' (i#N' (' ?1@ C.[ / L E0g. ' #6'QU' KL M4*{ w8FTb,' 'r= k5 A8:

-|'0e . ' [!VoC ('FG8 B !D / 9, #

e#S,'(Supply Power)KM ,4 E %L WFG4,' r= F 9+C8:B.[:o,' KL #


11/143

$

,-0+ (#)*+

[:o,' 8 !s @A#&' (#P4:L -!* L [De w8FTb,' [:m jt46 K 2i' [:o,'8 6i''!s (#P4:U' -!* L F+" w8FTb,' !X)g jt46 0%

" #$%&'" ()$* Mother board -!. #

#


12/143

%

,-0+ (#)*+

[ / L)Q#+U' 064SC,!n'4o+,' W0H'r,' I : G8 !M4P,+A49,' (#\9s hFM......'J(q.(80:,' fzg KL #


13/143

1

,-0+ (#)*+

2.'()+-EISA(Enhanced Industry Standard Architecture)

234%-'" 51/67(Ports) F 9+C " #9,#"8 " 1x# 5' U#+,' " )M @A#&' #

! .


14/143

34

,-0+ (#)*+

" n4 % ,'.....WFG4,' [bX, 1#G y#T= F+C U ],r"8 8 !,'49L )%)A Wx4 4 - 'r:=8 p4:C pB 4= + x80 % ,' F!G4,' W 0o,'8 8 #5"#A XF A p#H #*H E0gB WFG8 [! 4 49, LFc9%U'

[! 4 49,#" j*%C #/+;"Processors Q#+U'4=- I:\9,' @P#1 YZ !5STU'8 !"#%&' (#!)*+,#" 3#!5,' KM f4 E %U' /QO'

" #P#!GB `*%6 ],r,8 E0g. ' @A#&' /'Q1B -!.6QH0U' Q#+U' WFG4 CPU(CentralProcessing Unit)3456 Q#+U#s 8& #

Z# 9M0%" h4b5U' #L8 8 Q#+U' 4= #*sQ#+U': x#DM 4=345C J,'8 !P809:,u' 0n'8F,' KL ) 6zU' +4 = [:o,' +"0L A 0m KM W

Wh#6; ,8#} - [ / *96 Q#+U' - 0*9%U' 064S9,'8 8 !5STU'8 !"#%&' (#!)*+,' -!* K #=x8F" X)9cU' f#!1. ' - [ / *96 #L 4=8 K:LB #*)H A 0o,' I : G (#D 1 -L !P809:,u' 0n'8F,' hFM

#+*),Q.

Q#+U' M0A: QC ? = # : !U' `*%C WFG4" #56 hFM KM Wx#DM "


15/143

33

,-0+ (#)*+

0A Q1#G (F+C Q#+U' M3 QC ? = # : !1(fh#+6 #L3000#D605C QC ? = # : !L)F6QU' y#T= f';#L8 x4S9,' KL-Q#+U' " = x4S9,' - M0A @A#&' /'Q1B 0 / HB p4:6 # ! x-(#O#+L F 9+C #!,#G8

Pentium IV(#O#+U' w'4AB - 34!,' #+!DL 0 / H. ' " =.

+4 A pB @A#&' ;#


16/143

35

,-0+ (#)*+

3?3@A'" (AB"5'"(Ram/Rom)

# !s ]mi # SpB ,'KL " = W0H'r I=B'/'Q1. KL " =8 0C4!D*:,' ;#

G4),' `)M # D!H0C I96 [bXTL 4= #L3. ' ? V9L 4= #L #


17/143

3

,-0+ (#)*+

#-IJ;" (AB"5'")RAM( " =J,' !%!n0,' W0H'r,'I96 ##9,' [:o,#" #*H' 4P [H ] +L I


18/143

3!

,-0+ (#)*+

D $,' KL 7# / ,' ' 4T,' YZ p?' D@ P)RAM(4=8)SRAM(" $

"DDR3#,*-./0 12345"1066#67 89:;?@ A4B C%;+( DE FBG



19/143

3"

,-0+ (#)*+

D)M [g'h M4t4L STV S Wh# ! !)SL !PF+L |'0eB KM Wx#DM 4=8wz C u' *:}# !s #


20/143

3#

,-0+ (#)*+

I96# P p#M4P F146 8 W0s49U' ["'4:,' KL ) M4P k60l KM 3i' G4),#" ]Ahx#


21/143

3$

,-0+ (#)*+

L3&'" PAG'" 2XY7- CD-Rom-RamLaser Disk Drive r= 3Fc9%C8 8 (zVoU' KL ' 4T,' 'r _ 4 # 5' 6xQ!),' |'0e . ' [!Vo9" |#g ;#


22/143

3%

,-0+ (#)*+

>'4G j )DC W/805U' |'0e k , !T6Qc9,' MBlIcf'4G. ' Iv+L -

^. S/-T'"* (H"AG&' ZL3&'" P"AI9 .\XY7 (CD-RAM) |'0e . '

(zVoL

# DoC

(zVoL

" =8

CD-ROM ,8!P#:LZ

-

#


23/143

31

,-0+ (#)*+

h4U'8 > H#X,'8 (4b,'8 m#o,' (80H [ / LV...#= ?C8.

A;- VW.( %XF2Y ,K*W"AGP Slot#

7/e #Q%0&7

(4 4 (x#H

X)9cU' f#:m. ' $ +"Flash Disk



24/143

54

,-0+ (#)*+

?@-(Flash Disk) ' [ / *H # ) / L K6Qc9,' dn#A8 KL ' 4T,' 'r= 3Fc9%6# * : G K:,8 [5T9U' @)b,' |05,

6 !G ? V 4 6) " #L g8'09C !T6Qc9,' # 9+A (' # TL F14 bi8 B 6#"# : !Le 0+A8 B 6#"# : !1!T6Qc9,' # 9+A (h'; #*)H h'hQ6.,4


25/143

53

,-0+ (#)*+

q. F &' s^#e +"#l(Inkjet Printer) 3456 ' 4T,' 'r=8 8 !Lh#b9,' ?C (#+"#S,' KL " = M#DS,' ex8 " )M W0m#DL [:o,' 8B Y 0&' /#oP2"

KL 'F1 W ? V 4 ('0Se ` x SA'4" F &'(SprayDroplets of Ink)6# C - @5 1 fzg KL ex4,' " )M

M#Dl # T: 2 ##M # T:,8 M#DS,' - !,#M y#T=8 h4AB8 $ !"B xQ!, (#+"#l F14C 6 !G F &' s^#e

' +XC0L #


26/143

55

,-0+ (#)*+

KL F"i @A#&' (#!{0" " )M Y 0+9,'>?'(Software)/#TV9Ai' @A#\), K: 2 i J,'8[!VoC 3#vP p4:C Fe " =8 #


27/143

5

,-0+ (#)*+

"#$&' (#)*,. /1 24" #6& 7#1 8:


28/143

5!

,-0+ (#)*+

./ggD


29/143

5"

,-0+ (#)*+

i-Z [! 4 49,' rs#TL KL ' '4P' X z 1 0H^' b-...........................e-..........................f- .........................h- 3'0,' ' '4P' 0H^'RAM Z

...........................

..........................

I-) " w0X,' 4=#LDRAM & SRAM Z

i-Z {FU' (#P'4SAi' (zVoL ' '4P' 0H^' ...........................

..........................

..........................

h3W/i:#3'*)'" #OjA'" #&C,"ICDL: b-B 6#" 4)!H FG'8=

100B 6#" 1000B 6#" 1024B 6#" 1240B 6#"

`)M dVt'FG' x#D9gi' x'x;'.

e-!L4A0,' < 0+,' m#m Y' @\A') 9)*O'q4A#&' WFn#s p#\t4C ) 9),'.

|%7!K; .%$%FP6/ '8 KFPh [42 9F-K- AMB!

%?,"/ :%M-I/ '8 'F80+eGB6/ vA8 AMB!



30/143

5#

,-0+ (#)*+

!"#$ %&'($

)&*+,- ./0 1234($5(6$ 78&9$

a0O Q0_7B6/ FO%G


31/143

!"#$%& '#(%&

#$%&' ($)&' *$+,-. "#$%" &'"() *"+,-)Windows XP(./0' 1'.02%" 3,4,5.

2 6" 37.8%" *.9#:' ;(71,?82%" @.A$% 3,B.Windows XP

&'.9C%" D

;:E2%"

(F.$G

)&'"() H BI 3 .JKM(0%" 37.7I NI.O" *"P"QGK D ;:E2%"(

,G(4%" *"QRS" QBT) UR' V4BI W) 3,G( *"QRX YJII QRX 1ZG 3,4,5

' ./0' 1'.02%" 3,4,5I 3\ERO" &'"C%" ]0) ^RG *.\,_`a

)b(:4O".c(%"-3_c.d" @"Qe2c"(

Rfc='3,%IQ%" 3hi(%"ICDL

jk#l3hi(%" g' m#J#O" " < D bPn"#%" 3Rfco",%IQ%"



32/143

!

!"#$% '"($%

01231: !"#$%& '()* +$,-Operating System.%& /(!0+%& 123 45!6789 :& 45 /;#*3& ?(@&A 'BC$8D& EF G!?H%& IJ (KL M >?(@.>7?(@&

)Windows VistaMWindows XP.,M2000Windows NT , Windows ME Windows(A }(-&s5 f% '()* q.

U(ID& !V? rcg (6`5A !"#$%& 1)* 1),5 i ?$@,& 5 (6, ! AA Z[q&" %& \& 4-sC$%& ZBpA 45 (2" !N`9 e&[D& # 5&+%& $(gB$?&" !N`$%& Y ! H .]&[kQ&A U(keQ& ~( A " !N`9


33/143

"

!"#$% '"($%

4567-&' A$9#Windows XP: 0B$7&' *$#,C15D$--:E'4567-&' A$9F&

lW? PHb$-r2A (6!O 1b & $%& 4bv $&s:& < '(' 45 >$bD&: )->$bD& lW? /(*Ht-&) [kL _(6: 45 ~c$ *( +-'(6D& G-[S

,-3BF& R_ )start(

-C=' HIJDesktop: $bD& lW8%lW8F (66!V#9 - BwA M 8p ZRHm%& PHb9.

#

"$&() *+- Desktop



34/143

$

!"#$% '"($%

$#,3+K'I cons:

$bD& lW8% =Hc,%& A& [8-L&A"3BF&" (Start)1 ? pA


35/143

#%

!"#$% '"($%

O:',1 N3#' 8P *'Q'2RS' T56-U WUN=' "YR N3#' Z$5-[E' 2FRH\ 01]R "^-_ `' NL9a "-D

cU 05F1d&' 03IF='` GJ$e' fV,&' M)g c&h; ` A$L=' M+NB *'Q'2R' T6a

fc-B,9 A& ~cD& $(#*&

X1 GJ$e' 0R$J M)g 8-+ l' *QZ' 'm'#


36/143

#&

!"#$% '"($%

(Start Menu ) (Classic Start menu)

*$#,3+K'` 8?',3&' X1 41$q-:

8?',3&':Y5 5(,$%(F Bmt-?',3&'!"#$%& '()`F ZeH:HD& 1&Ht%& '&BC$?&r2" !N`9cm%& % [t%(q 7e(5 PHb5 A3 Bc0 A3 ~c5 A3


37/143

#

!"#$% '"($%

:

Q$r' 05^5; ,s ` *$#,3+E' A'2t-JE u$%1 h[vW0:Nq1bwN;'h&' 0x5VRAM z$L{ wQ,|,=' )- *& [9H!V=b%& _(6:


38/143

##

!"#$% '"($%

wh:$F&' T)Ca ` }]~' Z !#$%

&()*+%,.01%

)2357 !

89;


39/143

#'

!"#$% '"($%

N+Nx-&' 0 NB' [-[=$%& R&R_& '&BC$?(F u`bv A /(5Hc,D& 8p fc!b#9 1$- 7" %& P(bD& Iv >$bD&/ ( !mN9q/&Ae5 & f!cg YX- / !p 'BC$85(/&R(m$kL&)UA(`$5 y PHb9 / ! QA fc=g 689 (K3 7 [- .%&

>$bD& lW? Y5 5(,$%& RH 1 45A M >$bD& lW? 0 (mk GV !A=& rcg ; A(=c% 4v5 & Rs%& 6 cg G"X%(F (6!cg m L .%& 0 (mk R(!$k& 1$- $bD& lW? 45 P(b5PropertiesZ" O(* [6)9 (6`5A

S [,%& 0 (mk P&H`,F.



40/143

#)

!"#$% '"($%

V,-&' 0B$B:bS B-B^ ( 8( k 45 1$- Z" O(* [6)9 ~wH$%& $bD& lW? R_ rcg G"X%(F

!


41/143

#*

!"#$% '"($%

>$bD&)8p ZRHm%&(ZRHm%& Y ! A i 1b & $%& &" qA)G!?H9 R8C"-&' 0D,&:(6`5 R($ U


42/143

#!

!"#$% '"($%

FU 8C"-&' 0D,& 0B$B wh:$# NL9a l# iCj`xs` M$ 4; 4['Q i1 $xLF5U 4+2)-&' iCj%NqY&&I:


43/143

#"

!"#$% '"($%

5RN^&' *'2Y) ' 2DvU >Y1*^D +U 05RN: *'2Y Xg`` 2Y 4xR 05^5;*'2Y) ' ` *$^Y=' u,D 01$R wN

I5 M

>7C-k=' H-:)- 3BF& R_ rcg G ! &+-# 5&+%& (6`5 R($k&


44/143

#$

!"#$% '"($%

IQ$v#%" U8:2p' D *"QRS" I *.4RO" w.:7= g' 3$,G



45/143

'%

!"#$% '"($%

2+2| 2Y , $7#' ). _AB*H%& ~#b$85 l$O&-$(#*& B-[9 =" %& Bc 3& A& %&[wL& z[ Z rcg G" ! &. w 45Bc0 [t*& : M B-B: \& [S& ~c5


46/143

'&

!"#$% '"($%

0@,"Y1:4vL& $ s 9& i < . R(O

Shift akL& [m`,%& YHO [t*& : 4($N5 rcg R&[=$?(F G" ! & M

[m`g q YHO G" ! &.QRS" I" UR' ;c" {,?a

PDF created with FinePrint pdfFactory Pr o trial version www.pdffactory.com


47/143

'

!"#$% '"($%

?a g:|2\v(`%" QBT) URO" I" QRS" ;c" {: )U8:2pO"(7._' 39#\vo" @"Qe2c"(

I6" 3\v(`%" ~#b$8D& l$O&f ] & a!"9 e&[D& Bc 3& A& ~cD& YHO [t*&

( I5 >$b* A)>?(@& n($q(

[' ./0' 1'.02%" 3,4,5I 3\ERO" &'"C%" ]0) ^RG *.\,_`a:-

)b(:4O".c(%"-3_c.d" @"Qe2c"(

~I6" 3\v(`%",9.[%" 3\v(`%"



48/143

'#

!"#$% '"($%

`'


49/143

''

!"#$% '"($%

0E`'/:2&' X1 41$q-&'



50/143

')

!"#$% '"($%

5J$5V H5a$^=' 0D,&1m,$

R#0$' Q>' E;U !


51/143

'*

!"#$% '"($%

JK' H5a$^=' 0D,& >?$@5J$

Alt-Shift [8-L&



52/143

'!

!"#$% '"($%

01$s 0@,"Y1

4%1 *$35)I-&' X52 ": 0-U$P H5a$^=' 0D,&` z,1N&WQZ`,&' Y 4k;E'3pp4' $5#$P/$JN&'/1$#NU X1 41$q-&'

YF[5 (6`5 A /&s!5 ZBg rcg '(?[%& =H$ > A '(?[%&


53/143

'"

!"#$% '"($%

r9L& YV$- P&H%5 & A& /&Ae5 &: 9 - 1&Ht%& G-[S 45 [t`%& 1$- u5(5& =" %& G-[#%& [6)- S [g


54/143

'$

!"#$% '"($%

,.H2


55/143

)%

!"#$% '"($%

>$bD& lW8%


56/143

)&

!"#$% '"($%

rcg G"X%(F

Na,5)xC&' z$L| }]~'

3BF& R($k&(6`5 R($k&


57/143

)

!"#$% '"($%

*$;;;)+Z2a )-d

[-B -[ C 4g ~wH$%& ...............................................................................................................................................

\- %& # 5(*[F i $q&d u!? ( b%& Y ! H%& \& r?(!t%& Y ! H%& 45 _AB*H

................................................................................................................................................. ...............................................................................................................................................

e R


58/143

)#

!"#$% '"($%

"# $:%"&'(&) %*+,&) %-./)ICDL:

0'1) 0)23&)

4 5&) 0)23&):-

'



59/143

M icrosoft Word

!"#!$ &"'!$

"#$%&' (")* +*",-. MICROSOFT WORD

//&"1&' 2"3&' "45 !"!#$%& '#&()%& *+ ,+-./%&0 1+-23%& 45 +6)+.67/"8& 5-9: 0 ;&?&65& @!AB !



60/143

M icrosoft Word

!

!"#$"% '"%

9*:;*:

m+ ?U00 n(m=7%& o-m.+ 1+-m2$P 3m/.[4 mp-.+ d g-m!%-I +6f/m"8& 1+&3m%& ,mqbr m[-s 67/m"+ tmO5 ,m=u 6!-m-mm!OG5 -&$mmRV0 D JmmK&+ 7mm%& d mmGOC 4mm5 zmm;9%& . %}mmC D Emm= ]rU e-mYUr 0r 4[0-m75 b-mcV D >&$m)-b-m"8&0 / +&( && E!"7B D - &&69/`&0

-W/[- 0 0r >-;-m2-!P ,m!y 10 -mW!b >-m2-!9%& Q0&6mB %(Wm`0 Q0&6mp& ,mG5 !2-a+ * P 1+-23%& \!G/[ -GC

& -mmq[r0 D mm!2-!9%& e(mm`$%& e&6f/mm`-P Q06mmp&>-+(mm`U D U(mmS D U-mm:V T&U?V tmmO5 XU6mm)%67/"8& ,k&? !c-[U >( ?-.+0.

n(m=7%&0 ](+-m)%&0 2 m#Z+x& EY6m8&0 3(m;7%& EY6m8& e&6f/m`& m!2-a+V -q[r 4-7~0 imOA8& ,mG50 D >Z`&$8& >-&0?$ & 4+ 6[6.%-P $k\[ 1+-23%&,m+-a/+ 67/m"+ tmO5 Q(= ' & 4+ -7a 1 w%& ,#-`(%&0E!"7/%& Y?0 7 .8& ;S z!I 4+.

"4'


61/143

M icrosoft Word

"

!"#$"% '"%

>-;


62/143


63/143

M icrosoft Word

#

!"#$"% '"%

'#&()%& $ # ` tG"[ B G#-Y F7+ Q6"7[ $=75 ,C N( 4+ 5(G{ tO5 -W7+ ,C 9(/ t~ '#&()%&

%}~0 $+&0

$ &:

C-iO+File . D- $[$ BEdit . J-K $5View . L-T&U?V Insert .M-E!"7BFormat . N->&0?rTools . O-Q0&6RTable . P- U-:VWindow .

.a"I;&' [4-\

>&0?$ & $ # ` tG"[ Tools Bar)2 `-!Y(,mC 9(m/u >-m.P$8& 4m+ m5(G{ 4+ N(a/[ z!I $m+&0$ & mG#-Y 4m+ %}m!-.P$8& %}~ m%-.&0?$ & Nr jIZ[0 D ]0-8& ^-/


64/143

M icrosoft Word

$

!"#$"% '"%

>&$)&$)&$)-GOaO% t#Z+$ & E!Y6/%&

$WB z! " ;


65/143

M icrosoft Word

%

!"#$"% '"%

9c5h$* & E[$: 45 2 `-!)%& >&0?$ & J[$_ 4+ 6[6R iO+ --|2V 4a \+$%

B6_=' 9i"3j F 9hbA&' 'D':i' kIJL 9IblUF'8hbA&' 'D':i' kIJL

(~ P-/a%& ,9Y X?6 B N& !Y Z _ Q0& ,.%>?@A # 6B6[6 B . %}C 0 ;


66/143

M icrosoft Word

&

!"#$"% '"%

M-6[6 B 4a / +&( && U @ tO5 $)7%-P !O&0?$ & $ # ` 4+

!%-/%& >&( # K&: C-iO+ G#-Y < /b&File .

D- $+$ & $/k&Print'`-P X}b-2 $W/`Print5-9 # %&.

U-!/k& '/[ - &

Zk 4+ YU(%& ]-)+X-v& 0

[-/a%&)t)b& 0& 9?(G5( tO5 $)7%& E[$: 45

U-!/kZ% OP-)8& X$#&6%&.

X6[6p& >&?&65x& ,.p!c&$/b& >&?&65 * C

.P- # %& L(2A!)B&!C (DE6?&'

!)FG!HI J6D:?&' K"-&' -;


67/143

M icrosoft Word

#'

!"#$"% '"%

9i"3m&' H3p 9B4"): / +&( && @!AB0 D - & Zk < -;&( # K& L-9B] P . %=0 D: C-iO+ G#-Y < /b& File

-Wm7!P Q-m)/2( & 4ma X$Am=+ imO8& >-;


68/143

M icrosoft Word

#(

!"#$"% '"%

&'I_B6C9#qr F [s' t5, kIJL O 5$&' 66m T . m%=0 JmK& E!m"7/% e6f/m"B _ m%& >&0?$ & 4m+ 6m[6.%& tmO5 ?U00 1+-2$P 9(/u

Q- `& &}~ I 1+-23%& >-2-a+V : .P %}~0 D a U-)O% < [$+0 '7+ 67/"+ tO5 Q(= ' &.

uv[s' t5, kIJL(Font ) C-(2 X&?r H tO5 ?(R(8& 'W"%& JAcVI-/8& b( # K& -- c r G#-Y $W/ JK& L D-[ (O # 8& JK& L(2 tO5 JAcV

2vs' ]qr kIJL(Size )C-JK& 'HI X&?& tO5 ?(R(8& 'W"%& JAcVe-YU& G#-Y $W/`D-JK& 'H ' & tO5 JAcV[ (O # 8&

vs' W5& kJL -6 $I U-/ X >&0?$ & J[$_ 4+A 0r '`$%& J[$_ 4+

[s' t5, kIJ6& "BQ [JP'

IJ6& "BQ [s' ]qr k



69/143

M icrosoft Word

#)

!"#$"% '"%

d ?(mR(8& 60$ ' & $+& 4+ -q[& 9 $k& >-!OG50 )P-"%& E!"7/%& >-!OG5 -&$R& 4a -GC %0 DE!"7/%& G#-Y!%-/%& >&( # K& *9B& . %= ,G. :

C-E!"7B G#-Y < /b& FormatD-Jk $+( & $/k&(font)'` * P X}b-2 $WBfont)Jk (6[6 B - & Zk 4+ 4a

!%-/%& >&U-!/k( &:

9c5h$* v )7%& ?&6./%& 0& >&$)-!2-a+x&K0$.%& 4+ @yaP ==f/8&.

9c5h$*

LF-z' HI%Kv B 675 . WR&([ 6Yb0$I G(b ,!a|/%& *c0 ! R(/"[ H .+ + 2 67/"8& $[$ );/-[& d -GC-7% ^-B& 6Y0 D i[$|%& z[6 ' & 0& d $a%& N&$)%& ; -/%& Q06p&0 ! `-78& ,!a|/%& *c0 . 7a 60$ ' & P-/C 6.9b D !S-K& X}~ ?U00 1+-2$P

Aq%& [ (O # 8& < !B-


70/143

M icrosoft Word

#!

!"#$"% '"%

!"#$%& '!()*+&,-$. / 01 +Shift

'$.

2345(

6 07 Shift+

,81 9 0: Shift+;1 2345( < = Shift+

> ? Shift+@ AShift +

BCDE F G Shift+CDE 2345( H I Shift+BJK 0 L+ ShiftBJM N O Shift+

!"#$ % & Shift+

{F':|'Table X6G5$ & tG"B F!`rU b( # k *:-)B 675 Q06p& 4[(aB '/[ ColumnsFm!)br b(m # k0

6(


71/143

M icrosoft Word

#"

!"#$"% '"%

(- %& t=Yr I .Y&(%& !OK& d ]0-8& ^-/


72/143

M icrosoft Word

#

!"#$"% '"%

{F:|' Hn'D ~-h6&'v

& -[Zk ,k&? Q-)/2( & F)[$: ; -/%& ,a|%& H 9[Q06p:-

"6b=' bIc5&' ]0-8&

^-/


73/143


74/143

M icrosoft Word

#$

!"#$"% '"%

$+$ & $W ^ &= V INSERT CELLS4+ ( 6P)X6G5r T&U?r 0r 6(


75/143

M icrosoft Word

#%

!"#$"% '"%

F:q$& DF:r H#i Borders 6m75 0 !a9m_ b(m # k 4m5 XU-m95 Q06p& ?06I N-P Q0&6p& --|2V 675 jIZ[( m5-9 # %&

w%& >-2-!9%& J)b *9 # B 0 ?06 ' & %}~ $WB -W[(/uQ06p&.*m+ Q06mp& ?06I F5-9 # %0!%-/%& >&( # K& *9BV FB-2-!P:-

C- -~6[6 B [ (O # 8& -[ZK& 0r ,+-a%-P Q06p& ?6I. D- E!"7B FG#-Y < /brFormat. J- /kV- ,!OB0 ?06I $+$ & UBorder and shading:-

X6G5$ & 90-"B 6.P Q06p& ,a_

?6I) O5t ([ (O # 8& X6G5$ &

! 2&(R 6[6;/% P(O # 8& ?06 ' &-[ZfO% !Ok&6%& ?06 ' &0 U-:x& U-:V ,G5

J)b 2 RU-k 0r Q06HO%

X?6 E& -[ZK&



76/143

M icrosoft Word

#&

!"#$"% '"%

>&0?$ & J[$_ 4+ -q[& . 7a 0)?06I0 Q0&6R(. %}C 0 !RU-K& ?06 ' & Jk L(2 U-!/k& FOGC] P Q06p& tO5 6[6 B 6.P . %= 0 !OK& l9.BD

M-

J g?06 ' & Jk

!RU-K& 0 !Ok&6%& ?06 ' & U-!/k& 4a &05-9 # %& 675 -W#-


77/143

M icrosoft Word

$'

!"#$"% '"%

"4#s' +*DMERGE CELLS :6I&0 d !Ok 4+ $yC& 1+? 4a !%-/%& >&( # K& L-9B * P . %=0 X:-

C-Q06p& -t|2V D-X6G5$ & K $5 ?6I)-[ZK& 1+? F!OG5 -&$RV ,9Y X6G5$ & K $5 6[6 B ,q


78/143

M icrosoft Word

$(

!"#$"% '"%

! %-: i`([ 6 $_& ?-G5 DMDML! %-: 4"I ?(G > t< # =+ NMNNN>-!20$/a%& t#-=k& i`([ ?(G > 6 k & LMLML

=


79/143

M icrosoft Word

$)

!"#$"% '"%

N-. 7a XU(=%& TU6B N& 6.Pe&6f/`-P -W)"7B N& XU(=%& J[$_

O-L-9B-P . %= 0 ?(R(+ iO+ 4+ XU(=%& T&U?V 4a -GC 4+ ( 6P 4a% 0 >&( # K& i


80/143


81/143

M icrosoft Word

$"

!"#$"% '"%

I^"* 9*# i H#i m!&0?& J[$_ U(W ^ '/[



82/143

M icrosoft Word

$

!"#$"% '"%

hbA$& E"m4' H#i '5ms'

C.tO5 $)2& '#&()%& J[$_ 4+)E!"7B(D. U-/ X E!"7B 4+),!OB 0 ?06I(



83/143

M icrosoft Word

$#

!"#$"% '"%

J.;


84/143

M icrosoft Word

$$

!"#$"% '"%

w'ED} '5mn"pEu "hbA&' ' * < /br V G#-YT&U?insert D O U-/k&e-YUr; -/%& ,a|%& $W[ 6(` >-;


85/143

M icrosoft Word

$%

!"#$"% '"%

M O R /kV- Eb&(+ Uok `)P-"%& . B&U-!/k( -)9: -WG!Y$B U 6Y >-;


86/143

M icrosoft Word

$&

!"#$"% '"%

,a|%& &} T

$W[

Eb&(+

tO5

$)7%&

675

0

xvI^";$6&' {"%\U' Q-a_r GOC tO5 $)7%& 6750 '`$%& J[$_ 4Gc !#-)O/%& Q-a_( & 6R(B'/[ !#-)OB

4+ N(a/[ 0 G#-Y < /b:

PDF created wi th FinePrint pdfFactory Pro trial version www.pdffactory.com


87/143

M icrosoft Word

%'

!"#$"% '"%

9^"i:6a' F o$=') br 9IbIR >&0?$ & $ # ` 4+ j< ' & X&?r *P$+ JAc& 6[6p& iO8& j

folder iO8& [(/u 9}%& ]$W


88/143


89/143

M icrosoft Word

%)

!"#$"% '"%

P- U- # [& ,G5 Q-a_$ & 96I * P )P-"%& r Zy%&

! /C& R ,G.%& >&( # k

X6~-|8&0 P-R( & `&$aPq

"# $:%"&'(&) %*+,&) %-./)ICDL:

K"$ K LMA:

N(OA K LMA:

G U @( & N(O%& ; & ?6 E& + 7%& N(% @!A/P 'Y ^(;O+:+ 7%& tO5 >&@!AB 9r $v( .

%0(10



90/143

M icrosoft Word

%!

!"#$"% '"%



91/143

!"#$%# &'(%# "#$%&'() *$)+,)

M icrosoft Excel

M icrosoft Excel

!!!"#$%&'()*+,* -#.,*/

!"!#$%& '#&()%& *+ ,+-./%&0 !10$/2%3& 40&56& 7+-1$8 9: +5)+;-!1-< =#-:5/>&0 ?@&5/+& A$.+0 BCD& EFG !F!HIFJ%& K&@&5:L M!NO !F!H=P+ QRS 0T 5P/"D& :-UV0.=)!"PO0 4056& 5W5X !F!H

!1-!U%& Y(>$%&0 %@-.D& 8-/H !F!H)Z-!U%& ,![\/%&( K-"W-)D& ,\.% !)!U]O C[+T ^$_)`Ja/%& b"G(



92/143

M icrosoft Excel !

()*+,* -#.,*

-.+/ 12345) 6.7#89: "#$%&'() *$)+,)

7+-1$8 cT","HT"9d+ =% -e 7+&f%& g5J/WK-d!1-2+LdC#-hK-+&5a/d>&0-iA$./d> d:(P/+5.8 -\!A. dd+ ,d+-./C% ;-d>->T Y5a/d"O !8-d"j& 40&56& 7+&$8 cT 'kg0* @&5d:3&0 K-d1-!U%&

'/l0 m !\n$%&Q&$So8cT p& m -i[W5dX0 -i!C: !8-"j& K-!C\.%&",d"HT"q&$dkT r Y5a/d"W sdP2t 4-dd[D& ,!Ud> udC.A m ,d\.%& v&g0T0 K-FPJD& *+ ,+-./%& ,[d+ w$xTY&5a/d>&Excel

&5:3 0T dP!.+ K&$/A 0T y$/F% K-.!UD& z-"G 0T m W$W5)/%& K-1{&(D&0 K-!1&R!D& @|&$a/d>p 7O-d1 K-d1-!U%& 5d:&(n yg&@L dF!}(8 Y-d!)%&0 m d!%-D& B#-}(%& 9+ -hfk0 !~-W$%&0 !8-"j& [email protected]& $%& 9d+ y@5d./+ 4-2d_8 ;-d!1-!8 ,d\.%& dng0 -di!C: ,\/d O ! %& K-1-!U%& ,[ "0md!1-!U%& Y(d>

)charts(!1-!U%& Y(>$%& :-UV0. Q&$dSL0 d!\n$%& K-d1-!U%& =d6-.D d!10$/2%3& K-d1-!U%& IF # Y5a/"O yM[H 7+&$8 K$i} 5n0

-i!C: K-8-"j&|&$a/>&04-2_$ & FC/ % 7#-/1. 7+-1$8 7+&f%& ?& h =\n uC: c-H0),!"H&. (

2"34< 6.7#89 =>8?@ 0!\n$%& K-1-!U%& *+ ,+-./C% ;->->T Y5a/"O ' %& !10$/2%3& !8-"j& 40&56& 7+&$8 9+ 5G&

,[+ -i[W5X0 -i!C: !8-"j& K-!C\.%& Q&$SL0: T " W$W5)/%& K-1{&(D& @&5:L. z-K-.!UD& Un&$+. |- !%-D& B#-}(%&.

dh-!1-!8 Y(>$8 K-1-!U%& ,![ ". 0-!#-)C/8 4-\:$ & & !FPO)KpR/aD&. (

{-q$: K-G(% z(C>o8 !1-!U%& Y(>$%&0 K-1-!U%& q$:)SLIDE SHOW(

2"34< 6.7#89 =B7C$ T-K-1-!U%& IF # *+ ,+-./%&)WORKSHEET(!8-"j& K-!C\.%& 7#-/1 |&$a/>3

z--1-!U%& 5:&(n yg&@L F!}(8 Y-!)%&K.



93/143

M icrosoft Excel #

()*+,* -#.,*

|-!1-!U%& Y(>$%& 9+ y@5./+ 4-2_8 K-1-!U%& ,![ ")SHARTS. ( @-0 0$H-D& Y&5a/>L)KpR/aD&(-+ !C\: & !FP/C% u:5/"W MN # 7+-1$8 (h0.

dh-K-1-!U%& IFJ% !1-!8 Y(>g A-~L !1-2+L. 0-z(C>o8 K-1-!U%& q$: !1-2+L)SLIDES. (

2"DE@E X C E L

(.T58& {g uC: ) N~&)start(. *.7+&f%& uC: $)1&) programs(. +. $)1T )OfficeM icrosoft( ,. R+$%& 0 ,!"H3& 7+-1$8 g-/x&

234( "F7GGH() I7E') $

!# %



94/143

M icrosoft Excel %

()*+,* -#.,*

2345) 6.7#89 KLH7M' "3"B8') N

"#$ %&$()*+,$ %&$$. /,$ 01234$.5,$ 0123

0123 6$789$

:;&);5,$

$?

212@A,$ 0123B5C$

D.E",$

-$. F G2/1:?$

0123 6$789

H;I A,$JK@FL$ ,8)/#$

0123

212@A,$ 0123B&M2,$



95/143


96/143

M icrosoft Excel '

()*+,* -#.,*

? ns/n0 $A(O K-!C\: & !FP/% Y5a/"O K&0@T uC: ,\/ W b! B (d1 g-d!/x& =d% 7 x 9d+ 9d2t0 -i\ 2 G0 )8 & C8-/2%& y$)A 5 !"PO C8-/2%& y$)F% uC2%& ) U ? %&-)8 & c(% M!NO

>8QG') \8IY 5P/"D& ,x&@ > FJ/C% Y5a/"O.

'X7?P) W>8I ] P%& !C 8& K-W(/ D $i = W " \H- E-x@L Q-P


97/143

M icrosoft Excel (

()*+,* -#.,*

,!N O 92t,"H$ &y& A-1 9+ !8$.%& NC%-8 y$_-U+)7+&f%& yg&@L( T- $)1T R+g)B (

z-> /AT,"H$ &)F L 6 \!%& 9+ =!A 8-/2%& ?- GT0 5P/"D& $i = Wuh 8-/2%& N%0 g-"!%& !8$.%&(

|-

`J H,!"H3&@&5/+$ &[.XLS]

w$x$ & K&5P/"D&

9:

&R! 4

2"34< i7j#< A8\ lmn9 Y_B)O-') 8Se

(( BC+ \#-n > /AL *( $+T $/xLQ-


98/143

M icrosoft Excel

()*+,* -#.,*

6.7#]'79 u7aR5) v>8?@ ^H _&`G->8S9 )T ( "@7qP) FO' u)+xGey9:

(- )+0 40@ g-/xLM !W- *-!8$.%& NC%& 5W5X '/W +-) )A w@ 7 !D& N()/%& *+ ,!"HL ,+-./W

)z( .7#]') ^H _&`G') QB7a b98. u)+xGey9: (-^-/F+ ) N~T 0T y5G&0 y$+ '2I/%& *8$+ $)1T)ALT. + Spacebar ( *- $+$ & $/xT :T-ARABIC) {05PW(%& c-H && k=':@(0T

z-SYSTEM) {05PW(%& c-H &A L=@-\/:L( c&(P.8 *8$+ uC: ,JX)M !W-)+0 40@(

+- $+T $/xL)+5)/+ K&g-!x( K&@&5:L c&(P.8 *8$+ uC: ,JX)!8$.%& NC%&(

,-b>-PD& ) U ? %& $/xL.

+MG3P) zLH7# 2[)X {8`G AG->8S9

T-Ryq') 8I|.:- ;-.UO =C2_ MN/W J !G)8(C]D& !C\.%& B (P%(F-/%& 4056& b"G:-

$_; D& F L M O -+5P: $i = W



99/143

M icrosoft Excel )

()*+,* -#.,*

-iP+ y5G&0 > /F% '#&()%& ) W$_ " c&(P: 0T-iC)1 r Uk$%& 5P: y& A-P%&

| !C 8& K-W(/ D 8-/2% %@-.D& ) W$_ -i\ 2 G M!N/% y& A-P%& %-G

? D& K-:(~(+ 9+ B (~(+y5:-" }Jp"@7qP) FO'

& A&(1 ,x&@ O $I/%& 8- O uh0" {05PW0"+-: FJ8.

N~X7?P)$ u7aR5)$ "H8d) N7#7"h')J K-1-!U%& IFJ% ,x5O!10$/2%3&K-1-!U%& 9+ B &(1T < 7 8 ;1>$7M?') *7[X)J

T-5W5S 5P/"+ > /AT z-!C 8& g-/xT)A1( |-&b/H)4(H O g-U+ @ g&5+( @-4-x@$ & 0T *8$+ $)1 ?-!C 8& g-/x&)A2( 0-b/H&)-+ `Ja/% "W-)+ ,\:( {-0T *8$+ $)1T4-x@3& ^-!C 8& $/xT)A3(

R-b/HT)Y-:*SST( w-T0T *8$+ $)14-x@3&



100/143

M icrosoft Excel )*

()*+,* -#.,*

CO`T.J K-1-!U%& 4-x@L 92t y5G&0 y(]x r4-)/1p&06 /)W$]8 yg0- U& !C 8& F&:

T-ygF%& g-!/x-8y5W56& !C 8& z-'i> $ & 4 7 x 9+ > !O-FD& G(C8

1>8 K-.!UD& - -P # T 4-x@L G V $O(!U\H yRiS$ !:-PJ%& @ g&5D-8 4-D& @Tg B 0$ + 9+ -i.\ :

T-!C 8& $)1T)A5(BPJ%& b/H& I

z-!C 8& $)1&)A6(K-_-_ b/H& I |-!C 8& b/H&)A7(K-.8-V b/H& I @-!C 8& $)1T)A8(UC # W&$nT b/H& I ?-!C 8& $)1T)A9(1$+ W&$nT b/H& I 0-!C 8& $)1T)A10(b/H& IX- Y LK-.!UD&.



101/143

M icrosoft Excel )$

()*+,* -#.,*

"Qa8') N7#7"h') *7[X !C 8& q$: 9+ fHT Z 1-H &A L uh0### !C 8& q$.8.

1>8 ;N7?"hP) u7aRY *7[X(J T-9+ -W 78& 'C:B6F&D9 z-'n$%& b/HT(SSS!C 8& r 'n$%& b/2!A 4-x@$ & I)B6(!C 8& F& $_; D& ,)/PW IB7 |-Y-ng$ & !)8 b/HT-iP+ ,H 8-/H 5.8 4-x@$ & ) N~ *+ I~(D&:-

!C 8& 'n$%& B7 *SSS B8 */SS B9 +SSS

B)O-') W>8I _- %& uC:T r W-x K&0@T ) W$_ 9: yg-U: (h'#&(d)%& Q-d [ T udC: ,\/ W)d\#-n ,dH

$+&0T :(\ \ uC: ,\/ O(,[+"1/ "0 m"2#3"0 m"#5"0 m"7+-8" m0":;


102/143

M icrosoft Excel )!

()*+,* -#.,*

\#-n (h '#&()%& ) W$ % 4-[+ 01/: 6 Ud+ (dh -d\H uOp& ,\: - E7 x 9+ 92t \#-n 4&5"1& EG 7 1 BC+ \#-n uC: $)P%& '/W 0

,2 %-8-u\d"O > !O-dFD& ] d.8 -di+-+T $di = W $+&0$ & ] .8)SHORTCUT KEYS(wT h Y()O J !G y$J/aD& > !O-FD&-i+-+T > ~(D& $+$ & F!}0 M FP8 > !O-FD& ?& .

p =1$ /h-8 $i = O $+&0$ & ] .892t-hg-U/x&- $ & > !O-Fe O $I/%& '/W0]ESC. [ g(i} *+ g-!/x&0^_ $+T) $i = W^- ? WLK-+(C.D& ) W$_ r $J/ % =P:. (

`q%') X)+0< g-!/x& '/W '#&()%& ) W$_ 9+)IFJ%& @&5:L(-idP+ g-d/ L IFdJ%& @&5:L c&(P.8 y& A-1 $i = O

d!%-/%& y& dA-P%& 0 4(]%-d8 dng0 uC: ,J ` !%(V :-UV uC: $)P%-8 0 K&g-!/xp& $i = O IF # K&@&5:3& > ~(O..

5W5S BC+ > /A

> /A5W5S BC+a (F D

BC+ EFG

40p BC+ EFGy$+

IFJ%& ) U~b +&( E& @&5:L 0



103/143

M icrosoft Excel )#

()*+,* -#.,*

&.)O' ) & F& )8-"%& K&(] 8& M F1 g$H g-/ L %-j& ?& h r0 IFJ%& @&5:& y& A-1 $i = O c)b +&(h(

=/7>?7 @ AB:5J)W 0=8!%-/%& K&(]aC% ;-.UO ?- G L wT r :(U]D& )]PD& 0 ng(%& A-G 6 8 c &$F%&:-

(.\#-n 9+FILE g-/xTPAGE SETUP $/xT Ib +&( E&MARGINS.

5P/"D& -!%(V

5P/"D& ;-!~$:



104/143

M icrosoft Excel )%

()*+,* -#.,*

*. i> $ & 9+ '!)%& c-J)1 0 y@-W{ '/Wy$_-U+ 'n$%& 8-/H 92t 0 ' @05G c(2O s%& 8 0IFJ%& 6 t=( m g-"W=( mv(A=* m,F>&=*+MG3P) 07h\:

T-\#-n 9+BC+ )FILE( ( g-/xTIFJ%& @&5:&)PAGE SETUP(.

z- g-/xTPRINTER SETUP C: w(/ : g&$G *8$+ $i = WK-.8-]%& B &(1T u A$.D& 0 y@(S(D& {05PW0 Y- = P%.Q- ? D& ) W$ %& Z X !%-j& .8-]%& $i = O 0|- /xT .8-V 9+ $[HT O-Ph c-H &A L- I -h5W$O ' %& .8-]%& gOK 4-x@$ & 0T.

r"js V$+9 +MG3P) 07h\: M"?. N7`q ^H _&`G') V$X(T4 =TP): ) W$_ 9+ g-/xT92t 0 Wg-S :-U]%& c8 5!FO %->g $i = O :-U]%& y&@T K&0@$ &

d8 -iA-)WLCANCEL.

s 07hST' +MG3P) r"j ,i"O 0 =OQ-FH 9+ 5WRO B (U]D& 5P/"D& uC: K-P!"X 4-x@L - 9 5J)W=OQ&$n=\iA 0

,[+:A-~L5P/"D-8 K-IFJC% ,!W& O 0 @Tg-b +&( E& M!NO--.8$+ Q-N%L-W 78& K :-U]%& 5P:.wg&(G *8$+ 4 7 x 9+ s%A '/W 0:(U]D& IFJ%& R!i 2 /8

u\"WPAGE SETUP DIALOGBOX'/W 0?Q-:5/>&F-/%-H:T-\#-n $/xTBC+)FILE(-iP+ $/xT:-UV)PRINT(=P+ g-/xTIFJ%& @&5:L)PAGE

SETUP(.

z-9+ 92t 0BC+)FILE( L g-!/x&IFJ%& @&5:)PAGE SETUP( R!i 2 /% y$_-U+ IFJ%&.N~X7?P) *7[X<

9: yg-U: %@-.D&)Y-ngT " !~-Wg {(+g " d!C 8& 'n$d% yg-_L " dP!U+ dF!}0(- 5d E& d%@-.D& d+ 7 .8 T5dUO cT bd d d%@-.D& K-d1-!U%& IF # ,x&@ w$xT -W 7 x r y@(S(+ '!n z-"G -iP+(=)

:(\ \ -i.U/O0K-+ 7 .%& 9+ = : :)bQ,) *8S'); *,}8- ');

.Q3-'); :^O-') bHR~) $); *:>. ]4Y; *:


105/143

M icrosoft Excel )&

()*+,* -#.,*

z-!8$.C% 8-/2%& *~0 M 2.1T &A L)& v(]P+ M 2.PW%@-.D.( .

*7n. -)c9*d10( =z$ ? %& !C\: & - 2 !/P%& *~ !C 8& rB11

29)O3 ^T0 2QGE@ 'X7?. 97G $i_ K-.!U+ * Y 7O-1 -P!].O ' %& %@-.D&) $W-PW(9+ -W 78& r C 2 "D&)B6F&B9(

uh= :(SSS+*SSS+*/SS++SSS

?& h

8-/2%!C 8& r

%@-.D&

B107O-1

uC:

4(JIC% 6&!%-/%&

K&(] 8&

*UOT

*\

:-

T- !C 8& $)1TB10 z- uC: ) N~&+ 7 :)(*\6& |- -W 78& uC: @0-D-8 @5GB6 :B9

@- *\6& 7O-1 $i = !A 4-x@$ & uC: ) N~L)1/SS(!C 8& r)B10(0) W$_ r %@-.D& $i = O



106/143

M icrosoft Excel )'

()*+,* -#.,*

!C 8& ?& h K$/xT -\CH %@-.D&

.

CO`T. 2QGE>34Y(9+ $[H& uC:)(/S(u\"O /!U+ F!}04&05%&)Functions(-iP+ - 5 E&0

!~-W$%&0 !8-"j& K-!C\.%& Q&$S& r y5:-"D&. )SUM= (Y()O F!}0 uh@- d 3 * Y 7O-1r *)O -W 7 x)@5 D w5+) . (@(\: 0T B #(

7>mU) u7aRY < KR7I579 'X7? $i_ K-.!U+ * Y 7O-1 -P!].O ' %& %@-.D&) $W&fA(9+ -W 78& r C 2 "D&)C6F&C9(uh:

)C6+C7+C8+C9( =

!C 8& r %@-.D& ?& h 8-/2%)C10(7O-1 uC: 4(JIC% 6& 8& *UOT *\ !%-/%& K&(] : T-!C 8& $/xTC10

!"#$&%( )*,%(

.%/"0*%( 1346

78*%(

9"&:+ ;$< 4#=%(.,?&=%( 4@A' C"D/E(



107/143

M icrosoft Excel )(

()*+,* -#.,*

z-+ 7 : b/HT(=)w0-"W)%@-.+ uh !%-/%& K 7 x5D& cT ,!"HL 'iFW( |-,2 %& &&9 %@-.D& b/HT) :C6+C7+C8+C9( = @-*\6& 7O-1 $i = !A 4-x@$ & uC: ) N~L)1/SS(!C 8& r)C10( .D& $i = O0r %@-

) W$_

*)$+')u\"O m P!.+ '!n Y&5a/>-8 K-8-"j& & FPO ;-)U"+ A$.+ f ! # g h Kp&5%& m) #->(%&

*)$+') o)RX(

(-%&@ -iP+ 0 |&g@& g-/ L '#&()%& ) W$_ 9+ *-&0@$ & ) W$_ 9+ g-/ L Kfx +-%&@ |&g@& c&(P.8 y& A-1 $i = O.



108/143

M icrosoft Excel )

()*+,* -#.,*

')+') u)+xGe) ^T0 *7n.: "\8E') ')+')IF (% 6 /\!)%& 5G& q$.O I 6 /\!n uC: u)]P+ g-U/x-8 F!}(%& ?& h Y()O

!8- d& 2 !/P%& Z 1-H

N)OSU)A (.Sg@ c(" h b%-]C% 4(U)%& Sg@ c& q$F1)/S(*.!C 8& uC: @0-D-8 $FP%-8C2)!C 8& ?& h r %@-.D& 8-/H w&(

+.

g-/ L K&0@$ &

) W$_

9+

)fx ( -iP+

g-/ L

%&@

|&g@&

c&(P.8

y& A-1

$i = O

)IF

(

5ddS(W 4-dd[D& && ddh r z 7 d]%& 9+ :(\ \ b%-V ,H ,JG 5n 0 6 dd.+ B (dd\ \ uddC: ddddd8-/H z(dddddC]D& &A& y$dd_-U+ dd 2 !/P%&

c-Hr p Y& ,dU)W 5dn!%-/%& CG$D&

PDF created w ith FinePrint pdfFactory Pro trial version www.pdffactory.com


109/143

M icrosoft Excel ))

()*+,* -#.,*

,-!C 8-8 2 !/P%& g-i}L '/WC2-W 78& un-8 uC: 2 !P%& bI> '/W I.

FHG 24I%( )JF3 K+4MO(>

Q"3F&R+ L"O (T( 4MO( .?$U%(VWXY+

+,-/1, 235791, ;7=: ?9@ AB.ACD,FHI8

KL0 N-O1, "QSH6U V4A:"

+,-/1, 235791, ;9=: AB.ACD,?9@W?@

FHI8KL0 N-O1, "QSH6X"



110/143

M icrosoft Excel $**

()*+,* -#.,*

e8')^#7"h') _ Y(>$8 =!10$/2%p& K-1-!U%& =IF # -i!C: ,\/ O ' %& K-1-!UC% ,![ " (h4-2_T0=!1-!8

F& ,ddJO(,,![\/%& 4-[D& ,!U> uC: -iP+ B (ddd1Z-!U%&?5\:p-84-2_$ &0=W$#&5%& !G-"D&0-hMk0

X0 7#-/P%& W7 a/>& i -!U%& '>$%& ,i"W40&5d6& ,d!CX 9d+ p5d8 ?5dG&0 ?$d = P8 -idC!C ,x&@ K-1-!U%& ?5\:&0F(/W 5P/"D&","H&"' d%& K-d1-!U%-8 i -d!U%& 'd>$%& ) d8g -d!#-)CO

'>$%& 45./W J ! . 5P/"D& ,x&@ -iC[t %5.O -\CH -!#-)COZ 5P/"D& r K-1-!U%&s1-2+-8Q- 1LQ-d 1& 0& i -d!U%& '>$%& =8 * ? /% ,)/"+ 5P/"+'d>$%&&,dx&@ i -d!U%

5P/d"D& M dF1 ,dx&@ i -d!U%& 'd>$%&0 K-1-!U%& $i = O J ! . ="F1 5P/"D&'d>$%& Q-d 1& ,)/"+ 5P/"+ ,x&@ i -!U%&

^#7"h') _e8') i7E#) N)OS[

(.5W5S 5P/"+ > /A&*.4056& ,x&@ K-1-!U%& 4-x@L '/W

+.'>$%& c-2+ 5W5XZ-!U%&'!C./8 s%A0)]PD&y@5 j & %uCW -\H '>$C

,- ) W$_ 9+K&0@$ &!>-!)%& $)1& K-]!]a/%& k -.+ uC:



111/143

M icrosoft Excel $*$

()*+,* -#.,*

O $i = K-]!]a/%& k -.+ c&(P.8 c&(P.8 y& A-1

N)OS[ b9RY Z>8\ 10 _G@)%7>CD7 EFG2 HI"&JK7 L7>J5 M N$O'((. $)P%& I w@(\: ) !] l 92!%0 ) !]a/%& B (1 g-!/x& '/W F0$ & y(] 8&F-/%& ^-/F+ uC:

G-"+ ) !] lw$#&@ ) !] lu]x ) !] l

w@(\: ) !] l



112/143

M icrosoft Excel $*!

()*+,* -#.,*

*-y5\:T r "C"D& g-!/x& '/W)y(] 8& 'ng MNO c&(P.%& EG 7 1 -\H* C,( ^-/F+ uC: $)P%& I F-/%&.



113/143

M icrosoft Excel $*#

()*+,* -#.,*

+-c&(P:0 K-P!"%& g( D c&(P: 0 c&(P.%& 8-/H 0 ) ]aD& 5 !"PO '/W y& A-1 $i = OK&@-J%& g( D )y(] 8& 'ng MNO c&(P.%& EG 7 1 -\H+ C,(F-/%& ^-/F+ uC: $)P%& I .

,-yMx$ & y(] 8&)y(] 8& 'ng MNO c&(P.%& EG 7 1 -\H, C,(Q- < L ^-/F+ uC: $)P%& I.

c&(P:) ]aD&

c&(P:

ST",7 +>U7

c&(P: SVW#K7 +>U7



114/143

M icrosoft Excel $*%

()*+,* -#.,*

48B)+') WSxP) u)+xGe79 o5OQM') b. 2.7?G') 1&6 o5O7 i7%F)X+?' c"GM')88v'7\

6&XJK7 YZ'\]&^K7 +:;K7 YZ'

_`aYV7#K7 YZ'

+7cM') 73 R$X e)R

9: 8

b. K+F ^T0 t8H 24 }73F b- @ V) +>8@$ Kgn4 t$8H 7' 48E'; -"hS@ *7n.+8IX)+0()$ Z"3MG') b. >)+h') 1.+8E9 uO-Me $(9 7U) N7.7U)$ X+?')

_3-M@ ) 48E'):7&"#7&". _3a [ i798j4 _3a [ +>]G') _3a [ N7"#$%&') _3a [ *7Q0) _3a "`J1.c7 f.( gh;' L7 Ei j;YK7 gY*

,:W:#F"-,\.%&work bookBC+ ,\: $/A@ ,H ,[t 0 ,\.%& v&g0T 9+ @5: 9+ c(2/W s/1&(]>& uC: !%- 8& G-"D& pT -hQ- 1L sP2 " ' %& ,\.%& $O-A@ @5: 5 : p 0 5G&0

:(P/D& v&g0p& 9+ MUH @5: Cx&58 *\ d c& ,\.%& $/A5% 92t 0 UCJ%&.



115/143

M icrosoft Excel $*&

()*+,* -#.,*

& '&k: ,\.%& ng0:5G&(%& ,\.%& $/A@ w(/ :y$H&& %& .> b"G v&g0$ & 9+ ?@5X @5: w& uC: sU>-G r.

ng0 r '"n ,H s%A 0 Y-"n$ & *! Y uC: w(/ : I 5G&0 ,\: $/A@ ,\.1 c& 92t s%A uC:05./O p ' G ,\:@!Op& )W$]%-8 s%A '/W 0 K-FCD&:-

(.'>-8 BCD& EF `) ,\.%& $/A@work book ( 7 [+ 92!% 0H$_c-tp&.*.ng0 uC: $)P%-8 s%A 0 Y-"n$ & @5.8 ,\: vg0 B! ? 1+I @0-\C% 9tp& gR%-8)|&g@&.(+.`Ja/%-8 ng0 ,2% !\"/%& y@-:o8 'n.

t,2 %& &&9 BC+ -1 1T 5n c(21 s%A uC:0.



116/143

M icrosoft Excel $*'

()*+,* -#.,*

t":-2!1-2!D&

'"n

K-1-!8

)y5G&0

K&(] 8&0

& !FP/%&

c&

= G 7 +

*+*!\6 Y- 8& 0& g-!N%& *]n B (1 BC/ H ) )A K-JJa/%&(

T- Q- 1o8 T5UPA) g-!N%& *]n0 2Ci/"D& K-+- 8& 405S(X-/%& ,2 %& 7/P!A:# #

!%-/%& K&(] 8& *U/1 ,2 %-8 s+-+T m %& )W$]%-8 5 8-"%& 4056& Q- 13

78& n 4056& n y@(S(D& K-1-!U%& b/21' dG =d!%-: ,2d %-8 -d\H Id~(D& -W ^$ %& n (h -\H !8-"j& K&(] 8& & FPO cT *!]/"O.

X-/%& ,2 %& 7/P!A ) )A K-1-!U%& b/21

$%&'( #)*+"#,-./012 #3%4%5 #6"78#9%:;#?&1@



117/143

M icrosoft Excel $*(

()*+,* -#.,*

t-W 78& 7+5%)A8, B8, C8, D8, E8, F8, G8(5 !"PO \#-n > /F1 I -W 78& ?& h uC: 'C.1 )Format(-W 7 x $+T g-/ L I)Cells(-W 7 x 5 !"PO g&(j& *8$D& 7/P!A)Format Cells(-\H

X-/%& ,2 %-8

y&A- j & bW(UO =P+ g-/ L)Alignment(`P%-8 '2I/%& '")%& Z X I)Text control(5 e -W 7 x 7+@ Mx$ & g-!/xp& -iP+ g-/ L K&g-!/x& < 7


118/143

M icrosoft Excel $*

()*+,* -#.,*

-W 78& 7+@& )8-"%& K&(] 8& M FP8 I)A16, B16, C16, D16, E16('


119/143

M icrosoft Excel $*)

()*+,* -#.,*

#F+$#GHIJK#LM4#$%0NNumberP,QR( #F1S( #TU#FVCategoryP $%&0W#,VXV#7Y#Z7H7[#$I1@#$%&0W\ #%/M4#$%0NFractionP]'^;#FV#_&1M0( #?-C#)>B2 #`#B/a&b#L&.[#F.=;OK

5dW$1 y5dG(%& $.d> d!Cx Z dX m %& -W 78& g FA -i!A C\.%& 8-/H 5W$1 m %& -W 78& n ,\.%& -dW 78& ?& dh udC: 'dC.1 9\[d%& 9d: fd.O Y-ngT *~0)D11, D12, D13, D14(-n > /dF10d\#

5 !"PO)Format(

$+T g-/ L

I

)Cells( g&(j&

*8$D&

7/P!A

)Format Cells(>%1( #?-:(%>#%c@# 'dng bW(UO =P+ g-/ L) Number ( d o F%& 'd")%& Z dX I)Category (K&g-d!/x& d< 7 < 5d e

Cddd\.%& g-d!/xp& -iddP+ g-/ L y5W5:)Currency( dddJ+ =d!PS =d1T 5dH/10 =d!C: 'dC.1 $d W$d .%& 4{-dPD& d\CH g0-d U& *8$D& n $i = !A)Decimal place (Y-dng p % 5 !d"P/%& ,2d_

'n$%& =8 c(2W W$ .%&)+(=C.S&)*() N ? 1 I =1T 5H/1)OK (X-/%& ,2 %-8 -\H:

# ## #

# # /"+ K-+-x !Cx Z X m %& -W 78& g FA -i!A C\.%& 8-/H 5W$1 m %& -W 78& n ,\.%&5W$1 2Ci

-W 78& ?& h uC: 'C.1 9\[%& 9: f.O Y-ngT *~0)E11, E12, E13, E14, E15(\#-n > /F10 5 !"PO)Format(-W 7 x $+T g-/ L I)Cells(-8 7 x 5 !"PO g&(j& *8$D& 7/P!A)Format Cells(-\H

5 8-"%& ,2 %-8 'ng bW(UO =P+ g-/ L) Number (d o F%& 'd")%& Z dX I)Category(K&g-d!/x& d< 7 < 5d e

g-!/xp& -iP+ g-/ L y5W5:)Currency(n $di = !A $dJ+ =d!PS =d1T 5dH/10 =d!C: 'C.1 \CH g0- U& *8$D&)Decimal place('n$d%& =d8 c(d2W W$d .%& Y-ng p % 5 !"P/%& ,2_)+(

=C.S&)*() N ? 1 I =1T 5H/1)OK (5 8-"%& ,2 %-8 -\H.



120/143

M icrosoft Excel $$*

()*+,* -#.,*

& -W 78& n ,\.%&*d~0 5dW$1 g-!N%& *]n !Cx Z X m %& -W 78& g FA -i!A C\.%& 8-/H 5W$1 m % -dW 78& ?& dh udC: 'dC.1 9\[d%& 9d: fd.O Y-ngT)F11, F12, F13, F14, F15, F16( d\#-n > /dF10

)Format( $+T g-/ L I)Cells( g&(j& *8$D& 7/P!A)Format Cells(5 8-"%& ,2 %-8 -\H g-/ L 'ng bW(UO =P+) Number ('")%& Z X I)Category(y5W5: K&g-!/x& < 7 < 5 e

g-!/xp&

-iP+

g-/ L

)Currency( g0- U&

*8$D&

n

$i = !A

$J+

=!PS

=1T

5H/10

=!C:

'C.1 \CH)Decimal place('n$%& =8 c(2W W$ .%& Y-ng p % 5 !"P/%& ,2_)+(=C.S&)*(

) N ? 1 I =1T 5H/1)OK (5 8-"%& ,2 %-8 -\H9W@(\.%& Z X I~(D& -W 78& n Y-ng$ & *~0 n T5U1)C(!\2%)D(y5G(%& $.>

&!C 8& n)E11(K-8-"j& !C\: T5U1& ,\.%0 !\2%& n y5G(%& $.> z$~ , # -G (h0 2Ci/"D& K-+- 8& 9 q z-"G 5W$1

!C 8& n B)1 s%A)E11(!%-/%& N!J%& b/2O0 =D11*C11 I X-/%& ,2 %-8 -\H ) N ? 1)Enter (

g ~-D& Y-.%& n -P\C.O -\H g CF"%& $"W$ & 9H$%& 9+ ,F> p % !C 8& bI"1 I.z-"G 7/P!A ' G -W 78& z-"G -1@gT -P1T EGp0 X-/%& ,2 %-8 -\H -W 78& *! Y)E13() )A.

W$]%& M FP8!C 8& n 92% g-!N%& *]n 9 q z-"G 5W$1 ) )F14(y5:-"e -h& FPO cT 40-G s\C.+. &!C 8& n)E15( 2Ci/"D& K-+- 8& 9 q X- Y L z-"G !C\: T5U1&

s\C.+ y5:-"e -h& FPO cT 40-G )8-"%& )W$]%& M FP8. &,&.5 #`F16P#$%&'( #)*+#de#f(%g


121/143

M icrosoft Excel $$$

()*+,* -#.,*

# # -!1--8)y5W56& Q&RS$ &0 K-+- 8& 405S(X-/%& ,2 %& 7/P!A

& K-1-!U%& b/21& FPO cT *!]/"O ' G =!%-: ,2 %-8 -\H I~(D& -W 78& n 4056& n y@(S(D^$ %& n (h -\H !8-"j& K&(] 8&

5 8-"%& 4-[D& r -\H K&(] 8& ,\2/>&)*!\6 y5G&0 K&(] 8&0 & !FP/%& c& = G 7 + *+ / H ) )A K-JJa/%&Y- 8& 0& g-!N%& *]n B (1 BC (

M dF1 *dU/1 0 K-dP!H-+ g-!k *]n 0& K-+-x Y5a/"1 Y-"np& un-U% U"P%-8 K&(dd] 8&(0& yg(O-ddA w& r +5a/dd"D& !8-dd"j& K-dd!C\.%& c& dd = G 7 + *dd+

uh K-!C\.%& bCk& c(2O K-+-x 0& "W-)+)*\6& ( 0)z$ ? %&( d2% 0-15dJn 9 l>m1/

/&n



122/143

M icrosoft Excel $$!

()*+,* -#.,*

=O-!1-2+L 0 b>-j& Y&5a/>& uC: -PW5WT zg51 c& M!dNO r 5 dj& s\C.D c& -\H`Ja/%& b"G y@(S(D& K-1-!U%&.

%&Z2&Tc7 g).K T YCB 1)5 %&Y2+;B)opqFK7 EZ$( &r a5>s>t u&)Fn,7 L>G V jdv7 7In M:

(.405S F& 0& "W-)D& ,)1)K-+- 8& C g(S$ & C %&!#-iP%& B!%-2/ -....r &(uh -\H. *.,"H$ & 7+-1$8 n +5a/"D& [email protected]& 5 !U]O !F!H.

$ 0&:40&56& ,)1 bWg5O)(: (c&(P.%& M FP8 (h -\H uOp& 4056& ,)1&

)"W-)+ ,\: K&(]x 40&5S(

X-/%& | A(\P%& r , 2 "O - < oA - 9 # - 8& 6 1&()%-8 y5G ,H K-+- 8& z-"G 5.8: K-+- 8& 405S

YBPJ%& '>&y5G(%&!\2%&y5G(%& $.>y5G(%& 9 qK- = G 7 + s $n=!PSs $n=!PS

(O.Y&$S* $/++@5:,t $A /F%

K-dd+-dd 8& 9 q Cddd Y

bWg5O)*: (c&(P.%& M FP8 (h -\H uK & 4056& ,)1& w/x 9:;< AyFK7 H+:-

9&).K7 +>Ch g 13 9:;< :7

Y!C\.%& B (1yg-iD& Sg@& !FP/%& 9+{:-"%-8 $Sp& $Sp& C YK- = G 7 + B B .Yv@s $n=!PSs $n=!PS

(,+-: B *



123/143

M icrosoft Excel $$#

()*+,* -#.,*

+B . $+-: Y $h-+

,4-\.%& g(dddddS& B (\ \

bWg5O)+: (c&(P.%& M FP8 (h -\H uK & 4056& ,)1&

z&eJK7 0 K&GFK7 9:;<

u#pK7 L& (|1GFK7 }$O/ ~


124/143

M icrosoft Excel $$%

()*+,* -#.,*

4-[+)((]!"8 %@-.+ N!J% ) !"8 )* +/ (

= 2 + 5

9&^/)( 2>)c7 EZJK7`\` X`%

g*7:+ 7 .8 T5U1 I !C 8& g-!/x& '/W(= )'n$%& I)(S/S( %& IU"P (%)I)(

9&^/)( +:Iv7 : + V,7

6 /)W$]8 -i!C: 4(Jj& 92t 0 M >p& 0 g& S @(S 0 %@-.D& ?& h r EG 7 1:

F0p& )W$]%&:%@-.D& 8-/H 0 > !O-FD& G(% 5 W$V 9: y$_-U+ 8-/2%&

!1-[%& )W$]%&:4&05%& 9+fx

C"D/( ;%GE( \F]U%( .+X"Y%( \F]U%(CGE( `4%( C"D/(

.?>"Y%( \F]U%( %"Y%( \F]U%(.Y >"Y%( `4%( C"D/(

5"&U>aE(power Q"Y$Y+G Q"?J"35 K+

"b ( &e>



125/143


126/143

M icrosoft Excel $$'

()*+,* -#.,*

(7#K7 - &YK7 S15 1)VW

"#$"% &'("% )*+%ICDL:

CGE( C(tv%(:

w-.xM0&%( yM#+ cRb 8=


127/143

M icrosoft Excel $$(

()*+,* -#.,*



128/143

!"#$ &"'($

"#"$%&' ()*"+ ,-"#./ MICROSOFT ACCESS

00-"2' 3"%&' "4567 !"!#$%& '#&()%& *+ ,+-./%&0 1+-23%& 4/5 !6!7.-!2-8 9#-:;/&;/+& 5$.+0 ;?/"@& A6B !6!7C'!DEF G -H.I00 JK-5 L-2-!M N;:-O ,D: !6!7.,D: !6!7)P0&;Q R&L-+S./< RTU-V R $WK-)F(6X/Y@& L-EEY/X% L-2-!M N;:-)% Z)![\F P-]+.



129/143

!

!"#$% '(%

9-):-

^_-+L-2-![%& ;:&(OData base: )W$` a+ $]7bM 0c )W$\M -HI$:0 L-2-![%& 0c L-+(X.@& a+ Nd[7 !De% *!Df Z_

-H?+ N>-6/j Lg-EF&)>K&00 K>- -. (

.-L& ((}B0 L-W$6< % F-e+. /-Wd 0 \u2c0 L-50$E+0 L-:3F ,!}"F.

x1-!F( - L-[/e+ & K-H5)!F( - `${c(

;:&()%& =w_ L&m! 2 a+: x->&;/+g& w 0bW ;B&0 3 X+ * N;:-)%& L-?#-7 *! 4 * 4MDB * ,H


130/143

"

!"#$% '(%

5c HQ a+ N;:-)%& ^X: NK(\ 0 ,]h ;O 5-7 5 j0 N;:-)%& *+ ,+-./%& 3 X/W 3 X@& &w_ 3 XF N;:-)%& L-?#-7 ,7 9.+.

~- 1+&$M0 ;:&(O 6 j 0c o507 & :(D 8 1+&$M 6 j L-2-![%& a+ 6X/ 9 : &(2c $W;EF0 >&d/


131/143

#

!"#$% '(%

t1+-23%& ^X: $)?%& )Microsoft Access

" #$ %&' ( ) *"+ 4/r5 0c L&0>7 & K W$r{ ar+ ;rW;Q K ( K< rI A rW$` a: -+j N;W;Q L-2-!M N;:-O 3 X+ t-u2j aeh

ZB-/6+ K< I 0c ;W;Q $+7 & K-!/ 0& O 3 X+ D#-OCtrl+n

%&'(12. 34"45).6 37'8.6 92: ;)-./7 & K W${y;Y/r"F I r%& K&K (7 & ar+ r:(D 8 ^X: ; (/ Q Pw%&



132/143

$

!"#$% '(%

S l[%& 50;M N${-[+ $+&07 & w!6?/%'#&(r)%& K W$r{ * $+&07 & a:.;rQ(F 1+-r23%& Nwr5-2 , 0&;rM0 'r&;/+& 5$.+0 3 X+ A6B !6!7 ) :db1.mdb( A XJ >$} VT-r/ G q%wr% -Hr/X 0>c R r%& L-r2-![%& ,r7 *!r B F W $rHe%& K-!/%& : -\)2& 0& $F(![De%&

P0bM g0c q%-D:c A6 E .>$6?F0ACCESS>$r} V L-r2-![%& N;r:-O Ar6B z(rE X [! Nm! V

-H/!D"F. y()F - B W& 0ACCESSqrXD: Ar6 E Q-B G p"X5 q%w% ,}"%& A6 Y -!#-)XF A XJ ;W$F -+;?: g&qF-2-!M N;:-O .

,r 0&> P&) r"%& $rH H W L&d!r < /%& A6B G % J$F 0 L-2-![%& N;:-O G LSW;.F ; & ; $f -+;?: S]D5 K-!/ 0& '/W 0 6-/%& ; K&(B *M$+)'.2 (0 ,W;./%& P([O %-B G)g (t- < %v& %-B G

9/!D"F0 L-2-![%& P0;Q A6B -6 - &(+ P- 0>& P-D/7& ;.Mqr?eD!% ^r"!`-? < @& z$r)%& ^rX: 9 H 6B %Z L-2-![%& P0;Q L

;r.M -D!5 9.+ ,+-./%&C&;rW;Q g0;rQ 4/r6F -+;r?:C4Dr"F R r%& P0;r ?& J $r: Nwr5-2 $rH H F ;W; ?& P0; ?& '!DE/MC> EnACCESS'r 0U 'r


133/143

%

!"#$% '(%

a: ;WmW g - V 9!M$.%& 0c 9!?!F7 & @0$ E-M '< 7 & 5(eW 5c aeh'! $B-51 9!%- 0 95-" V P0; ?& ' P0; ?& '


134/143

23

!"#$% '(%

*,rrr)/"+ 3 rX+ G P0;rrQ ,r7 Arr6 QCN;rr:-O $r - -?: ar+ $rrE?: ,r7 Arr6 Q0G $rrW$r)/%& S]+ ,rr)r/"+ 3 X+ G ; $r 07 & L-2-![%&3 rrX+ G TU(rD?%&0 3 X+.

&wrre_0. rr:-O G -+cL-2-![%& N; ACCESSR r%& ; $r 0g& $r - -?.%& *! 4 0 qF-2-!M 5-5 TU-rD?%& 0 $WK-r)/%&0 L-r2-!M P0;rQ S]+ ;B&0 3 rX+ G Ar6 G L-2-![%& N;r:-O G -HQ-/ G

K(E%&0

P-e{7 &0

^ &C

L-2-!M N;:-O 4/5: L-2-!M N;:-O 4/6%:

x-3 X+ D#-O a+ ~-4/5 K-/ _-T0>m+ $)2 &0-@-M $)2&

9l/5 >&$@&

3 X@&

^X:

vL-2-!M N;:-O ,D: !6!7:

+ /)W$\M L-2-!M N;:-O t-u2& aeh: v-W0;W -HQ-/l/< R %& $WK-)/%&0 P0&; ?& t-u2& O JK-5 L-2-!M N;:-O. vTU-rD?%&0 P0&;r ?& t-ru2-M qr?: rM-!2 y()W S !B ` -.@& y&;Y/


135/143

2

!"#$% '(%

TU-D?%&- $WK-)/%&( t "# $%&'())*+,-.( /01(

t ( $r)2 0c L-2-![%& N;:-O Nw5-2 , 0&> a+ -H!X: T0>m@& $)?%-M q%U0 '!DE/%& J $: )W$` K );W;Q P0;Q t-u2j( Nwr5-2 4/r6/5 L-r2-![%& N;r:-)M z-r T& L&0>7 & K W$r{ a+);rW;Q P0;rQ(

$/ 0& -H?+0) '!DE/%& J $: O$`((r_ -rD7 '!DrE/%& J $: {-{ 4/5 '/!5 A 5&(+ $)2 O P- 0> a % P()B 8S8 ^X: P(/ G - MN 5 P $F -D70 A M-"%& ,eu%-M 4I(+:

x- ,) E& '


136/143

22

!"#$% '(%

-3- (%& 2- 0 *:aeD!5 P0; ?& ,D: * q%U $8) W g0 ,)lX% 3- 0 5-Ij q?eh j y;:4/5 '/!5 L&0>7 & K W${ a+ A6B K ( k(5 $)2& P() E& P- 0>j a+ t-H/2g& ;.M0 9Q&K>

Nw5-2 $H H /5 A 5&(+ K ( ^X: $)?2 O P0;}X% U-|& % /e?5 P0; ?& '(Q0 y;:Access* D!)%& o6?M + X}< t-u2 N M 4D"W g Z7 & K W${ a+ '!DEF K ( ^X: $)?%&

L&0>7 & K W${ a+ 4/5 K ( ^X: $)?%& ("2( 341 506 7%*4+1:-

789:.( ;< %=-'>(:- M LS}"%& + M ,)?/%& aeh&0-@& KmM N;B&0 N$)2 ,}< Pc k(5 $)?%-

z-r T& 'O$r%& -r_K&( c0 P0; ?& Nw5-2 ,6; d& ,}"%-M.'O$r%& arh ^rX: 'Hr"%& $r)2 A rW$` ar: $ 0[ ,}< a+ P-)/2g& aeh S !B

2S% =K-"W

^X:

0c

A M-"%& ,}"%&

6 j P-)/2S%N$r{-[+

P-r)/2g&

aeh

-D7

e-/%& ,}"%&

6 j P-)/ ,}r"%& 6 j P-)/2g& - B Wc q%w70 'O$%& ah ^X: f -]%& 'H"%& $)?M D#-)%& a+ P07 & ,}"%& 6 j

k(r5 $r)?%& A rW$` ar: ;rW;Q ,}r< 4/r5 - B Wc aeh0 'O$%& K-"W ^X: f -]%& 'H"%& $)?M d 07 && >(Q(M m!D/W0 K-"!%& 6 j d 07 & 'H"%&+S.%(*),r)?/%& areh -rD7 ,rM-)@& ,eu%-M -D7 =K&( c

D#-O 4/5 \


137/143

24

!"#$% '(%

x-89:.( ?@ A 0B@A A ?9C "D"E:- }r"%& ;W; G aeh*rM$@& ^rX: $r)?%& A rW$` ar: , LS}r"%& P0c ^rX: K< r B %-M ,}r< ar+ S 7c ;W; G aeh -D7 ,}< ,7 K-"W ^X: >(Q(@& (rX\@& dr 07 & ,}"%& 6 j &0-@& KmM P( - (%& R B K(rQ0 ar+ ;rM g -r?_0 r6X/ 9 L&K-r! 0 .r"F -_>;r:0

pr2c =K-r/n Pw%& TU(D?%& t-u2 N M y()!% L-2-!M K;E+ 3 ! B F 5c % X\!< ` -.@& 5g TU(D?X% )W$\%& =w_ 0 : ,W;./%& aeh0 + #;/[DX% , B 5cpO0 Pc * 9#-u2 N M pDO TU(V Pc ZX .

TU-V ^X: $)2&

2



138/143

25

!"#$% '(%

p+ /)W$\M =K-!/ 0& aeh0 TU-D?%& ` -.+:

x-2()Wc A W$` a: -+j^X:7 -M N>(Q(@& ;W;Q9?+ =K-!/ 0&0 ;W;Q TU(V K&(B *M$+ K-Hij0 ~-2()W7 & a+ =K-/n 0cTU-D?%& Nw5-2 * ^X: N>(Q(@&!%-/%& NK-[.%& -H[2- c0)t-u2j

y&;Y/(rD: R60;rQ RrOK0 RK [I(

yS./&$@

,D: >&$@& P() E& K-/ _9% P()B

60;Q TU(V PDF created with FinePrint pdfFactory Pro trial version www.pdffactory.com


139/143

2!

!"#$% '(%

K-/Y?(D * -D7,eu%& &w_5[ &0 (_ -D7 97$Fb< TU(D?%& !6X 00 5(X%& ,e{ Pc TU(D?%& K V K-!/ 0-M % %-\W ` -.@& 5c ;}?; d& P() E& D#-O 6 j D#-)%& a+ >; d& K;E@& P()B Km+ $)2(,)2 e -/%& ,eu%& + [W -?_0

4!lE%& - M-e+ * P() E&. vL-W(/"+ L&K-! 0 Z_0 !%-/%& N(\YX% P-)/2S% e -/%& \ -/6+ ^X: K(.?(D: l6EX% L&K-! 00

cU-rrrr!)5=-rrrrf& q%wrrrr70 l6rrE%&-rrD7 -H7$/?rr< e -/%& ,eu%& * Z_

TC=[P'( ]#^ /^*_='( S*?I(



142/143

2$

!"#$% '(%

v> ?r%& P(r)B0 $rW$)/%& ,er{ Pc $rW$)/%& K rV K-r!/ 0& Zr_0 !%-/%& N(\YX% P-)/2g& ;.M ,eru%& &wr_ * N>(rQ(@& P-er{7 & ar+ 5(X%&0,r)/?20 (r_ -rD7 K D?r%& K-r!/ 0& j $/?r

tech3 sec1 computer s

Documents