Appendix A – test data from four option multiple choice

Step 1 HIGH LIGHT EMPTY CELLS AND ADJUST COLUM WIDTH TO 5

Key C B D D B C D A C B A C B D A A C D B C
St No Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20
1 C B B A C D A   D D A D A A A A C B D B
2 C B D D B D A A C B A C B D A A C D B C
3 C B D D B C D A C B A C B D A A C B D C
4 C B D B B C B A C B A C A D C A C B C C
5 C B D C B C B A C D A C B D A A A B B C
6 C A D D C C A D C D A C A D A A A B D C
7 B B A B B C B B D D A C B D C A A D D C
8 C B D B B C B D B C A C B D A A C A B A
9 C B D A B C D D B D A C B D A A C B D A
10 C B B A B C D C D C A B A D D A C D B C
11 C B D D B C D A C B A C B D A A C D B C
12 C B D D B C D D D A A C A D A A C B B D
13 C B D A B C D A C B A C B D A A A B B C
14 C B D A B C D A C B A C B D A A A   B C
15 C B D D B B A A B D A C D A A C B B D D
16 C B D D B C D A C B A C B D A A C D B C
17 B B C C B A D D C   A D B D A     C A D
18 C B B D B A D D D D A C A D A A C B B C
19 D C A D B A B A D C C D A A D B B B A B
20 C B D D B C D A C A C D B D A A C D B C
21 C A D D C C A D C D A C A D A A A B D C
22 B B A B B C B B D D A C B D C A A D D C
23 C B D B B C B D B C A C B D A A C A B A
24 C B B A C D A   D D A D A A A A C B D B
25 C B D D B D A A C B A C B D A A C D B C

Appendix B – conversion of data and sorting

 Step COPYING AND PASTING AS Step
4 VALUES 5 SORTING IN DESCENDING ORDER BY %

Key C B D D B C D A C B A C B D A A C D B C Total %
St No Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Score Mark
11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20 100%
16 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20 100%
2 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 18 90%
3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 18 90%
25 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 18 90%
13 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 17 85%
14 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0   1 1 17 85%
20 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 17 85%
5 1 1 1 0 1 1 0 1 1 0 1 1 1 1 1 1 0 0 1 1 15 75%
4 1 1 1 0 1 1 0 1 1 1 1 1 0 1 0 1 1 0 0 1 14 70%
12 1 1 1 1 1 1 1 0 0 0 1 1 0 1 1 1 1 0 1 0 14 70%
8 1 1 1 0 1 1 0 0 0 0 1 1 1 1 1 1 1 0 1 0 13 65%
9 1 1 1 0 1 1 1 0 0 0 1 1 1 1 1 1 1 0 0 0 13 65%
18 1 1 0 1 1 0 1 0 0 0 1 1 0 1 1 1 1 0 1 1 13 65%
23 1 1 1 0 1 1 0 0 0 0 1 1 1 1 1 1 1 0 1 0 13 65%
10 1 1 0 0 1 1 1 0 0 0 1 0 0 1 0 1 1 1 1 1 12 60%
6 1 0 1 1 0 1 0 0 1 0 1 1 0 1 1 1 0 0 0 1 11 55%
21 1 0 1 1 0 1 0 0 1 0 1 1 0 1 1 1 0 0 0 1 11 55%
7 0 1 0 0 1 1 0 0 0 0 1 1 1 1 0 1 0 1 0 1 10 50%
22 0 1 0 0 1 1 0 0 0 0 1 1 1 1 0 1 0 1 0 1 10 50%
15 1 1 1 1 1 0 0 1 0 0 1 1 0 0 1 0 0 0 0 0 9 45%
17 0 1 0 0 1 0 1 0 1   1 0 1 1 1     0 0 0 8 40%
1 1 1 0 0 0 0 0   0 0 1 0 0 0 1 1 1 0 0 0 6 30%
24 1 1 0 0 0 0 0   0 0 1 0 0 0 1 1 1 0 0 0 6 30%
19 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 15%

Appendix C – Grouping Scores

 Step 5 DETERMINE GROUP NUMBERS

Key Total %
St No Score Mark GROUPS
11 20 100% Upper Group
16 20 100% Upper Group
2 18 90% Upper Group
3 18 90% Upper Group
25 18 90% Upper Group
13 17 85% Upper Group
14 17 85% Upper Group
20 17 85% Upper Group
5 15 75% Upper Group
4 14 70% Upper Group
12 14 70% Upper Group
8 13 65% Upper Group
9 13 65% Upper Group
18 13 65% Upper Group
23 13 65% Upper Group
10 12 60% Lower Group
6 11 55% Lower Group
21 11 55% Lower Group
7 10 50% Lower Group
22 10 50% Lower Group
15 9 45% Lower Group
17 8 40% Lower Group
1 6 30% Lower Group
24 6 30% Lower Group
19 3 15% Lower Group

Upper Group 15
Lower Group 10

Appendix D – Grouped Frequencies

    TABULATING      
 GROUPED
FREQUENCIE
S

LL UP MP f Groups f
15 24 19.5 1 15-24 1
25 34 29.5 2 25-34 2
35 44 39.5 1 35-44 1
45 54 49.5 3 45-54 3
55 64 59.5 3 55-64 3
65 74 69.5 6 65-74 6
75 84 79.5 1 75-84 1
85 94 89.5 6 85-94 6
95 104 99.5 2 95-104 2

CALCULATING CUMULATIVE FREQUENCIES

LL UP MP f Groups UP a-z cf
15 24 19.5 1 15-24 24 1
25 34 29.5 2 25-34 34 3
35 44 39.5 1 35-44 44 4
45 54 49.5 3 45-54 54 7
55 64 59.5 3 55-64 64 10
65 74 69.5 6 65-74 74 16
75 84 79.5 1 75-84 84 17
85 94 89.5 6 85-94 94 23
95 104 99.5 2 95-104 104 25

Appendix E - Formulas

R = highest score - lowest score

 Difficulty Index key

p Values Result Code

p>=and <20 Unacceptable Un
p>=20 and <30 Too Difficult T.d
p>=30 and <70 Acceptable Acc
p>=70 and < 80 Too Easy T.e
p>=80 Unacceptable Unn

Discrimination Index key

D Values Result Code

D>0 Positive Acc
D=0 Zero Un
D<0 Negative Unn
Appendix F - Summary

30

25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
25 24 24 24 24
23

20

# Correct
# Answered
15 15 15 15 15 p [Diff.index]
15 14 14 14 14
# LG Correct
12 12 12 12 # UG Correct
11 D [Disc.index]
10 10
10 9 9
8 8
7 7
6 6 6 6
5 5 5 5
5 4
3 3 3 3 3
2 2
0.840.600.880.530.680.790.480.500.840.600.680.580.440.780.520.800.520.70 1.000.92 0.760.640.600.750.840.600.800.570.920.530.630.75 10.92
0.330 0.36 0.330.400.52 0.640.55
0
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20