Continuing Education Informatization Platform Operations Report Generator

Problem

Operations reports for higher continuing education informatization platforms often require consolidating Excel files covering logins, live classes, delivery progress, demand management, institutional coverage, staffing, and exams into fixed chapters. Manually copying metrics, checking periods, and redrawing charts easily creates formatting drift and inconsistent numbers.

How It Works

The skill takes university name, report type, report period, and service company name, then expects most of the seven required Excel dimensions. process_data.py skips merged title rows, coerces numeric text, and aggregates metrics into report_data.json. generate_charts.py renders nine PNG charts from that JSON with matplotlib, so charts refresh when data changes. A Node.js script then reads the JSON and chart directory to generate an A4 Word report with 14 monthly chapters, 11 quarterly chapters, 9 semi-annual chapters, or 8 annual chapters. The output includes light-blue table headers, page headers and footers, body pagination, and a final chapter with auto-generated industry insights.

Boundaries

It fits scenarios where structured operational data already exists and a reporting document is needed quickly. If monthly filtered live-class data is empty, related sections and charts are skipped; the optional exam dimension is omitted when absent. Framework templates are for development and maintenance only; deliverables should use the data-filled report.