MID PROJECT EVALUATION

ACADEMIC YEAR 2011/2012

PROJECT : Staff Workload Management System

GROUP NO : 10

OBJECTIVES:1. To increase effectiveness of the current

manual staff workload management system

2. To manage the management activities easily & clashes in process will be minimized

3. To gain a clear idea about each & every staff members’ workload

4. To measure the productivity of the staff members easily.

MAIN FUNCTIONS:

Head Of the Department 1. Facilitating HOD to assign lectures & practical for staff

members such as lecturers, academic supportive staff technicians, demonstrators, instructors through this system.

2. Assigning extra workload such as meetings, seminars, committee participations, consultancy, examination duties, researches, workshops etc by studying pre-assigned workload.

3. Retrieving individual reports of each staff member within a given time period. The report includes total lecture hours or practical hours worked, hours allocated for extra work & the weight of entire workload.

Staff Members4. Every staff member is able to view own profile with his/her

workload.

DATABASE STRUCTUREDATABASE NAME : CS2012G10

Table Name : Personal

Table Name : Workload

We add a foreign key constraint to the personalID field of workload table with the personalID of personal table.

Name PersonalID

Designation

Password

Varchar(35)Not null

Varchar(10)Primary key

Varchar(30)Not null

Varchar(10)Not null

Type Course_Unit

Date

Start_Time

End_Time

PersonalID

Comments

Varchar(10)not null

Varchar(10) DateNot null

Timestampnot null

Timestampnot null

Varchar(10)Not null

Varchar(30)

SOFTWARE USED1. Apache - Server

2. MySQL - For database management

3. HTML - For web page creating / designing

4. PHP - For server side scripting

5. CSS - For web page designing

6. JavaScript

Week No

Task

1 2 3 4 5 6 7 8 9 10

Requirements gathering & analysis

Proposal writing

Coding the main pages

Linking all pages

Run the whole web site & testing

Adding additional pages & features

Interface designing

Integration & troubleshooting

Report writing

TIME LINE

CONTRIBUTION OF EACH GROUP MEMBERS

SC/2009/7290 (Amadoru T)

1. Creating forms for assigning workload

2. Management of workload assigning.

SC/2009/7322 (N.P.Waidyarathna)

1. Creation of profile pages

2. Displaying regarded time tables

SC/2009/7269 (K.P.T.B.P.Kariyawasam)

1. Creating tables which included workload for each person

SC/2009/7229 (J.A.M.Lakmal)

1. Creation of login page & signup page including validation

SC/2009/7201 (D.G.A.Weerasinghe)

1. Evaluating workload2. Creating form of

generating reports