I'm going on the assumption that 'worksheet' really means Question Bank and that you are trying to find the results for a particular Question in one of your Question Banks.
In the answwersheetitem table, there are a number of ways of referencing questions.
questionindex represents the order that the quesitons were given for an instance of an assignment.
questiongroup and questionref combine to reference a question within an assignment.
topic and question combine to reference a question held in a Question Bank. tblocation points to the .qu file that holds the question. Whenever you edit a Question Bank, a new .qu file is created with a version number. This allows one to look-up instances of a question that was taken prior to that question being changed.
so an answersheetitem row like the following
This was the third question that the student saw when they took the test.
The question belongs to the 2nd questiongroup in the assignment (0-indexed) and it was the 3rd question in that group (0-indexed)
The actual quesiton is the 5th question in the 2nd topic of the Question Bank corresponding to the bank at the loation given in tblocation
Suppose you know the topic and number of a Question in a Question Bank and also know which .qu files represenf that bank (banks are indexed based on the last 3 digits of the file name - 000, 001, 002 etc)
let's say the question is the first question in the first topic of the bank represented by Bank002.qu
you could find all of the grades for that question by querying with the where condition:
topic=0 and question=0 and tblocation like 'your_stem\Local_Tests\Bank%.qu'.
This clause could also be used to find the corresponding question group and question ref for assignments.
I hope this sheds some light on how answersheetitems represent their data.
Developer, Maple T.A.