achievement-qztc

What This Skill Does

The achievement-qztc skill is a specialized automation tool designed for academic administrators and instructors to streamline the generation of course target achievement analysis reports. By leveraging Python's powerful data processing ecosystem, this skill bridges the gap between raw student examination data (in Excel format) and formal institutional documentation (in Word format). It automatically parses student data, excludes specific subsets such as 'absent' students, calculates performance metrics based on defined course objectives, and injects these values into a pre-formatted Word document template. It handles common Word document formatting challenges—such as text being split across multiple XML runs—to ensure the generated reports maintain professional layout standards.

Installation

To integrate this skill into your environment, run the following command in your OpenClaw terminal: clawhub install openclaw/skills/skills/alukardo/achievement-qztc Ensure you have the necessary dependencies, including pandas, python-docx, and openpyxl, installed in your local Python environment to support data processing and document manipulation tasks.

Use Cases

• Automated Grading Reports: Ideal for educators who need to produce individual course target achievement tables for various classes each semester.
• Academic Reporting: Useful for department heads generating compliance documentation for curriculum audits and educational assessment records.
• Efficiency Gains: Drastically reduces manual data entry time by automating the extraction of academic years, semesters, and student majors from Excel spreadsheets, minimizing human error during document population.

Example Prompts

1. "Generate the course target achievement analysis report for the 23-level computer science class using the file located at /Volumes/qztcm09/Desktop/temp/数据可视化技术23级计算机.xls."
2. "Process the latest student exam data to fill the Word template and save the final report as a new file in my desktop temp folder."
3. "Automate the calculation of course objective achievement percentages for the current semester based on the class list provided in the Excel sheet."

Tips & Limitations

• Template Integrity: Ensure the Word template uses clear, distinct placeholders (e.g., {{variable_name}}) so the replacement logic can accurately locate where to inject data. Complex nested tables might require additional logic customization.
• Environment Paths: The skill currently relies on specific file paths. Ensure your source files are placed in the directories specified in the configuration, or modify the script to accept dynamic file paths.
• Data Formatting: The Excel file must contain columns labeled '学号', '姓名', '班级', and '备注' for the current script logic to function correctly. If your source files vary, adjust the column mapping in Step 1 of the skill code.