Use when validating student club credit application Excel files for BP Debate Union. Validates both the member submission list and individual certification forms against school requirements. Examples: "validate credit application files", "check if this student qualifies for 1 credit"
Validates student credit application Excel files for BP Debate Union. Checks two file types against school eligibility rules and format requirements. Proposes fixes for problems found.
See references/eligibility_rules.md for full details.
| Student Type | Activities Required | Hours Required | Credits |
|---|
| 本科 (Undergrad) | 36 | 90 | 1 |
| 专科 0.5 credit | 8 | 16 | 0.5 |
| 专科 1 credit | 16 | 32 | 1 |
Activity counts can combine across: 1 club, 2 clubs, club+dissolved club, etc.
| Column | Requirement |
|---|---|
| 序号 | Required — sequential row numbers |
| 姓名 | Required — no blanks |
| 班级 | Required — no blanks |
| 联系方式 | Required — phone number, 7+ digits, no blanks |
| Column | Requirement |
|---|---|
| 姓名 | Required — no blanks |
| 班级 | Required — no blanks |
| 学号 | Required — no blanks |
| 联系方式 | Required — phone, 7+ digits |
| 学分数量 | Must be exactly 0.5 or 1 |
| 备注 | Must contain BP Debate Union |
| 活动认证情况 | Must be blank (school fills this upon approval) |
BP_Debate_Union_社团学分认证材料上交名单.xlsx24级BP_Debate_Union_学分申请认证表_姓名.xlsxFile formats: .xlsx (Excel), .xls (legacy Excel)
Script: scripts/validate_credit_app.py
python scripts/validate_credit_app.py "path/to/file.xlsx"
Checks performed:
isna() or blank string on all required columnsBP Debate UnionAgent double-check policy:
read_excel) and verify each result. The subagent should report findings without running the validation script. The main agent then synthesizes both results.Email: [email protected] Subject: BP Debate Union 学分认证材料 Hard Copy: 博闻楼B-109 Deadline: Check school announcement (typically within 48h of notice)