Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
stats_candidate [2017/02/13 12:21]
127.0.0.1 external edit
stats_candidate [2017/10/06 10:12] (current)
72.38.112.148
Line 1: Line 1:
-====== ​Competency ​Statistics and Results ====== +====== ​Registrant ​Statistics and Results ====== 
-Table: **ceStatsExamCompetency**+Table: **ceStatsReigstration**
  
-Aggregate of [[Stats_Item|Item Stats]], grouped by Competency.+Aggregate of [[Stats_CandidateItem|Registrant ​Item Stats]], grouped by Registrant.
  
 ^Field^Description^ ^Field^Description^
 |StatsID|Unique Identifier for this set of Statistics| |StatsID|Unique Identifier for this set of Statistics|
-|IsRollup|If true is base Competency rollup (A, A-1, A-2)  If false is the single Competency (A only)| +|RegistrationID|Unique RegistrationID of Candidate for 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.
-|CompetencyID|ID ​of the Competency Items linked to| +|QtyCorrect|Total of all QtyCorrect ​for Candidate ​for all Items on Exam
-|QtyQuestions|Count of all Items in this Competency+|QtySkipped|Total of all QtySkipped ​for Candidate ​for all Items on Exam
-|QtyCorrect|Total of all QtyCorrect for all Items in this Competency+|QtyIncorrect|Total of all QtyIncorrect ​for Candidate ​for all Items on Exam
-|QtySkipped|Total of all QtySkipped for all Items in this Competency+|RawPercent|x = Count of Correct Items for Candidate ​on Exam \\ k = Count of Items on Exam \\ \\ {{:stat_difficulty.png?|}}| 
-|QtyIncorrect|Total of all QtyIncorrect for all Items in this Competency+|ValueCorrect|Total of all ValueCorrect ​for Candidate ​for all Items on Exam
-|RawPercent|x = Count of Correct Items in Competency \\ n = Count of Candidates ​on Exam \\ k = Count of Items in Competency ​\\ \\ {{:stat_rawpercent.png|}}| +|ValueSkipped|Total of all ValueSkipped ​for Candidate ​for all Items on Exam
-|ValueCorrect|Total of all ValueCorrect for all Items in this Competency+|ValueIncorrect|Total of all ValueIncorrect ​for Candidate ​for all Items on Exam|
-|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)| |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)|
 |ValuePercent|{{:​stat_valuepercent.png|}}| |ValuePercent|{{:​stat_valuepercent.png|}}|
-|Difficulty|x = Count of Correct ​Items in Competency \\ n = Count of Candidates on Exam \\ k = Count of Items in Competency \\ \\ {{:stat_difficulty.png|}}| +|Ranking|Candidates Ranking on Exam vs all other Candidates performance on Exam| 
-|ValueMax|Maximum achievable points for Competency from sum off all Value Max of Items in Competency+|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 [[Stats_Exam|Exam Stats]]| 
-|ValueHigh|Highest ValueTotal achieved by a Candidate ​for this Competency+|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 [[Stats_Exam|Exam Stats]]| 
-|ValueLow|Lowest ValueTotal ​achieved ​by a Candidate for this Competency+|PassExam|True if Candidate ValueTotal > PassMark for the Exam.  Additionally,​ if any sections or any Items had requirements to pass, Candidate must pass each of those to pass Exam.| 
-|ValueMean|Mean (average) ValueTotal ​achieved ​by Candidate for this Competency+|IncludeStats|True if Candidate not auditing Exam| 
-|ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Competency+|STScore|{{:​stat_stscore.png?​|}} ​\\ See [[stats_concepts#​alternate_scores|Alternate Scores]]| 
-|ValueVariance|Variance of ValueTotal for all Candidates for this Competency+|Decile|Candidate Decile of Value Total on Exam| 
-|ValueMedian|Median (middle) ValueTotal for all Candidates for this Competency+|zScore|{{:stat_zscore.png?|}}| 
-|ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Competency|+|TScore|{{:​stat_tscore.png?​|}} \\ see [[stats_concepts#​Alternate Scores|Alternate Scores]]| 
 +|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|{{:​stat_valuealternate.png?​|}} \\ See [[stats_concepts#​alternate_scores|Alternate Scores]]| 
 +|ValueAlternateGrade|Future use, link to text Grade based on Alternate Value achieved
 +|ValueNormalized|zScore * AlternateStDev + AlternateMean \\ See [[stats_concepts#​alternate_scores|Alternate Scores]]| 
 +|ValueNormalizedGrade|Future use, link to text Grade based on Normalized Value achieved| 
 +|ValueNormalizedPercent|{{:​stat_valuenormalizedpercent.png?​|}} \\ See [[stats_concepts#​alternate_scores|Alternate Scores]]| 
 +|ValueNormalizedAlternate|{{:​stat_valuenormalizedalternate.png?​|}} \\ See [[stats_concepts#​alternate_scores|Alternate Scores]]| 
 +|Scaled Score|Scales score to common base score \\ see [[calculations#​scaled_scoring|Scaled Scores]]
 +|PROXProportion|Future use
 +|PROXLogit|Future use
 +|PROXCalibration|Future use
 +|PROXCalibrationFinal|Future use| 
 +|PROXCalibrationError|Future use| 
 + 
 +