Issue with order of marked questions

Added by Steve Murphy over 6 years ago

Hello!

I have a slight oddity I have not come across before. When I mark an AMC test, the order of the answers in the 'Look at marks' window and the exported spreadsheet is non-numerical. So the order is:
1 10 11 12 13 14 15 16 17 18 18 2 20 etc.

I have used AMC many times and not come across the before. I note that in my previous tests, 1 and 2 have been formatted as 01 and 02 in the marks output, but I am not aware of changing any settings in the current project that may have altered this.

Suggestions please!

Thanks in advance.

Steve


Replies (7)

RE: Issue with order of marked questions - Added by shreikant kv over 6 years ago

Please upload your .ods file...

RE: Issue with order of marked questions - Added by Steve Murphy over 6 years ago

Hi,

Thanks for the speedy reply. File attached.

The issue seems unrelated to spreadsheet generation as the same pattern is seen in the 'Look at marks' window.

Thanks,

Steve

OrderIssue.ods (31 kB)

RE: Issue with order of marked questions - Added by shreikant kv over 6 years ago

Here is a "bad" but not "terrible" solution:
1. Open the source latex file
2. Relabel questions as follows:
1--> 101
2--> 102
...
9--> 109
10--> 110
...
21-->121 etc
3. That should do the trick?

RE: Issue with order of marked questions - Added by Steve Murphy over 6 years ago

Hi,

I have a workaround in case others have this problem.

I've had a quick look in the database 'scoring.sqllite' and the table 'scoring_title' and edited the entries in here so '1' becomes '01' and '2' is '02' etc. The output is now sorted correctly in both the Look at marks window and the ods file.. So, whatever writes the input into this table is what is causing the issue.

This workaround will allow me to quickly get the test marked for the time being until the solution can be found.

Thanks.

Steve

RE: Issue with order of marked questions - Added by shreikant kv over 6 years ago

1. Use function value(entry) to convert text "'1" to number "1" etc.
2. Select part of the table which has marks and row headers of question numbers.
3. Choose Data-->Sort and under options pick left to right (sort columns)
4. Do the sorting.
5. Done. Pl see attached.

OrderIssue.ods (47.1 kB)

RE: Issue with order of marked questions - Added by Alexis Bienvenüe over 6 years ago

The question labels can be strings that describe briefly the content of the question, so that the columns can be identified quickly. That's why these labels are sorted with lexicographic order.

RE: Issue with order of marked questions - Added by Steve Murphy over 6 years ago

Hi,

Thanks both for the speedy responses. I understand what you are saying, but I still think there is something 'fishy' going on.

What I don't understand is why the issue of sort order has suddenly cropped up for me. I am not doing anything noticeably different in this project to my previous ones which worked as expected. I have never needed to 'trick' the code to get the correct sort order before and this source.tex is a copy a previous one, just a few extra questions and columns.

So to test out whether it is a code issue Latex or some setting somewhere, I cloned an old project that sorted results correctly, deleted the old Latex source.tex and pasted in the new one form the project that exhibits the odd sorting behaviour. I then click Update Documents and Detect Layouts so the old project used the new Latex source. I looked in the database layout.sqlite in this project directory and now questions 1-9 are described as 01, 02, 03 etc and results are sorted correctly on the output. In a 'faulty' project they are just described as 1,2 3 etc. with the leading zeroes missing in this database. So, unless I'm missing something, this tells me there must be a setting somewhere in the project that is causing the issue, not that it is default behaviour or a problem with the Latex code.

Any ideas where this can be found so I can alter it please? Does that even make sense ?! :-)

Thanks,

Steve

(1-7/7)