Google Sheets and App script based student management for coaching institute

[rahul101001000]

Google Sheets and App script based student management for coaching institutes

Context

Tuition teachers, coaching institutes, NGOs in the education space need to manage list of students enrolled, track collection of fees, track student and teacher attendance in classes among other things. Several commercial software options are available to do the same such as SchoolonApp, Fekara, Classe365, Fedena, MyClassCampus amongst others.

Small organizations who cannot afford these tools often rely on spreadsheets to do the same, albeit with manual intervention. Google Sheets, Google Forms and App script for custom programs are a powerful combination to achieve similar functionality.

Project

Create a Google Sheets, Forms and Apps Script based open source product that can help small organizations manage the end to end student lifecycle.

Milestones

• Define steps in the workflow for students and teachers
• Create schemas for teacher, student, fee payments, etc and store all data in different tabs in Google Sheets
• Use Google Forms to get data from teachers/students
• Use Apps Script to populate Google Forms drop down with data from spreadsheet. See tutorial for this
• Prefill data in Google Forms using this tutorial.
• Add more functionality to get this to at least 70% of commercial products listed above
• Package it as a Google Sheet Add on and list it on the Apps marketplace.