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 = | ||
Find all uploaded files [[Special:ListFiles|here]]. | |||
= 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". }
}
}
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.