COMPUTERED GRADUATION FORM Performers Ofir Medlinsky Ahmad Hamdan

COMPUTERED GRADUATION FORM Performers: Ofir Medlinsky Ahmad Hamdan GF Instructor: Victor Kulikov 1 SOFTWARE SYSTEM LABORATORY

Targets l l l 2 Replace the current graduation form submission build an automated web application tool Reduce secretary effort and mistakes on reviewing submitted form Reduce student submission time Serve as course planner for students SOFTWARE SYSTEM LABORATORY

Benefits Developing web application l Improving OOP skills l Improving GUI skills l Cope with “real life” chalange l 3 SOFTWARE SYSTEM LABORATORY

System description l l l 4 Online web application Secretary can add, remove and update tracks and tracks information Student can plan his progress effectively from first semester System validate form “on place” Intuitive and friendly user tabled data SOFTWARE SYSTEM LABORATORY

Implementation l Can be divided into two main categories – The web application – The validation algorithm 5 SOFTWARE SYSTEM LABORATORY

The web application l Implemented in several layers – – Database DAL (Typed Data Sets) BLL Presentation layer BLL 6 SQL SOFTWARE SYSTEM LABORATORY

The web application There are two pages groups l Divided by permission level l – Secretary pages – Student pages 7 SOFTWARE SYSTEM LABORATORY

The student pages l l l 8 Table for each category Table is initialize with student’s track info Adding course to table is enabled Student can select/deselect course in each category “my courses” button to load the student credit courses from DB SOFTWARE SYSTEM LABORATORY

The student pages “validate” button to run the algorithm on selected courses l Boolean acknowledge l – Green passed – Red failed Upon failure, a detailed table with required courses (suggestion) is created l Selecting courses from new table and validate. l 9 SOFTWARE SYSTEM LABORATORY

The validation algorithm Student can fill categorized tables l When pressing the validate button, the data is read into hash table l The data is being validate by checking each category requirement l A detailed (tabled) report is printed after validation l 10 SOFTWARE SYSTEM LABORATORY

Algorithm data base _my_courses Hash table Mandatory courses Core courses Chain courses (by chain name) Courses with no pre courses Courses their coupled already considered Courses from other faculties Courses marked as faculty choice Courses marked as free choice 11 SOFTWARE SYSTEM LABORATORY

The secretary pages Data is arranged in nested tables. l Allowing easy and intuitive manipulation l – Add, remove and update l 12 Editing with sub tables SOFTWARE SYSTEM LABORATORY

The secretary pages Track manipulation: Define requirements l Define courses by categories l Courses manipulation: Already in track orientation l Data is relevant by category l Defines courses relation l 13 SOFTWARE SYSTEM LABORATORY

Development environment C#. NET – web application – Typed Data. Sets l SQL server and store procedure l 14 SOFTWARE SYSTEM LABORATORY

SQL data base 15 SOFTWARE SYSTEM LABORATORY

Future development Adding other faculty’s forms l Gather student statistics l Validate the system for “real” use l 16 SOFTWARE SYSTEM LABORATORY

17 SOFTWARE SYSTEM LABORATORY