PresentationPics - Revision history

Leonie: /* Overview of Student */ update query (-username edgeLabel)

2023-11-09T16:01:26Z

Overview of Student: update query (-username edgeLabel)

← Older revision		Revision as of 16:01, 9 November 2023
Line 155:		Line 155:
	?item1 ?prop ?item2.		?item1 ?prop ?item2.
	?edge ?dummy ?prop ; rdf:type wikibase:Property.		?edge ?dummy ?prop ; rdf:type wikibase:Property.

			# Minus username in edgeLabel
			FILTER (?prop != wdt:P28)

	# Color Coding:		# Color Coding:

Leonie: added: overview student

2023-11-06T16:36:06Z

added: overview student

@@ Line 138: / Line 138: @@
    ?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
 }}

Leonie: /* Student Interest */ update query with color

2023-11-06T16:34:47Z

Student Interest: update query with color

← Older revision		Revision as of 16:34, 6 November 2023
Line 127:		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 137:		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". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	} ORDER BY ?prop		} ORDER BY ?prop
	}}		}}

Leonie: /* Existing Images */ removed gallery

2023-11-06T16:26:27Z

Existing Images: removed gallery

← Older revision		Revision as of 16:26, 6 November 2023
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 =		= Queries =

Leonie: added queries for Learning path and Student interest

2023-11-06T16:24:20Z

added queries for Learning path and Student interest

@@ Line 9: / Line 9: @@
 </gallery>
 == Full Graph with Learning Path ==
 Query returns the full CGBV-Graph and the learning path to an item.
 {{SPARQL2|query=
 #defaultView:Graph
@@ Line 68: / Line 70: @@
+}
+}
 }}

Leonie: created page + added gallery and query

2023-11-06T16:18:55Z

created page + added gallery and query

New page

A collection of images for presentations or similar.

= Existing Images =
<gallery mode="slideshow">
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>

== Full Graph with Learning Path ==
Query returns the full CGBV-Graph and the learning path to an item.
{{SPARQL2|query=
#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". }
}
}
}}