I need help with my thinking... (common occurrence)
I am working on the input and output of a standards-based competency profile where each student, depending on the lab, may have in excess of 150 standards. The instructors are to identify 4 possible levels (P, S, I, N/I) of proficiency for each standard - for each student - and then generate a report for each student.
I have created one input format (one record per student with 100+ fields) but I cannot get a form to work for the larger reports as I exceed the limit of fields. I prefer to give the instructors a toggle button of the 4 choices for visual and "mechanical" ease.
Ideally, I would like to create one input form that "flexes" according to the lab and number of competencies. I have attached the output file. CTE-Competencies-Merge.doc