Grade - 7 Item Analysis
Grade - 7 Item Analysis
Grade - 7 Item Analysis
Directions: Enter teacher, class information, student names etc. in the brown cells. When entering data in the blue or white cells, enter a character only if the question was answered CORRECTLY. Do not ente
Of Questions' OR ' # Of Students' cells. ***NOTICE*** There are two graph tabs at the bottom of the spreadsheet.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
1
2
3
4
5
6
7
8
9
Ansing, Reynaldo A. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Baluit, Cris-Mark S. 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Barol, Jhon Llyud M. 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Basmayor, Frances G. 4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Bongcalon, Dixter M. 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Cabahug, Scepter Jhon 6 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 1 1 1 1
Cristoria, Dinnes L. 7 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Etang, James Kie A. 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Fajardo, Junrel P. 9 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Gumaod, Joselito D. 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Jumachag, Joshua A. 11 1 1 1 1 1 1 1 1 1 1+M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Ligao, Ryan Jay P. 12 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Beronguez, Danny Mar E 13 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Macadildig, Roy G. 14 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Macadildig, Johny M. 15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Narciso, Reymart V. 16 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Narciso, Ronel 17 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Neniel, Je-Ar L. 18 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Neri, Clent Ryan D. 19 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Palaca, Maico 20 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Pamaybay, Ryan T. 21 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Pracueles, Suren D. 22 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Ricanillo, Roger Jr. P. 23 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Rojas, Reniel T. 24 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Rubia, Hilbert V. 25 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Sanchez, Alfer A. 26 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Sicad, Armando Jr. E. 27 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Tagaytay, Jonel B. 28 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Tagaytay, Ronald, B. 29 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Templa, Adrian Criz E. 30 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Matanog, Jangil M. 31 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Almirante, Cherryl Joy C. 32 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Angus, Irish Nicole S. 33 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Bucog, Ea-mie S. 34 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Bustamante, Kristine Mie 35 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Canete, Cristine M. 36 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Canete, Romelyn M. 37 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Colong, Angelica B. 38 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Evedientes, Jehanny C. 39 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Evedientes, Rea Jean P. 40 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Evedientes, Reamay M. 41 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Lagnason, Jura Mae E. 42 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Manatad, Airene M. 43 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Marmis, Cristen S. 44 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Masayon, Angel C. 45 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Monggas, Rose Fe V. 46 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Pangaral, Marjorie S. 47 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1
1 1 1
1 1 1 1 1 1 1
Sarda, Mey Flor P. 48 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Sarmiento, Mica B. 49 1 1 1 1 11 1 1 1 1 1 1 1 1 1 1 1 1
Suerte, Emelyn Z. 50 1 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Tagaytay, Jessanie B. 51 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Tagaytay, Melody B. 52 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Tagaytay, Melody B. 53 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
# Of Items Answered Correctly 45 33 43 34 46 35 39 41 32 23 32 26 22 32 26 31 37 36 36 40 41 33 41 38 42 36 33 35 29 42 35 37 37 29 39 34 37 36
% Of Students Who Answered
85%
62%
81%
64%
87%
66%
74%
77%
60%
43%
60%
49%
42%
60%
49%
58%
70%
68%
68%
75%
77%
62%
77%
72%
79%
68%
62%
66%
55%
79%
66%
70%
70%
55%
74%
64%
70%
68%
The Question/Item Correctly
nalysis Calculator >>>>>
n the blue or white cells, enter a character only if the question was answered CORRECTLY. Do not enter data in the '#
adsheet.
# Of Correct Answers
Student Score
39
40
1 1 33 83%
30 75%
1 30 75%
1 1 29 73%
25 63%
1 30 75%
1 1 34 85%
1 32 80%
1 1 22 55%
1 1 28 70%
28 70%
1 1 35 88%
1 1 28 70%
1 1 31 78%
1 32 80%
1 20 50%
26 65%
1 1 25 63%
1 1 27 68%
1 18 45%
1 30 75%
1 1 28 70%
1 1 25 63%
1 27 68%
1 1 23 58%
1 20 50%
19 48%
1 26 65%
1 1 20 50%
1 1 21 53%
1 1 30 75%
1 30 75%
1 1 33 83%
1 19 48%
1 1 30 75%
1 24 60%
1 1 33 83%
1 1 34 85%
1 30 75%
1 1 27 66%
1 1 28 70%
1 21 53%
1 31 78%
1 29 73%
1 1 30 75%
1 19 48%
1 1 35 88%
1 18 45%
1 19 48%
1 1 31 78%
1 1 25 63%
1 19 48%
1 19 48%
33
62% 41
77%
Student Score
100%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
Ansing, Reynaldo A. 83%
75%
Barol, Jhon Llyud M. 75%
73%
Bongcalon, Dixter M. 63%
75%
Cristoria, Dinnes L. 85%
80%
Fajardo, Junrel P. 55%
70%
Jumachag, Joshua A. 70%
88%
Beronguez, Danny Mar E. 70%
78%
Macadildig, Johny M. 80%
50%
Narciso, Ronel 65%
63%
Neri, Clent Ryan D. 68%
45%
Pamaybay, Ryan T. 75%
70%
Ricanillo, Roger Jr. P. 63%
68%
Rubia, Hilbert V. 58%
50%
Sicad, Armando Jr. E. 48%
65%
Tagaytay, Ronald, B. 50%
53%
Matanog, Jangil M. 75%
75%
Angus, Irish Nicole S. 83%
48%
Student Score Analysis
100%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
1 85%
2 62%
3 81%
4 64%
5 87%
6 66%
7 74%
8 77%
9 60%
10 43%
11 60%
12 49%
13 42%
14 60%
15 49%
16 58%
17 70%
18 68%
19 68%
20 75%
Question# / Item
21 77%
22 62%
23 77%
Test Item Analysis
24 72%
25 79%
26 68%
27 62%
28 66%
29 55%
30 79%
31 66%
32 70%
33 70%
34 55%
35 74%
36 64%
37 70%
38 68%
39 62%
40 77%