Currently, teachers are forced to follow a two-step workflow:
(1) select the question,
(2) select the corresponding answer keys.

This process is cumbersome, error-prone, and highly inefficient . It consumes significant time, often leads to mismatches, and the resulting configuration cannot be reused or stored systematically.

Teachers urgently need a single-file import—modeled after the existing Test Import template—but specifically optimized for Answer Sheet setup. In this version, there is no question text column, as the system does not store question content; instead, each item is defined by Order No. (1, 2, 3…) to represent question sequence.

This approach would allow teachers to prepare the complete answer key and question setup in one structured file, eliminating repeated steps, reducing errors, and enabling proper storage and reuse.

Functional Requirements

1. One-file Excel Import

• System must support uploading one Excel file (.xlsx).

• Each worksheet/tab corresponds to exactly one question.

• Tab name format must follow: Multiple Choice, Multi-Select, True or False, True or False, Fill in the blanks, Q & A

• Import must generate:

• Full Question Setup

• Correct Answer

• Order No. mapping