AMOUNT

SALARY COMPONENTS
(ANNUAL)
CTC 1,600,000
Basic 640,000
HRA 320,000
EPF 21,600
Sec 80C Investment 100,000
Leave Travel Allowance 20,000
Special Allowance 575,324
Gratuity 23,076
Professional Tax 2400
1,600,000

Gross Salary 1,555,324

Income Tax 194,841
Take home salary 1,358,083
Monthly Takehome salary 113173.583333333
 Particulars Amount (in
AMOUNT (MONTHLY) INR)
- Basic Salary 120,000 10000
53,332 Dearness Allowance 60,000 5000
26,666 HRA 48000 4000
1,800 Travel allowance, 9,600 800
8,333 Education allowance 2,400 200
1,666 Medical allowance 15,000 1250
47,943 PF 14,400 1200
1,923 Gratuity 9000 750
200 CTC 278,400 21250

Gross salary=CTC-Gratuity-PF 255,000

Take Home salary= Gross Salary-PT-IT
21250
 MSW HRDM MARKS AND EVALUATION-2018-2020 BATCH
Place CIA 1 (10) CIA2 (25) CIA 3 (10) Total CIA End Sem
Marks
Reg Name
No. of the Student (50)

Sl No
1 1237701 Aby M North 4 10.00 7.5 21.50 35
2 1237712 Deonna F South 6 15.83 5 26.83 33
3 1237702 Anu F East 7 17.50 7 31.50 28
4 1237703 Asha F West 8 17.50 7.5 33.00 33
5 1237704 Arathi F West 8 18.33 7 33.33 34
6 1237705 Abin M South 7 16.67 7 30.67 37
7 1237706 Bino M South 7.5 17.50 7 32.00 32
8 1237707 Bijo M West 8 15.83 6.5 30.33 22
9 1237708 Bitto M North 7 16.67 6.5 30.17 25
10 1237709 Byju M South 6.5 16.67 7.5 30.67 33
11 1237710 Bindu F East 8 16.67 8 32.67 37
12 1237711 Cimy F East 7.5 15.00 7 29.50 30
13 1237713 Eva F West 7 15.83 7 29.83 33
14 1237714 Feo F North 8.5 18.33 8.5 35.33 29
15 1237715 Geena F South 8 16.67 8 32.67 38
16 1237716 Indu F south 7.5 15.83 7.5 30.83 14
17 1237717 Joby M South 7 17.50 7 31.50 36
18 1237718 Krishna M East 6.5 18.33 8 32.83 36
19 1237719 Leena F West 8 16.67 7.5 32.17 30
20 1237720 Lisha F West 6 17.50 8 31.50 37
21 1237721 Lijo M South 6 16.67 8 30.67 29
22 1237722 Meera F South 8.5 15.83 7.5 31.83 27
23 1237723 Molly F West 6.5 16.67 8 31.17 32
24 1237724 Melbin M North 8 19.17 8.5 35.67 39
25 1237725 Mevin M South 7.5 17.50 8 33.00 36
26 1237726 Nora F West 6.5 16.67 8 31.17 36
27 1237727 Niya F West 8 16.67 7.5 32.17 34
28 1237728 Prinu F North 7.5 17.50 7.5 32.50 35
29 1237729 Priya F South 6.5 15.00 7 28.50 31

Question
1 Write MSW HRDM MARKS AND EVALUATION-2018-2020 BATCH
2 Convert CIA 1 and CIA 3 out of 10 instead of out of 20 marks
Convert CIA II out of 25
Question
1 Write MSW HRDM MARKS AND EVALUATION-2018-2020 BATCH
2 Count the number of students from east
3 Count the number of female students from North
4 Calcuate the averge CIA Marks of each student
5 Count the total number of females and Males
 6 Find the percentage of marks for females and males and draw agraph for the same.
7 Write an interpretation for the same.
8 Find the sum of all Marks and Standard Deviation.
9 Allign all the cell in a proper format
10

11 Count the number of boys who scored more than 17 Marks in CIA 1,and CIA 3.
12 Find the total Marks of all girls students
13 Find the total Marks of all girls students who scored more than 70 Marks
14 Highlight the students who scored more than 65
0 BATCH
Attendan Total CIA Total Average
ce Marks Marks Marks of Three
+Attenda (100) CIA
nce(50)

4 25.50 60.50 7.17

3 29.83 62.83 8.94
5 36.50 64.50 10.50
3 36.00 69.00 11.00
3 36.33 70.33 11.11
4 34.67 71.67 10.22
2 34.00 66.00 10.67
4 34.33 56.33 10.11
3 33.17 58.17 10.06
3 33.67 66.67 10.22
2 34.67 71.67 10.89
1 30.50 60.50 9.83
0 29.83 62.83 9.94
0 35.33 64.33 11.78
4 36.67 74.67 10.89
5 35.83 49.83 10.28
5 36.50 72.50 10.50
5 37.83 73.83 10.94
3 35.17 65.17 10.72
5 36.50 73.50 10.50
4 34.67 63.67 10.22
2 33.83 60.83 10.61
3 34.17 66.17 10.39
5 40.67 79.67 11.89
4 37.00 73.00 11.00
4 35.17 71.17 10.39
3 35.17 69.17 10.72
4 36.50 71.50 10.83
2 30.50 61.50 9.50
Sl.No Name of Location Basic Pay DA = Basic HRA (50% of
the pay *25% Basic+DA)
Employe
e

20 ANUPAM D Mangalore Rs 4,000.00

42 ANWAR SA Hassana Rs 20,797.00
32 ASHISH PR Bangalore Rs 20,517.50
9 CHRISTIN Bangalore Rs 20,574.00
25 DANIEL JOH Bangalore Rs 20,574.00
47 NAGANA Bangalore Rs 20,574.00
13 SAJI THOM Mangalore Rs 20,574.00
45 SAM THOM Mangalore Rs 20,574.00
37 TONY JAME Bangalore Rs 21,551.00
38 AMRITA RE Bangalore Rs 21,551.00
41 ANANYA D Bangalore Rs 21,551.00
8 ANN GRAC Mangalore Rs 21,551.00
16 ARUNIDA Mangalore Rs 21,551.00
23 ARUNIMA Mysore Rs 21,551.00
46 BENCY BAB Mangalore Rs 21,551.00
12 CHRISTINA Mysore Rs 21,578.00
27 DIVITA JAI Mysore Rs 21,578.00
2 IVY SEBAST Bangalore Rs 21,405.00
19 JESLET T Bangalore Rs 21,405.00
30 JIYA RAJ Bangalore Rs 21,405.00
31 KETRINA R Bangalore Rs 21,405.00
33 M L PARVA Bangalore Rs 21,457.00
43 N RAGHINI Bangalore Rs 21,457.50
15 PRIYANKA Bangalore Rs 22,459.00
1 ROSHNI T Bangalore Rs 22,486.00
6 STEFFY JA Bangalore Rs 22,576.50
34 DYENA K Bangalore Rs 24,576.50
28 SIJIN THO Bangalore Rs 24,540.00
44 DON V ARK Mangalore Rs 24,540.00
4 ALAN SHA Bangalore Rs 24,555.50
22 D'SOUZA R Bangalore Rs 24,594.00
10 JONATHAN Bangalore Rs 25,688.50
21 KARTHIKRA Bangalore Rs 105,688.50
39 KISHORE K Bangalore Rs 60,550.00
 Salary Contribution Employer
Conveyance Medical (Rs. Gross Salary Basic + DA PF (13.61% of
(Rs. 1250/month) (Basic+DA+HR Basic + DA)
1600/mont A+Conveyance
h) +Medical)
lary Contribution Employer Deductions from Employee
ESI (If Gross Total PF (12% of ESI(If Gross Total Net
salary is less Employer basic +DA) salary is less Deductions Salary=Gross
than Rs.21000, contribution than Rs.21000 from salary-
4.75%of Gross deduct 1.75% employees Deductions
salary else No) of gross from
salary, else employees
No)
 CTC= Gross
Salary+Employer
Contributions