Students Management System Using Python
Data science projects in pondicherry
Create New

Students Management System Using Python

Project period

07/18/2020 - 07/31/2020

Views

68

0

Project Category

Computer Science



Students Management System Using Python
Students Management System Using Python

The main advantage of a student management system is that as a school, colleges or any other training institute we are able to keep a proper track of data/information related to students. The Student Management System provides an easy interface for maintenance of student data. It can be used by school, educational institutes or colleges to maintain the records of students easily. The creation and management of accurate, still to date information regarding a students’ is critically important in the schools as well as colleges. Student information system deals with all kinds of student details. If we want any information regarding the particular student then it can be obtained by just entering the roll number or the name of the student to be searched. This student management system will make the work of storing the information in an organized way.

Why: Problem statement

With the help of this computer system no longer would the admin people need to type in all the data or information of the students as well as others in the school or college on excel sheets for long hours. The majority of student data can be quite complex, without a student information system, that information can be lost on the way. Every educational institution has to manage a large amount of students' data on a daily basis. Students form an important part of all educational institutions. But the institutions find it difficult to maintain the details of many students of the organization just in one stretch. It should involve a lot of pen paper work. Sometimes there will be some huge amount of files bundled up and kept together in the office.

How: Solution description

Student Management is developed using python programming with tkinter library. The project contains only an admin side from where the admin can maintain student records easily. In this project, the user has to perform all the important functions from the Admin side. We can add student records, the user has to provide various data such as his/her name, roll no., date of birth, and gender, phone number location etc. After this, the user can easily manage the student’s record and can update, delete the data if we want.

The project file contains a python script (student management system.ipny). Also, the design of this project is very simple so that the user won’t find any difficulties while working on it. Our Student Management system in Python helps in easy management of student records and data.

Before we run this project, we must have Python installed on our Computer. I created the database using python programming. The database python script is saved by (database.db). In this database I created a table, the table contains the name, age, roll no which we want to add in this database. After completing the database, I designed GUI using tkinter library. Then We combine the GUI with the database. Finally I ran the program, the GUI was opened. I enter details for name, Age, Roll no., etc and click the add button it will be stored in the database. Then I click the view all button and it will show the total number for registration.

How is it different from competition

This project can all now be organized in a format that happens to be simple and easy to accept one and all. This also means that we would be able to access data/information within a few seconds. Student information systems help organize, categorize this information, saving a valuable amount of time from the teachers, students and everyone else involved in the education process. Student management systems reduce manual workload and labor as they make daily tasks easier, error-free and simple. In this project, we wanted to make something different from other projects. It helps many schools, colleges and other educational institutions. This project is done by simple python programming and very easy to maintain the data/information.

Who are your customers

This project is mainly proposed by school, college, and many educational institutions. By collecting student data, teachers and the management can assess the progress of their students and manage daily workload and track student’s information. It mainly helps the educational institution such that the student management system can simplify the registration process of an institute at each stage.

Project Phases and Schedule

Software Installation: Before we start the project, First of all we need to install Python 3.7 and all the required python packages.

Import required library: We import the tkinter library for creating GUI.

Create Database: After we created the database using python programming. We created a database table, the table contains the name, age, roll no etc. which we want to add in this database. The database fetches the student details from the GUI and maintains the students' details.

Create GUI: Then we create GUI(graphical user interface) using tkinter and connect the database with the GUI.

Program Execution: After completing the python coding we started to run the project and get the desired output. If we want to see all the students' details click the view all button.

Resources Required

Software requirements: Python 3.7 - Underneath the Python Releases for Windows find Latest Python 3 Release – Python 3.7. 4 (latest stable release as of now is Python 3.7. The advantages of Python 3.7 are Easier access to debuggers through a new breakpoint() built-in, Simple class creation using data classes, Customized access to module attributes, Improved support for type hinting and Higher precision timing functions. 

Anaconda tool: Anaconda may be a free and open-source distribution of the Python and R programming languages for scientific computing (data science, machine learning applications, large-scale processing, prediction analysis, etc.). You can download anaconda tool for Python by clicking this link - https://anaconda.org

Download:
Project Code Code copy
/* Your file Name : Students Management System.ipynb */
/* Your coding Language : python */
/* Your code snippet start here */
{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from tkinter import *\n",
    "import sqlite3,sys\n",
    "\n",
    "def connection():\n",
    "    try:\n",
    "        conn=sqlite3.connect(\"Students.db\")\n",
    "    except:\n",
    "        print(\"cannot connect to the database\")\n",
    "    return conn    \n",
    "\n",
    "\n",
    "def verifier():\n",
    "    a=b=c=d=e=f=0\n",
    "    if not student_name.get():\n",
    "        t1.insert(END,\"<>Student name is required<>\\n\")\n",
    "        a=1\n",
    "    if not roll_no.get():\n",
    "        t1.insert(END,\"<>Roll no is required<>\\n\")\n",
    "        b=1\n",
    "    if not branch.get():\n",
    "        t1.insert(END,\"<>Branch is required<>\\n\")\n",
    "        c=1\n",
    "    if not phone.get():\n",
    "        t1.insert(END,\"<>Phone number is requrired<>\\n\")\n",
    "        d=1\n",
    "    if not father.get():\n",
    "        t1.insert(END,\"<>Father name is required<>\\n\")\n",
    "        e=1\n",
    "    if not address.get():\n",
    "        t1.insert(END,\"<>Address is Required<>\\n\")\n",
    "        f=1\n",
    "    if a==1 or b==1 or c==1 or d==1 or e==1 or f==1:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0\n",
    "\n",
    "\n",
    "def add_student():\n",
    "            ret=verifier()\n",
    "            if ret==0:\n",
    "                conn=connection()\n",
    "                cur=conn.cursor()\n",
    "                cur.execute(\"CREATE TABLE IF NOT EXISTS STUDENTS(NAME TEXT,ROLL_NO INTEGER,BRANCH TEXT,PHONE_NO INTEGER,FATHER TEXT,ADDRESS TEXT)\")\n",
    "                cur.execute(\"insert into STUDENTS values(?,?,?,?,?,?)\",(student_name.get(),int(roll_no.get()),branch.get(),int(phone.get()),father.get(),address.get()))\n",
    "                conn.commit()\n",
    "                conn.close()\n",
    "                t1.insert(END,\"ADDED SUCCESSFULLY\\n\")\n",
    "\n",
    "\n",
    "def view_student():\n",
    "    conn=connection()\n",
    "    cur=conn.cursor()\n",
    "    cur.execute(\"select * from STUDENTS\")\n",
    "    data=cur.fetchall()\n",
    "    conn.close()\n",
    "    for i in data:\n",
    "        t1.insert(END,str(i)+\"\\n\")\n",
    "\n",
    "\n",
    "def delete_student():\n",
    "    ret=verifier()\n",
    "    if ret==0:\n",
    "        conn=connection()\n",
    "        cur=conn.cursor()\n",
    "        cur.execute(\"DELETE FROM STUDENTS WHERE ROLL_NO=?\",(int(roll_no.get()),))\n",
    "        conn.commit()\n",
    "        conn.close()\n",
    "        t1.insert(END,\"SUCCESSFULLY DELETED THE USER\\n\")\n",
    "\n",
    "def update_student():\n",
    "    ret=verifier()\n",
    "    if ret==0:\n",
    "        conn=connection()\n",
    "        cur=conn.cursor()\n",
    "        cur.execute(\"UPDATE STUDENTS SET NAME=?,ROLL_NO=?,BRANCH=?,PHONE_NO=?,FATHER=?,ADDRESS=? where ROLL_NO=?\",(student_name.get(),int(roll_no.get()),branch.get(),int(phone.get()),father.get(),address.get(),int(roll_no.get())))\n",
    "        conn.commit()\n",
    "        conn.close()\n",
    "        t1.insert(END,\"UPDATED SUCCESSFULLY\\n\")\n",
    "\n",
    "\n",
    "def clse():\n",
    "    sys.exit() \n",
    "\n",
    "\n",
    "if __name__==\"__main__\":\n",
    "    root=Tk()\n",
    "    root.title(\"Student Management System\")\n",
    "     \n",
    "    student_name=StringVar()\n",
    "    roll_no=StringVar()\n",
    "    branch=StringVar()\n",
    "    phone=StringVar()\n",
    "    father=StringVar()\n",
    "    address=StringVar()\n",
    "    \n",
    "    label1=Label(root,text=\"Student name:\",)\n",
    "    label1.place(x=0,y=0)\n",
    "\n",
    "    label2=Label(root,text=\"Roll no:\")\n",
    "    label2.place(x=0,y=30)\n",
    "\n",
    "    label3=Label(root,text=\"Branch:\")\n",
    "    label3.place(x=0,y=60)\n",
    "\n",
    "    label4=Label(root,text=\"Phone Number:\")\n",
    "    label4.place(x=0,y=90)\n",
    "\n",
    "    label5=Label(root,text=\"Father Name:\")\n",
    "    label5.place(x=0,y=120)\n",
    "\n",
    "    label6=Label(root,text=\"Address:\")\n",
    "    label6.place(x=0,y=150)\n",
    "\n",
    "    e1=Entry(root,textvariable=student_name)\n",
    "    e1.place(x=100,y=0)\n",
    "\n",
    "    e2=Entry(root,textvariable=roll_no)\n",
    "    e2.place(x=100,y=30)\n",
    "\n",
    "    e3=Entry(root,textvariable=branch)\n",
    "    e3.place(x=100,y=60)\n",
    "\n",
    "    e4=Entry(root,textvariable=phone)\n",
    "    e4.place(x=100,y=90)\n",
    "    \n",
    "    e5=Entry(root,textvariable=father)\n",
    "    e5.place(x=100,y=120)\n",
    "\n",
    "    e6=Entry(root,textvariable=address)\n",
    "    e6.place(x=100,y=150)\n",
    "    \n",
    "    t1=Text(root,width=80,height=20)\n",
    "    t1.grid(row=10,column=1)\n",
    "   \n",
    "\n",
    "\n",
    "    b1=Button(root,text=\"ADD STUDENT\",command=add_student,width=40)\n",
    "    b1.grid(row=11,column=0)\n",
    "\n",
    "    b2=Button(root,text=\"VIEW ALL STUDENTS\",command=view_student,width=40)\n",
    "    b2.grid(row=12,column=0)\n",
    "\n",
    "    b3=Button(root,text=\"DELETE STUDENT\",command=delete_student,width=40)\n",
    "    b3.grid(row=13,column=0)\n",
    "\n",
    "    b4=Button(root,text=\"UPDATE INFO\",command=update_student,width=40)\n",
    "    b4.grid(row=14,column=0)\n",
    "\n",
    "    b5=Button(root,text=\"CLOSE\",command=clse,width=40)\n",
    "    b5.grid(row=15,column=0)\n",
    "\n",
    "\n",
    "    root.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
View on Github
Student

Comments

Leave a Comment

Post a Comment

Are you Interested in this project?


Do you need help with a similar project? We can guide you. Please Click the Contact Us button.


Contact Us

Social Sharing