SciELO - Scientific Electronic Library Online

 
 issue20A COMPARATIVE STUDY OF SENSOR PLACEMENT TECHNIQUES FOR STRUCTURAL DAMAGE DETECTIONDISTANCIAS A LOS EXTREMOS EN CONEXIONES PERNADAS DE MADERA author indexsubject indexarticles search
Home Pagealphabetic serial listing  

Services on Demand

Article

Indicators

Related links

  • On index processCited by Google
  • Have no similar articlesSimilars in SciELO
  • On index processSimilars in Google

Share


Revista EIA

Print version ISSN 1794-1237

Abstract

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.

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

        · abstract in Spanish | Portuguese     · text in Spanish     · Spanish ( pdf )