An advanced AI agent skill designed to generate interactive exam analysis dashboards and beautiful, WeChat-ready output directly from Excel or CSV data.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install exam-dashboard
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install exam-dashboard using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Exam Dashboard Skill?
The Exam Dashboard skill is a professional data analysis and formatting tool developed for educational environments and content creators. It bridges the gap between raw statistical data (like student grade sheets) and stunning, presentation-ready visualizations. Instead of manually wrangling Excel formulas and plotting rigid charts, this skill automatically computes advanced psychometric indicators—such as difficulty, discrimination, reliability (Cronbach's alpha), and validity—while producing interactive web dashboards.
By leveraging this solution from the Openclaw Skills ecosystem, educators and administrators can instantly turn student scores into comprehensive evaluation reports. Additionally, it outputs fully typeset, responsive HTML code specifically formatted for WeChat Official Accounts, saving hours of manual layout adjustment.
Exam Dashboard Skill Use Cases
- Teachers and professors needing deep insights into final exam distributions, difficulty curves, and student performances.
- School administrators looking to generate standardized, publication-quality academic evaluation reports in Word or PDF formats.
- Educational content creators and social media managers who want to publish visually appealing exam statistics directly to WeChat Official Accounts.
- Psychometricians who require advanced analysis such as Item Response Theory (IRT) and reliability testing without writing code.
How Exam Dashboard Skill Works
- Skill Activation: The user activates the environment with the
/load-skill exam-dashboardcommand. - Data Ingestion: The AI agent prompts the user to upload an Excel (
.xlsxor.xls) or CSV file structured with student IDs/Names followed by raw question scores. - Statistical Computation: The backend executes rigorous statistics utilizing pandas, scipy, and scikit-learn, calculating over 20 advanced analytics parameters.
- Visual & Report Generation: The skill renders a dynamic HTML dashboard (using Plotly), formats WeChat-compatible HTML using Jinja2 templates, and exports offline reports.
- Delivery: The user receives interactive HTML dashboards, ready-to-copy WeChat layouts, and high-resolution chart images (PNG/SVG) for presentation slides.
Exam Dashboard Skill Setup
To utilize this module within the Openclaw Skills framework, ensure the necessary Python packages are installed in your environment:
pip install pandas numpy matplotlib plotly seaborn scipy scikit-learn jinja2 python-docx openpyxl
Once the dependencies are ready, you can initialize the skill inside your agent terminal:
/load-skill exam-dashboard
Exam Dashboard Skill Data Schema & Taxonomy
The skill requires a structured dataset in Excel or CSV format. It expects the following column schema:
| Column Position | Expected Content | Examples / Rules |
|---|---|---|
| Column 1 | Student Identifier | Student ID or Name (e.g., 20260101 or Alice) |
| Columns 2 to N-1 | Individual Question Scores | Raw points earned for Question 1, Question 2, etc. |
| Column N (Optional) | Total Score | If omitted, the skill will automatically calculate the sum. |
Generated File Outputs:
dashboard.html: Fully interactive Plotly-based HTML dashboard containing all 20+ charts.wechat_article.html: A custom Jinja2-rendered HTML document optimized for copy-pasting directly into the WeChat Official Account editor.report.docx: A professional evaluation Word document with statistical interpretations./images/: Directory containing standalone static images (PNG/SVG) of all visualized metrics.
Exam Dashboard Skill Advanced Features
- Comprehensive Psychometric Analysis: Computes sophisticated educational testing standards including Cronbach's alpha coefficient, validity index, Item Characteristic Curves (IRT models), and student ability distribution.
- WeChat Layout Optimization: Automates complex inline CSS styling specifically tested to prevent formatting breakage when pasting into WeChat's rich text editor.
- Robust Data Preprocessing: Gracefully handles missing values, detects and highlights anomalies (e.g., cheating signatures, outlier scores), and fully supports Chinese font rendering natively.
- Multi-Class Comparative Dashboarding: Generates comparative radar and grouped bar charts to easily benchmark academic performance across multiple classrooms or semesters.
SKILL.md
Loading
Related Openclaw Skills
The Color of Water Skill
An executable AI-powered toolkit for analyzing identity, race, and resilience themes in James McBride's dual-narrative memoir The Color of Water.
Arabic RTL Layout Checker Skill
An automated review skill that checks Arabic and right-to-left layout alignment, text shaping, translation quality, and typography before you publish.
Product Validation Planner
A structured planner that helps creators validate SaaS ideas, design creative briefs, and formulate highly actionable strategies for Ask HN style feedback.
Product Validation Planner
An AI-powered validation assistant that helps creators refine and structure product feedback campaigns, specifically optimized for Ask HN requests.
The Right Stuff
An executable AI coding agent skill mapping Tom Wolfe's analysis of the golden age of American test pilots, the Mercury 7, and the psychology of extreme risk.
Second Brain Growth Evaluator
An advanced evaluation tool for auditing the growth, connectivity, and practical actionability of your markdown-based second brain using AI-driven metric groups.
Featured*
