Tech Stack
Main Tech
Tools & Libraries
The Problem
The electrical engineering lab at the University of Sonora ran entirely on paper. Practice requests were filled out by hand, equipment loans had no traceability, and there was no digital record of assets. Coordinating between professors and lab staff was slow, error-prone, and unsustainable. This project was developed as part of a university Social Service program to change that.
Automated Intake Flow
The workflow begins when a professor or student fills out a Microsoft Forms request. A Power Automate flow automatically transfers the response data to Google Sheets — acting as an integration hub. A backend sync command then reads the spreadsheet using pandas, validates the data, and inserts it into the database. Each request is uniquely identified to prevent duplicates.
What the System Manages
- Equipment — fixed assets tracked by serial number with automatic maintenance alerts
- Consumables — stock-based materials with restocking alerts
- Equipment History — immutable log of events per asset (maintenance, calibration, repairs)
- Incident Reports — failure logs linked to specific reservations
- Reservations — scheduled lab sessions linked to professors and official practices
- Loans — physical asset check-out with return date tracking
- Internal Messaging — communication between lab staff and users
- Academic Catalog — official and temporary practices, subjects, and resources
