Auction Registration
HELLO WORLD
The first six of these downloadables are Excel spreadsheets that I made to calculate classical testing statistics. I know, I should combine them all into one big spreadsheet but I'm too busy with other things these days. Instructions are included in the downloads when necessary. Other downloads are below.
1. This file will take raw multiple-choice data (ABCD etc.) and convert them to 0s and 1s when you put in the correct answer key - so it essentially scores the test for you. It can handle up to 200 items and 3000 examinees. It's over 3 MB to download but it inflates to something like 25 MB. 0s and 1s converter
2. This file takes raw multiple choice data, rating scales data, or 0s and 1s data and calculates Cronbach's alpha. This yields the exact same calculation as KR-20 for dichotomously scored data. It can handle up to 200 items and 3000 examinees. cronbachsalpha.zip
3. This file will take your multiple-choice data and tell you what percent of the responses to each item were A, B, C, and D. distractoranalysis.zip
4. This file will correct correlations for attenuation due to unreliability, and will also calculate the reliability of gain scores. gain scoresandattenuation.xls
5. This file will calculate KR-21 for you - all you need to know is the number of items in the test, the mean score, and the standard deviation of scores. It's good for a quick estimate of a test's internal consistency when you don't have the raw data (like when looking at someone else's published results). KR21macrosheet.xls
6. This file calculates the point-biserial correlation for each of your test items. point biserial calculator
7. This is an explanation of how to interpret FACETS output based on how your facets are oriented. facets explanation
8. This is a little Applescript that will help you put attachments into e-mail messages if you are using Apple's Mail application. It's already compiled, all you do is put it into your Applications folder, then drag its icon to your Dock. When you want to attach files to a new e-mail message, just select them in the Finder and click on the attaché icon - it will create a new e-mail with those files already in, no dragging necessary. attaché
9. This is a pdf of my master's degree research from the University of Hawai`i, which was published in 2001. The complete reference is:
Bonk, W. (2001). Testing ESL learners' knowledge of collocations. In T. Hudson & J. D. Brown (Eds.), A focus on language test development: Expanding the language proficiency construct across a variety of tests (Technical Report #21) (pp. 113-142). Honolulu: University of Hawai'i, Second Language Teaching & Curriculum Center. bonk collocation test
10. This is a study of ESL listening comprehension related to lexical knowledge that was published in 2000. The complete reference is
Bonk, W. (2000). Second language lexical knowledge and listening comprehension. International Journal of Listening, 14, 14-31. lexical knowledge ESL study
If you've found anything on here useful or would like to give me feedback on it, send me e-mail: bonk at colorado.edu
Check out my new photos website: here