school-grading-system

School grading system Rest APIS using Django Rest Framework

Intro

Creating a school grading system using Django Rest Framework

Key Functionalities

It has two users:

1. Teacher
2. Student

Both users have different authorizations access Teacher can add marks for students using pdf Teacher can view marks for all students of any grade Student can view their own marks

Tech

certifi==2018.4.16 chardet==3.0.4 coreapi==2.3.3 coreschema==0.0.4 distro==1.3.0 Django==2.0.7 django-rest-swagger==2.2.0 djangorestframework==3.8.2 djangorestframework-jwt==1.11.0 idna==2.7 itypes==1.1.0 Jinja2==2.10 MarkupSafe==1.0 numpy==1.14.5 openapi-codec==1.3.2 pandas==0.23.3 pdftables-api==1.0.0 PyJWT==1.6.4 python-dateutil==2.7.3 pytz==2018.5 requests==2.19.1 simplejson==3.16.0 six==1.11.0 tabula-py==1.2.0 uritemplate==3.0.0 urllib3==1.23

Steps for Installation

Make a directory where you want to store the project mkdir Gridle cd Gridle

Install virtual environment for python pip install virtualenv or python -m pip install virtualenv

Create virtual environment for python mkdir vene_gridle cd venv_gridle virtualenv . Activate virtual environment .\Scripts\activate

Download or clone folder

Install Requirments pip install -r requirements.txt or python -m pip install -r requirements.txt

Runserver python server python manage.py runserver

Postman APIs

Login

It checks whether user is present in the database http://127.0.0.1:8000/login In Body add following JSON as it is a POST request [{"email":"value","password":"value"}]

AddMarks

It adds marks from a pdf file to Marksheet Model http://127.0.0.1:8000/addmarks/<filename> example: http://127.0.0.1:8000/addmarks/file Select form-data in the and select FILE option Click on choose file option and select pdf file* In Headers section add TOKEN at key {id_value} at value where id_value is teacher's id

'*' pdf file should have format student_id | grade| english| maths | science xlsx or xls file should be saved as pdf Copy of your pdf will be stored in your folder with a csv file

GetMarks

This API views all the data for a particular student using student ID http://127.0.0.1:8000/getmarks It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is students' id

GetMarksByGrade

This API views students' data for that grade using student ID as well as grade parameter http://127.0.0.1:8000/getmarks/<grade> example: http://127.0.0.1:8000/getmarks/9 http://127.0.0.1:8000/getmarks/8 It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is students' id

GetMarksBYSubject

This API views marks of student for a particular subject using student ID as well as subject parameter http://127.0.0.1:8000/getmarks/<subject> example: http://127.0.0.1:8000/getmarks/english http://127.0.0.1:8000/getmarks/maths http://127.0.0.1:8000/getmarks/science

It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is students' id

FetchMarks

This API views all the data of students using teacher's ID http://127.0.0.1:8000/fetchmarks It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is Teacher's id

FetchmarksByGrade

This API views all the data of students of same grade using teacher's ID http://127.0.0.1:8000/fetchmarks/<grade> example: http://127.0.0.1:8000/fetchmarks/8 It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is Teacher's id

FetchmarksBySubject

This API views all the data of students for a particular subject using teacher's ID http://127.0.0.1:8000/fetchmarks/<subject> example: http://127.0.0.1:8000/fetchmarks/english http://127.0.0.1:8000/fetchmarks/maths http://127.0.0.1:8000/fetchmarks/science It is a GET API In Headers section add TOKEN at key {id_value} at value where id_value is Teacher's id

UserProfile

This Api views the profile of a particular user ````http://127.0.0.1:8000/userprofile>``` It is a GET API In Headers section add TOKEN at key ```{id_value}``` at value where id_value is user's id