...
Quantity Field: single select from dropdown list contents (3, 4, 5); required
Scoring Type: single select from dropdown list contents (Percentile Range, Raw Score) ; required
Benchmark label: Smart select or custom enter with 30 character limit; optional
Dropdown contents listed in alphabetical order: At/Above, Avg, HiAvg, High, Intervention, LoAvg, Low, On Watch, Urgent, Other
As additional custom entries are made we add them to the list in alphabetical order
Always maintain an 'Other” option as the last on the list
Scoring Type: Percentile Range
If user edits Quantity Field (4, 5, 6), then additional lines are created.
If user edits Quantity Field (4, 5, 6), then percentile ranges are determine by an equal division from 100% to 0% for the number selected in the Quantity field
If user edits Quantity Field (4, 5, 6), then Tier Mapping locks the top most line as Tier 1 and the bottom most line as Tier 3 after user selects from Quantity field.
The top most line contains the locked maximum value as 100%
The bottom most line contains the locked minimum value as 0%
Score ranges assigned to the Tiers are mutually exclusive and all inclusive
Tiers are shown in this order from top to bottom: Tier 1, Tier 2, Tier 3.
There must be at least one of each for Tier 1, Tier 2, Tier 3
Tier Mapping is in order of Tier 1 to Tier 3 where multiple mapping are possible for the Tiers BUT the order persists from Tier 1 to Tier 3.
Example: Quantity field: 4, Tier Mapping from top to bottom can read: Tier 1, Tier 1, Tier 2, Tier 3 or Tier 1 Tier 2, Tier 2, Tier 3 or Tier 1, Tier 2, Tier 3, Tier 3
Non-Example: Quantity field: 4 Tier Mapping from top to bottom CANNOT read: Tier 1, Tier 3, Tier 2, Tier 1
The Percentile Ranges contain the highest values for the top-most line ( Tier 1) and lowest values for the bottom-most line (Tier 3)
Scoring Type: Raw Score
Max Score limit is 3000
Min Score limit is 0
Maximum Score (Max Score) must be larger than Minimum Score (Min Score)
If user edits Quantity Field (4, 5, 6), then additional lines are created.
If user edits Quantity Field (4, 5, 6), then score ranges are determine by an equal division from Max Score value to Min Score value for the number selected in the Quantity field
If user edits Quantity Field (4, 5, 6), then Tier Mapping locks the top most line as Tier 1 and the bottom most line as Tier 3.
The top most line contains the locked maximum value as the value entered for Max Value field
The bottom most line contains the locked minimum value as the value entered for Min Value field
Score ranges assigned to Tiers are mutually exclusive and all inclusive
There must be at least one of each for Tier 1, Tier 2, Tier 3
The Raw Score Ranges contain the highest values for the top-most line ( Tier 1) and lowest values for the bottom-most line (Tier 3)
Validation: The default setting is for 3 lines and the order is: Tier 1, Tier 2, Tier 3. If changes are made to the Quantity field, then the topmost line is locked at Tier 1 and the bottom-most line is locked at Tier 3 after user selects from the Quantity field.
All tiers must be included at least once. We cannot show the tiers out of order from top to bottom so Tier 3 can never be shown in line 2 and Tier 1 can never be shown in the bottom most line for the quantity selected (Quantity field selection of 4, 5, or 6)
If the User enters into the Quantity field (4, 5, 6) we still need to keep the order for Tier mapping. An example with 4 selected in the Quantity field has these possibilities for the four lines with line 1 beginning with T1:
T1, T1, T2, T3
T1, T2, T2, T3
T1, T2, T3, T3
Field Mapping Tab
Upload Sample Template button upload the heading of the data set selected and prefills the Select field drop down with those headings
Required Fields: If Percentile Range is selected from Scoring Type, then the required fields are: StudentID, CompletionDate, PercentileRank, ScaledScore
Required Fields: If Raw Score is selected from Scoring Type, then the required fields are: StudentId, CompletionDate, RawScore,
Show Tooltip: Optional checkbox with default as unchecked
Clicking checkbox for Show Tooltip opens a text box
User text enters Tooltip contents
Select Field: Dropdown contains the headings from Unload Sample Template
User clicks on Select field dropdown arrow and makes a selection
Add Note: Clicking Add note opens an optional text enter box
User types note and selects Save to have note appear
Users can remove note by clicking Cancel
Add Custom Field: Opens an additional line to Custom enter the Field, optional text entry field description, Show Tooltips checkbox, Select field dropdown, and Add Note.
Save button: Saves all work completed
Cancel button: Removes all work completed and restores to the default for all fields
...