CBT Exams using Third Parties

From ATI Chennai IT and ITES Wiki

Jump to: navigation, search


Data sizing and notes

  • Students taking exam: ~24 Lakhs
  • DB size for plain text of 1K per record: 24 Lakh x 1 K = 2400 x 1000 x 1000 = 2.4 GB
  • Index(es) size will be generally upto 15% of above
  • Lookup data are not considered as they will be miniscule
  • Photos at 80KB per student = 2.4 GB x 50 = 192 GB

Photo Notes

Proposed SoP by TT Cell


  • NCVT MIS Portal - WIPRO
  • DGT Server - Govt
  • NPIU TT Cell
  • SPIU - Data Entry Responsibility from each institution
  • CBT Test Agency

Proposed Work to be contracted out to Exam Agency

  • Student Details taken in bulk from NCVT MIS Portal (WIPRO) through the DGT Server through FTP
  • Exam Eligibility upload, Exam Centre choice, Hall Ticket download to be managed by various institutes online entering into NCVT MIS (WIPRO) Portal
  • Exam Fee to be paid into Agency's Portal
  • Hall Ticket to be downloadable from Agency's Portal
  • Records from NCVT MIS Portal first go into DGT Server (why??) from where it is transmitted to the Agency's Server - this needs to be updated from time to time to account for new records - changes mitigation is another issue too.
  • Fields to be provided by WIPRO into DGT Server for use by Exam Portal Server:
Trainee Name
Reg No (Unique Key)
ITI Code
ITI District
Father's Name
Trade Name
Yr 1/2 or Sem 1/2/3/4
Subject Type - Theory, ED, Practical
EMail ID
Mobile Number

DOB field is missing

Suggested SoP by IT Cell

  • Avoid Data transfer and synchronisation
  • Data pertaining to large volume photos and sensitive personal data can be retained in the WIPRO's NCVT MIS Server itself
  • No need for data interchange using CSV, etc.
  • Use encrypted / password protected APIs where necessary on the intranet with IP and record-field restrictions

The above will make for real time data visualisation and operation


  • NPIU/SPIU logs into NCVTMIS portal and enters
    • Student Photograph already in NCVT MIS Server at time of registration of student in the course
    • Exam Eligibility
    • Exam Centre Choice
    • ED and Practicals Marks (WIPRO Excel Template)
  • Hall Ticket Download from NCVTMIS Portal:
    • NPIU
    • SPIU for their own records
    • Student - own record only
  • Reports pertaining to records
    • processed
    • updated
    • rejected with reason
  • Record Redundancies across Marks Templates uploaded
    • Same student, different subjects - Append
    • Same Student, Same Subject - Use later data, voiding earlier ones with overwrite count

CBT Exam Agency Interfacing

  • Exam Portal
  • Login for users:
    • NPIU
    • SPIU
    • Centre HOD
    • Invigilator
    • Student
  • Exam Process
    • Student logs in for taking the exam and submits for evaluation
    • Invigilator locks the submission
    • Centre HOD authorises their data for processing
    • Exam Portal auto processes the result
    • Exam Portal sends data with NCVT MIS Portal through encrypted / password protected API

Bullet Proof Zero Sharing SoP

  • Exam Portal is given the Questions and Answer Keys by NPIU TT Cell
  • Exam Portal provides for Porteus / Web Converger like Browser only RAM based appliance to run on any PC / Mobile
  • Student logs into NCVT MIS Portal and clicks the Exam Subject Link available for the student for that date and time and place.
  • The link takes the student to the Exam Portal with the Student-Subject Dummy Number (Unique, mapped to RegNo-SubjectCode) information whilst logging out from the NCVT Portal and logging into the Exam Portal's specific session
  • On completion of the exam, all exam related answers and other pertinent info are automatically sent to a processing script that does the following:
    • Populate the Exam Portal's DB
    • Populate the NCVT MIS / DGT Server DBs (Open Loop)
    • Update the Exam Portal's DB with the status of data sent to NCVT MIS / DGT Servers if available - small timeout to avoid server crashes - later synching for missed ones.
    • This connection to external servers should be IP, record and time restricted.
Personal tools