ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
COURSE ATTAINMENT FROM MARKS - CALCULATION STEPS
2
To be done by faculty
3
1Change the given file name with Batch-Course Code-Course Name Course Attainment
4
2In the 'Subject Data' sheet, fill in the required details.
5
Batch
6
Course Code - Course Title
7
Academic Year
8
Semester
9
10
Evaluation Components (%)
11
Cummulative Internal Component[CIE] (%)
12
Semester End Examinations [SEE](%)
13
14
Threshold (%)
15
Target (%)
16
3Fill in the CO-PO Mapping (Affinity mapping)
17
4Fill in the Indirect CO Assessment from CMS Course feedback.
18
5Fill in the Names and Roll numbers for the respective batches.
19
6Enter marks for Batch - A, B, C and D - In all sheets, enter max marks and CO for each question.
20
7
Go to 'Weighted PO Attain Contribution' sheet. You will find your Course Attainment on the 11th row. This is the row that has to be submitted for Program Attainment Calculation.
21
8Verify the 'Printout' sheet before printing.
22
23
24
25
26
27
28
60%
29
60%
30
70
31
30
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100