Classes and students
Classes and sections, students and transfer certificates
Classes and sections sheet
Name (text, required), Class (the class or section it sits under), Class teacher (person), Room (text).
Classes and sections sit under each other, up to 8 levels deep; one with classes and sections under it can't be deleted.
Students sheet
Name (text, required), Admission number (text), Class (one row from Classes and sections, required), Section (one row from Classes and sections), Roll number (number), Date of birth (date, required), Gender (Girl, Boy or Other), Admitted on (date, today), House (Red, Blue, Green or Yellow), Left on (date), Father's name (text), Mother's name (text), Guardian's name (text), Phone (phone, required), Other phone (phone), Email (email), Address (long text), Nationality (text, Indian), Category (General, SC, ST, OBC or EWS), APAAR ID (text), PEN (UDISE+) (text), Aadhaar number (text), Birth certificate (file), Transfer certificate from the last school (file), Last school (text), Blood group (A+, A−, B+, B−, AB+, AB−, O+ or O−), Allergies (long text), Medical notes (long text), Emergency contact (text), Emergency phone (phone).
A student is added only when Section is empty or the Class of the Section is Class (The section is in the class).
The form: Basics (Name, Admission number, Class, Section, Roll number, Date of birth, Gender, Admitted on, House and Left on), Family (Father's name, Mother's name, Guardian's name, Phone, Other phone, Email and Address), Documents (Nationality, Category, APAAR ID, PEN (UDISE+), Aadhaar number, Birth certificate, Transfer certificate from the last school and Last school), Health (Blood group, Allergies, Medical notes, Emergency contact and Emergency phone). Asked when creating: Name, Class, Section, Date of birth and Phone.
Transfer certificates sheet
Student (one row from Students, required), Class last studied (one row from Classes and sections), Date of leaving (date, required), Reason for leaving (Family moving, Changing school, Completed school or Other, required), Qualified for promotion (Yes, No or Not yet decided), All dues paid (Yes or No), Working days this year (number), Days present (number), General conduct (Excellent, Very good, Good or Satisfactory), Certificate number (text), Issued on (date), Remarks (long text).
Steps
Requested → Issued or Cancelled
What happens by itself
When a student is added without a section, tell the office to give one, with an admission number.
A transfer certificate waits on the principal to issue it.
When a transfer certificate is issued, the student's Left on is its date of leaving.
Company rules that apply here
Every new student gets a fee card for the year.
Who can see and do what
Principal sees every class or section, add, edit and move them.
Office sees every class or section, add and edit them.
Accountant and Teachers see every class or section.
Class teachers see the students of their own classes and sections and can edit them.
Everyone sees every class or section.
Connections
People fills Class teacher.