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 | ||
| caption=Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen | |||
}} | }} | ||
== 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 | } 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
Detailansicht
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
|
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
Empfohlene Fachsemester