Study Stat

• Tracks time connected to Eduroam (UNC On-Campus WiFi) 📶

• Client-server app! Data is sent to a Flask server hosted with PythonAnywhere ☁️

  • GUI built with PyQt6 🐍

• Downloadable Executables: (Check Releases Tab)

  • 🍏 Mac: .app (Permissions: Settings -> Privacy & Security -> Allow)
  • 📁 Windows: .exe

• Utilized to track and promote academic productivity in my fraternity 📚

Create Leaderboard:

• SQL data cleaning to group and sort .db data:

  SELECT client_id, SUM(time_total) AS total_time
  FROM logs
  GROUP BY client_id
  ORDER BY total_time DESC;
  

• Weekly leaderboard updates sent to fraternity Slack