AgentSkillsCN

course-schedule-analyzer

当用户需要从大学课程表（通常为PDF格式）中，根据课程名称、课程类型、上课时间、考试形式以及校区位置等多个条件筛选并选择课程时，此技能会从PDF课程表中提取课程信息，按名称或类别搜索特定课程，根据星期几、考试类型（开卷/闭卷）以及时间段等约束条件筛选结果，检查课程安排是否存在冲突，并以Excel文件等结构化格式输出整理后的课程选择方案。

SKILL.md
--- frontmatter
name: course-schedule-analyzer
description: When the user needs to find and select courses from a university schedule (typically in PDF format) based on multiple criteria including course names, course types, class times, exam formats, and campus locations. This skill extracts course information from PDF schedules, searches for specific courses by name or category, filters results based on constraints like day of week, exam type (open-book/closed-book), and time slots, checks for scheduling conflicts, and outputs organized course selection options in structured formats like Excel files.

Instructions

1. Understand the Request

  • •Identify the user's required courses, categories, and constraints.
  • •Key constraints often include:
    • •Specific course names (e.g., "自然语言处理", "软件体系结构").
    • •Course categories (e.g., "思政B", "通识教育核心课程").
    • •Day of week (e.g., "Monday").
    • •Exam type (e.g., "开卷" for open-book).
    • •Campus location.
    • •Output format (e.g., Excel files with specific headers).
  • •Clarify if multiple valid options should be saved as separate files.

2. Locate and Inspect Reference Files

  • •List the workspace directory to find the schedule PDF and any reference files (e.g., reference_format.xlsx).
  • •Read the reference format file to understand the required output structure (headers, data format).
  • •Inspect the PDF file to understand its structure (total pages, layout).

3. Extract and Search Course Data

  • •Use PDF search functions to locate specific courses by name or category.
  • •For each required course/category, perform targeted searches.
  • •Extract detailed information by reading relevant page ranges.
  • •Parse the extracted text to identify:
    • •Course ID
    • •Course name
    • •Instructor
    • •Campus
    • •Class time (day and periods)
    • •Enrollment limit
    • •Credits
    • •Assessment method (e.g., "闭卷", "开卷", "论文")
    • •Exam time
    • •Course selection restrictions

4. Apply Filters and Check Constraints

  • •Filter courses based on:
    • •Day of week (e.g., Monday courses only).
    • •Exam type (e.g., only "开卷" exams).
    • •Other user-specified constraints.
  • •For courses with multiple sections, identify all valid options.
  • •Check for time conflicts between fixed required courses.
  • •Ensure selected courses do not overlap in schedule.

5. Generate Course Selection Schemes

  • •Combine fixed required courses with optional courses that meet all constraints.
  • •For each valid combination, create a distinct selection scheme.
  • •Structure the data according to the reference format.
  • •Ensure values are in Chinese while headers remain in English.

6. Create Output Files

  • •For each selection scheme, create a separate Excel file.
  • •Use a programmatic approach (e.g., Python with openpyxl) to generate files efficiently.
  • •Save files with clear naming (e.g., course_selection_scheme_1.xlsx).
  • •Clean up the workspace by removing temporary or reference files if requested.

7. Verify and Summarize

  • •Verify the content of generated files matches the expected format.
  • •Provide a clear summary to the user listing:
    • •The fixed courses included in all schemes.
    • •The variable options for each scheme.
    • •File names and locations.