We have already design and implement the roadsigns application. Some major changes need to be done in order to improve the scope of this software. We need to create a new table in the database to store the students details and progress in the software. The user should now be able to login and be recognized from the system.
Add new student page
From this page we add to the database a new student (see Students DB Table. Students
The records include:
Licence Category: Drop down menu for categories (A, A1, B, C, D, D+E)
Place of Birth:
Date of Birth:
ID Card No:
Glasses: Drop Down Menu for YES/NO
Add Picture: Upload picture from file/capture from webcam.
View/ Edit Student Details Page
Administration should be able to login and view/edit student details and print three predefined forms in A4 Pages.
Form 1) &#917;&#926;&#927;&#933;&#931;&#921;&#927;&#916;&#927;&#932;&#919;&#931;&#919;
Form 2) &#933;&#928;&#917;&#933;&#920;&#933;&#925;&#919; &#916;&#919;&#923;&#937;&#931;&#919;
Form 3) &#937;&#929;&#917;&#931; &#917;&#922;&#928;&#913;&#921;&#916;&#917;&#933;&#931;&#919;&#931;
Form 4) &#935;&#913;&#929;&#932;&#913;&#922;&#921; &#915;&#921;&#913;&#932;&#929;&#927;&#933;
These forms have the user details printed. The forms are 4 because each form has more or less details according to each use. More details about these forms in a later description.
LicenseCategory in students table defines the type of license (car, motorcycle truc etc.) According to the LicenseCategory field in students database the adequate buttons will be available in the main menu. If user belongs to A or A1 category then cars and motorcycles buttons only will be available. If user belongs to B category then only cars button will be available. If user belong to C category then only trucks button will be available. And if user belong to D category only buses button will be available.
When the user is logged in the software is navigated to the main page and a message appears to the top (Hello, (name) your last login was (Last login Date).
User can only visit STUDY mode. The TEST mode will be disabled (grey) and will only be available when training in STUDY mode is completed (all units) and then the TEST button will be available and colored.
Study mode categories in cars used to be 6. From now on will be only 5. Changes described below will be done for all categories and all vehicles (motorcycles, cars etc).
From these 5 categories the application should remember the student’s progress from last login and questions completed. If user has stopped studying in the last login in category 2 and question 55, the software should ask him to continue from there or start from the beginning of category 2 to repeat the questions.
For example motorcycles study mode has 9 categories. If user stoped in category 8 question 4 last time should be able to resume from there or start category 8 from the beginning. The same should happen for trucks cars and buses
Every time the user clicks the wrong button in a question, this question is stored using QBook field in the database in a table called wrong answers (that will include studentID) and these questions will be repeated in the end of every category. The user should be able to print a results page that incudes only wrong answers using the QBook Field. When all categories in study mode are completed, a review test should be available. The review test will be a study mode but will include only the questions with wrong answers from the past using the wrong answers table.