School Assist

Until recent times, school staff used computers for checking their timetable, reading messages and taking attendance of class. By utilising the capabilities of the AGP, the Java Database Connectivity (JDBC), SQL and java applications we can now provide a significant amount of functionality for school staff on the optiPoint phones via the DSM or APM. However this application can be extended in future to include features like event calendar, contact details of students and staff,to broadcast news/alerts etc.

file=SchoolAssitn.swf|width=720|height=560|scale=exactfit|quality=best|bgcolor=#ffffff Click on image to view slideshow!

Operation


Operational Overview:
 * School Assist application on the phone interacts with the server using XML. The server provides XML to the phone which the application renders into a screen for the user to interact with. The user’s interaction with the phone results in key-value pairs being passed back to the server for processing.
 * Java Application connects to database using JDBC (Java Database Connectivity).
 * Java Application then uses SQL to query /update the database on the server.
 * In turn database returns the results in the form of result-set.
 * Java Application processes this result-set and constructs an appropriate XML page for IP Phone.

Key Features
School Staff can view their own timetable along with details like start time, room number, class, subject etc. It enables staff member to view messages sent to them regarding various aspects of school. It allows staff member to take attendance of a class and update's attendance of particular class for specified subject on the school's database.
 * View Timetable
 * View Messages
 * Take Attendance Of Class