[AISWorld] Automated assessment for SQL/database courses

[ilia]

Dear Joseph,

Sorry for the late reply and thank you for your interest in our project. 
This project has been started as a MS project to satisfy our own needs. 
As it looks like there is an interest from other universities, we are 
planning to put some efforts in making YASQLT available for others in 
one way or another. To start with, we need to make internationalization, 
at least for English (YASQLT, currently, works in Swedish), and provide 
interface for the teacher to upload own database and assignments. We 
will inform you as soon as we have anything for the third parties to test.

Best regards

Ilia


On 12/16/2016 3:54 PM, Joseph Clark wrote:
> This is wonderful work, and will be very useful in teaching!  Have you
> made it available as a SaaS, or open-source code?
>
> // joseph w. clark
> \\ maine, u.s.a.
>
>
> On Thu, Dec 15, 2016 at 2:54 AM, ilia <ilia at ibissoft.se> wrote:
>> Dear colleagues,
>>
>> Sorry for the late reply. I haven't got any suggestions on the post below,
>> except a request of sharing any information received.
>>
>> Anyway, after several years waiting :-), we decided to try to do something
>> ourselves. The preliminary results can be found here: http://bit.ly/2hIg0Ik
>> (Springer), http://bit.ly/2hIgjms (ResearchGate), http://bit.ly/2hyQhiF
>> (SlideShare)
>>
>> Sincerely
>>
>> Ilia
>>
>>
>> On 1/15/2014 11:36 PM, ilia wrote:
>>> Dear colleagues,
>>>
>>> I wonder whether anybody has a tool in operation for automated assessment
>>> of assignments in a database course. In particular, we would be interested
>>> to have such a tool for assessing assignments related to SQL, though other
>>> tools like converting UML into Relational scheme, or assessing assignments
>>> in the area of Relational Algebra would be also good to have.
>>>
>>> In connection to SQL, assessing assignments connected to learning SELECT
>>> has a priority. The tool does not need to make a sophisticated analysis of
>>> SQL statements, and it does not need to insure 100% correctness - it can
>>> miss some incorrect statements, but shouldn't mark as incorrect correct
>>> statements. The following scheme would do. A database is created in some
>>> popular DBMS, like SQLserver, or MySQL, or even Access. A teacher creates a
>>> textual question, and a corresponding SQL SELECT. The statement is run and
>>> the set of records it gives is saved. The students are not allowed to change
>>> the content of the database. When a student creates his/her own SELECT to
>>> answer the question, it is run against the same database and the set
>>> produced is compared with the one stored when the teacher ran his/her
>>> version of SELECT. If the data sets differ, the tool marks the student's
>>> SELECT as incorrect.
>>>
>>> Any help in acquiring such a tool would be much appreciated.
>>> As customary, a summary of responses will be reported back to the list.
>>>
>>> -- Best regards/Ilia
>>> ===============================================
>>> Dr. Ilia Bider
>>> Process- och systemutvecklingskonsult at IbisSoft.se
>>> Lektor & Forskare/Docent i data- och systemvetenskap at DSV.su.se
>>> ilia at ibissoft.se        +46 (0)8 164998
>>> Design science in action ... http://slidesha.re/Uq3RTC
>>>
>>>
>>> _______________________________________________
>>> AISWorld mailing list
>>> AISWorld at lists.aisnet.org
>>
>> --
>> ===============================================
>> Dr. Ilia Bider
>> Process- och systemutvecklingskonsult at IbisSoft.se
>> Lektor & Forskare/Docent i data- och systemvetenskap at DSV.su.se
>> ilia at ibissoft.se        +46 (0)8 164998
>> Software project as a socio-technical system: http://bit.ly/1TKgnf6
>>
>>
>> _______________________________________________
>> AISWorld mailing list
>> AISWorld at lists.aisnet.org

-- 
===============================================
Dr. Ilia Bider
Process- och systemutvecklingskonsult at IbisSoft.se
Lektor & Forskare/Docent i data- och systemvetenskap at DSV.su.se
ilia at ibissoft.se        +46 (0)8 164998
Software project as a socio-technical system: http://bit.ly/1TKgnf6