HAL will be down for maintenance from Friday, June 10 at 4pm through Monday, June 13 at 9am. More information
Skip to Main content Skip to Navigation
Conference papers

Pupils’ Data

Abstract : 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.
Document type :
Conference papers
Complete list of metadata

Cited literature [2 references]  Display  Hide  Download

Contributor : Hal Ifip Connect in order to contact the contributor
Submitted on : Wednesday, February 15, 2017 - 3:04:45 PM
Last modification on : Wednesday, February 15, 2017 - 3:08:14 PM
Long-term archiving on: : Tuesday, May 16, 2017 - 3:08:20 PM


Files produced by the author(s)


Distributed under a Creative Commons Attribution 4.0 International License



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⟩



Record views


Files downloads