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


Download the file from the image to see the whole thing. 
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   
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