Breakout Presentation

 

Presented by

Chris Anderson
Head of Computer Science, Christ Church Grammar School

SQLite is a full featured yet light weight SQL database engine that is perfect for use in the classroom.

Simple to install and easy to use, it allows you to quickly create a full featured SQL database without the need to set up complex servers.

Since all the internal structures are kept inside a single file, it is easy to transfer between computers and does not require a server to be set up.

Most common programming languages come with easy to use SQLite modules, making it a flexible way of teaching database concepts in the classroom using SQL.

In this workshop we will explore how to use SQLite to teach database design in an engaging manner.

We will work through a series of activities designed to introduce students to databases through simple queries. We will then create a simple database, highlighting concepts from the ATAR syllabus such as data types, primary and foreign keys, entity, domain and referential integrity, and relationships.

Once we have worked through the fundamentals, we will discuss a number of methods to create a suitable user interface and how using an open ended project enables students to improve their understanding of database design in an engaging manner.

Although it is possible to use SQLite with a variety of languages, the activities that we will work through in this hands-on session will use Python 3 so it is recommended that you have this installed on your computer prior to the commencement of the session.

Chris Anderson has kindly made the slides for his presentation available at  https://tinyurl.com/ycr9hudj

 

Requirements:

To participate fully in this workshop, BYO computer with Python 3 already installed before you arrive at the Conference venue.

 

Intended Audience:

Those interested in STEM, Middle School, Senior Secondary

 

About the Presenter:

After completing a BSc in Computer Science and Psychology at UNSW, Chris worked as a software developer for 10 years in Sydney.

Seeking a change of scenery, he moved to Perth in 2006 to pursue a career in teaching.

Chris is currently Head of Computer Science at Christ Church Grammar School and is always keen to look at new ways to teach young people about computers, in particular encouraging creativity and problem solving through programming..

Join Chris Anderson at the ECAWA 2017 State Conference at ECU Mount Lawley.