Skip to main content

Overview

The Questions Management feature provides a comprehensive, transversal view of all questions across every dilemma in the platform. This admin-only tool is designed for risk detection and learning gap analysis, helping you identify critical questions with high failure rates and optimize content quality.
Admin-Only Feature: This page is only accessible to administrators. Client users will be redirected to the homepage.

Strategic Purpose

This feature enables:
  • Risk Detection: Identify questions with abnormally high error rates
  • Content Quality Assurance: Find poorly worded or confusing questions
  • Difficulty Calibration: Analyze question difficulty distribution
  • Learning Gap Analysis: Discover topics where users consistently struggle
  • Cross-Dilemma Insights: Compare question performance across different games

Advanced Filtering System

The Questions Management page includes six powerful filters:

Client Filter

Filter by client organization (admin-only; locked for client users)

Dilemma Filter

Show questions from specific dilemmas only

Difficulty Filter

Filter by difficulty: High (≥0.70), Medium (0.40-0.69), Low (<0.40)

Search Filter

Free-text search within question text

Sort Options

Sort by difficulty, attempts, success rate, or error rate

Pagination

Navigate through results (10 questions per page)

Filter Examples

# Find high-risk questions across all clients
?difficulty=high&order_by=error_desc

# Search for questions about ethics in a specific game
?game_id=42&search=ethics

# View most-attempted questions for a client
?client=Acme+Corp&order_by=attempts_desc

Question-Level Metrics

Each question displays comprehensive analytics:

Core Metrics

MetricDescriptionRisk Indicator
Total AttemptsNumber of times the question was answeredLow attempts = low visibility
Success Rate (%)Percentage of correct answers<40% = high difficulty
Error Rate (%)Percentage of incorrect answers>30% = potential issue
Difficulty IndexCalculated difficulty score (0.0-1.0)≥0.7 = High, 0.4-0.69 = Medium, <0.4 = Low
Is Critical FlagManually marked as critical questionRed dot indicator
The Success Rate is color-coded:
  • 🟢 >70% = Green (well-calibrated)
  • 🟡 40-70% = Yellow (moderate difficulty)
  • ⚠️ <40% or 0 = Gray/Red (needs review)

Visual Indicators

Critical Questions are marked with a pulsing red dot (🔴) to draw immediate attention:
<span class="w-2 h-2 rounded-full bg-red-500 shadow-[0_0_8px_rgba(239,68,68,0.5)]"></span>
These are questions that have been flagged as strategically important or high-stakes.

Difficulty Classification System

Questions are automatically classified into three difficulty tiers:

Low Difficulty

Index: <0.40Users find these questions easy. Success rate is typically high.Badge: 🟢 Green

Medium Difficulty

Index: 0.40-0.69Balanced questions with moderate challenge.Badge: 🟡 Yellow

High Difficulty

Index: ≥0.70Challenging questions with high error rates. Review for clarity.Badge: 🔴 Red

Sorting Options

Optimize your workflow with powerful sorting:
  • Mayor Dificultad (Highest Difficulty First): Review hardest questions
  • Menor Dificultad (Lowest Difficulty First): Find questions that may be too easy
  • Más Intentos (Most Attempts): Analyze most-answered questions
  • Menos Intentos (Fewest Attempts): Find under-exposed questions
  • Mayor % Acierto (Highest Success Rate): Identify well-performing questions
  • Mayor % Error (Highest Error Rate): Critical for risk detection
Risk Detection Workflow:Use order_by=error_desc to surface the highest-risk questions immediately. Questions with >40% error rates should be reviewed for:
  • Unclear wording
  • Incorrect answer keys
  • Misleading distractors
  • Overly complex scenarios

CSV Export Functionality

Export filtered question data for external analysis:
1

Apply Filters

Set your desired filters (client, game, difficulty, search, etc.)
2

Click Export

Click the “Exportar Preguntas a CSV” button in the top-right
3

Download CSV

The system generates a CSV file with all filtered questions and their metrics
Export URL Pattern:
export_questions.php?client={client}&game_id={game_id}&difficulty={difficulty}&search={search}&order_by={order_by}
CSV Columns Include:
  • Question text
  • Category
  • Client name
  • Dilemma name
  • Total attempts
  • Success rate (%)
  • Error rate (%)
  • Difficulty index
  • Is critical flag

Pagination System

Results are paginated at 10 questions per page to maintain performance:
  • Navigate with ◀️ Previous / Next ▶️ buttons
  • Jump to specific pages (displays ±2 pages around current)
  • Shows “Showing X - Y of Z preguntas” counter
  • Pagination preserves all active filters
// Pagination logic (questions.php:42-48)
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$questions = get_transversal_questions($filters, $limit, $offset);
$totalPages = ceil($totalQuestions / $limit);

Use Cases

Content Audit

Review all questions across dilemmas to ensure quality and consistency

Difficulty Balancing

Identify dilemmas that are too hard or too easy and adjust question mix

Learning Gap Analysis

Find topics/categories where users consistently struggle

Question Reusability

Identify high-performing questions that can be repurposed

Risk Monitoring

Continuously monitor critical questions for performance degradation

Client Reporting

Export client-specific question performance data for review meetings

Question Detail Navigation

Each question has a “Detalle” button that navigates to a dedicated detail page:
question_detail.php?id={question_id}
This provides:
  • Complete question text and answer options
  • Answer distribution charts
  • User-level response data
  • Time-series performance trends

Access Control

Access Level: Admin-Only
// Access control (questions.php:6-9)
if (!check_is_admin()) {
    header('Location: ' . SITE_URL . '/');
    exit;
}
Non-admin users attempting to access this page are automatically redirected.

Best Practices

For Quality Assurance:
  1. Review questions with error rate >40% monthly
  2. Investigate questions with <10 attempts - they may be in inactive dilemmas
  3. Monitor critical questions weekly
  4. Export data quarterly for trend analysis
  5. Cross-reference high-difficulty questions with user feedback
For Content Optimization:
  1. Balance difficulty: Aim for 20% low, 60% medium, 20% high
  2. Replace questions with consistently poor performance
  3. Use high-performing questions as templates for new content
  4. Ensure critical questions have success rates >60%

Build docs developers (and LLMs) love