Hochschul-Administration

Stakeholder-Sicht der Hochschulverwaltung auf die Säule-B-Echtdaten (Supply-Profile aus Modulhandbüchern, Pipeline v0.4). Aggregat-Übersicht pro Hochschule.

Hochschule Darmstadt

hda

2962

Module

16.739

ECTS gesamt

2377

Lernziele

651

Unmapped Outcomes

73,3%

Ø Confidence

Module ansehen →

FernUniversität in Hagen

fuh

605

Module

5.192

ECTS gesamt

528

Lernziele

161

Unmapped Outcomes

75,4%

Ø Confidence

Module ansehen →

Berechnungs-Transparenz Cypher

Diese Cypher-Query produziert die Aggregat-Zahlen oben. Kopieren und im Neo4j-Browser (http://localhost:7474) ausführen, um den Graph interaktiv zu erkunden.

    MATCH (hei:hrqde__HigherEducationInstitution)
    WHERE hei.uri STARTS WITH "http://hr-qde.org/data/koeppe/"

    OPTIONAL MATCH (m:hrqde__EducationalModule)-[:hrqde__offeredBy]->(hei)
    WITH hei, count(DISTINCT m) AS moduleCount,
         sum(toFloat(m.hrqde__ects)) AS totalEcts

    OPTIONAL MATCH (m2:hrqde__EducationalModule)-[:hrqde__offeredBy]->(hei),
                  (m2)-[:hrqde__hasOutcome]->(o:hrqde__LearningOutcome)
    WITH hei, moduleCount, totalEcts,
         count(DISTINCT o) AS outcomesCount,
         avg(toFloat(o.hrqde__provenanceConfidence)) AS avgConfidence

    OPTIONAL MATCH (m3:hrqde__EducationalModule)-[:hrqde__offeredBy]->(hei),
                  (m3)-[:hrqde__hasUnmappedOutcome]->(u:hrqde__UnmappedLearningOutcome)
    RETURN hei.uri AS uri,
           hei.rdfs__label AS label,
           moduleCount,
           coalesce(totalEcts, 0.0) AS totalEcts,
           outcomesCount,
           count(DISTINCT u) AS unmappedCount,
           coalesce(avgConfidence, 0.0) AS avgConfidence
    ORDER BY moduleCount DESC