You could set up an auto-enter number field (uncheck 'Do not replace existing...').
If your dropdown field is named TABLE::Dropdown, then the formula for your auto-enter field which I'll call TABLE::Score could be this:
IsEmpty ( TABLE::Dropdown ) ; "" ;
TABLE::Dropdown = "UNACCEPTABLE" ; 0.04 ;
TABLE::Dropdown = "NOVICE" ; 0.6 ;
TABLE::Dropdown = "COMPETENT" ; 0.75 ; 1
You can also set up a table of four records. Put the text in one field and the score in another. Define your value list as a use values from field value list with the score selected as field 1 and the descriptive text as field 2. Select the "show only values from second field" option and you now have a value list that displays the text but enters the score.
Phil, thank you for you help with this. it’s taken me a while to figure out how to do this, but I think I understand what you’ve suggested, and got part way there.
What I can’t seem to figure out, is how to get access to the mark associated with the competency (unacceptable, nov, comp, pro)…to be able to build a calculation that will determine the mark a student would get for this project..
The other thing I’m not sure about, is whether this is the best way to do this. For this project, there are 18 fields, each with their own U/N/C/P comment, would I have to create 18 separate tables to make this work?
Making head way!
Not sure this is the best way, or even what you were suggesting, but I’ve been able to get a number score, from the drop down list. By changing the fields in the table to the level (U/N/C/P) and the corresponding text, and then using the CASE function to translate that into a number (.4/.6/.75/1)
Still doing it this way will require me to make 18 tables for each project… I’ll work with this for now.
thanks for your help, and if I’m overstepping your help, pls let me know, and I’ll stop emailing you.
You'd need 18 relationships to that table because your structure is ... well, bad
These 18 fields should be records in a related table. That table needs (besides a primary key, and a foreign key to link it to the other table) only a test score field, and another field that tells you what it is you're testing. At the moment, that information is encoded in the 18 field names; with this generic structure, you need to store this in another way.
Now you ...
... only need a single relationship to look up the numerical value of a score (any score)
... can easily analyze any subset if data (by participant, score, date, subject ...)
... add metadata (test date etc.) by simply adding the required fields once (rather than 18 times)
... are able to easily accommodate a larger number of tests by simply adding more related records, without changing the structure (adding more fields) and without any modifications to scripts or calculations
I know enough that this way works, but is not the best way to do it, but not enough to understand what you are suggesting I try…
I’m a college professor, trying to move my program from traditional scoring to competency based evaluation.
For each project there are 2 sessions (day 1 and day 2), each session has a number of domains (Client Assessment, Measurement&Shape Capture, etc), each domain has up to 5 tasks (Client Assessment: introduction/consent, client history, physical assess, static eval, dynamic eval), and then each task has 4 competencies score and definition (U/N/C/P).
Should I create a table with the headings of Project, Session, Domain, Task, Comp level/definition/numerical score? This I could do, but how to link that up to an interface that my faculty could use to eval students, I do not. (yet)
The screen shot below, is what I would like my faculty to use from there tablets while with their students in a clinical setting:
The fields you have in your screenshot would come from the related table I described, displayed in one or several portals. The labels would come from one (pre-set) field, and the other (empty) field would receive the respective score entry.
When I said "you can easily add meta-data", then the point in fact here is that you can just add another field that describes the domain a task (single record) belongs to. This could be a text field, or a key that links to a Domain table. Another could be on what day of a session that task was (or is scheduled to be) taken.
Depending on your current and future needs, I envision a basic structure of:
Domain --< DomainTask >-- Task (lets you define domains, tasks and their relationship; the "template")
Session --< ParticipantTask >-- People (holds the actual scores of tasks taken)
You may want to search this forum for "questionnaire". There should be several posts that describe the basic structure & setup of such a solution, and how for example you'd go from a template to creating records for an actual session.
Here's another simple approach. Note that there are no calculations used in this file to produce scores.
PS. Posting responses to "phil" in this thread will be a tad confusing given that there are two of us named "phil".
ValueListScores.fmp12.zip 67.1 K
K, back from my day job, and had a chance to look at the file.
Wow, minimal coding!
I could work with this to start with, but my next issues are:
- the final score is not just a summation of each 18 “ScoreNames”, but each section is weighted differently
- when faculty use this to evaluate their students, the supporting text that is linked to each of the “ScoreNames” needs to be displayed
I have attached the fmp you provided, with the weighting and a sample drop down list for the first ScoreName1 and an xlsx spreadsheet, so you can see the full rubric for the project and session.
OK, this looks even sleeker, but I am even less able to figure out how you did this… I can’t figure out how the scores are calculated, and having it set up in the layout provided, I can’t seem to format it in the various sections (Client Assessment, Shape Capture, etc)
Plus, this one has the same issue as the previous file you shared with me, in that I need to have the descriptive text that corresponds to the 1 question U/N/C/P answers…
I’ll give the forum a try searching for questionnaire, to see if it will help me..
none of the Starter Solutions available are suitable for what I am trying to create, unfortunately..
What this example is showing is that a field can show the values in a value list (the radial button choices), but store the underlying VALUE of the field Look at the value list. It uses the text choice and the value. The value is what is stored.. The two fields to the right are the same, but one displays the value list and the other displays the actual value that matches the text response.
i like this way a lot. People use this all the time to show a user's name but actually store the ID. Here's it is just exposed.
ANd maybe for your purposes you need to expose the value; i wouldn't but I'd use the numerical value for reporting and numerical analysis.
Scripting to set another field the number based on the text choice or this way is just fine for any purpose. I'm not sure any one is more complex than the other.
There are no calculations in the file that I uploaded. The value list simply enters the numeric value when you click a radio button. There are two copies of the same field, one formatted with the value list and one formatted as an edit box to show the actual value entered.
I placed a text field to the left with the text "Question 1", "Question 2". That's the field where you can edit to put in your descriptive text. To weight different questions, you'd add a number field for the weight to each question and now you would need a calculation to multiply the answer value by the weight.
Others have recommemded that you research "Questionnaire" or "Survey" here. I strongly recommend that you do that. My sample file was set up to be somewhat similar to such an approach though in such a system, the question field becomes a fielf in a related record.