CORVIT Institute Dashboard – Setup Guide

Project Structure

corvit_dashboard/
├── app.py            ← Main Streamlit app (all pages)
├── db.py             ← All SQLite queries
├── corvit.db         ← Database file (copy here)
├── requirements.txt  ← Only 3 packages
└── README.md

Step 1 – Install Python

Python 3.9+ required. Download from python.org if not installed.

Step 2 – Open in PyCharm

1. File → Open → select corvit_dashboard folder
2. PyCharm will detect it as a project

Step 3 – Create Virtual Environment (in PyCharm)

• Go to: File → Settings → Project → Python Interpreter
• Click gear icon → Add → Virtualenv Environment → OK
• PyCharm creates .venv folder (lightweight, only 3 packages)

Step 4 – Install Packages

Open PyCharm Terminal (bottom panel):

pip install -r requirements.txt

Step 5 – Run Locally

streamlit run app.py

Browser opens at: http://localhost:8501

---

Deploy on Streamlit Cloud (Free)

Step 1 – Push to GitHub

1. Create GitHub account at github.com
2. New repository → name: corvit-dashboard
3. Upload all files from corvit_dashboard/ folder

Step 2 – Deploy

1. Go to: share.streamlit.io
2. Sign in with GitHub
3. Click "New app"
4. Select your repo, branch=main, file=app.py
5. Click Deploy → Done! ✅

Your app will be live at: https://your-username-corvit-dashboard.streamlit.app

---

Pages in Dashboard

Page	What it shows
Overview	KPIs, charts for all sections
Students	Student list with filters, top performers
Fees	Collection stats, pending amounts
Academics	Grades, attendance, subjects, assignments
Placements	Company-wise placements, salary trends
Library	Book availability, issued books
Events	All institute events