Creating an exam

Hello all,

I'm looking to create an app that allows everyone on the internet to take a test, and I'm hoping to get some help with the basic app structure.  This will allow internal users to create tests, add questions and multiple choice answers.

I'll layout what my initial thinking was.

Tables:

• Tests
  • has many related Test Questions
  • has many related Submissions
• Test Questions: has many related Possible Answers, and one related correct answer
• Submissions
  • Everyone on the internet will have the ability to add a record from the related Test
  • Should list all the Test Questions and allow the user to select from the Possible Answer for each question
• Possible Answers

I'm having trouble figuring out how I could display all the test questions on a Submission form. My goal was to then use formula fields to calculate how many of the given answers equal the correct answer and therefore have it automatically graded. Ideally the user will open the Tests table, pick a test, then click a button which adds a record to Submissions for that test and saves the record to submit their test.

Hopefully I've started out in the right direction but I wouldn't mind totally changing the approach to something that would work better in Quickbase. I'm more concerned now with the basic structure right now and would work on permissions later to get it ready for Everyone on the internet.

------------------------------
Jeff Jeff
------------------------------
​
#Appbuilders​