1. Understand the Request

• 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.