Courses/Wissenschaftliches Arbeiten SS24/Graph - Revision history

Leonie: /* Interests & Knowledge */ convert to Try It!

2024-05-23T11:54:28Z

Interests & Knowledge: convert to Try It!

← Older revision		Revision as of 11:54, 23 May 2024
Line 8:		Line 8:
	\|-		\|-
	<!-- Linke Spalte -->		<!-- Linke Spalte -->
	\| style="width: 50%" \| {{~~#widget:SPARQLquery~~\|~~code~~=		\| style="width: 50%" \| {{SPARQL2\|query=
	#defaultView:ReScatterChart		#defaultView:ReScatterChart
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 36:		Line 36:
	}}		}}
	<!-- Rechte Spalte -->		<!-- Rechte Spalte -->
	\| style="width: 50%" \| {{~~#widget:SPARQLquery~~\|~~code~~=		\| style="width: 50%" \| {{SPARQL2\|query=
	#defaultView:ReScatterChart		#defaultView:ReScatterChart
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>

Leonie: /* Interests & Knowledge */ (update title)

2024-05-23T09:39:49Z

Interests & Knowledge: (update title)

← Older revision		Revision as of 09:39, 23 May 2024
Line 5:		Line 5:
	<!-- Floated Table that contains both orphan queries(32.5em)-->		<!-- Floated Table that contains both orphan queries(32.5em)-->
	{\| class="wikitable"		{\| class="wikitable"
	! '''~~Unlinked Items~~''' !! '''~~No dependencies~~'''		! '''WissArb 23/24 Winter Term''' !! '''WissArb 24 Summer Term'''
	\|-		\|-
	<!-- Linke Spalte -->		<!-- Linke Spalte -->
Line 33:		Line 33:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	~~\|caption=WissArb 23/24 Winter Term~~
	\|height=30vh		\|height=30vh
	}}		}}
Line 62:		Line 61:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	~~\|caption=WissArb 24 Summer Term~~
	\|height=30vh		\|height=30vh
	}}		}}
	\|}		\|}

Leonie: created page + added compairison query (for knowledge & interest)

2024-05-23T09:36:17Z

created page + added compairison query (for knowledge & interest)

New page

Contains queries about the graph of the "Wissenschaftliches Arbeiten SS24" course to help debug and structure it.

== Interests & Knowledge ==
Compairing the 23/24 WS version with the 24SS Version of the course

{| class="wikitable"
! '''Unlinked Items''' !! '''No dependencies'''
|-

| style="width: 50%" | {{#widget:SPARQLquery|code=
#defaultView:ReScatterChart
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>

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

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|caption=WissArb 23/24 Winter Term
|height=30vh
}}

| style="width: 50%" | {{#widget:SPARQLquery|code=
#defaultView:ReScatterChart
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>

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

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|caption=WissArb 24 Summer Term
|height=30vh
}}
|}