Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
stats_competency [2017/02/13 11:46] 127.0.0.1 external edit |
stats_competency [2017/02/13 12:21] (current) steveclarke |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Item Statistics and Results ====== | + | ====== Competency Statistics and Results ====== |
| - | Table: **ceStatsExamSection** | + | Table: **ceStatsExamCompetency** |
| - | + | ||
| - | Aggregate of [[Stats_Item|Item Stats]], grouped by Section. Also derives some values by aggregating from Candidate performance by Section from [[Stats_Registration_Section|Registration Section Stats]]. | + | |
| + | Aggregate of [[Stats_Item|Item Stats]], grouped by Competency. | ||
| ^Field^Description^ | ^Field^Description^ | ||
| |StatsID|Unique Identifier for this set of Statistics| | |StatsID|Unique Identifier for this set of Statistics| | ||
| - | |SectionID|ID of Section all Items are a member of| | + | |IsRollup|If true is a base Competency rollup (A, A-1, A-2) If false is the single Competency (A only)| |
| - | |QtyQuestions|Count of all Items in this Section| | + | |CompetencyID|ID of the Competency Items linked to| |
| - | |QtyCorrect|Total of all QtyCorrect for all Items in this Section| | + | |QtyQuestions|Count of all Items in this Competency| |
| - | |QtySkipped|Total of all QtySkipped for all Items in this Section| | + | |QtyCorrect|Total of all QtyCorrect for all Items in this Competency| |
| - | |QtyIncorrect|Total of all QtyIncorrect for all Items in this Section| | + | |QtySkipped|Total of all QtySkipped for all Items in this Competency| |
| - | |RawPercent|x = Count of Correct Items in Section \\ n = Count of Candidates on Exam \\ k = Count of Items in Section \\ \\ {{:stat_rawpercent.png|}}| | + | |QtyIncorrect|Total of all QtyIncorrect for all Items in this Competency| |
| - | |ValueCorrect|Total of all ValueCorrect for all Items in this Section| | + | |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 all Items in this Section| | + | |ValueCorrect|Total of all ValueCorrect for all Items in this Competency| |
| - | |ValueIncorrect|Total of all ValueIncorrect for all Items in this Section| | + | |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 Section \\ n = Count of Candidates on Exam \\ k = Count of Items in Section \\ \\ {{:stat_difficulty.png|}}| | + | |Difficulty|x = Count of Correct Items in Competency \\ n = Count of Candidates on Exam \\ k = Count of Items in Competency \\ \\ {{:stat_difficulty.png|}}| |
| - | |RawHigh|Highest QtyCorrect achieved by a Candidate for this Section| | + | |ValueMax|Maximum achievable points for Competency from sum off all Value Max of Items in Competency| |
| - | |RawLow|Lowest QtyCorrect achieved by a Candidate for this Section| | + | |ValueHigh|Highest ValueTotal achieved by a Candidate for this Competency| |
| - | |RawMean|Mean (average) QtyCorrect achieved by a Candidate for this Section| | + | |ValueLow|Lowest ValueTotal achieved by a Candidate for this Competency| |
| - | |RawVariance|Variance of QtyCorrect for all Candidates for this Section| | + | |ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Competency| |
| - | |RawStdev|Standard Deviation of QtyCorrect for all Candidates for this Section| | + | |ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Competency| |
| - | |ValueMax|Maximum achievable points for Group from sum off all Value Max of Items in Section| | + | |ValueVariance|Variance of ValueTotal for all Candidates for this Competency| |
| - | |ValueHigh|Highest ValueTotal achieved by a Candidate for this Section| | + | |ValueMedian|Median (middle) ValueTotal for all Candidates for this Competency| |
| - | |ValueLow|Lowest ValueTotal achieved by a Candidate for this Section| | + | |ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Competency| |
| - | |ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Section| | + | |
| - | |ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Section| | + | |
| - | |ValueVariance|Variance of ValueTotal for all Candidates for this Section| | + | |
| - | |ValueMedian|Median (middle) ValueTotal for all Candidates for this Section| | + | |
| - | |ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Section| | + | |
| - | |KuderRichardson20|k = Count of Items in Section \\ Total Section Variance = Variance of Candidate Raw Scores for Section \\ Sum of p*q = sum of all items p (difficulty) * q (1-p) for all items in Section \\ \\ {{:stat_kr20.png|}}| | + | |
| - | |StandardError|s = StDev of QtyCorrect for Section \\ n = Count of Candidates \\ {{:stat_stderr.png|}}| | + | |
| - | |Skewness|n = Count of Candidates \\ xi = QtyCorrect for each Candidate in Section \\ x = Mean of QtyCorrect in Section \\ s = StDev of QtyCorrect in Section \\ \\ {{:stat_skewness_1.png|}} \\ \\ Calculate Population Skewness using Sample Skewness \\ \\ {{:stat_skewness_2.png|}}| | + | |
| - | |Kurtosis|n = Count of Candidates \\ xi = QtyCorrect for each Candidate in Section \\ x = Mean of QtyCorrect for Section \\ s = StDev of QtyCorrect for Section \\ \\ Calculate Sample Kurtosis {{:stat_kurtosis_1.png|}} \\ \\ Calculate Population Kurtosis using Sample Kurtosis \\ \\ {{:stat_kurtosis_2.png|}}| | + | |
