Paano magcopy at paste ng data?

E-Class Record to EQWART-FORM 01-(for individual teacher)

1. Sa E-Class Record, Column "AF", i-highlight ang nakuhang scores sa quarter exam n
2. Click "Copy"
3. Sa EQWART FORM 01, sheet: raw score, piliin ang Paste Option na Values o Values

May mga notes po per sheet (nasa gray part)

Kung sobra ang column/row

> highlight po ang sobrang column/row
> right click, HIDE

Wag po kayong magdelete ng column/row, may maaapektuhan pong link/formula

Wag pong mahihiyang magtanong o humingi ng tulong sa inyong eqwart coordinator ^_^
ores sa quarter exam ng mga learners.

tion na Values o Values Only

pong link/formula
g eqwart coordinator ^_^
 Harmonia

Selene
Brizo
Subject /

H
D

G
E

F
Grade / Section

Student 1 10 48 60
Student 2 39 52 59
Student 3 37 38 60
Student 4 32 49 54
Student 5 35 51 52
Student 6 17 43 60
Student 7 13 47 49
Student 8 56 54
Student 9 19 45 51
Student 10 25 47 60
Student 11 21 48 60
Student 12 15 45 57
Student 13 15 43 53
Student 14 30 39 50
Student 15 37 52 60
Student 16 25 55 55
Student 17 19 44 49
Student 18 53
Student 19 20 56
Student 20 11 44
Student 21 56
Student 22 30 44
Student 23 20
Student 24 14
Student 25 0
Student 26 26
Student 27 34
Student 28 0
Student 29 0
Student 30 0
Student 31 12
Student 32 33
Student 33 30
Student 34 22
Student 35 30
Student 36 30
Student 37 30
Student 38
Student 39
Student 40
Student 41
Student 42
Student 43
Student 44
Student 45
Student 46
Student 47
Student 48
Student 49
Student 50
Student 51
Student 52
Student 53
Student 54
Student 55
Student 56
Student 57
Student 58
Student 59
Student 60
Student 61
Student 62
Student 63
Student 64
Student 65
Student 66
Student 67
Student 68
Student 69
Student 70
Student 71
Student 72
Student 73
Student 74
Student 75
Student 76
Student 77
Student 78
Student 79
Student 80
TOTAL 731 1055 943 0 0 0 0 0
 Harmonia

Selene
Brizo

H
D

G
E

F
NO. OF LEARNERS
TESTED 34 22 17 0 0 0 0 0

HIGHEST POSSIBLE
SCORE 60 60 60 60 60 60 60 60

Target Score (75%) 45 45 45 45 45 45 45 45

TOTAL SCORES
OBTAINED 731 1055 943 0 0 0 0 0

HIGHEST SCORE
OBTAINED 39 56 60 0 0 0 0 0

LOWEST SCORE
OBTAINED 0 38 49 0 0 0 0 0

75% and above 0 15 17 0 0 0 0 0

below 75% 34 7 0 0 0 0 0 0
MEAN 21.50 47.95 55.47 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
SD 11.39 5.38 4.29 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
MPS 35.83 79.92 92.45 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Skewness -0.46 0.01 -0.23 Err:502 Err:502 Err:502 Err:502 Err:502
I

J
0 0
 I

0 0

60 60

45 45

0 0

0 0

0 0

0 0
0 0
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
Err:502 Err:502
 Sections

Harmonia
Selene
Rank

Brizo
(Least
Item no. Mastered)

H
D

G
E
F

I
J
Number of test takers 34 22 17 0 0 0 0 0 0 0
1 56 5 3 15
2 60 29 21 10
3 59 30 20 9
4 57 13 7 14
5 57 14 9 11
6 1
7 1
8 1
9 1
10 1
11 1
12 1
13 1
14 1
15 1
16 1
17 1
18 1
19 1
20 1
21 1
22 1
23 1
24 1
25 1
26 1
27 1
28 1
29 1
30 1
31 1
32 1
33 1
34 1
35 1
36 1
37 1
38 1
39 1
40 1
41 1
42 1
43 1
44 1
45 1
46 1
47 1
48 1
49 1
50 1
51 1
52 1
53 1
54 1
55 1
56 1
57 1
58 1
59 1
60 1
 Interpretation

Low Mastery
Moving Toward Mastery
Moving Toward Mastery
Average Mastery
Average Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
Absolutely No Mastery
 Least Mastered Competencies/Skills (refer to Table of Specification)

Section Rank Item No. Competencies/Skills

1 abcdefg
Brizo 2
3
1
Harmon 2
ia
3
1
Selene 2
3
1
D 2
3
1
E 2
3
1
F 2
3
1
G 2
3
1
H 2
3
1
I 2
3
1
J 2
3
 Proposed
Interventions
School: ES / HS
Grading Period: First Grading Period

Number of student :
Number of student:
75% & above (Raw
Number of Test

below 75% (Raw

Skewness

Actual
Target
Takers

Mean
Score)

Score)
Least Mastered

MPS
SD
Competencies/Skills

Brizo 34 0 34 21.50 11.39 35.83 -0.46 45.00 21.50 abcdefg

Harmonia 22 15 7 47.95 5.38 79.92 0.01 45.00 47.95 0

Selene 17 17 0 55.47 4.29 92.45 -0.23 45.00 55.47 0

D 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

E 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

F 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

G 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

H 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

I 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

J 0 0 0 #DIV/0! #DIV/0! #DIV/0! Err:502 45.00 #DIV/0! 0

Prepared by: Noted by:

Teacher Department Head
Intervention