This is an old revision of the document!
Registrant Statistics and Results
Table: ceStatsReigstration
Aggregate of Registrant Item Stats, grouped by Registrant.
| Field | Description |
|---|---|
| StatsID | Unique Identifier for this set of Statistics |
| IsRollup | If true is a base Competency rollup (A, A-1, A-2) If false is the single Competency (A only) |
| CompetencyID | ID of the Competency Items linked to |
| QtyQuestions | Count of all Items in this Competency |
| QtyCorrect | Total of all QtyCorrect for all Items in this Competency |
| QtySkipped | Total of all QtySkipped for all Items in this Competency |
| QtyIncorrect | Total of all QtyIncorrect for all Items in this Competency |
| RawPercent | x = Count of Correct Items in Competency n = Count of Candidates on Exam k = Count of Items in Competency  fixme graphic description |
| ValueCorrect | Total of all ValueCorrect for all Items in this Competency |
| ValueSkipped | Total of all ValueSkipped for all Items in this Competency |
| ValueIncorrect | Total of all ValueIncorrect for all Items in this Competency |
| ValueTotal | (ValueCorrect + ValueSkipped + ValueIncorrect) |
| ValuePercent |  |
| Difficulty | x = Count of Correct Items in Competency n = Count of Candidates on Exam k = Count of Items in Competency  |
| ValueMax | Maximum achievable points for Competency from sum off all Value Max of Items in Competency |
| ValueHigh | Highest ValueTotal achieved by a Candidate for this Competency |
| ValueLow | Lowest ValueTotal achieved by a Candidate for this Competency |
| ValueMean | Mean (average) ValueTotal achieved by a Candidate for this Competency |
| ValueStdev | Standard Deviation of ValueTotal for all Candidates for this Competency |
| ValueVariance | Variance of ValueTotal for all Candidates for this Competency |
| ValueMedian | Median (middle) ValueTotal for all Candidates for this Competency |
| ValueMode | Mode (most frequent) ValueTotal for all Candidates for this Competency |
| StatsID | Unique Identifier for this set of Statistics |
| RegistrationID | Unique RegistrationID of Candidate for a given Session of the Exam. Candidates can be registered for multiple Sessions of an Exam Candidates can be registered more than once for a Session of the Exam. |
| QtyCorrect | Total of all QtyCorrect for Candidate for all Items on Exam |
| QtySkipped | Total of all QtySkipped for Candidate for all Items on Exam |
| QtyIncorrect | Total of all QtyIncorrect for Candidate for all Items on Exam |
RawPercent x = Count of Correct Items for Candidate on Exam k = Count of Items on Exam x/(k*100)
| ValueTotal | (ValueCorrect + ValueSkipped + ValueIncorrect) |
| ValuePercent | |
| Ranking | Candidates Ranking on Exam vs all other Candidates performance on Exam |
| RankingOdd | Candidates Ranking on odd sequenced Items on Exam vs all other Candidates performance on odd sequenced Items on Exam. Used in Spearman Rank Coefficient. See Exam Stats |
| RankingEven | Candidates Ranking on odd sequenced Items on Exam vs all other Candidates performance on odd sequenced Items on Exam. Used in Spearman Rank Coefficient. See Exam Stats |
| PassExam | True if Candidate ValueTotal > PassMark for the Exam. Additionaly, if any sections or any Items had requirements to pass, Candidate must pass each of those to pass Exam. |
| IncludeStats | True if Candidate not auditing Exam |
| STScore |
see Alternate Scores Note: this is the Same as ValueAlternate Decile Candidate Decile of Value Total on Exam zScore 1)/ExamStDevValue TScore x = Count of Correct Items for Candidate on Exam x ̅ = Mean of QtyCorrect for Exam s = Standard deviation of Candidate QtyCorrect on Exam
Note: Ability provided to override x ̅ and s
2)/s*10+50
| QtyCorrectOdd | Count of odd sequenced Items Candidate answered correctly. Used in calculating RankingOdd |
| QtyCorrectEven | Count of even sequenced Items Candidate answered correctly. Used in calculating RankingEven |
| ValueGrade | Future use, link to text Grade based on Value Total achieved |
| ValueAlternate |
see Alternate Scores
see Alternate Scores
see Alternate Scores
see Alternate Scores
| PROXProportion | Future use |
| PROXLogit | Future use |
| PROXCalibration | Future use |
| PROXCalibrationFinal | Future use |
| PROXCalibrationError | Future use |
