Design and Evaluation of the Electronic Class Record for LPULaguna International School
Journal: Asia Pacific Journal of Multidisciplinary Research (APJMR) (Vol.2, No. 4)Publication Date: 2014-08-15
Authors : RHOWEL M. DELLOSA;
Page : 67-71
Keywords : vlookup; countif; e-class record; LPU-Laguna international school;
Abstract
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.
Other Latest Articles
- Implementation of the Firearms Amnesty Program in the Municipality of Bauan, Batangas
- Batangas Heavy Fabrication Yard Multi-Purpose Cooperative: Basis for Business Operation
- Correlation Analysis of Customer Satisfaction and Loyalty in Carlito Peña Reyes Hospital
- An Analysis of Named Entity Disambiguation in Social Networks
- Tracer Study of BS in Information Technology (BSIT) Graduates of Camarines Sur Polytechnic Colleges, Nabua, Camarines Sur from 2004 to 2010
Last modified: 2014-08-18 10:07:01