This form is to be accomplished by the school math teachers after checking the project all numerates test

materials.
Read this guide before using the template.

FOR ENCODING (MATH TEACHERS)

How do I start?
Instructions:

1. First, start by choosing TIN-AR_Teachers’ Template Excel File for class encoding. This file can be used during pre-test and post-test PAN administration.

2. Open score guide tab and review the scores.

3. Choose between 1A or 1B. Open 1A TIN-AR Encoding (2Fs) tab or 1B TIN-AR Encoding (4Fs) tab and answer the required information such as school, section, type of test (pre/post),
1A TIN-AR Encoding (2Fs) is intended for grade 1
It contains two fundamental operations. - addition and subtraction
1B TIN-AR Encoding (4Fs) is intended for grade 2 to 7.
It contains the four fundamental operations. - addition, subtraction, multiplication, and division

Where can I see the data fields? The data fields are the active cells intended to personalize your sheets. Here are the data fields for TIN Encoding.

4. After encoding the name of learner on the name field and the corresponding scores. Scroll down to see the graphs for the class numeracy level summary. Notice that the template autom

*Note: To determine the percentage of decrease during post-test, encode the number of pre-test non-numerates and pre-test nearly numerates in the yellow cell.

Complete the template by encoding

Important:
1. The worksheets are protected with passwords to prevent the teachers from accidentally deleting important formulas and clicking locked or hidden
cells. Deleting cells and columns is discouraged.
2. A data validation guide appears in applicable cells as guide in typing entry in each cell.

3. In the case of error for acceptable values, a prompt will appear.

as school, section, type of test (pre/post), testing date, name of pupils, the number of items intended for each part and the corresponding scores of pupils for each component.

summary. Notice that the template automatically presents the data of the class numeracy through summary and graphs. Save a copy of the pre-test/posttest file. Send the excel file to your school math le

s in the yellow cell.

Send the excel file to your school math leader for consolidation.
 Project All Numerates (AN) Scoring Guide
Grade Test I/Part I Test II/Part II Test III/Part III
No. of No. of No. of No. of No. of No. of
Level Score Score
Items Pts. Items Pts. Items/Problems Pts
A & B 10 2 pts
Grade 1 10 1pt 10 20 1 pt 20
C & D 2 problems 5 pts
A. 10 2 pts
Grade 2 10 1 pt 10 10 1 pt 10
B. 4 problems 5 pts
A. 10 2 pts
Grade 3 10 1 pt 10 10 2 pts 20
B. 2 problems 5 pts
Grade 4 15 1 pt 15 10 2 pts 20 5 problems 5 pts
Grade 5 15 1 pt 15 10 2 pts 20 5 problems 5 pts
Grade 6 15 1 pt 15 10 2 pts 20 5 problems 5 pts
Grade 7 15 1 pt 15 25 1 pt 25 5 problems 4 pts

Total Score of Pupils/ Students MPS = Computed Mean

Mean =
Total Number of Pupils/ Students Total Number of Test Item

Percentage Decrease Formula (Non- No. of Non-Numerates (PRE - TEST) - No. of Non-Numerates (P
Numerates) = No. of Non-Numerates (PRE TEST)
ng Guide Total
est III/Part III Test IV/Part IV
Score No. of Items Divisor Score
Numeracy Level Scores
Score
30 200 5 40 100 Numerates 60-100
2Fs - 200 5
40
4Fs - 400 10
40 100 Nearly Numerates 31-59
30 400 10 40 100 Non-Numerates 0-30
25 400 10 40 100
25 400 10 40 100
25 400 10 40 100
20 400 10 40 100

Computed Mean
x 100
Total Number of Test Items

TEST) - No. of Non-Numerates (POST-TEST)

x 100
n-Numerates (PRE TEST)
 Republic of the Philippines
Department of Education
Region III
TARLAC CITY SCHOOLS DIVISION
(SCHOOL)

TEMPLATES IN NUMERACY ASSESSMENT AND

(SCHOOL YEAR)

GRADE AND SECTION PRE POST

Performance Level Distribution
No. Name of Pupils Part I Part II Part III Part
Score Score Score A S
MALE 100 100
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45

Performance Level Distribution

No. Name of Pupils Part I Part II Part III Part
Score Score Score A S
FEMALE 0 0 0 100 100
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45
 Republic of the Philippines
Department of Education
Region III
TARLAC CITY SCHOOLS DIVISION
(SCHOOL)
TEMPLATES IN NUMERACY ASSESSMENT AND
(SCHOOL YEAR)

CLASS NUMERACY LEVEL SU

GRAPHICAL PRESENTATION OF CLASS NUMERACY LEVEL
(%)

M %
0 0.00

M %
0 0.00

M %
0 0.00
0 0
Numerates Nearly Numerates Non - Numerates

Numeracy Level Male Female Total

Numerates 0 0 0 0.00
Nearly Numerates 0 0 0 0.00
Non - Numerates 0 0 0 0.00
Total 0 0 0

Equivalent Numerical Value

VLOOKUP
Equivalent Numerical Level N
0-30% 0 Non-Numerate
31-59% 31 Nearly Numerate
60-100% 60 Numerate

greater than 100 101 Err

Components Class Size No. of Items HS LS Mean

Part I 0 0 0 0 0.00
Part II 0 0 0 0 0.00
Part III 0 0 0 0 0.00
Addition 0 100 0 0 0.00
Subtraction 0 100 0 0 0.00
TOTAL 0 40 0 0 0.00

MPS PER COMPONENT

 MPS PER COMPONENT
100

90

80

70

60

50

40

30

20

10

0 0.00 0.00 0.00 0.00 0.00

Part I Part II Part III Addition Subtraction

NOTE: For POST TEST only.

Total no. of pre-test nearly numerates
Total no of pre-test non-numerates
% of decrease (nearly &non-numerates): 0.00
% of decrease (nearly numerates): 0.00
% of decrease (non-numerates): 0.00

Prepared by:
Teacher

Certified Correct:
School Math Focal Person
 lic of the Philippines
ment of Education
Region III
ITY SCHOOLS DIVISION
(SCHOOL)

SESSMENT AND REPORTING (TIN-AR)

SCHOOL YEAR)

TEST DATE:
erformance Level Distribution
Part IV (2Fs) Total Score
Numeracy Level No.
Total Score
200 40 40
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45

erformance Level Distribution

Part IV (2Fs) Total
Numeracy Level No.
Total Score
200 40 100
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45
 lic of the Philippines
ment of Education
Region III
ITY SCHOOLS DIVISION
(SCHOOL)
SESSMENT AND REPORTING (TIN-AR)
SCHOOL YEAR)

ACY LEVEL SUMMARY

NUMERATES
F % T %
0 0.00 0 0.00
NEARLY NUMERATES
F % T %
0 0.00 0 0.00
NON - NUMERATES
F % T %
0 0.00 0 0.00 100.00
0 0 0 0

0.00 0.00

NON -
NUMERATES
(%)

MPS
0.00
0.00
MPS (%)
0.00
0.00
0.00
0.00
 NUMERATES (%)

100.00
90.00
80.00
70.00
60.00
50.00
40.00
30.00
20.00
10.00
0.00
1 2

GR & SEC 0
CLASS SIZE 0
TOTAL ITEMS 40
HS 0
LS 0
RANGE 0
MEAN 0.00
MPS 0.00
100.00

Teacher

ath Focal Person

 Republic of the Philippines
Department of Education
Region III
TARLAC CITY SCHOOLS DIVISION
(SCHOOL YEAR)

TEMPLATES IN NUMERACY ASSESSMENT AN

(SCHOOL YEAR)

Grade and Section PRE POST

Performance Level Distribution
No. Name of Pupils Part I Part II Part III Part IV (
Score Score Score A S M
MALE 100 100 100
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45

Performance Level Distribution

No. Name of Pupils Part I Part II Part III Part IV (
Score Score Score A S M
FEMALE 0 0 0 100 100 100
1 Pupil 1
2 Pupil 2
3 Pupil 3
4 Pupil 4
5 Pupil 5
6 Pupil 6
7 Pupil 7
8 Pupil 8
9 Pupil 9
10 Pupil 10
11 Pupil 11
12 Pupil 12
13 Pupil 13
14 Pupil 14
15 Pupil 15
16 Pupil 16
17 Pupil 17
18 Pupil 18
19 Pupil 19
20 Pupil 20
21 Pupil 21
22 Pupil 22
23 Pupil 23
24 Pupil 24
25 Pupil 25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 Republic of the Philippines
Department of Education
Region III
TARLAC CITY SCHOOLS DIVISION
(SCHOOL YEAR)

Template In Numeracy Assessment and R

(SCHOOL YEAR)

CLASS NUMERACY LEVEL S

GRAPHICAL PRESENTATION OF CLASS NUMERACY
LEVEL (%)

M
0

M
0

M
0
0

Numerates Nearly Numerates

Non - Numerates

Numeracy Level Male Female Total

Numerates 0 0 0 0.00
Nearly Numerates 0 0 0 0.00

NU
Non - Numerates 0 0 0 0.00
Total 0 0 0

VLOOKUP
Equivalent Numerical Value Numerical Level
Equivalent
0-30% 0 Non-Numerate
31-59% 31 Nearly Numerate
60-100% 60 Numerate

greater than 100 101 Err

Components Class Size No. of Items HS LS Mean MPS

Part I 0 0 0 0 0.00 0.00
Part II 0 0 0 0 0.00 0.00
Part III 0 0 0 0 0.00 0.00
Addition 0 100 0 0 0.00 0.00
Subtraction 0 100 0 0 0.00 0.00
Multiplication 0 100 0 0 0.00 0.00
 Division 0 100 0 0 0.00 0.00
TOTAL 0 40 0 0 0.00 0.00

MPS PER COMPONENT

100

90

80

70

60

50

40

30

20

10

0 0.00 0.00 0.00 0.00 0.00 0.00 0.00

tI tI
I III n n on n
Pa
r r rt tio tio ti sio
Pa P a di ac i ca vi
A d tr l Di
Su
b tip
ul
M

NOTE: For POST TEST only.

Total no. of pre-test nearly numerates 12
Total no of pre-test non-numerates 12
% of decrease (nearly &non-numerates): 100.00
% of decrease (nearly numerates): 100.00
% of decrease (non-numerates): ###

Prepared by:
Teacher

Certified Correct:
School Math Focal Person
 of the Philippines
ent of Education
Region III
Y SCHOOLS DIVISION
HOOL YEAR)

ESSMENT AND REPORTING (TIN-AR)

HOOL YEAR)

TEST DATE
e Level Distribution
Part IV (4FS) Total Score
D TOTAL Score
Numeracy Level No.
100 400 40 40
1
2
3
4
5
6
7
8
9
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
41
 42
43
44
45

ce Level Distribution
Part IV (4FS) Total
D TOTAL Score
Numeracy Level No.
100 400 40 40
1
2
3
4
5
6
7
8
9
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
41
42
43
44
45
 of the Philippines
ent of Education
Region III
Y SCHOOLS DIVISION
HOOL YEAR)

essment and Reporting (TIN-AR)

HOOL YEAR)

CY LEVEL SUMMARY

NUMERATES
% F % T %
0.00 0 0.00 0 0.00
NEARLY NUMERATES
% F % T %
0.00 0 0.00 0 0.00
NON - NUMERATES
% F % T %
0.00 0 0.00 0 0.00 ###
0 0 0 0 0

0.00 0.00

NON-
NUMERATES
(%)

Components

MPS (%)
 NUMERATES (%)

100

90

80

70

60

50

40

30

20

10

GR & SEC 0
CLASS SIZE 0
TOTAL ITEMS 40
HS 0
LS 0
RANGE 0
MEAN 0.00
MPS 0.00
100.00