[QTI] Newbie Question

[Annesley, James A]

Hi,

It is possible to import XML files into databases such as MS SQL if you use the XMLType. You also have to add the schema to the database if you want validation. From there if you wish to query your data you can use XQuery. In this way no mapping is needed since you operate on the XML directly.

Best regards,

James
________________________________
From: ims-qti-bounces at lists.ucles.org.uk [ims-qti-bounces at lists.ucles.org.uk] On Behalf Of Niall Barr [n.barr at admin.gla.ac.uk]
Sent: 19 October 2009 13:27
To: IMS Question &Test Interoperability
Subject: RE: [QTI] Newbie Question

Hi,

As CJ said, When putting QTI into a database the QTI Schema is not really a useful starting point - I assume that MS-SQL has a way or serializing databases as XML, however the structure of that XML will be very different from QTI. If I were putting QTI items into a database I'd probably only extract metadata, and leave the rest in a single field - possibly the variable declaration, presentation, processing and feedback could be split into separate fields if you were binding the database tightly to a QTI player.

QTI (other than the Common Cartridge profile of QTI 1.2.1) doesn't really have the concept of question types in quite the same way as simpler systems - it is closer to being a way of describing questions. In QTI 2.* there are 21 defined interaction types however, and the examples supplied with the QTI 2.1 public draft specification cover all but customInteraction and mediaInteraction. (I'm don't know why mediaInteraction is missing.)

Niall

________________________________
From: ims-qti-bounces at lists.ucles.org.uk [mailto:ims-qti-bounces at lists.ucles.org.uk] On Behalf Of Sue Milne
Sent: 15 October 2009 10:02
To: IMS Question &amp, Test Interoperability
Subject: Re: [QTI] Newbie Question

Hi Bob,

Could I suggest that you go for QTIv2.1 rather than QTIv2.0?

Several teams are currently working on 2.1 implementations and the differences in the assessmentItem parts of the spec are few.

The examples cover all the basic question types - see http://www2.ph.ed.ac.uk/qtiv2/examples/V2examples.html which demonstrates most of them and some other interesting examples including our MathAssess collection.

Cheers
Sue

2009/10/15 Yuan Cheng Jiun <cjyuan at cse.cuhk.edu.hk<mailto:cjyuan at cse.cuhk.edu.hk>>
QTI XSD is very flexible, perhaps too flexible for the task you want
to accomplish.

A QTI assessmentItem (question) can contain question data and more.
If needed, one can also embed in a question the logic to interact
with the user (i.e. how to provide feedbacks) and the logic to
calculate score.

Trying to import the QTI XSD into a relational database is like
trying to import HTML XSD into a relational database.

For the task you want to accomplish (transfering data from one DB to
another), I think it is easier for you to just customize a XSD or
use a subset of QTI XSD.

Regards,
CJ

On Wed, 7 Oct 2009, Harris, B. wrote:

> Hi
>
> I've recently joined the list having recently started looking at some QTI based data. A couple of questions if anyone can advise:
>
> 1) We tried to use the QTI v2 XSD at http://www.imsglobal.org/xsd/imsqti_v2p0.xsd to create tables in a SQL database using the MS SQLXMLBULKLOAD function. We came across quite a few errors that the SQLXMLBULKLOAD reported - for an example " Schema: relationship expected on 'col'". Is this something that people have come across or should it work (or not work) okay? Is there anything we need to do to the schema to get the SQLXMLBULKLOAD to work? Has anyone managed to create tables of the schema - any pointers as to how?
>
> 2) I notice on the http://www.imsglobal.org/question/ page where we downloaded the XSD file from in the 'Version 2.0 -IMS XML Examples and Schemas' section that there are a few xml examples. Does this cover all the 'question' types in the xsd or are there more? Am I right in understanding that the xsd file describes these xml files...and a lot more? Basically, we're trying to deserialise some QTI v2 xml data from a learning environment system (LE) so we can populate another database with it. Our stumbling block is understanding how the xml is structured (which is when we were pointed to the IMS site). We thought about creating tables based upon the XSD (or in a roundabout fashion the xml) so we can deserialise the LE xml. Are we barking up the wrong tree with this. Could anyone provide an easier pointer if there is one? We're very much a newbie at all this so would appreciate some advice.
>
> Many thanks for any advice offered
>
> Kind regards
>
> Bob
>
>
> _______________________________________________
> IMS-QTI mailing list
> IMS-QTI at lists.ucles.org.uk<mailto:IMS-QTI at lists.ucles.org.uk>
> http://lists.ucles.org.uk/lists/listinfo/ims-qti
>

-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-
Phone: 2696 1284
Office: Room 129, HSH Engineering Building
Email: cjyuan at cse.cuhk.edu.hk<mailto:cjyuan at cse.cuhk.edu.hk>
Homepage: http://www.cse.cuhk.edu.hk/~cjyuan
-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-

_______________________________________________
IMS-QTI mailing list
IMS-QTI at lists.ucles.org.uk<mailto:IMS-QTI at lists.ucles.org.uk>
http://lists.ucles.org.uk/lists/listinfo/ims-qti



--
Dr Sue Milne

Mobile: +44(0)7780995748

Consultant
ELandWeb Ltd
Registered Address:
54 Grampian Way
Bearsden
Glasgow
G61 4RW
Company Number: SC312309

This email has been scanned for all viruses by the MessageLabs Email
Security System.

This email has been scanned for all viruses by the MessageLabs Email
Security System.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /public/ims-qti/attachments/20091020/838cba25/attachment.html