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

▶

Jan 03, 2023 336 likes •422 views

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

SLIDE 1

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

SLIDE 2

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

SLIDE 3

Chair of Network Architectures and Services Department of Informatics Technical University of Munich

Database

Requirements

import of students data from different sources
handling different course components

(midterm, bonus, assignments, endterm)

storage and updates of exam results
calculation of grades with bonus

Approach

PostgreSQL database for each course
bash script inserting data from .csv files
main output tumonline.csv for grade upload

registration calculation export

Jonas Andre – TUMexam 3

SLIDE 4

Chair of Network Architectures and Services Department of Informatics Technical University of Munich

Database scheme

students

matrikel, name, email

examination2student

matrikel, examID, examinationID

result

examID, examinationID, problemID, pass, credits

examination

examinationID, bonusID

problem

problem, subproblem, examinationID, maxCredits

bonus

bonusType, examinationID

gradetable

examinationID, credits, grade 1 n n m n 1 n 1 1 n n m 1 0..1 Jonas Andre – TUMexam 4

SLIDE 5

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

SLIDE 6

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

SLIDE 7

Chair of Network Architectures and Services Department of Informatics Technical University of Munich

Jonas Andre – TUMexam 7

SLIDE 8