📜 Syllabus Archaeology — Architecture

University course syllabus database. SvelteKit + Deno + Supabase + Ollama (Mac Mini) for content extraction and synthesis.

🛠️ Tech Stack

Component	Technology	Why
Frontend	SvelteKit	Course search, syllabus viewer, comparison tool
Backend	Deno 2	Syllabus parsing, AI extraction, data normalization
Database	Supabase (PostgreSQL)	Syllabi DB, courses, professors, user accounts
AI	Ollama (Mac Mini)	Extract structured data from syllabus PDFs, synthesize scorecards
PDF Parsing	PdfParse + custom	Extract text from uploaded syllabi
Payments	Stripe	Subscriptions

🗄️ Data Model

syllabi
id	uuid
course_id	uuid (FK)
professor_id	uuid (FK)
semester	varchar(20)	Fall 2024, etc.
raw_pdf_url	varchar(500)	Stored in Supabase Storage
parsed_json	jsonb	Assignments, readings, grading rubric
workload_estimate_hrs	integer	Actual estimated hours/week
grade_distribution	jsonb	{% A: 30, B: 40, ...}
contributor_id	uuid (FK)	Anonymous contributor

🤖 AI Pipeline

Syllabus PDF → Structured Data

Ollama (Mac Mini) reads uploaded PDF. Extracts: assignments (type, weight, due dates), reading list, grading rubric breakdown, policies. Stored as structured JSON.

Scorecard Synthesis

Multiple syllabi for same course → Ollama synthesizes: "This class has 3 papers (40%), 2 exams (40%), and participation (20%). Workload is heavier than official credit hours suggest. Grading is tough but fair."

Professor Profile Aggregation

All syllabi for Professor X → aggregated teaching style profile, average workload, grading generosity rating.

← Requirements | All Projects | Presentation →