ExampleStudent - Revision history

Leonie: /* A complete overview */ update query (-username edgeLabel)

2023-11-09T16:00:46Z

A complete overview: update query (-username edgeLabel)

← Older revision		Revision as of 16:00, 9 November 2023
Line 41:		Line 41:
	?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: /* Using the Graph */ added Prereqs for course

2023-10-10T13:29:43Z

Using the Graph: added Prereqs for course

@@ Line 132: / Line 132: @@
 }}
 '''NOTE:''' Currently works without specific courses, meaning that the Course Works has not yet been attributed to a specific course. There is also no certification by a lecturer.
 = Using the Graph yourself =

Leonie: /* A complete overview */

2023-10-09T14:37:25Z

A complete overview

← Older revision		Revision as of 14:37, 9 October 2023
Line 50:		Line 50:
	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
	}}.		}}

	== Learnpath to interests ==		== Learnpath to interests ==

Leonie: /* Completed Items */ add caption + height

2023-10-09T10:07:29Z

Completed Items: add caption + height

← Older revision		Revision as of 10:07, 9 October 2023
Line 93:		Line 93:
	OPTIONAL {?topic wdt:P11 ?image.}		OPTIONAL {?topic wdt:P11 ?image.}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		} \|captio=A timeline of when an item was completed \|height=30vh
	}}		}}

Leonie: /* Completed Course Work */ update color

2023-10-09T09:44:56Z

Completed Course Work: update color

← Older revision		Revision as of 09:44, 9 October 2023
Line 105:		Line 105:
	select distinct ?course ?courseLabel ?user ?userLabel ?work ?workLabel ?rgb ?prof # ?course ?courseLabel		select distinct ?course ?courseLabel ?user ?userLabel ?work ?workLabel ?rgb ?prof # ?course ?courseLabel
	where {		where {
	values (?user) {(wd:Q157)}.		values (?user) { (wd:Q157) }.

	# get courses ?user participates in		# get courses ?user participates in
Line 117:		Line 117:
	optional {		optional {
	?user wdt:P12 ?work.		?user wdt:P12 ?work.
	bind (if(bound(?work), "~~79b965~~", "FFFFFF") as ?rgb). # work "		bind (if(bound(?work), "B2FF7B", "FFFFFF") as ?rgb). # work "
	}		}

Line 125:		Line 125:
	optional {		optional {
	?work wdt:P13 ?importance.		?work wdt:P13 ?importance.
	bind (if(?importance = wd:Q324, "~~e53935~~", "FFFFFF") as ?rgb).		bind (if(?importance = wd:Q324, "FF5F5C", "FFFFFF") as ?rgb).
	}		}

Leonie: /* Completed Course Work */ update query

2023-09-22T09:10:28Z

Completed Course Work: update query

← Older revision		Revision as of 09:10, 22 September 2023
Line 99:		Line 99:
	Returns all items, that are [[Item:Q463\|Course Work]], i.e need to be completed in order to pass the course. Completed items are marked <span style="color: green">green</span> and work, that is mandatory but has not been completed yet is marked <span style="color: red">red</span>. ''(Completed items are items that a student links to using the [[Property:P12\|has completed]]-Property.)''		Returns all items, that are [[Item:Q463\|Course Work]], i.e need to be completed in order to pass the course. Completed items are marked <span style="color: green">green</span> and work, that is mandatory but has not been completed yet is marked <span style="color: red">red</span>. ''(Completed items are items that a student links to using the [[Property:P12\|has completed]]-Property.)''
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=
			#defaultView:Graph
	#defaultView:Graph		#defaultView:Graph
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
	select distinct ?user ?userLabel ?work ?workLabel ?rgb ?prof		select distinct ?course ?courseLabel ?user ?userLabel ?work ?workLabel ?rgb ?prof # ?course ?courseLabel
	{		where {
	values (?user) {(wd:Q157)}		values (?user) {(wd:Q157)}.
	#~~values (~~?course~~) {(wd~~:~~Q171)}~~
	?work wdt:P3 wd:Q463. ~~# get all course Work~~		# get courses ?user participates in
			?user wdt:P25 ?course.

			# get all course Work from courses that ?user participates in
			?course wdt:P14 ?work.
			?work wdt:P3 wd:Q463.

	# Mark completed Items in green.		# Mark completed Items in green.
	optional {		optional {
	?user wdt:P12 ?work.		?user wdt:P12 ?work.
	bind (if(bound(?work), "79b965", "FFFFFF") as ?rgb). # work		bind (if(bound(?work), "79b965", "FFFFFF") as ?rgb). # work "
	}		}

Line 126:		Line 132:
	}}		}}
	'''NOTE:''' Currently works without specific courses, meaning that the Course Works has not yet been attributed to a specific course. There is also no certification by a lecturer.		'''NOTE:''' Currently works without specific courses, meaning that the Course Works has not yet been attributed to a specific course. There is also no certification by a lecturer.


	= Using the Graph yourself =		= Using the Graph yourself =

Leonie: /* A complete overview */ update color

2023-09-22T08:49:47Z

A complete overview: update color

← Older revision		Revision as of 08:49, 22 September 2023
Line 36:		Line 36:
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>

	SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel WHERE {		SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel ?rgb WHERE {
	VALUES ?item1 {wd:Q157}		VALUES ?item1 {wd:Q157}

	?item1 ?prop ?item2.		?item1 ?prop ?item2.
	?edge ?dummy ?prop ; rdf:type wikibase:Property		?edge ?dummy ?prop ; rdf:type wikibase:Property.

			# 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". }

Leonie: added: completed course work

2023-09-20T09:47:47Z

added: completed course work

@@ Line 89: / Line 89: @@
+}
 }}
 = Using the Graph yourself =
-If you want to visualize your own usage of the graph, try the queries down below. After clicking ''Try it'' all you need to do is swap out the Item: Q157 with your own item's number Q... and query the graph (or press CTRL+ENTER).
+If you want to visualize your '''own usage''' of the graph, try the queries down below. After clicking <span style="color:dodgerblue">Try it!</span> all you need to do is swap out the Item: Q157 with your own item's number Q... and query the graph (or press CTRL+ENTER).
@@ Line 147: / Line 179: @@
    OPTIONAL {?topic wdt:P11 ?image.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+}
 }}

Leonie: added: Completed Items

2023-09-19T15:19:26Z

added: Completed Items

@@ Line 13: / Line 13: @@
-The item itself needs '''further specifications''', such as a declaration that it is an [[Property:P3|instance of]] the [[Item:Q167|Student]]-Item, which course a student [[Property:P25|participates in]], and what items a student is [[Property:P23|interested in]] or [[Property:P12|has completed]]. As seen below:
+The item itself needs '''further specifications''', such as a declaration that it is an [[Property:P3|instance of]] the [[Item:Q167|Student]]-Item, which course a student [[Property:P25|participates in]], and what items a student is [[Property:P23|interested in]] or [[Property:P12|has completed]].
 {| class="wikitable" style="margin:auto; text-align:center;"
-| <Name> || — [[Property:P3|instance of]] &rarr; || [[Item:Q167|Student]]
+| Student-Item || — [[Property:P3|instance of]] &rarr; || [[Item:Q167|Student]]
 |-
 | Student-Item || — [[Property:P23|interested in]] &rarr; || Item
@@ Line 67: / Line 67: @@
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 } ORDER BY ?prop
 }}
@@ Line 107: / Line 128: @@
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 } ORDER BY ?prop
 }}

Leonie: /* A Student */ update

2023-09-19T15:00:44Z

A Student: update

← Older revision		Revision as of 15:00, 19 September 2023
Line 13:		Line 13:


	The item itself needs '''further specifications'', such as a declaration that it is an [[Property:P3\|instance of]] the [[Item:Q167\|Student]], which ~~Course~~ a student [[Property:P25\|participates in]], what items a student is [[Property:P23\|interested in]] or [[Property:P12\|has completed]]. As seen below:		The item itself needs '''further specifications''', such as a declaration that it is an [[Property:P3\|instance of]] the [[Item:Q167\|Student]]-Item, which course a student [[Property:P25\|participates in]], and what items a student is [[Property:P23\|interested in]] or [[Property:P12\|has completed]]. As seen below:

	{\| class="wikitable" style="margin:auto; text-align:center;"		{\| class="wikitable" style="margin:auto; text-align:center;"