Having real problems with a design for this one. Hoping for a few ideas....
My students (60) sit at least 20 exam papers as they approach their final exam.
Each paper has about 20 questions covering 1 topic and each question may be out of anything up to 5 marks
If a pupil gets 1/5 on a question his mastery of that particular topic is 20%
I envisage being able to provide students with a list of topics which they've mastered (and those that they haven't) in the run up to their final exam.
I initially thought
tbl1Paper
ExamID
Q1topic
q2topic
and so on
tbl1topics
topic ID
Topicname
tblstudent
studentID
studentname
etc
But this stores topics in two separate places and currently doesn't store what each question is out of
I cant see a better way round it.
Any thoughts would be more than welcome.