**Work statement: Adding a 'Careers' link to an existing web-site**
* On clicking 'Careers' link, the user is directed to a page which
lists the available vacancies. With each job vacancy, a brief profile
of the job listed, qualifying requirements and a button to 'Submit
Candidate Details'.
* On clicking 'Submit Candidate Details', the user is directed to
a form-based
webpage wherein the following information is required to be entered:
1. Contact information of candidate:
-
2. Education:
3. Experience
* All these are to be entered in a database with one row for each
student
* Add a feature to enter the characters and letters seen on the page into a box . This is to eliminate hackers to enter random data
* Add " Data protection and confidentiality agreement " clause and users have to review and agree the terms before proceeding further.
* Admin page for 'Career': Entered with Username & Password
authentication
v
Based on the combination of the above criteria, the
list of suitable candidates should be generated from the database and
presented as a list.
A button to 'Email List' to be provided
## Deliverables
**Data base : MS access 2003**
**Work statement: Adding a 'Careers' link to an existing web-site with
the following
requirements:**
* On clicking 'Careers' link, the user is directed to a page which
lists
the available vacancies. With each job vacancy, a brief profile
of the
job listed, qualifying requirements and a button to 'Submit
Candidate Details'.
* On clicking 'Submit Candidate Details', the user is directed to
a form-based
webpage wherein the following information is required to be entered:
1. Contact information of candidate:
- Name, Phone no., Address, E-mail address, Preferred
time of contact.
(All the fields are text boxes)
2. Education:
* Graduation:
- Degree: list box with the following options:
B.E. CSE
B.E. ECE
B.E. EEE
B.E. Instrumentation
B.E. EIE
M.E. (for this a text box should appear for
the user to enter branch)
- Year of Passing: list box with the following options:
2007 or earlier
2008
2009
2010
- Percentage: textbox in which the user can enter a value
(validation to be performed - should be a
number -
floating point or integer)
- College and University : text box
- Place: textbox
* HSc / +2 / PUC:
- Year of Passing: list box with the following options:
2003 or earlier
2004
2005
2006
- Percentage: textbox in which the user can enter a value
(validation to be performed - should be a
number -
floating point or integer)
- College / School : text box
- Place: textbox
* SSLC / 10th / Matriculation:
- Year of Passing: list box with the following options:
2001 or earlier
2002
2003
2004
by using a
- Percentage: textbox in which the user can enter a value
(validation to be performed - should be a
number -
floating point or integer)
- School : text box
- Place: textbox
* All these are to be entered in a database with one row for each
student
* Admin page for 'Career': Entered with Username & Password
authentication
- Option to change password also to be provided
- Job details: Provide text boxes for the following:
Job title, job description, qualifying requirements
Options to enter multiple such jobs should be
possible.
This detail is what is displayed to the candidate
when
clicking on 'Careers'.
Option to say 'No current vacancies' should also
be present
For this no jobs are listed in the 'Careers' link
page.
- Following filter options to be provided for searching
the database:
* Job applied for
* Year of passing (single or multiple selections
should be allowed)
* Percentage: list box with the following options:
All
> 75
> 70
> 65
* BE with branch selection
* HSC and SSLC percentage:
All
> 90
> 80
> 70
Based on the combination of the above criteria, the
list of suitable
candidates should be generated from the database and
presented as a list.
A button to 'Email List' to be provided which
generates an Excel sheet
containing all candidate details(contact info, degree,
HSc and SSLC details)
to be generated and e-mailed to user entered e-mail
address (text box to
provided for this).
* Facility to purge the database entries by job or degree, all
entries etc.