# Basic course
1,Fundamental of computer
2,Window-2003
3,Typing(T.T)Tuter
4,Typesala
5,Word pad
6,Ms-word
7,Ms-Excel
8,Multimiedia
9,Powerpoint
10,E-mail,Internet
11,Project work(practices)
# Office package course
1,Basic course (all)
2,Akobe pagemaker 7.0
3,Microsoft Dos
4,Typing English&Nepali
5,Using Floppy or diskettes
6,Virus scaning
# Graphic Desining
1,Adobe pagemaker
2,Adobe photo shop
3,Freehand
4,Project(Practies)
# Diploma in computer's cource
1,Fundamental of compute
2,M.s office program
3,Software installation
4,Ms-Access
5,Virus scanig
6,M.s photo shop
7,Dos window utility
8,Tally
9,Project work(practice)
# Advance Diploma
1,Office pakage
2,Accounting pakage
3,Graphic Desining
4,M.s Access
5,Basic hardware
6,Net-working
# Advance Graphic Design
1,Adobe pagemaker
2,Adobe pagemaker
3,Adobe image Ready
4,Core draw
5,Freehand
Microsoft powerpoint:-
1, File:-(Ctrl+N)
Open(Ctrl+o)
Close
Save(ctrl+s)
Save as web page
Search
Pack and go
Webpage preview
Page setup
Print preview
PRint(ctrl+p)
Send to:-Mailrecipient\forrever,Mail recipient,Excharge folder,Microsoft word,property
2 , Edit menu:-
Undo cat(ctrl+z)
Reapeat properties(ctrl+Y)
Office clipboard
Paste(ctrl+v)
Select all(ctrl+A)
Fine(ctrl+)
Paste speacil
Delete slide
Replace(ctrl+H)
3,Veiw menu:-
Normal
slide sorter
slide show(ctrl+f5)
Note page
Master:-slide maste,mandout master,not maste
Color\Greyscable:-Color,Grayscate,pure black and white
Task pane
Toolbars:-castomice,visual basic,Picture,standard,farmating,drawing,autoshap,tables and border,revision pane,rular,grid and guider,header and footer,zoom
4, Insert menu:-
New slide(ctrl+n)
duplicate slide
slide number
Date and time
Coment
Slide from file
Slides from out line
Picture:-Clipart,from scanner ar camera,new photoalbum,organization chart,
Autoshapes
Wordart
5, Formate menu:-
Font
Alignment:- Align left(ctrl+L),center(ctrl+E),Align right(ctrl+r)
Replace fonts
slide desin
slide layout
Background
6, Tolls:-
Spelling and Grammer f7)
Language
Commpare and merge presentations
Online collaboration:- Meet now,schedulemeeting,web Discussions
Meeting minder
Tools on the web
Macro:- Macro (alt+f8)
Record new macro
Sequrity
Visual Basic editor (alt+f11)
Macrosoft scrpt editor (alt+shift+f11)
Customize
option
Add-ins
7, Slide show :- View show f5)
Setup show
Rehearse timings
Online Broad cast-Record and save a broadcast,Schedule alive broadcast,Start live broadcast now,settings,Action buttons,Animation cchemds,custom animation,slide transition,hide slide,custom shows
8, Window menu:-
New window
Arrange all
Cascade
Next pane f6
Telicome Bill sheet
100 call minimum charge,Rs 200
>100 per|call charge Rs 3.25 excess call Telicome tax subtotal's 5%
sn Name Teliphone no previwous month Total Excess call Subtotal Tax Billamount Remarks
1 Dhan b d r Rai 14622883 150 200 100 525 26.25 551.25
stuctures :-Total=Curentmonth-previewousmonth
Excesscall:-=if(totall>=100,totall-100)
Subtotal:-=200+excesscall*3.25
Telicome tax:-=subtotall*5%
Billamount:-=subtotall+tax
2, marksheet
other knowledge:-=today shift()enter. sn english Math Scince Social Population Nepali Education Geography Total Persontage Result Division Remarks
Method lookes today date&time. 32 32 32 32 32 32 32 32 256 32 pass 2nd
stuctures:- Total=sum(select all subjects)enter
Persontage:-=total/all subjects)enter
Result:-=if(and(english>=32,math>=32,scince>=32,population>=32,nepali>=32,education>=32,geography>=32),"pass","fail")enter
Division:-=if(persontage>=60,"1st",if(and(persontage60,persontage<45,persontage),"2nd",if(and(persontage<45,persontage>=32),"3rd",no division")))enter
Remarks:-=if(division="1st","excelence",if(division="2nd","well",if(division="3rd","good","tryagain")))enter
3,Eletronic Bills
Pradhikaran facilities:- 20Unit minimum charge Rs 80
21-250 per|unit Rs 7.25>250 per|unit Rs 9.90
sn Name Cutommer no Previousmonth Curentmonth Total unit Bill amount
1 Ghanashyam 1254 150 300 150 1022.5
stuctures:-Total:-=Curentmonth-previeousmonth
Billamount:-=if(Total<20,80,if(total<=250,(Total-20)*7.25+80,if(total>250,(total-250)*9.90+(250-20)*7.25+80)))enter
4, General Bills Office facilities:- 2% Discount
sn Particulars Queentity Rate Amount Discount BillAmount
1 Pattato 5 5 25 0.5 24.5
2 Apple 10 70 700 14 686
3 Rice 25 50 1250 25 1225
4 Biscut 5 80 400 8 392
5 Jeera 4 90 360 7.2 352.8
6 Sugar 25 36 900 18 882
Stucture:-Amount=Queetity*Rate
Discount:-=Total*Discount
BillAmount:-=Amount-Discount
No comments:
Post a Comment