student-database

Student Database Skill

This skill provides tools for processing student database:

1. Grade calculation: Calculate student grades from scores
2. Duplicate name finder: Find duplicate names in database
3. Filter by recommendation: Find students by recommendation grade
4. Filter by TOEFL: Find students by TOEFL score threshold

Important Notes

• Do not use other bash commands: Do not attempt to use general bash commands or shell operations like cat, ls.
• Use relative paths: Use paths relative to the working directory (e.g., ./student_database).

---

I. Skills

1. Grade-Based Score

Calculate student grades from student database and generate output files.

Features

• Read all basic_info.txt files from student folders
• Extract chinese, math, english scores
• Calculate grades: A(90+), B(80-89), C(70-79), D(60-69), F(<60)
• Generate student_grades.csv and grade_summary.txt

Example

python gradebased_score.py ./student_database

# Specify output directory
python gradebased_score.py ./student_database --output-dir ./output

Output Files

1. student_grades.csv: student_id, name, chinese_score, chinese_grade, math_score, math_grade, english_score, english_grade
2. grade_summary.txt: Total students, A/B/C/D/F counts per subject, pass/fail counts

---

2. Duplicate Name Finder

Find duplicate names in student database.

Features

• Scan all student folders
• Extract names from basic_info.txt
• Identify names that appear more than once
• Generate namesake.txt

Example

python duplicate_name.py ./student_database

# Specify output file
python duplicate_name.py ./student_database --output ./namesake.txt

Output Format

name: xxx
count: xxx
ids: xxx, xxx, ...

name: yyy
count: yyy
ids: yyy, yyy, ...

---

3. Filter by Recommendation Grade

Find students with specified grade(s) from recommendation_letter.txt files.

Features

• Filter by single grade (S, A, B, C, D, F) or multiple grades (e.g., SA for S or A)
• Returns list of matching student folder names