Medieninformatik BA: Difference between revisions

(→‎Module, Modulpositionen und Kurse: update query for better show of term (commented))
(→‎Aufbau des Studiengangs: new query for widget, old in "alternativ" section (collapsed))
Line 53: Line 53:
   service wikibase:label { bd:serviceParam wikibase:language "de".}
   service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50
} LIMIT 50
| height=70vh | caption=Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen
| caption=Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen
}}
}}


Alternativ:
== Detailansicht ==


{{#widget:SPARQLquery|code=
{{#widget:SPARQLquery|code=
#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX p: <https://graphit.ur.de/prop/>
PREFIX ps: <https://graphit.ur.de/prop/statement/>
PREFIX pq: <https://graphit.ur.de/prop/qualifier/>
SELECT DISTINCT
?position ?positionLabel
?module ?moduleLabel ?rgb ?module2 ?module2Label
?course ?courseLabel
# ?tag ?tagLabel
?term ?termLabel # show relation to terms
WHERE { # Module -> Moduleposition -> Course
 
  {
  # Structure: module -> positions -> course
  { SELECT * WHERE {
    wd:Q790 wdt:P14 ?module.
    ?module wdt:P3 wd:Q791.
    ?module wdt:P14 ?position.
    ?position wdt:P14 ?course.
    ?course wdt:P3 wd:Q170.
    OPTIONAL {?position wdt:P34 ?term.} # term
   
    # Use "Kürzel" as labels for ?position
    ?position skos:altLabel ?pAlias.
    FILTER regex(?pAlias, "BA", "i").
    BIND(IF(BOUND(?pAlias), ?pAlias, ?positionLabel) as ?positionLabel).
   
    # Only show a module position, if there are >1 included in a module.
    { SELECT ?module ?moduleLabel (COUNT(?position) as ?pCount) WHERE {
      ?module wdt:P14 ?position.
    } GROUP BY ?module ?moduleLabel
    }
    ?module wdt:P14 ?position.
    FILTER (?pCount > 1).
  } }
  } UNION {
  # Structure: module -> course
  { SELECT ?module ?moduleLabel ?course ?courseLabel ?module2 ?module2Label ?term ?termLabel
  WHERE { # module -> course
    wd:Q790 wdt:P14 ?module.
    ?module wdt:P3 wd:Q791.
    ?module wdt:P14 ?position.
    ?position wdt:P14 ?course.
    ?course wdt:P3 wd:Q170.
    ?module wdt:P34 ?term. # term
   
    # Filter out all module positions for modules with only one position
    { SELECT ?module ?moduleLabel (COUNT(?position) as ?pCount) WHERE {
      ?module wdt:P14 ?position.
    } GROUP BY ?module ?moduleLabel
    }
    ?module wdt:P14 ?position.
    FILTER (?pCount = 1).
   
    # Show the dependencies according to their importance (=qualifier), currently only "Mandatory" (Q324)
    OPTIONAL {
        ?module p:P1 ?statement.
        ?statement ps:P1 ?module2.
        ?statement pq:P13 wd:Q324. # exclude this line to show dependencies of diff importance
      }
  } }
  }
 
  # OPTIONAL {?module wdt:P35 ?tag.} # hängt an module
  BIND (IF(BOUND(?module2), "ffeec2","e3ffd9") as ?rgb)
 
  # Use alias for courses -> e.g. OOP
  OPTIONAL {
    ?course skos:altLabel ?cAlias.
    BIND(IF(BOUND(?cAlias), ?cAlias, ?courseLabel) as ?courseLabel).
  } # REMOVE to show FULL COURSE LABELS
 
  # Only show exemplary courses -> no ~ WS/SS23
  FILTER(!regex(?courseLabel, "[0-9]{2}", "i"))
 
 
  service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50 |caption=Module, Modulpositionen und Kurse abhängig von Semester
}}
{{QA|question=Alternativ|answer=
Zeigt Module und deren Kurse in Abhängigkeit an.
{{SPARQL2|query=
#defaultView:Graph
#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
Line 85: Line 171:
   BIND (IF(BOUND(?depend), "ffeec2","e3ffd9") as ?rgb)
   BIND (IF(BOUND(?depend), "ffeec2","e3ffd9") as ?rgb)
   service wikibase:label { bd:serviceParam wikibase:language "de".}
   service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50 |caption= Abhängigkeiten zwischen Modulen, sowie deren Kurse.
} LIMIT 50
}}
}}
}}



Revision as of 10:20, 9 February 2024

Dies ist Übersicht für den Studiengang Medieninformatik (Bachelor of Arts) an der Universität Regensburg.

💡Info! Für direkte Informationen nutzen Sie die offizielle Homepage


Aufbau des Studiengangs

Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen

Detailansicht

Module, Modulpositionen und Kurse abhängig von Semester


Alternativ
Zeigt Module und deren Kurse in Abhängigkeit an.

Items used: Media informatics B.A. UR (Q790), Module (Q791), Course (Q170), Mandatory (Q324)

Properties used: includes (P14), instance of (P3), depends on (P1), importance (P13)

#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX p: <https://graphit.ur.de/prop/>
PREFIX ps: <https://graphit.ur.de/prop/statement/>
PREFIX pq: <https://graphit.ur.de/prop/qualifier/>
SELECT DISTINCT
?module ?moduleLabel ?rgb
# ?mPos ?mPosLabel
?depend ?dependLabel 
?course ?courseLabel 
WHERE {
  wd:Q790 wdt:P14 ?module.
  ?module wdt:P3 wd:Q791.
  ?module wdt:P14+ ?course. # Module -> (Modulepos) -> Course
  ?course wdt:P3 wd:Q170.
  
  # Show the dependencies according to their importance (=qualifier), currently only "Mandatory" (Q324)
  OPTIONAL {
    ?module p:P1 ?statement.
    ?statement ps:P1 ?depend. 
    ?statement pq:P13 wd:Q324. # exclude this line to show dependencies of diff importance
  } 
  
  BIND (IF(BOUND(?depend), "ffeec2","e3ffd9") as ?rgb)
  service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50

Try it!


Module, Modulpositionen und Kurse

Diese Query zeigt alle Module mit notwendigen Modulpositionen (wenn es mehr als eine gibt), und den anhängenden (exemplarischen) Kursen. Items used: Media informatics B.A. UR (Q790), Module (Q791), Course (Q170), Mandatory (Q324)

Properties used: includes (P14), instance of (P3), in term (P34), has tag (P35), depends on (P1), importance (P13)

#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX p: <https://graphit.ur.de/prop/>
PREFIX ps: <https://graphit.ur.de/prop/statement/>
PREFIX pq: <https://graphit.ur.de/prop/qualifier/>
SELECT DISTINCT
?position ?positionLabel
?module ?moduleLabel ?rgb ?module2 ?module2Label 
?course ?courseLabel 
# ?tag ?tagLabel 
# ?term ?termLabel # show relation to terms
WHERE { # Module -> Moduleposition -> Course
  
  {
  # Structure: module -> positions -> course
  { SELECT * WHERE {
    wd:Q790 wdt:P14 ?module.
    ?module wdt:P3 wd:Q791.
    ?module wdt:P14 ?position.
    ?position wdt:P14 ?course.
    ?course wdt:P3 wd:Q170.
    OPTIONAL {?position wdt:P34 ?term.} # term
    
    # Only show a module position, if there are >1 included in a module.
    { SELECT ?module ?moduleLabel (COUNT(?position) as ?pCount) WHERE {
       ?module wdt:P14 ?position.
    } GROUP BY ?module ?moduleLabel
    }
    ?module wdt:P14 ?position.
    FILTER (?pCount > 1).
  } }
  } UNION {
  # Structure: module -> course
  { SELECT ?module ?moduleLabel ?course ?courseLabel ?module2 ?module2Label ?term ?termLabel
  WHERE { # module -> course
    wd:Q790 wdt:P14 ?module.
    ?module wdt:P3 wd:Q791.
    ?module wdt:P14 ?position.
    ?position wdt:P14 ?course.
    ?course wdt:P3 wd:Q170.
    ?module wdt:P34 ?term. # term
    
    # Filter out all module positions for modules with only one position
    { SELECT ?module ?moduleLabel (COUNT(?position) as ?pCount) WHERE {
       ?module wdt:P14 ?position.
    } GROUP BY ?module ?moduleLabel
    }
    ?module wdt:P14 ?position.
    FILTER (?pCount = 1). 
    
    # Show the dependencies according to their importance (=qualifier), currently only "Mandatory" (Q324)
      OPTIONAL {
        ?module p:P1 ?statement.
        ?statement ps:P1 ?module2. 
        ?statement pq:P13 wd:Q324. # exclude this line to show dependencies of diff importance
      } 
  } } 
  }
  
  # OPTIONAL {?module wdt:P35 ?tag.} # hängt an module
  BIND (IF(BOUND(?module2), "ffeec2","e3ffd9") as ?rgb)
  # TODO: nur Module hängen an Semester dran = Farbige Knoten
  
  service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50

Try it!


Empfohlene Fachsemester

Empfohlene Fachsemester für die Module