ActionLevelData
One row per action. A good place to understand where the data comes from look at this first. For each problem a student works on, there is a sequence of actions associated with that problem. The Action Level Report contains the sequence of actions for each student on each problem. The following columns are included in the Action Level report.
Here is an example of a sample file
How to look at this file
In row 3, column J and K the student first types 1/64 and was marked correct. In row 3 column E you see this was problem PRAVJUV.
In row 9, column J and K the student did the third problem (PRAVJVV) typed in "10^-3" and was marked wrong.
In row 10, column J and K you can see the student typed in 1/1000 as a second attempt which was correct.
In row 25, column C you see that the data for a new student (118662) is being presented.
In row 27, column I you see that this student asked for a hint after entering 1/4^3 a wrong answer.
In row 27 - 29, column L YOu can see the student asked for a series of three hints in a row spending only about 1 second per hint
Download the file from the image to see the whole thing.
Action Level Report Glossary
For each problem a student works on, there is a sequence of actions associated with that problem. The Action Level Report contains the sequence of actions for each student on each problem. The following columns are included in the Action Level report.
RowID
Each row has a number, this can be used to sort the rows back into the original order.
Order of Action Per Student
This can be used to sort the actions back into order after sorting by other columns.
User ID
The ID of the student doing the problem.
Problem ID
The ID of the problem
Problem Sub-Part ID
The ID of the problem sub-part. A problem can consist of one or more main problems, which are considered sub-parts.
Order
The order number of a specific action for a given user and a given problem
Action Type
The type of action.
Start = when the student starts the problem
Hint = when a student asks for a hint
Resume = when a student resumes a problem
Answer = when a student submits an answer
End = when a student finishes a problem
Time stamp
The time stamp of the action.
Answer Text
The text of the answer (applicable only for the answer action)
Correctness
The correctness of the answer (True/False)(applicable only for the answer action)
Problem Logs ID
The unique ID of the problem log entry