Medieninformatik BA: Difference between revisions
(→Aufbau des Studiengangs: added query for Module -> (positions) -> course) |
(→Studiengang: update "Kurse (mit Tags)") |
||
| (15 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
{{Note|type=info|text=Für direkte Informationen nutzen Sie die offizielle [https://www.uni-regensburg.de/sprache-literatur-kultur/medieninformatik/studium/bachelor/index.html Homepage] }} | {{Note|type=info|text=Für direkte Informationen nutzen Sie die offizielle [https://www.uni-regensburg.de/sprache-literatur-kultur/medieninformatik/studium/bachelor/index.html Homepage] }} | ||
== | {{#get_web_data:url=http://query.graphit.ur.de/proxy/wdqs/bigdata/namespace/wdq/sparql?query=%23defaultView%3ATable%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fentity%2F%3E%0ASELECT%20%0ADISTINCT%20%3Fmodules%20%3Fpositions%20%3Fterms%20%0A%23%3Fposition%20%3FpositionLabel%20%0A%23%20(COUNT%20(DISTINCT%20%3Fposition)%20as%20%3Fpositions)%0AWHERE%20%7B%0A%20%20%7B%20Select%20(COUNT%20(DISTINCT%20%3Fposition)%20as%20%3Fpositions)%20WHERE%20%7B%0A%20%20wd%3AQ790%20wdt%3AP14%20%3Fmodule.%0A%20%20%3Fmodule%20wdt%3AP3%20wd%3AQ791.%0A%20%20%3Fmodule%20wdt%3AP14%20%3Fposition.%0A%20%20%3Fposition%20wdt%3AP14%20%3Fcourse.%0A%20%20%3Fcourse%20wdt%3AP3%20wd%3AQ170.%0A%20%20%7D%7D%20%0A%20%20%7B%20Select%20(COUNT%20(DISTINCT%20%3Fmodule)%20as%20%3Fmodules)%20WHERE%20%7B%0A%20%20wd%3AQ790%20wdt%3AP14%20%3Fmodule.%0A%20%20%3Fmodule%20wdt%3AP3%20wd%3AQ791.%0A%20%20%7D%7D%0A%20%20%7B%20Select%20(COUNT%20(DISTINCT%20%3Fterm)%20as%20%3Fterms)%20WHERE%20%7B%0A%20%20wd%3AQ790%20wdt%3AP14%20%3Fmodule.%0A%20%20%3Fmodule%20wdt%3AP3%20wd%3AQ791.%0A%20%20%3Fmodule%20wdt%3AP34%20%3Fterm%0A%20%20%7D%7D%0A%20%20%23%20FILTER(!regex(%3FcourseLabel%2C%20%22%5B0-9%5D%7B2%7D%22%2C%20%22i%22))%0A%0A%20%20service%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%7D%0A%7D%20&format=json | ||
{{# | |format=json | ||
|use jsonpath | |||
|data= | |||
modules=$.results.bindings[0].modules.value, | |||
positions=$.results.bindings[0].positions.value, | |||
terms=$.results.bindings[0].terms.value, | |||
}} | |||
Der Studiengang hat '''{{#external_value:modules}} Module''' mit '''{{#external_value:positions}} Kursen''' in einer Regelstudienzeit von '''{{#external_value:terms}} Semestern'''. | |||
= Studiengang = | |||
Links zu verschiedenen Visualisierungen | |||
{| class="wikitable" style="margin:auto" | |||
! Beschreibung !! Query-Ergebnis !! SPARQL-Query | |||
|- | |||
| Kurse pro Semester || https://tinyurl.com/2d4l76x9 || https://tinyurl.com/2852we9m | |||
|- | |||
| Kurse (mit Tags) pro Semester || https://tinyurl.com/2c2sfdsq || https://tinyurl.com/2bsmgm3m | |||
|- | |||
| Bar Chart: Kurse pro Semester || http://tinyurl.com/22hybdbp || http://tinyurl.com/2aza77az | |||
|} | |||
== Modulplan == | |||
Zeigt die Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen | |||
{{SPARQL2|query= | |||
#defaultView:Graph | #defaultView:Graph | ||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | PREFIX wdt: <https://graphit.ur.de/prop/direct/> | ||
| Line 53: | Line 76: | ||
service wikibase:label { bd:serviceParam wikibase:language "de".} | service wikibase:label { bd:serviceParam wikibase:language "de".} | ||
} LIMIT 50 | } LIMIT 50 | ||
}} | }} | ||
== | == Detailansicht == | ||
Zeigt die Module, Modulpositionen und Kurse abhängig von Semester | |||
{{SPARQL2|query= | {{SPARQL2|query= | ||
#defaultView:Graph | #defaultView:Graph | ||
| Line 101: | Line 91: | ||
?module ?moduleLabel ?rgb ?module2 ?module2Label | ?module ?moduleLabel ?rgb ?module2 ?module2Label | ||
?course ?courseLabel | ?course ?courseLabel | ||
# ?tag ?tagLabel | |||
?term ?termLabel # show relation to terms | |||
WHERE { # Module -> Moduleposition -> Course | WHERE { # Module -> Moduleposition -> Course | ||
| Line 112: | Line 103: | ||
?position wdt:P14 ?course. | ?position wdt:P14 ?course. | ||
?course wdt:P3 wd:Q170. | ?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. | # Only show a module position, if there are >1 included in a module. | ||
| Line 119: | Line 116: | ||
} | } | ||
?module wdt:P14 ?position. | ?module wdt:P14 ?position. | ||
FILTER (?pCount > 1). | FILTER (?pCount > 1). | ||
} } | } } | ||
} UNION { | } UNION { | ||
# Structure: module -> course | # Structure: module -> course | ||
{ SELECT ?module ?moduleLabel ?course ?courseLabel ?module2 ?module2Label WHERE { # module -> course | { SELECT ?module ?moduleLabel ?course ?courseLabel ?module2 ?module2Label ?term ?termLabel | ||
WHERE { # module -> course | |||
wd:Q790 wdt:P14 ?module. | wd:Q790 wdt:P14 ?module. | ||
?module wdt:P3 wd:Q791. | ?module wdt:P3 wd:Q791. | ||
| Line 130: | Line 127: | ||
?position wdt:P14 ?course. | ?position wdt:P14 ?course. | ||
?course wdt:P3 wd:Q170. | ?course wdt:P3 wd:Q170. | ||
?module wdt:P34 ?term. # term | |||
# Filter out all module positions for modules with only one position | # Filter out all module positions for modules with only one position | ||
| Line 140: | Line 138: | ||
# Show the dependencies according to their importance (=qualifier), currently only "Mandatory" (Q324) | # Show the dependencies according to their importance (=qualifier), currently only "Mandatory" (Q324) | ||
OPTIONAL { | |||
?module p:P1 ?statement. | ?module p:P1 ?statement. | ||
?statement ps:P1 ?module2. | ?statement ps:P1 ?module2. | ||
?statement pq:P13 wd:Q324. # exclude this line to show dependencies of diff importance | ?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) | 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 | |||
}} | |||
{{QA|question=Alternativ|answer= | |||
Zeigt Module und deren Kurse in Abhängigkeit an. | |||
{{SPARQL2|query= | |||
#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".} | service wikibase:label { bd:serviceParam wikibase:language "de".} | ||
} LIMIT 50 | } LIMIT 50 | ||
}} | |||
}} | }} | ||
| Line 159: | Line 202: | ||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | PREFIX wdt: <https://graphit.ur.de/prop/direct/> | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
SELECT DISTINCT | SELECT DISTINCT ?term ?termLabel ?alias ?alias2 ?module ?moduleLabel | ||
?term ?termLabel | |||
?module ?moduleLabel | |||
WHERE { | WHERE { | ||
wd:Q790 wdt:P14 ?module. | wd:Q790 wdt:P14 ?module. | ||
?module wdt:P3 wd:Q791. | ?module wdt:P3 wd:Q791. | ||
?module wdt:P34 ?term. | ?module wdt:P34 ?term. | ||
# Modulkürzel als ALIAS | |||
?module skos:altLabel ?alias. | |||
FILTER regex(?alias, "BA", "i") # works | |||
service wikibase:label { bd:serviceParam wikibase:language "de".} | service wikibase:label { bd:serviceParam wikibase:language "de".} | ||
} LIMIT 50 | caption=Empfohlene Fachsemester für die Module | } LIMIT 50 | caption=Empfohlene Fachsemester für die Module | ||
}} | |||
== Zusätzliche Queries == | |||
{{QA|question=Studiengangsmetriken|answer= | |||
''Gibt zurück Anzahl der Module, Modulpositionen(=Kurse) und Semester.'' | |||
{{SPARQL2|query= | |||
#defaultView:Table | |||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | |||
PREFIX wd: <https://graphit.ur.de/entity/> | |||
SELECT DISTINCT ?modules ?positions ?terms | |||
WHERE { | |||
{ Select (COUNT (DISTINCT ?position) as ?positions) WHERE { | |||
wd:Q790 wdt:P14 ?module. | |||
?module wdt:P3 wd:Q791. | |||
?module wdt:P14 ?position. | |||
?position wdt:P14 ?course. | |||
?course wdt:P3 wd:Q170. | |||
} } | |||
{ Select (COUNT (DISTINCT ?module) as ?modules) WHERE { | |||
wd:Q790 wdt:P14 ?module. | |||
?module wdt:P3 wd:Q791. | |||
} } | |||
{ Select (COUNT (DISTINCT ?term) as ?terms) WHERE { | |||
wd:Q790 wdt:P14 ?module. | |||
?module wdt:P3 wd:Q791. | |||
?module wdt:P34 ?term. | |||
} } | |||
service wikibase:label { bd:serviceParam wikibase:language "de".} | |||
} | |||
}} | |||
}} | }} | ||
Latest revision as of 17:42, 13 February 2025
Dies ist Übersicht für den Studiengang Medieninformatik (Bachelor of Arts) an der Universität Regensburg.
ℹ️ Für direkte Informationen nutzen Sie die offizielle Homepage
Der Studiengang hat 14 Module mit 16 Kursen in einer Regelstudienzeit von 6 Semestern.
Studiengang
Links zu verschiedenen Visualisierungen
| Beschreibung | Query-Ergebnis | SPARQL-Query |
|---|---|---|
| Kurse pro Semester | https://tinyurl.com/2d4l76x9 | https://tinyurl.com/2852we9m |
| Kurse (mit Tags) pro Semester | https://tinyurl.com/2c2sfdsq | https://tinyurl.com/2bsmgm3m |
| Bar Chart: Kurse pro Semester | http://tinyurl.com/22hybdbp | http://tinyurl.com/2aza77az |
Modulplan
Zeigt die Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen Items used: Media informatics B.A. UR (Q790), Module (Q791), 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 ?module2 ?module2Label
?position ?positionLabel
# ?pCount
?course ?courseLabel
where {
wd:Q790 wdt:P14 ?module.
?module wdt:P3 wd:Q791.
{
# 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 {
# Select all other module normally
{ SELECT ?module ?moduleLabel ?module2 ?module2Label ?course ?courseLabel
WHERE {
wd:Q790 wdt:P14 ?module.
?module wdt:P3 wd:Q791.
?module wdt:P14 ?position.
# 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 {?position wdt:P14 ?course}
}
}
}
BIND (IF(BOUND(?module2), "ffeec2","e3ffd9") as ?rgb)
service wikibase:label { bd:serviceParam wikibase:language "de".}
} LIMIT 50
Detailansicht
Zeigt die Module, Modulpositionen und Kurse abhängig von Semester 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
# 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
| 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
|
Empfohlene Fachsemester
Empfohlene Fachsemester für die Module
Zusätzliche Queries
| Gibt zurück Anzahl der Module, Modulpositionen(=Kurse) und Semester.
Items used: Media informatics B.A. UR (Q790), Module (Q791), Course (Q170) Properties used: includes (P14), instance of (P3), in term (P34) #defaultView:Table
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
SELECT DISTINCT ?modules ?positions ?terms
WHERE {
{ Select (COUNT (DISTINCT ?position) as ?positions) WHERE {
wd:Q790 wdt:P14 ?module.
?module wdt:P3 wd:Q791.
?module wdt:P14 ?position.
?position wdt:P14 ?course.
?course wdt:P3 wd:Q170.
} }
{ Select (COUNT (DISTINCT ?module) as ?modules) WHERE {
wd:Q790 wdt:P14 ?module.
?module wdt:P3 wd:Q791.
} }
{ Select (COUNT (DISTINCT ?term) as ?terms) WHERE {
wd:Q790 wdt:P14 ?module.
?module wdt:P3 wd:Q791.
?module wdt:P34 ?term.
} }
service wikibase:label { bd:serviceParam wikibase:language "de".}
}
|