Results 1 -
6 of
6
Online Assessment of SQL Query Formulation Skills
, 2003
"... Being able to formulate useful SQL queries is a fundamental skill required by many software development professionals. Mastering this skill is a difficult process, requiring considerable practice and effort on the part of the student. In addition, assessment of SQL query formulation skills is a pro ..."
Abstract
-
Cited by 4 (0 self)
- Add to MetaCart
Being able to formulate useful SQL queries is a fundamental skill required by many software development professionals. Mastering this skill is a difficult process, requiring considerable practice and effort on the part of the student. In addition, assessment of SQL query formulation skills is a process that does not appear to have been thoroughly researched, and numerous problems are inherent to the approaches commonly taken in universities to do this assessment. This paper examines two of these approaches, identifies problems with them, and then proposes another method of assessment. The way that students are assessed in a subject has a significant impact on their learning approach, and it is crucial that assessment tasks are carefully designed and implemented to inculcate a deep learning experience. The online assessment method proposed is described, evaluated, and the challenges and benefits of using it are discussed. This is a work-in-progress and the conclusion states that further validation is needed, and there is opportunity for additional research and development in this particular area of assessment .
ONLINE LEARNING AND FUN WITH DATABASES SUBMISSION
"... In this paper, we explore how online learning can support face-to-face teaching in fundamental database theory and the contributions it can make towards motivating and enhancing the student learning experience. We show how we have used WebCT for a third level database module and present student feed ..."
Abstract
-
Cited by 1 (1 self)
- Add to MetaCart
(Show Context)
In this paper, we explore how online learning can support face-to-face teaching in fundamental database theory and the contributions it can make towards motivating and enhancing the student learning experience. We show how we have used WebCT for a third level database module and present student feedback to our approach. While online participation is high overall, motivation for selflearning is increased by the use of self-assessment exercises and summative assessment was also considered to be more fun online than using paper based equivalents. Evidence exists to link greater online participation of course materials to improved performance. We complement our feedback by presenting and discussing a number of software tools which help students practice important methods in database systems, including SQL. After evaluating these against known methods for improving student motivation, we suggest ideas for further development of more game-like learning tools.
An Automatic Correction Tool for Relational Algebra Queries
- ICCSA
, 2007
"... Abstract. Relational algebra is one of the main topics covered in undergraduate computer science database courses. In this paper, we present a web-based tool designed to automatically correct relational algebra queries. The tool is integrated in a more general e-learning environment and is used to r ..."
Abstract
-
Cited by 1 (0 self)
- Add to MetaCart
(Show Context)
Abstract. Relational algebra is one of the main topics covered in undergraduate computer science database courses. In this paper, we present a web-based tool designed to automatically correct relational algebra queries. The tool is integrated in a more general e-learning environment and is used to reinforce teaching and learning on introductory database courses. A teacher enters relational algebra problems into the system and it generates personalized workbooks with different relational algebra exercises for each student. Students solve these exercises using a specifically designed interface. They enter relational algebra expressions to solve the assigned queries and the system provides immediate feedback and, when there are errors, advise about how to correct them. Only a web browser is required to use the tool, which has been used in our university with very promising results. 1
Do students SQLify? Improving Learning Outcomes with Peer Review and Enhanced Computer Assisted Assessment of Querying Skills
"... In recent years a small number of web-based tools have been proposed to help students learn to write SQL query statements and also to assess students ' SQL writing skills. SQLify is a new SQL teaching and assessment tool that extends the current state-of-the-art by incorporating peer review and ..."
Abstract
- Add to MetaCart
(Show Context)
In recent years a small number of web-based tools have been proposed to help students learn to write SQL query statements and also to assess students ' SQL writing skills. SQLify is a new SQL teaching and assessment tool that extends the current state-of-the-art by incorporating peer review and enhanced automatic assessment based on database theory to produce more comprehensive feedback to students. SQLify is intended to yield a richer learning experience for students and reduce marking load for instructors. In this paper SQLify is compared with existing tools and important new features are demonstrated.
H. INFORMATION SYSTEMS
"... This paper examines the effect of grading approaches for SQL query formulation on students ’ learning strategies. The way that students are graded in a subject has a significant impact on their learning approach, and it is crucial that graded tasks are carefully designed and implemented to inculcate ..."
Abstract
- Add to MetaCart
(Show Context)
This paper examines the effect of grading approaches for SQL query formulation on students ’ learning strategies. The way that students are graded in a subject has a significant impact on their learning approach, and it is crucial that graded tasks are carefully designed and implemented to inculcate a deep learning experience. An online examination system is described and evaluated.
Relational Algebra and SQL Query Visualisation
, 2010
"... Relational algebra and the industry standard SQL are core topic covered in un-dergraduate database courses. Database management systems translate SQL state-ments into a procedural query plan composed with operations similar to those that arise in relational algebra. Learning relational algebra makes ..."
Abstract
- Add to MetaCart
(Show Context)
Relational algebra and the industry standard SQL are core topic covered in un-dergraduate database courses. Database management systems translate SQL state-ments into a procedural query plan composed with operations similar to those that arise in relational algebra. Learning relational algebra makes students familiar with this process. Moreover they understand the difference between procedural and declarative query languages. Students that understand the relation between the two languages have the required knowledge to query databases. Additionally, it is equally important to appreciate the difference in expressiveness of the two languages and that SQL is a superset of relational algebra. Currently there is no tool that can execute both types of queries and show the relation of the two in terms of the execution process. As a result students exercise on the two languages independently and do not acquire crucial knowledge which is useful in constructing optimised queries. Moreover, the available tools that support relational algebra fail to show the difference between basic and derived operations
