AUTOMATION OF STUDENTS’ PROGRESS RATING REGISTRATION
The set of applications for the automatic registry university system of students’ progress rating is considered. The hundred-point and ECTS grading scales are used. The students’ progress rating takes into account both subjective estimations and formal control of delivery terms, parameters of quality of tasks performance as well as absence from classes. The traditional typical learning paths are presented. The rating calculating algorithms produce “fair” estimations for these traditional typical learning paths. The technological, organizational and psychological means inculcations control automation ‘from above’ and ‘from below’ are discussed. The set of compatible applications for decentralized system is proposed. The applications can use varied data sources: MySQL server DBs, web-server with its own APIs, SQLite local DBs and files with particular group-theme rating data. Variety of sources implements two work regimes with DB for teachers: multiple access in share regime (if DB-hosting or web-hosting is available); teacher’s access to local DB and sharing rating data files for local access and periodic timing of files with DB (if hosting is not available). All applications have multilayer architecture with shared program Java-code for all server and client applications. The architecture consists of the conception layer, business logic controller, business logic model, tools for extraction and linkage of DB table business objects, binary and XML converters for business objects, support of DB table objects, JDBC and SQLite library interfaces, web-service server components. The system provides two kinds of authorization: according to its own logins/passwords storing in DB and according to university informatization centre logins/passwords. Every DB provides repository for temporary document storage and change. Repository is an area of data limited capacity. The system includes six main components and applications. The DB server (MySQL) with remote Java-clients’ standard network access means (using JDBC libraries). The web-server with own APIs and supporting all levels of business logic. Client applications work with web-server in “thin client” mode. Client application “Manager” provides all manager functions except for DB MySQL direct hosting: editing of data source list, connecting to DB, DB initialization, DB backup, editing of rating structure, maintaining of teacher accounts. Client application “Teacher” provides editing of data source list, connecting to DB and authorization, editing of rating structure, making pdf, html and window application reports, uploading, loading and viewing of repository files, making files - copies of rating data and timing file-copies with DB-source. Android-application “Teacher” has similar functionality with some limitations. Teacher’s client applications can work with all data sources: in the regime of web-server and server DB multi-access mode and local DB and rating data file-copy off-line editing. Client applications “Student” is intended for student’s rating data viewing and for files uploading into repository. In conclusion the system integration possibilities with university informatization centre are discussed.
Keywords
успеваемость, рейтинг, автоматизация, Android, desktop, Java, база данных, MySQL, progress, rating, automation, Android, desktop, Java, database (DB), MySQLAuthors
Name | Organization | |
Romanov E.L. | Novosibirsk State Technical University, Novosibirsk, Russia | romanow@vt.cs.nstu.ru. romanow@ngs.ru |
References

AUTOMATION OF STUDENTS’ PROGRESS RATING REGISTRATION | Open and distance education. 2014. № 2 (54).