Development of a Database for Electronically Supported Examination - PowerPoint PPT Presentation

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Development of a Database for Electronically Supported Examination Jonas Andre April 27, 2016 Chair of Network Architectures and Services Department of Informatics Technical University of Munich

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Motivation TUMexam • scanning of written examinations • generating result files TUMonline • download registration files • upload of examination results • just minimal examination statistics in TUMonline Jonas Andre – TUMexam 2

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Database Requirements • import of students data from different sources registration • handling different course components (midterm, bonus, assignments, endterm) • storage and updates of exam results calculation • calculation of grades with bonus Approach • PostgreSQL database for each course export • bash script inserting data from .csv files • main output tumonline.csv for grade upload Jonas Andre – TUMexam 3

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Database scheme matrikel , name , email matrikel , examID , examinationID examID , examinationID , problemID , pass , credits 1 n students examination2student result n m n n 1 1 1 examinationID , bonusID examination problem n problem , subproblem , examinationID , maxCredits n 1 m 0..1 bonus gradetable bonusType , examinationID examinationID , credits , grade Jonas Andre – TUMexam 4

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Web application Requirements • import of registration • import of exam results from scan application • correction of scan errors and update of results • export of results ready for import into TUMonline • graphical statistics • display of specific pages, problems, or subproblems Approach • webserver for database connection ( python flask ) • statistics visualization ( D3.js ) Jonas Andre – TUMexam 5

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Evaluation Already in use • ACN (116+43 exam registrations) • NetSec (181+66 exam registrations) • GRNVS (>800 lecture registration) • ITSec, Schaltungstechnik 2 (Electrical Engineering) Current work • interactive statistics for web application • replacement of bash script with web frontend Jonas Andre – TUMexam 6

Chair of Network Architectures and Services Department of Informatics Technical University of Munich Jonas Andre – TUMexam 7