ABSTRACT
The author's approach in teaching databases, focuses on acquiring competences needed to use and develop systems of realistic complexity, typical for a micro or small company. Each student works towards gaining experience with various database designs and implementations, querying and development of relational schemas, and building applications. An open-source system is introduced, intended to help teachers organize such courses at a scale, and effectively guide the students in an iterative process of acquiring competencies, at the level of smaller groups or even individuals. The main goal of the system is speed-up of administrative tasks at all levels. The system implements the core process of organizing exams in a partial and piece-wise manner, and implements sets of tools and practices for semi-automated assessment processes.
- Anthony Kleerekoper and Andrew Schofield. 2018. SQL Tester: An Online SQL Assessment Tool and Its Impact. In Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education (ITiCSE 2018). ACM, New York, NY, USA, 87--92. https://doi.org/10.1145/3197091.3197124Google ScholarDigital Library
- Aristotelis Leventidis, Jiahui Zhang, Cody Dunne, Wolfgang Gatterbauer, H.V. Jagadish, and Mirek Riedewald. 2020. QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster. In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data (SIGMOD '20). Association for Computing Machinery, New York, NY, USA, 2303--2318. https://doi.org/10.1145/3318464.3389767Google ScholarDigital Library
- Joshua License. 2017. testSQL: Learn SQL the Interactive Way . In Proceedings of the 2017 ACM Conference on Innovation and Technology in Computer Science Education (ITiCSE '17). ACM, New York, NY, USA, 376--376. https://doi.org/10.1145/3059009.3072991Google ScholarDigital Library
- Antonija Mitrovic. 1998. Learning SQL with a Computerized Tutor. In Proceedings of the Twenty-ninth SIGCSE Technical Symposium on Computer Science Education (SIGCSE '98). ACM, New York, NY, USA, 307--311. https://doi.org/10.1145/273133.274318Google ScholarDigital Library
- Julia R. Prior. 2014. AsseSQL: An Online, Browser-based SQL Skills Assessment Tool. In Proceedings of the 2014 Conference on Innovation & Technology in Computer Science Education (ITiCSE '14). ACM, New York, NY, USA, 327--327. https://doi.org/10.1145/2591708.2602682Google ScholarDigital Library
- Shazia Sadiq, Maria Orlowska, Wasim Sadiq, and Joe Lin. 2004. SQLator: An Online SQL Learning Workbench. In Proceedings of the 9th Annual SIGCSE Conference on Innovation and Technology in Computer Science Education (ITiCSE '04). ACM, New York, NY, USA, 223--227. https://doi.org/10.1145/1007996.1008055Google ScholarDigital Library
Index Terms
- dbLearn*: Open-Source System and a Set of Practices for Conducting Iterative Exercises and Exams in a Databases Course
Recommendations
Rapid Aspect-Oriented Assessment of Relational Database Design Assignments
SIGITE '22: Proceedings of the 23rd Annual Conference on Information Technology EducationIt can be argued that assignments in a Databases course, where students are required to build a database instance based on specifications provided in the form of Entity-Relationship Diagrams and descriptions, are one of the best ways to evaluate ...
DBLearn: a system prototype for knowledge discovery in relational databases
A prototyped data mining system, DBLearn, has been developed, which efficiently and effectively extracts different kinds of knowledge rules from relational databases. It has the following features: high level learning interfaces, tightly integrated with ...
A Multi-Course Report on the Experience of Unplanned Online Exams
SIGCSE '21: Proceedings of the 52nd ACM Technical Symposium on Computer Science EducationWe report our experience of preparing and conducting unplanned online exams in the unique half-physical, half-virtual semester of Winter 2020. The report covers four courses in a large university's computer science program, ranging from first-year to ...
Comments