Grading MultipleQuestions Exams System
-
Dear All I have a project that grade a multiple questions exams. Two files are the input of the system: 1-File which contains a line for each student that contains its information (such as test version and center number and ID ...etc) and answers. 2-File which contains the Key answers for each version and has the same settings of the first file. The user of the system then will configure the settings of the file(I mean will configure the start and end of each field such as the ID field will start at index 1 to index 9). After configuring the settings the system should load the answers and information into the database and then grade the exam. My question is What is the best database desighn for doing that? Is it a good practice to create an attripute for each answer(might be 210 answers) or put them all in one attripute? And what is the best algorithm for the grading process? please, help me... :sigh:
-
Dear All I have a project that grade a multiple questions exams. Two files are the input of the system: 1-File which contains a line for each student that contains its information (such as test version and center number and ID ...etc) and answers. 2-File which contains the Key answers for each version and has the same settings of the first file. The user of the system then will configure the settings of the file(I mean will configure the start and end of each field such as the ID field will start at index 1 to index 9). After configuring the settings the system should load the answers and information into the database and then grade the exam. My question is What is the best database desighn for doing that? Is it a good practice to create an attripute for each answer(might be 210 answers) or put them all in one attripute? And what is the best algorithm for the grading process? please, help me... :sigh:
Primary table is student table. This has an index into a StudentTests table (1:* relationship) The tests table contains an index to Test table which contains the students' test answers. The information in StudentTests also points to a Teacher table and eventually to the Teachers' Answer for that test. (assuming that each teacher or center would have different answers to their tests) Then for a specific test, iterate through the Test table for the specific test in the specific center for the specific teacher (returning a *:1) and just iterate through the answers. The Test table would hold an indicator for each correct/wrong answer and score. The grading algorithm would be dependant upon the rules: is this a bell curve? is this a straight step curve? There are 10 kinds of people in the world.
Those that read binary...
...and those who don't.