Skip to content

sajirhtml/370-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 

Repository files navigation

SCMS - Student Course Management System

Overview

The Smart Course Management System (SCMS) is a comprehensive academic planning platform designed to streamline course selection, time management, and academic tracking for students. By combining intelligent prerequisite checking, schedule optimization, and progress monitoring, SCMS empowers students to make informed decisions about their academic journey.

Key Features

1. Intelligent Course Prerequisite Planner

Students input their current semester and completed courses. The system validates prerequisite requirements and generates a curated list of eligible courses for the upcoming semester, ensuring students pursue courses they are academically qualified to take.

2. Conflict-Free Schedule Generator

When students select specific course sections, the system cross-references class timings and notifies them of any scheduling conflicts. This prevents overlaps and ensures students can attend all selected courses without conflicts.

3. Dynamic CGPA & Target Grade Predictor

A sophisticated calculator that tracks historical academic performance. Students can set a target CGPA, and the system computes the exact grades required in current courses to achieve that goal, providing clarity on academic objectives and required effort.

4. Interactive Course Planner

Students select courses for the upcoming semester through an intuitive interface. The system calculates total credit hours and enforces credit-load limitations to prevent registration overload and maintain academic sustainability.

5. Academic Task Tracker

A Kanban-style task management board for organizing assignments and exams. The system automatically links tasks to enrolled courses and sorts them by due date, keeping students focused on immediate priorities.

6. Room & Lab Availability Finder

Students can search for unoccupied study spaces in real-time. The system queries the schedule database against the current time or a specified time block, delivering availability information suitable for group study or independent work.

7. Course Resource Hub

A centralized repository for student-shared academic resources, including notes, video tutorials, and study guides organized by course. An upvote/downvote mechanism ensures highly-rated resources appear at the top.

8. Faculty Consultation Booking

A directory displaying faculty office hours with an integrated booking system. Students can reserve consultation slots using a calendar interface while preventing double-booking conflicts.

9. Faculty & Advisor Portal

Faculty members can log in to confirm or deny consultation requests and serve as academic advisors, guiding students in course selection and academic planning.

About

A backend-focused project for learning and applying core database concepts using MySQL. This repository serves as a practical guide to relational database design, SQL queries, optimization, and best practices.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors