GAS SIMPKL
An internship monitoring application built with Google Apps Script and Google Workspace to streamline student logs and supervisor evaluations.
Project Overview
GAS SIMPKL (Sistem Informasi Praktik Kerja Lapangan) is a cloud-based internship documentation platform. Utilizing Google Apps Script as a serverless backend and Google Sheets as a relational datastore, the application simplifies daily progress reporting for vocational students and facilitates verification by academic mentors.
01.The Problem & Opportunity
Prior internship monitoring relied heavily on physical paper logbooks and dispersed messaging chats. This manual process led to missing logs, delayed attendance verification, and excessive administrative effort when compiling final evaluation reports.
02.Solution & Architecture
Architected a centralized web application running on Google Apps Script infrastructure. Students log in to submit daily learning logs and project notes, while field supervisors and academic advisors review submissions, grant validation stamps, and export grading spreadsheets automatically.
Key Technical Features
Student portal for daily journal entries, task reports, and attendance logging
Supervisor dashboard for reviewing, providing feedback, and approving logs
Automated email notifications via Gmail Service upon status updates
Dynamic data binding directly with Google Sheets for audit-proof record keeping
Role-based access separation between students, supervisors, and coordinators
Engineering Challenges & Solutions
Operating within Google Apps Script execution time limits and quota restrictions
Ensuring responsive layout performance within Google HTML Service iframe sandboxes
Structuring concurrent spreadsheet reads and writes to avoid record collision
Results & Realized Impact
- Eliminated paper waste and manual transcript collation for academic administrators
- Accelerated supervisor review turnaround times from weeks to minutes
- Provided transparent audit trails for institutional internship accreditation
Other Projects to Explore
Smart Fish Feeder
An automated IoT-based aquarium feeding system with scheduled dispensing, servo motor actuation, and a web control dashboard.
Company Profile & E-Catalog
A responsive corporate web presence featuring dynamic product catalog management, service presentations, and customer inquiry routing.