SQLator: An online SQL learning workbench

SQL (Structured Query Language) is one of the essential topics in foundation databases courses in higher education. Due to its apparent simple syntax, learning to use the full power of SQL can be a very difficult activity. In this paper, we introduce SQLator, which is a web-based interactive tool for learning SQL. SQLator's key function is the evaluate function, which allows a user to evaluate the correctness of his/her query formulation. The evaluate engine is based on complex heuristic algorithms. The tool also provides instructors the facility to create and populate database schemas with an associated pool of SQL queries. Currently it hosts two databases with a query pool of 300+ across the two databases. The pool is divided into 3 categories according to query complexity. The SQLator user can perform unlimited executions and evaluations on query formulations and/or view the solutions. The SQLator evaluate function has a high rate of success in evaluating the user's statement as correct (or incorrect) corresponding to the question. We will present in this paper, the basic architecture and functions of SQLator. We will further discuss the value of SQLator as an educational technology and report on educational outcomes based on studies conducted at the School of Information Technology and Electrical Engineering, The University of Queensland.

Suit keen renovator: Alternate reality design

Virtual territories and their theme parks are more akin to the physical world of real estate than they might at first appear. The trick in triggering the designer's imagination, is to find a 'nice renovator' (cottage/ house) at a low price, with loads of potential, and by doing it on the cheap to add character, and engage the imagination. Here the designer can construct changes from an imagined space. Vision is more important than how the actual place presents.This work describes a case study involving undergraduate students in the Creative Industries who needed a place to explore, so as to create their own visions and projects. The place had to inspire, trigger engagement, and their imaginations. At the same time it was important that the place did not coerce activity, or distract from the task by confusing tools with task, or architectural navigation with conceptual skills.The solution was an alternate reality.

Virtual teachers: Negotiating new spaces for teaching bodies

In 2002, the authors reviewed the educational performance of a state education department virtual schooling service during its first 2 years of operation, 2000-2001 (Pendergast, Kapitzke, Land, Luke, & Bahr, 2002). Established by Education Queensland, the Virtual Schooling Service (VSS) utilises synchronous and asynchronous online delivery strategies and a range of learning technologies to support students at a distance (see http://education.qld.gov.au/learningplace/vss/). The service commenced with a focus on senior secondary subjects. At present, there are over 700 students in 89 schools across the state enrolled in 9 subjects. In response to the recommendations of the study, a series of professional development activities were conducted with the VSS teachers by the authors. Opportunity for critical reflection was provided, including consideration of the ways in which the teachers were developing as a learning community. Some data, including visual representations, were collected from participants with the purpose of understanding how VSS teachers are constructed as professionals. This study compares and contrasts that data with self-constructions of teacher professionals in other fields.