Latest revision as of 14:15, 9 April 2024

This page gives you (as a student user) an overview of your use of the graph.

How to

To use this page all you need to do is log in and this page should display the information connected to your personal item. Otherwise it will display the example student Max Mustermann.

NOTE: Your username needs to be the same as the english label of your personal item. For further information on how to do this you can check the ExampleStudent or CGBV page. Or you can take a direct look at the Max Mustermann item.

Your Graph

An Overview

This query gives an overview of all items that you have linked to from your personal item.

An overview of all linked items for Max Mustermann

It shows the courses that you participate in. The items that you have completed. And the items that you are interested in.

Path to interest

The query returns a small learning path that shows you all items that you are interested in and their direct prerequisites.

The direct prerequisites to all items that Max Mustermann is interested in.

Coursework

This query gives an overview of all courseworks to be done for the courses that you participate in.

The courses that Max Mustermann participates in and their (completed) coursework

It shows the completed coursework. And the, yet to be completed, but mandatory coursework.

A direct learning path

This query will give you a full learning path to an item. Meaning that the given graph will contain all prerequisites to the wanted item, as well as the direct postrequisites.

Input a custom value or just run the query to see an example. (Note: Autocomplete not currently working.)

@@ Line 9: / Line 9: @@
 '''NOTE:''' Your ''username'' needs to be <u>the same</u> as the ''english label'' of your personal item. For further information on how to do this you can check the [[ExampleStudent#A_Student|ExampleStudent]] or [[Courses/CGBV#Erste_Schritte_mit_GraphIT|CGBV]] page. Or you can take a direct look at the [[Item:Q157|Max Mustermann]] item.
 </div>
+= Your Graph =
+== An Overview ==
+This query gives an overview of all items that you have linked to from your personal item.
+{{#widget:SPARQLquery|code=
+#defaultView:Graph
+PREFIX wdt: <https://graphit.ur.de/prop/direct/>
+PREFIX wd: <https://graphit.ur.de/entity/>
+SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel ?rgb1 ?shape1 WHERE {
+  ?item1 rdfs:label "{{#username:Max Mustermann}}"@en.
+  ?item1 ?prop ?item2.
+  #?edge ?dummy ?prop ; rdf:type wikibase:Property.
+  MINUS {?item wdt:P3 ?item2}.
+  # Color Coding:
+    bind (if(?prop = wdt:P25, "e8fcff", # participates in (blue)  f3fdff
+          if(?prop = wdt:P12, "e3ffd9", # has completed (green)
+          if(?prop = wdt:P23, "ffeec2", # interested in (orange)
+       "FFFFFF" ))) as ?rgb1).
+    bind("ellipse" as ?shape1).
+SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+} |caption=An overview of all linked items for {{#username:Max Mustermann}}
+}}
+It shows the <span style="background-color:#e8fcff;">courses</span> that you [[Property:P25|participate in]].
+The  <span style="background-color:#e3ffd9">items</span> that you have [[Property:P12|completed]].
+And the <span style="background-color:#ffeec2">items</span> that you are [[Property:P23|interested in]].
+== Path to interest ==
+The query returns a small learning path that shows you all items that you are interested in and their direct prerequisites.
+{{#widget:SPARQLquery|code=
+#defaultView:Graph
+PREFIX wdt: <https://graphit.ur.de/prop/direct/>
+PREFIX wd: <https://graphit.ur.de/entity/>
+SELECT DISTINCT ?item2 ?item2Label ?rgb1 ?shape1 ?dependency ?dependencyLabel ?item1 ?item1Label ?edgeLabel
+WHERE {
+  ?item1 rdfs:label "{{#username:Max Mustermann}}"@en.
+  VALUES ?prop {wdt:P23}
+  ?item1 ?prop ?item2.
+  # Select all dependencies for every item2
+  OPTIONAL {?item2 wdt:P1 ?dependency.}
+  ?edge ?dummy ?prop ; rdf:type wikibase:Property. # edge labels
+  BIND ("ffeec2" as ?rgb1).
+  BIND ("ellipse" as ?shape1).
+SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+} | caption=The direct prerequisites to all items that {{#username:Max Mustermann}} is interested in.
+}}
+== Coursework ==
+This query gives an overview of all courseworks to be done for the courses that you participate in.
+{{#widget:SPARQLquery|code=
+#defaultView:Graph
+PREFIX wdt: <https://graphit.ur.de/prop/direct/>
+PREFIX wd: <https://graphit.ur.de/entity/>
+select distinct ?course ?courseLabel ?user ?userLabel ?work ?workLabel ?rgb
+Where {
+  ?user rdfs:label "{{#username:Max Mustermann}}"@en.
+  ?user wdt:P25 ?course.
+  ?course wdt:P14 ?work.
+  ?work wdt:P3 wd:Q463.
+  # Mark completed Items in green.
+  optional {
+   ?user wdt:P12 ?work.
+   bind (if(bound(?work), "B2FF7B", "FFFFFF") as ?rgb).  # work "
+  }
+  # Mark Mandatory Items in red
+  optional {
+    ?work wdt:P13 ?importance.
+    bind (if(?importance = wd:Q324, "FF5F5C", "FFFFFF") as ?rgb).
+  }
+  service wikibase:label { bd:serviceParam wikibase:language "en" }
+} |caption= The courses that {{#username:Max Mustermann}} participates in and their (completed) coursework
+}}
+It shows the <span style="background-color:#B2FF7B;">completed</span> coursework.
+And the, yet to be completed, but <span style="background-color:#FF5F5C">mandatory</span> coursework.
+== A direct learning path ==
+This query will give you a full learning path to an item.
+Meaning that the given graph will contain all prerequisites to the wanted item, as well as the direct postrequisites.
+''Input a custom value or just run the query to see an example. (Note: Autocomplete not currently working.)''
+{{#queryformlink:form=Learning Path2|link text=Try running the query :D|link type=button|tooltip=Runs the query in a separate window}}

Student Use: Difference between revisions