Courses/CGBV SS24/Graph - Revision history

Leonie: /* "Interests" and "Knowledge" */ convert to Try It!

2024-05-23T11:53:37Z

"Interests" and "Knowledge": convert to Try It!

← Older revision		Revision as of 11:53, 23 May 2024
Line 163:		Line 163:
	== "Interests" and "Knowledge" ==		== "Interests" and "Knowledge" ==
	{{Note\|text=The plot doesn't really show overlapping points}}		{{Note\|text=The plot doesn't really show overlapping points}}
	{{~~#widget:SPARQLquery~~\|~~code~~=		{{SPARQL2\|query=
	#defaultView:ScatterChart		#defaultView:ScatterChart
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>

Leonie: /* "Interests" and "Knowledge" */ add alternative query + legend

2024-05-07T13:45:15Z

"Interests" and "Knowledge": add alternative query + legend

← Older revision		Revision as of 13:45, 7 May 2024
Line 187:		Line 187:
	}		}
	}}		}}

			'''Alternative Visualization'''
			{{#widget:SPARQLquery\|code=
			#defaultView:Graph
			PREFIX wd: <https://graphit.ur.de/entity/>
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>

			SELECT DISTINCT ?sum ?item ?itemLabel ?rgb ?known ?interests
			WHERE {
			wd:Q932 wdt:P14/wdt:P14 ?item.
			OPTIONAL {
			SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?known) WHERE {
			?student wdt:P12 ?item.
			} GROUP BY ?item ?itemLabel
			}
			OPTIONAL {
			SELECT ?item ?itemLabel (COUNT(DISTINCT ?student) as ?interests) WHERE {
			?student wdt:P23 ?item.
			} GROUP BY ?item ?itemLabel
			}.
			BIND (IF(!BOUND(?interests), 0, ?interest) as ?interests).
			BIND (IF(!BOUND(?known), 0, ?known) as ?known).
			BIND ( ?interests + ?known as ?sum)

			# STYLING #
			BIND (if(?interests = 0 && ?known = 0, "FFFFFF", # white
			if(?interests = ?known, "DFDFDF", # grey
			if(?interests = 1 && ?known = 0, "e3ffd9", # light green
			if(?interests = 0 && ?known = 1, "F9DCDF", # light red
			if(?interests+1 = ?known, "BECF96", # red+green -> both
			if(?interests < ?known, "9FE586", # green, bc. knowledge is "good" :D
			if(?interests > ?known, "F0A8AF", # red
			"FFFFFF" ))))))) as ?rgb).

			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			} ORDER BY DESC(?sum)
			}}
			<span style="background-color:#F0A8AF">'''Interests'''</span> and <span style="background-color:#9FE586">'''knowledge'''</span> are mapped to color and to size.
			The '''size''' equals to the sum of interest and knowledge.

			A <span style="background-color:#F0A8AF">red</span> node means that '''more''' students are <span style="background-color:#F0A8AF">interested</span> in a topic.
			A <span style="background-color:#9FE586">green</span> node means that '''more''' students <span style="background-color:#9FE586">know</span> a topic.

			A <span style="background-color:#BECF96">olive</span> node means that '''one more''' student knows a topic than are interested in.

			A <span style="background-color:#DFDFDF">gray</span> node meant that the '''same''' amount of students know/are interested in a topic

Leonie: /* "Interests" and "Knowledge" */ fix typo

2024-05-07T12:45:20Z

"Interests" and "Knowledge": fix typo

← Older revision		Revision as of 12:45, 7 May 2024
Line 162:		Line 162:

	== "Interests" and "Knowledge" ==		== "Interests" and "Knowledge" ==
	{{Note\|text=The plot doesn't show ~~overlappind point~~}}		{{Note\|text=The plot doesn't really show overlapping points}}
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=
	#defaultView:ScatterChart		#defaultView:ScatterChart

Leonie: /* "Interests" and "Knowledge" */ added query

2024-05-06T11:05:51Z

"Interests" and "Knowledge": added query

@@ Line 158: / Line 158: @@
    service wikibase:label { bd:serviceParam wikibase:language "en". }
+}
 }}

Leonie: added degree query

2024-05-03T09:04:09Z

added degree query

@@ Line 30: / Line 30: @@
 Returns a graph with all categories '''included in''' the course.
 See the query '''[https://tinyurl.com/yorv5zu2 here]'''
 == Items ==

Leonie: /* Orphans */

2024-05-03T07:36:01Z

Orphans

← Older revision		Revision as of 07:36, 3 May 2024
Line 34:		Line 34:

	=== Orphans ===		=== Orphans ===
	~~Returns all items included in the course,~~ that ~~don~~'~~t depend on other items and aren~~'~~t depended on by other items.~~
	{{#widget:SPARQLquery\|code=		<!-- Floated Table that contains both orphan queries(32.5em)-->
			{\| class="wikitable"
			! '''Unlinked Items''' !! '''No dependencies'''
			\|-
			<!-- Linke Spalte -->
			\| style="width: 50%" \| {{#widget:SPARQLquery\|code=
	# All items that don't link to another item (no dependency)		# All items that don't link to another item (no dependency)
	#defaultView:Table		#defaultView:Table
	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 ?~~source~~ ?~~sourceLabel~~ ?dependency		SELECT DISTINCT ?item ?itemLabel # ?dependency
	WHERE {		WHERE {

	wd:Q932 wdt:P14/wdt:P14 ?~~source~~.		wd:Q932 wdt:P14/wdt:P14 ?item.

	MINUS {?dependency wdt:P1 ?~~source~~}. # Remove all items that have the ?source as a dependency		MINUS {?dependency wdt:P1 ?item}. # Remove all items that have the ?source as a dependency
	MINUS {?~~source~~ wdt:P1 ?dependency}. # Remove all ?source's that have a dependency		MINUS {?item wdt:P1 ?dependency}. # Remove all ?source's that have a dependency

			service wikibase:label { bd:serviceParam wikibase:language "en" }
			}
			\|caption=Items that don't depend on and aren't depended on
			\|height=25vh
			}}
			<!-- Rechte Spalte -->
			\| style="width: 50%" \| {{#widget:SPARQLquery\|code=
			#defaultView:Table
			# sources that don't -depend-on-> other item
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>
			SELECT DISTINCT ?item ?itemLabel # ?dependency
			WHERE {

			wd:Q932 wdt:P14/wdt:P14 ?item.
			MINUS {?item wdt:P1 ?dependency.}

	service wikibase:label { bd:serviceParam wikibase:language "en" }		service wikibase:label { bd:serviceParam wikibase:language "en" }
	}		}
			\|caption=Items that don't depend on other items
			\|height=25vh
	}}		}}
			\|-
			<!-- Linke Spalte -->
			\| [https://tinyurl.com/2aryewso Link to the query]
			<!-- Rechte Spalte -->
			\| [https://tinyurl.com/2c2sm43y Link to the query]
			\|}

	=== Resources ===		=== Resources ===

Leonie: /* Items */ add orphan query

2024-05-03T07:21:51Z

Items: add orphan query

@@ Line 32: / Line 32: @@
 == Items ==
 === Resources ===
 ==== All Resources ====

Leonie: /* All Categories */ fix typo

2024-05-03T07:16:03Z

All Categories: fix typo

← Older revision		Revision as of 07:16, 3 May 2024
Line 28:		Line 28:

	== All Categories ==		== All Categories ==
	Returns a graph with all '''included in''' the course.		Returns a graph with all categories '''included in''' the course.
	See the query '''[https://tinyurl.com/yorv5zu2 here]'''		See the query '''[https://tinyurl.com/yorv5zu2 here]'''

Leonie: /* Resources */ update with second query

2024-05-03T07:15:37Z

Resources: update with second query

@@ Line 33: / Line 33: @@
 == Items ==
 === Resources ===
 Returns a table with all resources that are linked to from inside the course.
-{{#widget:SPARQLquery|code=
 #defaultView:Table
 PREFIX wdt: <https://graphit.ur.de/prop/direct/>
@@ Line 50: / Line 52: @@
    service wikibase:label { bd:serviceParam wikibase:language "en" }
 } ORDER BY ASC(?resourceLabel)
 }}

Leonie: /* Resources */ add query

2024-05-02T09:32:02Z

Resources: add query

← Older revision		Revision as of 09:32, 2 May 2024
Line 30:		Line 30:
	Returns a graph with all '''included in''' the course.		Returns a graph with all '''included in''' the course.
	See the query '''[https://tinyurl.com/yorv5zu2 here]'''		See the query '''[https://tinyurl.com/yorv5zu2 here]'''

			== Items ==
			=== Resources ===
			Returns a table with all resources that are linked to from inside the course.
			{{#widget:SPARQLquery\|code=
			#defaultView:Table
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>
			SELECT DISTINCT ?item ?itemLabel ?resource ?resourceLabel ?alias ?url ?type ?typeLabel # ?resLabelLength
			WHERE {
			wd:Q932 wdt:P14/wdt:P14 ?item.
			?item wdt:P21 ?resource.
			OPTIONAL {?resource wdt:P20 ?link.
			BIND("true" as ?url) }

			OPTIONAL {?resource wdt:P3 ?type.}
			OPTIONAL {?resource skos:altLabel ?alias.}

			service wikibase:label { bd:serviceParam wikibase:language "en" }
			} ORDER BY ASC(?resourceLabel)
			}}