Automated Real-Time Grade Projection and Monitoring: A Systems-Engineering Approach to Academic Transparency at Quezon City University

Abstract

Traditional grading systems often suffer from feedback latency, leading students to perceive grading as inconsistent or subjective. This study implements a real-time grade projection system at Quezon City University (QCU) using Google Apps Script, Google Sheets, and Looker Studio. Following a Quantitative Grade Projection and Real-Time Monitoring design, the system computes projected grades based on weighted components: Attendance (20%), Quizzes (30%), Assignments (10%), and Exams (40%). Weekly projections were compared with final grades to assess reliability. Results indicate that the system provides early visibility of student performance, identifies academic gaps, and enhances transparency, reducing perceptions of instructor bias. This approach demonstrates that low-cost digital tools can support operational academic management and timely intervention in a Philippine urban university context.