Skip to content
Kiesha Conde / Portfolio
Work / Case studyBack to projects

Individual database project + web adaptation Local demonstration

University Grading System

The application brings students, courses, faculty, enrollments, grade entry, and reports together in a local Python/SQLite demo.

PythonSQLiteHTMLCSSJavaScript

Select a screen to explore the details.

Project details.

Project overview

Explore academic data relationships and make grade-recording and reporting workflows easier to inspect. The supplied package maps a 2024 SQL case study to a later browser application. The displayed student and faculty data is fictional.

My contributions

I designed the original academic database, wrote SQL queries, modeled relationships, and implemented the grading logic. The later web adaptation makes those concepts available through a browser interface.

  • Student, course, faculty, and enrollment management.
  • Grade recording using non-overlapping grade bands from the SQL source.
  • Printable report cards, academic summaries, and grade exports.

Outcome & learning

Local demonstration with fictional students. The supplied package does not include production authentication or a verified public repository link. Conflicting grade-band descriptions need an explicit source of truth. This adaptation follows the non-overlapping SQL bands and documents that choice.