Author: Manshurov, Sherzod To‘ychiboyevich; Abdug‘aniyeva, Yulduzoy Shaxabidinovna

Annotation: This article presents the development of a Python-based program for processing test questions stored in Excel and generating multiple randomized variants automatically. The program reads questions from an Excel file, separates the text and answer options, shuffles the answers, and reassigns the correct choice. It then creates a specified number of test variants (e.g., 40), each containing a set number of questions, and saves them into a new Excel file with separate sheets. The approach ensures automation, flexibility, and efficiency in preparing diverse test versions, supporting fair assessment and simplifying teachers’ work.

Keywords: Python programming, Excel file, Test questions, Variant generation, Answer shuffling, Automation.

Pages in journal: 765 - 772