Hi Rohit I would read about moodle and school server XS so you at least know what has been used in the past. moodle can be used for managing teacher/student/parent access, curriculum management (into categories/courses, with competence frameworks and individual/group learning plans these days), has chat and messaging systems as well as forums (so you can do synchronous/asynchronous and individual or select groups), quizzes and assignments, glossaries and databases, attendance modules (face to face sessions can even email students a calendar booking), full grade management. There are loads of other features in moodle, and it is open source with a large community, not only in development but in teachers, administrators, and users. You can look at what olpc and sugar users have already done regarding library management. We put close to 300 books on the school servers that we put in to deployments, then just gave the kids a link to the directory of books from moodle front page. But if you want a complete library management system you could look at Koha integrated library system - it is open source, http://www.koha.org/ The deployments I went to did not have internet, so we also gave them a link to get other sugar activities from the front page of moodle on their school server, with a bunch of activities stored on their school server. Also some offline wikipedia pages. Much improved situation over no internet and no books in a school. http://wiki.laptop.org/go/XS_Server_Software http://wiki.laptop.org/go/School_server https://wiki.sugarlabs.org/go/School_Server These pages haven't been edited in a while, so not sure who is still active in the sugar community who knows about this. But, the School Server provides an Apache web server, the PostgreSQL database and Moodle as a Learning management system.
Kind regards Tabitha On 19 March 2017 at 12:27, Rohit Lodha <rohit.lodha...@gmail.com> wrote: > After going through a whole lot of articles, I have framed the following > database structure connecting primary needs of a school management system. > The portal can be made with Django and sqlite/postgres database with easy > integration with sugar. > > - 4 types of user - Admin,Teacher, Student, Parent ( With appropriate > database fields and permissions) > - Teacher, Student, Parents can register themselves on the System or > admin can create them > - Admin can accept any request. > - Teacher can accept student request which are in their class > - Parents will be added only if the student is registered > - Subject :- A database for adding/removing subject. ( With fields > like name, teachers, grading system) > - Teachers and Admin can register subjects > - each subject will have a no. of teachers assigned and a class > timing for each teacher is also set. > - each student is assigned a no. of subjects with specific > teacher.( Either student register themselves and await teacher's > confirmation or teacher registers students) > - Subject Material: - Teachers can upload grades, assignments, study > materials and can review each student performance in this portal.( Parents > can view their child's performance) > - Class Schedule:- Each subject teacher and a student will have a > class schedule attached to them. They can view upcoming classes for a > week/month. > - Attendance:- Each Class schedule have attendance database connected. > ( Date,Student,Present or not) > - A similar daily attendance feature for teachers. > - Student Promotion:- To promote a student to the new academic year. > - Fees Management:- Managing receipt and dues of students. > - Teachers Payroll :- Managing salary of teachers and budget of the > school. > > Different views that will be created for respective audience are- > > - A News Board:- where admin and teachers can update/notify students > and parents. > - A Calendar:- Showing Academic Schedule of the year. > - Exam List:- Date and Venue > > Apart from this, other features that can be added to this system > > - Online exam feature:- A portal for conducting and managing online > exams. > - Hostel Management > - Library Management > - Transport Management for Students. > - Chat feature > > All these features can be made to support multi curriculum//boards. > > -Rohit Lodha > Gitlab profile : https://gitlab.com/rtgdk > Github profile: https://github.com/rtgdk > > _______________________________________________ > Sugar-devel mailing list > Sugar-devel@lists.sugarlabs.org > http://lists.sugarlabs.org/listinfo/sugar-devel > >
_______________________________________________ Sugar-devel mailing list Sugar-devel@lists.sugarlabs.org http://lists.sugarlabs.org/listinfo/sugar-devel
