Hello All,
For reasons that would take too long to explain here, I am planning on having attendees use an Excel form to provide their responses to a test.
The Excel form view is linked to a data worksheet which I would then import to the db I am designing.
Aside from the archaic data capture method, I need advice on a few items...
I am playing with the following tables:
Tbl ans_key
course
1
2
x
course is the key, such that I can determine which set of course answers to compare. 1 through x is determined by the number of questions for the respective course.
Tbl_course_data
course
course_date
instructor
fname
lname
1
2
x
course ties to the answer key table, a few demographic items, and then the responses 1 through x. this data is being imported from the Excel file mentioned.
Tbl_course_results (not sure about this table and maybe this should be a query/report)
course
course_date
fname
lname
1
2
x
the idea was to compare the data imported into tbl_course_data to the tbl_ans_key and store it in the tbl_course_results.
My questions:
1. Is the last table required?
2. What is the easiest way to do the compare of the data imported to the answer key and then display the results?
3. I want to be able to display results for an individual course as well as the aggregate of all courses of the same type
While I would like to use a different data gather approach, the challenge is that not all classes are held in a location where the machines will have Internet access (I know, a shock in this day in age) or, if they do, the attendees may not have an email address that is usable (I know, even crazier). The constraints limit me from using the web as a means to capture the data, and removes the possibility of using an email form to capture the data, so here I am in 2012 and I have to use an Excel file and sneaker net to get the files off the machines and then imported into the db I am designing.
Thanks.