Executive Summary
Advances in computing, connectivity, multimedia, and miniaturization are rapidly increasing the impact of technology on student learning and administration. As a result, today's parents are insisting that their schools be equipped with the latest technology. ÿ Streamline and simplify record-keeping school-wideÿ Save time and money by avoiding duplicate data entryÿ Eliminate the need for separate systems for different departments
Edu.cybernetics is an integrated solution aimed to automate School administration. It integrates the following modules: -

a) Financial Accounts
b) Student Accounts
c) Staff Payrolls
d) Students Database
e) Employee Database
f) Examination System
g) Timetable

Financial Accounts: -

This module is based on Post Transaction Double Entry accounting system of accounts. The origin of all the entries is Payment, Receipt and Journal Vouchers and all the statutory statements such as Cash Book, General Ledger, Trial Balance, Copy of Accounts etc. are generated automatically from vouchers itself. To increase the overall effectivity of the solution, entries of Cash Receipts, Cash Payments, Bank Receipts and Bank Payments are designed as per Single Entry System, however posting is double entry based. This assures high efficiency rates from the user.

Various statutory statements designed exceptionally for this solution is as under: -

ü Cash Book
ü Journal Book
ü Cash Book cum Journal
ü Bank Book
ü Bank Reconciliation Statement
ü General Ledger
ü Copy of Accounts
ü Expenditure Analysis
ü Depreciation Chart
ü Income & Expenditure
ü Balance Sheet with Annexures

All the above statements can be generated automatically for any date. Thus, all that is required is: Ledger Account Heads and its corresponding Voucher Entries, everything else required will be automatically generated.

Students Accounts: -

Student Bills and Receipts form the origin of all the entries to Student Accounts. The Bills are raised against various charges viz. Admission Fee, Registration Fee, Contingency Deposit, Boarding Fee, Tuition Fee, Computer Fee and other charges. Fee is generated from the Fee Structure defined and approved by the School. Schedule for Student Bills are as under: -

1. First Bill is raised in the month of March, which includes 1 month Boarding Fee, 1 Month Tuition Fee and Admission, Registration and Contingency deposit.
2. Second bill is raised in the month of May, which includes 8 months Boarding Fee and 11 months Tuition Fee.
3. The Bills for the Other Charges will be raised at the end of all the Three Terms.

Bills are automatically posted to the Student Accounts. A Receipt is issued against fee received from the Student and a voucher is posted automatically to Fee Register and Student Account. At the end of the day, a Bank Deposit Slip will be generated for a Bank Transaction and voucher is posted to Financial Accounts. The Student Accounts generate following Reports: -

ü Statement or Copy of an account
ü Student Ledger
ü Trial Balance
ü Fee Computation and Fee Register
ü Bills
ü Receipts, Payments and Journals
ü Bank Deposit Slip
ü Other Miscellaneous queries

Employee Database and Payrolls

An Employee Master updates Employee Personnel Information, Qualification, Experience and Payroll constraints viz, Bank Account No, PAN No., DA %, PF % etc. This module then generates the Staff Salary based on above constraints and different allowances and deductions (if applicable) at the end of every month. The Pay Slips for every Employee will be generated and a List to Transfer the Funds to Employee Salary accounts will be generated for the bank. TDS will be deducted as per govt. norms against which TDS list will be generated. At the end of year, FORM 16 will be issued to employees and TDS Return will be generated as per the government requirements in electronic form. The key reports that will be generated by this module are as under: -

ü Pay Slips
ü Pay Register
ü Bank List
ü Salary Lists for Director’s reference

Students Database

Personal, Academic, Health, Co-curricular, Extra co-curricular information about the students since their admission is archived in the Students database. This means that progress of every student can be assessed electronically. Also, an ID Card will be generated along with a BAR CODE unique to a Student. This BAR CODE based ID Card can be further used for electronic identification purposes in various functions viz. Canteen, Library etc.

Examination System

The Examination System automates Progress Reports, Results, and Marks Register. Examination is conducted for 3 Terms. Marks List will be punched in to the Examination System Class-wise Subject-wise. A User Login and Password will be created for all Teachers. A teacher will login to the Examination system to enter Progress Report based on the Student History and Photograph. The Examination system will automatically generate Progress Reports as per prescribed Performa for KG, I-V, VI-VIII, IX-X Commerce, IX-X Science, XI-XII Commerce, XI-XII Science. Marks Register will be maintained automatically for all classes. Following are the Key Reports: -

ü Merit List
ü Marks Register
ü Progress Report

Time Table

Time-table is the most complex activity performed by a School. Timetable is realized Class-wise as well as Teacher-wise depending upon the various parameters: -
ü No. of Periods in a class
(8X5 + 5 Periods in a week for Junior School & 9X5 + 6 Periods for Senior School)
ü Maximum No. of Periods to be allocated per Week to a Teacher
ü List of Teachers
ü List of Subjects in Every Class
ü Different Subjects a Teacher Teaches
ü Other Preferences like Intensity of Subjects, Breaks to Teachers etc.

This utility will enable school to deduce a Time-table in just a few minutes.