Project Name

    GGSIPU Result Analytics

Awarded III Prize at Inter-College Project Competition organized in association with GGSIPU at Maharaja SurajMal Institute of Technology, Delhi on 25th May 2015

Supervisors Detail

Students Detail

About Project

University issue students result through PDF files which can be downloaded from their website. Every time student wishes to see their result, they have to download the file and search their name in that file. This project aims at creating an utility which will accessible to both students and faculty, so that any student can view his/her result without downloading pdf file. Faculty can analyze students result without searching record of every student in PDF. To make this possible, a bash script has been developed which will convert a PDF file into SQL file. Basically a converter has been created which will convert a PDF file into a Database file. After creating Database, a PHP Script has been created which converts the data from the database in JSON, which is used both by the Android and Windows Phone Application through which student and faculty can view or analyze result. A Responsive Website is also available which provides the same functionality. Once the database is created, complex SQL Queries are written to retrieve the data in structured format. A lot of functionalities are provided in the website and applications.

GGSIPU Result Analyticsproject converts B.Tech. Results available at GGSIPU website from PDF format and store the structured data into the database. The Linux VM based Cloud is used as back-end, while the Website and the Mobile Applications are used as front-end. The stored data can be viewed both on the Website and the Mobile Applications (Android and Windows Phone).

The project includes a portal for Student Registration which contains all the details of the students including parent’s details, placement details, etc. This portal has an Admin panel which shows the details of all the students of GGSIPU along with their marks. The data for both the applications is sent in JSON format which is usable for developing any cross-platform application. This project provides a well-organized view of the marks of every student individually. The project provides various analytics including, but not limited to college-wise toppers, semester-wise toppers, overall toppers, and university and college ranks of students along with consolidated mark sheets.

This project involves the challenging task to handle large data set and performing optimized queries. It fetches the result and provides other analytics to end users. The complexity of the queries has to be reduced at every stage for faster processing and better response time for users. It is an application which is created for storing, maintaining, and updating the end term results of the students enrolled in the Guru Gobind Singh Indraprastha University (GGSIPU). This application simplifies and speedup the result management process. It has the capability to maintain information about the students enrolled in the particular branch, the subjects offered to students during different semesters, the marks obtained by the students in different subjects in various semesters, list of toppers for particular subject and also the overall topper. It also generates summary report (Consolidated mark sheet) regarding student information, semester wise marks list and performance reports(grades) .

The project is divided into two sub modules.

●     BACK-END: Conversion of PDF file into SQL file, JSON with PHP

●     FRONT-END: Cross-platform application that runs on Windows Phone, Android and any compatible web browser.

The project converts PDF to SQL by first converting PDF to text and then uses Shell Scripting to parse text and write SQL insert statements. The data is stored in structured format in MySQL.

This project has been designed to help our college faculty to effectively analyze the result of students through Cross-platform applications and a GUI Interface which was earlier done manually through a PDF. Also, students can now view their result using this utility which was earlier not possible. Now there is no need to download the PDF files which was earlier a cumbersome process. This GUI can also be accessed using portable devices such as Tablets, Phones etc. The students can view their marks in each semester combined in a single view rather than downloading pdfs for each semester separately.