Personalised feedback with semi-automatic tool for conceptual database model

1. Personalised feedback with semi-automatic tool for conceptual database model Firat Batmaz Roger Stone Chris Hinde HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

2. People/Project • Chris is Firat’s supervisor • PhD includes novel assessment of ‘database’ teaching • Particularly diagrams • Particularly ER diagrams • Roger supplied interface ideas • Leading to project co-draw HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

3. How bad could it be? • So you get pieces of paper from 200 students • containing hand-drawn ER diagrams • and you are expected to mark them • and give feedback • overnight HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

4. How good could it get? #1 • The students could use a computer-based tool to ‘draw’ their ER solution • You (as tutor) could ‘draw’ a model answer • A semi-automated assessment tool could mark as much as it could of the students based on your ‘model’ answer • You could then mark the rest HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

5. How good could it get? #2 • Mark each student’s work individually • (as yet) unmarked component -> mark it (including feedback) • marked component -> all students • mark the same mistake once (however many students made that mistake) HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

6. How good could it get? #3 • How much work would that save? HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

7. The co-draw editor #1 • Traditional diagram editor Drawing area Toolbox HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

8. The co-draw editor #2 Scenario text Drag & drop Drag & drop Relationships Entities HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

9. The co-draw editor #3 • Why is this better? • Emphasis on scenario, that the scenario ‘holds’ the answer, dragging information out of the scenario into the diagram • Faster, no ‘typing’ (of names) • Quick to learn, students only need to be shown creation of one entity, one attribute, one relationship and one delete (~ 3 min) • Web-based HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

10. The co-draw editor #4 • Show editor (live) • Size on - i/f is to support (finger) touch • Entity • Relationship • Attribute (+PK) • Deletion HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

11. co-draw marking • Tutor • marks elements not whole diagrams • using three (traffic light) colour buttons • wrong, acceptable, correct • adding textual feedback • gets an overall report listing every distinct element, how it was marked and the number of students diagrams whose diagrams included that element • Student • Gets a coloured version of their diagram with feedback on every element - a mix which is entirely personal HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

12. Feedback Wrong with textual explanation Acceptable but? Correct with textual explanation HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

13. Status / Further work • It really does save a huge amount of marking time • Students are enthusiastic about the editor • System available to <??>.ac.uk email addresses • http://co-draw.lboro.ac.uk • Want to reduce the dependence on graphViz • Want to revisit the i/f of the marking editor HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde

14. Conclusions • Interested to hear … • of any similar work • or from anyone who thinks they could use our system (possibly modified) • Want to extend to other diagramming systems (UML, …) • Any questions … HEA Conf // co-draw // Firat Batmaz, Roger Stone, Chris Hinde