Pupils’ Data - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Conference Papers Year : 2013

Pupils’ Data


Parents are able to choose the school their children will attend. Thus, a core task of the Berlin Senate Administration Office for Education, Youth and Science (SenBildJugWiss) is having optimally-resourced schools with the adequate number of teachers at the start of a school year. The project’s mission was to obtain accurate figures by efficiently processing data of approximately 320,000 pupils from 700 schools. This processing included reporting on the various target groups of the SenBildJugWiss. The solution was to implement the OLAP-Database Palo as a management information system (MIS) tool. By doing so, it was important that an initial version was completed fairly swiftly to demonstrate main functions for future users, to highlight necessary adjustments for integration into the existing system, to define key performance indicators (KPIs) and their data sources, as well as creating the desired reports. One of the major challenges was creating a homogeneous data structure and harmonising the search and query language (SQL) tables. The outcome is a MIS that best fits the requirements, including meeting strict data protection regulations. The created reports provide, inter alia, the data delivery status required - the amount of pupils per class and schools eligible to gain certain levels of resources.
Fichier principal
Vignette du fichier
978-3-642-38411-0_16_Chapter.pdf (39.18 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-01468473 , version 1 (15-02-2017)





Anne Gregor, Michael Wilmes, Christian Kiock. Pupils’ Data. 10th Next Generation of Information Technology in Educational Management (ITEM), Aug 2012, Bremen, Germany. pp.171-176, ⟨10.1007/978-3-642-38411-0_16⟩. ⟨hal-01468473⟩
234 View
44 Download



Gmail Facebook Twitter LinkedIn More