Designing a gradebook database
February 10, 2012 7:13 AM Subscribe
MS Access / relational database question. I'm trying to set up a database for a gradebook for multiple classes, that I can maintain indefinitely. I've got the basics in terms of tables for students, classes, etc. But in my ideal world, I'll be able to do item analysis, too -- like seeing what proportion of students got Question 17 correct on a certain exam, or pulling up the specific items that a student missed on Exam 3. The only way I can think of to get this level of detail is with a junction table that has a separate record matching up each test item with each student for each exam. Of course this will eventually swell into hundreds of thousands of records (students * test items * exams * classes * years). Am I thinking about this correctly? Is there a better way of designing this? Are there any examples you can point me to of databases that accomplish similar things? Thanks!