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.