Form Dropdown Help

Reed Vial

I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on each category (all numbers don't have to be used, but they can be).

I want the form to be as such:

12 categories listed... under each category, there is a list of the 15 students, and to the right of each student's name, there is a drop down menu to score each student 1-5.

Ex)

Attitude:

Tom (drop down menu with scores 1-5)

Kim (drop down menu with scores 1-5)

Jerry (drop down menu with scores 1-5)

Accountability:

Tom (drop down menu with scores 1-5)

Kim (drop down menu with scores 1-5)

Jerry (drop down menu with scores 1-5)

Paul Newcome

I would suggest either a separate form for each student with the scores listed as dropdowns under each category, or a separate form for each category with the scores listed as dropdowns under each student.