![]() ![]() Web Feature: These statistics are primarily for use in the analysis of multiple choice tests. Language Testing and Assessment: An Advanced Resource Book. The spreadsheet was updated in December 2017 and now allows the user to input up to 100 items. When you scroll down the page the spreadsheet calculates the item facility for each item, and the point biserial correlation (Rpbi: a correlation between a dichotomous and a continuous variables). In this spreadsheet you paste item responses as 0's and 1's into the cells, with items along the top row and cases down the left hand column. The Point Biserial Correlation is a measure of discrimination. Item Facility and Point Biserial Correlationĭescription: Item Facility tells us how difficult an item is for the intended population. are summed, and the percentage for each response is also given. ![]() When you scroll down the spreadsheet the number of a's, b's etc. For each case (test taker) you enter the answer they gave to the item as 'a', 'b', 'c' or 'd'. In this spreadsheet the items in the test are listed across the top row, and the cases are in the left column. When you click on the 0's and 1's tab and scroll to the top of the page you will have a set of 0's and 1's that you can cut and paste into other spreadsheets for analysis.ĭescription: Analysis of the number of responses to each of the options in multiple choice items (the key and the distractors) can be used to inform the revision of items to maximise item variance. Each subsequent row is a case, in which you enter the response of that person for each item. On the data input sheet you enter the key in the top row as 'a', 'b', 'c' or 'd' (or another number of options if required). Download here.ĭescription: This spreadsheet converts scores to a set of 0's and 1's. There are additional instructions in portable document format for Cronbach's alpha and the Score Converter. In order to do this, click on the expand button in the top right as shown in this illustration. When you first open a file make sure that the spreadsheet is maximised in Excel so you can see all the scroll bars and tabs. ![]() The spreadsheet for Cronbach's alpha also handles partial credit data. ![]() These include distractor analysis, item facility, a discrimination index, reliability, and descriptive statistics (mean, standard deviation, and standard error of measurement). The five spreadsheets calculate the basic statistics developed in classical test analysis for closed response items such as multiple choice. The Excel spreadsheets on this page have all been written by William Bonk (University of Colorado), who kindly donated them to the Language Testing Resources website when he was no longer able to distribute them through his own web page. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |