Rank Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a rank order question, something like:
Rank your favorite foods from 1 to 4.

Apples
Oranges
Lemons
Plums

I have a drop down box for each one but I want to make sure that no one uses
the same ranking twice.

Thanks,
 
Don't use a drop down, use Radio buttons and set it so that only one Radio button can be checked.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
But how does that get a rank order from 1 (the best) to the worse 4? I want
to know the favorite fruit to the worse fruit, 1, 2, 3, 4.

Let's say I have four radio buttons like you said instead of the drop down
and the person can only select one. OK, so the person selects 1 which is
apples. But then I want to know the 2nd best fruit, the 3rd best fruit, and
the least favorite. Not sure how the radio button would be the solution. If I
have another group of radio buttons the person could still select apples
again as #1. True, I can tell the person only pick #1 one time but that's not
a good way.

Tony



Tony
 
TonyK said:
But how does that get a rank order from 1 (the best) to the worse 4? I
want
to know the favorite fruit to the worse fruit, 1, 2, 3, 4.

Let's say I have four radio buttons like you said instead of the drop
down
and the person can only select one. OK, so the person selects 1 which is
apples. But then I want to know the 2nd best fruit, the 3rd best fruit,
and
the least favorite. Not sure how the radio button would be the solution.
If I
have another group of radio buttons the person could still select apples
again as #1. True, I can tell the person only pick #1 one time but that's
not
a good way.
Click to expand...

Pick one in in each row in the order of your preferences starting with 1 as
most favorite to 4 least favorite.
X's representing a radio button selected (only being able to click one in
the column).

Apple Plum Kiwi Pear
1 o x o o
2 x o o o
3 o o o x
4 o o x o

Hope that clarifies,
Steve Banks
 
Steve,

but that just moves the problem from the columns to the rows. Yes, I can fix
it where there can only be one selection per column, such as for column one
row 1, Group name would be apple with value 1, column one row 2 would be
group name apple with value 2 so you could pick apple one time (value 1, 2,
3, 4) which would go into the Apple field of Access (1, 2, 3, or 4). HOWEVER,
here's where the system breaks down. I can rate apple #1 but then I could
rate Plum, Kiwi, pear #1 as well. I know because I just tried it. I could
reverse it where by rows, I could only rate one fruit #1, let's say plum, but
then for #2, I could rate plum again.

Here is my code where I could only select one from each row and also the
code with did the reverse where I could select only one per column. However,
regardless of code I use, there could still be duplicate rankings.but then I
could pick only one column but multiple rows.

1. <input type="radio" value="V1" name="Apple">Apple
<input type="radio" value="V1" name="Plum">Plum
<input type="radio" value="V1" name="Kiwi">Kiwi
<input type="radio" value="V1" name="Pear">Pear<p>
2. <input type="radio" value="V2" name="Apple">Apple
<input type="radio" value="V2" name="Plum">Plum
<input type="radio" value="V2" name="Kiwi">Kiwi
<input type="radio" value="V2" name="Pear">Pear</p>
<p>
3. <input type="radio" value="v3" name="Apple">Apple
<input type="radio" value="V3" name="Plum">Plum
<input type="radio" value="V3" name="Kiwi">Kiwi
<input type="radio" value="V3" name="Pear">Pear</p>
<p>
4 <input type="radio" value="v4" name="Apple">Apple
<input type="radio" value="V4" name="Plum">Plum
<input type="radio" value="V4" name="Kiwi">Kiwi
<input type="radio" value="V4" name="Pear">Pear</p>
===================================================


1. <input type="radio" value="Apple" name="One">Apple
<input type="radio" value="Plum" name="One">Plum
<input type="radio" value="Kiwi" name="One">Kiwi
<input type="radio" value="Pear" name="One">Pear<p>
2. <input type="radio" value="Apple" name="Two">Apple
<input type="radio" value="Plum" name="Two">Plum
<input type="radio" value="Kiwi" name="Twp">Kiwi
<input type="radio" value="Pear" name="Two">Pear</p>
<p>
3. <input type="radio" value="Apple" name="Three">Apple
<input type="radio" value="Plum" name="Three">Plum
<input type="radio" value="Kiwi" name="Three">Kiwi
<input type="radio" value="Pear" name="Three">Pear</p>
<p>
4 <input type="radio" value="Apple" name="Four">Apple
<input type="radio" value="Plum" name="Four">Plum
<input type="radio" value="Kiwi" name="Four">Kiwi
<input type="radio" value="Pear" name="Four">Pear</p>
 
How about:

Group Name: FirstChoice: (1) Apple (2) Plum (3) Kiwi (4) Pear
Group Name: SecondChoice: (1) Apple (2) Plum (3) Kiwi (4) Pear
Group Name: ThirdChoice: (1) Apple (2) Plum (3) Kiwi (4) Pear

In your database, you have 3 columns, FirstChoice, SecondChoice, ThirdChoice, each record would
write one record with the 3 values. You either right the number or the word to the database and then
count them.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thomas,

In the database, I would have one record for each survey taker with the
fields (generated by the group names):

FirstChoice
SecondChoice
ThirdChoice
FourthChoice

with the possible values let's say 1,2,3,4. However the form does not
prevent a survey taker from submitting 1,2,2,2 or 1111, etc. intead of using
1,2,34 in any order with no duplicates when I want a ranking without
replacement. So I could have someone mistakenly rating "apple" the favorite
as well as the least favorite. I could catch this in Access but if someone
had duplicates in ranking I would have to throw out the record. I want to
prevent this on the form so once, let's say apple is ranked (1,2,3,or 4th)
the survey taker then can't rank it again and must rank the remaining items.

Tony
 
That is the user choice, but you also need a NoChoice field so that they wouldn't have to select the
same in item in all choices.

Another option is to break the survey in individual pages for each choice, as a choice is selected,
hide it from display on the next page, etc., however then you are forcing the answers for Choices,
unless you include a NoChoice option.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thomas,

I think what you are saying is that there is no simple way to rank a series
of items without having the possibility that the same item could be ranked
twice with a different ranking.

Maybe there is some script that might do what I want to do.

Tony
 
You would have to write a custom ASP/VBscript that would valid the submission based on your
requirements, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
That's what I thought. I would have thought that MS would have built a bot
for this feature since rank ordering is a very common survey procedure. What
I might do is go with I have and just tell the survey takers do not rank the
same item twice and hope they follow instructions. What I am really doing is
not ranking fruit but asking a class to list their favorite guest speaker to
their least favorite.

Tony
 
Do a search for FrontPage Survey Add-ins.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
TonyK said:
That's what I thought. I would have thought that MS would have built a bot
for this feature since rank ordering is a very common survey procedure.
What
I might do is go with I have and just tell the survey takers do not rank
the
same item twice and hope they follow instructions. What I am really doing
is
not ranking fruit but asking a class to list their favorite guest speaker
to
their least favorite.
Click to expand...

Tony,

All due respect, I think you are expecting more complex and involved
database features from an application that was not designed to specialize in
what you want. I also think you need to give a lot more credit (intelligence
wise) to your survey population you are going to submit this to. And, the
art of getting the population to do what you want is not only in design, but
in design of the question and directions. It's OK to show an example to
guide their response. The way we laid it out for you, yes... you could
select every item as number 1 ranking. But if you showed an example, it'd be
harder for the participants to screw it up.

All of the samples that you have been given are make sense to us, are valid,
will work. You just want to make it bullet proof, idiot proof and I think
that's asking to much from your software application of choice. Remember,
question design is one of the big reasons for "margin of errors" in every
survey. That's just par for the course.

While ranking is a common survey instrument, it is not a function of
FrontPage. Now you need to explore using Access database, InfoPath, or
possibly buying software specific to the task of designing, deploying
surveys. Ranking the "speakers" 1,2,3,4 a quantitative instrument will
certainly not be as important as the qualitative questions e.g., "Why did
you place this speaker at four?"

Content
Clarity
Voice projection
Knowledge of topic
etc.

How often is this survey going to be conducted? Is this going to be ongoing,
short term, one shot only? Are you willing to spend some money on the proper
software and lastly... sometimes "paper" is better!

Steve Banks
 
Steve,

No, with all due respect I don't think it would expect that much with FP but
that's my opinion. As far as making it bullet proof, this has nothing to with
intelligence of the responder but DB 101, information assurance and data
integrity. I think a Java validation script will probably take care of it.

Paper is not better when the students are scattered throughout the world.

Tony
 
The only issue with using JS (Validation), is that it can be disable in the browser.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thomas,

I didn't think about that. I think I will just do my survey as is. This
became more complex than I wanted.

Tony
 
TonyK said:
Steve,

No, with all due respect I don't think it would expect that much with FP
but
that's my opinion. As far as making it bullet proof, this has nothing to
with
intelligence of the responder but DB 101, information assurance and data
integrity. I think a Java validation script will probably take care of it.

Paper is not better when the students are scattered throughout the world.
Click to expand...

I understand your issues a bit better. The way I understand your approach
now is, I imagined a drop down list containing four people. Once you make
your first choice... the second time you choose you now only have three to
select from and so on. Really negating any chance of error or picking the
number one spot twice or more times.

Ideally it sounds like if you could have four openings (rectangular boxes)
with the four names of the presenters next to the four empty boxes and they
had to drag and drop each of the four names "into" position. That would
solve it also.

So I understand you need a little more now (I think), I just don't know how
to do this. But the drag and drop would be cool and fool proof..

Wish I knew more to really help you... but I think you guys are beyond my
scope of comprehension. If you do devise a solution though, I'd like to hear
it.

Sorry,
Steve Banks
 
Thanks Steve for your patience (and Thomas as well).

You got it...what I was trying to do. I just went ahead and released the
survey but with instructions explaining not to "vote" for someone twice for
the same ranking. If I do another survey I might experiment more with VBS or
JS but don't have time now.

I think it would be cool about the drag and drop. I think you could extend
that logic to making a really compelling survey. People get surveys all the
time and ignore them. Your drag and drop could be like showing a pool of lava
instead of a box and the radio button disintegrating or growing legs when you
hover over them and then trying to run away, etc.
What if you could make a survey like a game like that, "shooting" an item
you didn't like or some other non-traditional way in getting the data, and
perhaps animation or sound in the survey so drops downs may fly way or
transform or other weird stuff would happen while you were taking the
survey...but underneath the fun, the form would still be collecting the data.
Take the survey and we will give you a little fun in return.
Of course this is beyond FrontPage or casual programing and perhaps many
would not want the running radio buttons.

Thanks again, you and Thomas.

Tony
 
Back
Top