- \n
- Add attendance<\/li>\n
- Add marks<\/li>\n
- Add notice<\/li>\n
- Check attendance<\/li>\n
- Check notice<\/li>\n
- Check marks<\/li>\n<\/ul>\n
School Management System Project Prerequisites<\/h3>\n
To install the required libraries, please use pip installer from the terminal:<\/p>\n
pip install Django\r\n<\/pre>\n
Download School Management System Source Code<\/h3>\n
Please download the source code of online school management system in django: Online School Management System Project Code<\/strong><\/a><\/p>\n
Steps to Create School Management Project in Python Django<\/h2>\n
1. Start Project<\/h3>\n
Django itself creates a project and an app with all the necessary files if we run the following commands<\/p>\n
django-admin startproject OnlineSchoolMgmt\r\ncd OnlineSchoolMgmt\r\ndjango-admin startapp app\r\n<\/pre>\n
2. Writing Models<\/h3>\n
Code:<\/strong><\/p>\n
from django.db import models\r\nfrom django.contrib.auth.models import User\r\n \r\n# Create your models here.\r\n \r\nclass Attendance(models.Model):\r\n StudentName = models.CharField(max_length=200,null=True)\r\n StudentId = models.CharField(max_length=50,null=True)\r\n LecturesAttended = models.IntegerField(null=True)\r\n TotalLectures = models.IntegerField(null=True)\r\n \r\n def __str__(self):\r\n return self.StudentName\r\n \r\nclass Marks(models.Model):\r\n StudentName = models.CharField(max_length=200,null=True)\r\n StudentId = models.CharField(max_length=50,null=True)\r\n PhysicsMarks = models.IntegerField(null=True)\r\n ChemistryMarks = models.IntegerField(null=True)\r\n MathsMarks = models.IntegerField(null=True)\r\n EnglishMarks = models.IntegerField(null=True)\r\n ComputerMarks = models.IntegerField(null=True)\r\n \r\n def __str__(self):\r\n return self.StudentName\r\n \r\nclass Notice(models.Model):\r\n Message = models.CharField(max_length=200,null=True)\r\n date_created = models.DateTimeField(auto_now_add=True)\r\n \r\n def __str__(self):\r\n return self.Message\r\n<\/pre>\n
In this school management system project, we have created 3 models. In other words, we have created 3 tables to store the details of student\u2019s attendance, marks, and the notice (if any) drafted by the school authorities.<\/p>\n
Now, to actually create the tables, we have to execute the following two commands:<\/p>\n
Py manage.py makemigrations\r\nPy manage.py migrate\r\n<\/pre>\n
3. forms.py<\/h3>\n
Django does not create this file, so we have to create this new file in the app folder and then you can type the following code in forms.py.<\/p>\n
Forms.py is required to implement CRUD functionality i.e. for creating, retrieving, updating and deleting objects from the database. So we have created a form for each model we have defined.<\/p>\n
Code:<\/strong><\/p>\n
from django.forms import ModelForm\r\nfrom .models import *\r\nfrom django.contrib.auth.forms import UserCreationForm\r\nfrom django.contrib.auth.models import User\r\n \r\nclass createuserform(UserCreationForm):\r\n class Meta:\r\n model=User\r\n fields=['username','password'] \r\n \r\nclass addAttendanceform(ModelForm):\r\n class Meta:\r\n model=Attendance\r\n fields=\"__all__\"\r\n \r\nclass addMarksform(ModelForm):\r\n class Meta:\r\n model=Marks\r\n fields=\"__all__\"\r\n \r\nclass addNoticeform(ModelForm):\r\n class Meta:\r\n model=Notice\r\n fields=\"__all__\"\r\n<\/pre>\n
4. admin.py<\/h3>\n
Code:<\/strong><\/p>\n
from django.contrib import admin\r\nfrom .models import *\r\n \r\n# Register your models here.\r\nadmin.site.register(Atttendance)\r\nadmin.site.register(Notice)\r\nadmin.site.register(Marks)\r\n<\/pre>\n
Django provides an inbuilt admin panel for online school management project (for every project). We have to register the models we have created on admin panel so that we can access the data from admin panel also. But for that we require a staff user, to create a superuser (admin) run the following commands:<\/p>\n
py manage.py createsuperuser<\/pre>\n
It will ask following details: username, email, and password.<\/p>\n
5. urls.py<\/h3>\n
Code:<\/strong><\/p>\n
\"\"\"OnlineSchoolMgmt URL Configuration\r\n \r\nThe `urlpatterns` list routes URLs to views. For more information please see:\r\n https:\/\/docs.djangoproject.com\/en\/3.1\/topics\/http\/urls\/\r\nExamples:\r\nFunction views\r\n 1. Add an import: from my_app import views\r\n 2. Add a URL to urlpatterns: path('', views.home, name='home')\r\nClass-based views\r\n 1. Add an import: from other_app.views import Home\r\n 2. Add a URL to urlpatterns: path('', Home.as_view(), name='home')\r\nIncluding another URLconf\r\n 1. Import the include() function: from django.urls import include, path\r\n 2. Add a URL to urlpatterns: path('blog\/', include('blog.urls'))\r\n\"\"\"\r\nfrom django.contrib import admin\r\nfrom django.urls import path\r\nfrom app.views import*\r\n \r\nurlpatterns = [\r\n path('admin\/', admin.site.urls),\r\n path('',home ,name='home'),\r\n \r\n path('addAttendance\/', addAttendance,name='addAttendance'),\r\n \r\n path('addMarks\/', addMarks,name='addMarks'),\r\n \r\n path('addNotice\/', addNotice,name='addNotice'),\r\n \r\n path('login\/', loginPage,name='login'),\r\n path('logout\/', logoutPage,name='logout'),\r\n path('register\/', registerPage,name='register'),\r\n]\r\n<\/pre>\nWe have defined the url patterns in this file.<\/p>\n
6. views.py:<\/h3>\n
Code:<\/strong><\/p>\n
from django.shortcuts import redirect,render\r\nfrom django.contrib.auth import login,logout,authenticate\r\nfrom django.http import HttpResponse\r\nfrom .forms import *\r\n \r\ndef home(request):\r\n notice = Notice.objects.all()\r\n attendance = Attendance.objects.all()\r\n marks = Marks.objects.all()\r\n \r\n context = {\r\n 'notice':notice,\r\n 'marks':marks,\r\n 'attendance':attendance,\r\n }\r\n return render(request,'app\/home.html',context)\r\n \r\ndef addAttendance(request): \r\n if request.user.is_authenticated:\r\n form=addAttendanceform()\r\n if(request.method=='POST'):\r\n form=addAttendanceform(request.POST)\r\n if(form.is_valid()):\r\n form.save()\r\n return redirect('\/')\r\n context={'form':form}\r\n return render(request,'app\/addAttendance.html',context)\r\n else: \r\n return redirect('home')\r\n \r\ndef addMarks(request): \r\n if request.user.is_authenticated:\r\n form=addMarksform()\r\n if(request.method=='POST'):\r\n form=addMarksform(request.POST)\r\n if(form.is_valid()):\r\n form.save()\r\n return redirect('\/')\r\n context={'form':form}\r\n return render(request,'app\/addMarks.html',context)\r\n else: \r\n return redirect('home') \r\n \r\ndef addNotice(request): \r\n if request.user.is_authenticated:\r\n form=addNoticeform()\r\n if(request.method=='POST'):\r\n form=addNoticeform(request.POST)\r\n if(form.is_valid()):\r\n form.save()\r\n return redirect('\/')\r\n context={'form':form}\r\n return render(request,'app\/addNotice.html',context)\r\n else: \r\n return redirect('home') \r\n \r\ndef registerPage(request):\r\n if request.user.is_authenticated:\r\n return redirect('home') \r\n else: \r\n form=createuserform()\r\n if request.method=='POST':\r\n form=createuserform(request.POST)\r\n if form.is_valid() :\r\n user=form.save()\r\n return redirect('login')\r\n context={\r\n 'form':form,\r\n }\r\n return render(request,'app\/register.html',context)\r\n \r\ndef loginPage(request):\r\n if request.user.is_authenticated:\r\n return redirect('home')\r\n else:\r\n if request.method==\"POST\":\r\n username=request.POST.get('username')\r\n password=request.POST.get('password')\r\n user=authenticate(request,username=username,password=password)\r\n if user is not None:\r\n login(request,user)\r\n return redirect('\/')\r\n context={}\r\n return render(request,'app\/login.html',context)\r\n \r\ndef logoutPage(request):\r\n logout(request)\r\n return redirect('\/')\r\n<\/pre>\nThe very first function is home which renders all the entries from Attendance, Marks, and Notice table and pass them to home.html. Home.html (which is the home page of school management project) displays all the information in tabular form.<\/p>\n
Home.html<\/h4>\n
{% extends 'app\/Links.html' %}\r\n \r\n{% block content %}\r\n \r\n<div class=\"container \">\r\n \r\n <br><br>\r\n<div class=\"row\">\r\n <div class=\"col-md-9\">\r\n <h5>Notice:<\/h5>\r\n \r\n <div class=\"card card-body\">\r\n <table class=\"table table-sm\">\r\n <tr>\r\n <th>Notice<\/th>\r\n <th>Date<\/th>\r\n <\/tr>\r\n {% for n in notice %}\r\n <tr>\r\n <td>{{n.Message}} <\/td>\r\n <td>{{n.date_created}} <\/td>\r\n <\/tr>\r\n {% endfor %}\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n \r\n<br><br>\r\n \r\n<div class=\"row\">\r\n <div class=\"col-md-9\">\r\n <h5>Attendance:<\/h5>\r\n \r\n <div class=\"card card-body\">\r\n <table class=\"table table-sm\">\r\n <tr>\r\n <th>Student Id<\/th>\r\n <th>Student Name<\/th>\r\n <th>Attended Lectures<\/th> \r\n <th>Total Lectures<\/th>\r\n <\/tr>\r\n {% for a in attendance %}\r\n <tr>\r\n <td>{{a.StudentId}} <\/td>\r\n <td>{{a.StudentName}} <\/td>\r\n <td>{{a.LecturesAttended}} <\/td>\r\n <td> {{a.TotalLectures}} <\/td>\r\n <\/tr>\r\n {% endfor %}\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n \r\n<br><br>\r\n \r\n<div class=\"row\">\r\n <div class=\"col-md-9\">\r\n <h5>Marks:<\/h5>\r\n \r\n <div class=\"card card-body\">\r\n \r\n <table class=\"table table-sm\">\r\n <tr>\r\n <th>Student Id<\/th>\r\n <th>Student Name<\/th>\r\n <th>Physics Marks<\/th> \r\n <th>Chemistry Marks<\/th> \r\n <th>Maths Marks<\/th> \r\n <th>English Marks<\/th> \r\n <th>Computer Marks<\/th> \r\n <\/tr>\r\n {% for m in marks %}\r\n <tr>\r\n <td>{{m.StudentId}} <\/td>\r\n <td>{{m.StudentName}} <\/td>\r\n <td>{{m.PhysicsMarks}} <\/td>\r\n <td>{{m.ChemistryMarks}} <\/td>\r\n <td>{{m.MathsMarks}} <\/td>\r\n <td>{{m.EnglishMarks}} <\/td>\r\n <td>{{m.ComputerMarks}} <\/td>\r\n <\/tr>\r\n {% endfor %}\r\n <\/table>\r\n <p> <b>Note:<\/b> Marks are out of 100<\/p>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n\r\n\r\n\r\n{% endblock %}\r\n<\/pre>\nAdmin Home Page:<\/h4>\n
![\"admin](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/admin-home-page-1.png\")
<\/a><\/p>\n![\"school](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/admin-home-page-2.png\")
<\/a><\/p>\nStudent Home Page:<\/h4>\n
![\"school](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/school-student-home-page-1.png\")
<\/a><\/p>\nWe can see the navigation bar for both the users are different.<\/p>\n
The next function in this file is addAttendance which uses addAttendanceform to create a new record in attendance table. This function is only for admin of school management project. If any other user attempts to access this, the user will get redirected to respective home page.<\/p>\n
AddAttendance.html<\/h4>\n
{% extends 'app\/Links.html' %}\r\n{% block content %}\r\n \r\n<div class=\"jumbotron container row\">\r\n <div class=\"col-md-6\">\r\n \r\n <h1>Add Attendance<\/h1>\r\n <div class=\"card card-body\">\r\n <form action=\"\" method=\"POST\">\r\n {% csrf_token %}\r\n {{form.as_p}}\r\n <br>\r\n <input type=\"submit\" name=\"Submit\">\r\n <\/form>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n \r\n<\/div>\r\n{% endblock %}\r\n<\/pre>\nAdd Attendance Page:<\/h4>\n
![\"add](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/add-attendance-admin.png\")
<\/a><\/p>\nAdd Marks and Add Notice functions are very similar to this function<\/p>\n
AddNotice.html<\/h4>\n
{% extends 'app\/Links.html' %}\r\n{% block content %}\r\n \r\n<div class=\"jumbotron container row\">\r\n <div class=\"col-md-6\">\r\n <h1>Add Notice<\/h1>\r\n <div class=\"card card-body\">\r\n <form action=\"\" method=\"POST\">\r\n {% csrf_token %}\r\n {{form.as_p}}\r\n <br>\r\n <input type=\"submit\" name=\"Submit\">\r\n <\/form>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n \r\n<\/div>\r\n{% endblock %}\r\n<\/pre>\nAdd Notice Page:<\/h4>\n
![\"add](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/add-notice-admin.png\")
<\/a><\/p>\n![\"add](\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2021\/05\/add-marks-admin.png\")
<\/a><\/p>\n