Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
stats_item [2017/02/10 11:57] 127.0.0.1 external edit |
stats_item [2018/04/10 11:17] (current) 72.38.112.148 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Exam Statistics and Results ====== | + | ====== Item Statistics and Results ====== |
| - | Table: **ceStatsExam** | + | Table: **ceStatsExamQuestion** |
| - | Aggregation of all [[Stats_Item|Item Stats]] for the Exam. | + | Aggregate of [[stats_candidate_item|Candidate Item Stats]] for 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| | ||
| - | |QtyQuestions|Count of all Items on the Exam| | + | |QuestionID|ID of Item in the Bank| |
| - | |QtyCandidates|Count of all Candidates taking the Exam| | + | |Sequence|Sequence of Item on the Exam| |
| - | |QtyCompetencies|Count of distinct Competencies from all Items on the Exam| | + | |ValueMax|Maximum achievable points for Item| |
| - | |QtySections|Count of Sections on the Exam| | + | |QtyCorrect|Total of all QtyCorrect for Item for all Candidates| |
| - | |ValueMax|Maximum achievable points for Exam, from sum of all Value Max of Items on the Exam| | + | |QtySkipped|Total of all QtySkipped for Item for all Candidates| |
| - | |QtyCorrect|Total of all QtyCorrect for all Items on the Exam| | + | |QtyIncorrect|Total of all QtyIncorrect for Item for all Candidates| |
| - | |QtySkipped|Total of all QtySkipped for all Items on the Exam| | + | |RawPercent|x = Count of Correct Items on Exam \\ n = Count of Candidates on Exam \\ \\ {{:stat_rawpercent_candidate.png|}}| |
| - | |QtyIncorrect|Total of all QtyIncorrect for all Items on the Exam| | + | |ValueCorrect|Total of all ValueCorrect for Item for all Candidates| |
| - | |RawPercent|x = Count of Correct Items on Exam \\ n = Count of Candidates on Exam \\ k = Count of Items on Exam \\ \\ {{:stat_rawpercent.png|}}| | + | |ValueSkipped|Total of all ValueSkipped for Item for all Candidates| |
| - | |ValueCorrect|Total of all ValueCorrect for all Items on the Exam| | + | |ValueIncorrect|Total of all ValueIncorrect for Item for all Candidates| |
| - | |ValueSkipped|Total of all ValueSkipped for all Items on the Exam| | + | |
| - | |ValueIncorrect|Total of all ValueIncorrect for all Items on the Exam| | + | |
| |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| | |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| | ||
| |ValuePercent|{{:stat_valuepercent.png|}}| | |ValuePercent|{{:stat_valuepercent.png|}}| | ||
| - | |Difficulty|x = Count of Correct Items on Exam \\ n = Count of Candidates on Exam \\ k = Count of Items on Exam \\ \\ {{:stat_difficulty.png|}}| | + | |Difficulty|x = Count of Correct Items on Exam \\ n = Count of Candidates on Exam \\ \\ {{:stat_difficulty_candidate.png|}}| |
| - | |RawHigh|Highest QtyCorrect achieved by a Candidate on the Exam| | + | |QuestionDiscrimination|A value between -1 and 1 \\ \\ Q1 is the Count of Candidates who responded correctly to Item whose Value total is in the top 27% of all Candidates taking the Exam. \\ Q4 is the Count of Candidates who responded correctly to Item whose Value total is in the bottom27% of all Candidates taking the Exam. \\ n = Count of Candidates \\ \\ {{:stat_questiondiscrimination.png|}}| |
| - | |RawLow|Lowest QtyCorrect achieved by a Candidate on the Exam| | + | |BiserialExam|Future| |
| - | |RawMean|Mean (average) QtyCorrect achieved by a Candidate on the Exam| | + | |PointBiserialExam|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |RawVariance|Variance of QtyCorrect for all Candidates on the Exam| | + | |BiserialCorrectedExam|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |RawStdev|Standard Deviation of QtyCorrect for all Candidates on the Exam| | + | | |
| - | |ValueHigh|Highest ValueTotal achieved by a Candidate on the Exam| | + | |PointBiserialCorrectedExam|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |ValueLow|Lowest ValueTotal achieved by a Candidate on the Exam| | + | |BiserialSection|Future| |
| - | |ValueMean|Mean (average) ValueTotal achieved by a Candidate on the Exam| | + | |PointBiserialSection|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |ValueVariance|Variance of ValueTotal for all Candidates on the Exam| | + | |BiserialCorrectedSection|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |ValueStdev|Standard Deviation of ValueTotal for all Candidates on the Exam| | + | |PointBiserialCorrectedSection|See [stats_concepts#biserial_calculations|Biserials]]| |
| - | |ValueMedian|Median (middle) ValueTotal for all Candidates on the Exam| | + | |BiserialCompetency|Future| |
| - | |ValueMode|Mode (most frequent) ValueTotal for all Candidates on the Exam| | + | |PointBiserialCompetency|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |PercentDistribution|Text field which holds a summary of the score distributions. Not a statistic, but used in reporting| | + | |BiserialCorrectedCompetency|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |QtyPassExam|Count of Candidates that passed Exam. See Candidate Statistics (PassExam) FIXME link| | + | |PointBiserialCorrectedCompetency|See [[stats_concepts#biserial_calculations|Biserials]]| |
| - | |SpearmanRank|n = Number of Candidates \\ RankOdd = Candidates Ranking on Odd Items only compared to all other Candidates on Exam \\ RankEven = Candidates Ranking on Odd Items only compared to all other Candidates on Exam \\ \\ {{:stat_spearmanrank.png|}}| | + | |ValueLow|Lowest ValueTotal achieved by a Candidate for this Item| |
| - | |SpearmanBrown|{{:stat_spearmanbrown.png|}}| | + | |ValueHigh|Highest ValueTotal achieved by a Candidate for this Item| |
| - | |KuderRichardson20|k = Count of Items on Exam \\ Total Test Variance = Variance of Candidate Raw Scores \\ Sum of p*q = sum of all items p (difficulty) * q (1-p) for all items in Exam \\ \\ {{:stat_kr20.png|}}| | + | |ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Item| |
| - | |KuderRichardson21|qtyX = Count Items answered correctly on Exam \\ x ̅ = Mean of QtyCorrect for each Candidate on Exam \\ s = StDev of Raw Scores of all Candidates on Exam \\ \\ {{:stat_kr21.png|}}| | + | |ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Item| |
| - | |StandardError|s = StDev of QtyCorrect for Exam \\ n = Count of Candidates \\ {{:stat_stderr.png|}}| | + | |ValueVariance|Variance of ValueTotal for all Candidates for this Item| |
| - | |AlphaCoefficient|k = Count of Items on Exam \\ Total Test Variance = Variance of Candidate Raw Scores \\ Sum of Item Variance = Sum of all item variances on Exam \\ \\ {{:stat_alphacoefficient.png|}}| | + | |ValueMedian|Median (middle) ValueTotal for all Candidates for this Item| |
| - | |Skewness|n = Count of Candidates \\ xi = QtyCorrect for each Candidate on Exam \\ x ̅ = Mean of QtyCorrect on Exam \\ s = StDev of QtyCorrect on Exam \\ \\ {{:stat_skewness_1.png|}} \\ \\ Calculate Population Skewness using Sample Skewness \\ \\ {{:stat_skewness_2.png|}}| | + | |ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Item| |
| - | |Kurtosis|n = Count of Candidates \\ xi = QtyCorrect for each Candidate on Exam \\ x ̅ = Mean of QtyCorrect for Exam \\ s = StDev of QtyCorrect for Exam \\ \\ Calculate Sample Kurtosis {{:stat_kurtosis_1.png|}} \\ \\ Calculate Population Kurtosis using Sample Kurtosis \\ \\ {{:stat_kurtosis_2.png|}}| | + | |QtyCorrectTop50|Count of Candidates who responded correctly to Item whose Value total was in top 50% of all Candidates taking Exam| |
| - | |AlternateSystem|Stores Alternate Value used for Calculation (True, Custom, ZScore, TScore,…) see Alternate Scores FIXME link| | + | |QtyCorrectBottom50|Count of Candidates who responded incorrectly to Item whose Value total was in top 50% of all Candidates taking Exam| |
| - | |AlternateBase|Alternate used in Alternate Calculations see Alternate Scores FIXME link| | + | |TimeTotal|Total Time for all Candidates on this Item. Used in [[start#CE Online Testing|Online Testing]]| |
| - | |AlternateMean|Alternate Mean used in Alternate Calculations see Alternate Scores FIXME link| | + | |Dichotomous|True if Item has one correct response worth 1 point and all other responses are incorrect worth 0 points.| |
| - | |AlternateStDev|Alternate Standard Deviation used in Alternate Calculations see Alternate Scores FIXME link| | + | |IncludeInStats|See [[Stats_Concepts#Include in Stats|Include in Stats]]| |
| - | |QuestionLogitSum|Future use| | + | |PROXScore|Future use| |
| - | |QuestionLogitMean|Future use| | + | |PROXProportion|Future use| |
| - | |QuestionLogitVariance|Future use| | + | |PROXLogit|Future use| |
| - | |QuestionLogitSquaredSum|Future use| | + | |PROXCalibration|Future use| |
| - | |QuestionSpreadExpansion|Future use| | + | |PROXCalibrationFinal|Future use| |
| - | |CandidateLogitSum|Future use| | + | |PROXCalibrationError|Future use| |
| - | |CandidateLogitMean|Future use| | + | |
| - | |CandidateLogitVariance|Future use| | + | |
| - | |CandidateLogitSquaredSum|Future use| | + | |
| - | |CandidateSpreadExpansion|Future use| | + | |
