PresentationPics: Difference between revisions

(created page + added gallery and query)
 
(→‎Overview of Student: update query (-username edgeLabel))
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:


= Existing Images =
= Existing Images =
<gallery mode="slideshow">
Find all uploaded files [[Special:ListFiles|here]].
Image:Graph-structure.png|The Graph Structure
Image:Graph-structure-Course.png|The Course Structure
Image:Graph-simple.png|Dependencies between topics
Image:Max-screenie.png| Items connected to Max ([[ExampleStudent#A complete overview|Query]])
</gallery>


= Queries =
== Full Graph with Learning Path ==
== Full Graph with Learning Path ==
Query returns the full CGBV-Graph and the learning path to an item.
Query returns the full CGBV-Graph and the learning path to an item.  
''Union of both queries.''
{{SPARQL2|query=
{{SPARQL2|query=
#defaultView:Graph
#defaultView:Graph
Line 68: Line 65:
}
}
}
}
}}
== Learning path ==
The complete path to an item (here: [[Item:Q149|Virtual Cameras]]) and what's next.
{{#widget:SPARQLquery|code=
#defaultView:Graph
# prerequisite -> topic -> postrequisite
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct ?v ?vLabel ?rgb ?link ?linkLabel
WHERE {
{
  { SELECT * WHERE {
  { SELECT ?goal ?goalLabel ?topic ?topicLabel WHERE {
    {
    BIND (wd:Q149 as ?goal).
    ?goal wdt:P1+ ?topic.
    } UNION {
      VALUES ?topic { wd:Q149 } # we also want to include the root node itself
    }
   
  }
  }
   
  ?topic wdt:P1 ?pre.
  BIND (?topic as ?v). # + add all ?pre that are not yet in ?topic 
  BIND (?pre as ?link).
  bind (if(?v = wd:Q149, "FBBC74", "FFEDD8") as ?rgb).
  }
  }
  Union
 
  { SELECT * WHERE {
  { SELECT ?topic ?topicLabel ?goal ?goalLabel WHERE {
    {
      BIND (wd:Q149 as ?topic).
      ?goal wdt:P1+ ?topic.
    } UNION {
      VALUES ?topic { wd:Q149 } # we also want to include the root node itself
    }
  }
  }
  ?post wdt:P1 ?topic.
  BIND (?post as ?v).
  BIND (?topic as ?link).
  bind ("F68C13" as ?rgb).
  }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
} |caption=The learning path to an item, showing its pre- and postrequisites
}}
== Student Interest ==
{{#widget:SPARQLquery|code=
#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
SELECT DISTINCT #?item1 ?item1Label ?edgeLabel ?item2 ?item2Label ?dependency ?dependencyLabel
?item2 ?item2Label ?rgb ?dependency ?dependencyLabel ?item1 ?item1Label ?edgeLabel
WHERE {
  VALUES ?item1 {wd:Q157}
  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 ?rgb).
 
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?prop
}}
== Overview of Student ==
Shows what items a Student is has linked their item to. Can be used to track progress.
{{#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 ?rgb WHERE {
  VALUES ?item1 {wd:Q157}
 
  ?item1 ?prop ?item2.
  ?edge ?dummy ?prop ; rdf:type wikibase:Property.
  # Minus username in edgeLabel
  FILTER (?prop != wdt:P28)
  # 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 ?rgb).
 
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?prop
}}
}}

Latest revision as of 16:01, 9 November 2023

A collection of images for presentations or similar.

Existing Images

Find all uploaded files here.

Queries

Full Graph with Learning Path

Query returns the full CGBV-Graph and the learning path to an item. Union of both queries. Items used: Virtual Cameras (Q149)

Properties used: depends on (P1), subclass of (P2)

#defaultView:Graph
# prerequisite -> topic -> postrequisite
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct ?v ?vLabel ?rgb ?link ?linkLabel
WHERE {
{
  { SELECT * WHERE {
  { SELECT ?goal ?goalLabel ?topic ?topicLabel WHERE {
    {
    BIND (wd:Q149 as ?goal).
    ?goal wdt:P1+ ?topic.
    } UNION {
      VALUES ?topic { wd:Q149 } # we also want to include the root node itself
    }
    
  }
  }
    
  ?topic wdt:P1 ?pre.
  BIND (?topic as ?v). # + add all ?pre that are not yet in ?topic   
  BIND (?pre as ?link).
  bind (if(?v = wd:Q149, "FBBC74", "FFEDD8") as ?rgb).
  }
  }

  Union
  
  { SELECT * WHERE {
  { SELECT ?topic ?topicLabel ?goal ?goalLabel WHERE {
    {
      BIND (wd:Q149 as ?topic).
      ?goal wdt:P1+ ?topic. 
    } UNION {
      VALUES ?topic { wd:Q149 } # we also want to include the root node itself
    }
  }
  }
  ?post wdt:P1 ?topic.
  BIND (?post as ?v).
  BIND (?topic as ?link).
  bind ("F68C13" as ?rgb).
  }
  }
  
  Union 
  
  { Select ?v ?vLabel ?link ?linkLabel WHERE {
  ?v wdt:P1 ?link.
  ?v wdt:P2 ?class.
  }
  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}

Try it!


Learning path

The complete path to an item (here: Virtual Cameras) and what's next.

The learning path to an item, showing its pre- and postrequisites

Student Interest

Overview of Student

Shows what items a Student is has linked their item to. Can be used to track progress.