Problem log table:Current Dataset
Problem log table with PFA data
Sample Tabling Method (we did this in class)
Problem body table
http://users.wpi.edu/~yutaowang/problem_body.csv
(if any of the links does not work, please copy it into the explorer to open)
If you are interested in looking at the skills see this Skill Info file.
A more detailed description is here.Â
order_id
These id's are chronological, and refer to the id of the original problem log.
assignment_id
Two different assignments can have the same sequence id. Each assignment is specific to a single teacher/class.
user_id
The ID of the student doing the problem.
assistment_id
The ID of the ASSISTment. An ASSISTment consists of one or more problems.
problem_id
The ID of the problem.
original
1 = Main problem
0 = Scaffolding problem
correct
1 = Correct on first attempt
0 = Incorrect on first attempt, or asked for help.
attempt_count
Number of student attempts on this problem.
ms_first_response
The time in milliseconds for the student's first response.
tutor_mode
tutor, test mode, pre-test, or post-test
answer_type
choose_1: Multiple choice (radio buttons)
algebra: Math evaluated string (text box)
fill_in: Simple string-compared answer (text box)
open_response: Records student answer, but their response is always marked correct
sequence_id
The content id of the problem set. Different assignments that assign the same problem set will have the same sequence id.
student_class_id
The class ID.
position
Assignment position on the class assignments page.
problem_set_type
Linear - Student completes all problems in a predetermined order.
Random - Student completes all problems, but each student is presented with the problems in a different random order.
Mastery - Random order, and student must "master" the problem set by getting a certain number of questions correct in a row before being able to continue.
base_sequence_id
This is to account for if a sequence has been copied. This will point to the original copy, or be the same as sequence_id if it hasn't been copied.
skill_id
ID of the skill associated with the problem (different skills are in different rows).
skill_name
Skill name associated with the problem (different skills are in different rows).
teacher_id
The ID of the teacher who assigned the problem.
school_id
The ID of the school where the problem was assigned.
hint_count
Number of student attempts on this problem.
hint_total
Number of possible hints on this problem.
overlap_time
The time in milliseconds for the student's overlap time.
template_id
The template ID of the ASSISTment. ASSISTments with the same template ID have similar questions.
answer_id
The answer ID for multi-choice questions.
answer_text
The answer text for fill-in questions.
first_action
The type of first action: attemp or ask for a hint.
bottom_hint
Whether or not the student asks for all hints.
opportunity
The number of opportunities the student has to practice on this skill.
opportunity_original
The number of opportunities the student has to practice on this skill counting only original problems.