Resumen

MENDOZA, Martha et al. DIMENSIONAL MODELING OF ICT COMPETENCIES. Rev.EIA.Esc.Ing.Antioq [online]. 2013, n.20, pp.39-54. ISSN 1794-1237.

Some Latin American countries are developing programs that allow their educational communities to have greater access to in Information and Communication Technology (ICT). In order to verify the effectiveness of these programs is necessary to measure the ICT skills acquired by the members of these communities. This paper presents a dimensional model for a data warehouse that enables the analysis of information related to the appropriation of ICT skills by teachers and students of educational institutions. The design cases are based on Ralph Kimball’s proposals: many to many relationship, heterogeneous products, subdimension and organizational hierarchy. There is also a new design case called “Dimension with measures”, which together with a fact table and calculation of measures based on MDX functions allows weighted analysis of the competences of the actors in the educational institutions. This new design case can be used in other contexts that require recursive calculations of weighted numeric attributes on hierarchical organizational dimensions within a data warehouse. Finally, the main components of a Decision Support System (DSS) developed for the “Computers for Education” (CPE) program in partnership with the University of Cauca are presented. The DSS System can be replicated in other programs with similar objectives.

Palabras clave : Dimensional Modeling; Data Warehouse; OLAP; Competencies in Information and Communication Technology (ICT).

        · resumen en Español | Portugués     · texto en Español     · Español ( pdf )