Excel File CO-PO Attainment For UG - RAC

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 13

Instructions

a. Cells filled yellow needs to be entered by the faculty


b. Cells filled green or grey will be autocalculated

Steps to be followed
1. Fill course articulation matrix for CO-PO mapping in Course articulation matrix sheet as per below criteria
Criteria (CO-PO
Value
Mapping|)
High 3
medium 2
low 1
no mapping blank
2 .Fill yellow color Cells of Co-Calculation sheet
3. No Entry should be done in PO-Calcuation Sheet
below criteria
Program Out Statement
1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals, a
PO1 the solution of complex engineering problems.

2. Problem analysis: Identify, formulate, review research literature, and analyze complex engineerin
PO2 conclusions using first principles of mathematics, natural sciences, and engineering sciences.

3. Design/development of solutions: Design solutions for complex engineering problems and design sy
meet the specified needs with appropriate consideration for the public health and safety, and the cu
PO3 considerations.

4. Conduct investigations of complex problems: Use research-based knowledge and research metho
PO4 analysis and interpretation of data, and synthesis of the information to provide valid conclusions.

5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern engineer
PO5 and modeling to complex engineering activities with an understanding of the limitations.

6. The engineer and society: Apply reasoning informed by the contextual knowledge to assess societa
issues and the consequent responsibilities relevant to the professional engineering practice.
PO6
7. Environment and sustainability: Understand the impact of the professional engineering solutions in s
PO7 and demonstrate the knowledge of, and need for sustainable development.

8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the en
PO8
9. Individual and team work: Function effectively as an individual, and as a member or leader in dive
PO9 settings.
10. Communication: Communicate effectively on complex engineering activities with the engineering co
such as, being able to comprehend and write effective reports and design documentation, make effective
PO10 clear instructions.

11. Project management and finance: Demonstrate knowledge and understanding of the engineering an
PO11 these to one’s own work, as a member and leader in a team, to manage projects and in multidisciplinary env

12. Life-long learning: Recognize the need for, and have the preparation and ability to engage in indep
broadest context of technological change.
PO12

PSO1 Capability to innovate, design, analyze and develop mechanical systems

Ability to build the nation by imparting technological inputs and managerial skills to become Technocrats a
PSO2 toward developing new concepts in emerging fields, and pursue advanced education.

Criteria
(CO-PO
Value
Mapping
|)
High 3

medium 2

low 1
no mappi blank
Fill Cells having yellow color Course Articulation Matrix (CO-PO M
Course
Outcomes Statement PO1 PO2 PO3 PO4 PO5 PO6
Awareness about different
types refrigeration systems
and illustrate basics, ideal
CO1 and actual
vapour refrigeration
absorption cycles 2 1
CO2 systemthe
using and identify of
principles methods 3 2 2
CO3 psychrometry. Also
conditioning systems, 3 2 3
CO4 human comfort
radiations andand airheat
other 2 2 2 3
CO5 transfers. 3 2 1 2
CO6
2 3 2 3 1
engineering fundamentals, and an engineering specialization to

analyze complex engineering problems reaching substantiated


ng sciences.

ring problems and design system components or processes that


th and safety, and the cultural, societal, and environmental

wledge and research methods including design of experiments,


alid conclusions.

urces, and modern engineering and IT tools including prediction


tations.

knowledge to assess societal, health, safety, legal and cultural


ng practice.

al engineering solutions in societal and environmental contexts,

sibilities and norms of the engineering practice.

a member or leader in diverse teams, and in multidisciplinary

ies with the engineering community and with society at large,


umentation, make effective presentations, and give and receive

anding of the engineering and management principles and apply


and in multidisciplinary environments.

d ability to engage in independent and life-long learning in the

ls to become Technocrats and Entrepreneurs, build the attitude


tion.

Matrix (CO-PO Mapping)), Subject- Refrigeration and Air-Conditioning

PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2


1 1

2 1
Instructions
1. Cells filled yellow needs to be entered by the faculty
2. Cells filled green or grey will be autocalculated
3. Fill Table1 for End term mapping with COs
4. Fill Table 3 for MTE and CWS mapping with Cos

Subject Details Faculty Details


Refrigeration
Name of the Faculty
Program B. Tech and Air- Dr. Manish Kumar
subject Name
Conditioning
Academic
2021-2022 Subject Code MET-325 Deparment Mechanical
Year
Number of Employee
Semester VI 118 mnitjas292
Students Code

Note: Please verify the number of CO of the course. If Number of CO`s is 4 then Co 5 leave it as blank
Copy paste the tick mark from here ü

CO'S Table 1. End Term (Mapping of Question with CO)


Q.01 Q.02 Q.03 Q.04 Q.05 Q.06 Q.07 Q.08 Q.09 Q.10
Maximum 3 3 4 4 4 8 12 12
marks
CO 1 ü ü
CO 2 ü ü ü ü
CO 3 ü ü ü
CO 4 ü ü ü
CO 5 ü
CO 6
Marks
allocated for
Question to
3 1.5 2 4 2 8 6 6
individual CO
Total Number of maped content 13 Total Maximum Marks 50

CO'S Table 2. End Term (Auto Calculated) %


Q.01 Q.02 Q.03 Q.04 Q.05 Q.06 Q.07 Q.08 Q.09 Q.10
Maximum
3 3 4 4 4 8 12 12 50
marks
CO 1 2 6 16
CO 2 1.5 2 8 6 35
CO 3 3 4 2 18
CO 4 1.5 2 6 19
CO 5 6 12
CO 6
100 Check for 100% after every entry

Table 3. Continous Evaluation (MTE +CWS)


CO'S MTE CWS (ASSIGNMENT/QUIZ ETC)
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Quiz-1 Viva Assignments A4 A5
Maximum
4 4 4 5 5 8 5 5 10
marks
CO 1 ü ü ü ü ü ü
CO 2 ü ü ü ü ü ü
CO 3 ü ü
CO 4 ü ü
CO 5 ü ü
CO 6

Marks
allocated for
Question to
4 2 4 5 5 4 2.5 1.6667 2
individual CO

Total Number of maped content 18 Total maximum Marks 50

CO'S MTE (Auto Calculated) CWS (ASSIGNMENT/QUIZ ETC) (Auto Calculated)


%
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 A1 A2 A3 A4 A5
Maximum
4 4 4 5 5 8 5 5 10 50
marks
CO 1 4 2 4 4 2.5 2 37
CO 2 2 5 5 4 2.5 2 41
CO 3 1.66667 2 7.33
CO 4 1.66667 2 7.33
CO 5 1.66667 2 7.33
CO 6
99.99 Check for 100% after every entry

Percentage of weight for level 3 attaintment may be set by Course coordinator from 45-80
Percentage of weight for level 3 attaintment 45
END Term MTE and CWS

MTE and 45 percent 45


CO'S END Term Weights 40
CWS of weight
35
Percentage Weight

CO 1 16 37 26.50 11.925 30
25
CO 2 35 41 38.00 17.1 20
CO 3 18 7.33 12.67 5.69925 15
CO 4 19 7.33 13.17 5.92425 10
5
CO 5 12 7.33 9.67 4.34925
0
CO 6 CO 1 CO 2 CO 3 CO 4 CO 5 CO 6
100

Continuous
S.No Roll.No. End Term (50) Evaluation CO1 CO2 CO3 CO4 CO5 CO6 TOTAL
(50)
1 2018UME1180 15.5 19.9 9.84 13.58 4.25 4.4 3.32 35
2 2018UME1462 0 0 0 0 0 0 0 0
3 2019UME1030 23.5 24.845 12.95 18.41 6.05 6.29 Err:520 Err:520
4 2019UME1038 13 29.1375 12.86 16.5 4.48 4.61 3.7 42
5 2019UME1076 28 25.735 14 20.35 6.93 7.21 5.25 54
6 2019UME1085 15.5 29.7475 13.49 17.62 4.97 5.13 4.04 45
7 2019UME1094 17 29.8025 13.75 18.17 5.24 5.41 4.22 47
8 2019UME1101 21.75 25.3075 12.84 17.99 5.77 5.99 4.47 47
9 2019UME1107 17.5 24.715 11.94 16.26 4.96 5.14 3.91 42
10 2019UME1108 16 35.3875 15.65 20.11 5.47 5.63 4.51 51
11 2019UME1121 26.5 36.1625 17.62 24.1 7.42 7.69 5.83 63
12 2019UME1126 25.5 41.0925 19.28 25.77 7.6 7.86 6.07 67
13 2019UME1132 19 31.47 14.68 19.55 5.73 5.92 4.59 50
14 2019UME1141 19 27.67 13.28 17.99 5.45 5.64 4.31 47
15 2019UME1152 33 41.2375 20.54 28.46 8.96 9.29 6.98 74
16 2019UME1158 19.5 27.38 13.25 18.05 5.52 5.71 4.35 47
17 2019UME1160 27.5 43.76 20.59 27.57 8.16 8.43 6.51 71
18 2019UME1164 12.5 23.95 10.86 14.19 4.01 4.13 3.26 36
19 2019UME1168 22 25.3225 12.89 18.08 5.82 6.04 4.5 47
20 2019UME1172 23 28.7875 14.33 19.85 6.25 6.48 4.87 52
21 2019UME1173 36.25 40.4 20.75 29.25 9.49 9.85 7.31 77
22 2019UME1174 24.75 36.325 17.4 23.56 7.12 7.37 5.63 61
23 2019UME1177 20 21.84 11.28 15.95 5.2 5.4 4 42
24 2019UME1178 22 25.3225 12.89 18.08 5.82 6.04 4.5 47
25 2019UME1180 9.5 25.6 10.99 13.82 3.59 3.68 3.02 35
26 2019UME1181 45.5 45.8625 24.25 34.73 11.55 12.01 8.82 91
27 2019UME1182 11.5 30.5275 13.14 16.54 4.31 4.42 3.62 42
28 2019UME1184 10.5 25.065 10.95 13.95 3.73 3.83 3.1 36
29 2019UME1188 24.5 35.0625 16.89 22.95 6.98 7.23 5.51 60
30 2019UME1189 12.5 30.665 13.35 16.95 4.5 4.62 3.75 43
31 2019UME1190 29.5 30.995 16.19 23.03 7.58 7.88 5.81 60
32 2019UME1191 10.75 28.525 12.27 15.46 4.03 4.13 3.38 39
33 2019UME1193 12 13.675 6.98 9.81 3.16 3.28 2.44 26
34 2019UME1194 19.5 26.6775 12.99 17.76 5.47 5.66 4.3 46
35 2019UME1197 15 24.32 11.4 15.22 4.48 4.63 3.58 39
36 2019UME1199 12.5 24.5975 11.1 14.46 4.05 4.18 3.3 37
37 2019UME1200 12.5 22.53 10.34 13.61 3.9 4.03 3.15 35
38 2019UME1201 38 46.3525 23.23 32.3 10.24 10.62 7.96 84
39 2019UME1202 20.5 29.6275 14.24 19.32 5.86 6.07 4.63 50
40 2019UME1203 25.5 33.93 16.63 22.84 7.08 7.33 5.55 59
41 2019UME1205 22 23.8375 12.34 17.47 5.71 5.93 4.39 46
42 2019UME1206 25.5 39.795 18.8 25.24 7.51 7.76 5.98 65
43 2019UME1208 29.25 46.53 21.9 29.31 8.68 8.97 6.92 76
44 2019UME1212 16 24.87 11.76 15.8 4.7 4.86 3.74 41
45 2019UME1213 31.5 37.1425 18.78 26.25 8.39 8.71 6.5 69
46 2019UME1214 21.5 30.5625 14.75 20.06 6.11 6.33 4.82 52
47 2019UME1215 22.5 27.2775 13.69 19.06 6.05 6.27 4.7 50
48 2019UME1217 28.75 28.525 15.15 21.76 7.27 7.55 5.54 57
49 2019UME1218 27 36.255 17.73 24.31 7.52 7.79 5.9 63
50 2019UME1219 16.5 20.645 10.28 14.24 4.48 4.65 3.49 37
51 2019UME1220 18.5 31.58 14.64 19.42 5.64 5.83 4.53 50
52 2019UME1223 29.5 37.4275 18.57 25.67 8.05 8.35 6.28 67
53 2019UME1227 23.5 32.6275 15.83 21.6 6.62 6.86 5.21 56
54 2019UME1228 31.5 40.8125 20.14 27.76 8.66 8.98 6.77 72
55 2019UME1230 24.75 41.825 19.44 25.81 7.52 7.77 6.04 67
56 2019UME1231 20.5 25.195 12.6 17.5 5.54 5.74 4.31 46
57 2019UME1232 32.5 33.53 17.61 25.12 8.31 8.63 6.36 66
58 2019UME1233 24.25 40.8475 18.99 25.23 7.36 7.6 5.9 65
59 2019UME1235 13.5 27.5275 12.35 16.01 4.45 4.58 3.64 41
60 2019UME1238 23 34.2525 16.35 22.09 6.65 6.88 5.27 57
61 2019UME1240 31.5 38.0625 19.12 26.63 8.46 8.77 6.57 70
62 2019UME1242 30 41.1 20.01 27.35 8.41 8.71 6.61 71
63 2019UME1243 20.5 35.7475 16.51 21.83 6.31 6.52 5.08 56
64 2019UME1245 16.5 29.7775 13.66 17.98 5.15 5.32 4.16 46
65 2019UME1246 22.5 33.5775 16.02 21.64 6.51 6.74 5.16 56
66 2019UME1248 19 28.87 13.72 18.49 5.54 5.73 4.4 48
67 2019UME1249 29.5 34.9625 17.66 24.66 7.87 8.17 6.1 64
68 2019UME1251 15 27.57 12.6 16.55 4.72 4.87 3.82 43
69 2019UME1291 23 28.09 14.07 19.57 6.2 6.43 4.82 51
70 2019UME1357 9 17.725 8 10.42 2.92 3.01 2.38 27
71 2019UME1366 14 21.235 10.1 13.61 4.08 4.22 3.24 35
72 2019UME1398 16.5 27.095 12.67 16.88 4.96 5.12 3.97 44
73 2019UME1419 19 20.29 10.55 14.97 4.91 5.1 3.77 39
74 2019UME1436 23 28.6725 14.29 19.81 6.24 6.47 4.86 52
75 2019UME1484 11 27.1375 11.8 14.98 3.97 4.08 3.31 38
76 2019UME1488 25.5 34.66 16.9 23.14 7.13 7.39 5.6 60
77 2019UME1542 26.5 34.2775 16.92 23.33 7.28 7.55 5.69 61
78 2019UME1561 33.5 34.3775 18.08 25.82 8.55 8.88 6.54 68
79 2019UME1581 34 41.0525 20.63 28.73 9.13 9.47 7.09 75
80 2019UME1586 16.5 28.6625 13.25 17.53 5.07 5.24 4.08 45
81 2019UME1591 18.75 18.0425 9.68 13.96 4.7 4.89 3.57 37
82 2019UME1605 17.75 28.9275 13.54 18.07 5.32 5.49 4.25 47
83 2019UME1611 15 23.57 11.12 14.91 4.43 4.58 3.53 39
84 2019UME1628 23.25 28.615 14.31 19.87 6.28 6.51 4.89 52
85 2019UME1629 16 32.2525 14.49 18.82 5.24 5.4 4.28 48
86 2019UME1637 21.75 32.9925 15.69 21.14 6.33 6.55 5.03 55
87 2019UME1641 35 36.7225 19.19 27.31 8.99 9.34 6.89 72
88 2019UME1642 17.5 26.73875 12.69 17.09 5.11 5.28 4.06 44
89 2019UME1662 33 36.785 18.89 26.63 8.64 8.97 6.66 70
90 2019UME1678 12.5 22.9975 10.51 13.8 3.94 4.06 3.19 36
91 2019UME1688 27 39.485 18.93 25.64 7.75 8.02 6.13 66
92 2019UME1699 18.75 31.64 14.71 19.53 5.69 5.88 4.57 50
93 2019UME1706 13.5 21.8 10.23 13.66 4.03 4.16 3.22 35
94 2019UME1712 16 29.57 13.5 17.72 5.05 5.21 4.09 46
95 2019UME1715 36 45.435 22.57 31.23 9.81 10.17 7.65 81
96 2019UME1716 18.75 21.2775 10.87 15.29 4.93 5.12 3.81 40
97 2019UME1723 16.5 26.8125 12.56 16.77 4.94 5.1 3.95 43
98 2019UME1725 15.5 23.315 11.11 14.98 4.5 4.65 3.57 39
99 2019UME1729 21 28.185 13.79 18.91 5.85 6.06 4.59 49
100 2019UME1730 26.5 32.5275 16.28 22.61 7.15 7.42 5.56 59
101 2019UME1731 33.5 41.31 20.64 28.66 9.06 9.39 7.05 75
102 2019UME1738 11.5 23.75 10.63 13.76 3.81 3.93 3.12 35
103 2019UME1739 19.5 33.4475 15.5 20.54 5.96 6.16 4.79 53
104 2019UME1746 23.5 33.81 16.27 22.09 6.71 6.94 5.3 57
105 2019UME1756 20 23.205 11.79 16.51 5.3 5.5 4.1 43
106 2019UME1760 15 26.8375 12.33 16.25 4.67 4.82 3.77 42
107 2019UME1783 22 30.8225 14.92 20.34 6.22 6.44 4.9 53
108 2019UME1808 23 39.685 18.36 24.32 7.05 7.28 5.67 63
109 2019UME1810 14.5 26.6125 12.17 15.99 4.56 4.71 3.69 41
110 2019UME1826 0 0 0 0 0 0 0 0
111 2019UME1827 27.5 30.4625 15.67 22.11 7.18 7.46 5.53 58
112 2019UME1830 10.5 24.5125 10.75 13.73 3.69 3.79 3.06 35
113 2019UME1837 12.75 23.1775 10.62 13.97 3.99 4.12 3.23 36
114 2019UME1843 24.5 33.88 16.46 22.47 6.89 7.14 5.42 58
115 2019UME1854 14.5 26.68 12.19 16.01 4.57 4.71 3.7 41
116 2019UME1881 26 28.9225 14.86 20.96 6.8 7.06 5.24 55
117 2019UME1882 14.5 23.265 10.93 14.61 4.32 4.46 3.45 38
118 2019UME1883 16.5 23.53 11.35 15.42 4.69 4.86 3.7 40
0 0 0 0 0 0
0 0 0 0 0 0
Average 14.41 19.59 5.97 6.18 Err:520 Err:520
TOTAL Number of student 118 Wieghtage 26.50 38.00 12.67 13.17 9.67 99.995

No of
students
securing 89 76 61 60 65
above 45%
marks

Percentage
of students
75.42 64.41 51.69 50.85 55.08
scoring
above 45%

Average marks basis

Criteria
Percentage of
students
scoring Attainment
above 60 %
marks
>=60% 3
<60 %, >=50% 2
below 50% 1
CO Attainment
Level Average Marks Basis
Percentage of
students scoring CO Attainment Target
CO'S level Average
above 45% Marks basis Achieved
marks 3.5

3.0
CO 1 75.42 3 H Y
CO 2 64.41 3 H Y 2.5
CO Attainment

CO 3 51.69 2 M N
2.0
CO 4 50.85 2 M N
CO 5 55.08 2 M N 1.5
CO 6 1.0
0.5

0.0
CO 1 CO 2 CO 3 CO 4 CO 5 CO 6
Course Outcomes
Instructions
1. No entry need to be make in this sheet
2. Cells filled green, grey,orange will be autocalculated

Criteria (CO-PO Mapping|) Value


High 3
medium 2
low 1
no mapping blank
Course Articulation Matrix for the course (C
Course Outcomes PO1 PO2 PO3 PO4 PO5
CO1 heat pump cycle and their analysis 2
CO2 performance improvement. Also identify 3 2 2
CO3 interpret cooling and heating loads in an 3 2 3
CO4 human comfort and air distribution system 2 2 2 3
CO5 transfers. 3 2 1 2
CO6 0
2 3 2 3

Po-Attaintment for the cou

COs
attainme
nt taken
from CO
calculatio
CO n PO1 PO2 PO3 PO4 PO5
CO1 3.0 2.0
CO2 3.0 3.0 2.0 2.0
CO3 2.0 2.0 1.3 2.0
CO4 2.0 1.3 1.3 1.3 2.0
CO5 2.0 2.0 1.3 0.7 1.3
CO6
Average 2.0 2.0 1.0 2.0

Prgoram Outcome of
coo
Subject
Subject Name Code PO1 PO2 PO3 PO4 PO5
Refrigeration and Air-
Conditioning MET-325 2.0 2.0 1.0 2.0
ix for the course (CO-PO mapping)
PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2
1 1 1

1 2 1

intment for the course (Auto calculated )

PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2


1.0 1.0 1.0

1.3

1.0 1.0 1.0

goram Outcome of the course (Data for OBE


coordinator)

PO6 PO7 PO7 PO8 PO9 PO10 PO11 PSO1 PO12

1.0 1.0 1.0


PO Calculated -Subject
2.5

2.0

1.5

1.0

0.5

0.0
PO1 PO2 PO3 PO4 PO5 PO6
PO6

You might also like