cÖ‡R± wk‡ivbvg t †¯cÖWkxU A¨vbvjvBwmm †cÖvMÖvg e¨envi K‡i †Kvb cÖwZôv‡bi †eZb wej ev †c-‡ivj
cÖ¯‘ZKiY|
D‡Ïk¨ t †Kvb cÖwZôv‡bi Kg©KZ©v/Kg©Pvix‡`i †eZb wej ev †c-‡ivj ˆZwi K‡i msi¶Y I
KvM‡R wi‡cvU© AvKv‡i Qvcv‡bvi `¶Zv AR©b|
mgm¨vi eY©bv t
1.
cÖwZôv‡bi cÖ‡Z¨K Kg©KZ©v/Kg©Pvix‡`i GKwU g–j †eZb _vK‡e|
2.
evwofvov g–j †eZ‡bi 40%|
3.
kZ©vbymv‡i g–j †eZ‡bi mv‡_ wPwKrmv fvZv cv‡e| †hgb-g–j †eZb 15,000 UvKvi †ewk n‡j wPwKrmv
fvZv 1000 UvKv Ges Kg n‡j 800 UvKv nv‡i|
4. mKj Kg©KZ©v/Kg©Pvix‡`i cÖwf‡W›U dvÛ (Provident Fund) n‡e g–j †eZ‡bi
5%|
5.
mK‡ji Rb¨ AvqKi (Tax) wn‡me wb‡Pi gZ
n‡e t
g–j †eZb 15,000 UvKvi wb‡P n‡j AvqKi
n‡e 0%|
g–j †eZb 15,000 UvKvi mgvb ev †ewk wKš‘
18,000 UvKvi wb‡P n‡j AvqKi 7% Ges
g–j †eZb 18,000 UvKvi mgvb ev †ewk n‡j
AvqKi n‡e 10%|
(K) BbcyUmg–n t
· Kg©KZ©v/Kg©Pvix‡`i AvBwW b¤^i t ID No.
· Kg©KZ©v/Kg©Pvix‡`i bvg t Name
· Kg©KZ©v/Kg©Pvix‡`i c`ex t Designation
· Kg©KZ©v/Kg©Pvix‡`i wVKvbv t Address
· Kg©KZ©v/Kg©Pvix‡`i g–j †eZb t Basic
(L) AvDUcyUmg–n t
· Kg©KZ©v/Kg©Pvix‡`i AvBwW b¤^i t ID No.
· Kg©KZ©v/Kg©Pvix‡`i bvg t Name
· Kg©KZ©v/Kg©Pvix‡`i c`ex t Designation
· Kg©KZ©v/Kg©Pvix‡`i wVKvbv t Address
· Kg©KZ©v/Kg©Pvix‡`i g–j †eZb t Basic
· Kg©KZ©v/Kg©Pvix‡`i evwofvov t H-Rent
· Kg©KZ©v/Kg©Pvix‡`i wPwKrmv fvZv t Medical
· Kg©KZ©v/Kg©Pvix‡`i cÖwf‡W›U dvÛ t PF
· Kg©KZ©v/Kg©Pvix‡`i AvqKi t Tax
· Kg©KZ©v/Kg©Pvix‡`i Gross Pay t Gross Pay
· Kg©KZ©v/Kg©Pvix‡`i bxU †eZb t Net Pay
m¤úwK©Z wnmve
(K) evoxfvov
wbY©q t
g–j †eZb (Basic) Gi 40% = Basic
´ 0.4
(L) wPwKrmv fvZv
wbY©q t
(Basic) >= 15,000 n‡j wPwKrmv fvZv (Medical) = 1000
(Basic) <= 15,000 n‡j wPwKrmv fvZv (Medical) = 800
(M) Gross Pay = Basic + H-Rent + Medical
(N) Tax wbY©q t
g–j †eZb (Basic) < 15,000 n‡j Tax = Basic ´ 0.0
g–j †eZb (Basic) >= 15,000 n‡j Tax = Basic ´ 0.07
g–j †eZb (Basic) >= 18,000 n‡j Tax = Basic ´ 0.1
(O) Net Pay = Gross Pay – (Provident Fund + Tax)
†cÖvMÖvg wWRvBb t
cÖ‡R±wU‡Z Microsoft Excel c¨v‡KR †cÖvMÖvg e¨envi K‡i cÖ‡R± ˆZwi
Kiv n‡jv|
cÖ‡R‡±i †WUv Gw›Uª msw¶ß I mnR Kivi Rb¨
†h mKj wel‡qi †WUv Gw›Uª Ki‡Z n‡e Zvi †KvwWs wbgœiƒct
1. Basic Salary = Basic
|
2. House Rent = H-Rent
|
3. Medical = Medical
|
4. Gross Pay = GP
|
5. Provident Fund = PF
|
6. Tax = Tax
|
7. NetPay = NetPay
|
†c-‡ivj wbY©‡q
m–‡Îi e¨envi t
†WUv Gw›Uª I
dg–©jv ms‡hvRb t
1.
A, B Kjv‡g
Kg©KZ©v/Kg©Pvix‡`i AvBwW b¤^i I bvg Gw›Uª w`‡Z n‡e|
2.
C, D Ges E Kjv‡g
h_vµ‡g Address,
Designation Ges Basic †WUv Gw›Uª
w`‡Z n‡e|
House Rent wbY©‡qi dg–©jv t
Page
# 15
|
F2 †m‡j wb‡gœi m–Î
wjL‡Z n‡e t
= E2*40% ev E2*.40
Medical wbY©‡qi
dg–©jv t
G2 †m‡j wb‡gœi m–Î
wjL‡Z n‡e t
=IF(E2>=15000,1000,800)
Gross Pay wbY©‡qi dg–©jv t
H2 †m‡j wb‡Pi m–Î
wjL‡Z n‡e t
SUM (E2:G2)
A_ev
E2 + F2 + G2
Provident Fund wbY©‡qi dg–©jv t
I2 †m‡j wb‡Pi m–Î wjL‡Z n‡e t
= SUM(E2*0.05)
Tax
wbY©‡qi dg–©jv t
J2 †m‡j wb‡Pi m–Î
wjL‡Z n‡e t
=IF(H2<15000,0,IF(H2>=15000,H2*7%,IF(H2>=21000,H2*10%)))
Net Pay wbY©‡qi dg–©jv t
K2 †m‡j wb‡Pi m–Î wjL‡Z n‡e t
=H2-(I2+J2)
Aci Ni¸‡jv‡Z Fill Hand cÖwµqvq evg †_‡K Wvb w`‡K
gvDm w`‡q WªvM K‡i †Q‡o w`‡q mwVK djvdj cvIqv hv‡e|
†cÖvMÖvg †Uw÷s I bgybv AvDUcyU t
G †cÖvMÖv‡g wewfbœ wel‡qi †WUv Gw›Uª Kivi ci mwVKfv‡e dg–©jv/dvskb
e¨envi Ki‡j wbgœwjwLZ AvDUcyU cvIqv hv‡e|
cÖ‡R± wk‡ivbvg t †MÖwWs c×wZ‡Z gvB‡µvmdU G‡·j
†cÖvMÖvg e¨envi K‡i QvÎ-QvÎx‡`i cix¶vi djvdj cÖ¯‘ZKiY|
D‡Ïk¨ t gvB‡µvmdU G‡·j (Microsoft
Excel)
†cÖvMÖvg e¨envi bZzb †MÖwWs c×wZ‡Z QvÎ-QvÎx‡`i cix¶vi djvdj ˆZwi Ki‡Z n‡e|
mgm¨vi eY©bv t GBPGmwm cix¶vq QvÎ-QvÎx‡`i
6wU wel‡q cix¶vq AskMÖnY Ki‡Z nq, Gi g‡a¨ PZz_© welq wnmv‡e GKwU welq _v‡K hv
wk¶v_©xiv AwZwi³ wn‡m‡e wb‡q _v‡K| cÖwZwU wel‡q Avevi `yBwU cÎ (1g cÎ I 2q cÎ)
_v‡K| bZzb c×wZ‡Z AwZwi³ wel‡qi (PZz_© welq) b¤^i P‚ovšÍ djvd‡j mivmwi cÖfve we¯Ívi
K‡i| G‡¶‡Î kZ© _v‡K †h, AwZwi³ wel‡q †h b¤^i cv‡e Zv †_‡K Grade
Point
wnmv‡e
cÖvß 2 c‡q›U ev` w`‡q evwK
bv¤^vi Ab¨vb¨ wel‡qi cÖvß bv¤^v‡ii mv‡_ †hvM n‡e| GQvov cÖwZwU wel‡qi 1g I 2q
c‡Î cvk b¤^i wn‡m‡e †gvU 66 †c‡Z n‡e| G mKj kZ©mv‡c‡¶ eZ©gvb cÖPwjZ †MÖwWs
c×wZi wn‡m‡e G‡b djvdj cÖ¯‘Z Ki‡Z n‡e|
mgm¨vi we‡kølY t GBPGmwm cix¶vi djvdj ˆZwi
Ki‡Z n‡j †hme welq¸‡jv we‡ePbvq Avb‡Z n‡e t
1. BbcyUmg–n t
· QvÎ-QvÎxi bvg
· QvÎ-QvÎxi †ivj bs
· QvÎ-QvÎxi †iwR‡÷ªkb bs
· wewfbœ wel‡qi cÖvß b¤^i
2. AvDUcyUmg–n t
· QvÎ-QvÎxi bvg, †ivj bs, †iwR‡÷ªkb bs
· welqwfwËK cÖvß b¤^i
· †jUvi †MÖW I †MÖW c‡q›U Gfv‡iR (GPA-Grade Point
Average)
djvdj ˆZwii wbqgvewj t
1. cÖwZ wel‡qi 1g I 2q c‡Îi b¤^i‡K GK‡Î
GKwU wn‡m‡e MY¨ Ki‡Z n‡e|
2. †Kvb QvÎ-QvÎxi cÖwZ wel‡qi cÖvß †gvU
b¤^i 160 ev Zvi †ewk n‡j †jUvi †MÖW n‡e A+ Ges †MÖW c‡q›U n‡e 5
3. cÖwZ wel‡qi cÖvß †gvU b¤^i 140 ev
Zvi †ewk n‡j †jUvi †MÖW n‡e A Ges †MÖW
c‡q›U n‡e A
4. cÖwZ wel‡qi cÖvß †gvU b¤^i 120 ev
Zvi †ewk n‡j †jUvi †MÖW n‡e A- Ges †MÖW c‡q›U n‡e 3.5
5. cÖwZ wel‡qi cÖvß †gvU b¤^i 100 ev
Zvi †ewk n‡j †jUvi †MÖW n‡e B Ges †MÖW
c‡q›U n‡e 3
6. cÖwZ wel‡qi cÖvß †gvU b¤^i 80 ev Zvi
†ewk n‡j †jUvi †MÖW n‡e C Ges †MÖW
c‡q›U n‡e 2
7. cÖwZ wel‡qi cÖvß †gvU b¤^i 66 ev Zvi
†ewk n‡j †jUvi †MÖW n‡e D Ges †MÖW
c‡q›U n‡e 1
8. cÖwZ wel‡qi cÖvß †gvU b¤^i 66 Gi Kg
n‡j †jUvi †MÖW n‡e F Ges †MÖW c‡q›U
n‡e 0
9. PZz_© wel‡qi †¶‡Î Grade Point =2 Gi †ewk n‡j †m‡¶‡Î H wel‡qi †gvU Grade Point †_‡K 2 ev` w`‡q Aewkó Grade Point cuvPwU Avewk¨K wel‡qi Grade Point Gi mv‡_ †hvM K‡i 5 w`‡q fvM K‡i Grade Point Average (GPA) †ei Kiv nq|
DcwiD³ Av‡jvP¨ welqvewj wb‡gœ †Uwe‡ji g‡a¨ Dc¯’vcb Kiv n‡jv
t
SL No.
|
Class Interval (Marks)
|
Letter Grade
|
Grade Point
|
1.
|
80-100
|
A+
|
5
|
2.
|
70-79
|
A
|
4
|
3.
|
60-69
|
A-
|
3.6
|
4.
|
50-59
|
B
|
3
|
5.
|
40-49
|
C
|
2
|
6.
|
33-39
|
D
|
1
|
7.
|
0-32
|
F
|
0
|
†cÖvMÖvg wWRvBb t
G
As‡k we‡kl K‡i A¨vjMwi`g I †d¬vPvU© ˆZwi Ki‡Z nq| cÖ‡Z¨KwU‡K msw¶ßKi‡Yi j‡¶¨
GLv‡b mivmwi Microsoft Excel
c¨v‡KR
†cÖvMÖvg e¨envi K‡i cÖ‡R± ˆZiv Kiv n‡jv| cÖ‡R‡±i †WUv Gw›Uª msw¶ß I mnR Kiv Ges
GK kx‡U wcÖ›U Kivi myweav‡_© †h mKj wel‡qi †WUv Gw›Uª Ki‡Z n‡e Zvi msw¶ßiƒc Aci cvZvq wbgœiƒct
1.
|
Bangla 1st
Paper = Ban-1
|
|
Bangla 2nd
Paper = Ban-2
|
Bangla
Grade Point = BG
|
|
English
Total = ET
|
||
2.
|
English 1st
Paper = Eng-1
|
English
Grade Point = EnG
|
English 2nd
Paper = Eng-2
|
||
Bangla
Total = BT
|
||
3.
|
Physics 1st
Paper = Phy-1
|
|
Physics 2nd
Paper = Phy-2
|
Physics
Grade Point = PhG
|
|
Physics
Total = PT
|
||
4.
|
Chemistry
1st Paper = Che-1
|
|
Chemistry
2nd Paper = Che-2
|
Chemistry
Grade Point = ChG
|
|
Chemistry
Total = CT
|
||
5.
|
Math 1st
Paper = Mat-1
|
|
Math 2nd
Paper = Mat-2
|
Math
Grade Point = MtG
|
|
Math
Total = MT
|
||
6.
|
Bio 1st
Paper = Bio-1
|
|
Bio 2nd
Paper = Bio-2
|
Bio Grade
Point = BiG
|
|
Bio Total
= BiT
|
||
7.
|
Optional
1st Paper = Opt-1
|
|
Optional
2nd Paper = Opt-2
|
Optional
Grade Point = OPG
|
|
Optional
Total = OT
Optional
Neat = OPN
|
†iRvëkxU wbY©‡q
m–‡Îi e¨envi t
†WUv Gw›Uª t
1. A, B Kjv‡g QvÎ-QvÎxi †ivj b¤^i I bvg|
2. C, D, F, G, I, J, L, M, O, P, R, S Kjv‡g
h_vµ‡g Bangla,
English, Physics, Math, Chemistry, Biology I wel‡qi
1g I 2q c‡Îi cÖvß bv¤^vi Ges U,V Kjv‡g Optional (PZz_© wel‡qi) 1g I 2q c‡Îi bv¤^vi |
†gvU wbY©‡qi m–Î t
†h †Kvb welq †hgb- Bangla 1st Ges Bangla 2nd
Paper Gi †hvMdj E2 †m‡j †ei Kivi Rb¨ m–Î wjL‡Z
n‡e t
=
SUM (C2:D2)
Gfv‡e h_vµ‡g H2,
K2, N2,Q2, T2 I W2 Kjv‡g m–Î wj‡L Ab¨vb¨ wel‡qi
†gvU bv¤^vi †ei Ki‡Z n‡e|
†jUvi †MÖW wbY©‡qi m–Î t
†h †Kvb wel‡qi
†jUvi †MÖW †hgb Bangla 1st Ges
Bangla 2nd Paper Gi
Rb¨ Y2
†m‡j wb‡gœi m–Î wjL‡Z n‡e|
=IF(E2>=160,²5²,
IF(E2>=140,²4²,
IF(E2>=120,²3.5²,
IF(E2>=100,²3²,
IF(E2>=80,²2²,
IF(E2>=66,²1²,
²0²)))))) [ †h‡nZz
E2 †m‡j evsjv 1g
I 2q c‡Îi †gvU bv¤^vi i‡q‡Q|]
Gfv‡e
Ab¨vb¨ wel‡qi †jUvi †MÖW †ei Kivi Rb¨ h_vµ‡g X2, Z2, AA2, AB2, AC2 Kjv‡g DcwiD³ m–Î
wj‡L djvdj cvIqv hv‡e|
PZz_© wel‡qi bv¤^vi wn‡m‡ei m–Î t
†ev‡W©i
wbqgvbyhvqx †Kvb QvÎ-QvÎx PZz_© wel‡q †gvU †h †jUvi †MÖW bv¤^i cv‡e Zv †_‡K 2
ev` w`‡q evKx bv¤^vi Zvi Ab¨vb¨ wel‡qi †MÖW c‡q‡›Ui mv‡_ †hvM n‡e| Gi Rb¨ cÖ_‡g
†MÖW c‡q›U †ei Ki‡Z n‡e| Gici †MÖW c‡q›U
†_‡K 2 ev` w`‡q AwR©Z PZz_© wel‡qi b¤^i AD2 †m‡j wb‡gœi m–Î e¨envi K‡i OpN †ei Kiv hv‡e|
=IF(X2>2,X2-2,0)
P‚ovšÍ †MÖW c‡q›U Gfv‡iR (GPA) wbY©‡qi
m–Î t
AE2 †m‡j wb‡gœi m–Î wjL‡j P‚ovšÍ
I Kvsw¶Z djvdj cvIqv hv‡e|
=SUM(Y2 : AD2)/5
No comments:
Post a Comment