Wordlist Lookup Tool: An Excel Workbook for Checking Draft Test Items Against a Reference Wordlist

Résumé fourni par la source

A two-sheet Microsoft Excel workbook for checking draft test items against a reference wordlist. Draft text is pasted into a single cell; TEXTSPLIT parses it into tokens and XLOOKUP returns frequency and coverage metadata for each one from the Wordlist sheet. No add-ins or macros. Requires Excel 2021 or Microsoft 365 for dynamic array support. Companion to Chak & Wong, "Using Microsoft Excel for Wordlist Navigation and Management in Test Development," Shiken.

Ce résumé expose les affirmations des auteurs. BNTIC ne l’interprète pas comme une validation indépendante des résultats.