Español

For teachers

← Caso Abierto for the classroom

How to use it in Nearpod, Classroom, Moodle and Canvas

Steps to add the SQL arcade and the cases to your teaching platform. No student accounts and nothing to install: all it takes is a link.

Everything opens from a link, with no student accounts. Copy the link for your platform: it carries a tag so we know where the visit came from, nothing else. Menu names change between versions of each platform, so you may see a different one.

Nearpod

A real class has already reached the arcade from Nearpod.

  1. Open your lesson and choose to add content.
  2. Select Web Content.
  3. Paste the link below and save.
  4. If your school blocks pages inside frames, paste the link as text on a slide so students open it in another tab.

Arcade link for this platform

https://casoabiertogame.com/arcade?via=aula-nearpod

Google Classroom

  1. Go to Classwork and click Create.
  2. Choose Material or Assignment and add a title.
  3. Under Add, choose Link and paste the link.
  4. Post it. If it's an assignment, ask for the certificate code as the submission.

Arcade link for this platform

https://casoabiertogame.com/arcade?via=aula-classroom

Moodle

  1. Turn editing on in your course.
  2. Click Add an activity or resource and choose URL.
  3. Paste the link under External URL.
  4. Under Appearance, choose to open it in a new window if your site allows it: embedding external pages doesn't always work in Moodle.

Arcade link for this platform

https://casoabiertogame.com/arcade?via=aula-moodle

Canvas

  1. Go to Modules and click the module's +.
  2. Choose External URL and paste the link.
  3. Tick Load in a new tab and add it.

Arcade link for this platform

https://casoabiertogame.com/arcade?via=aula-canvas

Other activities you can link

SQL arcadeFrom zero, no typing: students build the query with tiles.Case 00: The First QueryWith a guided tutorial and a single table.Case 01: The File Nobody Asked ForTwo tables and a time window.SQL cheat sheetOne page to print.

Worth knowing before class

Want the answer key?

The worksheet answers and the solutions to all 28 cases aren't published, so students won't find them. Write to us from your institutional email and we'll send them, at no cost.

Request the answer key

The arcade, the lessons and the first two cases are free and need no account. For your group to have all 28 cases, the classroom license is free too: how to request it →