Information-analytical system for collecting and processing of the state statistical reporting
Customer: Chief Information Analysis Center of the Ministry of Education of the Republic of Belarus Software type: window application Software sub type: the program for collecting and processing of statistical data Efforts: 11 man-months Technologies used: Visual C#, SQL This project is developed for collecting and processing statistical reports, and for the formation of a summary reporting on collected data. The form, in which the reporting data is provided, has the form of spreadsheets. Editing occurs in the visual editor, which supports standard features: merge cells, alignment of values, add/delete rows/columns. For simplification of the calculation of intermediate and final data, there is the module of calculation of formulas. It is possible to specify the rules according to which the primary report must be filled. If any of these rules are not met, then a report is not sent to the server for processing. Sent reports are stored on the server. Subsequently, it is possible to generate various summary reports. While forming a summary report there is an opportunity to apply a filter to the existing reports on the server. It is also possible to print any report or to export it to Excel format. The program has distributed access, i.e. the various functions of the program will be available to the user depending on the type of user and his regional affiliation. Records which are stored on the server also are filtered by access rights. For example, if a user from the Minsk region, then only reports from the Minsk region will be available for him.