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"
! '''Unlinked Items''' !! '''No dependencies'''  
! '''WissArb 23/24 Winter Term''' !! '''WissArb 24 Summer Term'''  
|-
|-
<!-- Linke Spalte -->
<!-- Linke Spalte -->
| style="width: 50%" | {{#widget:SPARQLquery|code=
| 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". }
}
}
|caption=WissArb 23/24 Winter Term
|height=30vh
|height=30vh
}}  
}}  
<!-- Rechte Spalte -->
<!-- Rechte Spalte -->
| style="width: 50%" | {{#widget:SPARQLquery|code=
| 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". }
}
}
|caption=WissArb 24 Summer Term
|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". }
}

Try it!


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

Try it!