Carnegie Mellon University

Eberly Center

Teaching Excellence & Educational Innovation

Program Using Jupyter Notebook To Teach SQL

Learning to formulate a solution in software is an experimental
process: form a conceptual solution, develop code to realize the
solution, test the code, and repeat. Along the way, both a student
and an instructor would like to tinker with and tweak the code as they
explore the solution space.
The Jupyter Notebook is an open-source browser based application that
allows you to create and explore documents that contain live code,
equations, visualizations and explanatory text. The Jupyter notebook
has conventionally been used to teach courses in data science and
machine learning. For the past year we've been exploring the use of
the notebook to teach SQL programming.
The notebook is used for in class demonstrations, lab exercises, and
home work assignments. Both students and the instructor have found it
to be an effective learning environment. During the summit, I plan
will highlight the pedagogical features offered by the notebook to
experimentally evolve a solution and to explore the solution space."
"This demo shows how clickers are being used in Nature of Language, a large
introductory survey course in linguistics. Clickers are used to engage students in active
learning during lectures, which is a particular challenge due to the size of the course
(120 students) and time constraints (two 50 min. lectures/week).
Clickers are used in two ways. First, students are quizzed every class on recent
material, to help them keep up and provide them with immediate feedback. Second,
clickers are used in combination with paired discussions in activities designed to extend
core course concepts.
I will demonstrate participation activities, and Summit participants will interact with the
demo by answering poll questions and discussing them with the host. I will bring my
computer, clicker base, and a few iClickers so that participants can vote on sample poll

Sooriamurthi, Raja
DC, Information Systems