Level of Proficiency of the Learners

(based on the NAT) MASTERY LEVEL PER ITEM

Equivalent Percentage MASTERY LEVEL DESCRIPTION
Level of Proficiency
Numerical Value 0.00% 4.99% Absolutely No Mastery
0.00% 24.00% Not Proficient 5.00% 14.99% Very Low Mastery
25.00% 49.00% Low Proficiency 15.00% 34.99% Low Mastery
50.00% 74.00% Nearly Proficient 35.00% 65.99% Average Mastery
75.00% 89.00% Proficient 66.00% 85.99% Moving Towards Mastery
90.00% 100.00% Highly Proficient 86.00% 95.99% Closely Approximating Mastery
96.00% 100.00% Mastered

Instructions
To the Teachers
1 Class Report shall be prepared by the subject teachers.
2 Chage the # sign by the grade level in the subject title, "Mathematics #".
3 Enter the name of the school, grade level and section, number of test takers, number of items, and names of the learners.
4 Enter the answers of the learners in the cells AR12 to BU71.
5 Interpretation will be generated authomatically.
6 For additional sheets, do the following: (1) Right Click sheet S1 or S2, (2) select "move or copy", (3) select "(move to end)",
7 Update the answer per item in the tab "Answer Key" according to the grade level
8 If the number of rows is not enough for the learners in a class, inform the Math EPS.
9 For other concerns, please inform the Math EPS
EM Level of Proficiency
L DESCRIPTION Equivalent
Level of Proficiency
ANM Numerical Value
VLM 0.00% 74.00% Beginning
LM 75.00% 79.00% Developing
AM 80.00% 84.00% Approaching Proficiency
MTM 85.00% 89.00% Proficient
CAM 90.00% 100.00% Advanced
M

and names of the learners.

(3) select "(move to end)", (4) check the box for create a copy

/marilynbsoriano
Item Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Answer Key C B B C D B B C A B D A D B A D C D A D B B

Key Distribution
A 12
B 13
C 12
D 13
50
23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
C A D A A C B C B D D C A D A D C B C D A A C B D
48 49 50
B C A
 Grade Level and Section : 1 - Sampaguita

Name of the Learners

1 2 3 4 5 6

1 SORIANO, ANGELICA SHAZMAI ANDA 1 1 1 1 1 1

2 TAPIA, VALERIE 1 1 1 1 1 1
3 GEALONE, PATRICIA ANN ESCOREL 1 1 1 1 1 1
4 KADIL, YVONNE BEATRIZ AYAAY 1 1 1 1 1 1
5 ARROJO, AIVAN JHOSHUA ALBURO 1 1 1 1 1 1
6 BARBO, GEMMA ROSE ALCONTIN 1 1 1 1 1 1
7 BISCARRA, MARY JOY ALCERA 1 1 1 1 1 1
8 RAMOS, JUVIE ANNE PEÑA 1 1 1 1 1 1
9 DELA GRACIA, ELMIRA ANNE 1 1 1 1 1 1
10 CRUZ, MICAH BERNABE 1 1 1 1 1 1
11 MAXIMO, CATHEY 1 1 1 1 1 1
12 DIZON, ROSELLIZA ALVARO 0 1 1 1 1 1
13 BINIBINI, KIMBERLY ROSE CABONCE 1 1 1 1 1 1
14 BLOR, DJ MILES ADAME 1 1 1 1 1 1
15 ENRIQUEZ, ANA MARIE MANOGUID 1 1 1 1 1 1
16 FACUN, PAULA LIZA GARDUQUE 1 1 1 1 1 1
17 JUNIO, ALICIA JANE 1 1 1 1 1 1
18 QUIMBO, MITCHELLE ANNE T. 1 1 1 1 1 1
19 SOPRANES, SHIELLA MAE COLMINAR 1 1 1 1 1 1
20 SULIT, JESSA TOYONGAN 1 1 1 1 1 1
21 DOMER, ARIEL GAGARIN 1 1 1 1 1 0
22 RAYMUNDO, CARMINA MARCOS 1 1 1 1 1 0
23 YBAEZ, CORENA LUTAS 1 1 1 1 1 0
24 ATIENZA, ERIKA LYKA MANALANSAN 0 1 1 1 1 0
25 MERIN, JOHN ALFRED SAN MIGUEL 1 1 1 0 1 1
26 CUNANAN, KIANNE JOY BARRERA 1 1 1 1 1 0
27 BALAYONG, TRICIA MAE PACAY 1 1 1 1 1 1
28 JUANILLO, JOHN 1 1 1 1 1 1
29 GAN, EVANGELINE SANTIAGO 1 1 1 1 1 0
30 BRAGAIS, EMMARIE JOLO 1 1 1 1 1 1
31 RAMOS, MA. JANELLE CAYABYAB 1 1 1 1 1 1
32 BAYAWA, NIERVEILYN ATABAY 1 1 0 1 0 0
 33 ESQUIVEL, RENELL MACAM 1 1 1 0 0 0
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

0.52 0.55 0.53 0.52 0.52 0.42

Mastery Level Description
AM AM AM AM AM AM

Number of Correct Responses 31 33 32 31 31 25

Number of Incorrect Responses 2 1 2 2 8
1 2 3 4 5 6
Created by:
MARILYN B. SORIANO
EPS Math - SDO Valenzuela
7 8 9 10 11 12 13 14 15 16 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 1 1 1 1 1 1 1
1 1 1 1 1 1 1 0 1 1 1
1 1 1 1 1 1 1 0 0 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 0 1 1
1 1 1 1 1 0 0 1 1 1 1
1 0 0 1 0 1 1 1 1 1 0
1 1 1 1 1 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 0
1 1 1 1 1 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 0 0 1 1 1 1 1 1
1 0 0 1 0 1 1 1 1 1 0
1 0 0 1 0 1 1 1 1 1 0
1 0 0 1 0 1 1 1 1 1 0
1 0 0 1 0 1 1 1 1 1 0
1 0 0 0 0 1 1 1 1 0 0
1 0 0 1 0 0 0 1 1 1 0
1 0 0 0 0 0 0 0 0 0 1
0 0 0 0 0 0 0 1 0 1 0
1 0 0 1 0 0 0 1 0 1 0
0 0 0 1 0 0 0 0 0 0 0
0 0 0 1 0 0 0 0 1 0 0
0 1 0 1 0 0 0 1 0 0 1
 1 0 0 0 0 0 0 0 0 0 0

0.48 0.18 0.17 0.33 0.17 0.40 0.40 0.45 0.42 0.45 0.33
AM LM LM LM LM AM AM AM AM AM LM

29 11 10 20 10 24 24 27 25 27 20
4 22 23 13 23 9 9 6 8 6 13
7 8 9 10 11 12 13 14 15 16 17
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - VALENZULEA

NAME OF SCHOOL
FIRST PERIODIC EXAMINATION RESULT
MATHEMATICS #

Score per Item Number

18 19 20 21 22 23 24 25 26 27 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 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 0 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 0 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 0 1 1 0 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 0 1 1 0 1 1 1
1 1 1 0 1 0 0 1 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 1 0 1 0 0 1 1 1
1 1 1 0 0 0 1 1 0 0 1
1 1 1 0 0 0 1 1 0 0 1
1 1 1 0 0 0 1 1 0 0 1
1 1 1 0 0 0 1 1 0 0 1
1 1 0 1 1 0 0 0 0 0 1
1 1 1 0 0 0 1 1 0 0 1
1 1 0 1 0 1 1 0 1 1 1
1 1 1 1 0 1 1 0 1 1 1
0 1 1 0 0 0 1 0 0 0 0
1 1 0 0 0 0 1 0 0 0 1
1 1 0 1 1 0 0 0 1 1 1
1 0 0 1 0 1 0 0 1 0 1
 0 0 0 0 0 0 0 0 0 0 0

0.52 0.52 0.43 0.40 0.20 0.37 0.33 0.25 0.40 0.37 0.52
AM AM AM AM LM AM LM LM AM AM AM

31 31 26 24 12 22 20 15 24 22 31
2 2 7 9 21 11 13 18 9 11 2
18 19 20 21 22 23 24 25 26 27 28
es
n

ALENZULEA

N RESULT

29 30 31 32 33 34 35 36 37 38 39

1 1 1 0 1 1 1 1 1 1 1
1 1 1 0 1 1 1 1 1 1 1
1 1 1 0 1 1 1 1 1 1 1
1 1 1 1 0 0 1 1 1 1 1
1 1 1 0 1 1 1 1 1 1 1
1 1 1 0 1 1 1 1 1 1 1
1 1 1 0 1 1 1 1 1 1 1
1 1 1 0 0 0 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 0 1 0 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 0 0 1 1 0 1 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
0 1 0 1 1 1 0 0 1 1 1
1 1 0 1 1 0 0 0 1 1 1
1 1 0 1 1 0 0 0 1 1 1
1 1 0 1 1 0 0 0 1 1 1
1 1 0 1 1 0 0 0 1 1 1
1 1 0 1 1 0 1 1 1 1 1
1 1 0 1 1 0 0 0 1 1 1
0 1 0 0 1 0 1 1 1 1 1
1 0 0 1 1 0 0 1 1 1 0
1 1 0 1 0 0 0 0 1 1 1
1 1 1 0 1 0 1 1 1 0 0
1 0 1 1 1 0 1 0 1 0 0
0 1 0 0 1 1 0 0 0 1 1
 0 1 0 0 1 0 0 0 0 1 0

0.37 0.50 0.22 0.33 0.50 0.32 0.25 0.27 0.52 0.52 0.48
AM AM LM LM AM LM LM LM AM AM AM

22 30 13 20 30 19 15 16 31 31 29
11 3 20 13 3 14 18 17 2 2 4
29 30 31 32 33 34 35 36 37 38 39
 Number of Test Takers: 60

40 41 42 43 44 45 46 47 48 49 50

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 0 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 0 1 0 1 1 1 1 1 1 1
1 1 1 0 1 1 1 1 1 0 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
0 1 1 1 1 1 0 0 0 0 1
1 1 1 1 1 1 1 1 1 1 1
1 0 0 0 1 1 1 0 0 1 1
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 0 0 1 1 0
1 1 1 1 1 1 1 0 1 1 1
1 1 1 1 1 1 1 0 1 1 1
1 1 1 1 1 1 1 0 1 1 1
1 1 1 1 1 1 1 0 1 1 1
1 0 1 0 0 1 1 1 1 1 1
1 1 0 1 1 1 1 0 1 1 0
1 1 1 0 1 1 0 0 1 1 0
0 1 1 0 1 1 1 1 1 0 0
1 1 1 1 1 1 1 0 1 1 1
1 0 1 1 1 1 1 0 1 1 1
1 1 1 1 0 0 0 1 1 0 0
1 1 1 0 0 0 0 0 0 0 1
 1 1 1 1 0 0 0 0 0 1 0

0.52 0.48 0.52 0.43 0.48 0.48 0.33 0.22 0.48 0.47 0.33
AM AM AM AM AM AM LM LM AM AM LM

31 29 31 26 29 29 20 13 29 28 20
2 4 2 7 4 4 13 20 4 5 13
40 41 42 43 44 45 46 47 48 49 50
Number of Items 50 Level of Proficiency of the Learners
Mastery (based on the NAT)
Score Level of Proficiency
Level Equivalent
49 98.00% Highly Proficient Numerical Value
49 98.00% Highly Proficient 0.00% 24.00%
48 96.00% Highly Proficient 25.00% 49.00%
47 94.00% Highly Proficient 50.00% 74.00%
46 92.00% Highly Proficient 75.00% 89.00%
46 92.00% Highly Proficient 90.00% 100.00%
46 92.00% Highly Proficient
45 90.00% Highly Proficient MASTERY LEVEL PER ITEM
44 88.00% Proficient Percentage
43 86.00% Proficient 0.00% 4.99%
43 86.00% Proficient 5.00% 14.99%
38 76.00% Proficient 15.00% 34.99%
36 72.00% Nearly Proficient 35.00% 65.99%
36 72.00% Nearly Proficient 66.00% 85.99%
36 72.00% Nearly Proficient 86.00% 95.99%
36 72.00% Nearly Proficient 96.00% 100.00%
36 72.00% Nearly Proficient
36 72.00% Nearly Proficient
36 72.00% Nearly Proficient
36 72.00% Nearly Proficient
35 70.00% Nearly Proficient
35 70.00% Nearly Proficient
35 70.00% Nearly Proficient
34 68.00% Nearly Proficient
32 64.00% Nearly Proficient
31 62.00% Nearly Proficient
30 60.00% Nearly Proficient
30 60.00% Nearly Proficient
28 56.00% Nearly Proficient
27 54.00% Nearly Proficient
27 54.00% Nearly Proficient
21 42.00% Low Proficient
 12 24.00% Not Proficient

Mean MPS
20.15 40.00% Low Proficient
Overall Performance
Level of Proficiency of the Learners
(based on the NAT)

Number of Item Number 1 2 3 4 5 6 7 8

Level of Proficiency
Learners
C B B C D B B C
Not Proficient 1 C B B C D B B C
Low Proficient 1 C B B C D B B C
Nearly Proficient 19 C B B C D B B C
Proficient 4 C B B C D B B C
Highly Proficient 8 C B B C D B B C
C B B C D B B C
MASTERY LEVEL PER ITEM C B B C D B B C
MASTERY LEVEL DESCRIPTION C B B C D B B D
Absolutely No Mastery ANM C B B C D B B C
Very Low Mastery VLM C B B C D B B D
Low Mastery LM D B B C D B B C
Average Mastery AM C B B C D B B D
Moving Towards Mastery MTM C B B C D B B D
Closely Approximating Mastery CAM C B B C D B B D
Mastered M C B B C D B B D
C B B C D B B D
C B B C D B B D
C B B C D B B D
C B B C D B B D
C B B C D D B D
C B B C D D B D
C B B C D D B D
B B B C D D B D
C B B B D B B D
C B B C D D B D
C B B C D B B D
C B B C D B A D
C B B C D D B D
C B B C D B A B
C B B C D B A D
C B A C C C A C
C B B B C C B B
 Enter the Answers of the Learners Here
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

A B D A D B A D C D A D B B C A D A A C B C
A B D A D B A D C D A D B B C A D A A C B C
A B D A D B A D C D A D B B C A D A A C B C
A B D A D C A D C D A D B B C A D A A C B C
A B D A D A B D C D A B B B C A D A A C B C
A B D A D B A D C D A D B B C A D A C C B C
A B D A D B D D C D A D B B C A D A A C B C
A B D B A B A D C D A D B B C A D A A C B C
D B A A D B A D B D A D B C C A C A A C B C
A B D A D B A D C D A D B B C A D A A C B A
D C A A D B A D B D A D B C C A C A A C B C
A B D A D B A D C D A D A B B C D A A C B C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D D A A D B A D C D A D B C C B C A A C C C
D B B A D B A D A D A D C C D A D B B C B C
D B B A D B A D A D A D C C D A D B B C B C
D B B A D B A D A D A D C C D A D B B C B C
D B B A D B A D A D A D C C D A D B B C B C
D C A A D B A C D D A C B B D C A B B C B C
D B B D B B A D A D A D C C D A D C D C B C
D D A B C A C C C D A A B C C A B A A C A C
B D B B B B D D A D A D B C C A C A A C B D
D B B D B B D D A A A D C C D A C B B D B C
B B B C B C B C B D A B A A A A C C D C B C
D B A B A A A A B D A A B B D B C A A C B D
C B C C C B B A C D C A B C C B A A D C C C
B D B B A D C A B C D C C D A B A D B A A C
rs Here
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

B A D C A D A D C B C D A A C B D B C A
B A D C A D A D C B C D A A C B D B C A
B A D C A D A D C B C D A A B B D B C A
B D C B A D A D C B C D A A C B D B C A
B A D C A D A D C B C D A A C B D B C A
B A D C A D A D C B B D B A C B D B C A
B A D C A D A D C B C D C A C B D B D A
B A A D A D A D C B C D A A C B D B C A
B D D C A D A D C B C D A A C B D B C A
B A D C A D A D C A C D A A C D B D A A
B D D C A D A D C B C D A A C B D B C A
A A D C B D A D C B A C C A C B C C C A
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D C D A A D C B C D A A C A A B C C
A D D A C A A D C B C D A A C B A B C A
A D D A C A A D C B C D A A C B A B C A
A D D A C A A D C B C D A A C B A B C A
A D D A C A A D C B C D A A C B A B C A
C D D D A D A D C B B D B C C B D B C A
A D D A C A A D C B C B A A C B A B C B
A B D B A D A D C B C D B A C A C B C C
A D D D B D A D B A C D B A C B D B B C
A D C A C A A D C B C D A A C B A B C A
B A D B A D A C B B D D A A C B C B C A
B D D A A B A A A B C D A D A A D B B D
A C D C B A B D C B C D C C D C B C B A
A A D B C A C D B B C D A B D A B C C B
 Republic of the Philippines
Department of Education
National Capital Region
DIVISION OF CITY SCHOOLS - VALENZUELA
Pio Valenzuela St., Marulas, Valenzuela

ITEM ANALYSIS

School : DALANDANAN NATIONAL HIGH SCHOOL

Grade Level : 7 Subject Teacher :
Number of Examinees: 33 27% of the Examinees: 9 Number of Items :
Item Frequency of Error Correct Response Difficulty
Number Upper 27% Middle 46% Lower 27% Frequency Percentage Index Level
1 0 2 0 31 94.00% 0.00 Too Easy
2 0 0 0 33 100.00% 0.00 Too Easy
3 0 0 1 32 97.00% 0.06 Too Easy
4 0 0 2 31 94.00% 0.11 Easy
5 0 0 2 31 94.00% 0.11 Easy
6 0 4 4 25 76.00% 0.22 Easy
7 0 0 4 29 88.00% 0.22 Easy
8 1 13 8 11 33.00% 0.50 Average
9 1 13 9 10 30.00% 0.56 Average
10 0 9 4 20 61.00% 0.22 Easy
11 1 13 9 10 30.00% 0.56 Average
12 1 0 8 24 73.00% 0.50 Average
13 1 0 8 24 73.00% 0.50 Average
14 2 0 4 27 82.00% 0.33 Average
15 2 0 6 25 76.00% 0.44 Average
16 0 0 6 27 82.00% 0.33 Average
17 1 5 7 20 61.00% 0.44 Average
18 0 0 2 31 94.00% 0.11 Easy
19 0 0 2 31 94.00% 0.11 Easy
20 1 0 6 26 79.00% 0.39 Average
21 0 5 4 24 73.00% 0.22 Easy
22 1 13 7 12 36.00% 0.44 Average
23 0 5 6 22 67.00% 0.33 Average
24 0 9 4 20 61.00% 0.22 Easy
25 1 9 8 15 45.00% 0.50 Average
26 0 4 5 24 73.00% 0.28 Average
27 1 4 6 22 67.00% 0.39 Average
28 0 0 2 31 94.00% 0.11 Easy
29 0 8 3 22 67.00% 0.17 Easy
30 0 1 2 30 91.00% 0.11 Easy
31 0 13 7 13 39.00% 0.39 Average
 32 7 2 4 20 61.00% 0.61 Average
33 2 0 1 30 91.00% 0.17 Easy
34 2 4 8 19 58.00% 0.56 Average
35 0 13 5 15 45.00% 0.28 Average
36 0 12 5 16 48.00% 0.28 Average
37 0 0 2 31 94.00% 0.11 Easy
38 0 0 2 31 94.00% 0.11 Easy
39 0 0 4 29 88.00% 0.22 Easy
40 0 1 1 31 94.00% 0.06 Too Easy
41 1 1 2 29 88.00% 0.17 Easy
42 0 1 1 31 94.00% 0.06 Too Easy
43 2 1 4 26 79.00% 0.33 Average
44 0 0 4 29 88.00% 0.22 Easy
45 1 0 3 29 88.00% 0.22 Easy
46 0 9 4 20 61.00% 0.22 Easy
47 0 14 6 13 39.00% 0.33 Average
48 0 2 2 29 88.00% 0.11 Easy
49 1 1 3 28 85.00% 0.22 Easy
50 0 8 5 20 61.00% 0.28 Average
Mean = 36.64 Mean Percentage Score (MPS) =
Percentage of Difficulty
Mastery Level Description (MLD)
Correct Response Index Level
0.00% 4.00% Absolutely No Mastery 0.00 0.10 Too Easy
5.00% 14.00% Very Low Mastery 0.11 0.25 Easy
15.00% 34.00% Low Mastery 0.26 0.75 Average
35.00% 65.00% Average Mastery 0.76 0.90 Difficult
66.00% 85.00% Moving Towards Mastery 0.91 1.00 Too Difficult
86.00% 95.00% Closely Approximating Mastery
96.00% 100.00% Mastered
Prepared by: Checked by:

MRS. ELIZABETH L. LLANDELAR SERAFIN SD. RAYMUNDO II

Subject Teacher Department Head/Coordinator
 e Philippines
of Education
ital Region
OOLS - VALENZUELA
Marulas, Valenzuela

ALYSIS

Subject Teacher : MRS. ELIZABETH L. LLANDELAR

Number of Items : 50
Discrimination Mastery Level
REMARKS
Index Power Description
0.00 Poor Reject Closely Approximating Mastery
0.00 Poor Reject Mastered
0.11 Marginal Reject Mastered
0.22 Reasonably Revise Closely Approximating Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.44 Very Good Revise Moving Towards Mastery
0.44 Very Good Revise Closely Approximating Mastery
0.78 Very Good Retain Low Mastery
0.89 Very Good Retain Low Mastery
0.44 Very Good Revise Average Mastery
0.89 Very Good Retain Low Mastery
0.78 Very Good Retain Moving Towards Mastery
0.78 Very Good Retain Moving Towards Mastery
0.22 Reasonably Retain Moving Towards Mastery
0.44 Very Good Retain Moving Towards Mastery
0.67 Very Good Retain Moving Towards Mastery
0.67 Very Good Retain Average Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.56 Very Good Retain Moving Towards Mastery
0.44 Very Good Revise Moving Towards Mastery
0.67 Very Good Retain Average Mastery
0.67 Very Good Retain Moving Towards Mastery
0.44 Very Good Revise Average Mastery
0.78 Very Good Retain Average Mastery
0.56 Very Good Retain Moving Towards Mastery
0.56 Very Good Retain Moving Towards Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.33 Good Revise Moving Towards Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.78 Very Good Retain Average Mastery
 -0.33 Poor Reject Average Mastery
-0.11 Poor Reject Closely Approximating Mastery
0.67 Very Good Retain Average Mastery
0.56 Very Good Retain Average Mastery
0.56 Very Good Retain Average Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.44 Very Good Revise Closely Approximating Mastery
0.11 Marginal Reject Closely Approximating Mastery
0.11 Marginal Revise Closely Approximating Mastery
0.11 Marginal Reject Closely Approximating Mastery
0.22 Reasonably Retain Moving Towards Mastery
0.44 Very Good Revise Closely Approximating Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.44 Very Good Revise Average Mastery
0.67 Very Good Retain Average Mastery
0.22 Reasonably Revise Closely Approximating Mastery
0.22 Reasonably Revise Moving Towards Mastery
0.56 Very Good Retain Average Mastery
0.73
Discrimination
Index Power
-1.00 0.10 Poor
0.11 0.20 Marginal
0.21 0.30 Reasonably
0.31 0.40 Good
0.41 1.00 Very Good

Noted by:

RONALD A. TRONO
School Head
 Republic of the Philippines
Department of Education
National Capital Region
Division of City Schools – Valenzuela
DALANDANAN NATIONAL HIGH SCHOOL

ANNEX B: SUMMARY OF DIAGNOSTIC TEST RESULTS BY GRADE LEVEL

SCHOOL: DALANDANAN NATIONAL HIGH SCHOOL
SUBJECT: MATHEMATICS
GRADE LEVEL: 7
DEPT. HEADS/ SUBJECT COORDINATOR/ SERAFIN SD. RAYMUNDO II
GRADE LEVEL CHAIRMAN:
INCORRECT
ITEM NO. CORRECT REPONSES COMPETENCIES RANK MPS
RESPONSES
illustrates the following measures of position:
1 31 2 quartiles, deciles and 43.5 93.94
percentiles.

illustrates the following measures of position:

2 33 0 quartiles, deciles and 50 100.00
percentiles.

illustrates the following measures of position:

3 32 1 quartiles, deciles and 49 96.97
percentiles.

illustrates the following measures of position:

4 31 2 quartiles, deciles and 43.5 93.94
percentiles.
 illustrates the following measures of position:
5 31 2 quartiles, deciles and 43.5 93.94
percentiles.

illustrates the following measures of position:

6 25 8 quartiles, deciles and 24.5 75.76
percentiles.

calculates a specified measure of position (e.g.

7 29 4 33.5 87.88
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

8 11 22 3 33.33
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

9 10 23 90th percentile) of a set of data. 1.5 30.30

calculates a specified measure of position (e.g.

10 20 13 14.5 60.61
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

11 10 23 1.5 30.30
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

12 24 9 22 72.73
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

13 24 9 22 72.73
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

14 27 6 28.5 81.82
90th percentile) of a set of data.
15 25 8 calculates a specified measure of position (e.g. 24.5 75.76
90th percentile) of a set of data.

calculates a specified measure of position (e.g.

16 27 6 28.5 81.82
90th percentile) of a set of data.

17 20 13 interprets measures of position. 14.5 60.61

18 31 2 interprets measures of position. 43.5 93.94

19 31 2 interprets measures of position. 43.5 93.94

20 26 7 interprets measures of position. 26.5 78.79

21 12 9 interprets measures of position. 4.5 36.36

22 12 21 interprets measures of position. 4.5 36.36

23 22 11 solves problems involving measures of position. 19 66.67

24 20 13 solves problems involving measures of position. 14.5 60.61

25 15 18 solves problems involving measures of position. 8.5 45.45

26 24 9 solves problems involving measures of position. 22 72.73

27 22 11 solves problems involving measures of position. 19 66.67

28 31 2 solves problems involving measures of position. 43.5 93.94

29 22 11 solves problems involving measures of position. 19 66.67

30 30 3 formulates statistical mini research. 37.5 90.91

31 13 20 formulates statistical mini research. 6.5 39.39

32 20 13 formulates statistical mini research. 14.5 60.61

33 30 3 formulates statistical mini research. 37.5 90.91

34 19 14 formulates statistical mini research. 11 57.58

35 15 18 formulates statistical mini research. 8.5 45.45

36 16 17 formulates statistical mini research. 10 48.48

37 31 2 formulates statistical mini research. 43.5 93.94

38 31 2 formulates statistical mini research. 43.5 93.94

39 29 4 formulates statistical mini research. 33.5 87.88

40 31 2 formulates statistical mini research. 43.5 93.94

41 29 4 formulates statistical mini research. 33.5 87.88

42 31 2 formulates statistical mini research. 43.5 93.94

43 26 7 formulates statistical mini research. 26.5 78.79

44 29 4 formulates statistical mini research. 33.5 87.88

 45 29 4 formulates statistical mini research. 33.5 87.88

46 20 13 formulates statistical mini research. 14.5 60.61

47 13 20 formulates statistical mini research. 6.5 39.39

48 29 4 formulates statistical mini research. 33.5 87.88

uses appropriate measures of position and

49 28 5 other statistical methods in analyzing and 30 84.85
interpreting research data.

uses appropriate measures of position and

50 20 13 other statistical methods in analyzing and 14.5 60.61
interpreting research data.
Sum 1197 Mean 36.27 MPS 72.55

Prepared by: Checked by:

ENNIE V. ISRAEL SERAFIN SD RAYMUNDO II

Master Teacher In - Charge Head Teacher VI

Noted:

RONALD A. TRONO
PRINCIPAL IV
YMUNDO II

Mastery Level
Code
Description

Closely Approximating Mastery CAM SUMMARY

Mastered M

Mastered M MPS per student ML Description Code

Closely Approximating Mastery CAM 0 - 4.99 0 Absolutely No Mastery ANM

Closely Approximating Mastery CAM 5 - 14.99 5 Very Low Mastery VLM

Moving Towards Mastery MTM 15 - 34.99 15 Low Mastery LM

Closely Approximating Mastery CAM 35 - 65.99 35 Average Mastery AM

Low Mastery LM 66 - 85.99 66 Moving Towards Mastery MTM

Low Mastery LM 86 - 95.99 86 Closely Approximating Mastery CAM

Average Mastery AM 96 - 100 96 Mastered M

Low Mastery LM Sum

Moving Towards Mastery MTM

Moving Towards Mastery MTM

Moving Towards Mastery MTM

 Moving Towards Mastery MTM

Moving Towards Mastery MTM

Average Mastery AM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Moving Towards Mastery MTM

Average Mastery AM

Average Mastery AM

Moving Towards Mastery MTM

Average Mastery AM
 Average Mastery AM

Moving Towards Mastery MTM

Moving Towards Mastery MTM

Closely Approximating Mastery CAM

Moving Towards Mastery MTM

Closely Approximating Mastery CAM

Average Mastery AM

Average Mastery AM

Closely Approximating Mastery CAM

Average Mastery AM
 Average Mastery AM

Average Mastery AM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Moving Towards Mastery MTM

Closely Approximating Mastery CAM

Closely Approximating Mastery CAM

Average Mastery AM

Average Mastery AM

Closely Approximating Mastery CAM

Moving Towards Mastery MTM

Average Mastery AM

Moving Towards Mastery MTM

33 36.27273 0.7254545454545
Frequency

0
0

14

13

18

50
 Republic of the Philippines
Department of Education
National Capital Region
Division of City Schools – Valenzuela
DALANDANAN NATIONAL HIGH SCHOOL

DIVISION QUARTER II ASSESSMENT

COMPETENCY GAP IN MATH 7
School Year 2021 - 2022

Grade 7 MATHEMATICS

Mean
Item Level of Blooms Mastery Level
Competency Percentage Action to be Taken
Number Taxonomy Description
Score

calculates a specified measure of position (e.g. 90th The class will be divided into two (2) groups students consisting
8 Apply 33.33 Low Mastery 10 members each. Then, they will conduct a survey to their 9
percentile) of a set of data.
members about their preferred hero in Mobile Legends Bang
Bang. Afterwards, they will calculate specific measure of
position in quartile and percentile.

The students will be given 1,000 diamonds that they can use to
buy one (1) of their favorite heroes in Mobile Legends. Every
hero corresponds to a specific amount of diamonds. After
choosing what hero to buy, they will list down all the names
and prices of the heroes per group. Assuming each group has 10
members, thus, they are expected to list down 10 prices. The
students will arrange their gathered data in ascending order.
Last, the students will compute the given different measure of
position in quartile and percentile. If they computed for the
right value of position, they will be granted to ability to buy the
 Bang. Afterwards, they will calculate specific measure of
position in quartile and percentile.

The students will be given 1,000 diamonds that they can use to
buy one (1) of their favorite heroes in Mobile Legends. Every
hero corresponds to a specific amount of diamonds. After
choosing what hero to buy, they will list down all the names
and prices of the heroes per group. Assuming each group has 10
members, thus, they are expected to list down 10 prices. The
students will arrange their gathered data in ascending order.
Last, the students will compute the given different measure of
position in quartile and percentile. If they computed for the
calculates a specified measure of position (e.g. 90th
9, 11 Apply 30.30 Low Mastery right value of position, they will be granted to ability to buy the
percentile) of a set of data. specific hero they want.

Prepared by:

SERAFIN SD. RAYMUNDO II RONALD A. TRONO

Head Teacher VI Principal IV
 INSTRUCTIONS
Sampling Procedure
1 Use sample size of 50 students.
2 Divide 50 by the number of sections from the same grade levels that a teacher handle. The quotient is the sample siz
3 Calculate the sampling interval by dividing the population per section by the sample size per section.
4 Arrange the papers based on the scores from highest to lowest.
5 Select a random start between 1 and sampling interval.
6 Repeatedly add sampling interval to select subsequent sample student papers. Do it in all the sections.
7 Arrange the selected samples in descending order based on the scores and use it for item analysis.
Procedure for encoding
8 Save As this file following the format: Div Test Subject_GradeLevel_ IA-MPS (SchoolAcronym)
9 Update the title name (e.g. subject, grade level, quarterly exam, etc.)
10 Change the tab name using the format Grade_Level-Name_of_Teacher (e.g. 7-Ms ABC)
11 Most of the data will be generated automatically by the formula but there are some values that you need to enter.
12 Encode/change the required data (usually highlighted with colored background) per section. Do not overwrite the fo
13 Don't forget to update/encode the required names (adviser, subject teacher, subject head teacher, school head, tes
14 You may delete/not the excess rows and/or columns.
15 Sum and MeanMPS will be generated based on per section inputs. Delete the excess rows/columns.
16 Competencies with below average mastery level, will not be generated by the program. You need to identify based
17 NO NEED to PRINT your outputs.

Note:
user program, you need a single file for consolidation.
ve a single computer where every teacher may encode their data.
div123
 Systematic sampling is a type of probability sampling method in
which sample members from a larger population are selected
according to a random starting point and a fixed, periodic interval.
e. The quotient is the sample size per section. This interval, called the sampling interval, is calculated by dividing
the poulation size by the desired sample size.
ize per section.

in all the sections.

tem analysis.

values that you need to enter.

ection. Do not overwrite the formula without permission.
head teacher, school head, testing coor, etc.)

rows/columns.
m. You need to identify based on the generated mastery level description and TOS.
 pling method in
n are selected
periodic interval.
ulated by dividing