Differences

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

Link to this comparison view

Next revision
Previous revision
stats_candidate_item [2017/02/13 12:21]
127.0.0.1 external edit
stats_candidate_item [2017/03/21 11:16] (current)
steveclarke
Line 1: Line 1:
-====== ​Competency ​Statistics and Results ====== +====== ​Registrant Item Statistics and Results ====== 
-Table: **ceStatsExamCompetency**+Table: **ceStatsRegistrationQuestion**
  
-Aggregate of [[Stats_Item|Item Stats]], grouped by Competency.+Each Candidate is evaluated against each Item on the Exam.
  
 ^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+|QuestionID|ID of Item in the Bank
-|QtyQuestions|Count of all Items in this Competency+|Sequence|Sequence ​of Item on the Exam
-|QtyCorrect|Total of all QtyCorrect for all Items in this Competency+|QtyCorrect|0 = Candidate did not answer correctly \\ 1 = Candidate answered correctly
-|QtySkipped|Total of all QtySkipped for all Items in this Competency+|QtySkipped|0 = Candidate responded to this Item \\ 1 = Candidate did not respond to this Item
-|QtyIncorrect|Total of all QtyIncorrect for all Items in this Competency+|QtyIncorrect|0 = Candidate did not answer incorrectly \\ 1= Candidate answered correctly
-|RawPercent|Count of Correct Items in Competency ​\\ Count of Candidates on Exam \\ k = Count of Items in Competency \\ \\ {{:​stat_rawpercent.png|}}+|RawPercent|Candidate did not respond or answered incorrectly ​\\ 100 Candidate answered correctly
-|ValueCorrect|Total of all ValueCorrect for all Items in this Competency+|ValueCorrect|Points awarded if answered correctly
-|ValueSkipped|Total of all ValueSkipped for all Items in this Competency+|ValueSkipped|Points awarded/​penalized if skipped
-|ValueIncorrect|Total of all ValueIncorrect for all Items in this Competency+|ValueIncorrect|Points awarded/​penalized if answered incorrectly
-|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|}}+|TimeTotal|Used in [[start#CE Online Testing|Online Testing]]
-|ValueMax|Maximum achievable points for Competency from sum off all Value Max of Items in Competency+|Ranking|Candidates Ranking on Item vs all other Candidates performance on Item
-|ValueHigh|Highest ValueTotal achieved by a Candidate ​for this Competency| +|Decile|Candidate ​Decile of Value Total on Item vs all other Candidate ​performance on Item
-|ValueLow|Lowest ValueTotal achieved by a Candidate ​for this Competency+|PassQuestion|True if Multiple Choice and Correct or Essay and Value>​PassMark ​of Item
-|ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Competency| +|CandidateHigh|True if Candidate achieved highest Mark on this Item
-|ValueStdev|Standard Deviation ​of ValueTotal for all Candidates for this Competency+|IncludeStats|True if Candidate not auditing Exam and Item is not experimental See [[stats_Concepts#​Include In Stats|Include in Stats]]|
-|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| +