achievement-qztc
课程目标达成情况分析表生成工具。根据Excel学生数据替换Word模板中的课程目标达成情况,生成新的分析表。
Install / Use
npx skills add LeoYeAI/openclaw-master-skills --skill achievement-qztcInstalls into whichever agent you are using.
SKILL.md
Installable skill definition
Quality Score
Category
Content & MediaSupported Platforms
Our assessment of achievement-qztc
achievement-qztc scores 83/100 on our quality scale, 914th of 1,153 Content & Media skills we index.
Its SKILL.md is 17 KB long, well organised into 42 sections with 8 code examples: a thorough specification that gives an agent plenty to work with.
With 2,149 GitHub stars, it is one of the more widely adopted skills in the catalogue.
Maintenance, license and trust
- The repository was last updated about 4 months ago. That is recent enough to be usable, but agent tooling moves fast, so check the instructions against your agent's current version.
- Our last check on 2026-11-07 found the source still online.
- It is released under the MIT license, a permissive license that allows use, modification and commercial use with attribution.
- Its trust signals score 98/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.
Safety scan
No issues foundOur scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.
AI review by kimi-k2.7-code on 2026-10-01. Automated pattern scan on 2026-10-01. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.
achievement-qztc compared with similar skills
All 4 of these similar skills score higher than achievement-qztc; compare them before choosing.
| Skill | Score | Stars | Updated | Format |
|---|---|---|---|---|
| achievement-qztc (this skill)by LeoYeAI | 83 | 2.1k | 4mo ago | SKILL.md |
| Agent-Reachby Panniantong | 100 | 112.3k | 8d ago | CLAUDE.md |
| headroomby headroomlabs-ai | 100 | 79.8k | today | CLAUDE.md |
| Scraplingby D4Vinci | 100 | 103.6k | 2d ago | MCP Server |
| crawl4aiby unclecode | 100 | 87.4k | 3d ago | MCP Server |
Frequently asked questions
- How do I install achievement-qztc?
- Run
npx skills add LeoYeAI/openclaw-master-skills --skill achievement-qztc. The install tabs above show the steps for each supported agent. - Which AI agents does achievement-qztc work with?
- It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
- Is achievement-qztc safe to use?
- Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is MIT-licensed and scores 98/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
- Is achievement-qztc still maintained?
- The repository was last updated about 4 months ago. That is recent enough to be usable, but agent tooling moves fast, so check the instructions against your agent's current version.
Skill content
View source on GitHubname: achievement-qztc description: 课程目标达成情况分析表生成工具。根据Excel学生数据替换Word模板中的课程目标达成情况,生成新的分析表。
课程目标达成情况分析表生成工具(QZTC版)
根据Excel学生数据替换Word模板中的课程目标达成情况,生成新的分析表。
适用场景
- 根据Excel学生名单生成课程目标达成情况分析表
- 自动计算各课程目标的达成值(随机生成成绩,百分比表示)
文件路径
- 模板文件:
/Volumes/qztcm09/Desktop/temp/课程目标达成情况分析表-数据可视化-模版.docx - Excel数据:
/Volumes/qztcm09/Desktop/temp/数据可视化技术23级计算机.xls
使用步骤
步骤1:读取Excel数据
import pandas as pd
import shutil
import random
from docx import Document
from datetime import datetime
# 读取Excel
df = pd.read_excel('/Users/qztcm09/Desktop/temp/数据可视化技术23级计算机.xls')
# 排除旷考学生
df = df[df['备注'] != '旷考'].reset_index(drop=True)
# 自动判断当前学年和学期
now = datetime.now()
year = now.year
month = now.month
day= now.day
if 1 <= month <= 6:
# 1-6月:第一学期(上学年)
academic_year = f"{year-1} - {year}"
semester = "一"
else:
# 7-12月:第二学期(上学年)
academic_year = f"{year-1} - {year}"
semester = "二"
print(f"当前学年: {academic_year}, 学期: {semester}学期")
# 从"班级"字段提取年级、班级、专业信息
# 专业名称提取支持两种情况:
# 情况1: "23级计算机" → 年级=23, 专业=计算机
# 情况2: "23级软工2班" → 年级=23, 专业=软工
import re
class_name = df['班级'].iloc[0] if '班级' in df.columns else ''
match = re.search(r'(\d+)级', str(class_name))
grade = match.group(1) if match else '' # 如 "23"
# 提取专业:匹配 "XX级" 后面到 "XX班" 或结尾的部分
match = re.search(r'\d+级(.+?)(?:\d+班)?$', str(class_name))
major = match.group(1).strip() if match else '' # 如 "计算机" 或 "软工"
# 获取学生信息
students = df[['学号', '姓名']].copy()
print(f"学生人数: {len(students)}")
步骤2:复制模板并打开
template_path = '/Users/qztcm09/Desktop/temp/课程目标达成情况分析表-数据可视化-模版.docx'
output_path = '/Users/qztcm09/Desktop/temp/课程目标达成情况分析表-数据可视化-23级计算机.docx'
shutil.copy(template_path, output_path)
doc = Document(output_path)
步骤3:通用文本替换
⚠️ 重要:Word占位符可能被拆分成多个run,且表格单元格中可能有换行,需要特殊处理,保留原格式
def replace_text_preserve_format(para, replacements):
"""替换段落文本但保留格式"""
# 先收集所有run的文本
full_text = ''.join(run.text for run in para.runs if run.text)
# 检查是否有占位符
has_placeholder = any(old in full_text for old, _ in replacements)
if not has_placeholder:
return
# 执行替换
for old, new in replacements:
full_text = full_text.replace(old, new)
# 获取第一个run的格式作为基准
if para.runs:
first_run = para.runs[0]
font_name = first_run.font.name
font_size = first_run.font.size
font_bold = first_run.font.bold
font_italic = first_run.font.italic
else:
font_name, font_size, font_bold, font_italic = None, None, None, None
# 清空并用新文本创建单一run,保留格式
para.clear()
run = para.add_run(full_text)
if font_name:
run.font.name = font_name
if font_size:
run.font.size = font_size
if font_bold is not None:
run.font.bold = font_bold
if font_italic is not None:
run.font.italic = font_italic
return para
def replace_text_in_table_cell(cell, replacements):
"""替换表格单元格中的文本(处理单元格内换行的情况)"""
# 遍历单元格中的所有段落
for para in cell.paragraphs:
full_text = ''.join(run.text for run in para.runs if run.text)
has_placeholder = any(old in full_text for old, _ in replacements)
if has_placeholder:
# 获取格式
if para.runs:
first_run = para.runs[0]
font_name = first_run.font.name
font_size = first_run.font.size
font_bold = first_run.font.bold
font_italic = first_run.font.italic
else:
font_name, font_size, font_bold, font_italic = None, None, None, None
# 执行替换
for old, new in replacements:
full_text = full_text.replace(old, new)
# 清空并重新设置
para.clear()
run = para.add_run(full_text)
if font_name:
run.font.name = font_name
if font_size:
run.font.size = font_size
if font_bold is not None:
run.font.bold = font_bold
if font_italic is not None:
run.font.italic = font_italic
return cell
# 替换配置
replacements = [
('$acyear$', academic_year),
('$semester$', semester),
('$g$', grade),
('$major$', major),
('$total$', f'{len(students)}人'),
('$year$', str(year)),
('$month$', str(month)),
('$day$', str(day)),
]
# 替换表格中的文本
for table in doc.tables:
for row in table.rows:
for cell in row.cells:
replace_text_in_cell(cell, replacements)
# 替换段落中的文本(处理被拆分的情况,保留格式)
for para in doc.paragraphs:
replace_text_preserve_format(para, replacements)
步骤4:更新表8 - 课程目标个体达成情况明细
重要:
- 先清理除表头(2行)和最后一行(平均值)外的所有学生数据
- 根据Excel学生数动态调整表格行数
- 在最后一行(平均值行)之前插入新行
- 所有达成值用百分比表示(如 66%)
表格索引: 8
表头结构(前2行):
- 行0: 序号 | 学号 | 姓名 | 课程目标1(25分) | 课程目标1 | 课程目标2(30分) | 课程目标2 | 课程目标3(26.5分) | 课程目标3 | 课程目标4(18.5分) | 课程目标4
- 行1: 序号 | 学号 | 姓名 | 得分 | 达成值 | 得分 | 达成值 | 得分 | 达成值 | 得分 | 达成值
数据列对应关系: | 列索引 | 内容 | |--------|------| | 0 | 序号 | | 1 | 学号 | | 2 | 姓名 | | 3 | 随机值 a (10-24),课程目标1得分 | | 4 | a/25100%,课程目标1达成值(百分比) | | 5 | 随机值 b (20-28),课程目标2得分 | | 6 | b/30100%,课程目标2达成值(百分比) | | 7 | 随机值 c (20-25),课程目标3得分 | | 8 | c/26.5100%,课程目标3达成值(百分比) | | 9 | 随机值 d (15-18),课程目标4得分 | | 10 | d/18.5100%,课程目标4达成值(百分比) |
# 步骤4.1: 动态调整表格行数(在平均值行之前插入)
table = doc.tables[8]
current_rows = len(table.rows)
# 当前模板可以容纳的学生数(去掉2行表头和1行平均值)
template_capacity = current_rows - 3
# 调整行数:在倒数第2行(平均值行之前)插入
if len(students) > template_capacity:
# 需要插入行,在平均值行之前插入
for i in range(len(students) - template_capacity):
# 在倒数第2行之前插入(即平均值行之前)
new_row = table.add_row()
# 将新行移动到平均值行之前
# 由于add_row()是添加到末尾,需要交换位置
# 获取平均值行索引
avg_idx = len(table.rows) - 1
# 将新插入的行移到平均值行之前
table._element.remove(new_row._element)
table._element.insert(len(table.rows) - 2, new_row._element)
elif len(students) < template_capacity:
# 需要删除多余行(从数据区域末尾开始删,保留平均值行)
for i in range(template_capacity - len(students)):
# 删除倒数第2行(最后一个数据行)
delete_idx = 2 + len(students)
if delete_idx < len(table.rows) - 1:
table._element.remove(table.rows[delete_idx]._element)
# 步骤4.2: 清理数据行(保留前2行表头和最后1行平均值)
for row_idx in range(2, len(table.rows) - 1):
for cell in table.rows[row_idx].cells:
cell.text = ''
# 步骤4.3: 填入学生数据(达成值用百分比)
all_a, all_b, all_c, all_d = [], [], [], []
student_data = []
for i, (_, student) in enumerate(students.iterrows()):
row_idx = i + 2
if row_idx >= len(table.rows) - 1:
break
row = table.rows[row_idx]
a = random.randint(10, 24)
b = random.randint(20, 28)
c = random.randint(20, 25)
d = random.randint(15, 18)
all_a.append(a)
all_b.append(b)
all_c.append(c)
all_d.append(d)
# 转为百分比
v1, v2, v3, v4 = a/25*100, b/30*100, c/26.5*100, d/18.5*100
student_data.append({'v1': v1, 'v2': v2, 'v3': v3, 'v4': v4})
row.cells[0].text = str(i + 1)
row.cells[1].text = str(student['学号'])
row.cells[2].text = student['姓名']
row.cells[3].text = f"{a:.2f}"
row.cells[4].text = f"{v1:.0f}%" # 百分比
row.cells[5].text = f"{b:.2f}"
row.cells[6].text = f"{v2:.0f}%" # 百分比
row.cells[7].text = f"{c:.2f}"
row.cells[8].text = f"{v3:.0f}%" # 百分比
row.cells[9].text = f"{d:.2f}"
row.cells[10].text = f"{v4:.0f}%" # 百分比
n = len(student_data)
# 步骤4.4: 最后一行填写平均值(百分比)
avg_row = table.rows[-1]
avg_a = sum(all_a) / n
avg_b = sum(all_b) / n
avg_c = sum(all_c) / n
avg_d = sum(all_d) / n
avg_v1 = sum(s['v1'] for s in student_data) / n
avg_v2 = sum(s['v2'] for s in student_data) / n
avg_v3 = sum(s['v3'] for s in student_data) / n
avg_v4 = sum(s['v4'] for s in student_data) / n
avg_row.cells[0].text = "平均值"
avg_row.cells[3].text = f"{avg_a:.2f}"
avg_row.cells[4].text = f"{avg_v1:.0f}%"
avg_row.cells[5].text = f"{avg_b:.2f}"
avg_row.cells[6].text = f"{avg_v2:.0f}%"
avg_row.cells[7].text = f"{avg_c:.2f}"
avg_row.cells[8].text = f"{avg_v3:.0f}%"
avg_row.cells[9].text = f"{avg_d:.2f}"
avg_row.cells[10].text = f"{avg_v4:.0f}%"
步骤5:更新表7汇总数据(百分比)
table7 = doc.tables[7]
table7.rows[5].cells[7].text = f"{avg_v1:.0f}%"
table7.rows[8].cells[7].text = f"{avg_v2:.0f}%"
table7.rows[11].cells[7].text = f"{avg_v3:.0f}%"
table7.rows[14].cells[7].text = f"{avg_v4:.0f}%"
步骤6:更新课程目标分析段落(百分比)
# 计算统计数据
max_v1 = max(s['v1'] for s in student_data)
min_v1 = min(s['v1'] for s in student_data)
# ... 其他目标类似
# 计算满足百分比阈值的学生比例
count_v1_80 = sum(1 for s in student_data if s['v1'] >= 80)
count_v1_60 = sum(1 for s in student_data if s['v1'] >= 60)
# ... 其他类似
pct_v1_80 = count_v1_80 / n * 100
pct_v1_60 = count_v1_60 / n * 100
# ... 其他类似
# 更新段落
new_texts = {
1: f"课程目标1的平均达成值为{avg_v1:.0f}%,最高达成值为{max_v1:.0f}%,最低达成值为{min_v1:.0f}%。其中{pct_v1_80:.1f}%的学生达成值在80%以上,{pct_v1_60:.1f}%的学生达成值在60%以上,说明...",
# ... 其他目标
}
# 找到并更新段落
for i, para in enumerate(doc.paragraphs):
if '课程目标1的平均达成值为' in para.text:
# 更新段落文本
break
步骤7:保存
doc.save(output_path)
print(f"文件已保存至: {output_path}")
完整代码示例
import pandas as pd
import shutil
import random
from docx import Document
from datetime import datetime
random.seed(42) # 可选:固定随机种子
def replace_text_preserve_format(para, replacements):
"""替换段落文本但保留格式"""
# 先收集所有run的文本
full_text = ''.join(run.text for run in para.runs if run.text)
# 检查是否有占位符
has_placeholder = any(old in full_text for old, _ in replacements)
if not has_placeholder:
return
# 执行替换
for old, new in replacements:
full_text = full_text.replace(old, new)
# 获取第一个run的格式作为基准
if para.runs:
first_run = para.runs[0]
font_name = first_run.font.name
font_size = first_run.font.size
font_bold = first_run.font.bold
font_italic = first_run.font.italic
else:
font_name, font_size, font_bold, font_italic = None, None, None, None
# 清空并用新文本创建单一run,保留格式
para.clear()
run = para.add_run(full_text)
if font_name:
run.font.name = font_name
if font_size:
run.font.size = font_size
if font_bold is not None:
run.font.bold = font_bold
if font_italic is not None:
run.font.italic = font_italic
return para
def replace_text_in_table_cell(cell, replacements):
"""替换表格单元格中的文本(处理单元格内换行的情况)"""
for para in cell.paragraphs:
full_text = ''.join(run.text for run in para.runs if run.text)
has_placeholder = any(old in full_text for old, _ in replacements)
if has_placeholder:
if para.runs:
first_run = para.runs[0]
font_name = first_run.font.name
font_size = first_run.font.size
font_bold = first_run.font.bold
font_italic = first_run.font.italic
else:
font_name, font_size, font_bold, font_italic = None, None, None, None
for old, new in replacements:
full_text = full_text.replace(old, new)
para.clear()
run = para.add_run(full_text)
if font_name:
run.font.name = font_name
if font_size:
run.font.size = font_size
if font_bold is not None:
run.font.bold = font_bold
if font_italic is not None:
run.font.italic = font_italic
return cell
def generate_achievement_analysis():
# 1. 读取Excel
df = pd.read_excel('/Users/qztcm09/Desktop/temp/数据可视化技术23级计算机.xls')
df = df[df['备注'] != '旷考'].reset_index(drop=True)
students = df[['学号', '姓名']].copy()
print(f"学生人数: {len(students)}")
# 2. 复制模板
template_path = '/Users/qztcm09/Desktop/temp/课程目标达成情况分析表-数据可视化-模版.docx'
output_path = '/Users/qztcm09/Desktop/te
Truncated for display — read the full file on GitHub.
Related Skills
Agent-Reach
112.3kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
headroom
79.8kCompress tool outputs, logs, files, and RAG chunks before they reach the LLM. 20% fewer tokens for coding agents, 60-95% fewer tokens for JSON, same answers. Library, proxy, MCP server.
Scrapling
103.6k🕷️ The BEST Web Scraping framework that handles everything from a single request to a full-scale crawl! Don't be shy, join here: https://discord.gg/EMgGbDceNQ and follow here for daily tips and tricks: https://x.com/Scrapling_dev
crawl4ai
87.4kOfficial Crawl4AI Cloud: a hosted web scraping, extraction, and search API for AI agents. Free API key, 1,000 credits a month, no card. Fully open source: this repo is the Apache-2.0 crawler that powers it, and you can self-host it.
Languages
Trust signals
From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.
