Academic analyst and exam pattern extractor

ROLE: Act as an expert academic analyst and exam pattern extractor.

Category	Study › Exams
Tags	AnalyzingSummarizingCollege student

Prompt

ROLE: Act as an expert academic analyst and exam pattern extractor.

GOAL:
Given a question paper PDF (containing class test and final exam questions), classify ALL questions into a structured format for study and pattern recognition.

OUTPUT FORMAT (STRICT — MUST FOLLOW EXACTLY):

Classification of Questions by Chapter and Type

Chapter X: [Chapter Name]

X.1 Definition & Conceptual Questions

[Year/Exam].[Question No]: [Full question text]

[Year/Exam].[Question No]: [Full question text]

X.2 Mathematical/Analytical Questions

[Year/Exam].[Question No]: [Full question text]

...

X.3 Algorithm / Procedural Questions

...

X.4 Programming / Implementation Questions

...

X.5 Comparison / Justification Questions

...

--------------------------------------------------

INSTRUCTIONS:

1. FIRST, identify chapters based on syllabus-level grouping (Syllabus can be found in the pdf).
2. THEN group questions under appropriate chapters.
3. WITHIN each chapter, classify into types:
   - Definition & Conceptual
   - Mathematical / Numerical
   - Algorithm / Step-based
   - Programming / Code
   - Comparison / Justification

4. PRESERVE original wording of each question. (Paraphrase to shorten without losing context)
5. INCLUDE exact reference in this format:
   - class test (CT) 2023 Q1
   - Final 2023 Q2(a)

6. DO NOT skip any question.
7. Merge questions only if they are extremely same and add a number tag of how many of that ques was merged — else keep each separately listed.
8. DO NOT explain anything — ONLY classification output.
9. Maintain clean spacing and readability.

10. If a question has multiple subparts (a, b, c), list them separately:
   Example:
   2023 Q2(a): ...
   2023 Q2(b): ...

11. If chapter is unclear, infer based on topic intelligently.

12. Prioritize accuracy over speed.

13. Add frequency tags like [Repeated X times], [High Frequency]

14. If the document is noisy or contains formatting issues, carefully reconstruct questions before classification.

What this prompt does

Suited for past-exam analysis and study planning. It requires classification only, with no explanations, and asks the model to reconstruct noisy PDF questions without skipping any.

Model comparison

Claude is the most accurate but adds forbidden extras. Gemini best matches the format, while ChatGPT loses accuracy through duplication.

Claude

41/ 50

＋ All questions are assigned to suitable chapters and types.

－ It adds a prohibited summary table and explanatory note.

Gemini

41/ 50

＋ It follows the required heading and taxonomy most closely.

－ It labels every item high-frequency without evidence.

ChatGPT

38/ 50

＋ It concisely preserves wording and exam references well.

－ It duplicates Final Q2 and misuses the repetition tag.

Criterion	ChatGPT	Claude	Gemini	Leader
Instruction following	7	7	8	Gemini +14%
Accuracy	6	9	7	Claude +29%
Specificity	8	9	8	Claude +13%
Structure	8	9	9	Tie
Right length	9	7	9	Tie

Scored 1–10 by gpt-5.6-sol with model names hidden (2026-09-24). This is an AI review, not a measurement.

Read full answers

We gave three models the same input and copied their answers unedited. Each ran in its CLI (an agent harness), and answers in the ChatGPT or Claude apps or on the web may differ. Outputs are in Korean.

Input used

[Pasted material]
다음은 '데이터베이스 시스템' 과목 중간고사와 기말고사 문제를 텍스트로 옮긴 것입니다. 이 내용을 기준으로 분류해주세요.

[중간고사 2024]
Q1. 제3정규형(3NF)의 정의를 서술하고 예시를 들어 설명하라.
Q2(a). 다음 릴레이션에서 후보키를 모두 구하라. R(A,B,C,D), FD: A→B, B→C, C→D
Q2(b). 위 릴레이션이 BCNF를 만족하는지 판단하고 이유를 설명하라.
Q3. B+ Tree 인덱스에서 삽입 연산의 과정을 단계별로 설명하라.

[기말고사 2024]
Q1. 트랜잭션의 ACID 특성을 각각 설명하라.
Q2. 2단계 잠금 프로토콜(2PL)을 이용하여 교착상태가 발생하는 예시를 작성하고 해결 방법을 논하라.
Q3. SQL로 다음 질의를 작성하라: 각 학과별 평균 학점이 3.5 이상인 학과명을 출력하라.
Q4. 정규화 이전 릴레이션을 BCNF까지 분해하는 과정을 직접 수행하라.

gpt-5.6-luna (codex CLI · 에이전트 하네스) · Run on 2026-09-24

Classification of Questions by Chapter and Type

Chapter 1: 데이터베이스 정규화

1.1 Definition & Conceptual Questions

중간고사 2024 Q1: 제3정규형(3NF)의 정의를 서술하고 예시를 들어 설명하라. [High Frequency]

1.2 Mathematical/Analytical Questions

중간고사 2024 Q2(a): 다음 릴레이션에서 후보키를 모두 구하라. R(A,B,C,D), FD: A→B, B→C, C→D. [High Frequency]

기말고사 2024 Q4: 정규화 이전 릴레이션을 BCNF까지 분해하는 과정을 직접 수행하라. [High Frequency]

1.5 Comparison / Justification Questions

중간고사 2024 Q2(b): 위 릴레이션이 BCNF를 만족하는지 판단하고 이유를 설명하라. [Repeated 2 times] [High Frequency]

Chapter 2: 인덱싱 및 B+ Tree

2.3 Algorithm / Procedural Questions

중간고사 2024 Q3: B+ Tree 인덱스에서 삽입 연산의 과정을 단계별로 설명하라.

Chapter 3: 트랜잭션 및 동시성 제어

3.1 Definition & Conceptual Questions

기말고사 2024 Q1: 트랜잭션의 ACID 특성을 각각 설명하라.

3.3 Algorithm / Procedural Questions

기말고사 2024 Q2: 2단계 잠금 프로토콜(2PL)을 이용하여 교착상태가 발생하는 예시를 작성하고 해결 방법을 논하라.

3.5 Comparison / Justification Questions