Application title: UEW Admission Checker

Purpose: The UEW Admission Checker desktop application will determine the eligibility of an

applicant for their chosen programme of study.

Program Procedures: The administrator adds programmes and their respective cut-off grades for

male and female per programme. Applicants can select “Check Eligibility” button from the dashboard

and proceed.

Algorithms, Processing, and Conditions:

1. Program starts with a dashboard which has 2 buttons namely “Check Eligibility” and “View

Cut Off Points” and a link label “Login” that opens a Login form.

2. On the “Check Eligibility” form, the applicant must select from a drop-down control the

following programmes (General Science, Business Administration, General Arts).

3. For each option selected, the applicant must be able to enter their results based on the

subjects specific to the choice. Also, the applicant must be able to enter their name (first

name, last name), Date of Birth, Gender, Name of previous school. The “Check” button on this

form must be inactive until the applicant enters all required fields.

4. After clicking “Check” the program should calculate the applicant’s grade, verify if they qualify

for admission for the selected programmed and display a message to that effect. The details

of the applicant should be saved in a table “Applicants” and the “Qualified” column of the

table should be “Yes”. For unsuccessful applicants the data should be saved into the same

table and “No” saved into the “Qualified” column.

5. The “View Cut Off Points” button should open a form where the programmes already keyed

in by the Administrator should be displayed to the user.

6. The “Login” link label should open a Login form. This should allow the Administrator to Login

7. The “Cut Off Point” form should be displayed upon successful login.

8. Report of qualified and unqualified applicants should be generated by clicking “Generate

Report” button on the “Cut Off Point” form with the details (Applicant Name, Gender, Chosen

Program, Aggregate)

Notes and Restrictions:

1. The applicant should be able to click an exit button to close the application.

2. The grades entered by the applicant are not saved into the database.

Comments:

The designer must determine the design of the user interface, the words and graphics used in the

user interface.

Additional creativity will attract some marks

Comments: The designer must determine the design of the user interface, the words and graphics used in the user interface. Additional creativity will attract some marks Tables Cut Off Point Column ProgID ProgName MaleCut Off FemaleCutOff Login Table Column UserID Username Password Applicants Column ApplicantID FirstName LastName Gender DoB LastName PrevSchool PrevProg Chosen Prog Aggregate Qualified DateTime Forms 1. Login 2. Applicants 3. Cut Off Point Datatype Integer String Integer Integer Datatype Autolncrement String VarChar Datatype Autolncrement String String String Date String String String String Integer Boolean. DateTime