LMS-Gradescope Roster Sync Tool

Automatically sync student rosters between LMS and Gradescope/Ed Discussion platforms.

🚀 Quick Start

1. Install requirements:

   pip install pandas openpyxl

2. Place input files in the same directory:

   • LMS Excel file (rename to match script): sample_lms_roster.xlsx
   • Gradescope CSV file (rename to match script): sample_gradescope_roster.csv

3. Run the script:

   python process_roster.py

📄 Output Files

The tool generates 4 files:

1. ed_discussion_invites.txt - Ed Discussion invitation list
2. gradescope_invites.csv - Gradescope invitation list (Full Name, Email, SID)
3. students_to_remove.csv - Students to remove from platforms
4. invalid_email_students.csv - Students with email errors (manual review needed)

💡 How It Works

• Compares email addresses between LMS and Gradescope
• Finds students to add (in LMS but not in Gradescope)
• Finds students to remove (in Gradescope but not in LMS)
• Validates GIST email domains only (@gm.gist.ac.kr, @gist.ac.kr)

⚠️ Important Notes

• Uses email addresses as primary identifier
• Only processes valid GIST domain emails
• Always backup your rosters before making changes