Applicant Reports

The goal of this task is to generate reports regarding applicants data required for admission process. The list of male and female students separately, list that contains the contact number, email, mailing address, the students date wise form submission, the list of verified students for admission test, list of students of each room regarding admission test seating plan, the final status reports not eligible for admission based on 2nd year marks, those who are eligible but not come up to merit, the students who are eligible for enrollment in department but cannot submitted their dues, and the list of those students who submitted their dues and get enrolled in department.
These are explained below:

  • All Students Enrolled for Admission Test:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the All Student Enrolled for Admission Test  report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

ALL STUDENTS OF ADMISSIN TEST

  •  List of Male/Female Applicants:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the List of Male and Female Applicants report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

LIST OF MALE AND FEMALE STUDENTS

  • List of Verified students for Admission Test:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the List of verified Students for Admission Test report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

LIST OF VERIFIED STUDENTS

  • Date wise Admission Form Submission:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Date wise Submission of Admission Form report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

DATE WISE FORM SUBMISSION REPORT

  • List of Students in Each Room(Seating Plan for Admission Test):

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Room wise List of Students for Admission Test  report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

ROOM WISE LIST OF STUDENTS

  • Final Status Of Students:

The final status report contain four type of status, not eligible for admission based on 2nd year marks, those who are eligible but not come up to merit, the students who are eligible for enrollment in department but cannot submitted their dues, and the list of those students who submitted their dues and get enrolled in department. First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Final Status of the Students report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

FINAL STATUS REPORT OF STUDENTS

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicants that are enrolled for admission test.

sequence_applicant reports

Here is the Database script of table that is required for these reports.

Applicant and Test Venue