<<<<< Test Item Analysis Calculator >>>>>

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.
OR ' # Of Students' cells. ***NOTICE*** There are two graph tabs at the bottom of the spreadsheet.

Assessment: PERIODICAL EXAM Teacher: JESREEL B. DANIEL

Period: THIRD Grade(s): 12
Date Of Assessment: # Of Questions: 50 # Of Students 39

<<< Student #

Question# / Item > >>

Student Names

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
39
40
1
2
3
4
5
6
7
8
9
ABENION,LANCE JOSEPH CASTILLO P 1 P P P P P P P P P P P P P P P P P P P P P P P P
ALINSOOT,ERIC RAPSING 2 P P P P P P P P P P P P P P
AREVALO,JOHN PHILIP BIDOR 3 P P P P P P P P P P P P P P P P
Balaguza Ivan, 4 P P P P P P P P P P P
BUTAL,DANIEL JOHN BARRUN 5 P P P P P P P P P P P P P P P
CASTILLO,STEVEN LLOYD GRATE 6 P P P P P P P P P P P P P P P P P P
DELA CRUZ,JOE MARKWIN BACARON 7 P P P P P P P P P P P P
DESABELLE,JESON SUMALINOG 8 P P P P P P P P P P P
MANLAPAS,HAROLD REAL 9 P P P P P P P P P P P P P P P P P P P
NAVARRO,ARVEN SARCINO 10 P P P P P P P P P P P P P P
RAMO,LOISARD DELA CRUZ 11 P P P P P P P P P P P P P P P
RAMOS,JAY BENSAY 12 P P P P P P P P
RAPSING,SUNNY DOMINGO ROMBLON 13 P P P P P P P P P P P P P
REPOLONA,DAREL CAPINIG 14 P P P P P P P P P
SANTUELE,CARLOS RUEL RABINO 15 P P P P P P P P P P P P P P
SESE,RUDY CAASI 16 P P P P P P P P P P P P P
SOLIS,MARK IAN SOLINAP 17 P P P P P P P P P P P P P
TOMLOD,ARYEN ORTEGA 18 P P P P P P P P P P P P P P P P P P P P P
URSAL,GABRIEL RECTO 19 P P P P P P P P P P P P P P P P P P P P P P
ABENION,JESSA MAE CASTILLO 20 P 1 P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ABULENCIA,JULIE ROSE URSAL 21 P P P P P P P P P P P P P P
CANINO,REMYJOY MAGLUYAN 22 P P P P P P P P P P P P P P P P P P P P P P P
CAPINIG,DONALYN - 23 P P P P P P P P P P P P P P P P P P P P P P P P
CAPINIG,ELMAR DEQUINO 24 P P P P P P P P P P P P P P P P P P P
COMMISION,JESSA NOVABOS 25 P P P P P P P P P P P P P P P P
DEALDE,LYKEE DEQUINO 26 P P P P P P P P P P P P P P P P P P P P P P P P P P P P
INOPIA,CHARLENE VILLAR 27 P P P P P P P P P P P P P P P P P P P P P
NARCISO,MARY JANE SESE 28 P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RACE,JUDY-ANN CAPINIG 29 P P P P P P P P P P P P P P P P P P
RADA,JUDY ANN REGALA 30 1P P P P P P P P P P P P P P
RAMO,REYJEAN VILLAR 31 P P P P P P P P P P P P P P P P P P P P P P P P P
ROXAS,ARNELA MIRALLES 32 P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SABANGAN,LOWELLA MERCOLITA 33 P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SOLIS,VERLYN MIRALLES 34 P P P P P P P P P P P P P P P P P
TOLIBAT,NIKKI MESIAS 35 P P P P P P P P P P P P P P
VERALLO,SHAIRA CABAHOG 36 P P P P P P P P P P P P P P
VILLANUEVA,AIDA ROMBLON 37 P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
VILLAR,VANESSA BERNALES 38 P P P P P P P P P P P P P P P P P P P P P P P
ZURBITO,REGINE GUETA 39

42
43
# Of Items Answered Correctly############ 20 21 18######### 15 19 14######################## 18### 14###### 19 14###### 18 18 13 19 18 17 18### 20 18
% Of Students Who Answered The
51%
54%
46%

38%
49%
36%

46%

36%

49%
36%

46%
46%
33%
49%
46%
44%
46%

51%
46%
###
###
###
###

###
###
###

###
###
###
###
###
###
###
###

###

###
###

###
###

###
Question/Item Correctly
nalysis Calculator >>>>>
ue or white cells, enter a character only if the question was answered CORRECTLY. Do not enter data in the '# Of Questions'

# Of Correct Answers

Student Score
41
42
43
44
45
46
47
48
49
50
P P P P 29 58%
P P P 17 34%
P P P 19 38%
P P P P P 16 32%
15 30%
P P P P P 23 46%
P P P P 16 32%
P P P P P P P P 19 38%
P P P P P P P P 27 54%
P P P P 18 36%
15 30%
P P P P P P P 15 30%
P P P 16 32%
P P P P 13 26%
14 28%
13 26%
P P P 16 32%
P P P P P P P P 29 58%
 P P P P P P 28 56%
P P P 34 68%
P P P P 18 36%
P P P 26 52%
P P P P 28 56%
P P P P P 24 48%
P P P P P P 22 44%
P P P P P P P P P P 38 76%
21 42%
P P P P P 41 82%
P P P P 22 44%
P P PP P P 20 40%
PPP P P P P P P P P 35 70%
P P P P P P 42 84%
P P P P P P P P P 38 76%
P P P P P P P 24 48%
P P P P 18 36%
P P 16 32%
P P P P P P P P P 46 92%
P P P 26 52%
0 0%
0 0%
0 0%
0 0%
17 20 18 18 19 16 18 20 17 11 50 100%
44%
51%
46%
46%
49%
41%
46%
51%
44%
28%

50 100%
 Student Score

10%
20%
30%
40%
50%
60%
70%
80%
90%
100%

0%
ABENION,LANCE 58%
JOSEPH CASTILLO
ALINSOOT,ERIC 34%
RAPSING
AREVALO,JOHN PHILIP 38%
BIDOR
Balaguza Ivan, 32%
BUTAL,DANIEL JOHN 30%
BARRUN
CASTILLO,STEVEN 46%
DELALLOYD GRATE
CRUZ,JOE 32%
MARKWIN BACARON
DESABELLE,JESON 38%
SUMALINOG
MANLAPAS,HAROLD 54%
REALNAVARRO,ARVEN 36%
RAMO,LOISARD
SARCINO DELA
30%
CRUZ
RAMOS,JAY BENSAY 30%
RAPSING,SUNNY 32%
DOMINGO ROMBLON
REPOLONA,DAREL 26%
CAPINIG
SANTUELE,CARLOS 28%
RUEL RABINO
SESE,RUDY CAASI 26%
SOLIS,MARK IAN 32%
SOLINAP
TOMLOD,ARYEN 58%
ORTEGA
URSAL,GABRIEL RECTO 56%
ABENION,JESSA MAE 68%
CASTILLO
ABULENCIA,JULIE 36%
ROSE URSAL
CANINO,REMYJOY 52%
MAGLUYAN
CAPINIG,DONALYN - 56%
CAPINIG,ELMAR 48%
DEQUINO
COMMISION,JESSA 44%
NOVABOS
DEALDE,LYKEE 76%
DEQUINO
INOPIA,CHARLENE 42%
VILLAR
Student Score Analysis

NARCISO,MARY JANE 82%

SESE RACE,JUDY-ANN
44%
RADA,JUDY
CAPINIG ANN
40%
REGALA
RAMO,REYJEAN 70%
VILLAR
ROXAS,ARNELA 84%
MIRALLES
SABANGAN,LOWELLA 76%
MERCOLITASOLIS,VERLYN 48%
MIRALLES
TOLIBAT,NIKKI MESIAS 36%
VERALLO,SHAIRA 32%
CABAHOG
VILLANUEVA,AIDA 92%
ROMBLON
VILLAR,VANESSA 52%
BERNALES
ZURBITO,REGINE 0%
GUETA
0%
0%
0%
 % Of Students W ho Answered The Question / Item
Correctly

10%
20%
30%
40%
50%
60%
70%
80%
90%
100%

0%
1 64%
2 62%
3 59%
4 49%
5 51%
6 54%
7 46%
8 56%
9 38%
10 51%
11 38%
12 49%
13 36%
14 49%
15 46%
16 46%
17 41%
18 41%
19 44%
20 49%
21 41%
22 46%
23 38%
24 36%
25 36%
26 56%

Question# / Item
27 49%
28 36%
29 44%
30 46%
Test Item Analysis

31 46%
32 46%
33 33%
34 49%
35 46%
36 44%
37 46%
38 51%
39 51%
40 46%
41 44%
42 51%
43 46%
44 46%
45 49%
46 41%
47 46%
48 51%
49 44%
50 28%