PresentationPics: Difference between revisions

(created page + added gallery and query)
 
(added queries for Learning path and Student interest)
Line 9: Line 9:
</gallery>
</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 70:
}
}
}
}
}}
== 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 ?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
 
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?prop
}}
}}

Revision as of 16:24, 6 November 2023

A collection of images for presentations or similar.

Existing Images

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