PhAQ Structure

Using a Socratic dialogue style, the students are guided to a specific concept. If a student has an incorrect observation or inference along the way, they are stepped through questions and additional feedback that is tailored to their problem.

flowchart

 

Current question types:

 

 

What does this look like to the computer?

PK/FK Field Name Field Definition Field Datatype FK Table
  Courses      
PK CourseID The system generated ID given to all new course entries. INT IDENTITY(1,1)  
  CourseNumber The course number assigned by Registrar's Office. INT  
  CourseName The name of the course. VARCHAR(20)  
         
  Assignments      
PK AssignmentID The system generated ID given to all new assignment entries. INT IDENTITY(1,1)  
FK CourseID The course ID to which the assignment belongs. INT Courses
  AssignmentName The name of the assignment. VARCHAR(20)  
  AssignmentDescription The description of the assignment. VARCHAR(255)  
  AssignmentDueDate The due date of the assignment. DATETIME  
  Active An indicator as to whether or not a problem is active. BIT  
         
  AssignmentProblems      
PK AssignmentProblemID The system generated ID given to all new assignment problem entries. INT IDENTITY(1,1)  
FK CourseID The course ID to which the assignment problem belongs. INT Courses
FK AssignemntID The assignment ID to which the assignment problem belongs. INT Assignments
FK ProblemID The problem ID to which the assignment problem belongs. INT Problems
  ProblemNumber The number of the problem within a specific assignment. INT  
         
  Problems      
PK ProblemID The system generated ID given to all new problem entries. INT IDENTITY(1,1)  
  ProblemType The type of problem (Match, MC, TF, Essay). VARCHAR(20)  
  ProblemDescription The description of the problem. VARCHAR(50)  
  ProblemInstruction The instruction given to the user. VARCHAR(255)  
  ProblemTopic The topic of the problem (used so the professor can organize problems). VARCHAR(20)  
FK MMID The multi media ID of the problem. INT Multimedia
  Explain An indicator as to whether or not the user needs to give a written explanation. BIT  
  ExpertResponse The expert response given when a problem is answered correctly. VARCHAR(255)  
FK FollowUpProblemID The problem ID of a follow-up question, given after the problem is answered correctly. INT  
         
  MatchProblem      
PK MatchProlbemID The system generated ID given to all new match problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the match problem. INT Problems
  MatchSelectionNumber The static number of selction choices for the match problem. INT  
         
  Match      
PK MatchID The system generated ID given to all new match problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the match problem. INT Problems
  Choice1 The first choice of a match pair. VARCHAR(50)  
  Choice2 The second choice of a match pair. VARCHAR(50)  
  Answer An indicator as to whether or not the match pair is correct. BIT  
FK NextProblemID The problem ID of a feedback question, given if the problem is answered incorrectly. INT Problems
  NextStatement The feedback statement, given if the problem is answered incorrectly. VARCHAR(100)  
         
  MultipleChoice      
PK MultipleChoiceID The system generated ID given to all new multiple choice problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the multiple choice problem. INT Problems
  Choice The choice. VARCHAR(50)  
  Answer An indicator as to whether or not the choice is correct. BIT  
  DisplayOrder The display order of the choice within a problem set. INT  
FK MMID The multi media ID of the choice. INT Multimedia
FK NextProblemID The problem ID of a feedback question, given if the problem is answered incorrectly. INT Problems
  NextStatement The feedback statement, given if the problem is answered incorrectly. VARCHAR(100)  
         
  TrueFalse      
PK TrueFalseID The system generated ID given to all new true false problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the true false problem. INT Problems
  Answer An indicator as to whether or not the match pair is correct. BIT  
FK MMID The multi media ID of the problem. INT Multimedia
FK NextProblemID The problem ID of a feedback question, given if the problem is answered incorrectly. INT Problems
  NextStatement The feedback statement, given if the problem is answered incorrectly. VARCHAR(100)  
         
  MultipleAnswer      
PK MultipleAnswerID The system generated ID given to all new multiple answer problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the multiple answer problem. INT Problems
  Choice The choice. VARCHAR(50)  
  Answer An indicator as to whether or not the choice is correct. BIT  
  DisplayOrder The display order of the choice within a problem set. INT  
FK MMID The multi media ID of the choice. INT Multimedia
FK NextProblemID The problem ID of a feedback question, given if the problem is answered incorrectly. INT Problems
  NextStatement The feedback statement, given if the problem is answered incorrectly. VARCHAR(100)  
         
  RatingProblem      
PK RatingProblemID The system generated ID given to all new rating problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the rating problem. INT Problems
  RatingLowBound The low bound for the rating scale VARCHAR(15)  
  RatingHighBound The high bound for the rating scale VARCHAR(15)  
         
  Rating      
PK RatingID The system generated ID given to all new rating problem entries. INT IDENTITY(1,1)  
FK ProblemID The problem ID of the rating problem. INT Problems
  Choice The choice. VARCHAR(50)  
  Rating The rating. INT  
  DisplayOrder The display order of the choice within a problem set. INT  
FK MMID The multi media ID of the choice. INT Multimedia
FK NextProblemID The problem ID of a feedback question, given if the problem is answered incorrectly. INT Problems
  NextStatement The feedback statement, given if the problem is answered incorrectly. VARCHAR(100)  
         
  MultiMedia      
PK MMID The system generated ID given to all new multi media entries. INT IDENTITY(1,1)  
  Type The type of multi media (Applet, Image, Video). VARCHAR(20)  
  SubType The sub-type of a multi media (swf, qt, wmf). VARCHAR(20)  
  Name The name of a multi media object. VARCHAR(20)  
  Description The description of a multi media object. VARCHAR(255)  
  FilePath The file path (local to the server) of a multi media object. VARCHAR(255)  
         
  Submissions      
PK SubmissionID The system generated ID given to all new submission entries. INT IDENTITY(1,1)  
  CourseID The course ID of the submission. INT Course
  AssignmentID The assignment ID of the submission. INT Assignment
  ProblemNumber The problem number of the submission. INT  
  ProblemID The problem ID of the submission INT Problem
  ProblemType The problem type of the submission. VARCHAR(20)  
  UserID The user ID of the submission. INT User
  Choice The choice(s). VARCHAR(50)  
  Answer The answer. BIT  
  AssignmentTimestamp The timestamp for the assignment. DATETIME  
  SubmissionTimestamp The timestamp for the individual timestamp. DATETIME