Switch-Based Faculty Management System With Real-Time Camera Capture and SQLite Database

Clients

Techstack

Purpose

Built for Mapua University: a faculty management system operated through physical switches, pairing each status change with real-time camera capture and recording all activity in an SQLite database for accountability and review.

Description

A Raspberry Pi reads a bank of GPIO-wired switches — one per faculty member — so professors can flag their availability directly from the board. A PyQt desktop interface presents the live status alongside real-time camera capture via OpenCV, with dedicated screens for adding faculty and handling requests. Every event is written to an SQLite database, and a serial-driven dot-matrix display scrolls current information, making faculty availability visible at a glance.