READ ME FIRST

HOW TO USED AUTOMATED PROJECT -AN

1. Collect all the score of the student's in answering the windows card
then encode the result from addition to division

2. As you encode the NAMES of your pupils this form will authomatically count

The average is program to make it a whole number eg formula =ROUND(G11*10%,0)

your number of pupils on the number on th rigth side

3. Then also collect all the scores in PROJECT AN and encode it on its column
the auto project an will automatically identifies the score if it is
NUMERATES, NEARLY NUMERATES, OR NON-NUMERATE.

4. You will see the results on the number of NUMERATES, NEARLY NUMERATES, OR NON-NUMERATE.
on the sumarry box below

5. If your pupils are too many for the number of rows you can
YOU CAN UNHIDE ROWS IF YOURE LACKING OF ROWS

6. Always look at the print preview so that non of the cell will be cut of
just drag colunms that have a formula to copy the formula on the above column

7. If something you don’t understand or troubleshoot problems in this automated form

you may contact the formula maker of this form at rdeleon@deped.com.ph or on my facebook RONALD M. DE LEON
or the mind behind this form Ma'am Flerida P Orian at flerida.orian@deped,gov.ph or on facebook Flerida P. Orian
there are no lock cells here, because of hidden rows and formula has been done
in case of mistake you can copy or understand how the
k RONALD M. DE LEON
book Flerida P. Orian
AUTOMATED GROUP SCREENING TEST (GST)

GROUP SCREENING TEST (GST)

SCHOOL NAME STA. CRUZ (BBD) ELEMENTARY SCHOOL DISTRICT

GRADE III SECTION SCHOOL ID

NO. LEARNER'S NAME LRN 0 TO 7

MALE
1 RONALD M DE LEON 107164 1
2 RONALD 107164 2
3 RONALD 107164 3
4 RONALD 107164 4
5 RONALD 107164 5
6 RONALD 107164 6
7 RONALD 107164 7
8 RONALD 107164 0
9 RONALD 107164
10 RONALD 107164
11 RONALD 107164
12 RONALD 107164
13 RONALD 107164
14 RONALD 107164
15 RONALD 107164
16 RONALD 107164
17 RONALD 107164
18 RONALD 107164
19 RONALD 107164
20 RONALD 107164
21 RONALD 107164
22 RONALD 107164 1
23 RONALD 107164
24 RONALD 107164
25 RONALD 107164 2
25 TOTAL 10
NO. LEARNER'S NAME LRN 0 TO 7
FEMALE
1 PAMELA C. DE LEON 107164 0
2 PAMELA 107164 1
3 PAMELA 107164 2
4 PAMELA 107164 3
5 PAMELA 107164 4
6 PAMELA 107164 5
7 PAMELA 107164 6
8 PAMELA 107164 7
9 PAMELA 107164
10 PAMELA 107164
11 PAMELA 107164
12 PAMELA 107164
13 PAMELA 107164
14 PAMELA 107164
15 PAMELA 107164
16 PAMELA 107164
17 PAMELA 107164
18 PAMELA 107164
19 PAMELA 107164
20 PAMELA 107164
21 PAMELA 107164
22 PAMELA 107164 4
23 PAMELA 107164
24 PAMELA 107164
25 PAMELA 107164 2
25 TOTAL 10
ORAL READING PASSENGES
O TO 7 8 TO 13 14 TO 20
GENDER TOTAL NO OF TOTAL
PUPILS KINDER GRADE 1 DISCONTINUE
MALE 25 10 7 8 25
FEMALE 25 10 7 8 25
TOTAL 50 20 14 16 50
Prepared by:
RONALD M. DE
Adviser
 FIIVE

107164

8 TO 13 14 TO 20

A
B
C
D
E
F
G
H
8 I
9 J
10 K
11 L
12 M
13 KINDER
14
15
16
17
18
19
20

8
14

7 8
8 TO 13 14 TO 20

10
9
10
11
12
13
14
15
16
17
18
19
 20

9
17

7 8

###
###
###

ONALD M. DE LEON
Adviser
AUTOMATED GROUP SCREENING TEST (GST)

GROUP SCREENING TEST (GST)

SCHOOL NAME GRACEVILLE ELEMENTARY SCHOOL DISTRICT

GRADE IV SECTION A SCHOOL ID

NO. LEARNER'S NAME LRN 0 TO 7

MALE
1 AGAG, ERJHON AGAG 102668140030
2 ALAJEÑO, LEADRO VALDEZ 136632140038 7
3 CATABAY, LORENZO ARRANGUEZ 136507140331 7
4 DATUL, MARK LOUIE A. 162503140068 6
5 DELLOMAS, ALLAN FRANCIS VELOSO 162503140072
6 DELLOMOS, JOHN LLOYYD MIRANDA 162503130319
7 DU, RHENZ IVAN BONGHANOY 162503140177
8 ENDRIGA, RHUZZEL GREG CENERA 104824140011
9 ESTRELLA, ELMO GAN 162507140182
10 GALLEGO, ANGELO BAGORIO 162503140178
11 GAVINO, JOHN FRANCIS AGTALAO 162503150009
12 HOMERES, JHAMMER HASSEN ROLA 162503140429
13 LIANZA, ERWIN DION MORALES 162503140288
14 PARADERO, ADRIAN SILVESTRE 162503150015
15 RAGURO, JOHN PATRICK ELCHICO 162503140416
16 RECLUSADO, LEBRON BARNACHEA 102122140008
17 SIDRO, KURT LYRON EZEKEL 162503140096
18 TIO, CLARK JOHN COMETA 162503140204

18 TOTAL 3
NO. LEARNER'S NAME LRN 0 TO 7

FEMALE
1 AGUILLON, PRINCESS MARIE SARDENA 162503140236
2 ANASTACIO, FRANCES ANDREALLY VICTORIANO 162503140300
3 ARANDA, JOELLA MAE SANTIAGO 162503150004
4 BAGARES, GLAZIEL ANNE RAMOS 162503140104
5 BORCA, RHIZA MHIEL BULAN 162503140306
6 CABILAN, CHRISTIANA KIM HABLA 107156140113
7 DELA CERNA, IMEE DIANE LIMPAJAN 162503140237
8 DELLOMOS, MHIAN DESLATE 162503140181
9 DOMINGO, MIKYLA R 402735150045 7
10 GERONIMO, MA LEACIL FRANCISCO 162503140314
11 GUNO, SAMANTHA AIRA YANDER 162503140453
12 GUTIERREZ, MEREYA CLAIZA ROVINES 162508140074
13 LIM. ERICKA LYN SANDIG 136510150205
14 LONGCOP, CHILCY MAE MANGARIN 136593120298
15 MAHINAY, FRANCEZCA MIER 162503140361
16 MORALES, JANAIAH MARILLE MELANO 162503140329
17 MORENO, FRIA ALLYSON KATIGBAK 162503140247 7
18 QUINTO, MAI FE C 162503140338 7
19 REYES, PENELOPE AMIELLE SIDRO 162503140255
20 SUNGA, FAITH MARGARETTE GARCIA 162503140257
21 TERCO, JAMAICA MARICRIS TAMBONG 162503140417
22 VALENCIA, AGNES SEVILLA 162503140291
23 VALERIANO ANGEL SHANE ORCALES 162503140340
24 VELLEJO, JONABELLE ALCANTARA 162503140287 6

24 TOTAL 4
ORAL READING PASSENGES
O TO 7 8 TO 13 14 TO 20
GENDER TOTAL NO OF TOTAL
PUPILS GRADE 1 GRADE 2 DISCONTINUE
MALE 18 3 14 1 18
FEMALE 24 4 18 2 24
TOTAL 42 7 32 3 42
Prepared by:
MARIA ELENA G
Advise
 EIGHT

162503

8 TO 13 14 TO 20

13 A
B
C
D
11 E
9 F
9 G
12 H
12 I
9 J
12 K
11 L
12 M
14
11 GRADE 1
8 GRADE 2
12 GRADE 3
10

14 1
8 TO 13 14 TO 20

10
16
10
8
9
9
10
12

8
10
11
9
13
11
11

9
9
 11
9
16

18 2

IA ELENA G. ESTRELLA
Adviser
AUTOMATED GROUP SCREENING TEST (GST)

GROUP SCREENING TEST (GST)

SCHOOL NAME STA. CRUZ (BBD) ELEMENTARY SCHOOL DISTRICT

GRADE V SECTION SCHOOL ID

NO. LEARNER'S NAME LRN 0 TO 7

MALE
1 RONALD M DE LEON 107164 1
2 RONALD 107164 2
3 RONALD 107164 3
4 RONALD 107164 4
5 RONALD 107164 5
6 RONALD 107164 6
7 RONALD 107164 7
8 RONALD 107164 0
9 RONALD 107164
10 RONALD 107164
11 RONALD 107164
12 RONALD 107164
13 RONALD 107164
14 RONALD 107164
15 RONALD 107164
16 RONALD 107164
17 RONALD 107164
18 RONALD 107164
19 RONALD 107164
20 RONALD 107164
21 RONALD 107164
22 RONALD 107164 1
23 RONALD 107164
24 RONALD 107164
25 RONALD 107164 2
25 TOTAL 10
NO. LEARNER'S NAME LRN 0 TO 7
FEMALE
1 PAMELA C. DE LEON 107164 0
2 PAMELA 107164 1
3 PAMELA 107164 2
4 PAMELA 107164 3
5 PAMELA 107164 4
6 PAMELA 107164 5
7 PAMELA 107164 6
8 PAMELA 107164 7
9 PAMELA 107164
10 PAMELA 107164
11 PAMELA 107164
12 PAMELA 107164
13 PAMELA 107164
14 PAMELA 107164
15 PAMELA 107164
16 PAMELA 107164
17 PAMELA 107164
18 PAMELA 107164
19 PAMELA 107164
20 PAMELA 107164
21 PAMELA 107164
22 PAMELA 107164 4
23 PAMELA 107164
24 PAMELA 107164
25 PAMELA 107164 2
25 TOTAL 10
ORAL READING PASSENGES
O TO 7 8 TO 13 14 TO 20
GENDER TOTAL NO OF TOTAL
PUPILS GRADE 2 GRADE 3 DISCONTINUE
MALE 25 10 7 8 25
FEMALE 25 10 7 8 25
TOTAL 50 20 14 16 50
Prepared by:
RONALD M. DE
Adviser
 FIIVE

107164

8 TO 13 14 TO 20

8
9
10
11
12
13
14
15
16
17
18
19
20

8
14

7 8
8 TO 13 14 TO 20

8
9
10
11
12
13
14
15
16
17
18
19
 20

9
17

7 8

ONALD M. DE LEON
Adviser
AUTOMATED GROUP SCREENING TEST (GST)

GROUP SCREENING TEST (GST)

SCHOOL NAME GRACEVILLE ELEMENTARY SCHOOL DISTRICT

GRADE IV SECTION A SCHOOL ID

NO. LEARNER'S NAME LRN 0 TO 7

MALE
1 RONALD M DE LEON 107164 1
2 RONALD 107164 2
3 RONALD 107164 3
4 RONALD 107164 4
5 RONALD 107164 5
6 RONALD 107164 6
7 RONALD 107164 7
8 RONALD 107164 0
9 RONALD 107164
10 RONALD 107164
11 RONALD 107164
12 RONALD 107164
13 RONALD 107164
14 RONALD 107164
15 RONALD 107164
16 RONALD 107164
17 RONALD 107164
18 RONALD 107164
19 RONALD 107164
20 RONALD 107164
21 RONALD 107164
22 RONALD 107164 1
23 RONALD 107164
24 RONALD 107164
25 RONALD 107164 2
25 TOTAL 10
NO. LEARNER'S NAME LRN 0 TO 7
FEMALE
1 PAMELA C. DE LEON 107164 0
2 PAMELA 107164 1
3 PAMELA 107164 2
4 PAMELA 107164 3
5 PAMELA 107164 4
6 PAMELA 107164 5
7 PAMELA 107164 6
8 PAMELA 107164 7
9 PAMELA 107164
10 PAMELA 107164
11 PAMELA 107164
12 PAMELA 107164
13 PAMELA 107164
14 PAMELA 107164
15 PAMELA 107164
16 PAMELA 107164
17 PAMELA 107164
18 PAMELA 107164
19 PAMELA 107164
20 PAMELA 107164
21 PAMELA 107164
22 PAMELA 107164 4
23 PAMELA 107164
24 PAMELA 107164
25 PAMELA 107164 2
25 TOTAL 10
ORAL READING PASSENGES
O TO 7 8 TO 13 14 TO 20
GENDER TOTAL NO OF TOTAL
PUPILS GRADE 3 GRADE 4 DISCONTINUE
MALE 25 10 7 8 25
FEMALE 25 10 7 8 25
TOTAL 50 20 14 16 50
Prepared by:
MARIA ELENA G.
Adviser
 EIGHT

162503

8 TO 13 14 TO 20

A
B
C
D
E
F
G
H
8 I
9 J
10 K
11 L
12 M
13 KINDER
14
15
16
17
18
19
20

8
14

7 8
8 TO 13 14 TO 20

8
9
10
11
12
13
14
15
16
17
18
19
 20

9
17

7 8

RIA ELENA G. ESTRELLA

Adviser