Courses/Wissenschaftliches Arbeiten SS24/Graph: Difference between revisions
(created page + added compairison query (for knowledge & interest)) |
(→Interests & Knowledge: convert to Try It!) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
<!-- Floated Table that contains both orphan queries(32.5em)--> | <!-- Floated Table that contains both orphan queries(32.5em)--> | ||
{| class="wikitable" | {| class="wikitable" | ||
! ''' | ! '''WissArb 23/24 Winter Term''' !! '''WissArb 24 Summer Term''' | ||
|- | |- | ||
<!-- Linke Spalte --> | <!-- Linke Spalte --> | ||
| style="width: 50%" | {{ | | style="width: 50%" | {{SPARQL2|query= | ||
#defaultView:ReScatterChart | #defaultView:ReScatterChart | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
| Line 33: | Line 33: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
|height=30vh | |height=30vh | ||
}} | }} | ||
<!-- Rechte Spalte --> | <!-- Rechte Spalte --> | ||
| style="width: 50%" | {{ | | style="width: 50%" | {{SPARQL2|query= | ||
#defaultView:ReScatterChart | #defaultView:ReScatterChart | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
| Line 62: | Line 61: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
|height=30vh | |height=30vh | ||
}} | }} | ||
|} | |} | ||
Latest revision as of 11:54, 23 May 2024
Contains queries about the graph of the "Wissenschaftliches Arbeiten SS24" course to help debug and structure it.
Interests & Knowledge
Compairing the 23/24 WS version with the 24SS Version of the course
| WissArb 23/24 Winter Term | WissArb 24 Summer Term |
|---|---|
| Items used: Wissenschaftliches Arbeiten 23/24WS (Q468)
Properties used: includes (P14), participates in (P25), has completed (P12), interested in (P23) #defaultView:ReScatterChart
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT DISTINCT ?known ?interests ?item ?itemLabel # ?known ?interests ?item ?itemLabel
WHERE {
wd:Q468 wdt:P14/wdt:P14 ?item. # ?session.
OPTIONAL {
SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?known) WHERE {
?student wdt:P25 wd:Q468.
?student wdt:P12 ?item.
} GROUP BY ?item ?itemLabel
}
OPTIONAL {
SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?interests) WHERE {
?student wdt:P25 wd:Q468.
?student wdt:P23 ?item.
} GROUP BY ?item ?itemLabel
}.
BIND (IF(!BOUND(?interests), 0, ?interest) as ?interests).
BIND (IF(!BOUND(?known), 0, ?known) as ?known).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
Items used: Wissenschaftliches Arbeiten 24SS (Q926)
Properties used: includes (P14), participates in (P25), has completed (P12), interested in (P23) #defaultView:ReScatterChart
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT DISTINCT ?known ?interests ?item ?itemLabel # ?known ?interests ?item ?itemLabel
WHERE {
wd:Q926 wdt:P14/wdt:P14 ?item.
OPTIONAL {
SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?known) WHERE {
?student wdt:P25 wd:Q926.
?student wdt:P12 ?item.
} GROUP BY ?item ?itemLabel
}
OPTIONAL {
SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?interests) WHERE {
?student wdt:P25 wd:Q926.
?student wdt:P23 ?item.
} GROUP BY ?item ?itemLabel
}.
BIND (IF(!BOUND(?interests), 0, ?interest) as ?interests).
BIND (IF(!BOUND(?known), 0, ?known) as ?known).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|