Grading Form setup 2

[newguy86]

Hi Everyone,
I have a db that is used to log/track work that has been tasked out to my department and I am trying to build a scoresheet into the db so that a user can grade the accuracy of a completed task. Now for each item the agent is being graded on, there are three options (Yes, No, N/A) and the grading will be simple ([total # of Yes's]/[total possible]).

My first question is would it be better to setup checkboxes for the three options or would it be better to setup a number field for each option and let the user input "1" in the field they want to select?

And my second question is what would be the best approach to gathering the numbers that I need to calculate the grade? All I can come up with is counting each individual field by writing out in code every field that I need to check and doing some simple math, but I figured that there must be a better way.

Any assistance that you guys can provide on this would be greatly appreciated.

Thanks,

Travis

http://www.enterprise.com

 

[traingamer]

Great question. Since you are building the scoresheet, make sure that you build an answer table, where the structure is something like:

ScoreId: autonumber
TaskId: foreign key
criteria: probably should be a FK from a criteria table
Results: boolean (true / false)
applicable: String (null or "n/a")

This will simplify the second part of your question.
You just need to query on the taskId where applicable is null and sum accordingly.

Your form should have two checkboxes (or one radio button with all three options, and your code will then populate the table accordingly.)

If you have all of your 'criteria' as columns, you'll just be making too much work for yourself.

Search this forum for Dhookom's survey solutions for an already developed answer.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[traingamer]

Google (or search engine of choice) hookom at your survey




Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[dhookom]

Can you provide your table structure? It doesn't seem to be normalized but I can't tell from your description. Ideally each grade/score/item/task or whatever should be stored in its own record.

Duane
Hook'D on Access
MS Access MVP

 

[newguy86]

Thanks traingamer! I will definatley take your suggestions into consideration.

dhookom,
Currently I have setup a table where each record is linked to a different Request Number in the work log, with a column for each possible answer (ex. Criteria1-Yes, Criteria1-No, Criteria1-NA, Criteria2-Yes, etc.) using checkboxes. That way I could store the grades for each criteria (25 total) and then all I have to do is calculate the grade. But traingamer makes a good point in that my setup creates a bigger workload for me to build and maintain. Can you think of something that will work better?

Thanks,

Travis

http://www.enterprise.com

 

[newguy86]

traingamer,
I reviewed over your suggestion again and I either am not understanding it or it may cause an issue with what I need to accomplish.

So, as I stated before, we have 25 pieces of criteria that will be on the grading sheet. And with every piece of criteria we need to know one of three things (1 - passed, 2 - failed, or 3 - N/A). My thought was to create a simple table that stored this data and link it to the record from the Request Log table that the user will be grading, so that we can look at either the individual grade for a specific request or at an average grade over a period of time.

With the suggestion that you gave me it almost seems like the table will create a new record for each specific criteria that gets graded. Which would sound like a nightmare for reporting.

Travis

http://www.enterprise.com

 

[dhookom]

it almost seems like the table will create a new record for each specific criteria that gets graded

Yes, that's how I have had success in creating this type of application. IMO, the reporting and query becomes much easier. You can always create a crosstab query if you want to get back to your spreadsheet view.

Duane
Hook'D on Access
MS Access MVP

 

[newguy86]

Ok, so I think I am starting to understand what you guys are getting at, but I have another question.

One of my goals in creating this is to build a user-friendly setup or a point-and-click system. In other words, I wanted to have the entire list of criteria preloaded on the form so that the user will be able to run down a checklist of items that they need to grade on and also be able to simply select the answer they want without having to build the record first. If I setup each field on the form (probably with checkboxes) how would I get the data from the table to display on the form?

Travis

http://www.enterprise.com

 

[dhookom]

Check the sample Traingamer suggested on 23 Aug 10 14:48. I think there is a similar setup in the Employee Evaluation demo

Duane
Hook'D on Access
MS Access MVP