Problem Level Data

One row per problem per student. Compared to an action file, it will have few rows, as for every problem solved, a action file will have at least a "start" row (indicated the time stamp the student was exposed to the problem) and at least one "attempt" action row, and finally a "end" row indicated these students moved to the next problem. All of that info is collapsed in this problem level file.

Here is an example file

How to look at this file

This spreadsheet corresponds with the action level data shown on the Action Level Data Page.

  1. Row 2 - 8 column B shows that user 111532 did 7 seven problems.

  2. Row 2 - 4 in column AJ you can see in red that students answer to their first attempt to problems 1,2 and 3.

  3. Row 13 column AJ the answer is blank because the student's first action was a hint. This is indicated in column AQ as yes for "first action".

  4. Row 9 shows users 118662's first problem. As you recall in the actions table this person attempts the problem by typing in "1/4^3" but was marked wrong and then asked for three hints. You can see those three hints marked in column AR ( "hint count") as "3" in purple. You can also see that in column AS "Bottom Hint" is labeled as 1, indicated that those three hints were all the hints available. This information is not available from the action file itself so this column is handy.

Download a small, more managment file, with just the first 100 rows.

Download the big file.