Saving Nationwide University Admission Campaign

Business Challenge 

A legacy EIT system, developed by a different company, had major performance and security flaws, making it impossible to use it further. Thus, the EIT had to be rebuilt and redesigned. Timeframes were of extreme importance, as the entire graduation campaign 2016 could fail. Only a few months were left to launch a modern, secure and productive system to make the graduation and admission campaigns possible. 

The EIT project required a comprehensive approach to design, development, implementation, support, and maintenance of the system, as well as the high level of security and protection against cyberattacks, along with the deep analysis of the legislative and procedural frameworks. The system had to support thousands of simultaneous connections and needed to facilitate the process continuity during admission campaign. One of the most important challenges was to implement, test and launch the system before the start of the admission campaign. 

Solution  

EIT Solution 

The updated External Testing system provides the following functions: 

  • Anonymized registration of the testing participants in the system  
  • Encrypted processing of application forms filed by school graduates  
  • Automated generation of documents for all testing participants and testing centers  
  • Automated tests processing  
  • Summary of the testing results across the country, etc.  

Some of the aforementioned EIT system functions are accessible online for the graduates or school representatives (Example 1, Example 2), while access to other backend features is available to specific User Groups only (e.g., UCEQA employees, school graduation campaign specialists, etc.). 

Some parts of the system were launched only 1 month after we started our work on the project, to allow graduates to register on the system. A number of other modules and parts of the system were launched right before the start of the testing campaign (just 3-5 months after we started our work). In total, the EIT system was actively developed for 9 months, with all preparatory and maintenance work taking up to 13 months. 

  • We suggested migrating the Database from MS SQL to Oracle DB as it allowed to harmonize the technology stack, review and clean up the entire backend code, and get rid of the unnecessary junk, bringing increased security and performance 
  • Established a high-level protection against DDoS attacks 
  • Our approach to system architecture design enabled horizontal scalability of the system, improving its reliability and performance 
  • Conducted updates to the network and server architecture 
  • Optimized back-office system and website source code.  

Currently, the system is able to withstand a significant number of concurrent users. 

In 2016, the EIT system was tested to ensure appropriate performance during periods of the sharp increase in the concurrent connections: 

  • 270,000 frontend users  
  • Up to 450 backend users  
  • Up to 20-30,000 requests per day during External Testing registration  
  • Up to 100-150,000 transactions per day after the publishing of the external testing results.  

Technologies used: 

  • EIT Frontend: CentOS, Nginx, MVC – Laravel, jQuery, MySQL, and PHP.  
  • EIT Backend: MS SQL / Oracle DB and Delphi.  

Technologies & Tools 

  • Azure App Service 
  • Azure App Service Environment 
  • Azure DevOps 
  • Azure Application Gateway 
  • Azure SQL Managed Instance 
  • Azure Monitor 
  • Azure SQL Database 
  • Azure API Management Gateway 
  • Azure Automation 

“My ZNO” Mobile Application 

Our next step to support UCEQA was to develop an official EIT mobile app for the testing participants. 

“MY ZNO” mobile app brings a simplified anytime-anywhere access to personalized testing schedule and results on handheld devices to the testing participants. 

The app offers a number of features, as listed below: 

  • Exams schedule in selected subjects and addresses of the External Testing Centers. 
  • Personalized results of External Testing. 
  • Reminders, push notifications and synchronization of the exams schedule with the system calendar. 
  • Option to view the previous year’s testing results. 

Due to the specific nature of the data, a personal certificate number and a PIN-code are required to access the above-listed app features. The app connects to the UCEQA database and requires an internet connection. At the same time, third parties don’t have access to the personal data of the testing participants. Upon establishing the connection with the server, the user’s personal data is stored on a user’s device and is accessible offline. 

In 2019, the number of active installs for Android and iOS platforms peaked at 170.000+ downloads, as in this year alone “My ZNO” app was downloaded by more than half of all external testing participants. 

Technologies 

Android Frontend: Dagger2, Butterknife, Retrofit2, RxJava/RxAndroid/RxBinding, JWT 

iOS Frontend: Swift, MVVM, Moya, RESTful, QuickLook 

Backend: PHP, Laravel, MySQL database, GCM, Nginx web server, Google Cloud Messages 

“My ZNO” app was available to all testing participants as a free download via Google Play Market and iOS App Store. 

Business Value 

Tietoevry Create Ukraine (formerly Infopulse) saved the nationwide admission campaign in Ukraine by meeting all regulatory requirements. 

UCEQA has successfully conducted the External Testing Campaign without a hitch. The 300 thousand external testing participants (school graduates and future students) were able to register for the external testing and complete all graduation exams on time. This allowed the students to receive and submit the results of their exams for the admission to colleges and universities. 

We ensured stability, performance, and durability of the system during peak loads, improving personal data protection, and fully maintaining all cybersecurity aspects. The EIT system has been certified to comply with modern information security requirements as we, together with partners, implemented multiple layers of cybersecurity protection and improved personal data protection, fully maintaining all cybersecurity aspects. This allowed encrypting and isolating executable code data, which ensures the highest levels of data security. 

We provided all required actions and operations, meeting tight deadlines determined by the government regulations and a strict due date of the admission campaign. 

Facts & Figures 

  • 270,00 front-end users 
  • 450 backend users 
  • ≈30,000 requests per day 
  • ≈150,000 transactions per day 

The results of the UCEQA and Infopulse (now Tietoevry Create Ukraine) collaboration in development and implementation of the External Independent Testing 2016 are very productive. In 2016, for the first time, the certificates with the results of the state final academic assessment were sent to educational institutions in pure digital form only. The certificates’ data integrity and consistency were confirmed with the digital signature. We strongly believe that ET Campaign 2016 was our mutual success.  

- Vadym Karandiy, Director at the Ukrainian Center for Educational Quality Assessment 

 

Share on Facebook Share on Threads Share on LinkedIn