Student Information Management System Notes

STUDENT INFORMATION MANAGEMENT SYSTEM

Authors:

  • Mr.Ritesh Ramchandra Landage
  • Ms.Pranjal Navnath Daphal
  • Mr.Gaurav Madhukar Dafal
  • Mr.Abhishek Balasaheb Daphal
  • Dr.Aniruddha S. Rumale

Abstract:

  • The project aims to create a website that centralizes student data, making it accessible to students, faculty, and administrators.
  • The system allows faculty and administrators to add, delete, and update student information.
  • The website will also host videos and images of college functions and events.
  • User login module handles student logins, while faculty and administrators use an admin login to manage student details.

Keywords:

Web Technology, administration, maintain records, Smart connect, student information management system, virtual tour, mysql, nodejs

I. INTRODUCTION

  • Problem with the Earlier System:
    • The earlier system relied on manual paper-based records.
    • This was disadvantageous due to the challenges of handling paper records and the time-consuming nature of the process.
    • There was also a risk of data loss.
  • Solution:
    • The Students Information Management System (SIMS) aims to overcome these problems.
    • It provides a better way to add, update, delete, and render data effectively.
    • It manages user access to the database effectively through a simple interface.
  • Project Title Definition:
    • Students Information Management System is defined as a web application that aims to provide information to all levels of management within an organization.
    • This system can be used as an information and data sharing system for the college.
  • Access and Security:
    • The administrator stores the login ID and password for each student/staff member.
    • Students/staff can then access the system to view or update their details.
  • Technology Stack:
    • Front-end: ReactJs, CSS, BOOTSTRAP (for webpage design), and JavaScript (for client-side validation).
    • Back-end: MySQL database and Node.js.
    • Server: XAMPP server.
  • Functionality:
    • The system contains academic information like academic achievements.
    • It provides a virtual tour of the campus and academic details to the users.
    • It uses a users table in the MySQL server.
    • The user login module handles user login activity, while the admin login module handles admin login activity.
    • The system accesses the college database through the web and acts as a smart connect between students and the college.

II. LITERATURE SURVEY

  • Focus:
    • The literature review focuses on management information systems and student records.
    • It considers the impact of computerized data collection, information protection, and record management on student records.
  • Theoretical Under-pinning of the Study:
    • Definition of a Student: According to the University of Florida (2012), a student is an individual registered for a university credit course or program.
    • Definition of a Student Record: A student record, also known as an educational record, contains information directly related to a student, making it personally identifiable.
    • Personal Identifiers: These include the student's name, student ID, student address, parent/family member names, and personal characteristics.
    • Media:
      • Student records are maintained in multiple media, including handwriting, print, computer’s main memory, magnetic tapes, cassettes, disks, and CDs.
      • These records may be presented by the student, submitted on behalf of the student, or created by the university.
    • Purpose:
      • Student records assist offices in supporting basic institutional objectives.
      • They document student progress and achievement in the educational process of the university.
  • Computerized Data Collection on Maintenance of Student Records:
    • Methodology: According to Sharapova (2014), a systematic literature review was employed with the following steps:
      1. A variety of combinations of search strings were applied to selected scientific databases and search engines.
      2. Papers pre-selected based on their title and abstracts were downloaded to the citation manager, along with their full text.
      3. Duplicates, multiple entries, and irrelevant papers were removed; remaining papers were scanned for information of interest.
      4. When a relevant document was cited that had not been previously identified by database queries, it was downloaded.
  • Computerized Information Protection on Students Record:
    • Challenges: According to Kyobe, South African university (2009), computerized information security issues (e.g., access to information, cyber-crime, privacy, virus attacks, and commercial data mining) are major concerns in academia today (Myler and Broadbent, 2006).
    • Security Concerns: According to Wamukoya and Mutual (2005), poor security and confidentiality controls have been identified as major factors contributing to the failure of capturing and preservation of electronic records in eastern and southern African institutions of education.
    • Lack of Protection:
      • Chinyemba and Ngulube (2005) found that 89% of the academics surveyed at the University of KwaZulu-Natal did not adequately protect and secure their electronic records.
      • Jones and Soltren (2005) found that 58% of the students surveyed were not concerned at all about risks to privacy on social network systems.
      • Lack of proper protection could be a problem.
  • Computerized Record/Data Management on Maintenance of Student Record:
    • Importance: According to the student records manual prepared by the University of South Florida, the creation and maintenance of records relating to the students of an institution are essential for:
      • Managing the relationship between the institution and the student.
      • Providing support and other services facilities to the student.
      • Controlling the student’s academic progress and measuring their achievements ,both at institution and subsequently.
      • Providing support to the student after they leave the institution.
    • Data Usage: Student records contain data that the institution can aggregate and analyze to inform future strategy, planning, and service provision.
    • Fair Information Practices: Educational universities and agencies are required to confirm to fair information practices, meaning that persons who are subjects of data systems must:
      • Be informed of the existence of such a system.
      • Have identified for them what data about them are on record.
      • Be given assurances that such data are used only for intended purposes.
      • Be certain that those responsible for data systems take reasonable precautions to prevent misuse of data.
    • User Preferences:
      • According to Allen (1989), studies analyzing patron’s response to using bibliographic databases on CD-ROM in academic libraries found that patrons prefer CD-ROM to comparable printed reference tools.
      • Lombardo and Condic (2000) found that users preferred OPAC (On-line Public Access Catalogue) and found it easy to use.

III. PROPOSED SYSTEM

  • Home Page: The design of the student information management system contains the home page, which is the first page of the system.
    • It provides the login page using which user can login into the system using their unique login credentials.
    • The login page provides the registration form for the new users through which they can register themselves in the system.

Components:

  • A. STUDENT:
    • Students can access the information of college, attendance details, placement details, marks details, and their basic details.
    • College details contain information about various college activities and the college timetable.
    • Attendance details provide student overall attendance based on their subject-wise attendance with graphs for easy understanding.
    • Placement details include data of companies that visited the campus and upcoming drives, as well as a list of students who are placed in companies.
    • Marks details allow students to view their performance in exams.
    • Basic details contain the basic information of the students.
  • B. FACULTY:
    • Each teacher maintains the record of student attendance and marks.
    • Teachers upload the attendance file into the system, updating the attendance of each student.
    • Administrators can send notifications to teachers related to various events happening in the college.
    • Teachers can view student records to analyze the performance of particular students.
  • C. EXAM SECTION:
    • The exam section handles the details of the exam timetable and the allocation of classrooms for particular exams.
    • The internal marks and results of the students are approved by the exam section.
  • D. PLACEMENT CELL:
    • The placement cell is handled by the placement officer, who updates the placement details.
    • The placement officer uploads the list of students who got placed in companies.
    • They also handle information like eligibility criteria.
  • E. ADMINISTRATOR:
    • The administrator is responsible for handling the entire system and oversees all activities.
    • The administrator adds new users to the system and can update basic details of the student like change in name, mobile number, email id, address, etc.
    • They are responsible for removing unwanted users.
    • The administrator updates college details like the event calendar and sends event notifications to the faculty.

IV. RESULT

  1. Home Page: The system starts with the home page, containing college details like college mail ID, Facebook ID, LinkedIn ID, etc.
  2. Login Page: Users enter their username and password to log in. Correct login credentials grant successful login. It provides the option of registration to the new users.
  3. Registration Page: New users can register, providing their details and getting registered into the system.
  4. Forgot Password Form: Users can recover their password by providing their email ID.
  5. Dashboard: The dashboard contains links to users' academic details.
  6. Attendance Page: Students can view their attendance details.
  7. Marks Page: Students can view their internal marks.
  8. Placement Details: Students can view placement details.
  9. Basic Details: Students can view their basic details.

V. FUTURE SCOPE

  • Using SIMS for data storage and retrieval has high scope because:
    • The project provides a simple interface for maintaining student information.
    • Students have their own user IDs and passwords to access their own information, such as attendance and marks etc., increasing the transparency of information.
    • The project avoids confusion and simplifies getting their own data for the students.
  1. In the future, students can also be able to upload or download notes
  2. The whole project will be made available as an Android app for far more ease

VI. CONCLUSION

The system helps users save time and effort by reducing processing time.
The efficiency of information handling is improved.
User satisfaction is higher compared to the old manual system.

VII. REFERENCES

  • [1] Almahdi Alshareef, Ahmed Alkilany "Toward a Student Information System for Sebha University, Libya",Fifth international conference on Innovative Computing Technology (INTECH 2015)-p 34-39
  • [2] Prabhu T Kannan, Srividya K Bansal,"Unimate: A Student Information System",2013 International Conference on Advances in Computing, Communications and Informatics (ICACCI)-p-1251-1256
  • [3] S.R.Bharamagoudar, Geeta R.B, S.G.Totad, “Web service api for student information and course management systems”International Journal of Advanced Research in Computer and Communication Engineering Vol. June 2013
  • [4] Hanan A. Al-Souly, Abeer S. Al-Sheddi, Heba A. Kurdi “Enhanced TSFS Algorithm for Secure Database Encryption” Science and Information Conference 2013. -p328-335
  • [5] D.Manivannan, R.Sujarani “Light Weight and Secure Database Encryption using TSFS Algorithm”
  • [6] Li Qian, Jun Hu, Shuying Liu “SQL Injection Attack and Prevention Technology” International Conference on Estimation, Detection and Information Fusion(ICEDIF 2015) -p-303-307
  • [7] System and method for communicating student information among student, parents guardians and educators.(US 20060127870 A1)
  • [8] Web service api for student information and course management systems(US20080085502A1)
  • [9] Student specific Information System.(US20120237917A1)
  • [10] TANG Yu-fang, ZHANG Yong-sheng, ,“Design and implementation of college student information management system based on the web services”. Natural Science Foundation of Shandong Province(Y2008G22), 978-1-4244-3930-0/09 2009 IEEE.