BATAAN PENINSULA STATE UNIVERSITY REPORT OF

City of Balanga 2100 Bataan

PHILIPPINES
GRADES

Academic Year : 2020-2021

Instruction: (1) Prepare this form in quadruplicate. Semester : 2nd
(2) Arrange the names of students by major in alphabetical order. Campus : BPSU Main
(3) All erasures made in this form should be initialed by the instructor.
(4) This should be submitted ten (10) days after the final examination.
(5) All grades of "INC" must be removed within a year, otherwise, the grades will automatically become "5.00".

Subject Code : TELE0223 Time: 10:00-11:30

Subject Title : TEACHING ICT AS AN Course: BTVTE 2B

(%) EQUI.
Names ATT. CS EXAM MTG ATT. CS EXAM FTG 50%MTG+50%FT
G RATING

1 Cruz, Dyanne 91 92 92 92### 89 95 90 92 92 1.50

2 De leon, Jessica 94 92 90 92 92 92 92 92 92 1.50
3 Diaz, Febelyn Jane 93 90 89 91 94 94 93 94 93 1.50
4 Dizon, Clarissa 89 89 90 90 91 92 95 93 92 1.50
5 Gonzalez, Cassy 97 95 90 94 93 95 95 95 95 1.25
6 Guiterrez, Jerina 96 90 89 92 95 93 96 95 94 1.50
7 Macusi, Honey Grace 95 89 88 91 91 90 93 92 92 1.50
8 Navarro, Shiralyn 89 96 88 91 89 95 94 93 93 1.50
9 Sanchez, Franz 97 95 90 94 92 96 95 95 95 1.25
10 Viceral, Angela 98 98 97 98 95 97 98 97 98 1.00

GRADE EQUIVALENT Prepared by: Reviewed by:

98 - 100 1.00 Excellent
95 - 97 1.25
92 - 94 1.50 Very Good MR. RUSSEL HANZ D. DAVID DR. CESAR GONZALES
89 - 91 1.75 Instructor/Professor Dean
86 - 88 2.00 (Signature over Printed Name) (Signature over Printed Name)
Good
83 - 85 2.25
80 - 82 2.50 Fair 06-18-2021 06-18-2021
77 - 79 2.75 Date Date
Passed
75 - 76 3.00
72 - 74 4.00 Conditional (MT only)
60 - 71 5.00 Failed
Inc Incomplete
 Group No. / Names

Course ATTENDANCE TOTAL EQUI.

1
2
3
4
5
6
7
8
9
10

1. Supply the names of your ten (10) students

2. Get the total of the attendance and its equivalent using the vlookup,
3. supply the grade of your students under the Class Standing and get the total value of their rating,
4. Enter the rating of your students with under written examination and encode its equivalent value using the transmutati
5. synchronize the Class Record and Grade Sheet
 CLASS STANDING

Group Performance 35% Teaher Evaluation 40% Leader Evaluation 25%

total value of their rating,

code its equivalent value using the transmutation and vlooup function.
total Examination EQUI.
 for Exam for Exam
for
with 100 with 100
Attendance
items items
50 5 20 60 0 100
51 5 21 60 1 95
52 5 22 61 2 85
53 5 23 61 3 75
54 5 24 62 4 70
55 5 25 62 5 50
56 5 26 63
57 5 27 63
58 5 28 64
59 5 29 64
60 5 30 65
61 5 31 65
62 5 32 66
63 5 33 66
64 5 34 67
65 5 35 67
66 5 36 68
67 5 37 68
68 5 38 69
69 5 39 69
70 4 40 70
71 4 41 70
72 4 42 71
73 4 43 71
74 4 44 72
75 3 45 72
76 3 46 73
76.99 2.75 47 73
77.99 2.75 48 74
79 2.75 49 74
80 2.5 50 75
81 2.5 51 75
82 2.5 52 76
83 2.25 53 76
84 2.25 54 77
85 2.25 55 77
86 2 56 78
87 2 57 78
88 2 58 79
89 1.75 59 79
90 1.75 60 80
91 1.75 61 80
92 1.5 62 81
93 1.5 63 81
94 1.5 64 82
95 1.25 65 82
96 1.25 66 83
97 1.25 67 83
98 1 68 84
 99 1 69 84
100 1 70 85
71 85
72 86
73 86
74 87
75 87
76 88
77 88
78 89
79 89
80 90
81 90
82 91
83 91
84 92
85 92
86 93
87 93
88 94
89 94
90 95
91 95
92 96
93 96
94 97
95 97
96 98
97 98
98 99
99 99
100 100