CLO Gradebook — Full-Stack (Next.js + Vercel Postgres + NextAuth)

Multi-teacher CLO gradebook. Har teacher apna account banata hai, apne courses banata hai, marks sheet import karta hai (Excel/CSV ya screenshot OCR), CLO tag karta hai, aur result Excel/PDF mein export karta hai. Data Postgres mein save hota hai (per teacher, per course) — koi bhi device se login karo, wahi data milega.

Deploy karne ka tareeqa (bina terminal ke, sirf browser se)

1. GitHub par push karein

1. GitHub par ek naya empty repository banayein (e.g. clo-gradebook).
2. Us repo ke web page par "Add file" → "Upload files" button use karein.
3. Is poore folder (clo-gradebook-app/) ke andar ki tamam files aur folders drag-drop karke upload kar dein (folder structure wesa hi rakhein jaisa hai — app/, lib/, components/, package.json, waghera).
4. "Commit changes" dabayein.

2. Vercel par import karein

1. vercel.com par login karein (GitHub account se login karna sab se aasan hai).
2. "Add New" → "Project" → apni GitHub repo select karein → Import.
3. Framework "Next.js" khud detect ho jayega. Abhi Deploy mat dabayein — pehle neeche wale steps (3 aur 4) complete karein, phir deploy karein.

3. Database attach karein (Vercel Postgres)

1. Vercel project ke andar "Storage" tab par jayein.
2. "Create Database" → "Postgres" select karein, ek naam dein, region select karein, Create dabayein.
3. Jab database ban jaye, "Connect Project" dabayein aur apna clo-gradebook project select karein — is se POSTGRES_URL waghera environment variables khud add ho jayenge.
4. Isi Storage tab mein ek "Query" ya "Data" tab hoga — wahan jaake schema.sql file ka pura content copy-paste karke ek dafa Run kar dein. Ye teachers/courses tables bana dega.

4. Auth secret set karein

1. Project ke "Settings" → "Environment Variables" mein jayein.
2. NEXTAUTH_SECRET naam ki ek variable add karein — koi bhi random 32+ character string (e.g. https://generate-secret.vercel.app/32 se generate kar lein).
3. NEXTAUTH_URL add karein — apni deploy hone wali URL, e.g. https://clo-gradebook.vercel.app (pehli baar deploy karne ke baad Vercel jo URL de, wahi yahan dobara set kar dein aur redeploy kar dein).

5. Deploy

1. Ab "Deploy" dabayein.
2. Build complete hone ke baad apni URL kholein, Sign up se account banayein, aur course banana shuru karein.

Local development (agar kabhi terminal mil jaye)

npm install
npm run dev

.env.local file banayein .env.example ki tarah, aur POSTGRES_URL (apne Vercel Postgres se copy karein) + NEXTAUTH_SECRET bhar dein.

Structure

• app/login, app/signup — authentication pages
• app/dashboard — teacher ke courses ki list
• app/course/[id] — ek course ka pura gradebook (Import → CLO Setup → Results)
• app/api/* — backend routes (signup, courses CRUD)
• lib/db.js — Postgres queries
• lib/auth.js — NextAuth config
• components/GradebookEditor.jsx — poora gradebook UI (import, CLO tagging, results table, Excel/PDF export, screenshot OCR)