PresentationPics: Difference between revisions
(added queries for Learning path and Student interest) |
(→Overview of Student: update query (-username edgeLabel)) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
= Existing Images = | = Existing Images = | ||
Find all uploaded files [[Special:ListFiles|here]]. | |||
= Queries = | = Queries = | ||
Line 132: | Line 127: | ||
SELECT DISTINCT #?item1 ?item1Label ?edgeLabel ?item2 ?item2Label ?dependency ?dependencyLabel | SELECT DISTINCT #?item1 ?item1Label ?edgeLabel ?item2 ?item2Label ?dependency ?dependencyLabel | ||
?item2 ?item2Label ?dependency ?dependencyLabel ?item1 ?item1Label ?edgeLabel | ?item2 ?item2Label ?rgb ?dependency ?dependencyLabel ?item1 ?item1Label ?edgeLabel | ||
WHERE { | WHERE { | ||
VALUES ?item1 {wd:Q157} | VALUES ?item1 {wd:Q157} | ||
Line 142: | Line 137: | ||
?edge ?dummy ?prop ; rdf:type wikibase:Property. # edge labels | ?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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} ORDER BY ?prop | } 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". }
}
}
Learning path
The complete path to an item (here: Virtual Cameras) and what's next.
Student Interest
Overview of Student
Shows what items a Student is has linked their item to. Can be used to track progress.