STUDENT MANAGEMENT SYSTEM
ABSTRACT
The project “ STUDENT MANAGEMENT SYSTEM ” is designed using Microsoft Visual Basic 6.0 as front end and Microsoft Access as backend. Stude Student nt Manag Manageme ement nt Syste System m deals deals with with all all kind kind of stude student nt deta details ils,, academic related reports, college details, course details, curriculum, batch details and other resource related details too. It tracks all the details of a student from the day one to the end of his course which can be used for all reporting purpose, purpose, tracking tracking of attenda attendance, nce, progres progress s in the course, course, complete completed d semeste semesters rs years, years, coming coming semeste semesterr year curriculum curriculum details, details, exam exam details details,, project project or any other other assignment details, final exam result; and all these will be available for future references too. Our program will have the databases of Courses offered by the college under all levels of graduation or main streams, teacher or faculty's details, batch execution details, students' details in all aspects. This program can facilitate us explore all the activities happening in the college, even we can get to know which teacher / faculty is assigned to which batch, batch, the the curre current nt status status of a batc batch, h, attend attendanc ance e perce percent ntage age of a batch batch and and upcoming requirements of a batch. Different reports and Queries can be generated based of vast options rela relate ted d to stud studen ents ts,, batc batch, h, cour course se,, teac teache herr / facu facult lty, y, exam exams, s, seme semest ster ers, s, certification and even for the entire college.
MODULE DESCRIPTION
The system has four modules. They are •
College and Department details
•
Login and subject
•
Student Details
•
Exam Details
College and Department details: This module deals with the college college details and differen differentt departm departments ents in the college. The college details are stored in the table SMSCollege. SMSCollege. And department department detail details s are stored stored in SMSCa SMSCateg tegory ory.. It deals deals with with the detail details s of colle college ge and and department. Login and subject
This module based with the login process and subject details. The login process specifies the user mode such as administrator or user. This module consist of two tables, SMSLogin and SMSSub . It contains the details of login process and subject details. Login process includes sign in sign up, sign out, change password. Student Details
This module deals with the student academic details and and pers perso onnel nnel deta detail ils. s. This This mod module ule consi onsist sts s of the the tabl tables es SMSStudacademic and SMSStudpersonal. Exam Details
This module deals with the student exam details, student particular such as various activities, final report. The tables comes in this modules are SMSExamdetail, SMSFinalreport and SMSStudparti.
EXISTING SYSTEM
Existing system is a manual system. In the manual system system all the entries are made in the books. It involves involves more efforts to arrive at the result. The paperwork causes fatigue. Retrieval of information and report generation is made after verifying the whole records entered in the books. References and Modifications of data requi require re a lot lot of sear search ch time time.. There There are are cert certain ain limi limita tati tion ons s in the the existing system that is mentioned as follows:
•
Time Consuming
•
Data Inconsistency
•
Data Redundancy
•
Tedious
•
Frequent Errors
•
Complex Data Handling
•
Large storage space is required
•
No security
PROPOSED SYSTEM
The proposed system is developed using VB as front end with MS Acce Access ss as the the back back end. end. The The propo ropos sed sys ysttem has has been been designed to overcome the bottle necks of the existing system. The Main Features of New System are
•
•
User friendly interface Automation of fine collection
•
Promotions can be given easily
•
Details of TTE can be viewed
•
Easy access to report information
•
Flexibility
•
Accuracy
•
Time consumption is reduced
•
Secure
SYSTEM CONFIGURATION
MINIMUM HARDWARE REQUIREMENTS
A Server PC with 3.0 GHz processor
2 GB of RAM
PC with a minimum of 512 MB RAM
Window XP
SOFTWARE REQUIREMENTS
Visual Basic 6.0 (Development Tool)
VB (Coding)
MS Access (Database)
Windows XP
