This is an old revision of the document!
Registrant Item Group Statistics and Results
Table: ceStatsRegistrationQuestionGroup
Aggregate of Registrant Item statistics, grouped by GroupID.
| Field | Description |
|---|---|
| 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 |
| GroupID | ID of Item Group Items are linked to |
| QtyCorrect | Total of all QtyCorrect for Candidate for all Items in Group |
| QtySkipped | Total of all QtySkipped for Candidate for all Items in Group |
| QtyIncorrect | Total of all QtyIncorrect for Candidate for all Items in Group |
RawPercent x = Count of Correct Items for Candidate in Group k = Count of Items in Group x/(k*100)
| ValueCorrect | Total of all ValueCorrect for Candidate for all Items in Group |
| ValueSkipped | Total of all ValueSkipped for Candidate for all Items in Group |
| ValueIncorrect | Total of all ValueIncorrect for Candidate for all Items in Group |
| ValueTotal | (ValueCorrect + ValueSkipped + ValueIncorrect) |
| ValuePercent |  |
| TimeTotal | Total Time for all Items in Group Used in Online testing  link |
| ValueMax | Maximum achievable points from all Items in Group |
| Ranking | Candidates Ranking on Group vs all other Candidates performance on Group |
| Decile | Candidate Decile of Value Total on Group |
| CandidateHigh | True if Candidate achieved highest Mark on this Item Group |
| IncludeStats | True if Candidate not auditing Exam. See Include in Stats |
| 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  |
| 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 |
