please see attachment
Data Analysis #1 (100 pts)
Part 1: (50 pts) Excel workbook: Using the attached Template; score and compute the following statistics for the participants.
Item score: individual performance on each test item (minus the 2-3 essay items (2.5 pts)
Individual raw and mean score: (2.5 pts)
Item Difficulty: (10 pts)
Item Discrimination: (10Pts)
Test or Class Mean Median and Mode scores: (10 pts)
Frequency Distribution & Curve: (5 pts)
Standard Deviation: (5 pts)
Skewness: (5pts)
Part 2: (50 pts) Performance Analysis: Using your findings from Part 1 interpret the performance of the sample and make relevant suggestions. This should be completed in two reflective paragraphs no longer than 1 page total .
1. Summary of Class results (25 points): Discuss and cite specific data that accurately summarizes your class/sample performance on the given assessment. Talk about measures of central tendency (mean, median, mode, frequency distribution, curve, skewness, and objective performance) their meanings and interpretations and what implications do they have on future instruction (how should you use these results).
2. Item Analysis and Reliability (25 points): Discuss relative aspects and findings from your item analysis. What are some potential threats to these findings, how could they be improved and what implications do they have on future instruction (how should you use these results).