student-database

Compute per-student grades from basic_info.txt files and generate CSV and summary outputs.

133|6|Updated Dec 8, 2025
One-click install
npx skills add https://github.com/MassLab-SII/open-agent-skills --skill student-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: student-database
Source: https://github.com/MassLab-SII/open-agent-skills/tree/main/portable-skills/student_database
Command: npx skills add https://github.com/MassLab-SII/open-agent-skills --skill student-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the processing of student databases by computing per-student grades, detecting duplicate names, and filtering records based on recommendations and TOEFL scores.

Core Features & Use Cases

  • Grade calculation: read basic_info.txts to compute chinese, math, and english grades and output student_grades.csv and grade_summary.txt.
  • Duplicate name detection: identify duplicate student names across folders and generate a namesake.txt with counts and IDs.
  • Filtering capabilities: filter students by recommendation grade or by TOEFL score to support admissions and reporting.
  • Use Case: A school administrator runs the tool against a student_database to generate a ready-to-share grade report and identify duplicate entries for cleanup.

Quick Start

Run the following commands to process a student database: python scripts/gradebased_score.py ./student_database --output-dir ./output python scripts/duplicate_name.py ./student_database --output ./namesake.txt python scripts/filter_by_recommendation.py ./student_database A python scripts/filter_by_toefl.py ./student_database 100

Frequently Asked Questions about student-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate student grades from a basic_info.txt file in batch?▼

To calculate student grades in batch, this Skill parses CSV-like basic_info.txt entries to compute Chinese, Math, and English scores, assigns letter grades, and generates a structured student_grades.csv and grade_summary.txt output.

What is the best way to detect duplicate student names across multiple folders?▼

Detecting duplicate student names across folders involves scanning the student database directories to identify matching entries, generating a namesake.txt file that lists the duplicate counts and corresponding student IDs for cleanup.

How do I filter student data by TOEFL scores for admissions reporting?▼

Filtering student data by TOEFL scores is handled by running a script against the student database with a specified score threshold, such as 100, to output records meeting the admissions criteria.

Can I filter a student database by recommendation grade?▼

Yes, you can filter a student database by recommendation grade by executing a filter script with a specified letter grade argument like A, which processes the records to output students matching that recommendation level.

What format should basic_info.txt entries follow for computing student grades?▼

The basic_info.txt entries should follow a CSV-like format containing the raw scores needed for the scripts to compute Chinese, Math, and English grades and accurately assign letter grades for the output files.