Design and Evaluation of the Electronic Class Record for LPU- Laguna International School

This study aimed to design, develop, deploy and evaluate an electronic class record (e-class record). Microsoft Excel is used to develop the electronic class record and several Microsoft Excel arithmetic operands and functions like VLOOKUP, IF, AVERAGE, COUNTIF are used. A worksheet template was developed to accept name of teacher, course code, course title, section, schedule, room, student number, student name, grade level, gender, date of each classes, base grade, test items attendance, and performance of the students. These serve as the input of the e-class record. The e-class record automatically computes the grades of the students following the standard grading system. Developmental process and prototyping method were utilized to develop the e-class record. Testing, deployment and evaluation have been initiated to observe its acceptability. It is found out that the e-class record can generate the quarterly and final grade of the students, total number of absences and tardiness of the students, grade sheet with corresponding level of evaluation of each student in the class and summary of the total number of students for each of the level of proficiency. It is recommended that further study may be initiated to utilize the output of this study as an input of an online application such as online grade viewer. Security of previous submitted grades from being changed by the teacher accidentally or intentionally must be also taken into consideration. A report card may be also included in the system.

Keywords: vlookup, countif, e-class record, LPU-Laguna international school