Educational Spatial Decision Support System (ESDSS) for the Education Department of Khyber Pakhtunkhwa
The Educational Spatial Decision Support System (ESDSS) assists decision-makers by providing evidence-based, accurate information through GIS tools, which smooths the decision-making process. The ESDSS delivers reports and analytical insights to users and stakeholders while providing the necessary interfaces for data entry and approval.
Additionally, the system generates printed reports for the Education Department of Khyber Pakhtunkhwa. This Software Design Specification (SDS) details the functional design of the ESDSS. Furthermore, the document outlines the system architecture and its components, focusing primarily on the design of the census form.
By integrating spatial data with administrative records, the ESDSS empowers officials to identify geographical gaps in educational resources and allocate funding more equitably. Furthermore, the system’s automated validation rules ensure high data integrity and reduce the discrepancies typically found in manual census reporting.
Windows Application
. e-strats developed this Windows Application using WPF and C# within the .NET 4.0 framework. The system features a modern interface and utilizes a local SQLite database for temporary offline storage. Upon the first launch, the application syncs with the web server. It fetches essential control and lookup tables to support the census process.
The system features a critical background data sync process that operates without requiring user interaction. This component periodically monitors network availibility and initiates synchronization whenever the internet is restored. It validatesdata, ensures guaranteed delivery, and updates the central SQL Server data via WCF REST services. While the system performs most tasks automatically, it also provides a manual sync option for users who wish to trigger an immediate update.
The project deploys the application using Microsoft ClickOnce technology, which simplifies installation and enables self-updating capabilities. This deployment method allows non-administrative users to install the software and ensures that each application is self-contained to avoid versioning conflicts with other programs. Furthermore, ClickOnce manages updates automatically by downloading only the modified parts of the application and prompting users to update the next time they launch the software.