Appendices
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Appendices as PDF for free.
More details
- Words: 1,578
- Pages: 6
Appendix A – test data from four option multiple choice Step 1
HIGH LIGHT EMPTY CELLS AND ADJUST COLUM WIDTH TO 5
Key St No
C Q1
B Q2
D Q3
D Q4
B Q5
C Q6
D Q7
A Q8
C Q9
B Q10
A Q11
C Q12
B Q13
D Q14
A Q15
A Q16
C Q17
D Q18
B Q19
C Q20
1 2 3 4 5 6 7 8 9 10 11 12 13
C C C C C C B C C C C C C
B B B B B A B B B B B B B
B D D D D D A D D B D D D
A D D B C D B B A A D D A
C B B B B C B B B B B B B
D D C C C C C C C C C C C
A A D B B A B B D D D D D
A A A A D B D D C A D A
D C C C C C D B B D C D C
D B B B D D D C D C B A B
A A A A A A A A A A A A A
D C C C C C C C C B C C C
A B B A B A B B B A B A B
A D D D D D D D D D D D D
A A A C A A C A A D A A A
A A A A A A A A A A A A A
C C C C A A A C C C C C A
B D B B B B D A B D D B B
D B D C B D D B D B B B B
B C C C C C C A A C C D C
14 15 16
C C C
B B B
D D D
A D D
B B B
C B C
D A D
A A A
C B C
B D B
A A A
C C C
B D B
D A D
A A A
A C A
A B C
B D
B D B
C D C
17 18 19 20 21 22 23
B C D C C B C
B B C B A B B
C B A D D A D
C D D D D B B
B B B B C B B
A A A C C C C
D D B D A B B
D D A A D B D
C D D C C D B
D C A D D C
A A C C A A A
D C D D C C C
B A A B A B B
D D A D D D D
A A D A A C A
A B A A A A
C B C A A C
C B B D B D A
A B A B D D B
D C B C C C A
24 25
C C
B B
B D
A D
C B
D D
A A
A
D C
D B
A A
D C
A B
A D
A A
A A
C C
B D
D B
B C
Appendix B – conversion of data and sorting
Step 4
Key St No 11 16 2 3 25 13 14 20 5 4 12 8 9 18 23 10 6 21 7 22 15 17 1 24 19
C Q1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 0
COPYING AND PASTING AS VALUES
B Q2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0
D Q3 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 1 0 0 0 0
D Q4 1 1 1 1 1 0 0 1 0 0 1 0 0 1 0 0 1 1 0 0 1 0 0 0 1
B Q5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 0 1
Appendix C – Grouping Scores
C Q6 1 1 0 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 0 0
D Q7 1 1 0 1 0 1 1 1 0 0 1 0 1 1 0 1 0 0 0 0 0 1 0 0 0
Step 5
A Q8 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 0
1
C Q9 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0
B Q10 1 1 1 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A Q11 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0
C Q12 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 0 0 0
B Q13 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 0 0 1 1 0 1 0 0 0
D Q14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 0 0
A Q15 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 0 1 1 1 1 0
SORTING IN DESCENDING ORDER BY %
A Q16 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0
C Q17 1 1 1 1 1 0 0 1 0 1 1 1 1 1 1 1 0 0 0 0 0
1 1 0
1 1 0
D Q18 1 1 1 0 1 0 1 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0
B Q19 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0
C Q20 1 1 1 1 1 1 1 1 1 1 0 0 0 1 0 1 1 1 1 1 0 0 0 0 0
Total Score 20 20 18 18 18 17 17 17 15 14 14 13 13 13 13 12 11 11 10 10 9 8 6 6 3
% Mark 100% 100% 90% 90% 90% 85% 85% 85% 75% 70% 70% 65% 65% 65% 65% 60% 55% 55% 50% 50% 45% 40% 30% 30% 15%
Step 5
Key St No 11 16 2 3 25 13 14 20 5 4 12 8 9 18 23 10 6 21 7 22 15 17 1 24 19
DETERMINE GROUP NUMBERS
Total Score 20 20 18 18 18 17 17 17 15 14 14 13 13 13 13 12 11 11 10 10 9 8 6 6 3
Upper Group Lower Group
% Mark 100% 100% 90% 90% 90% 85% 85% 85% 75% 70% 70% 65% 65% 65% 65% 60% 55% 55% 50% 50% 45% 40% 30% 30% 15%
GROUPS Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group
15 10
Appendix D – Grouped Frequencies TABULATING
GROUPED FREQUENCIE S
LL 15 25 35 45 55 65 75 85 95
UP 24 34 44 54 64 74 84 94 104
MP 19.5 29.5 39.5 49.5 59.5 69.5 79.5 89.5 99.5
f 1 2 1 3 3 6 1 6 2
Groups 15-24 25-34 35-44 45-54 55-64 65-74 75-84 85-94 95-104
f 1 2 1 3 3 6 1 6 2
CALCULATING CUMULATIVE FREQUENCIES
LL 15 25 35 45 55 65 75 85 95
UP 24 34 44 54 64 74 84 94 104
MP 19.5 29.5 39.5 49.5 59.5 69.5 79.5 89.5 99.5
f 1 2 1 3 3 6 1 6 2
Groups 15-24 25-34 35-44 45-54 55-64 65-74 75-84 85-94 95-104
Appendix E - Formulas R = highest score - lowest score
UP a-z 24 34 44 54 64 74 84 94 104
cf 1 3 4 7 10 16 17 23 25
Difficulty Index key p Values p>=and <20 p>=20 and <30 p>=30 and <70 p>=70 and < 80 p>=80
Result Unacceptable
Too Difficult Acceptable Too Easy Unacceptable
Code Un T.d Acc T.e Unn
Discrimination Index key D Values D>0 D=0 D<0
Result Positive
Zero Negative
Code Acc Un Unn
Appendix F - Summary
HIGH LIGHT EMPTY CELLS AND ADJUST COLUM WIDTH TO 5
Key St No
C Q1
B Q2
D Q3
D Q4
B Q5
C Q6
D Q7
A Q8
C Q9
B Q10
A Q11
C Q12
B Q13
D Q14
A Q15
A Q16
C Q17
D Q18
B Q19
C Q20
1 2 3 4 5 6 7 8 9 10 11 12 13
C C C C C C B C C C C C C
B B B B B A B B B B B B B
B D D D D D A D D B D D D
A D D B C D B B A A D D A
C B B B B C B B B B B B B
D D C C C C C C C C C C C
A A D B B A B B D D D D D
A A A A D B D D C A D A
D C C C C C D B B D C D C
D B B B D D D C D C B A B
A A A A A A A A A A A A A
D C C C C C C C C B C C C
A B B A B A B B B A B A B
A D D D D D D D D D D D D
A A A C A A C A A D A A A
A A A A A A A A A A A A A
C C C C A A A C C C C C A
B D B B B B D A B D D B B
D B D C B D D B D B B B B
B C C C C C C A A C C D C
14 15 16
C C C
B B B
D D D
A D D
B B B
C B C
D A D
A A A
C B C
B D B
A A A
C C C
B D B
D A D
A A A
A C A
A B C
B D
B D B
C D C
17 18 19 20 21 22 23
B C D C C B C
B B C B A B B
C B A D D A D
C D D D D B B
B B B B C B B
A A A C C C C
D D B D A B B
D D A A D B D
C D D C C D B
D C A D D C
A A C C A A A
D C D D C C C
B A A B A B B
D D A D D D D
A A D A A C A
A B A A A A
C B C A A C
C B B D B D A
A B A B D D B
D C B C C C A
24 25
C C
B B
B D
A D
C B
D D
A A
A
D C
D B
A A
D C
A B
A D
A A
A A
C C
B D
D B
B C
Appendix B – conversion of data and sorting
Step 4
Key St No 11 16 2 3 25 13 14 20 5 4 12 8 9 18 23 10 6 21 7 22 15 17 1 24 19
C Q1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 0
COPYING AND PASTING AS VALUES
B Q2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0
D Q3 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 1 0 0 0 0
D Q4 1 1 1 1 1 0 0 1 0 0 1 0 0 1 0 0 1 1 0 0 1 0 0 0 1
B Q5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 0 1
Appendix C – Grouping Scores
C Q6 1 1 0 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 0 0
D Q7 1 1 0 1 0 1 1 1 0 0 1 0 1 1 0 1 0 0 0 0 0 1 0 0 0
Step 5
A Q8 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 0
1
C Q9 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0
B Q10 1 1 1 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A Q11 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0
C Q12 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 0 0 0
B Q13 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 0 0 1 1 0 1 0 0 0
D Q14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 0 0
A Q15 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 0 1 1 1 1 0
SORTING IN DESCENDING ORDER BY %
A Q16 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0
C Q17 1 1 1 1 1 0 0 1 0 1 1 1 1 1 1 1 0 0 0 0 0
1 1 0
1 1 0
D Q18 1 1 1 0 1 0 1 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0
B Q19 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0
C Q20 1 1 1 1 1 1 1 1 1 1 0 0 0 1 0 1 1 1 1 1 0 0 0 0 0
Total Score 20 20 18 18 18 17 17 17 15 14 14 13 13 13 13 12 11 11 10 10 9 8 6 6 3
% Mark 100% 100% 90% 90% 90% 85% 85% 85% 75% 70% 70% 65% 65% 65% 65% 60% 55% 55% 50% 50% 45% 40% 30% 30% 15%
Step 5
Key St No 11 16 2 3 25 13 14 20 5 4 12 8 9 18 23 10 6 21 7 22 15 17 1 24 19
DETERMINE GROUP NUMBERS
Total Score 20 20 18 18 18 17 17 17 15 14 14 13 13 13 13 12 11 11 10 10 9 8 6 6 3
Upper Group Lower Group
% Mark 100% 100% 90% 90% 90% 85% 85% 85% 75% 70% 70% 65% 65% 65% 65% 60% 55% 55% 50% 50% 45% 40% 30% 30% 15%
GROUPS Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Upper Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group Lower Group
15 10
Appendix D – Grouped Frequencies TABULATING
GROUPED FREQUENCIE S
LL 15 25 35 45 55 65 75 85 95
UP 24 34 44 54 64 74 84 94 104
MP 19.5 29.5 39.5 49.5 59.5 69.5 79.5 89.5 99.5
f 1 2 1 3 3 6 1 6 2
Groups 15-24 25-34 35-44 45-54 55-64 65-74 75-84 85-94 95-104
f 1 2 1 3 3 6 1 6 2
CALCULATING CUMULATIVE FREQUENCIES
LL 15 25 35 45 55 65 75 85 95
UP 24 34 44 54 64 74 84 94 104
MP 19.5 29.5 39.5 49.5 59.5 69.5 79.5 89.5 99.5
f 1 2 1 3 3 6 1 6 2
Groups 15-24 25-34 35-44 45-54 55-64 65-74 75-84 85-94 95-104
Appendix E - Formulas R = highest score - lowest score
UP a-z 24 34 44 54 64 74 84 94 104
cf 1 3 4 7 10 16 17 23 25
Difficulty Index key p Values p>=and <20 p>=20 and <30 p>=30 and <70 p>=70 and < 80 p>=80
Result Unacceptable
Too Difficult Acceptable Too Easy Unacceptable
Code Un T.d Acc T.e Unn
Discrimination Index key D Values D>0 D=0 D<0
Result Positive
Zero Negative
Code Acc Un Unn
Appendix F - Summary
Related Documents
Appendices
November 2019 35
Appendices
June 2020 19
Appendices
June 2020 27
Appendices
October 2019 29
Appendices
May 2020 19