Courses/CGBV - Revision history

Leonie: /* Anzahl der Abhängigkeiten */ update query to exclude non-course items

2024-01-16T14:49:56Z

Anzahl der Abhängigkeiten: update query to exclude non-course items

← Older revision		Revision as of 14:49, 16 January 2024
Line 63:		Line 63:
	}		}
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
			?item wdt:P2 ?category.
			?category wdt:P3 wd:Q169.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}\|caption=The importance of topics using the amount of times its linked to as a prerequisite		}\|caption=The importance of topics using the amount of times its linked to as a prerequisite

2024-01-16T14:28:09Z

Grundlagen: update query to exclude non-course items

← Older revision		Revision as of 14:28, 16 January 2024
Line 42:		Line 42:
	}		}
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
			?item wdt:P2 ?category.
			?category wdt:P3 wd:Q169.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}\|caption=Shows the fundational topics of the course		}\|caption=Shows the fundational topics of the course

2024-01-16T14:24:54Z

Zeitstrahl der in Vorlesungen behandelten Inhalte: update query to remove non-course items

← Older revision		Revision as of 14:24, 16 January 2024
Line 15:		Line 15:
	select distinct ?item ?itemLabel ?date ?image #?dependency ?dependencyLabel		select distinct ?item ?itemLabel ?date ?image #?dependency ?dependencyLabel
	where {		where {
			wd:Q171 wdt:P14 ?session.
			?session wdt:P3 wd:Q427.
	?session wdt:P14 ?item.		?session wdt:P14 ?item.
	MINUS {?item wdt:P20 ?url.}		MINUS {?item wdt:P20 ?url.}
	MINUS {?session wdt:P3 wd:Q162.}		MINUS {?session wdt:P3 wd:Q162.}
	~~# OPTIONAL {?item wdt:P1 ?dependency.}~~
	OPTIONAL {?item wdt:P11 ?image.}		OPTIONAL {?item wdt:P11 ?image.}
	?session wdt:P19 ?date.		?session wdt:P19 ?date.

2023-10-09T07:53:30Z

Anzahl der Abhängigkeiten: update query (caption)

← Older revision		Revision as of 07:53, 9 October 2023
Line 62:		Line 62:
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}\|caption=The importance of topics using the amount of times its linked to as a prerequisite
	}}		}}

2023-10-09T07:49:17Z

Grundlagen: update query (style+caption)

← Older revision		Revision as of 07:49, 9 October 2023
Line 43:		Line 43:
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}\|caption=Shows the fundational topics of the course
	}}		}}

2023-10-09T07:25:04Z

Zeitstrahl der in Vorlesungen behandelten Inhalte: adjust height

← Older revision		Revision as of 07:25, 9 October 2023
Line 24:		Line 24:

	service wikibase:label { bd:serviceParam wikibase:language "en".}		service wikibase:label { bd:serviceParam wikibase:language "en".}
	}		}\|height=96vh\|caption=Timeline of the SS23 CGBV course modeled over several sessions
	}}		}}

2023-09-19T14:46:17Z

Grundlagen: update query

← Older revision		Revision as of 14:46, 19 September 2023
Line 38:		Line 38:
	SELECT ?prerequisite ?prerequisiteLabel (COUNT(DISTINCT ?item) as ?dependencies) WHERE {		SELECT ?prerequisite ?prerequisiteLabel (COUNT(DISTINCT ?item) as ?dependencies) WHERE {
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
	} GROUP BY ?prerequisite ?prerequisiteLabel		} GROUP BY ?prerequisite ?prerequisiteLabel
			having (count(?item) > 5)
	}		}
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.

2023-09-19T14:44:05Z

Grundlagen: added: Anzahl Abhängigkeiten

← Older revision		Revision as of 14:44, 19 September 2023
Line 39:		Line 39:
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
	} GROUP BY ?prerequisite ?prerequisiteLabel		} GROUP BY ?prerequisite ?prerequisiteLabel
	~~having (count(?item) > 5)~~
	}		}
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
Line 45:		Line 44:
	}		}
	}}		}}
	Hier ~~noch~~ einmal ein Überblick ~~nur~~ über die ~~Grundlagen~~
			== Anzahl der Abhängigkeiten ==
			Hier einmal ein visueller Überblick über die "Wichtigkeit" der Lerninhalte. Hier wird angezeigt, wie viele Inhalte von einem Item anhängen. Je öfter ein Item als als Vorwissen zu einem anderen gebraucht wird, desto größer ist es.
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=
	#defaultView:BubbleChart		#defaultView:BubbleChart
Line 51:		Line 52:
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>

	SELECT DISTINCT ?prerequisite ?prerequisiteLabel ?dependencies ~~#?item ?itemLabel~~		SELECT DISTINCT ?prerequisite ?prerequisiteLabel ?dependencies
	WHERE {		WHERE {
	{		{
Line 57:		Line 58:
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.
	} GROUP BY ?prerequisite ?prerequisiteLabel		} GROUP BY ?prerequisite ?prerequisiteLabel
	~~having (count(?item) > 5)~~
	}		}
	?item wdt:P1 ?prerequisite.		?item wdt:P1 ?prerequisite.

2023-09-19T14:38:52Z

Kursüberblick

@@ Line 35: / Line 35: @@
 SELECT DISTINCT ?prerequisite ?prerequisiteLabel ?dependencies ?item ?itemLabel WHERE {
+   {
    SELECT ?prerequisite ?prerequisiteLabel (COUNT(DISTINCT ?item) as ?dependencies) WHERE {

2023-09-19T14:19:18Z

Übersicht

← Older revision		Revision as of 14:19, 19 September 2023
Line 46:		Line 46:
	}}		}}

	== Übersicht ==		=== Übersicht ===
	Eine Übersicht über den '''gesamten''' Kurs kann über die nächste Query angesehen werden:		Eine Übersicht über den '''gesamten''' Kurs kann über die nächste Query angesehen werden:
	{{SPARQL2\|query=		{{SPARQL2\|query=