PDF Marksheet Generator

Published Online October 2014 in MECS

The marksheet generator is a system which allows the digital automation of the mark-sheets of the students. The system will generate the mark-sheets in Portable Document Format which is globally accepted format for files. The PDF document is very difficult to modify and requires the use of the complex software.

To simply put, system is to provide the mark-sheet for credits based grading system in user friendly and secure manner. The credits based grading system enables a much require shift in focus from teacher-centric to learner-centric education. It also focuses on the continuous evaluation which will enhance the quality of education. It is very much essential to implement credits based grading system based higher education worldwide.

• II.    Review of Literature

The marksheet generator is kind of a document generator. There have been number of technologies proposed to generate the document or reports.

• A.    Existing System

Digital Signature based mark-sheet generator: A digital signature or the digital signature scheme is type of asymmetric cryptography used to simulate the security properties of hand written signature on the paper. The output of signature process is digital signature. It provides authenticity and integrity to data ^[2].

Digital academic transcript using encrypted QR code: Mark-sheet embed the digital form in mark sheet using encrypted QR code, so that any unauthorized user cannot retrieve any information ^[1].

Predictive model for education: There are a set classification rules that were extracted from the decision tree to predict and classify the class label for each student [4] .

Custom Report Generation:  The modules are interrelated in a logical manner to report all clinical engineering services. Each user has a unique login name and a password, which are checked and verified by the system against the granted permissions of the respective user group. In addition, adequate mechanisms for easy and accurate data report and protection were installed in order to minimize incidents of incomplete or corrupted reports [3].

Report Generator technical Specification: It provides the capability for users to create their own text, graph or diagram reports, or allow them to use the standard report supplied with Isograph software product ^[5].

• B.    Disadvantage of Existing System

Association of digital signature and trusted time stamp: Digital signature algorithm and protocol do no inherently provide the certainty about the date and time at which underlying document was signed ^[2].

Non repudiation: In cryptographic context, the word repudiation refers to any act disclaiming responsibility for message. It is used to remove old expired certificates from repository. It is matter for security policy and responsibility of authority to keep old certificates for a period of time if non-repudiation data service is provided [2]

.

Unavailability of hardware: Even though the use of QR code in a mark-sheet that possess ability to scan QR code. Also for scanning purpose one must have hardware which adds a cost to system.

Lack of user friendly interface: Due to use of DOS or user interfaces which are not user friendly. It also uses various difficult commands to complete the number of tasks. The existing system fails to provide a good user interface. Also understanding of the user interface of existing system is tedious and time consuming whereas the new system is self-explanatory and easy to use as far as user interface is concerned.

• III.    Proposed System

The marksheet generator is to ensure an efficient certificate management using huge data and to provide mark-sheets for credit based grading system (CBGS) in very user friendly manner by not making it very complex.

The system being automated and generalized, the system ensures to reduce manual errors by reducing manual efforts. An added asset to the feature of system is that it aims at improving and easing out the work of the existing system in very sophisticated way.

• IV.    Working

In this proposed system, the admin of the system enters the marks of each student. That information will be stored in internal collection information database. In this system, percentage and grade is calculated manually.

The marksheet generation system is to ensure an efficient marksheet management using huge data and to provide mark-sheets for credit based grading system (CBGS) in very user friendly manner by not making it very complex.

As we describe in the existing system after the paper is check the marks goes to the mark sheet generator system. The admin of the system in this proposed system just enter the mark and information of the each student. That information will be stored in internal collection information database. In the system the percentage and grade is calculated manually.

After the marks of all the students is enter by the admin of the system by clicking the mark sheet generator button. Then application generates the mark sheet of all the students automatically with the grades calculated. Mark sheets will be in PDF format.PDF mark sheets cannot be easily tampered with and require use of complex software. The pdf file of mark sheet of every student will be stored in mark sheet database. And then application makes mark sheets available via internet on demand.

Fig. 1. System architecture of Marksheet generator

• V. Algorithm

This is how our system will work. Steps for the implementation of system are as follow:

Fig. 2. Flowchart for Marksheet generator

Step 1: If admin is operating the system, login id and password. If student is operating the system, they can access the system by providing the registration id.

Step 2: Check if provided login id and password or registration id is correct, if not go back to step 1 and if correct proceed for the step 3.

Step 3: If admin is operating the system, he can access the system by updating the database, changing the data in the database and can get the required information from the database. If students are operating the system, the can only view the data.

Step 4: Then system will generate the gadget sheet of all the students and it calculates the grade and grade point of each and every student as per the Credit based grading system (CBGS).

Step 5: Then this system will generate the mark sheet by fetching the grades, pointers and credits from the gadget sheet previously developed.

Step 6: Then this information of students’ marks are available to access to students by providing authentication. Admin will get requested mark sheet in PDF mark sheet for printing purpose. And only marks can be accessible to student.

Steps 7: These mark sheets then can be made printable by converting it into portable document format.

Table 1. Letter grades and their equivalent grade points applicable for under graduates

Percentage of marks Obtain	Letter Grade	Grade Points
80.00 and above	O	10
75.00-79.99	A	9
70.00-74.99	B	8
60.00-69.99	C	7
50.00-59.99	D	6
45.00-49.99	E	5
40.00-44.99	P	4
Less than 40.00	F	0

VI. Technology and Concept

PHP is used for web development works as a server side scripting language and also it is used for general purpose programming. PHP code is interpreted by a web server with the PHP processor generates the resulting page which interprets the PHP code. It also includes interface capacity of command line and can be used standalone graphical application.

In this system input can be marks of the students of their theory exams, practical exams, internal assessment and term work. Grades and pointers of student can be calculated according to rules, formulae and ordinances.

The formulae for calculation of grade performance index (GPI):

Semester Grade Performance Index (SGPI): The performance of semester is indicated by a number called semester grade performance index. SGPI is weighted average of the grade points obtained in all the courses by the student during the semester.

SGPI _ C1G1+C2G2+ ⋯

С1+С2+⋯

Cumulative Grade Performance Index (CGPA): An up to date of an overall performance of student from the time he/she enrolled in the university is obtained by calculating a number called cumulative grade performance index. It is calculated in similar manner of SGPI. CGPA is responsible to reflect final pass or fail status of student.

CGPI=

C1G1+C2G2+ ⋯

С1+С2+⋯

VII. Result And Discussion

The implementation phase of our project is still in progress. Thus far, we have successfully completed the implementation and work of the following factors:

• •    Final outline of the gadget sheet.

• •    Automated fetching of marks of the students from database.

• •    Calculation of Grades and credits for each course.

• •    Verification and evaluation of marks for special cases (Ordinance for grace marks)

• •    Generation of grade points for each Course.

• •    Determination of Grade Performance Index.

• •    Display of Final Performance of the student in terms of Pass/Fail.

• •    Veto Power Allocation for Admin Login.

• •    Creation of individual mark sheets by fetching data from gadget sheet.

• •    Availability of information of marks to individual student via internet/intranet.

Gadget sheet can be considered as a booklet which consists of marks, student information and grades of all the students belonging to specific organization. Gadget sheet keeps the track of student information in properly listed manner as shown in figure 3. For every student, in gadget sheet marks are generated considering any ordinance applicable to his/her case and grades are generated accordingly for each student.

VIII.Conclusion

We have automated the examination system for generating the gadget sheet and marksheet of the students. In project phase I of semester VII, we have stated that the project facilitates the provision of safe, authenticated and web based system and also automated marksheet generating for grading system and storage and will directly provide the result in form of PDF.

We saw how the existing systems had their own disadvantages as they could be tampered with and once the marksheets were lost, it was difficult to generate new ones.

The rule is given below:

Fig. 3. Screen shot of the implemented gadget sheet.

The Marksheet Generation System aims at developing a mark sheet generation system that will automate the distribution of digitally verifiable student result mark sheets by generating mark sheets in Portable Document Format which very difficult to modify.

This system makes use of the following software is made using very basic programming languages and includes:

• •    PHP: as server-side scripting language.

• •    SQL: as database language.

• •    HTML: at front end.

We have completed the implementation and work of the following factors:

• •    We have generated the gadget sheet by automated fetching of marks of the students from database.

• •    Calculation of the grades, credits, grade points of each courses and Grade Performance Index of whole semester considering all the courses.

• •    Also determined the calculations for verification and evaluation of marks for special cases (ordinances for grace marks in case of failure as per the university rules).

• •    We have generated Grade Performance Index (GPI) which depicts the final result of the students in particular semester in terms of pointers.

• •    Display of Final Performance of the student in terms of Pass/Fail.

• •    Generation of marksheet for individual student for particular semester by fetching data from database and calculating the credits, grades, grade points, grade performance index and final result in terms of pass/fail.

Marksheet is authorized certificate which is consisting of his/her marks for showing progress in respective semester. In our project, mark sheet can be extracted in a PDF which is exclusive feature of our project as shown in Figure 4.

The system automated and generalized the system ensures to reduce manual error by reducing manual efforts. An added asset to the feature of the system is that aims at improving and easing out the work of existing system in very sophisticated way. Also, this system is faster than the earlier methods of manually feeding, calculating and cross-checking the marks.

As this is a web-based system, it can provide services over the Internet on an On-Demand basis, thus making it more accessible. In future the system has sufficient adaptability to couple itself with the already existing mark sheet generation system systems. Also, there will be scope for integrating the report generation technology with this system.

The software is flexible enough to be modified and implemented as per future requirements. The system can be made more secure by providing various security features at different levels. It can also be applied at University level to store results of thousands of students without any glitches and is reliable.

Acknowledgement

It has been a sincere desire of every individual to get an opportunity to express his views, skills, attitude and talent in which he is proficient so as to give him satisfaction and confidence in his ability to do or produce something useful for mankind. A Paper is one such avenue through which an engineer gives vent to his feelings and expressions. We take this opportunity to express our gratitude towards our internal guide Dr. K.T.V. Reddy, without the motivation and guidance of whom we would have found it difficult to maintain the tempo and enthusiasm. Working with him has been a wonderful learning experience.

We would like to express our deepest gratitude to Exam section staff of PVPPCOE for their encouragement, suggestions and guidance which was instrumental in completing the Paper. We also thank college authorities and professors concerned, who have through meticulous planning, created a comfortable co-existence of the paper and college schedules.

University of Mumbai

PADMBHUSHAN VASAMDADA PATIL PRATISHTHANS COLLEGE OF ENGINEERING

SKMA-HUNABHATn, MUMBAI -И002-

GRADE CARD

NAME:        AMAN T

EXAMINATION:	SECOND YEAR ENGINEERING
HELD IN:	DECEMBER 2013
SEAT NUMBER:	1001                            REGISTRATION NO: 234567

Code	Course Title	Credits	Grade			Credit |С)	Grade Points (G)	ex G
			E	1	о
SELC 101	APPLIED MATHEMATICS III	4	P	о	D	4	6	24
		I	■■	о	о	1	10	10
SELC102	DATA STRUCTURE & ALGORITHM ANALYSIS	4	C	о	в	4	8	32
		I	О	о	о	1	10	10
SELC 103	OBJECT ORIENTED PROGRAMMING METHODOLOGY	4	c	о	в	4	8	32
		I	о	о	о	1	10	10
SELC 104	ANALOG AND DIGITAL CIRCUIT	4	c	о	в	4	8	32
		I	о	о	о	I	10	10
SELC 105	DATABASE MANAGEMENT SYSTEM	3	c	о	в	3	8	24
		1	о	о	о	1	10	10
SELC 106	PRINCIPLES OF ANALOG A DIGITAL COMMUNICATION	3	c	о	в	3	8	24
		I	о	о	о	1	10	10
Total		28				28	-	228

Rcttark:pa»          SGPI:*.142H57I428571       CGP1AI42857142857I

Results Declared On:

March 21,2014

PRINCIPAL

Fig. 4. Screen shot of Marksheet PDF