← Back to Skills Marketplace
157
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install manual-qztc
Description
仅供QZTC内部使用。教学工作手册生成工具 v5.3。Generator+Reviewer双模式，支持Pipeline一键生成+审查。
README (SKILL.md)
教学工作手册生成工具 v5.3
🎯 设计模式: Generator + Reviewer + Pipeline + Tool Wrapper 📁 代码文件:
manual_generator.py🔍 审查脚本:scripts/review_document.py📖 规则参考:references/grading-formula.md
🚀 快速开始
Pipeline 一键执行（推荐）
# 生成 + 审查
python3 manual_generator.py \x3CExcel文件> --pipeline
单独使用
# 生成
python3 manual_generator.py 数据可视化-23级计算机.xls
# 审查
python3 scripts/review_document.py 教学工作手册.docx
📁 目录结构
manual-qztc/
├── SKILL.md # 本文件
├── manual_generator.py # 主生成器（Generator模式）
├── scripts/
│ └── review_document.py # 质量审查（Reviewer模式）v1.0
└── references/
└── grading-formula.md # 工具规则（Tool Wrapper）
🔄 Pipeline 工作流
┌─────────────────────────────────────────────────────────────┐
│ STEP 1: 生成 (Generator) │
│ python3 manual_generator.py \x3CExcel> --pipeline │
│ ↓ │
│ ✅ CHECKPOINT 1: 文件生成成功？ │
│ ↓ │
│ STEP 2: 审查 (Reviewer) │
│ python3 scripts/review_document.py \x3C输出.docx> │
│ ↓ │
│ ✅ CHECKPOINT 2: 所有检查项通过？ │
│ ↓ │
│ STEP 3: 交付 │
└─────────────────────────────────────────────────────────────┘
🧪 测试数据
# C#程序设计（48学生，软工）
python3 manual_generator.py "~/Documents/QZTC/2026/C#程序设计-23级软工.xls" --pipeline
# 数据可视化（52学生，计算机）
python3 manual_generator.py "~/Documents/QZTC/2026/数据可视化-23级计算机.xls" --pipeline
📋 表格结构
作业表（学生作业登记表）
| 列 | 内容 |
|---|---|
| cells[0] | 学号 |
| cells[1] | 姓名 |
| cells[2-14] | 作业1-13（填√或空） |
成绩表（学生课程成绩登记表）
| 列 | 内容 |
|---|---|
| cells[0] | 学号 |
| cells[1] | 姓名 |
| cells[8] | 平时成绩 |
| cells[9] | 期中成绩 |
| cells[10] | 期末成绩 |
| cells[11] | 总评 |
分页
- 每表21行（1表头+20数据）
- 不足20学生时多余行留空
🔧 审查检查项
| 检查项 | 说明 |
|---|---|
| ✅ placeholders | 所有{*}占位符已替换 |
| ✅ homework_tables | 作业表结构正确 |
| ✅ grade_tables | 成绩表结构正确 |
📐 占位符规则
| 占位符 | 含义 | 示例 |
|---|---|---|
{as} |
学年 | 2025 - 2026 |
{ay} |
学年学期 | 2025-2026-2 |
{sm} |
学期 | 二 |
{g} |
年级 | 23 |
{mj} |
专业 | 软工 |
{g}{mj} |
复合 | 23软工 |
{tot} |
总人数 | 48 |
{v} |
平均成绩 | 78.5 |
{y} {m} {d} |
年/月/日 | 2026 / 4 / 9 |
{c} |
班号 | 1 |
📦 依赖
import pandas as pd
from docx import Document
🔄 更新日志
| 版本 | 日期 | 内容 |
|---|---|---|
| v5.1 | 2026-04-09 | 全面切换至{* }占位符格式 |
| v4.6 | 2026-03-28 | 文本替换格式、居中、分页 |
v5.1 - 2026-04-09 - Generator + Reviewer + Pipeline + Tool Wrapper
Usage Guidance
This skill appears to do what it says: generate and review teaching manuals from Excel templates. Before running it: (1) inspect the template directory it will use (defaults to ~/Documents/QZTC/教学文档模版) or supply a template you control; (2) only pass Excel files you trust (the scripts will read any file path you provide and write outputs next to those files); (3) note the script will create a config.env file in the skill's directory to store TEMPLATE_DIR — if you prefer, create that file yourself with TEMPLATE_DIR and OUTPUT_DIR entries; (4) ensure pandas and python-docx are installed in your Python environment. If you want extra assurance, run the scripts in an isolated environment (temporary VM or container) and review the full manual_generator.py file (the manifest shown was truncated in the listing) before processing sensitive data.
Capability Analysis
Type: OpenClaw Skill
Name: manual-qztc
Version: 5.3.0
The skill bundle is a specialized utility for generating academic teaching manuals from Excel data into Word templates for a specific institution (QZTC). The core logic in `manual_generator.py` and `scripts/review_document.py` uses standard libraries (pandas, python-docx) to perform document automation and quality checks. There are no indicators of data exfiltration, malicious execution, or persistence. While there is a functional inconsistency where the reviewer script looks for '$' placeholders while the generator uses '{}' (likely a versioning bug as noted in the SKILL.md update log), there is no evidence of intentional harm or prompt injection.
Capability Assessment
Purpose & Capability
Name/description (教学工作手册生成与审查) match the included Python code: manual_generator.py produces Word docs from Excel and scripts/review_document.py validates them. No unrelated binaries, env vars, or services are required.
Instruction Scope
SKILL.md instructs running the included scripts on local Excel and docx files, which is appropriate. The code reads user-supplied Excel and template files and writes an output .docx and may create a local config.env in the skill directory. This file I/O is expected for the stated purpose, but be aware the scripts will access any file paths you supply and will write output files to the same directory as the input Excel.
Install Mechanism
No install spec; the skill is instruction-only with bundled Python scripts. No network downloads or external package installation are performed by the skill itself. It depends on standard Python libraries plus pandas and python-docx (not installed by the skill).
Credentials
The skill declares no required environment variables, credentials, or config paths. The code does create/modify a local config.env in the skill/script directory to store TEMPLATE_DIR by default — this is local and proportional to template lookup functionality.
Persistence & Privilege
always:false and normal autonomous invocation settings. The only persistent action is creating a config.env file in the skill's directory if missing (config_loader.py). That is limited in scope and does not modify other skills or system-wide settings.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install manual-qztc - After installation, invoke the skill by name or use
/manual-qztc - Provide required inputs per the skill's parameter spec and get structured output
Version History
v5.3.0
description添加'仅供QZTC内部使用'，版本升至v5.3
v5.2.0
v5.2.0: 修复get_template_dir() expanduser bug；添加.clawhubignore忽略config.env；路径~/替代硬编码；Table13成绩分段统计及{ok}及格率占位符
Metadata
Frequently Asked Questions
What is Manual Qztc?
仅供QZTC内部使用。教学工作手册生成工具 v5.3。Generator+Reviewer双模式，支持Pipeline一键生成+审查。 It is an AI Agent Skill for Claude Code / OpenClaw, with 157 downloads so far.
How do I install Manual Qztc?
Run "/install manual-qztc" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Manual Qztc free?
Yes, Manual Qztc is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Manual Qztc support?
Manual Qztc is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Manual Qztc?
It is built and maintained by 林捷 (@alukardo); the current version is v5.3.0.
More Skills