SQL Noir

#learning #gamification #sql #sqlnoir

• SQL Noir - весьма интересное решение для изучения SQL в виде текстовой игры. По сюжету вы будете выступать в роли детектива, которому необходимо решить определённый пул задач, анализируя улики в базе данных.

• Задачи разделены на три уровня: для начинающих, продолжающих и продвинутых пользователей. Сейчас доступно четыре дела, которые предстоит раскрыть. Если получается найти решение, то вы получаете баллы, которые открывают доступ к более сложным задачам. К слову, на GitHub (https://github.com/hristo2612/SQLNoir) есть подробная инструкция для тех, кто хочет разработать и опубликовать собственную задачу.

Проект полностью бесплатный: https://www.sqlnoir.com

I just stumble on the article "Gamification makes about as much sense as chocolate-dipped broccoli" by @ASegar
https://www.conferencesthatwork.com/index.php/event-design/2021/02/gamification-chocolate-dipped-broccoli/

It resonates so strongly with me. For me #gamification has such a strong manipulative touch, introduces vanity metric and often is based on competition

And don't get me wrong. I'm a big fan of games in a professional setting (and my job)
But as #SeriousGames or playful interventions.

Examples for a Serious Games are emergency drills and exercises. They create a save environment to experience certain elements of reality and enable collective learning.
Are they fun? Not necessarily, or probably not. YOu will experience stress and anxiety like it would be real. But the designe of the Game/simulation can control this. And possibly they are "fun" in hindsight. You have a laugh on what went catastrophically wrong (but nobody got harmed because it was a game)

Playful interventions are "games" or activities which are completely unrelated to the task at hand. They can be used to cause a "reset", let you get away from a intellectual exercise to something physical and through this enable new perspectives or a "fresh start"
Examples would be #HappySalmon or #BodySongs

But not every Playful intervention fits for everyone

I'm looking forward to the @play4agile to discover new possibilities fror both

Spielerisch fürs Klima strampeln? Klingt gut – klappt sogar!
#Stadtradeln zeigt: Mit kleinen Challenges kommen viele aufs Rad.
Doch langfristig gilt:
Veränderung braucht mehr als drei Wochen
Punkte sind nett, aber Überzeugung fährt weiter
Und ohne gute Radwege hilft auch die beste App nicht

#Gamification #Fahrrad #Klimaschutz #Mobilitätswende
http://www.taz.de/!6101585/

In der Stadt Zürich gibt es einen Pilotversuch bei dem Menschen spielerisch über eine App motiviert werden herum liegenden Müll aufzusammeln

https://www.tagesanzeiger.ch/innovatives-projekt-aus-zuerich-mit-der-plattform-zsuber-wird-das-muellsammeln-zum-spiel-mit-belohnungen-506763809309

Pulling together the #shownotes in #ChapelHill for Monday’s posting of e522 for @gamesatwork_biz with @michaelrowe01 and @andypiper. Stories and discussion on #AI with #bees that listen & a #cat that #chats and then some fun drawing #fish, anticipating a #LEGO #GameBoy build and more! Check out earlier episodes, chock full of #AI #metaverse #AR #VR #gamification and so much more on https://www.gamesatwork.biz

Ukraine's 'Army of Drones: Bonus' system awards points for military targets, but the real high score comes from encouraging surrender (10x multiplier!). Turns out even in actual warfare, the optimal strategy is convincing your opponent to put down the controller.

https://tech.slashdot.org/story/25/07/20/1714257/kill-russian-soldiers-win-points-is-ukraines-new-drone-scheme-gamifying-war

Do general practitioners in the Netherlands know enough about diabetes to treat the growing number of patients? We've built a gamified learning tool for healthcare professionals with RadboudUMC, Schola Medica and Grafische Republiek.

Read about it here: https://tweedegolf.nl/en/blog/159/building-a-gamified-learning-tool-for-healthcare-professionals

@radboudumc

Tarot Freecell, my very first #glamhack project, coded during the first Swiss Open Cultural Data #Hackathon 10 years ago at the Swiss National #Library in Berne. Still quite a challenge to play.

https://www.thomasweibel.ch/tarot-freecell/

@Orixon è lieta di annunciare le ultime novità a tema #chat:

https://blog.orixon.org/orixon3-0/

Il nuovo Orixon 3.0 - IRC come non lo hai visto prima.

Scopri le novità sulle nostre #WebChat Disponibile da oggi per tutti i partner!

Great oaks from little acorns grow: Ein Hub - 12 Editoren für Minigames in #Moodle.

Fachschaft darf testen - aber irgendwie bin ich mir relativ sicher, dass die 8er die zuverlässigeren Bug-Ausschnüffler sein werden...

StreetComplete, https://streetcomplete.app/.

A mobile app (Android only for the moment) that helps finding missing OpenStreetMap data around you, and displays them like quests ! Given information are automatically added to OSM under your name.

It’s so cool!

FAQ: https://wiki.openstreetmap.org/wiki/StreetComplete/FAQ
iOS: NLNet is sponsoring iOS support, https://github.com/streetcomplete/StreetComplete/issues/5421#issuecomment-2849221573

@Sascha_Raubal @angeldruckt

Danke Euch, doch #Feloai scheint sich sehr sicher zu sein!

"Die Solarpunk-Bewegung lässt sich im Fediversum als ein dezentrales, kollaboratives Alternate Reality Game (ARG) verstehen und gestalten. Dieser Ansatz verbindet die optimistische Zukunftsvision des Solarpunk mit den partizipativen und realweltlichen Mechanismen von ARGs." (Druko 175455) #Solarpunk #Fediversum #ARG #Gamification #Spieltheorie #GameStudies #KI https://scilogs.spektrum.de/natur-des-glaubens/dualistische-superyacht-vs-monistische-arche-wie-ueberleben-menschen-die-mitweltkrise/#comment-175455