Medieninformatik BA: Difference between revisions

(→‎Aufbau des Studiengangs: added query for Module -> (positions) -> course)
 
(10 intermediate revisions by one other user 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] }}


== Aufbau des Studiengangs ==
{{#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
{{#widget:SPARQLquery|code=
|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 || http://tinyurl.com/2aza77az || http://tinyurl.com/2ckcypph
|-
| Kurse (mit Tags) pro Semester || http://tinyurl.com/27s9vaut || http://tinyurl.com/2bvg3qg9
|-
| 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
| height=70vh | caption=Abhängigkeiten zwischen Modulen, sowie deren relevanten Modulpositionen
}}
Alternativ:
{{#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
?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 |caption= Abhängigkeiten zwischen Modulen, sowie deren Kurse.
}}
}}


== Module, Modulpositionen und Kurse ==
== Detailansicht ==  
Diese Query zeigt alle Module mit notwendigen Modulpositionen (wenn es mehr als eine gibt), und den anhängenden (exemplarischen) Kursen.
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 {
    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  
?course ?courseLabel
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.
  BIND(?module as ?course). # for char legend
    
    
  # 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 23:51, 20 May 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


Der Studiengang hat 14 Module mit 17 Kursen in einer Regelstudienzeit von 6 Semestern.

Studiengang

Links zu verschiedenen Visualisierungen

Beschreibung Query-Ergebnis SPARQL-Query
Kurse pro Semester http://tinyurl.com/2aza77az http://tinyurl.com/2ckcypph
Kurse (mit Tags) pro Semester http://tinyurl.com/27s9vaut http://tinyurl.com/2bvg3qg9
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

Try it!


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

Try it!



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!


Empfohlene Fachsemester

Empfohlene Fachsemester für die Module

Zusätzliche Queries

Studiengangsmetriken
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".}
}

Try it!