__ _ _ _
/ _\ ___| |__ ___ | | __ _ _ __ /\/\ __ _| |_ ___
\ \ / __| '_ \ / _ \| |/ _` | '__/ \ / _` | __/ _ \
_\ \ (__| | | | (_) | | (_| | | / /\/\ \ (_| | || __/
\__/\___|_| |_|\___/|_|\__,_|_| \/ \/\__,_|\__\___|
ScholarMate is an RCMS (Report Card Managament System), under development for CS class 12 project by Anirudh, Dave & Vignesh
ScholarMate can be used by schools for handling their students' marks and keeping a secure and safe record of them. The sofware provides visual analytics of marks for each and every student who has written an exam, and also provides a comparison for the class averages. The program may be used to generate report cards for every student that has written an exam within seconds, and also includes many other features, described in the How to use ScholarMate section.
The file attatched below describes the design of the software, describing all the features and functionalities included in the software.
https://drive.google.com/file/d/1XUFr5fEAIPeqqcX7lUnfNcna0rNyRoBH/view?usp=sharing
The file attatched bellow describes the MySQL database structure
https://drive.google.com/file/d/1QQCceEJRKtQzwJt2dB5-S4vGCiToQtWy/view?usp=sharing
Note :
The database structure or the design of the software may or may not have been subject to changes during the course of development. These draw.io files were purely for our own reference during the inital stages of development. Kindly ignore any features that do not align with the initial design as they have been added/removed for a reason.
Sample report card :
REPORTCARD_Semester1_Aarti Sharma_50.pdf
Full project demo :
Ensure that you have VSCode installed on your system.
First, install python, after which run the following commands on your terminal
➡️ pip install pillow (for inserting image)
➡️ pip install sv_ttk (for the theme)
➡️ pip install fpdf (pdf generation)
➡️ pip install mysql-connector-python (for MySQL connection)
➡️ pip install matplotlib (Graph generation)
Download the zip file of this project and run login_page.py
Use only VSCode for testing and using the software and not python's IDLE. The aunthetication method in python's IDLE will not support connection to the database
Open login_page.py and enter your username and password.
As an admin you are allowed multiple access rights to the database server. You are allowed to create a new examination/a sheet for teachers to enter their student's marks, you are allowed to edit the schools directory by adding/removing teachers/students, you are allowed to generate report cards, view any student's/class' marks in a given exam and allowed to edit any student's marks in any exam. The user icon on the left hand side blue bar allows you to change your username and password. You can conveniently log out as well.
As a teacher, you are assigned to be the class teacher of a given class. You are allowed a restricted access to the database server. First and foremost, you are only allowed to view/edit your own class' marks. You cannot see or edit any other class' marks. You can generate report cards, but only for the students in your class.
As a student, you can only view your marks and generate your own report card
Here are some usernames and passwords that you may use for testing purposes :
Username and Password of admin :
➡️Username : _admin Password: _admin
Username and Password of a few students :
➡️Aarti Bansal_94
➡️Reyansh Jain_7
➡️Vivaan Sharma_2
➡️Ayaan Mehta_6
➡️Kartik Agarwal_8
Username and Password of all teachers :
➡️Mr. Arjun Gupta_5
➡️Mr. Rajesh Kumar_7
➡️Mr. Ramesh Patel_1
➡️Mr. Vikram Sharma_3
➡️Mrs. Sanya Desai_8
➡️Ms. Ananya Singh_2
➡️Ms. Neha Verma_6
➡️Ms. Priya Rao_4
For more student usernames, you may access the MySQL database. The host, username, and password are given in the source code. You may access either through your terminal or through MySQL workbench. To get more usernames and passwords, run this SQL statement to the server:
SELECT * FROM credentials;As of now, the "Edit school directory" feature (online host releease) is currently UNAVAILABLE due to server issues. This feature is only available for localhost release where the database server issues have been resolved. We apologise for any inconvenience caused.
Coming soon ...