Reports Summarizing Course Progress Data Capture

As a student progresses through a course he will be clicking on various pages and causing the capture of data into the Course Progress Table.

This data must be available in its raw form for both the student and the Administrator.  Obviously this data would be "read-only" for both.  My guess is that this table will have about XX fields:

• student course table
  • student_id  -- foreign key
  • course_id  -- foreign key
  • course purchase date
  • course start date
  • course start time
  • course completion date
  • course completion time
  • etc

• segment table
  • student_id -- foreign key
  • course_id -- foreign key
  • segment name
  • segment start (or restart) date
  • segment start (or restart) time
  • segment end date
  • segment end time
  • segment score
  • etc.
     

It is not clear to me whether there should be separate small MySQL tables, one for each student/course combination, or one table that includes all students and all courses.  This later would become a very large table, with constant addition of new records -- many thousands of them -- so I count on you for proper design of the MySQL tables.

Summary reports of this data, including graphs, will be of more value to both student and administrator.  Here is a description of the reports and graphs which could either be compiled on an ongoing basis (with data-to-date) or calculated when called.

• Length of time since starting course (show starting date/time)
• Number of study sessions
• Total time (hours/minutes) for study
• Total time divided by number of segments completed to criteria (study segment has no passing criteria)
• Total time divided by number of 5x100% segments
• Average time for study session
• Date/time of last session
• Date/time of last 5x100% score on a quiz
• Number of wrong answer selections
• Number of 100% scores
• Number of 5x100% scores
• Number of different segments started (study and quiz)
• Number of segments started or redone  (study and quiz)
• Number of quiz segments where score met passing criteria (either 1x100% and 5x100%)
• Number of segments completed (includes only 5x100% criteria)