LESSON PLAN.doc

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

Week No.: Time :

1

Lesson no. :

1

Title: History o Com!"ters # $eneration O Com!"ter  Objectie!:  Blas% Pascal and &is 'ec&anical calc"lator  C&arles Ba(( a)e: dierential en)ine  *irst $eneration  +econd $eneration  T&ird $eneration  *o"r $eneration Aid!: C&alk, D"ster, Black Board, Pointer. Pre"arati#$: -eie: A(acas seems to it& t&e earliest calc"lation mac&ine, &ic& as deelo!ed (y C&inese 0 years a)o. Until 123 t&e ma4or contri("tion ere rom t&e "niersity and researc& instit"tion. Almost all t&e letter deelo!ment d"e to t&e com!"ter man"act"rin). I$tr#ducti#$:  T&e irst mec&anical calc"lation mac&ine as made in 1567 (y t&e )reat *renc& mat"matan and !&iloso!&er Blas% Pascal. *rom t&e early 1238s com!"ter started a!!earin) in 9"ick s"ccession, eac& claimin) an im!roement oer t&e ot&er. T&ey re!resented im!roement in s!eed memory stora)e; systems in!"t and o"t!"t deices and !ro)rammin) tec&ni9"e T&ey also s&oed a cont. -ed"ction in !&ysical sin >n)l )lis is& & mat& mat&em emat atic ical al slate slatess &ain) &ain) a(ac" a(ac"ss rin) rin) deelo!ed deelo!ed mec&anical mec&anical calc"latin) calc"latin) deices called  (alls !ierced in steel rods dierence en)ine or a"tomatic com!o ration o  as i it is som some !lay !layin in) ) mat&em mat&ematic atical al ta(les ta(les aro"nd aro"nd 1?0. 1?0. Ba((a)e Ba((a)e as o(4ect or (a(ies ("t cant also inoled in t&e desi)n o anot&er calc"latin) si)ni si)niy y t&e im!or im!orta tance nce o  mac&i ac&ine ne &ic &ic& & co"l co"ld d !er !eror orm m many many )ene )enera rall its. "nction in an a"tomatically ater m"c& aord, &e corralled a mac&ine called analytical en)ine. T&is mac&ine &ad a memory deice and arit&metical deice, a !"nc& card in!"t system and an e@tended memory memory store. store. T&"s T&"s Ba((a)e Ba((a)e analyt analytical ical en)ine en)ine &ad many o t&e same "ndamental 4ealo"s as t&e modern com!"ters.

*irst $eneration

+econd $eneration

T&ird $eneration $eneration

*ort *ort& & $ene $enera rati tion on

*it *it& & $ener enerat atio ion n

Com!"ter deelo!ed ater >N=AC &ae (een classiied into t&e olloin) or )eneration *irst $eneration 1265 to 1233 +econd $eneration 1235 to 1253 T&ird $eneration  1255 to 123 *o"r $eneration  125 to !resent T&e 1st $eneration com!"ter t&ose t&at in ac""m *rom 1265 eac& decade t"(es are "sed. 'a)netic ta! drie and ma)netic &as contri("ted one core memory ere deelo!ed d"rin) t&is !eriod. )eneration o com!"ter. nd T&e 7  )eneration com!"ters ere market (y t&e "se o t&e +olid +tate deice called t&e transistor in t&e !lace o ac""m t"(e. All in more relia(le t&an earlier co"nter !arts. Alon) it& t&e t&ird )eneration )eneration com!"ters com!"ters neer  and and ast aster er e9"i e9"i!m !men ents ts &er &eree intr introd od"c "cee or  or  &and &andli lin) n) stor stora) a)ee and and in!" in!"tt o"t! o"t!"t "t cont contin in"e "ed d eo eort rtss toa toard rdss minia iniat" t"ri ri
)ue!ti#$:  List t&e s!ecial eat"res o Ba((a)e Analytical en)ine.  Ho do yo" t&ey com!are it& t&e modern com!"tersF  Classiy t&e )eneration o com!"ters.  W&at is t&e main dierence (eteen dierent )eneration com!"tersF Su''ar*: Ba((a)e in conceded one o t&e )reat !erorms in t&e trade o com!action or t&is oresi)&t to desi)n t&e analytical en)ine. T&e deelo!ments o t&e com!"ters are closely associated it& t&e deelo!ment in mec&anical tec&nolo)y, !artic"larly t&e semi cond"ctor tec&nolo)y. A""licati#$: No days t&ere are t&e most idely "sed mac&ine, ed"cation, B"siness, Comm"nication, Personal, and *"n. +"c& system o"ld inte)rate t&e adanta)e in t&e (ot& &ard ere and sot ere tec&nolo)y and o"ld acility com!"ter added !ro(lems sloin) it& t&e &el! o or)ani+  B $onindara4al". '=C-OP-OC>++O-+  -. $aonkar.  =NT-ODUCT=ON TO '=C-OP-OC>++O-+ Ne+t Le!!#$:  *"nction o Com!"ter.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

Week No.: Time :

1

Lesson no. :

,

Title: *"nction O Com!"ter.  =n!"t, O"t!"t, ALU, Control Unit, 'emory; # A!!lication o Com!"ter  Objectie!:  =ntrod"ction  Deelo!ment  Com!onents  A!!lication  >)oernance A!!lication  Commercial a!!lication "se like railay reseration, tele!&one (illin) etc. Aid!: C&alk, D"ster, Black Board, Pointer. Pre"arati#$: T&e a!!lications o com!onents are so ide t&at t&ey ill (e !layin) ary im!ortant rots and "t"re lie o man to reliee &im rom many !&ysical and mental (an dens. T&e com!lain does eeryt&in) as !er t&e instr"ctions )ien (y t&e !ro)rammer in &is !ro)ram. =t cannot t&ink o its on like &"man (ein). I$tr#ducti#$: T&e irst mec&anical calc"lation mac&ine as made in 1567 (y t&e )reat *renc& mat"matan and  !&iloso!&er Blas% Pascal Pasc al !res. %#tiati#$: Beore "se o com!"ter all ork as done (y !a!er and it as ery len)t&y !rocess to do and ater "se o com!"ter in ario"s a!!lication !a!er is ork is red"ced and ork is (ecome ery ast. Pre!e$tati#$: T#"ic! I$&#r'ati#$ P#i$t! S"#t (i$t! =n!"t "nit memory BLOCG D=A$-A' O* "nit ALU CO'PUT>-  ALU Control "nit =n!"t "nit: T&e !"r!ose o t&e in!"t O"t!"t "nit "nit is to acce!t t&e in!"t data &ic& is re9"ired to store t&e !ro(lems =/P O/P CU 'emory "nit: t&e memory "nit retains t&e sli!s or sol"tion and initial in!"t data, t&e intermediate '>'O- and inal res"lts. Arit&metic "nit: t&e arit&metic "nit  !er orms all mat&ematical com!"tation a!on receiin) instr"ction rom control "nit. Control "nit: T&is "nit !erorms t&e most ital "nction in t&e com!"ter. =t act"al all t&is "nit and controls t&e data lo (eteen t&em to sole t&e  !ro(lem. O"t!"t "nits: T&e o"t!"t "nit acce!ts t&e inal res"lt and translates t&em rom mac&ine code to t&e reada(le rom.

Com!"ter  A!!lication in railay reseration

>lectricity

P&one Billin)

Com!"ter controlled seat reseration  (rin) (eneit to c"stomers. c"s tomers. T&is is ac&ieed (y "sin) com!"ter netorks.

=t saes yo"r al"a(le time.

>lectricity (illin) (y maintainin) t&e list o all t&e "ser name, connection n"m(er, n"m(er o "nits and t&e amo"nt to (e  !aid.

o" can een )et t&e stat"s "!date.

Com!"teri
T&e inormation is aaila(le at any&ere and anytime  !roided yo" &ae access a ccess to internet.

)ue!ti#$: +t"dy t&e "nction o eac& "nit o com!"ter. >@!lain Iario"s Iario"s a!!lication a!!licatio n o com!"ter. Ho to "se o com!"ter in > )oernanceF Su''ar*: T&e com!lain does eeryt&in) as !er t&e instr"ctions )ien (y t&e !ro)rammer in &is !ro)rammer. =t cannot t&ink o its on like &"man (ein). A""licati#$: All lar)e ("siness are com!lain or calc"latin) !ay r"les (illin) and !rocessin) inentories Re&ere$ce: Ne+t Le!!#$: =ntrod"ction to ario"s !rocessor # com!"ter Lan)"a)es

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

Week No.: Time :

,

Lesson no. :

-

Title: =ntrod"ction to ario"s !rocessor # com!"ter Lan)"a)es Objectie!:  'icro Com!"ter   'ini Com!"ter   'ainrame Com!"ter   +"!er Com!"ter  Aid!: C&alk d"ster  Pre"arati#$: Com!"ters are a(oe aaila(le in dierent si
+"!er Com!"ter

Pro)ram:

'ac& ac&ine lan)" an)"aa)e :

Assem(ly lan)"a)e:

T&ese &ae e@tremely lar)e stora)e ca!acity and co"ntin) s!eed, &ic& are are at leas leastt 1 tim times ast aster er t&an t&an ot&ers com!"ters. W&ile t&e s!eed o traditional com!"ters in meas"re meas"red d in terms o million millionss o  instr"ction !er second '=P+;, A s"!er Com!"ter is rated in terms o  'ill 'illio ion n o o!era o!erati tion on !er second second 'OP+;: An o!eration is made o  "! n"mero"s instr"ction. +e9"ence o instr"ction to !erorm any task is called !ro)ram. T&e lan)"a)e , &ic& can "nderstand (y com!"ter is knon as !ro)rammin) lan)"a)e. T&ere are 0 ty!es o !ro)rammin) lan)"a)e. 1; 'ac&ine lan)"a)e 7; Assem(ly lan)"a)e 0; Hi)&er leel lan)"a)e Com!"t !"ter orks on (in (inary !"lse "lsess. Hence, it can (e "nderstood only in  !"lses. Pro)ram ritten in (inary code is called mac&ine lan)"a)e. =nstr"ctions ritten in mac&ine lan)"a)e is not easy to remem(er. We can easily remem(er t&e sym(ols instead o n"m(ers or code. Assem(ly lan)"a)e "ses mnemonics mnemonics  sym(ols; to re!resent any instr"ction. Assem(ly or sym(olic lan)"a)e re9"ires JTranslator , &ic& translate assem(ly lan)"a)e !ro)ram into mac&ine lan)"a)e. 'ac&ine # Assem(ly lan)"a)e, (ot& are mac&ine &ine ori oriente nted lan)"a )"a)e. )e. Pro)ram deelo!ment in t&is lan)"a)e is ery tedio"s.

Ty!ically t&e s"!er com!"ter is "sed or lar)e scale n"merical !ro(lems in scientiic and en)ineerin) disci!line

Hi)&er Leel Lan)"a)e:

Hi)&er leel lan)"a)es "ses sim!le >n)lis& ords, in &ic& command in  !artic"lar ormat are "sed "s ed to !erorm some instr"ction or ork. T&is lan)"a)e is "ser oriented. As ritin) !ro)ram in mac&ine lan)"a)e  (ein) tedio"s, it !"ts o rite in >n)lis& like ords &ic& is easy # conenient, cons"min) less time it& minim"m error. T&en t&is >n)lis& ty!e command is conerted into mac&ine lan)"a)e (y  !artic"lar !ro)ram. *or eac& Hi)& leel Lan)"a)e t&at may (e a Com!iler  or =nter!reter.

)ue!ti#$: Classiy t&e Com!"ter accordin) to t&e t&eir s!eed and stora)e ca!acity 1; W&at do yo" mean (y J'ac&ine lan)"a)eF 7; W&y H.L.L. is re9"iredF 0; *"nction o Translator. 6; Dierence (eteen Com!iler and =nter!reter. Su''ar*: Com!"ters are classiied accordin) to t&eir tec&nolo)y and e@treme "se o its !"r!ose. A""licati#$: A!!lication o eac& com!"ter aries rom ("siness to ("siness and it s !otential ca!acity o !rocessin). A!!lication in t&e electronic, !etrole"m en)ineerin) Weat&er or castin) str"ct"ral analysis c&emistry, medicine and !&ysics. Ne+t Le!!#$: =n!"t / O"t!"t deice # t&eir *eat"res

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ec O(4ecti tie e

:

Unit/Block No.: Date:

Week No.: Time :

,

Lesson no. :

/

=n!"t / O"t!"t deice # t&eir *eat"res 1; Onlin Onlinee in!"t in!"t deic deice, e, Gey( Gey(oar oard d , 'o 'o"se "se,, +cann +canner er , li)&t li)&t Pen Pen >tc >tc 7; IDU ,LCD ,ario"s ty!es o !rinter 

Aids Aids : 'ark 'arker er,, W&it W&itee Boar Board d ,D"s ,D"ste terr ,Com ,Com!" !"te terr ,Pro ,Pro4e 4ect ctor or Pre!aration : K -eie : Iario"s A!!lication A!!lication O Com!"ter Com!"ter # Iario"s *"nction *"nction O Com!"ter K =ntr =ntrod od"c "cti tion on : ari ario" o"ss in!" in!"tt # O"t! O"t!"t "t inormation rom system. 'otiation : Presentation : To!ics

dei deice cess are are "sed "sed to )ie )ie data data to syste system m # to )et

+!ot &ints / "estion Ask;

=normation Points Tell

=n!"t deice

=n!" =n!"tt dei deice cess are are "sed "sed to enter enter o"tside orld into !rimary stora)e.

Gey(oard deices

Allo Allo data entry entry into into a com!"t com!"ter er syste system m (y 11 keys keys W>W>-T T key  !ressin) a set o keys  (oard is most !o!"lar.

'o"se

Used to ra!idly !oint to and select a )ra!&ic icon icon or men" en" item item rom rom m"lti "lti!l !lee o!ti o!tion onss 'ost ost !o!" !o!"la larr !oin !ointt and and dis!layed on $U= o a screen. dra deice. +tored ima)e can (e =n!"t deice t&at translates !a!er doc"ment doc"ment into mani mani!" !"la late ted d it& it& ima) ima)ee electronic ormat or stora)e in a com!"ter.  !rocessin) s/

+canner 

'onitor 

Cat&ode ray t"(e

data data rom rom

'onitor are most !o!"lar o/! deices "sed or  Dis!lay o/! on a teleision  !rod"cin) sotco!y sot co!y o/!. like screen. =ts =ts ada adant nta) a)es es like like lo lo T&e cat&ode ray t"(e  t"(e  C-T; is a ac""m t"(e ener)y cons"m!tion, con contain ainin) an electr ctron )"n )"n a so"rc o"rcee o  smaller and li)&ter. electrons; and a l"orescent screen.

LCD

Printer 

LCD as introd"ced in t&e 12s and is no a!!lied to dis!lay terminals also. t&ey t&ey can can (e clas classi sii ied ed as =m!ac !act or Noni onim m!act !act Printers are "sed to !rod"ce !a!er commonly  !rinters. knon as &ardco!y; o"t!"t. Based on t&e tec&nolo)y "sed.

=m!act !rinters

t&ey t&ey "se "se ty!e ty!er rit itin in) ) !rin !rinti tin) n) mec&a ec&ani nism sm Dotma Dotmatri@ tri@ and C&aract C&aracter  er  &er &erei ein n a &amm &ammer er stri strike kess !a!e !a!err t&ro t&ro") ")& & a  !rinters all "nder t&is ri((on in order to !rod"ce o"t!"t. cate)ory.

 Nonim!act !rinters

 !rinters do not to"c& t&e !a!er &ile !rintin). =nk4 =nk4et et,, Desk Desk4e 4et, t, Lase Laserr, T&ey "se c&emical, &eat or electrical si)nals to T&ermal !rinters all "nder  etc& etc& t&e t&e sym( sym(ols ols on !a!er !a!er.. =nk4e =nk4et, t, Desk4 Desk4et et,, t&is cate)ory o !rinters. Laser, T&ermal  !rinters all "nder "nde r t&is cate)ory o !rinters. !rinter s.

APPL=CAT=ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

=n!"t =n!"t deices deices are t&e deices deices t&ro")& t&ro")& &ic& &ic& e can )ie instr"ct instr"ction ion to system. o"t!"t deice )ies t&e o"t!"t o o"r )ien instr"ctions . 1; W&at is t&e "ll orm o IDU,LCDF 7; W&at is +ot Co!y # Hard Co!yF 0; >@!lain its eat"re Com!"ter O!erator # Pro)rammin) Assistant  N='= B=O+ +ettin)s # Iario"s Iario"s Ty!e o 'emories

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ec 4ectie :

Unit/Block No.: Date:

Week No.: Time :

-

Lesson no. :

0

B=O+ +ettin)s # Iario"s Iario"s Ty!e o 'emories 1; 1; ty!es !es o memory de deice , !ri !rimary memory dei deicce: ram, am, rom +econdary memory deice: *lo!!y Disk ,Hard Disk, Cd/ Dd, *las& 'emory ,Bl"e -ay Disk  'ark 'arker er,, W&it W&itee Boar Board d ,D"s ,D"ste terr ,Com ,Com!" !"te terr, Pro4 Pro4ec ecto tor  r 

Aids Aids : Pre!aration : K -eie -eie : Ty Ty!es !es o 'emory 'emory and =ts =ts >@am!l >@am!lee

K =ntrod"ction : ario"s ty!es o stora)e deices are "sed to store data tem!orary or !ermanent.. 'otiation : Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; Ty!es Ty !es o memory  Primary stora)e deice  +econdarty sto stora)e >ery com!"ter &as a Primary stora)e -A' -andom Access 'emory; tem! tem!or orar ary y stor stora) a)ee ("il ("iltt deices Primary stora)e o a com!"ter is oten reerred into into com!"t com!"ter er &ard &ardare are.. as -A' (eca"se o its random access T&is T&is tem!ora tem!orary ry stora)e stora)e is ca!a(ilities. knon as main memory. memory. -A' c&i!s are olatile memory. -O' -ead only memory ;

Data is ("rnt (y man"act"rer  Also Also kno knon n as a"@il a"@ilia iary ry memory.

+econdary stora)e

User can load and store readonly !ro)rams and data in it. User can erase inormation stored in it and c&i!s can (e re!ro)rammed to store ne.

>@am!le : ma)netic ta!e , CD-O CD-O' ' , lo! lo!!y !y disk disk , &ard disk.

=t &as "nlimited ca!acity. +!eed is ar sloer t&an !rimary stora)e. Used to store lar)e ol"mes o data on  !ermanent (asis. APPL=CAT=ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

=n!"t =n!"t deices deices are t&e deices deices t&ro")& t&ro")& &ic& &ic& e can )ie instr"ct instr"ction ion to system. o"t!"t deice )ies t&e o"t!"t o o"r )ien instr"ctions . 1; Descri(e Ty!es o 'emory and its *"nction 7; W&at is key to >nter in B=O+ settin) 0; W&at is "se o B=O+ +ettin). Com!"ter O!erator # Pro)rammin) Assistant  N='= Basic Hardare # +otare =ss"es # +otare =nstallation

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie : Aids Aids : Pre!aration : K -eie -eie :

Unit/Block No.: Date:

Week No.: Time :

-

Lesson no. :5

Basic Hardare # +otare =ss"es # +otare =nstallation W&at is &ardare and sotare, Ty!es o +otare and =ts =nstallation 'ark 'arker er,, W&it W&itee Boar Board d ,D"s ,D"ste terr ,Com ,Com!" !"te terr ,Pro ,Pro4e 4ect ctor  or  Ty!es Ty !es o =n!"t =n!"t / O"t!"t O"t!"t deice deice # t&eir t&eir *eat"res *eat"res

K =ntrod"ction : ario"s Hardare # +otare =ts >@am!le 'otiation : Presentation : To!ics

=normation Points Tell

Hardare # +otare =ss"es

1;Contin"e -estart Com!"ter  7;Do not Dis!lay 'onitor  0;Do not Work Gey(oard and 'o"se 6;Boot Disk *ail"re 3;Do not o"t Iol"me Iol"me =n +!eaker  +!eake r  5; Net Work Pro(lem ;Do not +tart =nternet. ?;Pro(lem To take Printo"t t&o")&t Printer  2; To come Bi! Bi! ol"me in CPU 1; Become to &ide ile # *older  11;Cd and Dd do not o!en and Write 17;+!eed lo com!"ters =nstallation o Basic sotare 1;'inim"m +ystem -e9"irement 7; +otare +et"! *ile or =t+ cd Drier  0;User 'an"al

=nstallation any +otare

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

+!ot &ints / "estion Ask; *irst *irst +tart +tart Com!"te Com!"terr and C&eck =ts Pro(lem 1;W 1;W&at is Pro(lem (lem to -estart Com!"terF 7;W&at is Pro(lem to do not Dis!lay 'onitorF 0;De 0;Desc scri ri(e (e !ro( !ro(le lem m do mott Work key(oa mo key(oard rd and 'o"se 1; >@!lain +te! to install 'icrosot Oice

1; W&at is -e9"ired to =nstall any +otare 7; Descri(e Hardare and +otare =ss"e Com!"ter O!erator # Pro)rammin) Assistant  N='= DO+ =nternal Commands

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie : Aids : Pre!aration : -eie : =ntod"ction : 'otiation : Presentation :

Unit/Block No.: Date:

Week No.: Time :

/

Lesson no. :



=nternal Command o DO+ 1; O!eratin) +ystem 7; CU= # $U= C&alk, D"ster, Pointer. Bootin) Process DO+ is a One Ty!e o CU= O!eratin) +ystem Command.com ile is t&e set o =nternal command

To!ics

=normation Points Tell

DO+ =nternal Command

• • • • • • • • • • • • • • •

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

Date Time CL+ Ier  Ier  Iol D=-  Co!y Con Ty!e Co!y -en Del 'D,CD,-D Prom!t >dit >@it

+!ot &ints / "estion Ask; Q W&at is t&e "ll orm o  DO+F Q Detail disc"ssion o all t&e internal commands O DO+

-"n all t&e internal commands. Use =nternal Command any time &en yo"r system is on. 1; W&at is CU= +ystemF 7; Dierence Beteen Ty!e Ty!e # >dit 0; >@!lain DO+ Prom!t 6; Dierence (eteen Del # -D DO+ >@ternal Command

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ec 4ectie : Aids : Pre!aration : -eie : =ntrod"ction : 'otiation : Presentation :

Unit/Block No.: Date:

Week No.: Time :

/

Lesson no. :

2

>@ternal Command o DO+ 1; Disk O!er !eratin) +ystem stem 7; =nternal Command o DO+ C&alk, D"ster, Pointer. -"n Dos . C&eck Dos !rom!t

To!ics

=normation Points Tell

DO+ >@ternal Command

• • • • • • • • • • •

APPL=CAT=ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

La(el *ind +ort Tree 'ore Attri( *ormat CHGD+G  Disk co!y +can disk  Del tree

+!ot &ints / "estion Ask; Q W&at is t&e "se o e@ternal commands o DO+F Q Detail disc"ssion o all t&e >@ternal commands O DO+

-"n all t&e >@ternal commands. >@terna >@ternall comman commands ds are "se to ormat ormat &ard disk, disk, =nstall =nstall ne !ro)ram !ro)rams. s. 'ana)e all iles . 1; W&at is Use o sort commandF 7; Dierence Beteen Tree # Del treeF 0; >@!lain *ormat Command 6; Ho can yo" c&an)e t&e attri( o ileF =ntrod"ction to O!en +o"rce # Lin"@ O!eratin) +ystemF

INDUSTRIAL TRAINING TRAINING INSTITUTE LESSON PLAN  Name : Trade :

J.G.Chaudhari

COPA

T#"ic 4 Ai' Objectie Aid! Pre"arati#$ Reie I$tr#ducti#$

%#tiati#$ Pre!e$tati#$

Unit/Block No.: Date:

Week No.: Time :

0

Lesson no. :

3

=ntrod"ction to o!en so"rce and lin"@ o!eratin) system. 'arker !en , d"ster , !ointer.

Lin"@ is Uni@ (ase o!eratin) system. =t is inented (y Lin"s Troalds . T&ere is no any oner o Lin"@ O+. Any one can donload it it&o"t any &idden cost or  reely. Today, Lin"@ is mostly "sed o!eratin) system in !ersonal com!"ter. =t is ery "se"l or small ("siness and also t&e installation is a(sol"tely ree. To create +ocially -es!onsi(le and ree o!en so"rce sotare like $='P.

T#"ic!

I$&#r'ati#$ P#i$t! Tell

I$e$ti#$ O& Li$u+ :

 Lin"@

is inented (y Lin"s Troalds , st"dent o t&e Helsinki Uniersity in t&e year o 1221. Lin"s likes to !lay it& com!"ter and sotare so t&at &e )ies t&e name L=NUM to t&e nely inented O!eratin) +ystem.

O"e$ S#urce :

 T&e

main adanta)e o lin"@ is , it is o!en so"rce o!eratin) system means Any one can donload it easily it&o"t any cost. Also t&e so"rce code or t&is O+ is easily aaila(le. +o e can also modiy it as !er o"r ies and ideas. =nstallation and "tili
8hat I! Li$u+ :

 Lin"@

S"#t hi$t! 4 )ue!ti#$! 5A!67 W&o is t&e =nentor o Lin"@ O!eration +ystem F

W&y Lin"@ is called O!en +o"rce F

is O!eratin) +ystem &ic& is also knon as $NU / L=NUM. Lin"@ is coo!eratie deelo!ment model so t&at any one can "se it.

 =t

is also knon as *ree O!en +o"rce +otare *O++;.

W&at is t&e *"ll *orm o *O++ F

Can ir"s aected to o"r main adanta)es o lin"@ is +!eed ,  !c i e installed Lin"@ F +ec"rity And its +ta(ility. T&ere is no any =ss"es like Iir"s , +!yare and Worm. T&e

 Lin"@

is o!en O+ so t&at t&e sotare is deelo!ed (y t&e coordination o many Com!anies. 8here I! Li$u+ :

 =n

startin) !&ase it is "sed as a +erer o!eratin) system ("t no its "se as a deskto! o!eratin) system.

 =t

is also "sed in +ym(ian O!eratin) +ystem P&one as ell as in PDA+.

Ada$ta9e O& Li$u+ :

 T&ere

is no any oner o Lin"@ Os . +o any one can de(") it it&o"t License Permission.

W&at are t&e adanta)es O Lin"@ O!eratin) +ystemF

 T&e

main adanta)e is , its *ree and most o t&e sotares comes it& $eneral P"(lic License. '"lti!le

User can "se it at a time. +!eed ill  (e same no matter &o many "sers "se "s e it.  =ts

r"n on PC , 'AC O+ , 'ainrame Com!"ter , +"!er Com!"ter and in Cell P&one.

 We

APPLICATION

SU%%AR

ASSIGN%ENT/ )UESTION RE;ERENCE NE
also r"n it on +e!arate Hardare. To Deelo!s t&e o!en so"rce sotare like o!en oice &ic& is mostly ork as a 'icrosot Oice !roided (y 'icrosot Cor!oration. To create Iir"s Iir"s *ree and +!yare ree A!!lication. Today To day all t&e sotare are ery costly in market. Lin"@ is only sin)le !latorm on &ic& e can create , modiy and de(") t&e ree a!!lication or sotare. =t ill (e ery "se"l in $oernment +ectors Beca"se no a days )oernment &as to !ay (i) amo"nt o money to !riate sector or com!any or t&eir license ersion sotare. 1.>@!lain History O Lin"@. 7.W&at Do yo" mean (y Lin"@ F And &ere it is "sed F 0.>@!lain t&e adanta)es o Lin"@ O!eratin) +ystem. =nternet L=NUM Commands

INDUSTRIAL TRAINING TRAINING INSTITUTE LESSON PLAN  Name : Trade :

Unit/Block No.: Date:

J.G.Chaudhari

COPA

T#"ic 4 Ai' Objectie Aid! Pre"arati#$ Reie I$tr#ducti#$

%#tiati#$ Pre!e$tati#$

Week No.: Time :

Lesson no. :

1=

L=NUM Commands. To aare it& t&e (asic Lin"@ Commands. 'arker !en , d"ster , !ointer.

We can !erorm t&e dierent dierent o!erations o!erations like like c&an)e date , dis!lay messa)e , co!y iles , remoe olders , create olders etc..Usin) t&e Lin"@ Commands. =t is also "sed to !erorm system task like to c&an)e !assord or !artic"lar lo)in "ser. =n s&ort Lin"@ command is ery "se"l &en e &ae to !erorm dierent task in a system mainly in C&aracter User =nterace CU=;. To ork in C&aracter User =nterace and O!en +o"rce +otare.

T#"ic! Date C#''a$d :

I$&#r'ati#$ P#i$t! Tell  =t

is "se to dis!lay as ell as c&an)e t&e system date and time.  Dierent

!arameters like D,@,M,, D,@,M,,y,(,B,m, y,(,B,m, W etc..are "se to set date and time in a !artic"lar  ormat like mm/dd/yy and etc.

 +ynta@  +ynta@ Ech# C#''a$d :

8h# C#''a$d :

command is "se to dis!lay messa)e on screen. We can also dis!lay ec&o in a color. Dierent esca!e se9"ence code is "sed to dis!lay ore)ro"nd color as ell as (ack )ro"nd color.

>.). ec&o H>LLOVCOPA H>LLOVCOPA

: ec&o Ro!tionS R+trin)S

 =t

is "se to dis!lay list o c"rrently lo)in "sers as ell as additional inormation o  !artic"lar "ser like lo)in time and terminal n"m(er etc..  +ynta@

S"#t hi$t! 4 )ue!ti#$! 5A!67 >.). date JDAT>: m/ d/y/n =t dis!lay t&e o/! like DAT> : 1/7?/16

: date Ro!tionS RormatS

 T&is

 +ynta@

L! c#''a$d :

0

>.). &o

: &o Ro!tionS

>.). ls A command is "se to dis!lay list o iles as To dis!lay ile list it& all ell as directories. &idden iles.  T&is

 Dierent

o!tions like a,A,-,@,d,l are "sed to dis!lay iles and directory in !artic"lar ormat.  +ynta@

: ls Ro!tionS *ile / Directory.

C" c#''a$d :

 T&is

command is "sed to co!y one or more iles to anot&er location.

>.).  !1.doc e:X!7.doc

 We

can also co!y arc&ie ile as ell as take  (ack "! "sin) t&e s"( o!tion a,(.  +ynta@  +ynta@ R' c#''a$d :

 T&is

command is "se to delete ile. =t deletes t&e ile it& messa)e or it&o"t messa)e it& s"( o!tion  and i.  +ynta@

% c#''a$d :

command is "se to rename ile and moes t&e ile rom one directory to anot&er.

%6dir C#''a$d :

command is "se to c&an)e c"rrent directory.

>.). cd d:

: cd directoryVname

 T&is

command is "se to make ne directory in to c"rrent directory. T&e ne directory m"st not (e in t&e same directory.

 +ynta@

>.). m myco!a.t@t c.t@t

: ' OldV*ilename NeV*ilename

 T&is

 +ynta@

>.).  rm test.t@t =t remoes test.t@t ile.

: rm Ro!tionS RileS

 T&is

 +ynta@  +ynta@ Cd C#''a$d :

: c! so"rce ile destination ile.

>.). mkdir itiV(a(ra

: mkdir directoryVname >.). rmdir itiV(a(ra

R'dir C#''a$d :  T&is

command is "se to delete em!ty directory.  +ynta@ : rmdir DirectoryVname >.). c&mod 566 test.t@t

Ch'#d C#''a$d :  T&is

command is "se to c&an)e iles access  !ermission. Dierent code or read,rite re ad,rite and e@ec"te is "sed.  +ynta@

: c&mod code ilename >.). sort itiV(a(raVadm

S#rt C#''a$d :  T&is

Gre" C#''a$d :

command is "se to arran)e lines in te@t

ile.  +ynta@ : sort Ro!tionS ilename

>.).  )re! Jco!a iti((r.t@t iti((r.t@t

T&is

command is "se to searc& !artic"lar ord in a ile as ell as dis!lay t&at ord on a screen. Pa!!d c#''a$d :

 +ynta@

: )re! Ro!tionS strin) ileVname

 T&is

command is "se to c&an)e !assord or  t&e c"rrently lo))ed in "ser.

 +ynta@

: !assd Ro!tionS

>.).  !assd

APPLICATION SU%%AR

ASSIGN%ENT/ )UESTION RE;ERENCE NE
'ostly "sed in dierent Lin"@ (ased O+ like "("nt", edora etcY =t Becomes ery easy to ork in a C&aracter User =nterace "sin) all t&ese lin"@ command. =t is !ossi(le to !erorm dierent task related to t&e o!eratin) system "sin) Lin"@ command. 1. >@!lai >@!lain n Date Date and Ls Ls comman command d it& it& all its its o!tion o!tion.. 7. >@!lai >@!lain n mkd mkdir ir and rmdir rmdir comman command d it& it& e@am!le. e@am!le. 0. >@!lai >@!lain n c!,rm, c!,rm,m m and and cd comm command and it& it& e@am! e@am!le. le. =nternet =ntrod"ction o ord # ile men"

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name :

J.G.Chaudhari

Unit/Block No.:

Week No.:

>

Trade :

COPA

Date:

Time

3(#ur

To!ic / Aim : O(4e O(4ect cti iee :

:

Lesson 11 no. :

=ntrod"ction o ord # ile men" 1; 1; =nst =nstal alla lati tion on o '+O '+O ic icee 7; A!!lication o '+ ord 0; Iario"s o!tion o '+ ord*ile 'en"; C&alk, D"ster, Pointer.

Aids : Pre!aration : K -eie : Windo K =ntod"ction : 'otiation : Ho to creat Atrectie Doc"ment Presentation : To!ics =ntrod"ction o '+ Oice

=normation Points Tell '+ Oice a"tomation sotare is "se"l to make ario"s doc"ment, s!read s&eet and  !resentation =t contain co ntain 0 !art. A. '+Word '+Word B. '+>@cel C. '+Poer Point Use o '+ord to make ario"s ty!e

+!ot &ints / "estion Ask; =nstallation o '+Oice =nsert CD o '+ •

•

Oice in t&e CD drie o com!"ter system. *rom r"n o!tion o

•

start men" r"n set"!.e@e $ie re9"ired

•

o!tion d"rin) set"!. Ater com!letion o 

•

•

o Doc"ment. '+>@cel is "se"l or makin) o

•

dierent ty!e o s!read s&eet. Poer Point is or !resentation

T&"s (y "se o 'sOice one can do any ty!e O com!"ter ork. =t is more adanta)es t&en Dos (ase sotare like Lot"s # Word star.

+t"dy o ario"s men".

*ile 'en".

'+  Oice installation ,restart com!"ter system. -"n '+Oice no.

*rom start men", men", !ro)ram !ro)ram load load '+W '+Word (y do"(le do"(le clickin clickin) ) on '+W '+Word. ord. Ater Ater Loadin) Loadin) indo o Word. Word. One 'en" (ar yo" ill see olloin) o!tion. *ile,>dit,Iie,=nsert,*ormat,Tool,Ta(le,Windo ,Hel!. =n ile men" olloin) item see. Detail disc"ssion o all  Ne, o!en, close, sae, sae as, e( !a)e, ! a)e, o!tion o ile men". ersion, !a)e !reie, !a)e set"!, !rint  !reie, send to, !ro!erty

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

Word is "se"l to make ario"s ty!es o doc"ment. '+OiceOice A"tomation +otare; 1; W&at is t&e "ll orm o '+ in '+WordF 7; W&at i t&e dierence (eteen sae and sae asF 0; W&at is t&e "se o !rint !reieF 6; >@!lain !a)e set"!F '+Word is "se to create a!!lication, letters and ot&er attractie doc"ments. >dit , Iie and =nsert 'en" 'en " o '+Word.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name :

J.G.Chaudhari

Unit/Block No.:

Week No.:



Trade :

COPA

Date:

Time

3 (#ur!

To!ic / Aim : O(4ec 4ectie :

:

Lesson 1, no. :

=ntrod"ction o >dit , Iie and =nsert men" o '+Word. 1; >dit 'en" o '+Word. 7; Iie 'en" o '+Word. '+Word. 0; =nsert 'en" o '+Word.

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : '+ Oice K =ntod"ction : 'otiation : Usin) >dit, Iie and =nsert men" o Word ,"ser can edit t&e doc"ment. Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; >dit 'en" =n edit men" olloin) o!tions are aaila(le. Detail Disc"ssion o all Undo , -e!eat, C"t, Co!y, Paste, Paste +!ecial, a(oe o!tion o edit  !aste as &y!erlink, clear, select all, ind, 'en" -e!lace, $o to, Link, O(4ect Iie men". =n ie men" olloin) o!tions are aaila(le. Detail Disc"ssion o all a(oe o!tion o Iie  Normal, We( We( layo"t, Print layo"t, O"t line, 'en" Tool (ar (ar, -"le -"lerr, Doc" Doc"me ment nt ma!, ma!, &ead &eader er # ooter, *ootnote, Comment, *"ll screen, Zoom

=nsert men".

=n =nsert men" olloin) O!tions are aaila(le. Break, Pa)e N"m(er, date # Time, a"to te@t, *ield, +ym(ol, Comment, *ootnote, Ca!tion, Cross reerence, inde@ # Ta(, !ict"re, Book mark, ile, o(4ect.

APPL=CAT=ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

Detail Disc"ssion o all a(oe o!tion o =nsert 'en".

>dit , Iie and =nsert men" is "se"l or editin) ord doc"ment. Iie Iie or Dier Dierent ent ie ie o doc"men doc"ment, t, =nsert =nsert and >dit >dit men" men" or editin) editin) doc"ment 1; Work all s&ort c"t key o o!tion o edit, ie and insert men"F 7; W&at is t&e "se o Header # *ooterF 0; dierence (eteen !aste and !aste s!ecialF 6; Ho to add ne !a)e in doc"mentF *ormat # Tools men", Ta(le and Windos men".

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.C(AUD(AR  Unit/Block No.: I COPA Date:

To!ic / Aim : O(4ectie :

Week No.: Time

2

Lesson no. :

1-

:

*ormat,Tools # Ta(le 'en" 1; *ormat men" 7; Tools ools men" men" 0; Ta(le a(le men" men"

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =nto =ntod" d"ct ctio ion n : 'icr 'icros oso ott ord ord 'otiation : Presentation : To!ics *ormat men"

Windo # dos (ase !ro)ram like ty!in) t"tor ,'sOice etc. =normation Points Tell

+!ot &ints / "estion Ask; Q W&at is t&e "se o ont commandF

Q *ont: T&is ill c&an)e t&e ont attri("tes o eit&er t&e c"rrently selected te@t QPara)ra!&: select t&e te@t yo" is& to c&an)e and t&en "se t&is command to make t&e Q W&at is t&e "se o alterations, s"c& as ali)nment, indentation, and  (orders and s&adin)F s&adin )F s!acin). QB"llets and N"m(erin): T&is is a &andy Q W&at is t&e "se o command, it creates indented lists it& ario"s c&an)e caseF ormats. QBorders and +&adin): T&is command allos yo" to create (orders and s&adin) on elements it&in yo"r 'icrosot Word doc"ment. QCol"mns: T&e Col"mns command ill s!lit t&e c"rrent doc"ment into t&e n"m(er o col"mns yo" s!eciy. QDro! Ca!:T&is tool allos yo" to eit&er add a dro! ca! c&aracter to yo"r doc"ment or c&an)e an e@istin) letter at t&e start o a sentence; to a dro! ca!. QTe@t Direction: T&is allos yo" to c&an)e t&e te@t direction o a te@t o(4ect, or e@am!le a te@t (o@. QC&an)e Case: T&e C&an)e case tool allos yo" to alter t&e case o e@istin) te@t. QBack)ro"nd: T&is c&an)es t&e (ack)ro"nd color o yo"r 'icrosot Word doc"ment. =t also allos yo" to add atermarks and "se dierent )radient eects. Q+tyles and *ormattin): T&is ill o!en t&e +tyles and *ormattin) tool(ar, alloin) yo" create &eadin)s, lists and more.

Tools 'en"

Q W&at is t&e "se o Q+!ellin) and $rammar: T&is command ill s!ellin) and )rammerF c&eck t&e s!ellin) and )rammar o t&e c"rrent 'icrosot Word doc"ment. Q >@!lain mail mer)e. QLan)"a)e: T&e lan)"a)e tool &as ario"s o!tions, incl"din) settin) t&e lan)"a)e o t&e  e@!lain macro. doc"ment, translatin) te@t, o!en t&e t&esa"r"s and mana)e &y!&enation. QWord QWord Co"nt: T&is ill o!en t&e Word Word Co"nt dialo)"e (o@, ena(lin) yo" to co"nt t&e amo"nt o ords in t&e &ole doc"ment, or t&e c"rrently selected te@t. QProtect Doc"ment: T&is command allos yo" to control t&e !rotection o t&e doc"ment, incl"din) tracked c&an)es, comments and orms. QLetters and 'ailin): $ies yo" access to ario"s eat"res, incl"din) t&e 'ail 'er)e Winelo!es and La(els tool, and t&e 'ail 'er)e Tool(ar. Tool(ar. Q'acro: T&is o!ens t&e 'acro Dialo)"e (o@, alloin) yo" to mana)e s"(se9"ent and e@istin) macros. We ill (e coerin) 'icrosot Word macros in a "t"re t"torial. QTem!lates QTem!lates and an d Add=ns: O!ens t&e Tem!lates Tem!lates and Add=ns Dialo)"e (o@, alloin) yo" to add, remoe or "!date styles and tem!late. QA"toCorrect O!tions: O!ens t&e A"toCorrect dialo)"e (o@, ena(lin) yo" to mana)e ca!itali
Ta(le men"

QDra Ta(le: Ta(le: T&is command o!ens t&e Ta(les and Borders dialo)"e (o@ it& t&e draw table  actie. tool  actie. Q=nsert: Allos yo" to insert a &ole ta(le or  4"st col"mns, ros and cells into t&e c"rrent doc"ment. QDelete: Delete com!lete ta(les, col"mns, ros and selected cells. Q+elect: T&is command allos yo" to select t&e c"rrent ta(le, col"mn, ro or cell. Q'er)e Cells: T&is tool ill mer)e t&e c"rrently selected cells into one. Q+!lit Cells: T&is ill s!lit t&e selected cell/s into yo"r c&osen amo"nt o col"mns and ros, it ill also oer i more t&an one cell selected; to mer)e t&e selected cells (eore t&e s!lit. QTa(le QTa(le A"to*ormat: T&is command ill o!en t&e 'icrosot 'icros ot Word Word Ta(le A"to*ormat A"to*ormat dialo)"e dia lo)"e  (o@, &ere yo" can c&oose c&oo se rom a n"m(er o dierent ta(le tem!lates, incl"din) !reset onts and cell (ack)ro"nd colo"rs colors;. QConert: T&is command ill conert e@istin) te@t into a ta(le ormat. T&e te@t ill &ae to &ae a common se!arator to indicate t&e dierent col"mns, it ill also needs ne  !ara)ra!&s &ere yo" o"ld like eac& ro. Q+ort: T&is o!ens t&e +ort Ta(le dialo)"e (o@. o" can c&oose &ic& col"mn yo" o"ld like to sort and (y &at order.

APPL=CAT=ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

Q W&at is t&e "se o mer)e cellsF Q W&at is t&e "se o s!lit cellsF Q W&at is t&e "se o sortF

T&"s, T&"s, ormat,t ormat,tools ools and ta(le ta(le men" men" is ery "se"l "se"l or makin) makin) doc"men doc"mentt attractie. 1; >@!lain mostly "sed commands o ormat men" in ord. 7; >@!lain mostly "sed commands o tools men" in ord. 0; >@!lain mostly "sed commands o ta(le men" in ord. =ntrod"ction o >MC>L # *ile men"

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie :

Unit/Block No.: Date:

Week No.: Time :

3

Lesson no. :

1/

=ntrod"ction o >MC>L # *ile men" 1; =ntrod"ction to >MC>L 7; *ile *ile men" men"

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod"ction : 'otiation : Presentation :

Windo # dos (ase !ro)ram like ty!in) t"tor ,'sOice etc.

To!ics

=normation Points Tell

=ntrod"ction to e@cel

'icrosot e@cel is a s!reads&eet sotare and a sotare o micrsot oice s"ite. =t is "sed to sotore n"meric data ery easily. o" can also add orm"la and "nction to analy@cel iles called ork(ook. >ac& ork(ook &as t&ree orks&eets. Works&eets are t&e are &ere yo" can enter data in ta("lar ormat. >ac& orks&eet &ae 733 col"mns ane 53305 ros. >@cel iles are saed "sin) .@ls e@tension. 'icrosot e@cel is "sed or creatin) marks&eets,!ayroll o em!loyees,!rod"ction re!orts or com!anies. o" can start e@cel (y startQall !ro)rams Q'icrosot oiceQ 'icrosot e@cel. o" can also o!en e@cel (y ty!in) e@cel in r"n men". >@cel screens &ae dierent areas like title(ar,men"(ar,standard tool(ar,ormattin) tool(ar,orm"la(ar,orks&eet etc.

+!ot &ints / "estion Ask; Q W&at is t&e "se o 'icrosot e@celF Q >@!lain dierent ays to start e@cel

*ile men"

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON ->*>->NC>  N>MT L>++ON L>++ON

QNe... O!ens a ne >@cel Work(ook. Q W&at is t&e "se o QO!en... O!ens many ty!es o >@cel ne,o!en,sae command F doc"ments, een te@t iles. QClose: Closes t&e c"rrent Work(ook. Q >@!lain !a)e Q+ae As... +aes yo"r Work(ook "nder a set"!,!rint !reie,!rint dierent name or dierent ormat. area. QPa)e +et"! Controls &o yo"r !a)e !rints o"t. QPrint Area: =s &o yo" s!eciy t&e !art o yo"r orks&eet t&at yo" is& to !rint. QPrint Preie +&os yo" &at yo"r doc"ment looks like (eore yo" aste !a!er  !rintin) o"t somet&in) t&at doesn8t look t&e ay a y yo" ant it to. QPrint... Prints t&e selected area, c"rrent Works&eet Works&eet all a ll Works&eets Works&eets in yo"r Work(ook. Work(ook.  Pro!erties Allos yo" to look "! or add detailed inormation a(o"t yo"r doc"ment. Belo t&is is a list o t&e iles o!ened recently  (y >@cel. Q >@it Closes >@cel and all o!en Work(ooks. : : : : :

T&"s, 'icrosot e@cel is ery "se"l sotare or calc"lations on data. 1; Write s&ort note on 'icrosot e@cel 7; >@!lain mostly "sed commands o ile men". >dit, Iie Iie # =nsert =nse rt 'en"

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie :

Unit/Block No.: Date:

Week No.: Time :

1=

Lesson no. :

>dit, Iie Iie # =nsert =nser t 'en" 1; >dit men" 7; Iie men" men" 0; =nser =nsertt men" men"

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod"ction : 'otiation : Windo # dos (ase !ro)ram like ty!in) t"tor ,'sOice etc. Presentation : To!ics >dit men"

+!ot &ints / "estion Ask; Q Undo :Takes (ack t&e last t&in) yo" did. o" Q W&at is t&e "se o may click it or ty!e CtrlZ re!eatedly to t"rn c"t,co!y and !aste  (ack time to (eore yo" make a mistake. commandF Q -e!eat or -edo: -e!eats t&e last action reerses an "ndo. Q W&at is t&e "se o QC"t: T&e selected cells; ill disa!!ear ater moe or co!y s&eet yo" !aste t&em. +elected te@t disa!!ears and is commandF stored tem!orarily in t&e Cli!(oard. Q Co!y: T&e contents o selected cells; ill Q W&at is t&e "se o  (e co!ied to a ne location &en yo" !aste ind,re!lace and )otoF t&em. +elected te@t is co!ied into t&e Cli!(oard. Q Paste :Preio"sly c"t or co!ied cells are  !asted into t&e nely selected s elected location. C"t or co!ied te@t, ima)es, etc. are co!ied rom t&e Cli!(oard into t&e nely selected location.  Q *ill: Lets yo" ill selected cells it& t&e contents o t&e irst cell in t&e ran)e in &ite;. Q Clear: -emoes ormattin) e.). (old;, contents, or all o t&e a(oe. Note t&at t&e little [Del[: key clears contents ("t not ormats or comments. Q Delete +&eet: Permanently remoes t&e c"rrent s&eet rom e@istence. Q 'oe or Co!y +&eet.: Lets yo" moe or co!y t&e c"rrent Works&eet it&in t&e c"rrent Work(ook Work(ook or to a ne Work(ook. Work(ook.  Q *ind.:Locates a )ien te@t strin) it&in yo"r selection. Q -e!lace: Locates and re!laces a )ien te@t strin) in yo"r selection it& anot&er s!eciied strin) or it& not&in) at all;. Q $o To.:Takes yo" to a cell s!eciied (y col"mn and ro, or s!eciied (y name. =normation Points Tell

10

Iie men"

=nsert men"

Q Normal Iie :dis!lays all cells, !rintin) or not. Q Pa)e Break Preie :Dis!lays only t&e cells t&at ill (e !rinted. o" may set !a)e (reaks in t&is ies dis!layed as (l"e lines; (y dra))in) t&em. Q Tool(ars: Lets yo" select &ic& tool(ars are isi(le across t&e to! o yo"r >@cel indo i.e. t&e ros o ("ttons;. Q *orm"la Bar: +ets &et&er or not yo" is& to dis!lay t&e *orm"la Bar, &ic& dis!lays t&e orm"la i any; or "normatted contents o t&e c"rrently selected cell. Q +tat"s Bar :+ets &et&er or not yo" is& to dis!lay t&e +tat"s Bar, s&on across t&e (ottom o t&e >@cel indo. Q Header and *ooter: Allos yo" to edit t&e Header, &ic& a!!ears across t&e to! o eac&  !rinted !a)e, and/or and/o r t&e *ooter, &ic& a!!ears across t&e (ottom. Q *"ll +creen :'a@imi
Q W&at is "se o !a)e  (reak !reieF

Q Cells: =nserts ne cells into yo"r orks&eet,  !rom!tin) yo" to ask as k &o yo" o"ld like to moe t&e s"rro"ndin) cells o"t o t&e ay. Q -os : =nserts a ne ro a(oe t&e selected cells;. QCol"mns: =nserts a ne col"mn to t&e let o t&e selected cells;. Q Works&eet: Works&eet: =nserts =n serts a ne n e Works&eet, Works&eet, it& its ta( to t&e let o t&at o t&e selected Works&eet. Q C&art... La"nc&es t&e C&art Wi
Q W&at is "se o c&artF

Q >@!lain &eader and ooter.

Q W&at is "se o  !a)e(reakF Q W&at is t&e "se o "nctionF

Q *"nction: La"nc&es t&e *"nction Wi O(4ect Linkin) and >m(eddin); com!ati(le ile. Q Hy!erlink : =nserts a link to a s!eciied e(site or ile location. = yo" click on t&e link, yo" ill (e (ro")&t to t&at location. APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

1; >@!lain mostly "sed commands o edit men" in e@cel. 7; >@!lain mostly "sed commands o ie men" in e@cel. 0; >@!lain mostly "sed commands o insert men" in e@cel. *ormat , Tool And And Data men" o >MC>L

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudahri COPA

T#"ic 4 Ai' Objectie

Aid! Pre"arati#$ Reie I$tr#ducti#$

%#tiati#$ Pre!e$tati#$

Unit/Block No.: Date:

Week No.: Time :

11

Lesson no. :

1>

*ormat , Tool And And Data men" o >MC>L 1. To re!resent a data in a !ro!er ormat to "nderstand "nderstand it easily. easily. 7. To create create error error ree and )ramm )rammatic atically ally !erect !erect orks& orks&eet. eet. 0. Present data in !ro!er se9"ence se9"ence so so t&at anyone can can "nderstand "nderstand it easily. easily. 'arker Pen , D"ster And Pointer 

=n a com! com!"te "terr , &en &en yo" ork ork it it& & arit&m arit&meti eticc or n"meri n"merica call data data it is ery ery necessary t&at it looks like any(ody can "nderstand it easily and m"st (e in !ro!er  se9"ence and ormat. =t is also necessary t&at t&e data ill (e error ree and  !roides "ser riendly riend ly enironment. Create data(ase !ro)ram like -es"lt s&eet and Acco"ntin) Data(ase.

T#"ic! ;OR%AT %ENU :

I$&#r'ati#$ P#i$t! Tell

yo" can set t&e CELLS : Usin) t&is o!tion yo"  !artic"lar cate)ory cate)or y or eac& and eery cell like c"rrency, n"m(er, date, time, !ercenta)e etc. =t is also !ossi(le to set ali)nment like let, center, ri)&t, to!, (ottom. =t !roides t&e acility to set ont, ont style, si
R# A$d C#lu'$:

T&is o!tion is "se to set &ei)&t and idt& o t&e cell s&o"ld (e ad4"sta(le as !er data.o" can also &ide -o and Col"mn.

Ho can yo" set ro &ei)&t or col"mn idt& F

Sheet :

=s it !ossi(le to set (ack )ro"nd ima)e to s&eet F HoF

Aut# ;#r'at:

Ho can yo" set A"to ormat o s&eet in e@celF

Usin) t&is o!tion, User can )ies t&e name to s&eet as !er its re9"irement and also set  (ack)ro"nd !ict"re !ict" re or t&e s&eet and ta( color. User can &ide t&e s&eet "sin) t&is o!tion. =t is a collection o dierent in("ilt ormats or s&eet it& desi)ns and dierent colors. 

C#$diti#$al ;#r'atti$9 : User can  !roides dierent ormattin) o rmattin) to t&e cell as !er dierent condition.

TOOLS %ENU :

S"#t hi$t! 4 )ue!ti#$ 5A!67 =s it !ossi(le to set date ormat or !artic"lar cell or  col"mn F Ho F

S"elli$9 5;7: >@cel c&ecks t&e s!ellin) in entire actie orks&eet. = t&ere is a mistake, it s"))est t&e correct s!ellin).



Re!earch :

o" o" can 9"ickly 9"ic kly reerence inormation online and easily insert deinition , stoke 9"otes etc.

E.9. : =n 'ark s&eet i st"dent res"lt is ail t&en cells (ack)ro"nd color s&o"ld (e red ot&erise its dis!lay it& )reen  (ack)ro"nd color etc..

W&ic& is t&e s&ort c"t key to c&eck s!ellin) F

Pr#tecti#$ :

User can !rotects its data in s&eet "sin) t&is o!tion. Passord re9"ire to "n Protect t&e s&eet.

Ho e can !rotect o"r s&eetF

Aut#

E.9. +!ellin) JT&e is ty!e Like  Te& t&en it ill a"tomatically conerted in to  T&e i e already added t&at s!ellin) into t&is o!tion.

c#rrect  : =ts a"tomatically corrects t&e s!ellin)s or ord i e s!eciy it in a"to correct o!tion.

%acr#:

= yo" !erorm a task re!eatedly in e@cel , yo" can a"tomate t&e task it& a macro. =t is a series o command and "nctions t&at are stored in 'icrosot Iis"al Basic mod"les and can (e r"n &en eer yo" need to !erorm t&e task. DATA %ENU :

E.9. = yo" oten enter lon) te@t strin)s in cells, yo" can create a macro to ormat t&ose cells so t&at t&e te@t ra!s.

S#rt : Use to sort data accordin) to s!eciic sort order like ascendin) or descendin). = data in one col"mn ill (e same t&en it ill c&ecks t&e 7nd and 0rd col"mn &ic& e s!eciy in sort o!tion o data men".

Ho can yo" arran)e data in !artic"lar order F

;ilter  : We can ilter data as !er o"r re9"irement. +&eet contains dierent cell al"es in dierent ros ("t i e ant to see !artic"lar  cells &ic& contains same al"e or al"e to a(oe or (elo to s!eciic criteria , t&en it s&o"ld (e done only it& ilter o!tion.

E.9. =n res"lt s&eet e &ae to see only t&ose ros &ic& contains +cience as a stream t&en it s&o"ld  (e !ossi(le it& ilter o!tion.





>.). =n mark s&eet , !ercen ta)e m"st (e (eteen 1 to 1 so i any one can enter  A(oe or (elo al"e , it Te+t t# C#lu'$ : User can conerts t&e te@t dis!lay error like T&e al data into col"mn a"tomatically "sin) t&is o!tion "e yo" entered is not alid. ?alidati#$ :

We can s!eciy t&e !artic"lar r"les or !artic"lar cell "sin) t&is o!tion.

APPLICATION SU%%AR ASSIGN%ENT/ )UESTION RE;ERENCE  NE
To create mark s&eet etc. =t is ery easy to arran)e , ormat and re!resent data and sae o"r time and ener)y. 1. >@!lai >@!lain n Conditi Conditional onal *orm *ormatti attin) n) in >MC> >MC>L. L. 7. >@!lai >@!lain n sort and *ilte *ilterr acility acility and and its its adanta adanta)e. )e. 0. >@ >@!l !lai ain n mac macro ro acil acility ity.. =nternet. =ntrod"ction to !oer !oint # ile, edit, ie men".

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

T#"ic 4 Ai' Objectie

Aid! Pre"arati#$ Reie I$tr#ducti#$

%#tiati#$ Pre!e$tati#$

Unit/Block No.: Date:

Week No.: Time :

1,

Lesson no. :

1

=ntrod"ction to !oer !oint # *ile , >dit , Iie men". 1. A "niersally "niersally desi)ned !resentation !resentation en&ances st"dent learnin) learnin) (y !resentin) !resentin) inormation in a ariety o ormats , te@t , ima)es , and m"ltimedia. 7. To create "se"l "se"l and !ro!er !resentat !resentation ion so t&at t&at any !ersons !ersons can can "nderstand "nderstand it easily. 'arker !en , d"ster , !ointer.

Poer Poer !oint !oint is t&e t&e !resen !resentat tation ion )ra!&i )ra!&ics cs !ro)r !ro)ram am t&at t&at &el!s &el!s yo" create create lasti lastin) n) is"al im!act eit&er in !erson or online. Wit& en&anced m"ltimedia s"!!ort , sae yo"r !resentation to stora)e deice or distri("tion and !lay streamin) a"dio and ideo it&in a slide s&o. To create !resentation like B"siness strate)y , science and tec&nolo)y etcY

T#"ic!

I$&#r'ati#$ P#i$t! T# Tell  Poer

I$tr#ducti#$ T# P#er "#i$t :

!oint is a ery !oer"l sotare "sin) &ic& e can create s"ita(le  !resentation , slides slide s on !artic"lar to!ics. to!ics . =t (ecomes ery easy to  !resent data on a com!"ter co m!"ter "sin) t&e !oer  !oint sotare.

;ILE %ENU :

Ne : Usin) t&is o!tion e can create a  (lank !resentation or c&oose in("ilt desi)n d esi)n tem!lates.  O"e$ : To o!en !resentations &ic& are stored on stora)e media.  Cl#!e : To close t&e c"rrently o!en  !resentation ile.  Sae : =t is "se to store or sae !resentation on stora)e media in a com!"ter.  Sae a! : =t is "se to create anot&er co!y o saed !resentation it& dierent name and location.  Pa9e Setu" : =t is "se to set slide si
S"#t (i$t 4 )ue!ti#$! 5A!67 W&at =s Poer Point F



W&at is t&e s&ortc"t key o  Ne , O!en ,and +ae o!tion F

W&ic& O!tion is "se to set Orientation o +lide F



Pri$t : =t is "se to take !rint o"t o o"r slides. We can also !rint selected slides as ell as s!eciies t&e n"m(er o co!ies into t&is.  E+it : Use to e@it rom !oer !oint sotare. EDIT %ENU :



U$d# 5ctrl@7  : =t remoes t&e eect or  !rocess o last task.  Re"eat 5ctrl@*7: =t cancels t&e eect o "ndo.  Cut5ctlr@+7  : =t is "se to moe data rom one slide to anot&er.  C#"*5ctrl@c7 : =t is "se to co!y data rom one slide to anot&er.  Pa!te5ctrl@7  : Use to !aste c"t or co!ied data to t&e destination.  O&&ice Cli"b#ard : =t saes t&e co!y o co!ied or c"t data in it.  Clear : Use to delete !artic"lar o(4ect/ content as ell as slide.  Select All : Use to select all t&e content or data in a slide.  Du"licate : To create t&e slide same as selected slide.  ;i$d : We can searc& !artic"lar ord in o"r  !resentation "sin) t&is o!tion. We can also searc& it& !erect matc& like ca!ital ord or small.  Re"lace : We can !"t anot&er ord at t&e  !lace o t&e ord ritten in  *ind *in d &at (o@.

W&ic& s&ortc"t key is "se to !rint slide data F

W&at is t&e s&ortc"t key o "ndo or re!eat F

W&at is t&e s&ortc"t key o c"t , co!y # !aste F

W&at is t&e s&ortc"t key o clear # select all F

W&at is t&e s&ortc"t key o *ind and re!lace F

?IE8 %ENU : N#r'al : =t is t&e main editin) ie. User can normally orks it& normal ie.  Slide S#rter : =t is an e@cl"sie ie o o"r slide in t&"m(nail rom , &el!"l or rearran)in) t&e order o o"r slides.  Slide Sh# : +lide s&o ie takes "! t&e "ll com!"ter screen , like an act"al slide s&o  !resentation. =n t&is "ll screen ie yo" see yo"r !resentation t&e ay yo"r a"dience ill.  Ta!6 Pa$e : W&en t&is o!tion is ticked , =t ill dis!lay t&e task !ane to t&e ri)&t side o t&e slide.  T##lbar : Use to ena(le dierent tool(ar like !ict"re , drain) , standard , ormattin) etcY on t&e screen.  Ruler : Use to dis!lay ertical as ell as &ori
Ho many ty!es o ie aaila(le in !oer !oint F

Ho can yo" add dierent tool(ar in !oer !oint F

Ho can yo" add slide n"m(er in !oer !oint F

APPLICATION SU%%AR ASSIGN%ENT/ )UESTION

RE;ERENCE NE
To re!resent any data on com!"ter >asily # Attractiely. W&en o" are makin) yo"r !resentation , create t&e content o yo"r  !resentation irst irs t and t&en )et creatie it& colors co lors and animation. 1. W&at W&at is Poer Poer Point Point F >@!lain >@!lain t&e ile ile men". men". 7. >@!lai >@!lain n t&e edit edit men" men" it& all all s"( men"s men"s in !oer !oer !oint !oint.. 0. Ho many many ty!es ty!es o ies are aaila(le aaila(le in !oer !oer !oint !oint F >@!lain >@!lain eac& it& details. =nternet. =nsert and +lide s&o men".

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

T#"ic 4 Ai' Objectie Aid! Pre"arati#$ Reie I$tr#ducti#$

%#tiati#$ Pre!e$tati#$

Week No.: Time :

1,

Lesson no. :

12

=nsert and slide s&o men". 1. To create !resentation "sin) m"ltimedia tools like so"nd , !ict"res , o(4ects etc... 7. To add animation eects and timin)s o slides in !resentation. 'arker !en , d"ster , !ointer.

=t is ery necessary necessary t&at o"r !resentation !resentation &as so"nd eects eects , animations animations , !ict"res and eects. +ometimes o"r !resentation (ecomes (orin) so t&at =nsert men" and slide s&o men" (ot& !roides t&e acilities acilities to add a(oe mention all acilities acilities and eects. T&ey makes o"r !resentation attractie and =nterestin). To create !resentations like B"siness strate)y , science # Tec&nolo)y etcY..

T#"ic! INSERT %ENU :

SLIDE S(O8 %ENU :

Unit/Block No.: Date:

I$&#r'ati#$ P#i$t! Tell 

S"#t hi$t! 4 )ue!ti#$! 5A!67 W&at is t&e s&ortc"t key or ne slide F

Ne Slide5ctrl@'7 : =t is "se to insert ne  (lank slide into c"rrent c"r rent !resentation.  Du"licate Slide : =t is "se to insert anot&er slide same as selected slide into !resentation. Ho can yo" add slide  Slide Nu'ber : Use to insert slide n"m(er n"m(er , date # time into in all slides o !resentation.  !resentation F  Date  Ti'e : To insert date and time into c"rrent slide. Ho can yo" add a"to  Picture  : =t is "se to insert )ra!&ics like cli! s&a!es in !oer !oint F art , a"to s&a!es , ord art and or)ani@cel , Word , Ado(e  !resentation F Ho F -eader and Word !ad etcY "sin) t&is o!tion. W&at is t&e s&ort c"t key o   ?ie Sh# : We re!resent o"r !resentation slide s&o F in "ll screen ie "sin) t&is o!tion. T&e s&ort c"t key or t&is o!tion is *3.



Set u" Sh# : We sets &o many slides &ae to dis!lay and also sets slide s&o resol"tion "sin) t&is o!tion.  Acti#$ utt#$!  : We add dierent ("ttons icons like ne@t , !reio"s , &ome etc.. "sin) t&is o!tion. Ater addin) ("ttons s!eciy &y!erlink or t&at ("tton. +o &en e click on t&at ("tton d"rin) slide s&o , e moes on slide &ic& set into &y!erlink.

W&at is t&e "se o Action B"ttons F

Ho e can a!!ly animation to o"r content F



A$i'ati#$ Sche'e! : =t contains dierent animation sc&emes like ade in , aded
Cu!t#' A$i'ati#$ : =ts "se to a!!ly c"stom animation eects to o"r content in slide. = e select t&is o!tion , animation eect ill a!!ly (y sotare on o"r content a"tomatically.

W&at is t&e main dierence  (eteen animation sc&eme and slide transition F Ho e can a!!ly animation to o"r slide F

Slide Tra$!iti#$ : =t is "se to )ie animation eect to o"r slide not to content. We also set so"nd # s!eed or o"r slide transition.





(ide Slide : = e &ide any slide t&en it s&o"ld not (e dis!lay d"rin) slide s&o.

APPLICATION SU%%AR

ASSIGN%ENT/ )UESTION RE;ERENCE NE
To re!resent any data on com!"ter >asily # attractiely. Add only necessary so"nds and animation in !resentation. = e added more so"nds , colors # Animation into slide t&en !eo!le more attracts toards t&em not toards yo"r data and so t&at it s&o"ld (e !ossi(le t&at yo" ill (e ail in yo"r aim. 1.>@!lain Pict"re # Dia)ram o!tion it& all o!tion. 7.>@!lain Animation sc&emes and +lide transition o!tion. 0.W&at is dia)ram c&art F >@!lain it& i)"re and e@am!le. =nternet Conce!ts o Data , =normation # Data(ase.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ec O(4ecti tie e

:

Unit/Block No.: Date:

Week No.: Time :

1-

Lesson no. :

13

Conce!ts o Data, =normation , Data(ase, DB'+ and -DB'+ 1; Termi erminol nolo)y o)y o Data Data,, =norm =normat atio ion n ,Dat ,Data( a(ase ase , DB'+ DB'+ and -DB' -DB'+ + 7; >@!lanation o DB'+ 0; Dierence (eteen Data and =normation . C&alk, D"ster, Pointer.

Aids : Pre!aration : K -eie : K =ntod"ction : Data(ase mana)ement and -elational Data(ase 'ana)ement system 'otiation : DB'+ and -DB'+ Conce!t in -eal World Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; =normation Q W&at is =normationF -es"lt o Data Processin) *or 'akin) a Decision Q W&y =normation F Used to make !rocess, !lannin) and re!resentation Q W&at is t&e "se o =normationF Data Collection o =normation &ic& s&o"ld Q &at is data F Q W&y data F  (e 1 *act. =t is (asic ra material or !rocessin) =t ill sim!le and random. •

• •

•

• •

Data I/+ =normation

•

•

•

•

•

•

Data(ase

•

• •

Data *rom Latin Word Word Dat"m and =normation *rom Latin Word  =normare Data is *ormatted =normation and =normation is res"lt o Data Processin) Data may (e meanin)"l and =normation m"st (e 'eanin)"l Data consider as system in!"t and =normation Consider as Data O"t!"t Data is Basic -a materials and =normation is Prod"ct. Data re9"ire to !rocess or "nderstandin) and No need to re9"ire or =normation Collection o =normation it& !ro!er ormat Collection o Arran)ed data in ormat Collection o Ta(le Ta(le

QDierence Beteen Data and =normation

Q&at is Data(aseF Q W&y Data(aseF

DB'+

• •

• •

*"ll orm o DB'+ 'aintainin) Dierent Ty!es o =normation >@am!le.*o@!ro,d(ase etc. Adanta)es o DB'+ Packa)es 1. Com! Com!le le@ @ -ela -elati tion ons& s&i! i! 7. Data Data red" red"nd ndan ancy cy 0. Us User er Dei Deine ne Ta(le *orm *orm 6. 'ain 'ainta tain in Dic Dicti tion onar ary y 3. A"tom A"tomati aticc Back"! Back"! And -eco -ecoer ery y

-DB'+ • • •

•

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

*"ll *orm o -DB'+  >d)ar *. Codd -"les o -DB'+ Conce!t o -o, Col"mn, Ta(le, Ta(le, -ecord , *ield , Attri("te Conce!t and Ty!es o -elations&i!

Q&at is DB'+ F Q &at is *"ll orm o DB'+ F Q>@!lain Adanta)es o DB'+

Q&at is -DB'+ F  Q -"les *or -DB'+ PACGA$>+ Q &at is -o and Col"mn F Q W&at is Attri("te F QW&at is Ta(le F Q &at is -ecord and *ield F Q>@!lain ty!es o -elations&i!.

Conce!t and Terminolo)y o Data, =normation, Data(ase and DB'+ 1; W&at is Data, =normation and Data(aseF 7; >@!lain DB'+ it& Adanta)es. 0; >@!lain Dierence Beteen Data and =normation 6; &at is -DB'+F >@!lain it& >.*. Codd -"les. 3; >@!lain -o, Col"mn, Col"mn, Ta(le, -ecord, *ield and Attri("te. 'icrosot Oice 70 (y Bi(le -"les or desi)nin) )ood )o od ta(les, Data =nte)rity Constaints Cons taints and -elations&i!s in a ta(les.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4e O(4ect cti iee

:

Unit/Block No.: Date:

Week No.: Time :

1-

Lesson no. :

,=

-"les or desi)nin) )ood ta(les, Data =nte)rity Constraints and -elations&i!s in ta(les. 1;1;-"l "les es or or Desi) esi)ni nin) n) Ta(le (le 7; Data =nte)rity constraints 0;-elations&i! =n Ta(le. Ta(le. C&alk, D"ster, Pointer.

Aids : Pre!aration : K -eie : K =ntod"ction : Desi)nin) $ood Ta(le Ta(le Wit& -elations&i!. 'otiation : Data inte)rity in -elations&i! o Ta(les. Presentation : To!ics

=normation Points Tell

-"les or Desi)nin) Ta(le

•

*ield name '"st (e Beteen  to 733 C&aracters. +elect !ro!er Data ty!e o *ield. +et t&e !rimary key. *or NOD"!lication +et Dea"lt Ial"e . *or Blank Ial"e +et Ialidation Ialidation o *ield +et *ormat o N"m(er *ield +et es es o *ield or Data '"st Be entered +et alidation te@t or Ialidation Ialidation >rror  W&at is Data =nte)rity F Primary key C&eck Constraints Dea"lt Constraints *orei)n Gey

•

Uni9"e Constraints

•

• • • • • •

Data =nte)rity Constraints

• • • •

-elations&i! =n Ta(le

• •

APPL=CAT=ON +U''A+U''A-  A++=$N'>NT/ U>+T=ON

: : :

->*> ->*>-> ->NC NC> >  N>MT L>++ON L>++ON

: :

W&at is -elations&i! F >@!lain Ty!es o -elation s&i! 1. One  to o one 7. One  to  many 0. 'any to m many 6. 'any  to to  one

+!ot &ints / "estion Ask; Q W&at is Ta(leF Ta(leF Q&at is -o and Col"mnF Q W&at are t&e r"les o Ta(le Ta(le Desi)nin) F

Q&at is Data =nte)rityF Q&at is Primary keyF Q &at is C&eck Constraints F QW&at is Dea"lt Constraints F QW&at is *orei)n GeyF Q W&at is Uni9"e GeyF Q&at is -DB'+ F Q &at is -elations&i!F Q >@!lain Ty Ty!es !es o -elations&i!.

-"les -"les o Desi)ni Desi)nin) n) Ta(le a(le it& it& Data Data =nte)rit =nte)rity y and -elati -elations& ons&i! i! 1; >@!lain >@!lain -"le o Desi)nin) Desi)nin) Ta(le Ta(le . 7; >@!lai >@!lain n Data inte)r inte)rity ity . 0; Dierence Dierence Beteen Beteen Primary Primary key and *orei)n *orei)n key 6; >@!lain >@!lain C&eck, Dea"lt and Uni9"e Constraints Constraints 'icr 'icroso osot t Access ccess 70 70 (y D"mm D"mmies ies . Creatin) Ta(le Ta(le Usin) Dierent Iies Iies

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4e O(4ect cti iee

:

Unit/Block No.: Date:

Week No.: Time :

1/

Lesson no. :

,1

Creatin) Ta(le Usin) Dierent Iies Iies 1; 1; +tar +tartt T& T&ee 's 'sA Acc cces ess sa aak akin in) ) t&e t&e Acces ccess; s; 7; Create Data(ase and +tore data(ase 0; terms o -o, Col"mn, Ta(le, Ta(le, -ecord and *ield 6; Create Ta(le Ta(le in Desi)n Iie 3; Create Ta(le (y Usin) Winterin) Data

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod"ction : +tart T&e Access and Create Data(ase And Ta(les Ta(les 'otiation : Create data(ase and +tored Data in T&e Ta(les. Presentation : To!ics +tart T&e 'sAccess aakin) t&e Access; Create Data(ase and +tore data(ase

=normation Points Tell •

•

•

terms o -o, Col"mn, Ta(le, Ta(le, -ecord and *ield

• • •

•

•

Create Ta(le in Desi)n Iie

•

•

• •

• •

+tart\Pro)rams'icrosot oice Access +elect Blank Data(ase o *ile men" Or  Task Task Panel Pan el +tore T&e Data(ase it& Data(ase Data(ase name =n +tora)e Drie -o means Horinter t&e Data in t&e ta(le

+!ot &ints / "estion Ask; QHo Aakin) Aakin) t&e 's Access F QHo to Create Data(ase in 'sAccess F

Q&at is -o F Q&at is Col"mnF Q&at is Ta(le F Q&at is -ecordF Q&at is *ieldF .

Q>@!lain Create Ta(le =n Desi)n Iie. Q>@!lain Data ty!es Q>@!lain Data ty!e  !ro!erties

 Create Ta(le (y Usin) Wi
•

•

•

•

Create Ta(le By >nterin) Data

•

•

APPL=CAT=ON +U''A- A++=$N'>NT/ U>+T=ON

: : :

->*>->NC>  N>MT L>++ON L>++ON

: :

+elect ta(le O(4ect and Create Ta(le (y "sin) Wi
Qrite ste!s o create ta(le (y "sin) i
Qrite t&e ste!s or create ta(le (y enterin) data

Create Data(ase and Ta(le in 'sAccess 1; Ho to A Aakin) in 'sAccessF. 'sAccessF. 7; Ho To To Create Create Data(ase Data(ase in 'sAccess 'sAccess F 0; >@!lain >@!lain Data ty!es ty!es =n 'sAccess 'sAccess.. 6; >@!lain >@!lain Ty!es Ty!es O Create Ta(l Ta(le. e. 3; Ho to create create ta(le in Desi)n Desi)n Iie IieFF 5; >@!lain >@!lain Pro!erties Pro!erties o Data Ty! Ty!es. es. ; Write Write +te!s or Create Create ta(le (y "sin) Winterin) Data. Com!lete -eerence o 'icrosot Access  7 . Creatin) "eries # *orms

INDUSTRIAL TRAINING TRAINING INSTITUTE LESSON PLAN  Name : Trade :

J.G.C(AUD(ARI

COPA

Unit/Block No.: Date:

To!ic / Aim : O(4ectie :

Creatin) "eries # *orms

Aids : Pre!aration :

C&alk, D"ster, Pointer.

K

Week No. Time :

13

Lesson no. :

,,

1; Ho to create "eries and *orm. =m!ortance o 9"ery and orm in !ro)rammin) enironment.

-eie :

K =ntod"ction : 'otiation : Presentation : To!ics =ntrod"ction

Ho to create 9"eryF

=normation Points Tell "eries i it&in a DB'+ system ca can do do mo more t& t&an dis!lay ansers to t&e 9"estions yo" ask. T&ey can act"ally !erorm ario"s actions on t&e data in yo"r data(ase. Action 9"eries are 9"eries t&at can add, c&an)e, or delete m"lti!le records at one time. T&e added (eneit is t&at yo" can !reie t&e 9"ery res"lts in Access (eore yo" r"n it. 'icrosot Access !roides 6 dierent ty!es o Action "eries: 'akeTa(le, A!!end, U!date, and Delete. Q+tart 'icrosot Access and o!en yo"r data(ase Click on t&e "eries ta( o yo"r data(ase. QClick on t&e Ne ("tton and t&en select Desi)n Iie to start creatin) a 9"ery in Desi)n ie. C&oose t&e ta(les or ot&er 9"eries yo" is& to 9"ery QC&oose t&e ields rom t&e ta(le/9"ery yo" ant. E"st like normal 9"eries, yo" ill oten &ae to s!eciy a criterion in yo"r 9"ery to )et t&e res"lts yo" ant. Q -"n t&e 9"ery to make s"re yo"r 9"ery contains t&e res"lts are yo" are lookin) or.  No, yo" need to c&an)e t&e t& e ty!e o 9"ery t&is is. =n t&e middle o t&e screen, click t&e "ery ty!e ("tton. C&an)e to 'akeTa(le. +!eciy t&e name o t&e ne ta(le and i it is )oin) to (e created in t&e data(ase yo" are c"rrently orkin) rom, or anot&er data(ase.

+!ot &ints / "estion Ask; Q W&at is t&e "ll orm o DB'+F

Q W&at is Action "ery F Q Ho can e create 9"eryF.

=

yo" are creatin) t&e ta(le or a se!arate

data(ase, yo" ill &ae to s!eciy t&e location o it. -"n t&e 9"ery. QBeca"se yo" r"nnin) an action 9"ery t&at makes c&an)es to yo"r oerall data(ase str"ct"re, 'icrosot Access ill ask i yo" ant to cancel t&e o!eration. C&oose t&e ields rom t&e ta(le/9"ery yo" ant. Q Click es to close t&e dialo) (o@, create t&e ne ta(le and ret"rn to "ery Desi)n Iie. Q+ae yo"r 9"ery, and yo"8re done. 'icrosot Access ill ask i yo" ant to cancel t&e o!eration. Create a *orm

Q>ns"rin) t&e [*orms[ ta( is selected, click [Ne[.

Q W&at is *ormF

Q +elect [*orm Wi
Q >@!lain Creation o a ormF

Q +elect t&e ields t&at yo" need on yo"r orm and click [Ne@t[. =n t&is case, e only need t&e "ser to enter irst name and last name, so e c&oose t&ose to ields: QC&oose &ic& layo"t yo"8d like yo"r orm to "se. Leae t&is at t&e dea"lt [Col"mnar[; and click [Ne@t[: QC&oose &ic& style yo"8d like yo"r orm to "se. Leae t&is at t&e dea"lt [Clo"ds[; and click [Ne@t[: QC&oose a name or yo"r orm and click [*inis&[: APPL=CAT=ON

:

+U''A-

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>

:

"eries are "sed to do task and orms are collectors o m"lti!le o(4ects. 1; W&at is t&e "ll orm o DB'+F 7; W&at is "ery and *ormF 0; >@!lain "ery creation. 6; >@!lain orm creation. .

 N>MT L>++ON L>++ON

:

Creatin) -e!ort Usin) Dierent Iies

INDUSTRIAL TRAINING TRAINING INSTITUTE LESSON PLAN  Name : Trade :

J.G.C(AUD(ARI

COPA

Unit/Block No.: Date:

To!ic / Aim : O(4ectie :

Creatin) -e!ort Usin) Dierent Iies

Aids : Pre!aration :

C&alk, D"ster, Pointer.

K

Week No. Time :

13

Lesson no. :

,-

1; Ho to create a -e!ortF =m!ortance o -e!ort in !ro)rammin) enironment and DB'+.

-eie :

K =ntod"ction : 'otiation : Presentation : To!ics =ntrod"ction

Create -e -e!ort

=normation Points Tell -e!orts or)ani
+!ot &ints / "estion Ask; Q W&at is t&e -e!ortF

Q Ho can e create -e!ortF

QTy!e t&e name yo" ant to )ie yo"r re!ort. QClick OG. Access saes t&e re!ort. o" o" can no access t&e re!ort (y "sin) t&e Nai)ation  !ane Access re!orts created sim!ly (y "sin) t&e -e!ort  ("tton &ae seeral sections. s ections. T&ey are detailed in t&e olloin) ta(le. -e!ort Header  A!!ears at t&e to! o t&e irst  !a)e and dis!lays t&e re!ort re !ort title. Pa)e Header  A!!ears at t&e to! o eery !a)e and dis!lays t&e &eadin)s ield la(els; or eac& col"mn. Pa)e *ooter  A!!ears at t&e (ottom o eery !a)e and dis!lays t&e !a)e n"m(er and total n"m(er o  !a)es. Detail +ection  A!!ears (eteen t&e !a)e &eader and !a)e ooter and dis!lays t&e records rom t&e ta(le or 9"ery. -e!ort *ooter  T&is section is o!tional. A!!ears on t&e last !a)e o t&e re!ort and dis!lays s"mmary inormation s"c& as )rand totals. Use t&e -e!ort Wi
o" can also "se t&e -e!ort Wi
Q-e!eat Q-e!eat ste!s 1 and 7 or eac& ta(le rom &ic& yo" ant to select ields. QClick Ne@t. T&e -e!ort Win)lis&. >n)lis&. Access ill )ro"! all o t&e data or t&e Administration de!artment to)et&er, all o t&e data or t&e Com!"te Com!"terr +cience +cience de!artm de!artment ent to)et&er to)et&er,, and and all all o t&e t&e data data or or t&e >n >n)l )lis& is& de!ar de!artm tmen entt to)et&er. QClick to select t&e ield (y &ic& yo" ant to )ro"! yo"r data. o" may not see t&is !a)e o t&e i
:

+U''A-

:

A++=$N'>NT/ U>+T=ON ->*>->NC>

: :

 N>MT L>++ON L>++ON

:

-e!orts or)ani
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie :

Aids : Pre!aration : K

Unit/Block No.: Date:

Week No. Time :

15

Lesson no. :

,/

=ntrod"ction to netork, Client +erer # Peer to Peer Netork  1; Netorkin). 7; Clie Client nt and and +er +ere err. 0; Peer Peer to Peer Peer Net Netork ork.. C&alk, D"ster, Pointer. =m!ortance o Netorkin) in Com!"tin) >nironment..

-eie :

K =ntod"ction :  Netorkin). 'otiation : Presentation : To!ics  Netork 

Client +erer  Netork 

+!ot &ints / "estion Ask; A com!"t !"ter net etork or data net netork is a Q W&at is t&e NetorkF telecomm"nications netork t&at allos allos com!"te com!"ters rs to e@c&an)e e@c&an)e data. data. =n com!"te com!"ter  r  netorks, netorks, netorked com!"tin) deices !ass data to eac& eac& ot&er ot&er alon) alon) data data connec connecti tions ons.. Data Data is transerred in t&e orm o !ackets =normation Points Tell

QClient/serer is a !ro)ram relations&i! in &ic& one !ro)ra !ro)ram m t&e t&e client client;; re9" re9"es ests ts a ser seric icee or  Q W&at is Client+erer netorkF reso"rce rom anot&er !ro)ram t&e serer ;. ;. QAlt&o")& t&e client/serer model can (e "sed  (y !ro)rams it&in a sin)le com!"ter, it is a more im!ort im!ortant ant conce!t conce!t or netorkin) or netorkin)..   =n t&is case, t&e client esta(lis&es a connection to t&e serer  oer a local area netork LAN LAN;; or ide idear area ea netork W WAN AN;, ;, s"c& as t&e =nternet =nternet.. Once t&e ser serer er &as &as "l "lil ille led d t&e t&e clie client nt8s 8s re9" re9"es est, t, t&e t&e connection is terminated. o"r We( (roser  We( (roser  is a client !ro)ram !ro)ram t&at &as re9"ested re9"ested a serice serice rom a serer] in act, t&e serice and reso"rce t&e serer   !roided is t&e deliery delier y o t&is We( We( !a)e  !a)e..

QC QCom om!"t !"ter er transa transact ction ionss in &ic& &ic& t&e t&e serer  serer  "l "lil ills ls a re9" re9"es estt made ade (y a clie client nt are are ery ery common and t&e client/serer model &as (ecome one o t&e central ideas o netork   com!"tin). 'ostt ("siness 'os ("siness a!!lica a!!lication tionss "se t&e client/ client/ser serer  er  model as does t& e =nternet8s main  !ro)ram, TCP/=P TCP/=P.. QBot& client !ro)rams and serer !ro)rams are oten oten !art !art o a lar) lar)er er !ro)ra !ro)ram m or a!!li a!!licat cation ion.. Beca Beca"s "see m" m"lt lti! i!le le clie client nt !ro) !ro)ra rams ms s&ar s&aree t&e t&e seri serices ces o t&e t&e same same serer serer !ro)ra !ro)ram, m, a s!eci s!ecial al serer called a daemon daemon may  may (e actiated 4"st to aait client re9"ests. Q=n marketin), t&e client/serer as once "sed to distin)"is& dis distr tri(" i("ted ted com com!"t !"tin in) ) (y !erso erson nal com!"ters PCs PCs;; rom t&e monolit&ic, centrali
QA !eerto!eer P7P; netork is created &en Q W&at is a !eer to !eer to or more ore PCs are are conne onneccted and s&a s&are netorkF reso"rces it&o"t )oin) t&ro")& a se!arate serer  com!"ter. Q A P7P netork can (e an ad &oc connection a co"!le co"!le o com!"te com!"ters rs connecte connected d ia a Uniers Uniersal al +erial B"s to transer iles. Q Q A P7P P7P net netor ork k also also can can (e a !erm !erman anen entt inrastr"ct"re inrastr"ct"re t&at links a &aldo
APPL=CAT=ON

:

+U''A+U''A- 

:

A++=$N'>NT/ U>+T=ON ->*>->NC>

: :

 N>MT L>++ON L>++ON

:

 Netorkin) is "sed in many areas ar eas like railay,telecome sector Yetc A com!"te com!"terr netork netork or data netork netork is a telecom telecomm"n m"nicat ications ions netork netork t&at t&at allos com!"ters to e@c&an)e data. 1; W&at is t&e NetorkF 7; W&at is a client serer netorkF 0; W&at is a  !eer to !eer netorkF . Conce!ts o Pro@y +erer, *ireall +erer # Netork To!olo)ies.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

Week No.: Time :

15

Lesson no. :

To!ic / Aim : O(4ectie :

Understandin) conce!ts o Pro@y +erer, *ireall +erer # Netork To!olo)ies

Aids : Pre!aration :

C&alk, D"ster, Pointer.

K

,0

1; +erer Details 7; Dierent Ty!es o +erers # Netork To!olo)ies 0; Dierence (eteen Pro@y , *ireall and ot&er +erers

-eie :

K =ntod" =ntod"cti ction on : +ere +ererr and Net Netor ork k to!olo to!olo)y )y 'otiation :

Usin) +erers like *TP or ile s&arin).

Presentation : To!ics A(o"t Pro@y +erer, *ireall +erer

=normation Points Tell •

•

 Netork To!olo)ies To!olo)ies

=t is a com!"ter or  Q W&at is +ererF com!"ter !ro)ram &ic& mana)es access Q W&at is t&e Dierence to a centrali
•

 !ro@y serer are (ot& com!onents o  netork sec"rity. Pro@y +erer acts as a ireall (eteen

•

internal and e@ternal netork. *irealls can (lock !orts and !ro)rams

•

•

•

+!ot &ints / "estion Ask;

t&at try to )ain "na"t&ori
Q W&y Netork t&e ario"s elements links, nodes, etc.; To!olo)ies are "sedF o a com!"ter $et#r6 . Ty!es o Netork Netork To!olo) o!olo)ies ies are B"s To!olo)y, -in) To!olo)y, +tar To!olo)y etc.

Terminolo)y Terminolo)y :

•

LAN: LAN sta stands or Loca ocal Area rea Q W&at are netork  Netork &ic& is "sed "s ed or netorkin) in terminolo)iesF

•

 !artic"lar oice or ("ildin). ("ildin ). 'AN: 'AN: 'AN 'AN stand standss or 'etr 'etro!o o!oli lita tan n

•

Area Netork &ic& is a lar)e com!"ter $et#r6 t&at s!a ns a metro!olitan area or cam!"s. WAN: WAN stan stands ds or or Wide Area rea

•

 Netork &ic& is a $et#r6  t&at  t&at coers a (road area "sin) dierent comm"nication medi"ms. To!olo)y: -eers to layo"t o  

•

a $et#r6. B"ss To!o B" !olo lo)y )y::

•

to!olo)y  & o se com!onents are connected (y ("s (ar. -in) To!olo)y: =t is a to!olo)y in &ic&

•

eac& node connects to e@actly to ot&er  nodes. +tarr To! +ta o!olo) olo)y: y: =n t&is to!o to!olo)y lo)y,, eer eery y

+im im!l !les estt

Net Ne tor ork  k 

node is co node conn nnec ecte ted d to a ce cent ntra rall no node de called a &"( or sitc&. APPL=CAT=ON

:

+U''A+U''A- 

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>

:

 N>MT L>++ON L>++ON

:

Netork Netork To!olo) o!olo)ies ies makes makes netork netork ork ork easily easily.. +erer +erer makes makes netork netork and inormation ast and sec"re. 1; W&at is t&e "ll orm o LAN, 'AN, WANF WANF 7; W&at is To!olo)yF 0; Dierence (eteen Pro@y +erer and *ireall Pro@y +erer. 6; $ie t&e dierence (eteen netork to!olo)ies.  Netork Com!onents

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ec 4ectie : Aids : Pre!aration : K

Unit/Block No.: Date:

Week No.: Time :

15

Lesson no. :

,>

Understandin) Netork Com!onents 1; Netork Com om!o !one nent ntss 7; Use o Netork Com!onents C&alk, D"ster, Pointer.

-eie :

K =nto =ntod"c d"cti tion on : Net Netork ork Com! Com!one onents nts 'otiation :

 Netork Com!onent "sed in la( or netorkin).

Presentation : To!ics  Netork Com!onents

=normation Points Tell •

•

•

'odem

•

• •

•

•

+itc&

•

•

•

•

+!ot &ints / "estion Ask;

Basic asical ally ly t&e t&e Hard ardar aree e "se or  or   W&at is Netork  Netorkin) is called Netork  Com!onentsF Com!onents. $enerally netork com!onents incl"des W&y it is essential to "se deices deices like like  )ateays, ro"ters, ro"ters, netork  netork com!onents in netorkF  (rid)es, sitc&es, sitc&es, &"(s,  &"(s, and re!eaters and re!eaters.. A!art rom traditional netork deices it also incl"des &y(rid netork com!onents or &y(rid netork. 'odem stands or 'Od"lator D>'od"lator. 'odem is knon as Data P&one. =t is "sed to send and receie data to t&e com!"ter "sin) !&one line. =t is Async&rono"s deice. Ty!es o modems are internal modem, e@ternal modem and remoa(le modem. +itc& is "sed to connect more t&an one com!"ter in a LAN. Accordin) to t&e s!eed o netork e "se sitc&es. *or *or (ette (etterr ork ork mo more re t&an t&an one sitc& sitc& can can (e connec connecte ted d to net netork ork &ic& &ic& is called daisy c&ainin). =t orks on datalink layer.

Q W&at is "ll orm o 'odemF Q W&y it is "sedF Ty!es !es o 'odem. Ty

W&ere

e "se sitc&F

Ty!es !es o Ty

+itc&.

-o"ters

•

• •

•

•

 Netork Brid)e

•

• •

•

$ateay

•

• •

Terminolo)y Terminolo)y :

•

•

•

Ty!es !es o ro"ter. -o"ter is a !&ysical deice &ic& is "sed Ty Protocol "sed or ro"tin) in netork layer. o !ackets. =t is called as a $ateay deice. =n net netor ork k Wirele reless ss and and Wired red (ot& (ot& ro"ters are "sed. =t orks like sitc& and (rid)e in &ic& it ilters !ackets and "sed to connect to netorks. -o"ter diides netork lo)ically. Brid)e is eit&er a sotare or &ardare Dierence (eteen &ic& is "sed to connect to or more sitc& and (rid)e. netorks. Brid)e orks on t&e data link layer. =t decides t&at in netork eit&er sto! or  orard netork traic. =t is almost same like sitc& ("t it allos only only one neto netork rk (o" (o"nda ndary ry &ere &ere as sitc& allos 6 or more t&an it. T&is deice is !laced at a netork node and interaces it& anot&er netork t&at "ses dierent !rotocols. =t orks on O+= on O+= layers 6 to . . $ateay is related to ro"ter and sitc&es  (ot&. 'odem: =t is a deice t&at mod"lates an analo) [carrier[ si)nal s"c& as so"nd; to encode di)ital inormation and t&at also demod"lates s"c& a carrier si)nal to decode t&e transmitted inormation, s"c& as a com!"ter comm"nicatin) it& anot&er com!"ter oer a tele!&one netork. +itc&: =t is a deice t&at allocates traic rom one netork se)ment to certain lines &ic& connect t&e se)ment to anot&er netork se)ment. Unlike a &"(, a &"(, a sitc& s!lits t&e netork traic and sends it to dierent destinations rat&er t&an to all systems on t&e netork. =t orks on O+= on O+= layer 7. 7. -o"ter: =t is a s!eciali
•

•

APPL=CAT=ON

:

+U''A+U''A- 

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>

:

 N>MT L>++ON L>++ON

:

QW&ere to "se netork  Netork Brid)e: a deice t&at connects com!onentsF m"lti!le netork se)ments alon) se)ments alon) t&e data t&e data link layer . =t orks on O+= layer  7. $ateay: t&is deice is !laced at a netork node and interaces it& anot&er netork t&at "ses dierent  !rotocols. =t orks on O+= layers 6 to . .

Netork Netork Com!one Com!onents nts are t&e e9"i!me e9"i!ments nts "sed in t&e netork. netork. Accord Accordin) in) to t&e need o t&e netork, netork com!onents are "sed. 1; W&at is t&e "ll orm o 'odemF 7; W&at is ro"terF 0; Dierence (eteen sitc& and (rid)e.  Netork Ca(les, Wireless Netorkin) # Bl"e Toot& Toot& Tec&nolo)y Tec&nolo)y

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4ectie :

Aids : Pre!aration : K

Unit/Block No.: Date:

Week No.: Time :

1

Lesson no. :

Understandin) Netork Ca(les, Wireless Netorkin) # Bl"e Toot& Tec&nolo)y 1; Ty!es !es o ca(les. 7; Wireless tec&nolo)y 0; Bl"etoot& tec&nolo)y. C&alk, D"ster, Pointer.

-eie :

K =ntod"ction :  Netorkin) Ca(les and 'edi"ms. 'otiation : Presentation : To!ics  Netork Ca(les

=normation Points Tell •

•

•

•

•

+!ot &ints / "estion Ask;

 Ty!es o Netork  Netorkin) ca(les are "sed to connect  Ty!es one one net netork ork deic deicee to ot&er ot&er net netork  ork  Ca(les. deic ices or to conne onnecct to or more com!"ters to s&are !rinter  s&are !rinter , scanner  etc.  etc. Dierent ty!e ty!ess o netork ork ca(l a(les like Coa@ial ca(le, O!tical i(er  ca(le, Tisted isted Pair Pair ca(les are "sed de!endin) on t&e netork8s to!olo)y, to!olo)y, !rotocol and  !rotocol and si'=; >'=; rom ot&er ot&er ire  !airs and rom e@ternal so"rces. T&is ty!e ty!e o ca(l ca(lee is "sed "sed or or &om &ome and and cor!orate >t&ernet netorks. >t&ernet netorks. An o!tical i(er ca(le consists o a center  )lass core s"rro"nded (y seeral layers o !r !ro otec ecttie mater eriial. T&e o"t "teer  ins"l in s"lat atin) in) 4ac 4acket ket is ma made de o Tel lon on or  PIC to !r !reeen entt inter erere ren nce ce.. =t is e@!ensie ("t &as &i)&er (andidt& and can transmit data oer lon)er distances. Coa@ial lines conine t&e electroma)netic ae to area inside t&e ca(le, (eteen t&e center cond"ctor and t&e s&ield. T&e transmission o ener)y in t&e line occ"rs totally t&ro")& t&e dielectric inside t&e ca(le (eteen t&e cond"ctors.

,

Wireless Netorkin)

•

•

•

Bl"e Toot& Tec&nolo)y

• •

•

•

•

Terminolo)y Terminolo)y :

•

APPL=CAT=ON

:

+U''A-

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>

:

 N>MT L>++ON L>++ON

:

Usin) =nrared +i)nals or -adio W&at is Wireless *re9"ency +i)nals connect com!"ter or  Tec&nolo)yF any ot&er deice in t&e &ome or any ot&er  W&at is Ad&oc  !lace is called Wireless Netorkin).  NetorkF To ty!es o Wireless LANs are t&ere. 1; =nrastr =nrastr"ct" "ct"re re Netork Netork 7; Ad&oc Ad&oc  Netork. Wirele Wireless ss Netork Netork medi"m medi"mss are -adio -adio Waes Waes and 'icroae. W&at is Bl"etoot& Bl"e Toot& Toot& is a Wireless Protocol. =t is "sed "sed to conne connect ct deic deices es it& it&o"t o"t tec&nolo)yF "sin) LAN ("t t&ose deices m"st (e in W&ere e "se Bl"etoot& tec&nolo)y no daysF t&e ran)e o Bl"etoot&. Bl"et "etoot& ot& can comm"nica nicatte "! to 1'BP+ +!eed. =t can transmit t&e si)nals comes in t&e ran)e o  to 0 eet. Bl"e Bl"eto toot ot& & net netor ork k is com com!ara !arati tie ely ly sloer t&an ii. Protocol: A !rotocol is a set o r"les and standards t&at (asically deine a lan)"a)e t&at deices can "se to comm"nicate.

1; Ty!es o Netork Ca(les. 7; Use o dierent ca(les. 0; W&at is Wireless Tec&nolo)yF 6; Dierence (eteen Bl"etoot& and Wii. O+= Layer 'odel # Netork Protocol

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4e O(4ect cti iee :

Unit/Block No.: Date:

Week No.: Time :

1 6 Hr s

Lesson no. :

7?

O+= Layer 'odel # Netork Protocol 1; 1; +tan +tanda dard rd 'o 'ode dell or or Data Data Comm Comm"n "nic icat atio ions ns 7; +trate)y or connectin) &ost com!"ters and ot&er comm"nicatin) e9"i!ment. 0; Deines necessary elements or data comm"nication (eteen deices.

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod"ction :  Netork Comm"nication 'odel 'oti 'o tiat ation ion : O+= O+= O!e O!en n +yst +ystem emss =nter =ntercon connec necti tion; on; is is reer reerenc encee mode modell or or &o &o mess messa)e a)ess s&o" s&o"ld ld  (e transmitted (eteen any an y to !oints in a telecomm"nication netork  Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; O+= Layer 'odel: A""licati#$ la*er: User Leel Processin). Q W&at is t&e "ll orm o O+=F E+. Telnet, *TP, 'ail, HTTP Pre!e$tati#$ la*er:  Data -e!resentation Q HTTP, HTTP, telnet, and t! # +ynta@.  !rotocols r"n in &ic& E+. =+O Presentation layerF Se!!i#$ la*er:  +ync Points and Dialo)s. E+. =+O +ession Q >@!lain layer o O+= Tra$!"#rt la*er:  -elia(le >nd to >nd.. model. >@. TCP, UDP. Net#r6 la*er:  Unrelia(le T&r" '"lti  Node Netork. E+. M.73 Pkt, =P Data Li$6 la*er:  -elia(le Across P&ysical Line. E+. LAPB, HDLC  Unrelia(l e Wire, Telco Ph*!ical la*er: Unrelia(le Line E+. >=TH>-N>T, AT'  Netork Protocol: TCP4IP 5Tra$!'i!!i#$ 5Tra$!'i!!i#$ C#$tr#l Pr#t#c#l7 Pr#t#c#l7 Q To &ic& O+= layer TCP is knon as a connection does TCP/=P !rotocol oriented !rot !rotoc ocol ol,, &ic& &ic& mean meanss t&at t&at a  (elon)F connecti connection on is esta(lis esta(lis&ed &ed and maintai maintained ned "ntil t&e a!!lica t&e a!!lication tion !ro)rams !ro)rams at eac& end Q W&at is t&e "ll orm o +'TP F &ae com!leted e@c&an)in) messa)es. messa)es. ;TP 5;ile Tra$!&er a$!&er Pr#t#c# Pr#t#c#l7: l7: T&is is a  !o!"lar ay to transer iles rom mac&ine Q >@!lain *TP !rotocol. to mac&ine across a netork. S%TP 5Si'"le %ail Tra$!&er Pr#t#c#l7: =t8s a set o comm"nication )"idelines t&at allo sotare to transmit email oer t&e =nternet. •

•

•

•

•

•

•

•

•

•

•

(TTP 5(*"er Te+t e+t Tr Tra$!&er a$!&er Pr#t#c#l7: Pr#t#c#l7: HTTP HTTP is t&e "nderly "nderlyin) in)  !rotocol "  !rotocol "se sed d (y t&e World t&e World Wide We(. We(.

•

Lo)ical And P&ysical Addresses:

•

•

Classes O Netork:

•

•

•

•

APPL=CAT=ON +U''A-

: :

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

POP POP 5P#!t 5P#!t O& O&&ic &icee Pr#t Pr#t#c #c#l7 #l7:: POP is an a!!lication a!!lication layer internet standard !rotocol "sed (y local email clients to retriee e mail ail rom rom remo remote te ser serer er oe oerr a TC TCP/ P/=P =P connection. L#9ical Addre!!: An address )enerated  (y t&e CPU is commonly reerred to as a lo)ical a lo)ical address. T&e set o all lo)ical addresses )enerated (y a !ro)ram is knon as lo)ical address s!ace. Ph*!ical Addre!!:  Address seen (y t&e memory "nit t&at is, t&e one loaded into t&e memoryaddress re)ister o t&e memory is commonly reerred to as  !&ysical address. T&e set o all !&ysical !& ysical addresses corres!ondin) to t&e lo)ical addresses is knon as !&ysical address s!ace. Cla!! A: T&e &i)&order (it in a class A address is alays set to
QW&at is t&e Lo)ical AddressF Q W&at is t&e P&ysical AddressF

QW&at is t&e ran)e o Class B =P AddressF AddressF QW&ic& Class is resered or m"lticast addressesF

OSI re&ere$ce '#del  is to make netorks more mana)ea(le and to aid t&e  !ro(lem o moin) data (eteen ( eteen com!"ters.And c#''u$icati#$! "r#t#c#l  is a system o di)ital r"les or data e@c&an)e it&in or (eteen com!"ters. 1; W&at is t&e "ll orm o +'TP F 7; W&at is t&e Lo)ical AddressF 0; >@!lain layer o O+= model 6; W&at is t&e "ll orm o O+=F

Conce!ts o *=->WALL *=->WALL # DHCP DHCP +erer 

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim :

Unit/Block No.: Date:

Week No.: Time :

1 0 Hr s

Lesson no. :

,3

Conce!ts O *=->WALL *=->WALL # DHCP +erer  1; >ncry!ted A"t&entication 7; Iirt"al Priate Netorkin) 0; Protect yo"r netork or PC 6; +"!!ort o dynamic allocation o Netork Addresses C&alk, D"ster, Pointer.

Aids : Pre!aration : K -eie : K =ntrod"ction :  Netork +ec"rity 'otiat 'otiation ion : Beneit Beneitss o o *irea *ireall ll are mon monito itorr net netork ork traic traic,, (lock (lock &ackers, &ackers, (lock (lock Tro4an Tro4ans. s. =n addition to !rotectin) !ersonal inormation, a ireall orks to !rotect yo"r act"al com!"ter. Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; Conce!ts O F 8hat F 8hat i! &ireall *ireall is sotare or &ardare *ireall  (ased netork sec"rity system sec"rity system t&at controls Q *ireall is "sed or t&e incomin) and o"t)oin) netork traic &ic& !"r!oseF  (ased on a!!lied r"le r" le set. A ireall esta(lis&es a (arrier (eteen a tr"sted, sec"re internal netork and anot&er netork e.)., t&e =nternet; t&at is not ass"med to (e sec"re and tr"sted. =t is ty!ically !laced at t&e ed)e o a system and acts as a ilter or "na"t&ori
•

•

•

Conce!t O DHCP +erer 

•

Q W&at is t&e "ll orm Dynamic (ost Coni)"ration Protocol o DHCPF +tandard !rotocol Deined (y -*C 1361 s"!erseded (y -*C Q W&at is DHCP F 7101; -"ns oer UDP Utili@ten >@ tensio sion n o BOOT BOOTP P !roto !rotocol col "sed "sed or  sim!le interaction; Uses clientserer model s"!!ort o dynamic allocation o Netork  Addresses =P addresses are assi)ned ondemand Aoid Aoid man"al =P coni)"ration

•

+"!!ort mo(ility o la!to!s

• • •

• •

•

• •

•

Beneits O DHCP:

• • • • • •

APPL=CAT=ON

:

+U''A+U''A- 

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

C#$&i9urati#$ i! reliable -ed"ced eort. Central control.  No d"!licate =P addresses. >asy to "!date. Beneits to t&e clients.

*irealls are sotare !ro)rams or &ardare deices t&at ilter t&e traic t&at los into yo" PC or yo"r netork t&ro")& a internet connection. T&ey sit t&ro")& t&e data lo # (lock t&at &ic& t&ey deem (ased on &o # or  &at yo" &ae t"ned t&e ireall; &arm"l to yo"r netork or com!"ter  system. A ireal irealll is a system system desi)ned desi)ned to !reent !reent "na"t&or "na"t&ori@!lain Beneits o DHCP. Conce!t o =nternet, We( Broser, +earc& >n)ines # >'ail Comm"nication

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4e O(4ect cti iee :

Unit/Block No.: Date:

Week No.: Time :

12 6 Hrs

Lesson no. :

Conce!t o =nternet, We( Broser, +earc& >n)ines # >'ail Comm"nication 1; 1; +eri erice cess !ro !roid ided ed (y =nte =ntern rnet et.. 7; Access =nternet C&al C&alk, k, D"st D"ster er,, Com! Com!"t "ter er it& it& =nte =ntern rnet et conn connec ecti tii ity ty

-=

Aids Aids : Pre!aration : K -eie : K =ntod"ction : =nternet +erices # A!!lication 'oti 'o tiat ation ion : =nter =nternet net is ery ery amo amo"s "s no noada adays ys or or sati satis syi yin) n) !eo! !eo!le le it& it& ario" ario"ss seri serices ces related to eac& and eery dierent ield. =t is a ery ersatile acility &ic& can &el! yo" in com!letin) many tasks easily and coneniently it& e clicks. Presentation : +!ot &ints / To!ics =normation Points Tell "estion Ask; =ntrod"ction O E+. T&e =nternet is t&e !&ysical connection =nternet # &istory 1. A!!ly !!ly or or 4o( 4o(ss or or o millions o netorks. sc&ools  =ts t&e irst mass medi"m t&at inoles 7. *ill *ill o"t o"t )oe )oern rnm ment ent com!"ters and "ses di)itiT A-PAN>T as t&e netork netor k t&at (ecame (e came 0. C&ec C&eck k (an (ank k acc acco" o"nt ntss t&e (asis or t&e =nternet 6. Com Comm" m"ni nica cate te it& it& loosely &ierarc&ical netork o amily, riends and co netorks orkers Uses TCP/=P !rotocols and !acket 3. Do resea searc& rc& sitc&in). 5. Learn earn ne ne ski skill llss (# T# Acce!! Acce!! I$ter$et: I$ ter$et: . -ead ne nes  Com!"ter ?. Watc& tc& ide ideos os  'odem  Tele!&one Connection  +&ell or TCP/=P acco"nt rom t&e =+P •

•

•

•

•

•



=nternet (roser.

WWWWorld Wide We(;:

•

•

•

•

•

WWW WWW is t&e acron acronym ym or t&e t&e World rld QW&at is *"ll *orm O WWWF Wide We(.   =t is also commonly knon as JT&e We(. T&e WWW is &y!erte@t (ased inormation retrieal tool. T&e 8#rld T&e We(; is 8#rld 8ide 8ide 8eb T&e only a !ortion o &at makes "! t&e internet, internet, ("t it is t&e astest )roin) !art o t&e interne T&e "nctionality o t&e WWW is (ased on 0 main standards:  U-L Uniersal -eso"rce Locator; Hy!erte@t 'ark"!  HT'L Lan)"a)e; 

Terminolo)y Terminolo)y :

•

•

• •

• • • •

We( Broser 

•

+earc& >n)ine:

•

•

>mail Comm"nication:

HTTP Hy!erte@t transer Protocol; ISP5I$ter$et Serice Pr#ider7 : Proide =nternet Connection r#!er: !ro)rams "sed to e@!lore t&e =nternet. (#'e Pa9e: *irst &y!erte@t Doc"ment. I$ter$et Pr#t#c#l : Deines r"les and conentions or comm"nication (eteen netork deices (*"erte+t:  is (ased on t&is term. (T%L: Used to create We( !a)es. (TTP: Hy!erte@t transer Protocol URL: Uniersal -eso"rce Locator !

Q W&at is "ll orm o =+PF QW&at is U-LF Q W&at is "ll orm o HT'LF QW&at is "ll orm o HHTPF Q $ie name o !o!"lar e( (roser.

E+ .=nternet >@!lorer, A e( (roser or =nternet (roser is a  Netsca!e, 'o-Ps;.  !a)es +>-Ps;.

E+. Dierent email >lectronic mail, most commonly serice !roiders reerred to as email or email. $'ail =t is a met&od o e@c&an)in) di)ital a&oo 'ail messa)es rom an a"t&or to one or more Hot 'ail reci!ients. 'odern email o!erates across t&e =nternet t&e =nternet or  or ot&er  com!"ter  com!"ter netorks. netorks. T&e =nternet =nternet c&an)ed c&an)ed o"r lie enormo" enormo"sly sly]] t&ere t&ere is no do"(t do"(t a(o"t a(o"t t&at. t&at. T&e com!"ter is a i@ !art o eery modern oice, com!anies, sc&ools etc and also at o"r &ome and t&e )reatest !art &as also an access to t&e =nternet. T&e I$ter$et  is a )lo(al system o interconnected com!"ter netorks •

•

• • •

APPL=C APPL=CA AT=ON

:

+U''A-

:

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

1;>@!lain A!!lication O =nternet. 7;W&at is *"ll *orm O WWWF 0;$ie Dierent We( (roser name. Conce!t o Clo"d +tora)e # =nternet +ec"rity

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudahri COPA

To!ic / Aim : O(4e O(4ect cti iee :

Unit/Block No.: Date:

WeekNo.: Time :

1?

Lesson no. :

-1

Conce!t o Clo"d +tora)e # =nternet +ec"rity 1; 1; Hist Histor ory y # Adan danta ta)e )ess o Clo" Clo"d d +tor +tora) a)ee 7; Ho Clo"d +tora)e WorksF WorksF 0; =nternet +ec"rity # Ty!es o +ec"rity

Aids : C&alk, D"ster, Pointer. Pre!aration : K-eie : K =ntod"ction : Clo"d +tora)e # =nternet +ec"rity 'otiation : Clo"d stora)e serices may (e accessed t&ro")& a colocated clo"d com!"te serice, a e( serice a!!lication !ro)rammin) interace AP=; or (y a!!lications t&at "tili
•

History # Adanta)es o Clo"d +tora)e

Ho Clo"d +tora)e WorksF

F Cl#ud !t#ra9e  is a model o data stora)e &ere t&e di)ital data is stored in lo)ical !ools, t&e !&ysical stora)e s!ans m"lti!le m"lti!le serers and oten locations;, and t&e !&ysical enironment is ty!ically oned and mana)ed (y a &ostin) com!any. Used to create $U= (ased a!!lication. QClo"d com!"tin) is (elieed to &ae (een inented (y Eose!& Carl -o(nett Lickliderin t&e 125s it& &is ork on A-PAN>T to connect  !eo!le and data rom ro m any&ere at any time. Q Com!anies need only !ay or t&e stora)e t&ey t&ey act" act"al ally ly "se, "se, ty!i ty!ica call lly y an aer aera) a)ee o  cons"m cons"m!ti !tion on d"rin d"rin) ) a mo mont& nt&.. T& T&is is does does not mean t&at clo"d stora)e is less e@!ensie, only t&at t&at it inc"r inc"rss o!era o!erati tin) n) e@!en e@!enses ses rat&e rat&err t&an t&an ca!ital e@!enses. Q Clo"d stora)e !roides "sers it& immediate access to a (road ran)e o reso"rces and a!!lications &osted in t&e inrastr"ct"re o  anot&er or)ani
On t&e s"race, clo"d stora)e &as seeral adanta)es oer traditional data stora)e. *or e@am!le, i yo" store yo"r data on a clo"d stora)e system, yo"8ll (e a(le to )et to t&at data rom any location t&at &as =nternet access. o" o" o"ldn8t need nee d to carry aro"nd a !&ysical stora)e deice or  "se "se t&e t&e sam same com com!"te !"terr to sae sae and and retriee yo"r inormation. inormation. Wit& t&e ri)&t stora) stora)ee syste system, m, yo" yo" co"ld co"ld een een allo allo ot&er !eo!le to access t&e data, t"rnin) a  !ersonal !ro4ect into a colla(oratie eort.

Q W&at is Clo"d +tora)eF Q W&at are t&e Adanta)es o Clo"d +tora)eF

Q Ho Clo"d +tora)e WorksF

=nternet +ec"rity # Ty!es Ty !es o +ec"rity

•

=nternet sec"rity is a tree (ranc& o com!"ter sec"rity s!eciically related to t&e =nternet, oten inolin) (roser inolin) (roser sec"rity ("t sec"rity ("t also netork sec"rity on a more )eneral leel as it a!!lies to ot&er a!!lications or o!eratin) or o!eratin) systems on a &ole. =ts o(4ectie is to esta(lis& r"les and meas"res to "se a)ainst attacks oer t&e =nternet. T*"e! #& !ecurit*

Net#r6 la*er !ecurit*

TCP/=P &ic& stands or Transmission Control Protocol TCP; and =nternet Protocol =P; aka =nternet !rotocol s"ite can (e made sec"re it& t&e &el! o cry!to)ra!&ic met&ods and  !rotocols. T&ese !rotocols incl"de +ec"re +ockets Layer ++L;, s"cceeded (y Trans!ort Layer +ec"rity TL+; or e( traic, Pretty $ood Priacy P$P; or email, and =Psec or t&e netork layer sec"rity.

I$ter$et Pr#t#c#l Securit* 5IP!ec7

T&is !rotocol is desi)ned to !rotect comm"nication in a sec"re manner "sin) TCP/=P aka =nternet !rotocol s"ite. =t is a set o sec"rity e@tensions deelo!ed (y t&e =nternet Task orce =>T*, and it !roides sec"rity and a"t&entication at t&e =P layer (y transormin) data "sin) encry!tion. !ecurit* t#6e$ +ome online sites oer c"stomers t&e a(ility to "se a si@di)it code &ic& randomly c&an)es eery 05 seconds on a sec"rity token. T&e keys on t&e sec"rity token &ae ("ilt in mat&ematical com!"tations and mani!"late n"m(ers (ased on t&e c"rrent time ("ilt into t&e deice. T&is means t&at eery t&irty seconds t&ere is only a certain array o n"m(ers !ossi(le &ic& o"ld (e correct to alidate access to t&e online acco"nt.

Terminolo)y Terminolo)y :

Q=nternet: T&e I$ter$et  is a )lo(al system o interconnected com!"ter netorks t&at "se t&e standard =nternet !rotocol s"ite TCP/=P; to link  seeral (illion deices orldide. QCom!"ter sec"rity: sec"rity: Com!"ter sec"rity also knon as cy(er sec"rity or =T sec"rity; is inormation sec"rity as a!!lied to com!"tin) deices s"c& as com!"ters and smart!&ones, as ell as com!"ter netorks s"c& as !riate and  !"(lic netorks, incl"din) incl"din ) t&e &ole =nternet. =nternet. QClo"d: Also reerred to as a network cloud . =n telecomm"nications, a clo"d reers to a  !"(lic or semi!"(lic s!ace on transmission lines s"c& as T1 as T1 or  or T0 T0;; t&at e@ists (eteen t&e end !oints o a transmission.

APPL=CAT=ON +U'' +U''AA- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>-> ->*>->NC> NC>

:

 N>MT L>++ON L>++ON

:

Q W&at is =nternetF Q W&at is TCP/=PF Q W&at is Com!"ter +ec"rityF Q >@!lain Clo"d.

QC QClo lo"d "d stor stora) a)ee is (ase (ased d on &i)& &i)&ly ly irt irt"a "ali li@!lain Ty!es o +ec"rity. [A History History o Clo"d Clo"d Com!"ti Com!"tin)[, n)[, =nternet =nternet +ec"rit +ec"rity: y: Cry!to) Cry!to)ra!& ra!&ic ic Princi! Princi!les les,, Al)orit&ms and Protocols. =ntrod"ction to HT'L and Iario"s Ta)s. Ta)s.

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

To!ic / Aim : O(4ectie :

A!!roac&in) HT'L and ario"s Ta)s. 1; HT'L 7; DHT'L 0; M'L

Aids : Pre!aration : -eie : =ntr =ntrod od"c "cti tion on :

C&alk, D"ster, Pointer.

'oti 'o tiat ation ion :

Week No.: Time :

13

Lesson no. :

A We(site We(site is a collection collec tion o !a)es. Pro)r ro)ram amm min) in) tec& tec&ni ni9" 9"es es A e(si e(site te is is "nda "ndame menta ntally lly desi)n desi)ned ed to to or ork k or or all all Peo Peo!le !le,W ,W&a &ate teer er t&ei t&eirr &ardare,sotare,lan)"a)es,c"lt"re,location or !&ysical or mental a(ility.

Presentation : To!ics

=normation Points Tell

+!ot &ints / "estion Ask;

-,

HT'L

•

•

• •

•

DHT'L

• •

•

•

•

M'L

•

•

: :

A++=$N'>NT/ U>+T=ON

:

->*>-> ->*>->NC> NC>  N>MT L>++ON L>++ON

: :

'ark"! Lan)"a)e. A mark"! lan)"a)e is a set o mark"! Ta)s. T&e ta)s descri(ed doc"ment content. HT'L doc"ment contains &tml ta)s and  !lain te@t. HT'L doc"ment are also called e(!a)es. Dynamic Hy!er Te@t 'ark"! Lan)"a)e. DHT'L is mer)in) o &tml and 4aa scri!t. Wit& DHT' DHT'L L e can can alte alterr t&e t&e &tm &tml  !a)e &ile it is (ein) dis!layed and  !roide animated content co ntent to t&e ieer. DHT'L is not a tec&nolo)y in and o itsel] rat&er, it is t&e !rod"ct o t&ree related and com!lementary tec&nolo)ies: HT'L, Cascadin) +tyle +&eets C++;, and Eaa+cri!t.

Q W&at is t&e "ll orm o  HT'LF QE<. ^&tmlQ   ^(odyQ ^&1Q &eadin)^/&1Q ^!Q !ara)ra!&^/!Q   ^/(odyQ ^/&tmlQ Q W&at is DHT'LF

QE+a'"le: =n t&is e@am!le &eader ill c&an)es &en client clicks.  ^&tmlQ ^&eadQ ^scri!t ty!e[te@t/4aascri!t[Q "nction c&an)ete@tid; _ id.innerHT'L[a(c`[]  To allo scri!ts and com!onents to ^/scri!tQ access eat"res o HT'L and C++, t&e ^/&eadQ contents o t&e doc"ment are re!resented ^(odyQ as o(4ects in a !ro)rammin) model ^&1 knon as t&e Doc"ment O(4ect 'odel onclick[c&an)ete@tt&is;[ DO';. QClick on t&is te@t^/&1Q ^/(odyQ ^/&tmlQ

Q W&at is M'LF >@tensi(le 'ark"! Lan)"a)e. M'L is a mark"! lan)"a)e t&at deines a set o r"les or encodin) doc"ments in Q W&at are adanta)es o M'LF a ormat t&at is (ot& &"manreada(le and mac&inereada(le. T&e desi)n )oals o M'L em!&asi@!lain eat"res o &tml and d&tml and @ml. 6; $ie e@am!le o &tml and d&tml and @ml. HT'L,D HT'L,DHT HT'L 'L and M'L can (e idely idely "sed or deelo!m deelo!ment ent o e(!a)es e(!a)es.. Conce!ts o C++. •

APPL APPL=C =CA AT=ON =ON +U''A+U''A- 

Hy!er Te@t

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

Unit/Block No.: Date:

WeekNo.: Time :

,=

Lesson no. :

To!ic / Aim : O(4ectie :

Conce!t o Cascadin) +tyle +&eetsC++; 1; A(o"t C++. 7; Ho to insert C++.

Aids : Pre!aration : -eie : =ntr =ntrod od"c "cti tion on :

C&alk, D"ster, Pointer.

'oti 'o tiat ation ion :

=m!roe =m!ro e cont content ent access accessi(i i(ili lity ty,, !ro !roid idee more more le@i le@i(i (ilit lity y and and contr control ol in in t&e t&e s!eciication o !resentation c&aracteristics, ena(le m"lti!le !a)es to s&are ormattin), and red"ce com!le@ity and re!etition in t&e str"ct"ral content.

Presentation :

We(!a) (!a)ee sty style le or or lay layo" o"t. t.

--

To!ics A(o"t C++

=normation Points Tell •

•

Casc Cascad adin in) )

+!ot &ints / "estion Ask; +tyl +tylee Q W&at is t&e "ll orm o  C++F

+&eets C++;. Cascadin) +tyle +&eets C++; is a style

•

Q W&at is "se o C++F s&eet lan)"a)e "sed or descri(in) t&e look look and and orm ormat atti tin) n) o a doc" doc"m ment ent Q W&at are t&e ritten in a mark"! lan)"a)e. adanta)es o C++F C++ is desi)ned !rimarily to ena(le t&e

•

se!ara se!arati tion on o doc"m doc"ment ent conte content nt rom rom doc" doc"m ment ent !res !resen enta tati tion on,, incl incl"d "din in) ) elements s"c& as t&e layo"t, colors, and onts. =t can also (e "sed to allo t&e e( !a)e

•

to dis!lay dierently de!endin) on t&e screen si
Ho to insert C++F

•

•

•

•

Terminolo)y Terminolo)y :

•

•

APPL=CAT=ON +U''A+U''A- 

: :

E+ter$al !t*le !heet:  An e@ternal style s&eet is ideal &en t&e style is a!!lied to many many !a)e !a)es. s. Wit& an e@te e@tern rnal al styl stylee s&eet, yo" can c&an)e t&e look o an entire We( site (y c&an)in) 4"st one ile.

Q W&at is >@ternal and =nternal style s&eetF Q W&at is t&e "se o m"lti!le style s&eetsF

I$ter$al I$ter$al !t*le !heet !heet : An internal style s&ee s&eett s&o" s&o"ld ld (e "sed "sed &en &en a sin) sin)le le doc"ment &as a "ni9"e style. o" deine internal styles in t&e &ead section o an HT'L !a)e, inside t&e ^styleQ ta). I$li$e !t*le! :  An inline style loses many o t&e adanta)es o a style s&eet (y mi@in) mi@in) content content it& it& !resent !resentati ation;. on;. To "se inline styles, add t&e style attri("te to t&e releant ta). T&e style attri("te can contain any C++ !ro!erty. %ulti"le !t*le !heet :  = some !ro!erties &ae (een set or t&e same selector in dierent style s&eets, t&e al"es ill (e in&erite in&erited d rom t&e more more s!ecii s!eciicc style style s&eet. Q W&at are selectorsF +electors: +electors are needed to com!lete an entire line o C++ code. Q W&at is styleF T&ese are &at e declare to set &at ty!e o element e are tar)etin). +tyles: +tyles deine &o to dis!lay HT'L elements

Create Doc"ment "sin) C++. =t &as ta")&t ta")&t yo" &o to create create style style s&eets s&eets to control control t&e style style and layo"t layo"t o m"lti!le e( sites at once. o" &ae learned &o to "se C++ to add (ack)ro"nds, ormat te@t, add and ormat (orders, and s!eciy !addin) and mar)ins o elements.

A++=$N'>NT/ U>+T=ON

:

->*>->NC>  N>MT L>++ON L>++ON

: :

1; W&at is t&e "ll orm o C++F 7; W&at is C++ +electorsF 0; >@!lain its eat"re. 6; >@!lain >@ternal style s&eetF CSS, or Cascadin) +tyles +&eets, is a ay to style and !resent HT'L. =ntrod"ction to *rontPa)e

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

J.G.Chaudhari COPA

To!ic / Aim : O(4e O(4ect cti iee :

Unit/Block No.: Date:

Week No.: Time :

7

Lesson no. :

-/

I$tr#ducti#$ t# ;r#$tPa9e ,==1; 1; Dee Deelo lo!i !in) n) skil skilll to desi desi)n )n a e(! e(!a) a)ee 7; Dierent rom ot&er &tml editor.

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod =ntod"ct "ction ion : We(Pa)e (Pa)e We We(site, (site,   'otiation : Presentation :

Windo # creatin) a e(!a)e in HT'L

To!ics

=normation Points Tell

A(o"t *ront Pa)e

•

• • • •

*eat"res o *rontPa)e 70

•

•

•

=t is a $U= (ased +otare Used to create e( !a)e. =t is Deelo!ed By 'icrosot =t is a one ty!e o HT'L editor. As a [W+=W$[ W&at o" +ee =s W&at o" o" $et; editor, *rontPa)e is desi)ned to &ide t&e details o !a)es8 HT'L code rom t&e "ser, makin) it  !ossi(le or noices no ices to create We( !a)es and We( sites easily. *rontPa)e 70 consists o a +!lit Iie o!tion to allo t&e "ser to code in Code Iie and and !re !reie ie  in Desi Desi)n )n Iie it&o"t t&e &assle o sitc&in) rom t&e Desi) Desi)n n and Code Code Iie ta(s ta(s or or eac& eac& reie. Dynamic Dynamic We( Tem!lates Tem!lates DWT; DWT; ere incl"ded or t&e irst time in *rontPa)e 70 alloin) "sers to create a sin)le tem tem!lat !latee t&at t&at co"l co"ld d (e "sed "sed acro across ss m"lti!le !a)es and een t&e &ole We( site. =nter =nteract acti iee B"tt B"ttons ons )ie )ie "sers "sers a ne easy easy ay ay to creat createe We( )ra!&i )ra!&ics cs or  or  nai)a nai)ati tion on and and links links,, elim elimin inati atin) n) t&e t&e need need or a com!l com!lica icated ted ima)e ima)eed edit itin in) )  !acka)e s"c& as Ad Ado(e o(e P& P&ot otos& os&o! o! &ic& 'icrosot does not sell.

+!ot &ints / "estion Ask; Q W&at is t&e "ll orm o  $U=F Q W&at is t&e "ll orm o  HT'L F Q W&at is t&e e(!a)e F

Q W&at is DWT F Q W&at is +!lit ie in *ront!a)e 70 F

•

•

•

Terminolo)y Terminolo)y :

•

T&e accessi(ility c&ecker )ies t&e "ser t&e a(ility to c&eck i t&eir code is standardscom!liant and t&at t&eir We( site is easily accessi(le or !eo!le it& disa(ilities. An HT'L o!timi
W&at

is intellisence F

I$telli!e$!e, &ic& is a orm o aut#c#'"leti#$, is a key eat"re in *rontPa)e 70 t&at assists t&e "ser &ile ty!in) in Code Iie. W&en orkin) in Code Iie, Iie, =ntellisense ill s"))est ta)s and/or !ro!erties or t&e code t&at t&e "ser is enterin) &ic& as s"!!osed to si)niicantly red"ce t&e time to rite code

Code +ni!!ets )ie "sers t&e adanta)e o creatin) sni!!ets o t&eir commonly "sed !ieces o code alloin) t&em to store it or easy access &eneer it is ne@t needed. 8eb"a9e : A eb "a9e or eb"a9e; 8eb"a9e is a e( doc"ment t&at is s"ita(le or t&e World Wide We( and t&e web browser 

Q W&at is HT'LF Q W&at is WWWF Q W&at is webbrowser F

•

APPL APPL=C =CA AT=ON =ON +U''A+U''A- 

: :

A++=$N'>NT/ U>+T=ON

:

->*>-> ->*>->NC> NC>  N>MT L>++ON L>++ON

: :

(T%L : (*"erTe+t %ar6u" La$9ua9e  is t&e standard mark"! lan)"a)e "sed to create e( !a)es.

'icr 'icroso osot t *ront *rontPa Pa)e )e 7 70 0 's *rontP *rontPa)e a)e 70 is t&e ideal ideal sota sotare re or t&ose t&ose &o don8t don8t kno &o to rite &tml code ("t ant to create t&eir on e( !a)es. 1; W&at is t&e "ll orm o $U=F 7; W&at is We(!a)e F 0; W&at is eat"re o *rontPa)e F *rontP *rontPa)e a)e 70 Hel! Hel! and Hoto Hoto \ 'icroso 'icrosot t Oice Oice Online Online Cy(er +ec"rity

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

 Name : Trade :

N.S.NAHU% COPA

T#"ic T#"ic 4 Ai' : O(4e O(4ect cti iee :

Unit/Block No.: Date:

Week No.: Time :

Lesson no. :

,1

-0

I$tr#ducti#$ t# C*ber Securit* 1; 1; Aaren arenes esss o Cy(e Cy(erc rcri rim me 7; To "nderstand t&e tec&ni9"es or sec"rin) a com!"ter system

Aids : C&alk, D"ster, Pointer. Pre!aration : K -eie : K =ntod"c =ntod"ction tion : Com!"te Com!"terr +ystem +ystem,, Cy(erc Cy(ercrim rime, e, Hackin Hackin) ) 'otiation : Presentation :

Windo # dos (ase !ro)ram

To!ics I$&#r'ati#$ Securit*

=normation Points Tell •

•

?ul$erabilit*

•

C#'"uter !ecurit*  also knon as c*ber!ecurit*  or IT !ecurit*; is inormation sec"rity as sec"rity as a!!lied to com!"tin) deices s"c& as com!"ters and smart!&ones smart!&ones,, as ell as com!"ter netorks s"c& netorks  s"c& as !riate and !"(lic netorks, incl"din) t&e &ole =nternet =nternet.. T&e ield coers all t&e !rocesses and mec&anisms (y &ic& com!"ter(ased e9"i!ment, inormation and serices are  !rotected rom "nintended "ninte nded or "na"t&ori
•

Denial o serice attack 

•

Direct access attack 

•

>aesdro!!in)

•

>@!loits

•

=ndirect Attacks

+!ot &ints / "estion Ask;

Q W&at is t&e cy(ercrimeF

Q W&at is t&e &ackin)F

Q W&at is "lnera(ility F

Q >@!lain direct access attack 

W&at

is T&reats F

W&at

is -isk AnalysisF

De&i De&i$i $iti ti#$ #$ #& ri!6 ri!6 'a$a 'a$a9e 9e'e 'e$t $t:: "Risk management is the process of identifying vulnerabilities and vulnerabilities  and threats threats to  to the information resources used by an organization in achieving business objectives, and deciding what countermeasures , if  , if any, to take in reducing risk  to an acceptable level, based on the value of the information resource to the organization."  organization." RS Dierent met&odolo)ies &ae (een •  !ro!osed to mana)e -isks, eac& o t&em diided in !rocesses and ste!s

Ri!6 Ri!6 %a$a %a$a9e 9e'e 'e$t $t

•

•

• •

Terminolo)y Terminolo)y :

Ri!6 A!!e!'e$t Q-isk analysis 1;Deinin) T&reats 7;Deinin) I"lnera(ility I"lnera(ility 0;Deinin) -isk Ty Ty!es !es Q-isk >al"ation Ri!6 Treat'e$t. Q-isk Aoidance Q-isk -ed"ction Q-isk Transer  Q-isk -etention Ri!6 Acce"ta$cee Ri!6 C#''u$icati#$

Threat:  =n com!"ter sec"rity a threat is a  !ossi(le dan)er t&at t&a t mi)&t e@!loit a "lnera(ility to "lnera(ility  to (reac& sec"rity and t&"s ca"se  !ossi(le &arm. ?ul$erabilit*: a ul$erabilit* is a eakness &ic& allos an attacker  to  to red"ce a system8s inormation ass"rance. ass"rance.

APPL=CAT=ON +U''A-

: :

A++=$N'>NT/ U>+T=ON

:

->*> ->*>-> ->NC NC> >  N>MT L>++ON L>++ON

: :

QHo -isk comm"nication is "se"l F

Q W&at is -isk eal"ation F

inormation sec"rity as sec"rity as a!!lied to com!"tin) deices s"c& as com!"ters com!"ters and  and smart!&ones,, as ell as com!"ter netorks s"c& smart!&ones netorks s"c& as !riate and !"(lic netorks, incl"din) t&e &ole =nternet =nternet.. 1; W&at is t&e -isk 'ana)ementF 7; W&at is Cy(er +ec"rity F 0; >@!lain ste! o -isk assessment .  .Wiki!e ki!edi dia. a.co com m