Courses/CGBV SS24/Graph: Difference between revisions

Revision as of 11:05, 6 May 2024

Contains queries about the graph of the "CGBV SS24" course to help debug and structure it.

All Sessions

Returns a graph containing all sessions included in the course, as well as all included topics.

All existing CGBV SS24 sessions with included topics

All Categories

Returns a graph with all categories included in the course. See the query here

Indegrees

Returns a graph that uses the indegrees to size items. I.e. the size of a node depends on how many prerequisites it has.

Nodes that aren't cicles are items, that are linked to course-items, but are themselves not included in the course.

Items

Orphans

Unlinked Items	No dependencies
Items that don't depend on and aren't depended on	Items that don't depend on other items
Link to the query	Link to the query

Resources

All Resources

Returns a table with all resources that are linked to from inside the course.

Items used: CGBV 24SS (Q932)

Properties used: includes (P14), resource (P21), url (P20), instance of (P3)

#defaultView:Table
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
SELECT DISTINCT ?item ?itemLabel ?resource ?resourceLabel ?alias ?url ?type ?typeLabel # ?resLabelLength 
WHERE {
  wd:Q932 wdt:P14/wdt:P14 ?item.
  ?item wdt:P21 ?resource.
  OPTIONAL {?resource wdt:P20 ?link.
            BIND("true" as ?url) }
  
  OPTIONAL {?resource wdt:P3 ?type.}
  OPTIONAL {?resource skos:altLabel ?alias.}

  service wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ASC(?resourceLabel)

Try it!

Items without Resources

Returns a table with all items in the CGBV 24SS course, that don't link to a resource.

"Interests" and "Knowledge"

✒️ Note: The plot doesn't show overlappind point

@@ Line 158: / Line 158: @@
    service wikibase:label { bd:serviceParam wikibase:language "en". }
+}
+}}
+== "Interests" and "Knowledge" ==
+{{Note|text=The plot doesn't show overlappind point}}
+{{#widget:SPARQLquery|code=
+#defaultView:ScatterChart
+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:Q932 wdt:P14/wdt:P14 ?item.
+  OPTIONAL {
+    SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?known) WHERE {
+      ?student wdt:P12 ?item.
+    } GROUP BY ?item ?itemLabel
+  }
+  OPTIONAL {
+    SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?interests) WHERE {
+      ?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". }
 }
 }}