I’ve been looking at the documentation, and also the training day presentations, to decide if the system will allow me reflect/configure my particular scenario.
But as it is a very comprehensive and complex system, and also there are some concepts or at least nomenclature that may differ from what I’m used to, there are some items I’m not able to understand clearly.
So, I would like to ask someone with more experience in the system to please help me determine if Gibbon will be a good fit for my needs.
Below I will make a detailed description of what I need to achieve in the school, starting with the School structure, and following with things that might be specific to this scenario, information that needs to flow in and out of the application, and a couple of more things.
I will really appreciate some advice or opinions on this!!
Might be from the Team members, or from experienced users of the application.
Thank you very much!!!
The school structure is as follows:
• The school has a pool of subjects. Each subject is defined by its topic and contents and will be given on different days and hours
(I will call these, Classes, that is, different instances of the subject )
• The Classes might be taken individually or grouped in Programs, like for example General Program, Math Program or Music
Program, which will include a selected group of subjects and Classes
• A Class is an individual instance of a subject, having
o A particular subject
o An opening and closing dates
o A schedule (day of the week/time)
o A teacher
o A classroom
• Each subject might have different Classes running simultaneously throughout the year
o They will differ from each other in the schedule, the teacher, the students, etc.
• Depending on the Program the subjects may or may not be graded. (some students might be interested in taking the class only for learning purposes, but might not be interested in taking exams)
Things that need to be considered:
o A student might stop attending a Class
o The teacher for a particular Class might change (temporarily or permanently)
o The schedule of the class might change
o The room of the class might change
o All the changes above must be registered as historical states of that Class, the teacher, and the student.
In this way you will keep a current state and historical record of the Class, the teacher activity, and the student activity
o Inside a Program, some subjects may appear in several years, and others may exist only for some years of the whole duration of that Program.
o Some students in a Program may take all the subjects that belong to Year 1 of a Program, but some others will take only some of
subjects one year and take the rest in the following calendar year.
o A teacher has a certain availability and assigned Classes
Things that need to be queried easily from the system
o The current status of a Class (teacher, students, schedule, room, etc )
o The current status of a teacher (what Classes is the teacher giving, including all the details like schedules, rooms, students, etc.)
o Teacher availability, given its general availability and the Classes the teacher is currently giving.
o The same as above for students, rooms, etc.
o In the case of students, the query should be able to also return the student activity, like attendance, exam grades, etc.
o What is taking place on a particular room in a particular date and time
o Where a particular student is, at a given moment
o What rooms are available at a given moment.
o A picture of the activity in the whole school at a given date/time (for example to be able to have a quick look at what is taking place in the whole school right now)
Reporting (mostly statistical information)
o Student’s attendance
o Teacher’s attendance
o Alerts when a student accumulates more than N consecutive unattendances
o Students by different criteria (from their personal and curricular data)
o Classes by different criteria (like how many classes on a particular subject, or how many clases with a particular instrument, in
case of a Music Class)
o Room occupancy
o Ad-hoc querying. This is, being able to write an SQL query against the Database and be able to return the results in a report that
could be shown in a screen of the system. Or, define a report with particular filters and conditions though a GUI of the system,
and display results on screen, and perhaps be able to download the results to an Excel file or csv.
o Economic activity, like expenses and student payments
Students activity report
Invoices (if it is a paid Program)
To welcome enrolling students
To notify teacher of new Classes they’ve bee assigned to
Generic notifications to students, teachers, and staff
o Invoice amount calculation and printing (for students who are taking one or more paid Classes)
Examples of Programs:
General Program : (this is like a regular school)
On a yearly basis with several assorted subjects per year.
Year 1: Math 101, Music 101, History 101
Year 2: Math 201, Music 201, Geography 101
Year 6 …
Music Program:(only Music subjects)
- On a yearly basis with one or more music related Classes per year.
Year 1: Music Theory 101, Guitar 101
Year 2: Music Theory 201, Guitar 101 , Harmony 101
Standalone Program: (this is a student taking only one Class on any subject)