SQL for Data Analytics · Instructor resources

Instructor resources

What this is

This unit is for instructors. If you're a student, there's nothing here you need.

This site is the whole course: the videos, the written lessons, the interactive pieces, and the practice students turn in. Canvas holds the due dates, the assignments students upload to, announcements, and grades. I built it this way because I teach large online sections without a TA, and I wanted practice that checks itself, gives students feedback right away, and leaves me something I can look at when I need to.

If you teach this course, or you'd like to use the same setup for a different one, these pages explain how it works.

  1. How the site works. Lessons, practice, how answers are checked, and what a student turns in.
  2. Setting up Canvas. What goes in the Canvas shell, with the links and embed codes for every page.
  3. Checking submissions. What's in a submission file, and how the grading tool works.
  4. Grading tool. The tool itself. Worth bookmarking: courses.kellerflint.com/tools/grader.

The site's code is in a private repository, because the answers to the practice questions are in it. If you'd like access, email me at kflint-blanchard@greenriver.edu.